SLN

Straight-line method

Description

Calculates an asset's depreceiation over one period using the straigh-line method.

Function signature

SLN(cost: Number, salvage: Number, life: Number) => Number

Parameter

Description

Cost

The initial cost of the asset

Salvage

The value of the asset at the end of depreciation.

Life

The number of periods over which the asset is depreciated

Examples

Formula

Return value

SLN(100, 50, 5)

10

SLN(100, 60, 5)

8

SLN(150, 50, 5)

20

SLN(100, 50, 10)

5