Formula: Subtract, Divide; Cell Referencing Using Excel to Compute Revised Depreciation Student Work Area + Required: Provide input into cells shaded in yellow in this template. Use On January 1, 2022, the Hermann Company general ledger shows the mathematical formulas with cell references to the Problem and work areas l following information concerning its equipment. as indicated. ___. l Equipment 5 36,000 l' Accumulated Depreciation 13,600 Book value at date of change i The depreciation resulted from using the straight-line method with the Depreciabie C05! l l following additional information. .1 l Revised annual depreciation 'l Useful life 10 years i Salvage value $ 1,000 ' On January 1, 2022, the company concludes that the remaining useful life changes to the following with the same salvage value. Remaining useful life 2 years ' ' Compute the revised annual depreciation