The Excel Amorlinc function calculates the prorated linear depreciation of an asset for each accounting period. The function is provided for users of the French accounting system.
The syntax of the Amorlinc function is:
Where the arguments are as follows:
|cost||-||The cost of the asset.|
|date_purchased||-||The date of purchase of the asset.|
|first_period||-||The date of the end of the first period.|
|salvage||-||The salvage value at the end of the asset's lifetime.|
|period||-||An integer that specifies the period over which the depreciation is to be calculated.|
|rate||-||The rate of depreciation of the asset.|
|[basis]||-||An optional integer argument which specifies the financial day count basis that is used in the calculation. Possible values are:|
|The financial day count basis rules are explained in detail on the Wikipedia Day Count Convention page|
Note that the date_purchased and first_period arguments should be entered into the function as either:
Warning: If you attempt to enter dates as text, there is a chance that Excel may misinterpret them due to different date systems, or date interpretation settings on your computer.
|2||First Period Date:||30-Sep-2015|
|3||=AMORLINC( 150, B1, B2, 20, 1, 20%, 4 )|
The function returns the value 30.
I.e. the asset depreciates by €30.00 during the first period.
Note that, in the above example, as recommended, the date arguments have been supplied to the function as references to cells containing dates.
See the Microsoft Office website for further information on the Excel Amorlinc function.
If you get an error from the Amorlinc function, this is likely to be one of the following: