AMORLINC function
AMORLINC returns one period's straight-line depreciation, with the first partial period prorated by days. It follows French accounting conventions and matches SLN for full periods.
Example
Read it as a sentence: for an asset that cost 2,400 and was bought August 19, 2008, find the straight-line depreciation for period 1, with the first period ending December 31, 2008, a salvage value of 300, a 15% rate, and basis 1.
Syntax
AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Arguments in [square brackets] are optional.
-
cost(required) - Purchase cost of the asset.
-
date_purchased(required) - Date the asset was acquired.
-
first_period(required) - End date of the first accounting period.
-
salvage(required) - Value left at the end of the asset's life.
-
period(required) - Which period to calculate (the first period is 0).
-
rate(required) - Depreciation rate as a decimal.
-
basis(optional) - Day-count convention: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.
Returns: Depreciation for one period under the French straight-line method.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=AMORLINC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15,1) | 360 | Basic |
=AMORLINC(2400,DATE(2008,8,19),DATE(2008,12,31),300,0,0.15,1) | 131.8032787 | Period 0 |
=AMORLINC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15,4) | 360 | Basis 4 |
=AMORLINC(2400,DATE(2008,8,19),DATE(2008,12,31),300,20,0.15,1) | 0 | Late period |
=AMORLINC(2400,"2008-08-19","2008-12-31",300,1,0.15,1) | 360 | Text dates |
=AMORLINC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15,2) | #NUM! | Basis 2 (not allowed) |
=AMORLINC(2400,DATE(2008,8,19),DATE(2008,12,31),300,1,0.15,5) | #NUM! | Basis 5 |
=AMORLINC(2400,DATE(2008,12,31),DATE(2008,8,19),300,1,0.15,1) | #NUM! | First period before purchase |
Watch out for
- Period 0 is the prorated first period.
- Depreciation stops once salvage value is reached, so late periods can be smaller or zero.
Where it works
- Excel
- AMORLINC is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .