SYD Function (sum-of-years depreciation)

Returns a value specifying the sum-of-years digits depreciation

Description of the function SYD


Returns a value specifying the sum-of-years digits depreciation of an asset for a specified period.

The Life and Period arguments must be expressed in the same units. For example, if Life is given in months, Period must also be given in months. All arguments must be positive numbers.


Sum-of-years depreciation calculator

 Input
Initial cost
Worth at end of life
Useful life
Calculated period
Decimal places
  Depreciation for a period
Result

Example

Description of the parameters


Initial cost

The initial cost of the asset.


Worth at end of life

The value of the asset at the end of its useful life.


Useful life

The length of the useful life of the asset.


Calculated period

The period for which asset depreciation is calculated.


Is this page helpful?            
Thank you for your feedback!

Sorry about that

How can we improve it?