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.