I cant figure out the rest of the excel FORMULAS to complete this. I do not need the answers but rather the formulas I would input to excel to get the answers.

D 1 4 C F Name: | Your score: 2 On January 1 of the current year, the A Company purchased equipment for $45,000. The 3 has an estimated useful life of 5 years and an estimated salvage value of $5,000. Comp depreciation schedule below. 5 Each formula in column D must include the DDB function. 6 7 Cost $45,000 Salvage $5,000 Life (in years) 5 10 5 q 8 11 Your formula is incorrect. 12 13 January 1 Year book value 1 $45,000 2 $27,000 3 4 5 Depreciation Accumulated December 31 Expense Depreciation book value $18,000 $18,000 $27.000 $10,800 =15+ 14 15 16 3 17 18 19 $5,000