DDB

Returns the calculated depreciation allowance on an asset at a specific period of time using the double declining balance method.

Syntax:

DDB(cost:number, salvage:number, life:number, period:number {, factor:number})

where:

cost is the original value;
salvage is the value at the end of the life;
life is the number of periods for which you want to calculate the depreciation allowance;
period is the period for which the depreciation is being measured;
factor is the rate at which the balance declines. Default is 2 (two).

Example:

What is the depreciation allowance of a £5000 asset with a salvage value of £1000 one year into its five-year depreciation?

The formula

DDB(5000, 1000, 5, 1)

returns the number 2000 (pounds).

Revisions:

Starting with 2.00, this function will accept an extra optional parameter, factor. The default factor is two.