Skip to content
Excel

AMORLINC function in Excel

Returns the depreciation for each accounting period

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

AMORLINC 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.

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 Google Sheets

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 Excel gets this done.