excel

Formula: Subtract, Divide; Cell Referencing Using Excel to Compute Revised Depreciation PROBLEM On January 1, 2022, the Morgantown Company general ledger shows the following information concerning its equipment. Equipment Accumulated Depreciation 32,000 9,000 The depreciation resulted from using the straight-line method with the following additional information. Useful life Salvage value 10 years 2,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 4 years 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. Compute the revised annual depreciation. Book value at date of change Depreciable cost Revised annual depreciation