Question: ( Please Answer using excel and showing formulas ) Thank You! The Everly Equipment Company's flange - lipping machine was purchased 5 years ago for

(Please Answer using excel and showing formulas) Thank You!
The Everly Equipment Company's flange-lipping machine was purchased 5 years ago for $75,000. It had an expected life of 10 years when it was bought and its remaining depreciation is $7,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 $130,000, including installation costs. During its 5-year life, it will reduce cash operating expenses by $35,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 $45,000. The firm's tax rate is 35%, and the appropriate cost of capital is 16%.
If the new flange-lipper is purchased, what is the amount of the initial cash flow at Year 0? Round your answer to the nearest dollar. Cash outflow, if any, should be indicated by a minus sign.
$
he NPV of this project? Do not round intermediate calculations. Round your answer to the nearest whole dollar. Negative value, if any, should be indicated by a minus sign.
$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!