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