Skip to Content

SLN

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

Syntax

SLN(cost, salvage, life)

Parameters

  • cost: Required. The initial cost of the asset
  • salvage: Required. The value at the end of the depreciation
  • life: Required. The number of periods over which the asset is depreciated

Example

=SLN(30000, 7500, 10)
Returns: NumberSince: Excel 2003