Question: Please create or give a step by step way to build a depreciation tax shield calculation model You have just started with UPS as a

Please create or give a step by step way to build adepreciation tax shield calculation model You have just started with UPS asPlease create or give a step by step way to build a depreciation tax shield calculation model

You have just started with UPS as a financial analyst and your manager asks that you build a "depreciation tax shield" calculation model. The main purpose of the model is to track the annual amount of tax that is saved thanks to depreciation. Your manager appreciates concise results, especially plotted on a chart. Useful life Purchase price Tax 10 $250,000.00 Years 25% Book Value Annual Dep Annual TxSh 1 $250,000.00 $25,000.00 $6,250.00 2 $225,000.00 $25,000.00 $6,250.00 3 $200,000.00 $25,000.00 $6,250.00 4 $175,000.00 $25,000.00 $6,250.00 5 $150,000.00 $25,000.00 $6,250.00 6 $125,000.00 $25,000.00 $6,250.00 7 $100,000.00 $25,000.00 $6,250.00 8 $75,000.00 $25,000.00 $6,250.00 9 $50,000.00 $25,000.00 $6,250.00 10 $25,000.00 $25,000.00 $6,250.00 $30,000.00 $25,000.00 $20,000.00 $15,000.00 $10,000.00 $5,000.00 $0.00 Annual Depreciation and Tax-Shield 1 2 3 4 Annual TxSh 5 6 7 8 9 10 Annual Dep

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!