FINANCE-Otter must decide whether to replace a 10 year-old packing machine

QUESTION

Otter must decide whether to replace a 10 year-old packing machine with a new one that costs$153,800. Replacing the old machine will increase net operating income(excluding depreciation) from$70,000 to $110,000 and it will decrease net working capital by $18,000. The new machine falls into MACRS 5-year class. If the new machine is purchased, it will be sold in 6 years for $25,000, whereas, if the old machine is kept, it will have no salvage value in 6 years. The old machine has a current market value of $10,860 and although its current book value is $8,000, in one year the old machine’s book value will be zero ($0). The firm’s marginal tax rate is 40% and its required rate of return is 12%. Should the new packing machine be purchased? Explain. Depreciation NEW OLDYear 1 -$22,760 $ 8,000Year 2 – $49,216 $ 0Year 3 – $29,222 $ 0Year 4 – $18,456 $ 0Year 5 – $ 16,918 $ 0Year 6 – $9,228 $ 0Is there a way to make a balance sheet to solve this? I was looking at examples and that seems to be what they are looking for?

ANSWER:

REQUEST HELP FROM A TUTOR