On the tab marked ‘Depreciation Schedule’ complete the following items:
1 Apply the appropriate tax depreciable life to each asset
2 Calculate any allowable bonus depreciation on each asset. Assume no sec. 179 deduction has been taken on any asset.
3 Calculate the beginning accumulated depreciation for each asset. Include any allowable bonus depreciation in this amount
4 Calculate the current year tax depreciation for each asset.
5 Calculate the book to tax difference on the depreciation of these assets. Use the book depreciation schedule provided. Do not adjust or review the calculations on the book schedule.
All of this is to be done in Excel: