Using the Excel SLN Function
SummaryThe Excel SLN function returns the straight-line depreciation of an asset for one period.
Syntax=SLN (cost, salvage, life)
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 NotesThe 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