# AMORDEGRC

Formulas / AMORDEGRC
Return accounting depreciation for a period.
`=AMORDEGRC(cost, purchase, first, salvage, period, rate, [basis])`
• cost - asset cost
• purchase - asset purchase date
• first - the first period in which depreciation is taken
• salvage - asset salvage value
• period - when to calculate depreciation
• rate - depreciation rate
• basis - [OPTIONAL] day count basis (default =0)

## Examples

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

This example uses the AMORDEGRC function to calculate the depreciation in period 3 of a \$10,000 asset over 6 months with a depreciation rate of 0.2 and salvage value of \$1,000: The result is \$1,000, which is the depreciation amount for period 3.

• `=AMORDEGRC(\$C\$5,\$C\$6,\$C\$7,\$C\$8,E7,\$C\$9,\$C\$10)`

This example uses the AMORDEGRC function to calculate the depreciation of an asset over 6 months with a depreciation rate of 0.2 and salvage value of \$1,000 when the asset cost, start date, end date, and period are all specified in cells. The result is the depreciation amount for the period specified in cell E7.

## Summary

The AMORDEGRC function is used to calculate depreciation for accounting purposes, using a coefficient dependent on asset life. It is specifically tailored for the French system and takes into account proration of the asset with the date of purchase.

• The AMORDEGRC function is used in the French accounting system and is similar to the AMORLINC function.
• The AMORDEGRC function returns the depreciation for a specified asset using a depreciation coefficient.
• The depreciation coefficient used is determined by the asset life given.
• The AMORDEGRC function returns a #VALUE error if any dates are not valid.