AMORLINC Function

Returns French-system straight-line depreciation for an accounting period.

Category

Financial

Available in

All versions, Microsoft 365

Returns

Depreciation for a period

Want to practice AMORLINC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

AMORDEGRC and AMORLINC follow the French accounting system, where the first year is pro-rated from the purchase date to the end of the first period.

AMORLINC is the straight-line version: cost × rate per full year, with the first year pro-rated by days.

Syntax

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

Arguments

ArgumentRequired?What it does
costYesWhat the asset cost.
date_purchasedYesThe purchase date.
first_periodYesThe end date of the first accounting period.
salvageYesIts value at the end of its life (can be 0).
periodYesWhich period to return, starting at 0 for the first (part) period.
rateYesThe depreciation rate (straight-line rate, e.g. 15% for a life of about 6.7 years).
basisNoYear basis: 0 or omitted = 360 days, 1 = actual, 3 = 365 days, 4 = European 360 days. (2 isn't allowed.)

Examples

Example 1 — Equipment at Northstar's French office

The same €24,000 of equipment at 15% a year.

B6fx=AMORLINC($B$1,$B$2,$B$3,$B$4,A6,15%,1)
AB
1Cost24000
2Purchased8/19/2026
3First period ends12/31/2026
4Salvage3000
5PeriodDepreciation
601321.64
713600
823600

Each full year is €24,000 × 15% = €3,600; period 0 is 134 days' worth.

Common mistakes

  • #NUM! error. Basis 2 isn't allowed, and the first period must end after the purchase date.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.