SLN

  • Updated

Returns 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 at the end of the depreciation.
  • life - The number of periods over which the asset is depreciated.

Examples

SLN(100,50,10) returns the depreciation allowance for each year.