ID EN
…
#Financial

AMORDEGRC

Excel Functions

Depreciation for accounting period coefficient

Syntax

EXCEL 
=AMORDEGRC(cost, purchase, first, salvage, period, rate, [basis])

Arguments

Parameter Description
cost Asset cost.
purchase Asset purchase date.
first First period end date.
salvage Asset salvage value.
period Period for which to calculate depreciation.
rate Rate of depreciation.
basis [optional] Day count basis (default =0).

Return Value

Depreciation in given period

Details

The Excel AMORDEGRC function returns the depreciation for each accounting period by using a depreciation coefficient. This function is provided for the French accounting system. Depreciation is prorated based on the date an asset is purchased in the first period. AMORDEGRC is similar to AMORLINC, except AMORDEGRC applies a depreciation coefficient in the calculation based on life of asset. In the example shown, an asset was purchased on June 30, 2019 at an initial cost of $10,000. The end of the first period is December 31, 2019 and the depreciation rate is 20% per year. The salvage value is $1000, and the basis is European 30/360. The formula in F7, copied down the table is: Notice with the exception of the period numbers in column E, the other arguments use absolute references to prevent

Examples

Example

In the example shown, an asset was purchased on June 30, 2019 at an initial cost of $10,000. The end of the first period is December 31, 2019 and the

EXCEL 
=AMORDEGRC($C$5,$C$6,$C$7,$C$8,E7,$C$9,$C$10)
Entering dates

In Excel, dates are serial numbers. Generally, the best way to enter valid dates is to use cell references, as shown in the example. To enter valid da

EXCEL 
=AMORDEGRC(10000,date(2019,6,30),date(2019,12,31),1000,3,0.2,4)

See Also

AMORLINC