Edit

Share via


WorksheetFunction.Vdb Method

Definition

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

public double Vdb (double Arg1, double Arg2, double Arg3, double Arg4, double Arg5, object Arg6, object Arg7);
Public Function Vdb (Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, Arg5 As Double, Optional Arg6 As Object, Optional Arg7 As Object) As Double

Parameters

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
Object

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(Double, Double, Double, Double, Object).

Arg7
Object

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

Returns

Remarks

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.

Applies to