AMORDEGRC
Formulas / AMORDEGRCReturn 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.
Frequently Asked Questions
What is the AMORDEGRC function?
What are the arguments for the AMORDEGRC function?
What does the AMORDEGRC function return?
Is the AMORDEGRC function deprecated?
