DDB function
DDB returns an asset's depreciation for one period using the declining-balance method, at an adjustable multiple of the straight-line rate. Early periods get the biggest write-offs, and book value never drops below salvage.
Example
Read it as a sentence: for an asset that cost $10,000 and is worth $1,000 after 5 years, find the double-declining-balance depreciation for year 2, which gives 2,400.
Syntax
DDB(cost, salvage, life, period, [factor])
Arguments in [square brackets] are optional.
-
cost(required) - Initial cost of the asset.
-
salvage(required) - Value at the end of its life.
-
life(required) - Number of periods the asset is depreciated over.
-
period(required) - Period to calculate, in the same unit as life.
-
factor(optional) - Rate multiplier; 2 (double-declining) if omitted.
Returns: Depreciation for one period using declining balance with an adjustable factor.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=DDB(2400,300,10,1) | $480.00 | Year 1 |
=DDB(2400,300,10,1,1.5) | $360.00 | Factor 1.5 |
=DDB(2400,300,10,10) | $22.12 | Last year |
=DDB(2400,300,10,1.5) | $429.33 | Fractional period |
=DDB(1000,2000,5,1) | $0.00 | Salvage > cost |
=DDB(1000,0,5,1) | $400.00 | Salvage 0 |
=DDB(2400,300,10,11) | #NUM! | Period > life |
=DDB(2400,300,10,0) | #NUM! | Period 0 |
Watch out for
- It does not switch to straight-line late in life; VDB does that.
- Period and life must use the same unit.
Where it works
- Excel
- DDB is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .