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 |
Related Content
-
Financial Functions
Format:
Article,
1 min read