SLN Function
Calculates straight-line depreciation for one period.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Depreciation per period
Want to practice SLN 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
SLN spreads an asset's cost, less its salvage value, evenly over its life: (cost − salvage) ÷ life.
It's the simplest and most common depreciation method.
Syntax
=SLN(cost, salvage, life) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| cost | Yes | What the asset cost. |
| salvage | Yes | Its value at the end of its life (can be 0). |
| life | Yes | Its useful life, in periods. |
Examples
Example 1 — Depreciating the delivery van
Northstar's delivery van cost $48,000 and should be worth $6,000 after five years.
B4fx=SLN(B1,B2,B3)
| A | B | |
|---|---|---|
| 1 | Cost | $48,000 |
| 2 | Salvage | $6,000 |
| 3 | Life (years) | 5 |
| 4 | Per year | $8,400.00 |
| 5 | Per month | $700.00 |
Common mistakes
- #DIV/0! error. life is 0 or blank.
Notes

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.