Visual Basic Financial Function : SLN

Purpose : Use the SLN function to return the straight - line depreciation of an asset.

Syntax :
SLN ( dblInitialCost , dblSalvageValue , dblLifeSpan )

dblInitialCost : Initial cost of the assent.
dblSalvageValue : Salvage value of the asset.
dblLifeSpan : Total life span of the asset.

dblyearlyDepreciation = SLN ( 50000 , 2500 , 10 )

The SLN function returns the depreciation value for an asset. you provide the initial caost of the item , the eventual salvage value ( what it is worth after its useful life span ) , and it s total life span. SLN returns the average depreciation.