AMORLINC Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; this is a verified release, not a final supported version.
• Scope: Desktop Calc, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight ordinary reference formulas were recalculated from generated ODF in 4.1.16 on Linux x86-64, Build 9816. Source and independent arithmetic were checked.

AMORLINC calculates depreciation for a specified accounting period. It prorates period 0 using a date fraction, then uses Cost×Rate for full periods and a final remainder toward the salvage amount. It returns one period’s charge, not cumulative depreciation or remaining book value. Release implementation.

AMORLINC(Cost;PurchaseDate;FirstPeriodEnd;Salvage;Period;Rate[;Basis])

• Cost: positive acquisition amount. PurchaseDate, FirstPeriodEnd: chronological dates defining the initial period.
• Salvage: nonnegative residual value below Cost. Period: 0 for the initial partial period, then positive whole-number periods.
• Rate: positive annual depreciation rate.
• Basis: optional 0; this implementation supports 0, 1, 3 and 4 and explicitly rejects basis 2. The examples supply whole-number periods.

The native column contains saved 4.1.16 results; independent references use high-precision arithmetic and the stated source rules. Values are shown to twelve decimal places where needed. Enter DATE expressions directly rather than locale-dependent date text.

For Cost=1000, Salvage=100, Rate=20%, purchase July 1 and first period end December 31, 2024, basis 0 gives a half-year initial period. Period 0 is 100; periods 1–4 are 200 each. Periods 5 and 6 return zero because the depreciable amount has already been allocated.

The sum through period 4 is 100+4×200=900, leaving the stated salvage of 100. Period numbering begins at zero, so asking for period 1 does not request the initial partial-period charge.

The full-period amount is Cost*Rate; the initial charge is that amount times GetYearFrac(PurchaseDate;FirstPeriodEnd;Basis). The implementation counts the complete annual charges that fit after the initial charge, then uses a final remainder if needed.

For a January 1–December 31, 2024 initial period with basis 1, the source fraction is 365/366 rather than a full year. The native period-0 result is approximately 199.453551912568. Inclusive wording such as “the whole calendar year” does not override the function’s actual endpoints and date-fraction rule.

Use a positive cost and rate, a nonnegative salvage below cost, chronological dates and whole-number nonnegative periods. The helper converts Period to an unsigned integer; the native fixture does not establish safe or useful behavior for negative, extreme or fractional periods. Basis 2 is explicitly rejected in source.

The examples use ordinary valid values and do not test invalid domains or every final-remainder rounding case. This software formula does not establish a jurisdiction’s tax or accounting rule. Verify the selected method, period boundaries and cumulative book value for the intended worksheet.

AMORDEGRC, SLN, DB.

• Function-specific release implementation
• Function calculation helper
• GetYearFrac date-fraction helper
• GetDiffParam date-fraction helper

The generated ODF produced the informational load warning “Not all attributes could be read.” The sheet was hard-recalculated and saved separately. All eight ordinary function identities, inputs and results were reconciled; a stale SUM cache changed from 999999 to 3 and an uncached SUM returned 7. This establishes the stated examples, not every workbook style or invalid input. Other explanatory identities are independent calculations. The authoring-tool XLSX was not executed in OpenOffice, and its preview values are not the native results reported here.