For this week's assignment, update the spreadsheets you created in Modules 3 to incorporate depreciation and taxes This will require you to consider and model before tax cash flows and after tax cash flows in your models and then determine the appropriate output for your model Assume straight line depreciation only A simple example is in Chapter 12 Inputs from the user would include initial investment, marginal tax rate, useful life, salvage value, MARR, annual benefits (revenue), and annual costs The inputs for your submission 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 (this was not provided in 2 3) 0 10 Tax Rate 0 35 Equipment Sold For $20,000 Your model should show the before tax and after tax cash flows as well as the PV of the AFTC in each year and of course the NPV, which is the final solution Your submission should include the model in ready to use clean version and a completed model using the above information (on separate tabs)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 17, 2024

For this week's assignment, update the spreadsheets you created in Modules 3 to incorporate depreciation and taxes. This will require you to consider and model

For this week's assignment, update the spreadsheets you created in Modules 3 to incorporate depreciation and taxes. This will require you to consider and model before tax cash flows and after tax cash flows in your models and then determine the appropriate output for your model. Assume straight line depreciation only. A simple example is in Chapter 12.

Inputs from the user would include initial investment, marginal tax rate, useful life, salvage value, MARR, annual benefits (revenue), and annual costs.

The inputs for your submission 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 (this was not provided in 2.3)	0.10
Tax Rate	0.35
Equipment Sold For	$20,000

Your model should show the before tax and after tax cash flows as well as the PV of the AFTC in each year and of course the NPV, which is the final solution. Your submission should include the model in ready to use clean version and a completed model using the above information (on separate tabs).