All versions
Financial
The Excel AMORDEGRC function returns depreciation under the French accounting system, applying a depreciation coefficient based on asset life (the 'degressive' variant).
Quick answer:
=AMORDEGRC(10000, DATE(2026,1,1), DATE(2026,12,31), 1000, 1, 15%) // period 1
Syntax
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
| Argument | Description | |
|---|---|---|
cost | Required | Asset cost. |
date_purchased | Required | Purchase date. |
first_period | Required | End date of the first period. |
salvage | Required | Salvage value. |
period | Required | The period. |
rate | Required | Depreciation rate. |
basis | Optional | Day-count basis. |
How to use it
AMORDEGRC returns depreciation under the French accounting system, applying a depreciation coefficient based on asset life (the 'degressive' variant).
=AMORDEGRC(10000, DATE(2026,1,1), DATE(2026,12,31), 1000, 1, 15%) // French degressive depreciation
Try it: interactive demo
Live demo
This is the formula pattern AMORDEGRC uses — copy it into Excel with your own numbers.
Result: computed in Excel
Practice workbook
Download the free AMORDEGRC practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.
Frequently asked questions
Who uses AMORDEGRC?
Primarily French accounting, which prorates depreciation by purchase date and applies a life-based coefficient.
AMORDEGRC vs AMORLINC?
AMORDEGRC applies a degressive coefficient; AMORLINC is the linear (straight-line) French method.
Which Excel versions support it?
All modern versions.
Why might it return #NUM! or #VALUE!?
Out-of-range arguments (e.g. negative rate or settlement after maturity) give #NUM!; non-numeric inputs give #VALUE!.
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class