On the tab marked Depreciation Schedule' complete the following items 1 Apply the appropriate tax depreciable life to each asset 2 Calculate any alowable bonus depreciation on each asset. Assume no see 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 Calculate the book to tax difference on the depreciation of these assets. Use the book depreciation schedule provided. Do not adjust or review the calotations on the book schedule Do not change any calculations on the book depreciation schedule Life 10.00 Bonus Depreciation Beginning AVD 380,000 2020 Depreciation 95,000 Ending ND 475.000 NA Book Asset No 1 2 3 4 5 6 7 8 9 Asset Description Building Land Fumiture & Fixtures Computer Equipment Software Landscaping Fumiture & Fixtures Industrial Machine Building Computer Equipment Fumiture & Fodtures Date in Service 01.01.2016 01.01.2016 02.10.2017 02.10.2017 03.15.2018 04.15.2018 04.15.2019 07.20.2020 07.21.2020 07.20.2020 07.25.2020 Basis 950,000 300,000 75,000 35,000 20,000 15,000 80,000 1,000,000 2.500,000 30.000 27,000 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 22,500 10,500 4,000 3,000 8,000 7,500 3,500 2,000 1,500 8.000 100,000 250,000 3,000 2,700 30.000 14.000 6.000 4.500 16.000 100,000 250.000 3.000 2,700 10 11 Total 5.032,000 428,000 473,200 901.200 Life Bonus Depreciation Beginning A/D 2020 Depreciation Ending AD Tax Asset No. 1 2 3 4 5 6 7 8 9 Asset Description Building Land Fumiture & Fodtures Computer Equipment Software Landscaping Fumiture & Fixtures Industrial Machine Building Computer Equipment Fumiture & Fixtures Date in Service 01.01.2016 01.01.2016 02.10.2017 02.10.2017 03.15.2018 04.15.2018 04.15.2019 07.20.2020 0721.2020 07.20.2020 07.25.2020 Basis 950,000 300,000 75.000 35,000 20,000 15,000 80,000 1,000,000 2.500,000 30,000 27,000 10 11 Total 5.032,000 On the tab marked Depreciation Schedule' complete the following items 1 Apply the appropriate tax depreciable life to each asset 2 Calculate any alowable bonus depreciation on each asset. Assume no see 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 Calculate the book to tax difference on the depreciation of these assets. Use the book depreciation schedule provided. Do not adjust or review the calotations on the book schedule Do not change any calculations on the book depreciation schedule Life 10.00 Bonus Depreciation Beginning AVD 380,000 2020 Depreciation 95,000 Ending ND 475.000 NA Book Asset No 1 2 3 4 5 6 7 8 9 Asset Description Building Land Fumiture & Fixtures Computer Equipment Software Landscaping Fumiture & Fixtures Industrial Machine Building Computer Equipment Fumiture & Fodtures Date in Service 01.01.2016 01.01.2016 02.10.2017 02.10.2017 03.15.2018 04.15.2018 04.15.2019 07.20.2020 07.21.2020 07.20.2020 07.25.2020 Basis 950,000 300,000 75,000 35,000 20,000 15,000 80,000 1,000,000 2.500,000 30.000 27,000 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 22,500 10,500 4,000 3,000 8,000 7,500 3,500 2,000 1,500 8.000 100,000 250,000 3,000 2,700 30.000 14.000 6.000 4.500 16.000 100,000 250.000 3.000 2,700 10 11 Total 5.032,000 428,000 473,200 901.200 Life Bonus Depreciation Beginning A/D 2020 Depreciation Ending AD Tax Asset No. 1 2 3 4 5 6 7 8 9 Asset Description Building Land Fumiture & Fodtures Computer Equipment Software Landscaping Fumiture & Fixtures Industrial Machine Building Computer Equipment Fumiture & Fixtures Date in Service 01.01.2016 01.01.2016 02.10.2017 02.10.2017 03.15.2018 04.15.2018 04.15.2019 07.20.2020 0721.2020 07.20.2020 07.25.2020 Basis 950,000 300,000 75.000 35,000 20,000 15,000 80,000 1,000,000 2.500,000 30,000 27,000 10 11 Total 5.032,000
