# Documentation/Calc Functions/AMORLINC

Jump to navigation Jump to search

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. 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. For more information, visit Wikipedia's Day count convention page.

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.
2 Exact number of days in month, year has 360 days.
3 Exact number of days in month, year has 365 days.
4 European method, 12 months of 30 days each.

• 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.

## 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

AMORLINC