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.

Frequently Asked Questions

What is the AMORDEGRC function?
The AMORDEGRC function is used in Microsoft Sourcetable to calculate depreciation. It is similar to AMORLINC but differs because the calculation applies a depreciation coefficient dependent on asset life.
What are the arguments for the AMORDEGRC function?
The arguments for the AMORDEGRC function are cost, date_purchased, first_period, salvage, period, rate, and [basis]. The [basis] argument is optional and determines the year basis used.
What does the AMORDEGRC function return?
The AMORDEGRC function returns the depreciation up to the last period of the assets' lives or the deprecation's cumulated value exceeds the assets' cost minus salvage value.
Is the AMORDEGRC function deprecated?
Yes, the AMORDEGRC function is deprecated and should not be used.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV