Excel functions / Financial

DB function

Depreciation for one period, losing the same percentage of the remaining value each period.

Syntax

=DB(cost, salvage, life, period, [month])

Arguments

When to use it

DB gives depreciation by the fixed-declining-balance method: the same percentage of the remaining value each year, so the amounts fall over time. A fifth argument says how many months the asset was owned in the first year.

Examples

  1. The first year, bought in June

    ABCDE
    1CostSalvageLife
    210000001000006186083.33

    In E2: =DB(A2, B2, C2, 1, 7) → 186083.33

    Try this example

  2. The second year

    ABCDE
    1CostSalvageLife
    210000001000006259639.42

    In E2: =DB(A2, B2, C2, 2, 7) → 259639.42

    Try this example

Common mistakes

DB 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 DB in the playground

Related functions