Skip to content
Excel

AMORDEGRC function in Excel

Returns the depreciation for each accounting period by using a depreciation coefficient

=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])

AMORDEGRC syntax and parameters

Seven arguments, six required.

  • costnumberRequired

    The cost of the asset.

  • date_purchasedanyRequired

    The date of the purchase of the asset.

  • first_periodanyRequired

    The date of the end of the first period.

  • salvagenumberRequired

    The salvage value at the end of the life of the asset.

  • periodnumberRequired

    The period.

  • ratenumberRequired

    The rate of depreciation.

  • basisnumberOptional

    The year basis to be used.

AMORDEGRC examples

Formulas you'll actually reuse.

  1. French declining-balance depreciation for period 1 — a coefficient based on the asset's life is applied to the 20% rate:

    =AMORDEGRC(24000, DATE(2026, 1, 15), DATE(2026, 12, 31), 4000, 1, 20%)

  2. Period 0 on an actual/actual day-count basis:

    =AMORDEGRC(24000, DATE(2026, 1, 15), DATE(2026, 12, 31), 4000, 0, 20%, 1)

AMORDEGRC in Google Sheets

No direct equivalent — here's the way around.

Try AMORDEGRC in the playground

Edit the example — nothing to install.

Preloaded with the AMORDEGRC formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.