Excel problem E2) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of
Excel problem E2) 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 firms 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? b) What incremental operating cash flows will occur at the end of Years 1 through 5 as a result of replacing the old machine? c) 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 5-Year 7-Year 10-Year 1 33% 20% 14% 10% 2 45 32 25 18 3 15 19 17 14 4 7 12 13 12 5 11 9 9 6 6 9 7 7 9 7 8 4 7 9 7 10 6 11 3 100% 100% 100% 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started