Formulas for excel

2 On January 1 of the current year, the A Company purchased equipment for $45,000. The equipment 3 has an estimated useful life of 5 years and an estimated salvage value of $5,000. Complete the 4 depreciation schedule below. 5 Each formula in column D must include the DDB function. 6 7 Cost $45,000 8 Salvage $5,000 9 Life (in years) 5 10 11 12 January 1 Depreciation Accumulated December 31 13 Year book value Expense Depreciation book value 1 $45,000 $18,000 $18,000 $27,000 15 2 $27,000 $10.800 16 3 17 18 5 $5,000 19