Please show work to add to excel sheet for Asset 1, 2 and 3.

CHECK FIGURES Asset #1 DDB Asset #1 SYD Asset#2 DDB Asset #2 SYD Asset #3 DDB Asset #3 SYD Part A, Yr 2 Part B, Yr3 Part A, Yr 2 Part B, Yr3 Part A, Yr 2 Part B. Yr3 $ 318,000.00 $ 298,611.11 $ 127,551.02 $ 113,660.71 $ 140,640.00 $ 137,177.27 A D E F G H APPLICATION ASSIGNMENT #4- ACCT305 (Chapter 11) . Students - Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred to the appropriate blank in the Solutions (orange tab) worksheet in this workbook. Make sure you are utilizing Excel functions, formatting, and calculation abilities where applicable. Your worksheets should be easy to read and labelled properly. Problem: (DepreciationSL, DDB, SYD, Act.) On January 1st, 2017, Marco Company, a medium-sized manufacturer, acquired the following assets: 4 5 Cost Salvage MACRS Value Useful Life Units of Production Class Life 1 2 Asset #1 $ 1,325,000 $ 75,000 5 2017 42,000 5 * Total units of 3 2018 35,000 output = 160,000 2019 31,000 Asset #2 $ 625,000 $ 55,000 7 2017 25,000 7 * Total units of 7 2018 18,000 output = 100,000 8 2019 16,000 9 o Asset #3 $ 879,000 $ 10 2017 82,000 10 *Total units of 1 2018 75,000 output = 600,000 2 2019 60,000 3 4 The following depreciation methods will be used: (1) straight-line; (2) double-declining-balance; 5 (3) sum-of-the-years'-digits, and (4) units-of-output. 6 8 9 0 1 2 3 7 Instructions: (a) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods described above. Provide the depreciation expense for years 2017, 2018, and 2019. To complete this, utilize Excel worksheets and tools to create a table that is easy to read, use formulas where appropriate, and label the annual depreciation for each year. Make sure all compenents are included such as depreciable cost, etc. NOTE: Round final solutions to two digits. 4 5 6 7 (b) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods, assuming they were all purchased August 1st, 2017. Provide the depreciation expense for years 2017, 2018, 2019. Provide all solutions in the Solutions tab. Be sure to use cell references. 8 9 D (c)(1) Which depreciation method would maximize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? 1 2 3 4 (c)(2) Which depreciation method would minimize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? 5 Asset #1 2017 2018 2019 Asset #2 2017 2018 2019 Asset #3 2017 2018 2019 Straight Line SL SL Double-declining balance DDB DDB Sum-of-the-Years'- Digits SYD SYD Units of Output U-Output U-Output Asset #1 2017 2018 2019 Asset #2 2017 2018 2019 Asset #3 2017 2018 2019 Straight Line SL SL Double-declining balance DDB DDB Sum-of-the-Years'- Digits SYD SYD Units of Output U-Output U-Output (1) Method to maximize net income 2) Method to minimize net income Instructions Solutions Asset #1 Asset#2 Asset#3 CHECK FIGURES Asset #1 DDB Asset #1 SYD Asset#2 DDB Asset #2 SYD Asset #3 DDB Asset #3 SYD Part A, Yr 2 Part B, Yr3 Part A, Yr 2 Part B, Yr3 Part A, Yr 2 Part B. Yr3 $ 318,000.00 $ 298,611.11 $ 127,551.02 $ 113,660.71 $ 140,640.00 $ 137,177.27 A D E F G H APPLICATION ASSIGNMENT #4- ACCT305 (Chapter 11) . Students - Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred to the appropriate blank in the Solutions (orange tab) worksheet in this workbook. Make sure you are utilizing Excel functions, formatting, and calculation abilities where applicable. Your worksheets should be easy to read and labelled properly. Problem: (DepreciationSL, DDB, SYD, Act.) On January 1st, 2017, Marco Company, a medium-sized manufacturer, acquired the following assets: 4 5 Cost Salvage MACRS Value Useful Life Units of Production Class Life 1 2 Asset #1 $ 1,325,000 $ 75,000 5 2017 42,000 5 * Total units of 3 2018 35,000 output = 160,000 2019 31,000 Asset #2 $ 625,000 $ 55,000 7 2017 25,000 7 * Total units of 7 2018 18,000 output = 100,000 8 2019 16,000 9 o Asset #3 $ 879,000 $ 10 2017 82,000 10 *Total units of 1 2018 75,000 output = 600,000 2 2019 60,000 3 4 The following depreciation methods will be used: (1) straight-line; (2) double-declining-balance; 5 (3) sum-of-the-years'-digits, and (4) units-of-output. 6 8 9 0 1 2 3 7 Instructions: (a) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods described above. Provide the depreciation expense for years 2017, 2018, and 2019. To complete this, utilize Excel worksheets and tools to create a table that is easy to read, use formulas where appropriate, and label the annual depreciation for each year. Make sure all compenents are included such as depreciable cost, etc. NOTE: Round final solutions to two digits. 4 5 6 7 (b) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods, assuming they were all purchased August 1st, 2017. Provide the depreciation expense for years 2017, 2018, 2019. Provide all solutions in the Solutions tab. Be sure to use cell references. 8 9 D (c)(1) Which depreciation method would maximize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? 1 2 3 4 (c)(2) Which depreciation method would minimize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? 5 Asset #1 2017 2018 2019 Asset #2 2017 2018 2019 Asset #3 2017 2018 2019 Straight Line SL SL Double-declining balance DDB DDB Sum-of-the-Years'- Digits SYD SYD Units of Output U-Output U-Output Asset #1 2017 2018 2019 Asset #2 2017 2018 2019 Asset #3 2017 2018 2019 Straight Line SL SL Double-declining balance DDB DDB Sum-of-the-Years'- Digits SYD SYD Units of Output U-Output U-Output (1) Method to maximize net income 2) Method to minimize net income Instructions Solutions Asset #1 Asset#2 Asset#3