Excel AMORDEGRC Function

The AMORDEGRC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In this guide, we’re going to show you how to use the AMORDEGRC function and go over some tips and error handling methods.

Supported versions

All versions

AMORDEGRC Function Syntax

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

Arguments

cost	The initial cost of the asset.
date_purchased	The purchase date of the asset.
first_period	The end date of the first period.
salvage	The value after the asset has been fully depreciated, salvage value.
period	Specific period to calculation depreciation for.
rate	The rate of depreciation.
[basis]	Optional. The year basis type. Detailed information on Wikipedia.

Basis

Basis	Date system
0 or omitted	360 days (NASD method)
1	Actual
3	365 days in a year
4	360 days in a year (European method)

AMORDEGRC Function Examples

In our example, an asset was purchased on June 12, 2020 at an initial cost of $20,000. The end of the first period is December 31, 2020 and the depreciation rate is 20% per year with an expected salvage value of $4,000.

The table below shows the depreciation and asset value over periods for each basis.

Download Workbook

Remarks

Microsoft suggests using the DATE function or other date returning functions for date_purchased and first_period arguments instead of strings.
The AMORDEGRC applies a depreciation coefficient in the calculation based on the life of the asset.