Use the appropriate function in Excel to calculate the annual straight-line (SL) depreciation charge for an asset

Question:

Use the appropriate function in Excel to calculate the annual straight-line (SL) depreciation charge for an asset that has a $10,000 acquisition cost, a salvage value of $500, and a useful life of four years.

Salvage Value
Salvage value is the estimated book value of an asset after depreciation is complete, based on what a company expects to receive in exchange for the asset at the end of its useful life. As such, an asset’s estimated salvage value is an important...