The AMORDEGRC Function in Microsoft Excel

 

 

Now we are going to learn all about formulas and functions. This is the best way to learn them:

AMORDEGRC Function

Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period; the prorated depreciation is taken into account. The function is similar to AMORLINC; except that a depreciation coefficient is applied in the calculation depending on the life of the assets.

 

AMORDEGRC(cost; date_purchased; first_period; salvage; period; rate; [basis])

 

The AMORDEGRC function syntax has the following arguments:

  • Cost Required. The cost of the asset.
  • Date_purchased Required. The date of the purchase of the asset.
  • First_period Required. The date of the end of the first period.
  • Salvage Required. The salvage value at the end of the life of the asset.
  • Period Required. The period.
  • Rate Required. The rate of depreciation.
  • Basis Optional. The year basis to be used.
    BASIS DATE SYSTEM
    0 or omitted 360 days (NASD method)
    1 Actual
    3 365 days in a year
    4 360 days in a year (European method)

 

Remarks

 

    • Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default; January 1; 1900 is serial number 1; and January 1; 2008 is serial number 39448 because it is 39;448 days after January 1; 1900.
    • The depreciation coefficients are:
LIFE OF ASSETS (1/RATE) DEPRECIATION COEFFICIENT
Between 3 and 4 years 1.5
Between 5 and 6 years 2
More than 6 years 2.5
  • The depreciation rate will grow to 50 percent for the period preceding the last period and will grow to 100 percent for the last period.
  • If the life of assets is between 0 (zero) and 1; 1 and 2; 2 and 3; or 4 and 5; the #NUM! error value is returned.

 

Interactive Example