Skip to content

SLN

FinancialExcel 2007

Straight-line depreciation for one period.

Syntax

SLN(cost, salvage, life)

Examples

=SLN(100000, 10000, 5)

18000 per year

Related functions

More Financial functions

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.