Excel like a finance pro.
Financial function
AMORDEGRC
Returns depreciation for each accounting period using the French degressive method with a coefficient.
When to use it
Depreciation for a period under the French accounting system, declining balance with a coefficient that depends on the asset life, prorated for the first period.
The shape of it
- Syntax
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Worked examples
First full period
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15,1) → 776
Period 1 for an asset bought in August.
Stub period
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,0,0.15,1) → 330
Period 0: the prorated stub from purchase to the first period end.
Second period
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,2,0.15,1) → 485
Period 2 on the remaining balance.
Worth knowing
- Coefficients: 1.5 for a life of 3-4 years, 2 for 5-6, 2.5 beyond.
- Results are rounded to whole units.
- AMORLINC is the straight-line counterpart.
Where it goes wrong
- Only meaningful under French GAAP.
- Text dates return #VALUE!.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.