SLN

Returns the straight-line depreciation of an asset for one period.

Syntax

SLN( Number cost, Number salvage, Number life ) → Currency

Parameters

cost

Required. The initial cost of the asset.

salvage

Required. The value at the end of the depreciation, also known as the salvage value.

life

Required. The number of periods over which the asset is depreciated.

Example

Formula

=SLN(10000,4000,10)

See Also

Function Reference
DDB Function
SYD Function