The Excel SLN function returns the depreciation of an asset for one period, calculated with a straight-line method. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated.
Syntax:= SLN(cost, salvage, life)
The SLN function syntax has the following arguments:
- Cost Required. The initial cost of the asset.
- Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset).
-
Life Required. The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
Example: Let’s look at some Excel SLN function examples and explore how to use the SLN function as a worksheet function in Microsoft Excel:
Suppose we are given the following data and we need to calculate the depreciation using the straight-line method:
Syntax: =SLN(A2,B2,C2)
Result:
Based on the Excel spreadsheet above, the following SLN examples would return:
Syntax: =SLN(A3,B3,C3)
Result: $6,150
Syntax: =SLN(A4,B4,C4)
Result: $9,000
Syntax: =SLN(A5,B5,C5)
Result: $1,400
Syntax: =SLN(A6,B6,C6)
Result: $4,750
Syntax: =SLN(A7,B7,C7)
Result: $9,000
Syntax: =SLN(A8,B8,C8)
Result: $270,000
Note:
- #DIV/0! error – Occurs if the given life argument is equal to zero.
- #VALUE! error – Occurs if any of the given argument is non-numeric.