SLN function

Category: Financial
Introduced: Excel 2003

Summary

Returns the straight-line depreciation of an asset for one period

Syntax

SLN(cost, salvage, life) The SLN function syntax has the following arguments:
• Cost Required. The initial cost of the asset.
• Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset).
• Life Required. The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

Example

=SLN(A2, A3, A4)

Microsoft Support Page

https://support.microsoft.com/en-us/office/sln-function-cdb666e5-c1c6-40a7-806a-e695edc2f1c8

Back to Functions