Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need everything in shaded area with formulas plese, there is no other spread sheet. as, please investment t= 0 t= 1 years of equipment usage
Need everything in shaded area with formulas plese, there is no other spread sheet.as, please
investment t= 0 t= 1 years of equipment usage t= 2 3 t= 4 Discount rate: Tax Rate: 8.7% 22.0% Part 1: Before replacement Sales Revenue (constant) Expenses other than Depreciation Cost of equipment Expected life of equipment Annual Depreciation (straight line) After 2,600 525 2,000 4 500 Before 2,600 1,215 1,600 8 200 Sales Revenue Expenses other than Depreciation Depreciation EBIT EBIT After Taxes** Add back: Depreciation Free Cash Flow (Before) 0 Part 2: After replacement Disposal of Old Equipment: see handout Old equipment was depreciated on a straight-line basis 4 Age of old equipment: Accum. Deprec. On old equip Net Book Value of old equip Proceeds of sale: Gain/ (Loss) Tax on Gain (Loss)* Net cost of new Equipment Proceeds of 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) 980 Part 3: Incremental*** cash flows *Tax OUTFLOW if Gain *Tax INFLOW if loss ** EBIT *(1-tax rate) *** difference between FCF before new equip, and FCF after PV of Incremental Cash Flows: Cumulative Cash for Payback: Cumulative PV for Disc. Payback: NPV: IRR Payback Disc Payback: Profitability Index:Step 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