Microsoft® Excel® 2010 Formulas & Functions Inside Out

AMORDEGRC()

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.

Arguments

• 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. ...