Visual Basic Financial Function : SYD

Purpose : The SYD function returns the sum-of-years digits depreciation of an asset.

Syntax :
SYD ( dblInitialCost , dblSalvageValue , dblLifeSpan , dblPeriod )

dblInitialCost : Initial cost of the asset.
dblSalvageValue : Salvage value of the asset.
dblLifeSpan : Total life span of the asset.
dblPeriod : Sequential number representing the current period

For i = 1 to 10
Print SYD ( 10000 , 800 10 , i )
Next i

This function returns the depreciation value for a given period using the sum-of-year' digits algorithm. This gives a weighted depreciation schedule . with a greated amount of depreciation in the beginning than that of the SLN depreciation.