SLN
Name
Straight-line depreciation
Description
Returns the straight-line depreciation of an asset for one period.
Syntax
SLN(Cost, Salvage, Life)
Remarks
Arguments are as follows:
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 |
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
SLN(R1C2,1000,10)
SLN(500000,20000,5)=96000