Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

please use excel to answer the questions and show all outputs E3) The Erley Equipment Company purchased a machine 5 years ago at a cost

please use excel to answer the questions and show all outputs image text in transcribed
E3) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight line method toward a salvage value of $10,000, or by $9,000 per year. A new machine can be purchased for $150,000, including installation costs. During its 5-year life, it will reduce operating expenses by $50,000 per year. Sales are not expected to change. At the end of its useful life, the 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. The old machine can be sold today for $65,000. The firm's tax rate is 35%. The appropriate discount rate is 16%. (The MACRS recovery allowance percentages are specified in the formula sheet as well as at the end of the homework.) a) If the new machine is purchased, what is the amount of the initial cash flow at Year 0? What incremental operating cash flows will occur at the end of Years 1 through 5 as a result of replacing the old machine? What incremental non-operating cash flow will occur at the end of Year 5 if the new machine is purchased? d) What is the NPV of this project? Should Erley replace the old machine? MACRS - Recovery Allowance Percentage for Property Class of Investment Year 3-Year 7-Year 5-Year 20% 10-Year 10% 33% 14% 32

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