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