Formula: Subtract, Divide; Cell Referencing Using Excel to Compute Revised Depreciation Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this On January 1, 2022, the Hermann Company general ledger shows template. Use mathematical formulas with cell references to the the following information conceming its equipment. Problem and work areas as indicated. EquipmentAccumulatedDepreciation$36,00013,600 Book value at date of change The depreciation resulted from using the straight-line method with Depreciable cost the following additional information. Revised annual depreciation Useful life 10 years Salvage value 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. On January 1, 2022, the Hermann Company general ledger shows the following information concerning its equipment. The depreciation resulted from using the straight-line method with the following additional information. On January 1, 2022, the company concludes that the remaining useful life changes to the following with the same salvage value. 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 Revised annual depreciation