Excel functions / Financial

VDB function

Depreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.

Syntax

=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

Arguments

When to use it

VDB gives declining-balance depreciation between any two points in an asset's life, including part periods, and switches to straight-line once that gives more, as tax rules often require.

Examples

  1. The first year

    ABCDE
    1CostSalvageLife
    2240030010480

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

    Try this example

  2. From month 6 to month 18, at 1.5 times the straight-line rate

    ABCDE
    1CostSalvageLife
    2240030010311.81

    In E2: =VDB(A2, B2, C2*12, 6, 18, 1.5) → 311.81

    Try this example

Common mistakes

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

Related functions