Formualizer Docs
ReferenceFunctionsFinancial Functions

SLN

SLN: Returns straight-line depreciation for a single period.

Summary

SLN spreads the depreciable amount (cost - salvage) evenly across life periods.

Remarks

  • Formula: (cost - salvage) / life.
  • life must be non-zero; life = 0 returns #DIV/0!.
  • This function returns the algebraic result: if salvage > cost, depreciation is negative.
  • Inputs are interpreted as scalar numeric values in matching currency/period units.

Examples

Straight-line yearly depreciation
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1000
Negative depreciation when salvage exceeds cost
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-100

FAQ

Can SLN return a negative value?

Yes. If salvage > cost, (cost - salvage) / life is negative.

What happens when life is zero?

SLN returns #DIV/0!.

Runtime metadata

Category

Financial

Signature

SLN(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/depreciation.rs

RATE

Solves for the periodic interest rate implied by annuity cash flows.

SYD

SYD: Returns sum-of-years'-digits depreciation for a requested period.

On this page

SummaryRemarksExamplesRelated functionsFAQCan SLN return a negative value?What happens when life is zero?Runtime metadata