Suppose you are thinking to replace an old machine with a new one for your business. The old machine cost you $100,000, and the new one costs $150,000. The new machine will be depreciated on a three-year MACRS basis. The new machine has a 5-year life and a salvage value of zero at the end of this period.

The old machine was purchased 5 years ago, and it is being depreciated at the rate of $9,000 per year. Its book value is $55,000, and its salvage value today is $65,000. You estimate that you will be able to sell the old machine for $10,000 in 5 years, if you decide to not replace it.

The new machine will save you $50,000 per year. The tax rate is 40%, and the required rate of return is 10%. Based on the NPV and IRR investment criteria, should you replace the old machine?

Should the cost of the old machine be included in your decision? Why or why not?

Calculate the Initial Investment of the project, and the Terminal Cash Flow of the project.

Calculate the Operating Cash Flow (OCF) for each year of the project. Remember to calculate the EBIT and the net income from the project for each year of the project. Show each item that goes into the OCF on its own row.

Calculate the Cash Flow From Assets (CFFA) for each year of the project.

Calculate the projects NPV (NOTE: Make sure to use the NPV function in Excel correctly).

State whether you should replace the old machine based on NPV.

Explain why you decide to replace or not based on NPV. In other words, what does it mean for the NPV to be positive or negative (whichever you calculated)?

Calculate the projects IRR (use the Excel IRR function). Based on IRR, should you replace the old machine with the new machine?

State whether you should replace the old machine based on IRR.

Explain why you decide to replace or not based on IRR (i.e., what does IRR measure)?

Cite one reason why either NPV or IRR are better for evaluating projects than Payback Period.

Old machine data Initial cost Annual depreciation Purchased Book value Salvage value today Salvage value in 5 years $100,000 $9,000 5 years ago $55,000 $65.000 $10,000 New machine data $150,000 Initial cost 3yr MACRS 33.33% 7.41% 44.44% 14.82% 5-year life Salvage value in 5 years $0 $50,000 Cost savings per year Required return 0.1 Tax rate Year 2 Year 1 Year 3 50,000.00 s 50,000.00 s 50,000.00 S 50,000.00 s 50,000.00 Cost Savings Depreciation New Is 9,000.00 s 9,000.00 s 9,000.00 s 9,000.00 s 9,000.00 Depreciation Old Year Year o Year 1 Year 4 Year 2 Year 3 Change in NWC Year 5