Using the 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
CostRequired. 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