MS Excel: SLn Function

In Excel, the SLn function returns the depreciation of an asset for a period based on the straight-line depreciation method.

The syntax for the SLn function is:

SLn( cost, salvage, life )

cost is the original cost of the asset.

salvage is the salvage value after the asset has been fully depreciated.

life is the useful life of the asset or the number of periods that you will be depreciating the asset.

Applies To:

For example:

Let's take a look at a few examples:

This first example returns the depreciation for an asset that costs $10,000, with a salvage value of $5,000. The useful life of the asset is 5 years.

=SLn(10000, 5000, 5)

This next example returns the depreciation for an asset that costs $8,000, with a salvage value of $0. The useful life of the asset is 7 years.

=SLn(8000, 0, 7)

VBA Code

The SLn function can also be used in VBA code. For example:

Dim LValue As Double

LValue = SLn(8000, 0, 7)

In this example, the variable called LValue would now contain the value of 1142.857143.