Documentation/Calc Functions/AMORLINC

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

AMORLINC

Category:

Financial Analysis

Summary:

Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.

Im-jabber.svg

Note:
This is the amortization value for the French accounting system using linear depreciation (l'amortissement linéaire comptable).

Syntax:

AMORLINC(Cost; Date Purchased; First Period; Salvage; Period; Rate[; Basis])

Returns:

Returns a non-negative real number.

Arguments:

Cost is a positive real number or a reference to the cell containing that number which is the acquisition costs.

DatePurchased is a date or a reference to a cell containing that date which is the date of acquisition.

FirstPeriod is a date or a reference to a cell containing that date which is the end date of the first settlement period.

Salvage is a positive real number or a reference to the cell containing that number which is the salvage value of the capital asset at the end of the depreciable life.

Period is a positive real number or a reference to the cell containing that number which is the settlement period to be considered.

Rate is a positive real number or a reference to the cell containing that number which is the rate of depreciation.

Basis is a positive integer from 0 to 4 or a reference to a cell containing that integer which is chosen from a list of options and indicates how the year is to be calculated.

Basis Calculation
0 or missing US method (NASD), 12 months of 30 days each
1 Exact number of days in months, exact number of days in year, i.e. Actual/actual.
2 Exact number of days in month, year has 360 days, i.e. Actual/360.
3 Exact number of days in month, year has 365 days, i.e. Actual/365.
4 European method, 12 months of 30 days each, i.e. 30/360.


  • If either DatePurchased or FirstPeriod is not valid dates then the function returns an value(#VALUE!) error.
  • If Rate or Cost. are less than or equal to 0 then the function will return an error value.
  • If Salvage or Period. are less than 0 then the function will return an error value.
  • If DatePurchased date is after the FirstPeriod date then the function returns an error value.
  • If Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.
  • After truncation if Basis is ny number except 0,1,2,3,4 or missing(passed as empty argument or not passed at all),then the function will return an error value.

Additional details:

  • The formula for AMORLINC is:

When Period =0

Amorlinc0.png

For full periods, where Period > 0, the depreciation is Cost * Rate.

Amorlinc1.png

For the last period, possibly a partial period, the depreciation = Cost - Salvage - accumulated - depreciation, where accumulated - depreciation is the su f the depreciation in Period 0 plus any full period depreciations.

Amorlincf.png

When Period > depreciated life of the asset, i.e., when Period > t(from the formula above) then the depreciation is 0.

Amorlincf0.png

Examples:

Formula Description Returns
=AMORLINC(1500;"2001-04-01";"2001-06-15";454;2;0.19;2) The function calculates the amount of depreciation for a settlement period as linear amortization. 285
=AMORLINC(1500;"2001-04-01";"2001-06-15";454;2;0.19;) The function calculates the amount of depreciation for a settlement period as linear amortization. Here the basis is the US method (0) whenever either empty or no argument is passed. 285
=AMORLINC(1500;"2001-04-01";"2001-06-15";454;2;0.9;0) The function calculates the amount of depreciation for a settlement period as linear amortization. Here the rate is between 1 and 2 so the function will return a zero value. 0

Related LibreOffice functions:

AMORDEGRC

YEARFRAC

ODF standard:

Section 6.12.4, part 2

Equivalent Excel functions:

AMORLINC