FinSln

Syntax

FinSln(Cost,Salvage,Life)

Description

Returns the straight-line depreciation of an asset assuming constant benefit from the asset.

The FinSln 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 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.

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.

See Also

FinSYD, FinDDB.

Example

Sub Main
'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.
 
    dep# = Sln(10000.00,500.00,10)
    MsgBox "The annual depreciation is: " & _
			Format(dep#,"###,###,##0.00")
End Sub