AutoSave OH ARG - Lab 3 - Depreciation Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 20 ~AA = = Wrap Text General > Autosum KO X Cut Copy * Format Insert Delete Dclcte Format Paste B TV RY AY = = = -- Merge & Center S % ) Fill Clear Conditions Forma: Cell Formatting as Table Styles 0 Sort & Filter Find Select Analyze Data ci x. fx G T i N P A 5 24 25 Double Declining Balance 26 Depreciable Cost Depreciation Percentage Depreciation Expense Accumulated Depreciation 37 Year Net Book Value 23 1 2 3 20 21 4 5 22 33 14 Units of Production 16 17 28 Depreciation Rate Per Unit Depreciable Year Cost 1 2 3 Depreciation Expense Accumulated Depreciation Net Book Value 29 10 41 12 115 4 44 5 45 16 47 49 501 51 52 53 55 56 57 58 59 60 Problem 1 Problem 2 + Ready , + 90W AutoSave OH ARG - Lab 3 - Depreciation Drawi View Tell me Share Comments 2 Wrap Textv General > Autosum KO SIX Insert Dolce Dclcte Format y $ --- Merg & Center Home Insert Page Layout Formulas Data Review X Cut Calibri (Body) v 20 VA = = - Copy Paste B II * Format - * A a X. A Depreciation Practice Problems Vehicle 5 % 0 Fill Clear Conditions Forma: Cell Formatting as Table Styles Sort & Filter Find Select Analyze Data D G T T N P A 5 Acquisition Date Asset Cost 5 Salvage Value Useful Years Units (Miles Driven) Year 1 9 Year 2 10 Year 3 11 Year 4 12 Year 5 13 1/2/21 35,000.00 5,000.00 5 120000 28800 32400 25900 17600 15300 B 14 15 Straight Line Depreciation 16 Depreciable Cost Depreciation Expense Accumulated Depreciation Net Book Value 17 Year 11 1 2 3 20 21 4 5 22 23 25 Double Declining Balance 26 Depreciable Cost Depreciation Percentage Depreciation Expense Accumulated Depreciation Year Net Book Value 3R 29 1 2 3 4 20 31 32 5 23 Problem 1 Problem 2 + Ready + 90W