ddb Function
Description:
The depreciation of an asset for a specified period 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 | Any period within the life of the asset. |
5 | Number | The rate (usually double) at which the balance declines. |
Example:
When using functions inside a field, remember the field brackets:
{db(VehicleInitialValue, VehicleSalvageValue, VehicleLifeYears, CurrentPeriod, BalanceDeclineRate)}
Expression | Result |
|---|---|
ddb( 2400, 300, 10, 1, 2 ) | 480 |
Related Content
-
Financial Functions
Format:
Article,
1 min read