WorksheetFunction.Vdb (Excel)

Returns the depreciation of an asset for any period that you specify, including partial periods, by using the double-declining balance method or some other method that you specify. Vdb stands for variable declining balance.

If no_switch is True, Microsoft Excel does not switch to straight-line depreciation even when the depreciation is greater than the declining balance calculation. If no_switch is False or omitted, Excel switches to straight-line depreciation when depreciation is greater than the declining balance calculation. All arguments except no_switch must be positive numbers.

Vdb (Arg1, Arg2, ..., Arg7)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblArg4 As Double: dblArg4 = 
Dim dblArg5 As Double: dblArg5 = 
Dim dblVdb As Double
dblVdb = WorksheetFunction.Vdb(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3, Arg4:=dblArg4, Arg5:=dblArg5)

Arguments

Arg1 (Double) - Cost - the initial cost of the asset.

Arg2 (Double) - Salvage - the value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.

Arg3 (Double) - Life - the number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

Arg4 (Double) - Start_period - the starting period for which you want to calculate the depreciation. Start_period must use the same units as life.

Arg5 (Double) - End_period - the ending period for which you want to calculate the depreciation. End_period must use the same units as life.

Arg6 - Factor - the rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method). Change factor if you do not want to use the double-declining balance method. For a description of the double-declining balance method, see Ddb

Arg7 - No_switch - a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation