Skip to content
Google Sheets

AMORLINC function in Google Sheets

Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.

=AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])

AMORLINC syntax and parameters

Seven arguments, six required.

  • costanyRequired
  • purchase_dateanyRequired
  • first_period_endanyRequired
  • salvageanyRequired
  • periodanyRequired
  • rateanyRequired
  • basisanyOptional

AMORLINC examples

Formulas you'll actually reuse.

  1. French linear depreciation for period 1 at a 20% rate:

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

    Result4800

  2. Period 0 — the prorated stub from purchase to the first period end:

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

AMORLINC in Excel

Same name — your formula ports as-is.

Try AMORLINC in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.