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
|
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 |
|
What is the |
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
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
