The AMORLINC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In this guide, we’re going to show you how to use the AMORLINC function and go over some tips and error handling methods.
- All versions
AMORLINC Function Syntax
AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])
|cost||The initial cost of the asset.|
|date_purchased||The purchase date of the asset.|
|first_period||The end date of the first period.|
|salvage||The value after the asset has been fully depreciated, salvage value.|
|period||Specific period to calculation depreciation for.|
|rate||The rate of depreciation.|
|[basis]||Optional. The year basis type. Detailed information on Wikipedia.|
|0 or omitted||360 days (NASD method)|
|3||365 days in a year|
|4||360 days in a year (European method)|
AMORLINC Function Examples
In our example, an asset was purchased on June 12, 2020 at an initial cost of $20,000. The end of the first period is December 31, 2020 and the depreciation rate is 20% per year with an expected salvage value of $4,000.
The table below shows the depreciation and asset value over periods for each basis.
- Microsoft suggests using the DATE function or other date returning functions for date_purchased and first_period arguments instead of strings.
- The AMORLINC is similar to the AMORDEGRC function which applies a depreciation coefficient in the calculation based on the life of the asset. Thus, use the AMORDEGRC to calculate depreciation without applying a coefficient.
|Asset life||Depreciation coefficient|
|Between 3 and 4 years||1.5|
|Between 5 and 6 years||2|
|More than 6 years||2.5|
Excel Depreciation Functions
|French declining balance||AMORDEGR|