Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .