Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please kindly answer this question using Microsoft excel. Please show the embedded formulas in each cell. Thank you! Calculate the project's expected NPV, its standard

please kindly answer this question using Microsoft excel. Please show the embedded formulas in each cell. Thank you! image text in transcribed
Calculate the project's expected NPV, its standard deviation, and its coefficient of variation. Would you recommend that the project be accepted? The Everly Equipment Company's flange-lipping machine was purchased 5 years ago for $55,000. It had an expected life of 10 years when it was bought, and its remaining depreciation is $5,500 per year for each year of its remaining life. As older flange-lippers are robust and useful machines, this one can be sold for $20,000 at the end of its useful life. A new high-efficiency, digital-controlled flange-lipper can be purchased for $120,000, including installation costs. During its 5 -year life, it will reduce cash operating expenses by $30,000 per year, although it will not affect sales. At the end of its useful life, the high-efficiency machine is estimated to be worthless. MACRS depreciation will be used, and the machine will be depreciated over its 3-year class life rather than its 5-year economic life, so the applicable depreciation rates are 33.33%,44.45%,14.81%, and 7.41%. The old machine can be sold today for $35,000. The firm's tax rate is 25%, and the appropriate cost of capital is 16%. a. If the new flange-lipper is purchased, what is the amount of the initial cash flow at Year 0? b. What are the incremental cash flows that will occur at the end of Years 1 through 5? c. What is the NPV of this project? Should Everly replace the flange-lipper

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

More Books

Students also viewed these Finance questions