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

This article applies to: