db Function

Description:

The depreciation of an asset for a specified period using the fixed-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	Whole Number	The number of months in the first year.

Example:

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

{db(VehicleInitialValue, VehicleSalvageValue, VehicleLifeYears, CurrentPeriod, MonthsInFirstYear)}

Expression	Result
db( 1000000, 100000, 6, 1, 7 )	186083.33

This article applies to: