📎 This article includes 1 downloadable practice file ↓
In this article
SYD is another accelerated method, gentler than DDB. For a 5-year life the fractions are 5/15, 4/15, 3/15 and so on.
Syntax
=SYD(cost, salvage, life, per)| Argument | What it means |
|---|---|
per |
Year number. |
Examples
Example 1
=SYD(90000, 10000, 5, 1)Year 1: 80,000 × 5/15 = ₹26,667.
SYD in practice
Where you will use it
- Sum-of-years depreciation
- Accelerated write-off
- Compare with SLN
Worked example
| Year | Formula | Result |
|---|---|---|
| 1 | =SYD(500000,50000,5,A2) | ₹ 1,50,000.00 |
| 2 | =SYD(500000,50000,5,A3) | ₹ 1,20,000.00 |
| 5 | =SYD(500000,50000,5,A4) | ₹ 30,000.00 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Year beyond life | #NUM! |
| Indian tax | Use WDV rates for income tax |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
⚡ Interactive Practice Lab & Formula Tester:
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Financial: EMI, SIP, NPV, IRR, depreciation23 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 35 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong