VDB

This function returns the depreciation of an asset for any period you specify using the variable declining balance method.

Syntax

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

This function has these arguments:

Argument	Description
cost	[Required] Initial cost of the asset
salvage	[Required] Value at the end of the depreciation period
life	[Required] Number of periods over which the asset is being depreciated
start	[Required] Number representing the starting period for which to calculate the depreciation in the same units as life; if not an integer, the number is truncated
end	[Required] Number representing the ending period for which to calculate the depreciation in the same units as life; if not an integer, the number is truncated
factor	[Optional] Rate at which the balance declines; if omitted, uses two (2)
switchnot	[Optional] Logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation; if omitted uses FALSE

If factor is omitted, the calculation uses two, which represents the double‑declining balance method. For other methods, use a different value.

For more information about the double‑declining balance method, see DDB.

VDB(B1,1000,10,1,8)

VDB(50000,500,1200,100,1000,1) gives the result of 37,122.94