- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Financial - VDB Function
Description
The VDB function 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.
Syntax
VDB (cost, salvage, life, start_period, end_period, [factor], [no_switch])
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Cost | The initial cost of the asset. | Required |
| Salvage | The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0. |
Required |
| Life | The number of periods over which the asset is depreciated (sometimes called the useful life of the asset). | Required |
| Start_period | The starting period for which you want to calculate the depreciation. Start_period must use the same units as life. |
Required |
| End_period | The ending period for which you want to calculate the depreciation. End_period must use the same units as life. |
Required |
| 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 doubledeclining balance method. For a description of the double-declining balance method, refer DDB Function. |
Optional |
| No_switch | 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, 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. |
Optional |
Notes
All arguments except no_switch must be positive numbers.
If any of the specified cost, salvage, start_period, end_period or [factor] arguments is < 0, VDB returns #NUM! error.
If the specified life argument is ≤ 0, VDB returns #NUM! error.
If the specified start_period is > the supplied end_period, VDB returns #NUM! error.
If start_period > life or end_period > life, VDB returns #NUM! error.
If any of the specified arguments is non-numeric, VDB returns #VALUE! Error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
