April 2002
Intermediate to advanced
688 pages
19h 51m
English
SLN Function
Microsoft.VisualBasic.Financial
SLN(cost,salvage,life)
cost (required; Double)The initial cost of the asset
salvage (required; Double)The value of the asset at the end of its useful life
life (required; 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.
Read now
Unlock full access