A B C Using Excel to Calculate Double-Diminishing-Balance Depreciation Purchase price of truck Residual value Useful life D PROBLEM

Audio Systems purchased a delivery truck on January 1, 2024. The company has a December 31 year end. Additional information concerning the truck follows. $ 80,000 8,000 Enter Answer E 4 years + F G H L 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. b. Using the diminishing-balance method and assuming the depreciation rate is equal to double the straight-line rate, calculate the depreciation: a. For each year of the truck's life Rate 2021 2022 2023 2024 K January 1 Carrying Amount Total In total over the truck's life Answer Field 7.2% of your score. Formula: Divide, Multiply. Input a mathematical formula with cell the Dam Rate 0% 0% N 0% 0% Depreciation Expense Carrying Amount P Q R S

Required: Frovide input into cells shaded in yellow in this template. Use PROBLEM mathematical formulas with cell references to the Problem and work area as indicated. Aadio Systems purchased a dellvery buck on January 1, 2024. The compary has a December 31 vear end. Additional information concerning the truck follows. Using the diminishing balance method and assuming the depreciation rate is equal to double the straight-line rate, calculate the depreciation: 4. For each year of the truck's life b. In total over the trucks life Using the diminishing-balance method and assuming the depreciation rate is equal to double the straight-line rate, calculate the depreciation: b. In total over the truck's life