SLN Function |
Named Arguments
Yes
Syntax
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.
Return Value
A Double representing depreciation per period.
Description
Computes the straight-line depreciation of an asset for a single period.
Rules at a Glance
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.
See Also
- DDB Function, SYD Function
Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.