Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The red cells are what I need help with, thanks! = 4 Discount rate: Tax Rate: Equipment Replacement Analysis enter revenues & inflows as positive
The red cells are what I need help with, thanks!
= 4 Discount rate: Tax Rate: Equipment Replacement Analysis enter revenues & inflows as positive numbers, expenses & outflows as negative numbers round only where instructed to do so investment years of equipment usage t= = = = 9.4% Part 1: Before replacement 0 I 1 I 2 | 3 | 20.0% Sales Revenue 2,500 2,500 2,500 After Before Expenses other than Depreciation (1.125) (1,125) (1,125) 2,500 2,500 Depreciation (200) (200) (200) 500 1,125 EBIT 1,175 1.175 1.175 2,000 1,600 EBIT After Taxes** 940 940 940 Add back: Depreciation 200 200 200 below 200 Free Cash Flow (Before) 0 1,140 1,140 1,140 Sales Revenue (constant) Expenses other than Depreciation Cost of equipment Expected life of equipment Depreciation (straight line) 2,500 (1,125) (200) 1.175 940 200 1.140 8 Part 2: After replacement Disposal of Old Equipment: see handout Old equipment was depreciated on a straight-line basis (2,000) 510 58 Age of old equipment: 4 Accum. Deprec. On old equip 800 Net Book Value of old equip: 800 Proceeds of sale: 510 Gain/ (LOSS) (290) Tax on Gain (Loss)* round to S *Tax OUTFLOW if Gain *Tax INFLOW if loss ** EBIT * (1-tax rate) *** difference between FCF before new equip, and FCF after Net cost of new Equipment Sale of old equipment Tax on Gain / Loss: Sales Revenue Expenses other than Depreciation Depreciation EBIT EBIT After Taxes Add back: Depreciation Free Cash Flow (After) 2,500 (500) (333) 1,667 1,333 333 1,667 2,500 (500) (333) 1,667 1,333 333 1,667 2,500 (500) (333) 1,667 1,333 333 1,667 2,500 (500) (333) 1,667 1,333 333 1,667 58 (1,432) Part 3: Incremental*** cash flows | (1,432)| 527 527 | 527 527 after-before PV of Incremental Cash Flows: Cumulative Cash for Payback: Cumulative PV for Disc. Payback: 481 527 481 440 1,053 402 1,580 1,324 368 2,107 1,691 921Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
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