Incorporate depreciation and taxes. Model before tax cash flows and after tax cash flows. Show the before tax and after tax cash flows as well as the PV of the AFTC in each year and the NPV. Assume straight line depreciation and use excel. Inputs from the user include initial investment, marginal tax rate, useful life, salvage value, MARR, annual benefits (revenue), and annual costs. The inputs are:

Initial Cost $100,000

Annual Revenues $81,155

Annual Costs (Excluding Depreciation) $20,000

Year 3 Overhaul $15,390

Year 6 Clean-up Costs $17,690

Equipment Salvage/Book Value $10,000

Useful Life 6 years

r 0.10

Tax Rate 0.35

Equipment Sold For $20,000