SLN

The SLN function calculates the depreciation of an asset for one period using the straight-line method.

Sample Usage

SLN(100,50,10)

SLN(A2,A3,A4)

Syntax

SLN(cost, salvage, life)

  • cost - The initial cost of the asset.

  • salvage - The value of the asset at the end of depreciation.

  • life - The number of periods over which the asset is depreciated.

See Also

SYD: The SYD function calculates the depreciation of an asset for a specified period using the sum of years digits method.

DDB: The DDB function calculates the depreciation of an asset for a specified period using the double-declining balance method.

DB: The DB function calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

Examples

Was this article helpful?
How can we improve it?