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.