Formula Functions > Functions R to S > SLN |
This function returns the straight-line depreciation of an asset for one period.
SLN(cost,salvage,life)
This function has these arguments:
Argument | Description |
---|---|
cost | Initial cost of the asset |
salvage | Value at the end of the depreciation |
life | Number of periods over which the asset is being depreciated |
Accepts numeric data for all arguments. Returns numeric data.
SLN(B1,1000,10)
SLN(R1C2,1000,10)
SLN(500000,20000,5) gives the result $96,000
This function is available in product version 1.0 or later.
DB | DDB | SYD | Financial Functions