SLN ^v2.6.159
Calculates the straight-line depreciation of an asset for one period.
js
SLN(cost, salvage, life)Parameters
cost- The initial cost of the asset.salvage- The value of the asset at the end of its useful life (salvage value).life- The total number of periods over which the asset is depreciated.
Examples
js
SLN(1000, 100, 5)Result: 180.0
Note: Returns the annual straight-line depreciation of an asset costing 1000 with a 5-year life and 100 salvage value.
js
SLN(5000, 1000, 10)Result: 400.0
Note: Returns the yearly depreciation for an asset that costs 5000, has a salvage value of 1000, and a 10-year useful life.