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:

AMORLINC Function - How to use AMORLINC Function in Excel

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

Result:

AMORLINC Function in Excel 1 - How to use AMORLINC Function in Excel

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

Syntax: =AMORLINC(25000,DATE(2019,4,1),DATE(2019,12,31),4000,1,0.3,1)
Result: 7500

Syntax: =AMORLINC(25000,DATE(2019,4,1),DATE(2019,12,31),4000,1,30%,1)
Result: 7500

Note:

  • AMORLINC will return #VALUE if any dates are invalid.
  • AMORLINC returns #NUM if:
    • cost <= salvage
    • rate <= 0
    • basis is not 0-4
READ:  How to use NOMINAL Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *