Excel functions / Financial
SYD function
Sum-of-years’ digits depreciation: more in the early periods, less in the late ones.
Syntax
=SYD(cost, salvage, life, per)
Arguments
cost: What the asset cost.salvage: What it is worth at the end.life: How many periods it is used for.per: Which period to get the depreciation for.
When to use it
SYD gives depreciation by the sum-of-years' digits method: more in the early years, less later, in a straight-line decline. For a 10-year life, the first year takes 10/55 of the cost less salvage, the second 9/55, and so on.
Examples
The first year
A B C D E 1 Cost Salvage Life 2 30000 7500 10 4090.91 In E2:
=SYD(A2, B2, C2, 1)→ 4090.91The last year
A B C D E 1 Cost Salvage Life 2 30000 7500 10 409.09 In E2:
=SYD(A2, B2, C2, 10)→ 409.09
Common mistakes
- Period out of range. The period must be between 1 and the life.
SYD in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ODPIS.NELIN
- Danish: ÅRSAFSKRIVNING
- Dutch: SYD
- Finnish: VUOSIPOISTO
- French: SYD
- German: DIA
- Hungarian: ÉSZÖ
- Italian: AMMORT.ANNUO
- Norwegian: ÅRSAVS
- Polish: SYD
- Portuguese (Brazil): SDA
- Portuguese (Portugal): AMORTD
- Russian: АСЧ
- Spanish: SYD
- Swedish: ÅRSAVSKR
- Turkish: YAT
Related functions
- SLN: Straight-line depreciation: the same loss of value every year.
- DDB: Depreciation for one period at double the straight-line rate (or another multiple).
- DB: Depreciation for one period, losing the same percentage of the remaining value each period.
- VDB: Depreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.