|
Syntax
|
Sln
(Cost,Salvage,Life)
|
|
Description
|
Returns the straight-line depreciation of an asset assuming constant benefit from the asset.
|
|
Comments
|
The
Sln
of an asset is found by taking an estimate of its useful life in years, assigning values to each year, and adding up all the numbers.
The formula used to find the
Sln
of an asset is as follows:
(Cost - Salvage Value) / Useful Life
The
Sln
function requires the following parameters:
|
|
|
Parameter
|
Description
|
|
|
Cost
|
Double representing the initial cost of the asset.
|
|
|
Salvage
|
Double representing the estimated value of the asset at the end of its useful life.
|
|
|
Life
|
Double representing the length of the asset's useful life.
|
|
|
The unit of time used to express the useful life of the asset is the same as the unit of time used to express the period for which the depreciation is returned.
|
|
Example
|
This example calculates the straight-line depreciation of an asset that cost $10,000.00 and has a salvage value of $500.00 as scrap after 10 years of service life.
Sub Main()
dep# = Sln(10000.00,500.00,10)
MsgBox "The annual depreciation is: " & Format(dep#,"Currency")
End Sub
|
|
See Also
|
SYD (function); DDB (function).
|
|
|
|
|
CIMPLICITY
