# SYD

### [data-colorid=mh1dr8kmud]{color:#212121} html[data-color-mode=dark] [data-colorid=mh1dr8kmud]{color:#dedede}[data-colorid=vz47zyhheh]{color:#212121} html[data-color-mode=dark] [data-colorid=vz47zyhheh]{color:#dedede}[data-colorid=h3nhti36hh]{color:#212121} html[data-color-mode=dark] [data-colorid=h3nhti36hh]{color:#dedede}[data-colorid=jxkdy7ist4]{color:#212121} html[data-color-mode=dark] [data-colorid=jxkdy7ist4]{color:#dedede}[data-colorid=ogwvgl5fe1]{color:#212121} html[data-color-mode=dark] [data-colorid=ogwvgl5fe1]{color:#dedede}[data-colorid=b72c8s1l69]{color:#212121} html[data-color-mode=dark] [data-colorid=b72c8s1l69]{color:#dedede}[data-colorid=gkyc7w4fsv]{color:#212121} html[data-color-mode=dark] [data-colorid=gkyc7w4fsv]{color:#dedede}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.

`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.

### 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