Quick Answer

AMORDEGRC Function

Calculates depreciation for a specific period using the French declining balance method.

Syntax

AMORDEGRC

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

Parameters

Parameter	Description	Required
cost	Initial cost of the asset.	Required
date_purchased	Date the asset was purchased.	Required
first_period	End date of the first period.	Required
salvage	Salvage value at the end of the asset life.	Required
period	Period for which to calculate depreciation.	Required
rate	Depreciation rate.	Required
basis	Year basis (0 = 360 days, 1 = actual, 3 = 365 days).	Optional

Basic Example

French declining balance depreciation

=AMORDEGRC(10000, DATE(2024,1,1), DATE(2024,12,31), 1000, 1, 0.2)

ResultDepreciation for period 1

Calculates first-year depreciation for a $10,000 asset with a 20% depreciation rate.

Advanced Examples

Example 1: With actual year basis

French accounting

Use basis 1 for actual days

=AMORDEGRC(10000, DATE(2024,1,1), DATE(2024,12,31), 1000, 1, 0.2, 1)

Result: Depreciation with actual year basis

Basis 1 uses actual days for the period.

How AMORDEGRC Works

AMORDEGRC applies a depreciation coefficient based on the asset life and calculates declining balance depreciation. It is used primarily in French accounting systems.

1

Enter cost

Type the cost

2

Enter date_purchased

Type the date_purchased

3

Enter first_period

Type the first_period

4

Enter salvage

Type the salvage

5

Calculate

Press Enter to get the result.

Important Notes & Limitations

Used mainly in French accounting standards.
Rate is determined by asset life and a coefficient table.
Basis determines how days are counted.

Common Errors & Fixes

#NUM! errorInvalid dates, period, or rate.

Fix: Verify all inputs are valid.

Wrong depreciationRate does not match the French coefficient for the asset life.

Fix: Use the correct coefficient based on asset life.

Download Practice File

Practice AMORDEGRC with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the AMORDEGRC function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

ACCRINT

Calculates accrued interest for a security that pays periodic interest.

ACCRINTM

Calculates accrued interest for a security that pays interest at maturity.

AMORLINC

Calculates depreciation for a specific period using the French straight-line method.

COUPDAYBS

Calculates the number of days from the beginning of the coupon period to the settlement date.

COUPDAYS

Calculates the number of days in the coupon period that contains the settlement date.

COUPDAYSNC

Calculates the number of days from the settlement date to the next coupon date.

Frequently Asked Questions

What is the difference between AMORDEGRC and AMORLINC?

AMORDEGRC uses declining balance. AMORLINC uses straight-line depreciation.

When is AMORDEGRC used?

It is used in French accounting for accelerated depreciation.