Financial

AMORLINC Function in Excel

Returns the depreciation for each accounting period using linear depreciation.

Syntax

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

Arguments

  • cost (required): Asset cost
  • date_purchased (required): Purchase date
  • first_period (required): End of first period
  • salvage (required): Salvage value
  • period (required): Period number
  • rate (required): Depreciation rate
  • basis (optional): Day count basis

Examples

  • =AMORLINC(2400, "8/19/2023", "12/31/2023", 300, 1, 0.15) - Linear depreciation - Result: Depreciation amount

AMORLINC modeling tips

  • Align rate and period units (annual rate ÷ 12 for monthly models).
  • Use consistent cash-flow signs (outflows negative, inflows positive).
  • Hub: [Financial functions guide](/guides/excel-financial-functions-guide/).

Common errors

  • #NUM! if parameters invalid

Use cases

  • French accounting
  • Asset depreciation
  • Tax calculation

Frequently asked questions

  • What is the AMORLINC function in Excel? AMORLINC returns the depreciation for each accounting period using linear depreciation. The syntax is =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]). Typical use cases include french accounting, asset depreciation, tax calculation.
  • How do I use the AMORLINC function? To use AMORLINC, type =AMORLINC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is AMORLINC not working in my Excel? Common issues with AMORLINC include #NUM! if parameters invalid. Start by checking the syntax =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.