Skip to main content

SLN function

The SLN function is one of the financial functions. It is used to calculate the depreciation of an asset for one accounting period using the straight-line depreciation method.

Syntax​

SLN(cost, salvage, life)

The SLN function has the following arguments:

ArgumentDescription
costThe cost of the asset.
salvageThe salvage value of the asset at the end of its lifetime.
lifeThe total number of the periods within the asset lifetime.

Notes​

How to apply the SLN function.

Examples​

The figure below displays the result returned by the SLN function.

SLN Function