How to use AMORLINC Function in Excel

The Excel Amorlinc function is provided for users of the French accounting system. The function calculates the prorated linear depreciation of an asset for a specified accounting period.

Syntax:= AMORLINC (cost, purchase, first, salvage, period, rate, [basis])

The AMORLINC function syntax has the following arguments:

• Cost    Required. The cost of the asset.
• Date_purchased    Required. The date of the purchase of the asset.
• First_period    Required. The date of the end of the first period.
• Salvage    Required. The salvage value at the end of the life of the asset.
• Period    Required. The period.
• Rate    Required. The rate of depreciation.
• Basis    Optional. The year basis to be used.

Basis	Date system
0 or omitted	360 days (NASD method)
1	Actual
3	365 days in a year
4	360 days in a year (European method)

Example: Let’s look at some Excel AMORLINC function examples and explore how to use the AMORLINC function as a worksheet function in Microsoft Excel:

Syntax:  =AMORLINC(B1,B2,B3,B4,B5,B6,B7)

Result:

Based on the Excel spreadsheet above, the following AMORLINC examples would return:

Note:

• AMORLINC will return #VALUE if any dates are invalid.
• AMORLINC returns #NUM if:
  • cost <= salvage
  • rate <= 0
  • basis is not 0-4