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

 

 

 

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips