How to Calculate SLN Depreciation
Last updated: 2026-09-06
⚡ Quick Answer
The SLN function calculates the straight-line depreciation of an asset for a single period.
=SLN(Cost, Salvage, Life)📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =SLN(Cost, Salvage, Life)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | Initial Cost | $50,000 | =SLN(50000, 5000, 10) | - |
| 2 | 2 | Salvage Value | $5,000 | — | - |
| 3 | 3 | Useful Life | 10 Years | Output Result | $4,500 / year |
🧠 Deep Dive
The SLN function calculates the straight-line depreciation of an asset for a single period.
Key Insights
- Signed cash flows: outflows are negative, inflows are positive.
- Rates must match the period (annual rate / 12 for monthly).
Common Mistakes
- Passing annual rate directly to PMT.
- Forgetting minus sign on present value.
Pro Tips
- Build a small input block with named cells.
- Format currency after math.
FAQ
What does this formula do in plain English?
The SLN function calculates the straight-line depreciation of an asset for a single period.
Why is my formula not working?
Passing annual rate directly to PMT.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Forgetting minus sign on present value.
Related Guides
How to Calculate CAGR in ExcelHow to Calculate IRR in ExcelHow to Calculate NPV in ExcelHow to Calculate Loan Payments (PMT)Excel Error Hub
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)