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
Asked May 27, 2019
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

Expert Answer

Step 1

Calculation of NPV and IRR of the New Machine:

fullscreen
Step 2

Excel Workings:

fullscreen
Step 3

Calculation of NPV and IRR of the Old Machine:

...
fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Business

Finance

Related Finance Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Explain horizontal and vertical analysis and when you would use one over the other.

A: While assessing financial performance of a company, we can\\'t just look at the company\\'s financia...

question_answer

Q: Suppose you wish to invest in an annuity so that you will have $120,000 at some future date for your...

A: We invest $350 monthly at a interest rate of 5.85% per month in order to give the child $120,000 at ...

question_answer

Q: What finances do you need to have to achieve getting somewhere with Cosmetology?  For instance to bu...

A: Some essential costs that are needed to be assessed before building a salon are:Cosmetics: A salon h...

question_answer

Q: Given relatively stable financial market conditions, determine which one of the followingbonds would...

A: The bonds that would exhibit the least price volatility is “5-year, 10% coupon bond”.

question_answer

Q: A company is going public with an offering price of $10 per share. The gross spread is 7 percent. Ho...

A: Offer price, P = $ 10 per shareGross spread, S  = 7%Portion received by the bank = P x S = $ 10 / sh...

question_answer

Q: A store will give you a 4.00% discount on the cost of your purchase if you pay cash today. Otherwise...

A: Let's assume the cost of purchase is C. On immediate payment,Discount = 4%Hence, the discounted cost...

question_answer

Q: Walter is investing $5,000in an account paying 6.75 percent annually for three years. What is the in...

A: Principal invested, P = $ 5,000Interest rate, R = 6.75%Time, T = 3 yearsAs a first step, we will fin...

question_answer

Q: Why might an investor-owned firm choose to issue different classes of common stock?

A: An investor owned firm issues different classes of common stock mainly due to the difference in voti...

question_answer

Q: Divided Walls Construction (DWC) has determined that the yield to maturity (YTM) on new bonds is 5 p...

A: a)Calculation of Weighted Average Cost of Capital if new stock is not issued: