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

RRI

SYD

Last updated 11 months ago

Formula	Return value
`SLN(100, 50, 5)`	`10`
`SLN(100, 60, 5)`	`8`
`SLN(150, 50, 5)`	`20`
`SLN(100, 50, 10)`	`5`

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