Develop a spreadsheet to determine the net present value or present worth of the following project:

Bonus Depreciation: 0%

Investment: 140,000

Revenue/Savings: 25,000

Incremental Expense/Cost: 5,000

Salvage Value: 25,000

Project Life: 10 years

MACRS Schedule: 7 years

Tax Rate: 25%

MARR: 12%

Inflation: 3%

Is this a good investment to make?

Rework the problem with Bonus Depreciation of 50% and 100%

Determine the internal rate of return for the project in the previous problem with all three levels of Bonus Depreciation.

What is the projects payback period for all three cases (0% bonus depreciation, 50% bonus depreciation, and 100% bonus depreciation)?