Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .