SLN function
SLN(OriginalCost,
SalvageValue, Lifetime) SLN(OriginalCost;
SalvageValue; Lifetime)
OriginalCost
Number or { Number }
The initial cost of the asset.
SalvageValue
Number or { Number }
The value at the end of the depreciation (sometimes called the salvage value of the asset).
Lifetime
Number or { Number }
The number of periods (commonly years) over which the asset is being depreciated.
Returns
Number or { Number }
The depreciation of an asset.
Returns the depreciation of an asset in a single period using the straight-line depreciation method.
Example
SLN(14000, 4000,
5)SLN(14000; 4000;
5)
Returns $2,000. The asset depreciates $2,000 in each of the five years of its working life.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.