Skip to main content

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.


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


Step 3. Fill in the 2 values


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

A
B
C
D
1
Cost
Salvage
Life
Period
2
100
50
10
2
3
200
50
10
2
4
300
100
12
3
5
500
100
24
2
6
1000
50
6
4
E
1
SYD
2
8.181818182
3
24.54545455
4
25.64102564
5
30.66666667
6
135.7142857

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.