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