Formula: Subtract, Divide; Cell Referencing 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 areas as indicated Book value at date of change Depreciable cost 3 Using Excel to Computo Revised Depreciation 4 PROBLEM 5 On January 1, 2022, the Hermann Company general ledger shows the 6 following information concerning its equipment 7 8 Equipment $ 35.000 9 Accumulated Depreciation 13,600 10 11 The depreciation resulted from using the straight-line method with the 12 following additional information 13 14 Useful lite 10 years 35 Salvage value $ 2,000 16 On January 1, 2022, the company concludes that the remaining usetul life 18 changes to the following with the same salvage value 19 20 Remaining useful life 21 22 Compute the revised annual depreciation 23 24 25 Revised annual depreciation 2 years