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

Definition. This function calculates the depreciation amount for assets depending on the desired period based on the French accounting system. The calculated amount is rounded to an integer.


  • 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; in other words, the beginning of the depreciation.

  • First_Period (required) Refers to the date at the end of the first period in the depreciation period. ...

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

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