Excel SLN Function

Using the Excel SLN Function

Excel SLN Function

Summary

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

Syntax

=SLN (cost, salvage, life)

Syntax Breakdown

Cost
Required. Initial cost of the asset.

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

Life
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