**Using the Excel VDB Function**

## Summary

The Excel VDB function returns the depreciation of an asset for any specified period. The function includes partial periods, using the double-declining balance method or some other user specified depreciation method. VDB stands for variable declining balance.## Syntax

=VDB (cost, salvage, life, start_period, end_period, [factor], [no_switch])## Syntax Breakdown

**Cost**Required. Initial cost of the asset.

**Salvage**Required. Value at the end of the depreciation period. Also known as salvage value.

**Life**Required. Number of periods over which the asset is depreciated. Also know as the useful life of the asset.

**Start Period**Required. Starting period for which you want to calculate the depreciation. Must be in the same units as life.

**End Period**Required. Ending period for which you want to calculate the depreciation. Must be in the same units as life.

**Factor**Optional. Rate at which the balance declines. If omitted, the argument is assumed to be 2 (double-declining balance method). See the DDB function to learn more about the double-declining balance method.

**No Switch**Optional. Logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.

If TRUE, Excel does not switch to straight-line depreciation even when depreciation is greater than the declining balance.

If FALSE or omitted, Excel switches to straight-line depreciation when depreciation is greater than the declining balance.

## Usage Notes

VDB uses the double-declining balance method or another specified method to return the depreciation of an asset for a given period.

**Other Depreciation Functions**SYD Function: Sum-of-years depreciation method

DB Function: Fixed-declining balance depreciation method

DDB Function: Double-declining balance depreciation method

SLN Function: Straight-line depreciation method