deepcalc
DocsAMORDEGRC

AMORDEGRC

View as markdown/docs/functions/amordegrc.md Ask Claude about this pageOpens Claude with this page's address

Depreciation per period, French accounting, degressive.

  • Excel: Not checked yet
  • Google Sheets: No equivalent
  • Returns: Number

Examples

=AMORDEGRC(10000, DATE(2026,1,15), DATE(2026,9,30), 1000, 1, 0.15)
Result 2754

Syntax

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

Errors

#NUM!
=AMORDEGRC(2, DATE(2026,1,15), 2, 2, 2, 0.05)
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement. COUPDAYSNCDays from settlement to the next coupon date.