DDB

Formulas / DDB
Calculate depreciation of an asset.
=DDB(cost, salvage, life, period, [factor])
  • Cost - required
  • Salvage - required
  • Life - required
  • Period - required
  • Factor - required

Examples

  • =DDB(A2,A3,A4*365,1)

    The DDB function can be used to calculate the first day's depreciation using the double-declining balance method. This means that the formula will use the values in cells A2, A3 and A4 multiplied by 365 to calculate the first day's depreciation.

  • =DDB(A2,A3,A4,1,2)

    The DDB function can also be used to calculate the depreciation for year one. This means that the formula will use the values in cells A2, A3 and A4, along with the value 1, to calculate the depreciation for year one.

  • =DDB(A2,A3,A4,2,1.5)

    The DDB function can also be used to calculate the second year's depreciation using a factor of 1.5 instead of the double-declining balance method. This means that the formula will use the values in cells A2, A3 and A4, along with the value 2 and a factor of 1.5, to calculate the second year's depreciation.


Summary

The DDB function calculates depreciation for an asset and requires the cost, salvage, life, period, and factor arguments. The life and period arguments must use the same units and all arguments must be positive numbers.

  • The DDB function uses the MIN formula to calculate depreciation in a given period.
  • The factor argument of the DDB function can be changed to use a different method of calculating depreciation.

Frequently Asked Questions

What is the DDB Function?
The DDB Function is used to calculate depreciation for an asset using a double-declining balance method.
What are the parameters of the DDB Function?
The DDB Function requires five arguments:
  • Cost of the asset
  • Salvage value of the asset
  • Life of the asset
  • Period
  • Factor
Do the input parameters for the DDB Function have to be positive numbers?
Yes, all five arguments must be positive numbers.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV