Skip to content

sln

Straight-line depreciation.

v = sln(cost, salvage, life)

Returns (cost - salvage) / life — equal depreciation per period over the asset’s life.

sln(30000, 7500, 10) % $2250/year
  • syd — Sum-of-years’ digits depreciation.
  • ddb — Double-declining-balance depreciation.
  • vdb — Variable-declining-balance depreciation between two periods.