Skip to content

syd

Sum-of-years’ digits depreciation.

v = syd(cost, salvage, life, per)

Returns the depreciation for period per using the sum-of-years’ digits method — front-loaded (more depreciation early in the asset’s life).

syd(30000, 7500, 10, 1) % year-1 depreciation
  • sln — Straight-line depreciation.
  • ddb — Double-declining-balance depreciation.