AMORLINC in Collabora Office: Calculate Linear Depreciation by Settlement Period
Use Collabora AMORLINC’s dates, depreciation rate and day-count basis, reproduce the200-unit example, and recognize the documented Excel basis2 limit.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: AMORLINC calculates linear depreciation for a selected settlement period, including proportional treatment when an asset is acquired during a period. The documented fourth-period example returns 200 currency units for a 2000-unit asset with a 10% depreciation rate.
Syntax and arguments
=AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate [; Basis])
| Argument | Meaning |
|---|---|
| Cost | Acquisition cost |
| DatePurchased | Acquisition date |
| FirstPeriod | End date of the first settlement period |
| Salvage | Residual value at the end of the asset’s depreciable life |
| Period | Settlement period whose depreciation is required |
| Rate | Depreciation rate, entered as a fraction or percentage |
| Basis | Optional day-count convention; defaults to 0 |
The first six arguments are required. FirstPeriod is a date, not the number of periods; Period is the period selector, not a date. A rate of 10% is 0.1, not 10.
Day-count basis
| Basis | Documented convention |
|---|---|
| 0 or omitted | US NASD 30/360 |
| 1 | Actual days in months and actual days in the year |
| 2 | Actual days with a 360-day year |
| 3 | Actual days with a 365-day year |
| 4 | European 30/360 |
The choice matters for date-based proportional treatment. The help does not fully specify every boundary-date, first-period rounding or terminal-period rule, so the ordinary-period control below should not be treated as certification of a complete depreciation schedule.
Example: the vendor’s fourth-period amount
Create this input block:
| Cell | Entry |
|---|---|
| B2 | 2000 |
| B3 | =DATE(2020;2;1) |
| B4 | =DATE(2020;12;31) |
| B5 | 10 |
| B6 | 4 |
| B7 | 10% |
| B8 | 0 |
In B10 enter:
=AMORLINC(B2;B3;B4;B5;B6;B7;B8)
The documented expected result is 200. The equivalent explicit formula is:
=AMORLINC(2000;DATE(2020;2;1);DATE(2020;12;31);10;4;0.1;0)
DATE avoids relying on interpretation of typed date strings. Format B3 and B4 as dates to make the acquisition and first-period end visible.
The ordinary-period amount is independently consistent with acquisition cost × rate: 2000 × 0.1 = 200. This calculation checks the vendor’s stated result; it does not establish undocumented indexing, first-period proration or end-of-life rounding behavior.
Advanced application: scale a verified per-asset control
Suppose a planning group contains 12 identical assets, each with exactly the inputs above, and you are comparing the same fourth period for each asset. Put 12 in D2 and calculate:
=B10*D2
The independent expectation is 2400 currency units. This is a count-times-per-asset calculation, not a claim that assets with different acquisition dates or settlement calendars can be pooled into one AMORLINC call.
For a mixed asset register, keep acquisition date, first-period end, rate, salvage and selected period as separate columns for each asset. Calculate each row before summing the period expense. SUM can combine those numeric results once the per-row inputs have been checked.
Rate-based depreciation versus a life-based shortcut
The documented rate-based example produces 200. Dividing depreciable cost 2000−10 by an assumed ten-year life would instead produce 199. Those are different input models, not a rounding discrepancy.
AMORLINC accepts a rate and dated settlement-period information. Do not substitute a simple (Cost−Salvage)/Life model and expect it to reproduce every result. Nor should 200 be repeated indefinitely: the residual value and the partially used first period are relevant to a complete schedule, whose edge rules require further native verification.
Errors, compatibility and troubleshooting
Check that acquisition precedes the intended first-period end, that the selected period is deliberate, and that cost, residual value and rate represent the same asset assumptions. Keep the dates as actual spreadsheet date values. The dedicated help does not provide a complete list of invalid-input error codes or a full description of out-of-range period behavior; no exact native error is asserted here.
A specific export limitation is documented: Basis 2 is not supported by Microsoft Excel, and the help warns that such a formula returns an error when an exported XLSX document is opened there. This warning is evidence for that particular limitation, not proof of parity for all other bases or all other applications.
If a worksheet differs from the 200-unit control, first reproduce the exact dataset, including period4 and basis0, before investigating date boundaries, different first-period lengths or the final depreciation periods. This guide explains the function; it does not determine the depreciation policy required for a particular tax or reporting situation.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: AMORLINC (checked October 17, 2026).
- Editorial testing standards.