Please help with answering the last part

View Tools Data Window Excel File Edit o AutoSave OFF Home Insert Draw Insert $ Help Format U . Page Layout Formulas Data Review Verdana ACC 213 - Chapter 8 Instructions & Template View Conditional Formatting Currency Formats Table $ % 9 + S 14 A A BTU 2 . Paste F91 x fx-590-091 ACC 213 - Lab 87 for Chapter 8 - Depreciation Methods Lab .7 is divided into two parts: Part 1 is a series of depreciation calculations. Use formulas/cell references to mak Part 2 requires adjusting entries and a short written explanation. Instructions Use the following data to complete the depreciation calculations: Equipment Purchased on 17/2/2019 Cost of Equipment $62,000 Expected Life (for SL and DDR Expected Life (for Units of Production) Exacted Salvage for Besdal Value) Land DDB) Depected the Part 11 Eye LEDSBSHeng HER Straight-Line depreciation Part A use Excel formulas to calculate depreciation expense, accumulated depreciation, and book values at 12/31 for each year. Part using the Excel function (click on t, choose SLN, fill in the arguments screen), calculate the depreciation expense for years 1,9 and 10 Units of Production (Units of Output) depreciation Use Excel formulas to calculate depreciation expense, accumulated depreciation, and book values at 12/31 for each year, Apply your formulas in Year 10 without considering whether you've depreciated too much or teettle of the asset Note: there is no Excel fx for Units of Production depreciation. Double-Dedining Balance depreciation Part A - use Excel formulas to calculate depreciation expense, accumulated depreciation, and book values at 12/31 for each year, Apply your formulas in Year 10 without considering whether you've depreciated too much or too little of the asset Part 8 - using the Excel function (click on fx, choose po, il in the arguments screen), calculate the depreciation expense for years 1, 9 and 10. Part A - complete adjusting entries for each type of depreciation method as of 12/31/19. Part B - answer the question in the commentary section, Part 1 - Calculations Straight-Une Depreciation Port A: Construct formulas to calculate Depreciation Expense for each year, and Depreciation Template + Ready MacBook . . Du Home Insert Draw Page Layout Formulas Data Review View = = = Verdana 23 14 A OA Currency $ % BI U fx =R$90-191 F91 x > Part 1 -- Calculations 37 Straight-Line Depreciation > Part A: Construct formulas to calculate Depreciation Expense for each year, and Accumulated Depreciation and Book Value at the end of each year. Accumulated Depreciation 2999 BOX Depreciation Expense 1/2/19 Yeari 3500 Year 2 5500 Year 3 55,500 Year 4 $5,500 Year 5 55,500 Year 6 $5,500 Year 7 $5,500 Year 8 9500 Year 9 35,500 Year 10 $5,500 35,500 5:11,000 $16,500 522,000 $27,500 53,000 $58,500 $44,000 $49,500 $55,000 Book Value $62,000 536,500 351,000 345,500 $40,000 $34.500 $29,000 $23,500 $18,000 $12500 $7,000 56 Part B: Using Excel function (fx SLN), determine the depreciation expense for: Year 1 $5,500 58 Year 9 59 Year 10 5.500 Units of Output (Units of Production) Depreciation 6 Construct formulas to calculate Depreciation Expense for each year, and Accumulated Depreciation and Book Value at the end of each year. 65 Apply the formula without considering whether you've depreciated too much or too little of the asset! 67 Actual Number of 68 Units Produced Accumulated Depreciation Book Value $62,000 550,853 7015,200 71 4,800 4.000 2,400 20,000 Depreciation Expense 1/2/19 Yearl 11.1471 Year 2 $3,520 Year 3 52933 Year 4 $1.7601 Year 5 $11,147 $14,667 $1,600 3193760 344,400 14667 3340 327973 Depreciation Template Ready Tools Excel File Edit AutoSave OFF View o Insert s Format : Home Insert Draw Page Layout Formulas Data = Data Window Help ACC 213 - Review View = = Currenc D $ % Paste Verdana 14 A BI U Dva.Av. 4 x fc =F$90-091 F91 Year 9 59 Year 10 BRRRRRRRRRRES 62 Units of Output (Units of Production) Depreciation Construct formulas to calculate Depreciation Expense for each year, and 64 Accumulated Depreciation and Book Value at the end of each year. 6s Apply the formula without considering whether you've depreciated too much or too little of the asset! Actual Number of Depreciation Accumulated Book sa Units Produced Expense Depreciation Valve 1/2/19 $62,000 15,200 Yeart 311,147 4,800 Year 2 33,520 34,667 3472355 4,000 Year 3 $27953 1/600 544,400 2,400 Year 4 31.760 330973160 342,640 20,000 Year 5 E667 34027 $27973 2,400 Year 6 51760 53587 326,215 11,200 Year 7 Year 8 $121731 116.82 10,400 Year 9 3352000 3900 8.000 Year 10 $5,867 558,667 1,600 Double-Declining Balance Depreciation - Part A: Construct formulas to calculate Depreciation Expense for each year & Accumulated Depreciation and Book Value at the end of each year. Apply the formula without considering whether you've depreciated too much or too little of the asset! Accumulated Depreciation Depreciation Expense 312,400 9920 Book Value $62.000 549.6001 $59.68 90 91 52 90 94 95 9 92 1/2/19 Year1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 312400 223.20 3330,256 3336,05 3684 39,079 4,06 325395 30316 16253 48998 Depreciation Template + Ready Excel File Edit View Insert Format Tools Data Window Help o. AutoSave OFF svo: ACC 213 - Home Insert Draw Page Layout Formulas Data Review View Verdana 14 AA = 32 Currenc BI UV IV a. A ub Paste J97 x fx Double-Declining Balance Depreciation Part Ai Construct formulas to calculate Depreciation Expense for each year & Accumulated Depreciation and Book Value at the end of each year. Apply the formula without considering whether you've depreciated too much or too little of the asset! Depreciation Expense Accumulated Depreciation 2400 $9,920 $7936 $67349 90 1/2/19 Year1 Year 2 Year 3 Year 4 9 Year 5 2 Year 6 91 Year 7 Year 8 99 Year 9 100 Year 10 Book Value $62,000 $49,600 $39,680 331,744 325395 $20,316 $16, 253 $13,002 50.402 33321 $6,657 $12,400 $22320 530,256 $56,605 541,684 $45,747 34899918 $51,598 353,679 $55,343 34065 3,251 2,600 2080 $1,664 103 Part B: Using Excel function (fx DDB), determine the depreciation expense for: 104 Year 1 105 Year 9 100 Year 10 10 Part 2 - Adjusting Entries & Commentary. Prepare the adjusting journal entry for depreciation on 12/31/19 three different ways Units of Production, and Double Declining Balance. Acct Titles Adjusting Entry: Straight-Line Adjusting Entry: Units of Prod. Depreciation Template Ready CT Excel File Edit View Insert Format Tools Data Window Help o AutoSave O ROSU- ACC 213 - Chapter 8 Instructions & Home Insert Draw Page Layout Formulas Data Review View LyX Verdana ~ 14 A M Currency Paste B IULOA * $ -% 83 x fr 197 Part B: Using Excel function (fx DDB), determine the depreciation expense for: 10 Year 1 10 Part 2 - Adjusting Entries & Commentary. Prepare the adjusting journal entry for depreciation on 12/31/19 three different ways: Straight-Line, Units of Production, and Double Declining Balance. Acct Titles Debit Credit Adjusting Entry: Straight-Line Adjusting Entry: Units of Prod. Adjusting Entry: DDB Are the calculations you made for depreciation expense for Double Declining Balance and Units of Production (in part A) correct? (Answer Yes or No and explain why your calculations are correct Depreciation Template Ready