September 23, 2023

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:

SLN Function - How to use SLN Function in Excel

Syntax:  =SLN(A2,B2,C2)

Result:

SLN Function in Excel 1 - How to use SLN Function in Excel

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 PMT Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *