# A firm is considering an investment in a new machine with a price of \$16.9 million to replace its existing machine. The current machine has a book value of \$6.6 million and a market value of \$5.3 million. The new machine is expected to have a 4-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save \$6.9 million in operating costs each year over the next four years. Both machines will have no salvage value in four years. If the firm purchases the new machine, it will also need an investment of \$370,000 in net working capital. The required return on the investment is 12 percent and the tax rate is 22 percent. The company uses straight-line depreciation.     What is the NPV of the decision to purchase a new machine? I am having a lot of truoble setting this problem up in Excel and cannot figure it out?  Year 0 CF? Year 1 CF? How to do the NPV?  Both new and old machines? Same for IRR

Question
150 views
 A firm is considering an investment in a new machine with a price of \$16.9 million to replace its existing machine. The current machine has a book value of \$6.6 million and a market value of \$5.3 million. The new machine is expected to have a 4-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save \$6.9 million in operating costs each year over the next four years. Both machines will have no salvage value in four years. If the firm purchases the new machine, it will also need an investment of \$370,000 in net working capital. The required return on the investment is 12 percent and the tax rate is 22 percent. The company uses straight-line depreciation.

 What is the NPV of the decision to purchase a new machine?

I am having a lot of truoble setting this problem up in Excel and cannot figure it out?  Year 0 CF? Year 1 CF? How to do the NPV?  Both new and old machines? Same for IRR

check_circle

Step 1

Calculation of NPV and IRR of the New Machine:

Step 2

Excel Workings:

Step 3

Calculation of NPV and IRR of the Old Machine:

...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in