Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SYD
SYD allocates depreciation based on a fraction whose numerator is the remaining life and denominator is the sum of all years' digits. It depreciates faster than straight-line but more gradually than double-declining balance, suitable for assets that lose value rapidly but not as steeply.
Excel
=SYD(20000,2000,5,1)Google Sheets
=SYD(20000,2000,5,1)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Parameter | Value |
| Cost | 20000 |
| Salvage | 2000 |
| Life | 5 |
| Period | 2 |
=SYD(20000,2000,5,1)→6000
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Supply the asset cost, salvage value, useful life in years, and the specific period (1 = first year).
- 2Enter =SYD(cost, salvage, life, per) — Excel computes the sum of digits automatically.
- 3Repeat for each period to build a full depreciation schedule.
Need a version for your data?
Try: “What is the sum-of-years'-digits depreciation for year 2 on a $20,000 asset with a $2,000 salvage over 5 years?”