Excel SLN Function

Using the Excel SLN Function


The Excel SLN function returns the straight-line depreciation of an asset for one period.


=SLN (cost, salvage, life)

Syntax Breakdown

Required. Initial cost of the asset.

Required. Value at the end of the depreciation period. Also known as salvage value.

Required. Number of periods over which the asset is depreciated. Also know as the useful life of the asset.

Usage Notes

The SLN function uses the straight-line method to depreciate an asset over a single period. The depreciation is based on the initial cost of the asset, the salvage value, and the useful life of the asset.

Other Depreciation Functions
SYD Function: Sum-of-years depreciation method

DB Function: Fixed-declining balance depreciation method

DDB Function: Double-declining balance depreciation method

VDB Function: Variable declining balance depreciation method