Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HI I need help learning how to solve this equation step by step in excel. Please help! Thank you!! A firm is considering an investment

HI I need help learning how to solve this equation step by step in excel. Please help! Thank you!!

image text in transcribed
A firm is considering an investment in a new machine with a price of $15.7 million to replace its existing machine. The current machine has a book value of $5.5 million and a market value of $4.2 million. The new machine is expected to have a 4year life, and the old machine has four years left in which it can be used. If the rm replaces the old machine with the new machine, it expects to save $6.35 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 $260,000 in net working capital. The required return on the investment is 9 percent and the tax rate is 21 percent. The company uses straight-line depreciation. What is the NPV of the decision to purchase a new machine? (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89.) What is the IRR of the decision to purchase a new machine? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 3236) What is the NPV of the decision to purchase the old machine? (A negative amount should be indicated by a minus sign. Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89.) What is the IRR of the decision to purchase the old machine? (A negative amount should be indicated by a minus sign. Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) New machine NPV New machine IRR

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investing In Financial Research A Decision Making System For Better Results

Authors: Cheryl Strauss Einhorn, Tony Blair

1st Edition

1501732757, 9781501732751

More Books

Students also viewed these Finance questions

Question

6. How can hidden knowledge guide our actions?

Answered: 1 week ago