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

ArgumentRequired?What it does
costYesWhat the asset cost.
salvageYesIts value at the end of its life (can be 0).
lifeYesIts 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)
AB
1Cost$48,000
2Salvage$6,000
3Life (years)5
4Per year$8,400.00
5Per month$700.00

Common mistakes

  • #DIV/0! error. life is 0 or blank.

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.