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

ArgumentRequired?What it does
costYesWhat the asset cost.
salvageYesIts value at the end of its life (can be 0).
lifeYesIts useful life, in periods.
perYesThe 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)
AB
1YearDepreciation
21$14,000.00
32$11,200.00
43$8,400.00
54$5,600.00
65$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

Kyle Stott

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.