need help with the following. please provide formulas and cell referencing

A C D E F G H K 1 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. 8 Book value at date of change Depreciable cost 2. 3 Using Excel to Compute Revised Depreciation 4 PROBLEM 5 On January 1, 2022, the Hermann Company general ledger shows the following 6 information concerning its equipment. 7 Equipment $ 36,000 9 Accumulated Depreciation 13,600 10 11 The depreciation resulted from using the straight-line method with the following 12 additional information. 13 14 Useful life 15 Salvage value $ 2,000 16 17 On January 1, 2022, the company concludes that the remaining useful life changes to 18 the following with the same salvage value. 19 Remaining useful life 2 years 21 22 Compute the revised annual depreciation. 23 24 Revised annual depreciation 10 years 20