calculate the bonus depreciation, beginning depreciation, 2019 depreciation, and ending depreciation for each items

Chapter 10 Homeworkxlsx Microsoft Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Cut Arial A A 10 Wrap Text Copy aste Format Painter Custom Accent4 Accents Accent BIU A- Merge & Center Conditional Format as Comma Formatting Table $ % , Comma [0] Curren Cipboard Font Alignment Number Styles 25 A C D E F G H J TETI Book Asset No. Asset Description Date in Service 01.01.2016 Basis Life Bonus Depreciation Beginning A/D 285,000 2019 Depreciation Ending A/D 380,000 Building Land 950,000 300,000 10.00 95,000 2 01.01.2016 NA 0 1 12 13 4 15 16F 17 18 19 20 Total 21 22 23 24 Asset No. 25 26 27 28 29 30 31 32 33 34 35 36 37 3 Furniture & Fodures 02.10.2016 75,000 10.00 22,500 7,500 30,000 14,000 8,000 4 Computer Equipment Software 02.10.2016 35,000 20.000 10.00 10,500 6,000 3,500 5 03.15.2016 10.00 2,000 Landscaping Furniture & Fxtures Industrial Machine Buikding Computer Equipment 04.15.2017 15,000 10.00 3,000 16,000 1,500 8,000 100,000 4,500 04.15.2017 07 20.2019 24,000 100,000 250,000 80,000 10.00 1,000,000 10.00 07.21.2019 2,500,000 30,000 27,000 10.00 250,000 9 3,000 2,700 3,000 2,700 10.00 10 07.20.2019 10.00 Furniture & Fixtures 07.25.2019 11 816,200 473,200 5,032,000 343,000 x 2019 Depreciation Ending A/D 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 Life Bonus Depreciation Beginning A/D Date in Service Asset Description Building 27.50 01.01.2016 NA 01.01.2016 2 Land 7.00 Furniture & Fidures Computer Equipmont 02.10.2016 3 5.00 02.10.2016 4 3.00 03.15.2016 Software 5 15.00 04.15.2017 Landscaping 6 7.00 04.15.2017 07 20 2019 07 21 2019 07.20.2019 Furniture & Fatures Industrial Machine Building Computer Equipment Furniture & Fafures 7 7.00 8 27.50 5.00 10 7.00 07 25 2019 11 5,032,000 olal 38 Depreciation Schedule Instastions Chapter 10 Homeworkxlsx- Microsoft Excel REVIEW VIw DAIA FORMULAS PAGE LAVOUT HOMI INSERT FILE Normal Good Bad AA Wrap lest General X Cut h Copy 10 Arial t Conditional Format as Neutral Fomatting Table Insest Delete Calculation Check Cell Mege & Center S % . e & A a Pube BIU fomat Painter Cels styles Number Alignment Cpbcard Fe A4 N C L K J E G H D F B Acc 3043 Chapler 10 Homowork 3 Fal 2019 5 6 Instructioms 1-Oct 7 Due Date Possible Points 8 9 5 10 On the tab marked Deprecialion Schedule complete the following toms 11 12 13 14 15 16 17 18 Each component of the assignment is worth 1 point Submit your completed excel fle ty e-maid no lator than 11 59 PM 19 You may work in a group for this assignment. Each group only needs to submit one copy of the completed Excel file. 20 21 22 23 24 25 26 27 1 Apply the appropriate tax depreciable ife to each asset 2 Caculade any alowable bonus depreciation on each asset. Assume al assets are brand new at the time of purchase. 3 Cacuate the beginning accumulalod depreciation for each asset Include any alowable bonus depreciation in this amount 4 Calculate the current year tax depreciation for each asset 5 Calculte the book to tax difference on the depreciation of these assets Use the book depreciation schedule provided. Do not adiust or reviow the calculations on the book schodule 29 30 31 32 33 34 Instructions Depreciation Schedule Chapter 10 Homeworkxlsx Microsoft Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Cut Arial A A 10 Wrap Text Copy aste Format Painter Custom Accent4 Accents Accent BIU A- Merge & Center Conditional Format as Comma Formatting Table $ % , Comma [0] Curren Cipboard Font Alignment Number Styles 25 A C D E F G H J TETI Book Asset No. Asset Description Date in Service 01.01.2016 Basis Life Bonus Depreciation Beginning A/D 285,000 2019 Depreciation Ending A/D 380,000 Building Land 950,000 300,000 10.00 95,000 2 01.01.2016 NA 0 1 12 13 4 15 16F 17 18 19 20 Total 21 22 23 24 Asset No. 25 26 27 28 29 30 31 32 33 34 35 36 37 3 Furniture & Fodures 02.10.2016 75,000 10.00 22,500 7,500 30,000 14,000 8,000 4 Computer Equipment Software 02.10.2016 35,000 20.000 10.00 10,500 6,000 3,500 5 03.15.2016 10.00 2,000 Landscaping Furniture & Fxtures Industrial Machine Buikding Computer Equipment 04.15.2017 15,000 10.00 3,000 16,000 1,500 8,000 100,000 4,500 04.15.2017 07 20.2019 24,000 100,000 250,000 80,000 10.00 1,000,000 10.00 07.21.2019 2,500,000 30,000 27,000 10.00 250,000 9 3,000 2,700 3,000 2,700 10.00 10 07.20.2019 10.00 Furniture & Fixtures 07.25.2019 11 816,200 473,200 5,032,000 343,000 x 2019 Depreciation Ending A/D 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 Life Bonus Depreciation Beginning A/D Date in Service Asset Description Building 27.50 01.01.2016 NA 01.01.2016 2 Land 7.00 Furniture & Fidures Computer Equipmont 02.10.2016 3 5.00 02.10.2016 4 3.00 03.15.2016 Software 5 15.00 04.15.2017 Landscaping 6 7.00 04.15.2017 07 20 2019 07 21 2019 07.20.2019 Furniture & Fatures Industrial Machine Building Computer Equipment Furniture & Fafures 7 7.00 8 27.50 5.00 10 7.00 07 25 2019 11 5,032,000 olal 38 Depreciation Schedule Instastions Chapter 10 Homeworkxlsx- Microsoft Excel REVIEW VIw DAIA FORMULAS PAGE LAVOUT HOMI INSERT FILE Normal Good Bad AA Wrap lest General X Cut h Copy 10 Arial t Conditional Format as Neutral Fomatting Table Insest Delete Calculation Check Cell Mege & Center S % . e & A a Pube BIU fomat Painter Cels styles Number Alignment Cpbcard Fe A4 N C L K J E G H D F B Acc 3043 Chapler 10 Homowork 3 Fal 2019 5 6 Instructioms 1-Oct 7 Due Date Possible Points 8 9 5 10 On the tab marked Deprecialion Schedule complete the following toms 11 12 13 14 15 16 17 18 Each component of the assignment is worth 1 point Submit your completed excel fle ty e-maid no lator than 11 59 PM 19 You may work in a group for this assignment. Each group only needs to submit one copy of the completed Excel file. 20 21 22 23 24 25 26 27 1 Apply the appropriate tax depreciable ife to each asset 2 Caculade any alowable bonus depreciation on each asset. Assume al assets are brand new at the time of purchase. 3 Cacuate the beginning accumulalod depreciation for each asset Include any alowable bonus depreciation in this amount 4 Calculate the current year tax depreciation for each asset 5 Calculte the book to tax difference on the depreciation of these assets Use the book depreciation schedule provided. Do not adiust or reviow the calculations on the book schodule 29 30 31 32 33 34 Instructions Depreciation Schedule