solve please and write how to use excel formulas like =sum(a1,,b2)

D E F F G 5 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. H J K L IN template. Use mathematical formulas with cell references to the Problem and work area as indicated. 9 10 11 Purchase price of truck Residual value Useful life Using the diminishing-balance method and assuming the depreciation rate is equal to double the straight-line rate, calculate $ 80,000 8,000 4 years a. 12 13 14 For each year of the truck's life Rate 15 16 17 18 January 1 Carrying Amount Depreciation Expense December 31 Carrying Amount Rate 19 2021 0% 20 2022 0% 21 22 23 2023 0% 24 2024 0% 25 26 27 28 29 b. In total over the truck's life Total 30 31