Skip to content
Excel

DDB function in Excel

Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify

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

DDB syntax and parameters

Five arguments, four required.

  • costnumberRequired

    The initial cost of the asset.

  • salvagenumberRequired

    The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.

  • lifenumberRequired

    The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

  • periodnumberRequired

    The period for which you want to calculate the depreciation. Period must use the same units as life.

  • factornumberOptional

    The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method).

DDB examples

Formulas you'll actually reuse.

  1. Double-declining balance, year 1 — twice the straight-line rate on the full cost:

    =DDB(24000, 4000, 5, 1)

    Result9600

  2. Year 2 — the same rate on what's left:

    =DDB(24000, 4000, 5, 2)

    Result5760

DDB in Google Sheets

Same name — your formula ports as-is.

Try DDB in the playground

Edit the example — nothing to install.

Preloaded with the DDB formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.