AMORDEGRC Function
Returns French-system declining depreciation for an accounting period.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Depreciation for a period (rounded)
Overview
AMORDEGRC and AMORLINC follow the French accounting system, where the first year is pro-rated from the purchase date to the end of the first period.
AMORDEGRC multiplies the rate by a coefficient based on the asset's life (1.5, 2 or 2.5), applies it to the remaining value, and rounds to whole numbers.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| cost | Yes | What the asset cost. |
| date_purchased | Yes | The purchase date. |
| first_period | Yes | The end date of the first accounting period. |
| salvage | Yes | Its value at the end of its life (can be 0). |
| period | Yes | Which period to return, starting at 0 for the first (part) period. |
| rate | Yes | The depreciation rate (straight-line rate, e.g. 15% for a life of about 6.7 years). |
| basis | No | Year basis: 0 or omitted = 360 days, 1 = actual, 3 = 365 days, 4 = European 360 days. (2 isn't allowed.) |
Examples
Example 1 — Equipment at Northstar's French office
€24,000 of equipment bought 8/19/2026, salvage €3,000, 15% rate, actual-days basis.
| A | B | |
|---|---|---|
| 1 | Cost | 24000 |
| 2 | Purchased | 8/19/2026 |
| 3 | First period ends | 12/31/2026 |
| 4 | Salvage | 3000 |
| 5 | Period | Depreciation |
| 6 | 0 | 3304 |
| 7 | 1 | 7761 |
| 8 | 2 | 4851 |
Period 0 covers only 8/19–12/31/2026. With a 15% rate (life about 6.7 years) the coefficient is 2.5.
Common mistakes
- #NUM! error. Basis 2 isn't allowed, and lives between 0–1, 1–2, 2–3 or 4–5 years are also rejected.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.