AutoSave On tis Heald Jessica_App4_Ch11 - Saving... Search Heald, Jessica HJ File Home Insert Page Layout Formulas Data Review View Help Power Pivot Comments Share General Insert == Arial ~ AF 12 ab Conditional Formatting Format as Table 0 2 Delete Paste . I A S : + Sensitivity $ %) EM Number Cell Styles Styles Format Cells Sort & Find & Filter Select Editing Analyze Data Analysis Undo Clipboard Font Alignment Sensitivity L M N 0 Q R S T 9 N10 fx A B E G H 1 APPLICATION ASSIGNMENT #4- ACC T305 (Chapter 11) 2 3 Students - Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred 4 to the appropriate blank in the Solutions (orange tab) worksheet in this workbook. Make sure you are 5 utilizing Excel functions, formatting, and calculation abilities where applicable. Your worksheets should be 6 easy to read and labelled properly. 7 8 Problem: (DepreciationSL, DDB, SYD, Act.) On January 1st, 2017, Marco Company, a medium-sized manufacturer, acquired the following assets: 10 Salvage Cost Useful Life Units of Production Value Class Life 11 12 Asset #1 $ 1,425,000 $125,000 5 2017 40,000 5 * Total units of 13 2018 35,000 output = 160,000 14 2019 38,000 15 16 Asset #2 $ 890,000 $ 75,000 7 2017 25,000 7 * Total units of 17 2018 22.000 output = 100,000 18 2019 19,000 19 20 Asset #3 $ 975,000 $ 10 2017 85,000 10 *Total units of 21 2018 80,000 output = 600,000 22 2019 78.000 Instructions Solutions Asset #1 Asset#2 Asset#3 Ready 91% C) 5 6:22 PM 11/19/2021 AutoSave On tis Heald.Jessica_App4_Ch11 - Saved Search Heald, Jessica HJ File Home Insert Page Layout Formulas Data Review View Help Power Pivot Comments Share General Insert == Arial ~ AF 12 ab Conditional Formatting 7 Format as Table 47 0 2 Delete Paste . I v Av S : E $ %) E O Number Sort & Find & Filter Select Analyze Data Sensitivity Cell Styles Styles Format Cells Undo Clipboard Font Alignment Editing Analysis Sensitivity B C D G L M N 0 O R S T N10 fx E F 22 2019 78,000 23 24 The following depreciation methods will be used: (1) straight-line; (2) double-declining-balance; 25 (3) sum-of-the-years'-digits, and (4) units-of-output. 26 27 Instructions: 28 (a) Calculate the annual depreciation for each of the three assets for each of the four depreciation 29 methods described above. Provide the depreciation expense for years 2017, 2018, and 2019. 30 To complete this, utilize Excel worksheets and tools to create a table that is easy to read, use 31 formulas and cell references where appropriate, and label the annual depreciation for each year. 32 Make sure all compenents are included such as depreciable cost, etc. 33 NOTE: Round final solutions to two digits. 34 35 (b) Calculate the annual depreciation for each of the three assets for each of the four depreciation 36 methods, assuming they were all purchased August 1st, 2017. Provide the depreciation expense for years 37 2017, 2018, 2019. 38 Provide all solutions in the Solutions tab. Be sure to use cell references. 39 (c)(1) For Asset #1, which depreciation method would maximize net income for financial statement reporting for the 41 3-year period ending December 31, 2019 for the (a) situation? 40 42 43 44 (c)(2) For Asset #3, which depreciation method would minimize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? 45 Instructions Solutions Asset #1 Asset#2 Asset#3 Ready 91% C) 5 6:23 PM 11/19/2021 AutoSave On tis Heald.Jessica_App4_Ch11 - Saved Search Heald, Jessica HJ File Home Insert Page Layout Formulas Data Review View Help Power Pivot Comments Share General - AI Arial Insert == 11 ab Conditional Formatting Format as Table AY 0 $ %) 2 Delete Paste . I Av S : E Sort & Find & Filter Select Analyze Data Sensitivity Cell Styles Styles Format Cells Undo Clipboard Font Alignment Number Editing Analysis Sensitivity C2 fx A B D E F G H | J L M N 0 1 Solutions to Application Assignment #4 2 Student Name: 3 4 (a) Asset #1 2017 2018 2019 Asset #2 2017 2018 2019 Asset #3 2017 2018 2019 5 Straight Line SL SL 6 Double-declining balance DDB DDB 7 Sum-of-the-Years - Digits SYD SYD 8 Units of Output U-Output U-Output 9 10 (b) Asset #1 2017 2018 2019 Asset #2 2017 2018 2019 Asset #3 2017 2018 2019 11. Straight Line SL SL Instructions Solutions Asset #1 Asset#2 Asset#3 Ready 100% 6:23 PM 11/19/2021 AutoSave On tis Heald.Jessica_App4_Ch11 - Saved Search Heald, Jessica HJ File Home Insert Page Layout Formulas Data Review View Help Power Pivot Comments Share General - AI Arial Insert == 11 ab Conditional Formatting Format as Table AY 0 9. Delete Paste . I A = $ %) EM Number Sort & Find & Filter Select Analyze Data Sensitivity Cell Styles Styles Format Cells Undo Clipboard Font Alignment Editing Analysis Sensitivity C2 fox A B D E F G . J L M N 0 10 (b) Asset #1 2017 2018 2019 Asset #2 2017 2018 2019 Asset #3 2017 2018 2019 11 Straight Line SL SL 12 Double-declining balance DDB DDB 13 Sum-of-the-Years - Digits SYD SYD 14 Units of Output U-Output U-Output 15 (1) Method to maximize net income 16 ) (2) Method to minimize net income 17 18 Instructions Solutions Asset #1 Asset#2 Asset#3 Ready 100% 6:23 PM 11/19/2021