All functions / Financial

SLN

Straight-line depreciation: the same loss of value every year.

Syntax

=SLN(cost, salvage, life)

Arguments

• cost: What the asset cost.
• salvage: What it is worth at the end.
• life: How many periods it is used for.

Example

=SLN(12000, 2000, 5) → 2,000 per year