Menu
EXCEL AMORLINC FUNCTION
Excel AMORLINC Function Introduction
For users of the French accounting system, the Excel Amorlinc feature is available. The function computes the prorated linear depreciation of an asset over a specified accounting period.
Description of Excel AMORLINC Function
Syntax:
=AMORLINC( cost, date_purchased, first_period, salvage, period, rate, [basis] )
Parameter:
- using the following arguments
Cost:
- The asset’s price.
Date_Purchased:
- The asset’s acquisition date.
First_Period:
- The end date of the first period.
Salvage:
- The salvage value of an item at the end of its useful life
Period:
- An integer indicating the time period for which the depreciation is to be calculated.
Rate:
- The asset’s rate of depreciation.
Basis:
- An optional integer parameter that sets the financial day count basis for the computation. Possible values include:
| Basis | Day Count Basis |
|---|---|
| 0 (or omitted) | US (NASD) 30/360 |
| 1 | actual/actual |
| 2 | actual/360 |
| 3 | actual/365 |
| 4 | European 30/360 |
Step By Step Guide of AMORLINC Function
Example:
The Excel Amorlinc function is used in the following example spreadsheet to compute the depreciation of an asset during the first period. The asset was acquired on January 1, 2015, for €150, and the first period expires on September 30, 2015. The asset depreciates at a 20% annual rate and has a salvage value of €20. The European day count method is employed
Key Points
- #NUM! – Occurs if either: the date purchased is more than the first period; or the given salvage value is greater than the cost.
For the salvage, period, rate, or [base] arguments, invalid numbers are given.
(That is, if any of the following conditions are met: salvage 0, period 0, rate 0, or [base] is any number other than 0, 1, 2, 3, or 4). - #VALUE! – Occurs if any of the given date purchased or first period parameters is not a valid Excel date; Any of the given arguments is not a number..
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
