Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .