vdb Function

Description:

The depreciation of an asset for a range of periods using the double-declining-balance method.

Returns:

Number

Parameters:

Parameter	Data Type	Description
1	Number	The initial value of the asset.
2	Number	The salvage value at the end of its useful life.
3	Whole Number	The useful life of the asset in years.
4	Whole Number	The start period within the life of the asset.
5	Whole Number	The finish period within the life of the asset.
6	Number	The rate (usually double) at which the balance declines.

Example:

When using functions inside a field, remember the field brackets:

{vdb(VehicleInitialValue, VehicleSalvageValue, VehicleLifeYears, VehicleFinanceStartPeriod, VehicleFinanceEndPeriod, BalanceDeclineRate)}

Expression	Result
vdb( 2400, 300, 10, 0, 3, 2 )	1171.2

This article applies to: