correct ans with excel formula like how to write ans use formulas of excel

Tell me what you want to do C14 X for A B D E F H 1 1 Function: SUM; Formula: Divide, Subtract, Multiply; Cell Referencing N 0 2 5 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work area as indicated. 3 BE9.6 Using Excel to Calculate Double-Diminishing- 4 Balance Depreciation PROBLEM 6 Buckingham Ltd. purchased a delivery truck on January 1, 7 2021. Buckingham has a December 31 year end. Additional 8 information concerning the truck follows. 9 10 Purchase price of truck $ 80,000 11 Residual value 8,000 Useful life 4 years Using the diminishing-balance method and assuming the depreciation rate is equal to double the straight-line rate, calculate 12 a. For each year of the truck's life 13 Rate 14 15 16 January 1 Carrying Amount Depreciation Expense December 31 Carrying Amount 18 Rate 0% 19 2021 2022 0% 20 21 22 23 24 25 2023 0% 2024 0% b. In total over the truck's life 26 27 28 29 BO 31 Total