SLN

Definition: The SLN function in Excel calculates the straight-line depreciation of an asset.

Syntax: ==SLN(cost, salvage, life).

Situation: This function is appropriate when calculating the depreciation of an asset over its useful life.

Example: With an asset costing $10,000, having a salvage value of $2,000, and a useful life of 5 years, the formula =SLN(10000, 2000, 5) would return $1600, the yearly depreciation amount.