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