Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you solve this on excel and show me how A firm is considering an investment in a new machine with a price of $

can you solve this on excel and show me how
A firm is considering an investment in a new machine with a price of $15.9 million to
replace its existing machine. The current machine has a book value of $5.7 million and a
market value of $4.4 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.45 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 $280,000 in net
working capital. The required return on the investment is 11 percent and the tax rate is 23
percent. The company uses straight-line depreciation.
a. 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 of dollars,
rounded to 2 decimal places, e.g.,1,234,567.89.)
b. 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.,32.16.)
c. 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 of dollars, rounded to 2 decimal places,
e.g.,1,234,567.89.)
d. 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.)
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions