Visual Basic Financial Function : DDB

Purpose : The DDB function returns the depreciation of an asset based on the double-declining balance method.

Syntax :
DDB ( dblCost, dblSalvage, dblLife, dblPeriod, [ vFactor ] )

dblCost : Initial cost of the asset.
dblSalvage : Salvage value of the cost
dblLife : totla life span of the asset
dblPeriod : Period for which you want to determine the depreciation amount of the asset.
vFactor : The rate at which the balance beclines . This argument is optional.

dblPeriodDepreciation = DDB ( dblItemValue, 0 , 30, dblWhichPeriod )