SYD Function
Calculates sum-of-years'-digits depreciation for a period.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Depreciation for a period
Want to practice SYD in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
SYD front-loads depreciation: for a 5-year life the years are weighted 5, 4, 3, 2, 1 out of a total of 15.
Total depreciation still equals cost − salvage, just with more in the early years.
Syntax
=SYD(cost, salvage, life, per) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| cost | Yes | What the asset cost. |
| salvage | Yes | Its value at the end of its life (can be 0). |
| life | Yes | Its useful life, in periods. |
| per | Yes | The period to calculate (1 to life). |
Examples
Example 1 — Van depreciation year by year
Northstar's delivery van cost $48,000 and should be worth $6,000 after five years.
B2fx=SYD(48000,6000,5,A2)
| A | B | |
|---|---|---|
| 1 | Year | Depreciation |
| 2 | 1 | $14,000.00 |
| 3 | 2 | $11,200.00 |
| 4 | 3 | $8,400.00 |
| 5 | 4 | $5,600.00 |
| 6 | 5 | $2,800.00 |
Year 1 is 5/15 of the $42,000 to depreciate; the five years add up to $42,000.
Common mistakes
- #NUM! error. per must be between 1 and life.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.