SYD


Definition of SYD

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

Sample Usage

SYD(100,50,10,2)

SYD(A2,A3,A4,A5)

Syntax

SYD(cost, salvage, life, period)
  • cost - The initial cost of the asset.
  • salvage - The value of the asset at the end of depreciation.
  • life - The number of periods over which the asset is depreciated.
  • period - The single period within life for which to calculate depreciation.

Notes

  • life and period must be measured int he same units.

See Also

SLN: Calculates the depreciation of an asset for one period using the straight-line method.

DDB: Calculates the depreciation of an asset for a specified period using the double-declining balance method.

DB: Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.


To use the RATE Formula, start with the Excellentable you would like to edit.

Screen Shot 2016-05-27 at 12.23.51 PM.png


Then type the RATE formula into the cell you have chosen to display the outcome:

Screen Shot 2016-05-27 at 12.24.06 PM.png

Step 3. Fill in the 2 values

Screen Shot 2016-05-27 at 12.24.26 PM.png

By adding the values you would like to calculate, Excellentable generates the outcome: