# Documentation/Calc Functions/AMORLINC

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

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

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

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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

AMORLINC