SYD

Scripting Formulas Finance

FINANCE.SYD

 FINANCE.SYD(cost, salvage, periods, period)

Calculates the depreciation of an asset for a specified period using the sum of years digits method.

  • cost: The initial cost of the asset.
  • salvage: The value of the asset at the end of depreciation.
  • periods: Number of periods over which the asset is depreciated.
  • period: A s ingle period within periods for which to calculate depreciation.