The Excel VDB function returns the depreciation of an asset for given period, using the double-declining balance method or another method specified by changing the factor argument. By default, the VDB function will switch to straight line calculation. VDB stands for variable declining balance.
Syntax:= VDB (cost, salvage, life, start, end, [factor], [no_switch])
The VDB function syntax has the following arguments:
- Cost Required. The initial cost of the asset.
- Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.
- Life Required. The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
- Start_period Required. The starting period for which you want to calculate the depreciation. Start_period must use the same units as life.
- End_period Required. The ending period for which you want to calculate the depreciation. End_period must use the same units as life.
- Factor Optional. 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.
- No_switch Optional. A logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
- 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.
Example: Let’s look at some Excel VDB function examples and explore how to use the VDB function as a worksheet function in Microsoft Excel:
Syntax: =VDB(B1,B2,B3*365,0,1)
Result:
Based on the Excel spreadsheet above, the following VDB examples would return:
Syntax: =VDB(B1,B2,B3*12,0,1)
Result: $16,666.67
Syntax: =VDB(B1,B2,B3,0,1)
Result: $200,000.00
Syntax: =VDB(B1,B2,B3,1,4)
Result: $487,800.00
Syntax: =VDB(B1,B2,B3,2,6)
Result: $557,118.00
Syntax: =VDB(B1,B2,B3*12,3,9)
Result: $95,511.53
Syntax: =VDB(B1,B2,B3*12,6,10)
Result: $62,613.88
Syntax: =VDB(B1,B2,B3*12,6,18)
Result: $181,725.94
Syntax: =VDB(B1,B2,B3*12,6,18,1.5)
Result: $139,598.29
Syntax: =VDB(B1,B2,B3,0,0.875,1.5)
Result: $131,250.00
Note:
- We need to provide arguments “period” and “life” in the same units of time: years, months, or days.
- All arguments except no_switch must be positive numbers.
- #VALUE! error – Occurs when the given arguments are non-numeric.
- #NUM! error – Occurs when:
- Any of the supplied cost, salvage, start_period, end_period or [factor] arguments are < 0;
- The given life argument is less than or equal to zero;
- The given start_period is > the given end_period; and
- Start_period > life or end_period > life.