Please help, accounting question.

Review View Developer Help 13 RE General X COL Format Painter Clipboard N Arial 20 A== Wrap Text BIUDAY A Merge Center 27 $ -% - L Conditional Formatas Cell Formatting Table Styles Insert Delete Format AutoSum FIT Sort & Find & Clear Filter Select Editing AI C Font Alignem ly Number Style Gils E25 > P B c D E F G G 1 Acc 3013 1 J K K L M N 2 Chapter 10 Homework 3 Summer 2021 4 5 6 Instructions 7 Due Date 07.23.21 8 Possible Points 10 9 10 On the tab markod 'Depreciation Schedule complete the following items 11 12 1 Apply the appropriate tax depreciable site to each asset 13 2 Calculate any allowable bonus depreciation on each asset. Assume no sec 179 deduction has been taken on any asset 14 3 Calculate the beginning accumulated depreciation for each asset. Include any allowable bonus depreciation in this amount 15 4 Calculate the current year tax depreciation for each asset 16 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 schedu 17 18 Do not change any calculations on the book' depreciation schedule 19 You may work in a group for this assignment Each group only needs to submit one copy of the comploted Excel file 20 Submit your completed Excel file via blackboard 21 22 List group members, if any, here 23 24 25 26 27 28 29 30 31 22 Instructions Depreciation Schedule Roy 56 Accessibility: Good to go Arial 10 La Cupy Wrap Text Custom uste AAS A = AutoSum *Formal Painter BIU 49 0 3 Merge & Center Fill LINN $ % Conditional Format as Cell Formatting Table Styles Insert Delete Format Cirp buurt N Ferr Clear Alignment Sort & Find Analye Filtes Select Data Editing 5 Number Styles Celis 419 fo Aruss F G Bonus Depreciation K K L H Beginning A/D 380.000 M N c 1 2020 Depreciation 95.000 J Ending AID 475,000 107 12 D Basis 950.000 300,000 75,000 35 000 20,000 15 1100 30,000 1.000 XX) 2.500.000 30,000 27.000 E Life 10 00 N/A 10.00 1000 10.00 10.00 10.00 10 00 1000 10.00 10.00 22 500 10.500 4,00X 3,000 B,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 16 5,032,000 428,000 473 200 901 200 A B 7 Asset No. Asset Description Date in Service 8 Building 01.01.2018 9 2 Land 01 01 2016 3 Turnure & Lixtures 02.10.2017 11 1 Cutriputer Equipment 02.10.2017 5 Sollware 03.15.2018 13 Landscaping 04 15 2018 14 1 Furniture & Fixtures 04.15 2019 15 8 Industrial Machine 0/ 20.2020 9 Building 0721 2020 177 10 Computer Lquipment 07.20.2020 18 11 Turniture & Fixtures 07 29 2020 19 20 Total 21 22 23 Tax 24 Asset No Asset Description Date in Service 25 1 Building 01.01.2016 26 2 Land 01 01 2016 27 3 Furniture & Fixtures 12.10.2017 28 4 Computer Equipment 02.10.2017 5 Software 03.15.2018 ti Landscaping 04.15.2018 7 Furniture & Fixtures 04.15.2019 32 8 Industrial Machine 07 20 2020 9 Building 07 21 2020 34 10 Computer Equipment 07 20.2020 11 Furniture & Fixtures 07.25 2020 36 37 Total 20 Instructions Depreciation Schedule Life Bonus Depreciation Beginning A/D 2020 Depreciation Ending AID 29 30 317 Basis 9500,000 300 ODD 75,000 35,000 20 000 15,000 BOXXO 1.000.000 2,500,000 30.0XX) 27,000 33 35 5,032,0) Review View Developer Help 13 RE General X COL Format Painter Clipboard N Arial 20 A== Wrap Text BIUDAY A Merge Center 27 $ -% - L Conditional Formatas Cell Formatting Table Styles Insert Delete Format AutoSum FIT Sort & Find & Clear Filter Select Editing AI C Font Alignem ly Number Style Gils E25 > P B c D E F G G 1 Acc 3013 1 J K K L M N 2 Chapter 10 Homework 3 Summer 2021 4 5 6 Instructions 7 Due Date 07.23.21 8 Possible Points 10 9 10 On the tab markod 'Depreciation Schedule complete the following items 11 12 1 Apply the appropriate tax depreciable site to each asset 13 2 Calculate any allowable bonus depreciation on each asset. Assume no sec 179 deduction has been taken on any asset 14 3 Calculate the beginning accumulated depreciation for each asset. Include any allowable bonus depreciation in this amount 15 4 Calculate the current year tax depreciation for each asset 16 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 schedu 17 18 Do not change any calculations on the book' depreciation schedule 19 You may work in a group for this assignment Each group only needs to submit one copy of the comploted Excel file 20 Submit your completed Excel file via blackboard 21 22 List group members, if any, here 23 24 25 26 27 28 29 30 31 22 Instructions Depreciation Schedule Roy 56 Accessibility: Good to go Arial 10 La Cupy Wrap Text Custom uste AAS A = AutoSum *Formal Painter BIU 49 0 3 Merge & Center Fill LINN $ % Conditional Format as Cell Formatting Table Styles Insert Delete Format Cirp buurt N Ferr Clear Alignment Sort & Find Analye Filtes Select Data Editing 5 Number Styles Celis 419 fo Aruss F G Bonus Depreciation K K L H Beginning A/D 380.000 M N c 1 2020 Depreciation 95.000 J Ending AID 475,000 107 12 D Basis 950.000 300,000 75,000 35 000 20,000 15 1100 30,000 1.000 XX) 2.500.000 30,000 27.000 E Life 10 00 N/A 10.00 1000 10.00 10.00 10.00 10 00 1000 10.00 10.00 22 500 10.500 4,00X 3,000 B,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 16 5,032,000 428,000 473 200 901 200 A B 7 Asset No. Asset Description Date in Service 8 Building 01.01.2018 9 2 Land 01 01 2016 3 Turnure & Lixtures 02.10.2017 11 1 Cutriputer Equipment 02.10.2017 5 Sollware 03.15.2018 13 Landscaping 04 15 2018 14 1 Furniture & Fixtures 04.15 2019 15 8 Industrial Machine 0/ 20.2020 9 Building 0721 2020 177 10 Computer Lquipment 07.20.2020 18 11 Turniture & Fixtures 07 29 2020 19 20 Total 21 22 23 Tax 24 Asset No Asset Description Date in Service 25 1 Building 01.01.2016 26 2 Land 01 01 2016 27 3 Furniture & Fixtures 12.10.2017 28 4 Computer Equipment 02.10.2017 5 Software 03.15.2018 ti Landscaping 04.15.2018 7 Furniture & Fixtures 04.15.2019 32 8 Industrial Machine 07 20 2020 9 Building 07 21 2020 34 10 Computer Equipment 07 20.2020 11 Furniture & Fixtures 07.25 2020 36 37 Total 20 Instructions Depreciation Schedule Life Bonus Depreciation Beginning A/D 2020 Depreciation Ending AID 29 30 317 Basis 9500,000 300 ODD 75,000 35,000 20 000 15,000 BOXXO 1.000.000 2,500,000 30.0XX) 27,000 33 35 5,032,0)