SLN Function |
Yes
SLN(cost, salvage, life)
cost
Use: Required
Data Type: Double
The initial cost of the asset.
salvage
Use: Required
Data Type: Double
The value of the asset at the end of its useful life.
life
Use: Required
Data Type: Double
The length of the useful life of the asset.
A Double representing depreciation per period.
Computes the straight-line depreciation of an asset for a single period.
The function uses a very simple formula to calculate depreciation:
(cost - salvage) / life
The depreciation period is determined by the time period of life.
All arguments must be positive numeric values.