September 28, 2021

# How to use SLN Function in Excel

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:

1. #DIV/0! error – Occurs if the given life argument is equal to zero.
2. #VALUE! error – Occurs if any of the given argument is non-numeric.
READ:  How to use PRICEMAT Function in Excel #### Excel

View all posts by Excel →