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
| Argument | Required? | What it does |
|---|---|---|
| cost | Yes | What the asset cost. |
| date_purchased | Yes | The purchase date. |
| first_period | Yes | The end date of the first accounting period. |
| salvage | Yes | Its value at the end of its life (can be 0). |
| period | Yes | Which period to return, starting at 0 for the first (part) period. |
| rate | Yes | The depreciation rate (straight-line rate, e.g. 15% for a life of about 6.7 years). |
| basis | No | Year 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)
| A | B | |
|---|---|---|
| 1 | Cost | 24000 |
| 2 | Purchased | 8/19/2026 |
| 3 | First period ends | 12/31/2026 |
| 4 | Salvage | 3000 |
| 5 | Period | Depreciation |
| 6 | 0 | 1321.64 |
| 7 | 1 | 3600 |
| 8 | 2 | 3600 |
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

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.