SYD Function in Excel: Syntax, Examples and Free Practice
SYD is an Excel Financial function. Returns sum-of-years' digits depreciation for a period.
SYD syntax
Arguments
cost: The initial cost of the assetsalvage: The value of the asset at the end of its lifelife: The useful life of the assetper: Which period to calculate for
When to use SYD
SYD is used in loan, investment, or valuation models where precise financial math is required.
Practice SYD online, free
Open the live Excel-style spreadsheet and try SYD yourself. No Excel install or sign-up needed to start.
Practice SYD now →More Financial functions
Frequently asked questions
What does the SYD function do in Excel?
Returns sum-of-years' digits depreciation for a period.
What is the syntax of SYD in Excel?
The syntax is =SYD(cost, salvage, life, per). cost: The initial cost of the asset; salvage: The value of the asset at the end of its life; life: The useful life of the asset; per: Which period to calculate for.
Where can I practice SYD online for free?
Open the free live spreadsheet on Cellgrids and try SYD yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts