Excel functions / Financial

DDB function

Depreciation for one period at double the straight-line rate (or another multiple).

Syntax

=DDB(cost, salvage, life, period, [factor])

Arguments

When to use it

DDB gives depreciation by the double-declining-balance method: twice the straight-line rate, applied to what is left each period. It writes an asset down fastest at the start. A fifth argument changes the factor from 2.

Examples

  1. The first year

    ABCDE
    1CostSalvageLife
    2240030010480

    In E2: =DDB(A2, B2, C2, 1) → 480

    Try this example

  2. The first day, counting the life in days

    ABCDE
    1CostSalvageLife
    22400300101.32

    In E2: =DDB(A2, B2, C2*365, 1) → 1.32

    Try this example

Common mistakes

DDB in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try DDB in the playground

Related functions