DDB

This method specifies the depreciation of an asset for a specific time period using the double-declining balance method.

Syntax

financial.DDB(cost, salvage, life, period, factor)

Parameters

financial

Reference to a Finance control.

cost

Required. Variant that specifies the initial cost of an asset.

salvage

Required. Variant that specifies the value of an asset at the end of its useful life.

life

Required. Variant that specifies the length of the useful life of an asset.

period

Required. Variant that specifies the period for which an asset depreciation is calculated.

factor

Required. Variant that specifies the rate at which the balance declines.

Return Value

Double. Result of the DDB calculation.

Remarks

You must express the life and period parameters in the same units. For example, if you specify life in months, you must also specify period in months. All parameters must be positive numbers.

The following code example shows how to use the DDB method to calculate depreciation for a specified period.

Depreciation / period = ((cost – salvage) * factor) / life