Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred o...

   

Transcribed Image Text:

Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred o 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: (Depreciation-SL, DDB, SYD, Act) On January 1st, 2017, Marco Company, a medium-sized manufacturer, acquired the following assets Cost Salvage Value Useful Life Asset #1 $1,375,000 $75,000 5 Asset #2 $830,000 $ 55,000 7 Asset #3 $ 969,000 $ 10 Units of Production 2017 2018 2019 2017 2018 2019 2017 2018 2019 38,000 5 40,000 35,000 22,000 16,000 18,000 Class Life 75,000 85,000 72,000 10 Total units of output 160,000 Total units of output 100,000 "Total units of output=600,000 The following depreciation methods will be used: (1) straight-line, (2) double-declining-balance; (3) sum-of-the-years-digits; and (4) units-of-output 2 3 4 Instructions: 5 6 37 58 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 (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 and cell references 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. (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. (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? (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? CHECK FIGURES Asset #1 Asset #11 Asset#2 Asset #2 Asset #3 Asset #3 DDB SYD DDB SYD DDB SYD Part A Yr 2 Part B, Yr3 Part A, Yr 2 Part B, Yr3 Part A Yr 2 Part B. Yr3 $ 330,000.00 $ 310,555.56 $ 169,387,76 154,538.69 S $ 155,040.00 $ 151,222.73 Solutions to Application Assignment 84 Student Name: (a) Asset #1 Straight Line Double-declining balance Sum-of-the-Years Digts Units of Output (b) Asset #1 60) Straight Line Double-decining balance Sum of the Years: Digts Units of Output (1) Method to maximize net income (2) Method to minimize net income 2017 2017 2018 2018 2019 Asset #2 SL DOB 2010 SYD U-Output Asset #2 SA 008 SYD U-Output 2017 2017 2018 2018 2019 2019 Asset 3 SL DOB SYD U-Output Asset 3 St DOB SYD U-Output 2017 2017 2018 2018 2019 2019 Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred o 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: (Depreciation-SL, DDB, SYD, Act) On January 1st, 2017, Marco Company, a medium-sized manufacturer, acquired the following assets Cost Salvage Value Useful Life Asset #1 $1,375,000 $75,000 5 Asset #2 $830,000 $ 55,000 7 Asset #3 $ 969,000 $ 10 Units of Production 2017 2018 2019 2017 2018 2019 2017 2018 2019 38,000 5 40,000 35,000 22,000 16,000 18,000 Class Life 75,000 85,000 72,000 10 Total units of output 160,000 Total units of output 100,000 "Total units of output=600,000 The following depreciation methods will be used: (1) straight-line, (2) double-declining-balance; (3) sum-of-the-years-digits; and (4) units-of-output 2 3 4 Instructions: 5 6 37 58 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 (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 and cell references 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. (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. (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? (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? CHECK FIGURES Asset #1 Asset #11 Asset#2 Asset #2 Asset #3 Asset #3 DDB SYD DDB SYD DDB SYD Part A Yr 2 Part B, Yr3 Part A, Yr 2 Part B, Yr3 Part A Yr 2 Part B. Yr3 $ 330,000.00 $ 310,555.56 $ 169,387,76 154,538.69 S $ 155,040.00 $ 151,222.73 Solutions to Application Assignment 84 Student Name: (a) Asset #1 Straight Line Double-declining balance Sum-of-the-Years Digts Units of Output (b) Asset #1 60) Straight Line Double-decining balance Sum of the Years: Digts Units of Output (1) Method to maximize net income (2) Method to minimize net income 2017 2017 2018 2018 2019 Asset #2 SL DOB 2010 SYD U-Output Asset #2 SA 008 SYD U-Output 2017 2017 2018 2018 2019 2019 Asset 3 SL DOB SYD U-Output Asset 3 St DOB SYD U-Output 2017 2017 2018 2018 2019 2019