ExcelFlux

SLN function

the straight-line depreciation of an asset for one period.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Calculate straight-line depreciation per period. Equal cost and salvage imply no depreciation.

A worked example from the workbook

RowABC
6CostSalvageLife
712002005
890003
95005005
Record 1
=SLN(A7,B7,C7)

Expected result200

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=SLN(1200,200,5)
Turkish Excel · tr-TR
=DA(1200;200;5)

Expected result

200

Worked examples

Calculate straight-line depreciation per period. Equal cost and salvage imply no depreciation.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Cost Salvage Life
7 1200 200 5
8 900 0 3
9 500 500 5
Case Formula Expected result
Record 1 =SLN(A7,B7,C7) 200
Record 2 =SLN(A8,B8,C8) 300
Record 3 =SLN(A9,B9,C9) 0
Microsoft Excel reference