Syntax

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

Arguments

The printed syntax lists 7 argument(s), in order:

  • cost
  • purchase_date
  • first_period_end
  • salvage
  • period
  • rate
  • asi optional

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

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

Google’s help article for AMORLINC →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 80 of 516, data fetched 28 September 2026. Data month: September 2026.