SLN()

Syntax. SLN(Cost,Salvage,Life)

Definition. This function calculates the depreciation amounts of capital assets by using the linear depreciation method.

Arguments

  • Cost (required) The purchase cost (net purchase price plus incidental purchase expenses minus reduction of purchase cost) of an asset. If you do not use a number, the error #VALUE! is displayed. If the entered number is negative, the calculated values cannot be interpreted.

  • Salvage (required) The value of the asset at the end of the depreciation duration. If you don’t use a number, the error #VALUE! is displayed. If the entered number is negative, the error #NUMBER! is displayed.

  • Life (required) The number of periods in which the asset is depreciated. You should use an integer greater ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.