Do not worry anout the formula.

Excel File Edit View Insert . AutoSaver S U Home Insert Draw Page Layout Format : Formulas Tools Data Window Help ACC 213 - Chapter 8 Instructions & Template Data Review Verdana A AC Nsxv Instructions Use the following data to complete the depreciation calculations L pment Purchased on 2010 Cost of topment $62,000 Expected Ute (for SL and DB) 10 years Expected Ute for Units of Production) 75,000 product units Date Salvador Residual TI Part 11 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 fx, 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 formules in Year 10 without considering whether you've depreciated too much or toont of the asset! Note: there is no Excel for Units of Production depreciation Double-Declining Balance depreciation Part A -use Excel formulas to calculate depreciation expense, accumulated depreciation, and book values at 12/31 for each year. Apply your formules in Year 10 without considering whether you've depreciated too much or too little of the asseti Part - using the Excel function (click on te, cheese DDB, fill in the arguments screen), calculate the depreciation expense for years 1, and Part A - complete adjusting entries for each type of depreciation method as of 12/31/19. Part - answer the question in the commentary section Part 1 Calculations Part At Construct formulas to calculate Depreciation Expense for each year, and Accumulated Depreciation and Book Value at the end of each year. Depreciation Accumulated Expense Dereciation 2/19 4 Depreciation Template Paste 8 BI U ululavau 4 x v fx ...... ...... .......! N5 ! Part 1 -- Calculations 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. Depreciation Accumulated Book Expense Depreciation Value 1/2/19 $62,000 Yearl Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 56 Part B: Using Excel function (fx SLN), determine the depreciation expense for: 5 Year 1 sa Year 9 99 Year 10 62 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. Apply the formula without considering whether you've depreciated too much or too little of the asset Actual Number of a Units Produced Accumulated Depreciation Book Value $62.000 SRENN 15,200 4,800 4,000 2,400 Depreciation Expense 1/2/19 Year1 Year 2 Year 3 Year Depreciation Template Data Window ACC Review View Excel file Edit View Insert Format Tools co AutoSave OFF svo Home Insert Draw Page Layout Formulas Data Verdana 14 A A U I Paste & BI vulcravau N5 x v fx 29 w $ ECIALITA LUISA T B rare Di UMY EXLE TUILLIUI KIA SL), VELETTERIE LIG V 57 Year 1 s Year 9 59 Year 10 Units of Output (Units of Production) Depreciation Construct formulas to calculate Depreciation Expense for each year, and 4 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 6) Actual Number of 6 Units Produced Accumulated Depreciation Book Value $62,000 15,200 4,800 4,000 2,400 20,000 2,400 11,200 1,600 10,400 8,000 Depreciation Expense 1/2/19 Yeari Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 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. 06 Apply the formula without considering whether you've depreciated too much or too little of the asset Depreciation Expense Accumulated Depreciation Book Value $62,000 1/2/19 Year1 Year 2 Year 3 Year 4 Year 5 Depreciation Template Excel File Edit View Insert Format Tools AutoSave OFF SVO Home Insert Draw Page Layout Formulas Data Verdana AA BIUCA x fx Data Window He ACC 2 Review View = 2 Gene EE $ 8,000 Year 10 80 Double-Declining Balance Depreciation 84 Part A: Construct formulas to calculate Depreciation Expense for each year & Accumulated Depreciation and Book Value at the end of each year. 36 Apply the formula without considering whether you've depreciated too much or too little of the asset 88 89 88 89 88 89 &PN Accumulated Depreciation Book Value $62.000 Depreciation Expense 90 1/2/19 Year1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 98 Year 8 99 Year 9 100 Year 10 10 Part B: Using Excel function (fx DDB), determine the depreciation expense for: 104 Year 1 105 Year 9 106 Year 10 Part 2 -- Adjusting Entries & Commentary. Prepare the adjusting journal entry for depreciation on 12/31/19 three different wa Units of Production, and Double Declining Balance. Aoct Titles Debit Adjusting Entry: Straight-Line Adjusting Entry: Units of Prod. Depreciation Template Tools Excel File Edit View Insert Format AutoSave OFF o v o : Home Insert Draw Page Layout Formulas Data Window Help ACC 213 - Chapter 8 Instruction Review View Data Verdana General $ % UA 9 -8 22 NSX fx C D 106 Year 10 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. 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 or incorrect.) Depreciation Template MacBook