SLN (OriginalCost, SalvageValue, Lifetime) SLN (OriginalCost; SalvageValue; Lifetime)
OriginalCost
Number Number
The initial cost of the asset.
SalvageValue
Number Number
The value at the end of the depreciation (sometimes called the salvage value of the asset).
Lifetime
Number Number
The number of periods (commonly years) over which the asset is being depreciated.
Returns
Number Number
The depreciation of an asset.
Returns the depreciation of an asset in a single period using the straight-line method. The depreciation is the same in every period and equals (OriginalCost - SalvageValue) / Lifetime .
Example
SLN (18000, 3000, 6)
SLN (18000; 3000; 6)
Returns $2,500. An asset that cost $18,000 and has a salvage value of $3,000 loses $15,000 in value over six years, or $2,500 per year.