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:
Based on the Excel spreadsheet above, the following SLN examples would return:
- #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.