Answered step by step
Verified Expert Solution
Link Copied!

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.image text in transcribedas, 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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

AQA AS Accounting Unit 2 Financial And Management Accounting

Authors: Brendan Casey

1st Edition

1500684260?, 978-1500684266

More Books

Students also viewed these Finance questions