Scripting Formulas Finance


FINANCE.DB(cost, salvage, life, period, month = 12)

Calculate the depreciation of an asset for a specified period using the arithmetic declining balance method.

  • cost: Initial cost of the asset.
  • salvage: The asset's value 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.
  • month: The number of months in the first year of depreciation. 12 by default.