SYD function
SYD returns sum-of-years'-digits depreciation for one period. It gives accelerated depreciation that falls steadily each year, based on the sum of the years in the asset's life.
Example
Read it as a sentence: find the first year's sum-of-years depreciation on a $30,000 asset with a $7,500 salvage value over 10 years, which gives $4,090.91.
A
B
C
D
1
$4,090.91
2
3
Syntax
SYD(cost, salvage, life, per)
-
cost(required) - Initial cost of the asset.
-
salvage(required) - Value at the end of its life.
-
life(required) - Number of periods of use.
-
per(required) - Period to calculate (1 is first).
Returns: Sum-of-years'-digits depreciation for one period.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SYD(30000,7500,10,1) | $4,090.91 | Year 1 |
=SYD(30000,7500,10,10) | $409.09 | Last year |
=SYD(1000,2000,5,1) | ($333.33) | Salvage > cost |
=SYD(30000,7500,10,1.5) | $3,886.36 | Fractional per |
=SYD("30000","7500","10","1") | $4,090.91 | Text number |
=SYD(30000,7500,10,{1,2,3}) | $4,090.91 | Spill |
=SYD(30000,7500,10,0) | #NUM! | Per 0 |
=SYD(30000,7500,10,11) | #NUM! | Per > life |
Watch out for
- per and life must use the same unit.
Where it works
- Excel
- SYD is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .