syd
Sum-of-years’ digits depreciation.
Syntax
Section titled “Syntax”v = syd(cost, salvage, life, per)Description
Section titled “Description”Returns the depreciation for period per using the sum-of-years’ digits method — front-loaded (more depreciation early in the asset’s life).
Example
Section titled “Example”syd(30000, 7500, 10, 1) % year-1 depreciation