Documentation/Calc Functions/AMORLINC

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.

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.


 * 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

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



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.



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



Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/AMORDEGRC AMORDEGRC]

[[Special:MyLanguage/Documentation/Calc_Functions/YEARFRAC YEARFRAC]

ODF standard:
Section 6.12.4, part 2

Equivalent Excel functions:
AMORLINC