AMORDEGRC function
AMORDEGRC gives one period's depreciation using a French accounting method, where the rate is boosted by a coefficient tied to asset life. It is rarely needed unless you report under French rules.
Example
Read it as a sentence: for an asset that cost 2,400 and was bought August 19, 2008, find the depreciation for period 1, with the first period ending December 31, 2008, a salvage value of 300, a 15% rate, and basis 1.
Syntax
AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Arguments in [square brackets] are optional.
-
cost(required) - Purchase cost of the asset.
-
date_purchased(required) - Date the asset was acquired.
-
first_period(required) - End date of the first accounting period.
-
salvage(required) - Value left at the end of the asset's life.
-
period(required) - Which period to calculate (the first period is 0).
-
rate(required) - Depreciation rate as a decimal.
-
basis(optional) - Day-count convention: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.
Returns: Depreciation for one period under the French declining-balance method.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15,1) | 776 | Basic |
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,0,0.15,1) | 330 | Period 0 |
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.3,1) | 902 | Life 3-4 years (rate 0.3) |
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.4,1) | 937 | Life between 0 and 3 (rate 0.4) |
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15) | 776 | Basis omitted |
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,20,0.15,1) | 0 | Late period fully depreciated |
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.5,1) | #NUM! | Life between 0 and 3 (rate 0.5) |
=AMORDEGRC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15,2) | #NUM! | Basis 2 (not allowed) |
Watch out for
- Results are rounded to whole currency units at each step.
- Period 0 is the partial first period, so the first full year is period 1.
Where it works
- Excel
- AMORDEGRC is in every version of Excel from 2007 on. Basis 2 is not allowed for this function.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .