Returns the straight-line depreciation of an asset for one period.
Syntax
Copy Code
|
---|
SLN( Number cost, Number salvage, Number life ) → Currency |
Parameters
- cost
- Required. The initial cost of the asset.
- salvage
- Required. The value at the end of the depreciation, also known as the salvage value.
- life
- Required. The number of periods over which the asset is depreciated.
Example
Formula
Copy Code
|
---|
=SLN(10000,4000,10) |
See Also
Function Reference
DDB Function
SYD Function