How to Use the SLN Function in Excel

This guide explains how to use SLN Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: Returns the depreciation of assets according to the straight-line method over a given period.

Syntax: SLN (cost, salvage, life) .

Inside:

- cost : The initial cost of the property, is a required parameter.

- salvage : Value after depreciation, also called the value of product recall, is a mandatory parameter.

- life : Number of periods of depreciation, also known as useful life of assets, is a required parameter.

Attention:

- SLN function is calculated by the formula:

For example: Calculating the annual average depreciation for an asset with initial value of 600,000,000 and the remaining value after depreciation is 125,000,000 and the asset has a shelf life of 10 years.

In the cell to calculate enter the formula: = SLN (B7, C7, D7) .

Press Enter -> the average depreciation per year of the property over a 10 year period is:

The above is a detailed guide of usage and specific example of SLN function. Hope to help you in the case of depreciation calculation.

Good luck!