WorksheetFunction.Vdb Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 DoubleParameters
- 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.