DDB

Scripting Formulas Finance

FINANCE.DDB

FINANCE.DDB(cost, salvage, life, period, factor = 2)

Calculate the depreciation of an asset using the double-declining balance method.

  • cost: The asset's initial cost.
  • salvage: The value of the asset at the end of depreciation.
  • life: The number of periods over which the asset is depreciated.
  • period: The single period within the asset's life for which to calculate depreciation.
  • factor: The factor by which depreciation decreases. 2 by default.