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)

Want to practice AMORDEGRC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

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

Arguments

ArgumentRequired?What it does
costYesWhat the asset cost.
date_purchasedYesThe purchase date.
first_periodYesThe end date of the first accounting period.
salvageYesIts value at the end of its life (can be 0).
periodYesWhich period to return, starting at 0 for the first (part) period.
rateYesThe depreciation rate (straight-line rate, e.g. 15% for a life of about 6.7 years).
basisNoYear 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.

B6fx=AMORDEGRC($B$1,$B$2,$B$3,$B$4,A6,15%,1)
AB
1Cost24000
2Purchased8/19/2026
3First period ends12/31/2026
4Salvage3000
5PeriodDepreciation
603304
717761
824851

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

Kyle Stott

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.