Formulas Data REVIEW Insert Page Layout Draw Home - ab Wrap Text X A A = = = 0 od y $ % V Merge & Center Paste BIU A F14 x fx V F G E D A B Your score: 40% 1 Name: Aubrey Peck 2 On January 1 of the current year, the Aubrey Peck Company purchased equipment for $45,000. The equipment has an 3 estimated useful life of 5 years and an estimated salvage value of $5,000. Complete the depreciation schedule below. 4 5 Each formula in column D must include the DDB function. 6 7 Cost Salvage Life (in years) $45,000 $5,000 5 8 9 10 11 12 January 1 book value $45,000 Accumulated Depreciation $18,000 December 31 book value Year 1 2 3 4 5 Depreciation Expense $18,000 $10,800 $6,480 $3,888 $832 $5,000 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Instructions ODDB + MacBook Pro esc FI F2 PO F3 F4 F6 F7 @ ! 1 # $ % A 2 3 4 5 6 & 7 W C C