VDB

Excel Functions

Depreciation - double-declining variable

Syntax

EXCEL

=VDB(cost, salvage, life, start, end, [factor], [no_switch])

Arguments

Parameter	Description
`cost`	Initial cost of asset.
`salvage`	Asset value at the end of the depreciation.
`life`	Periods over which asset is depreciated.
`start`	Start period.
`end`	End period.
`factor`	[optional] Rate at which the balance declines. If omitted, defaults to 2.
`no_switch`	[optional] Don't switch to straight line. Default is FALSE.

Return Value

Depreciation in given period

Details

The VDB function returns the depreciation of an asset for a given period, using the double-declining balance method or another method specified by changing thefactorargument. By default, the VDB function will switch to straight line calculation when the depreciation value calculated with straight line method is greater than the depreciation value calculated with the double decline balance method. VDB stands for variable declining balance. In the example shown, the formula in C7, copied down, is:

Examples

Example 1

In the example shown, the formula in C7, copied down, is: