Syntax. AMORLINC(Cost,Date,First_Period,Residual_Value,Period,Rate,Basis)

Definition. This function calculates the depreciation amount in the desired period by using linear depreciation of assets. The calculations are based on the French accounting system, but can be adjusted to tax laws of other countries or regions with a few additional considerations regarding the depreciation calculation.


  • Cost (required) The purchase cost (net purchase price plus incidental purchase expenses minus reduction of purchase cost) of an asset. If you don’t use a number, the error #VALUE! is displayed. If the entered number is negative, the error #NUMBER! is displayed.

  • Date_Purchased (required) The purchase date of the asset; that is, the beginning ...

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.