CUMIPMT_ADD Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; no final supported release is established.
• Scope: English desktop Calc, Analysis add-in compatibility identity and semicolon-separated formulas.
• Checked: October 14, 2026. One ordinary English-name formula was directly entered and recalculated in 4.1.16 on Linux x86-64, Build 9816. The table contains independent references; the failed generated-ODF import is separate.

CUMIPMT_ADD is the Analysis add-in’s cumulative-interest function. It adds interest portions for an inclusive interval of a level-payment loan. The suffix distinguishes it from core CUMIPMT; the release registers both identities, and their argument interfaces are not identical. Release implementation.

=CUMIPMT_ADD(Rate;Nper;PV;StartPeriod;EndPeriod;Type)

• Rate: positive interest rate per payment period.
• Nper: positive total number of periods; use an integer.
• PV: positive initial loan value.
• StartPeriod, EndPeriod: inclusive integer payment numbers from 1 through Nper.
• Type: 0 for end-of-period payments or 1 for beginning-of-period payments. This add-in explicitly rejects other integer Type values.

All six arguments are required. Nper, the two interval limits and Type are declared as signed 32-bit integer parameters in the add-in interface. The examples use exact ordinary integers.

These values follow the stated mathematical formulas and the inspected integer-input contract. They are not presented as eight native executions. Results are rounded to twelve decimal places where needed.

For a 1000 loan at 1% per period with twelve end-of-period payments, the add-in returns approximately −66.185464140100 over all twelve payments. Periods 1 through 3 contain approximately −27.626651460782 of interest; periods 4 through 6 contain approximately −20.387145189468.

A positive principal is an inflow to the borrower, so repayments are negative. Negate the returned amount only when a report deliberately presents interest cost as positive. Do not remove the sign before combining it with other signed cash flows.

The independent payment is -1000*.01/(1-(1.01)^(-12)), approximately −88.848788678342. Its first interest portion is −10. Repeatedly update the outstanding balance by the principal portion and accumulate the interest to reproduce the displayed result.

Beginning-of-period timing changes the payment and makes the first interest portion zero. Its total interest here is approximately −55.629172415941. The corresponding principal total is −1000, so interest plus principal equals twelve signed payments. These are equal-period calculations, not an irregular-date interest accrual.

The wrapper checks positive rate, principal and period count, a valid inclusive interval and an integer Type of exactly 0 or 1. Those conditions were reviewed in source; no invalid-domain call was executed. A zero-rate loan is mathematically meaningful but is outside this add-in’s accepted positive-rate contract.

The core CUMIPMT helper uses a positive/nonpositive timing branch, whereas this add-in explicitly checks Type. Do not use a successful core formula as proof of every compatibility-call detail. Fractional argument conversion, extreme integer limits, text and blank cells were not tested here.

The directly entered English formula =CUMIPMT_ADD(0.01;12;1000;1;12;0) produced the saved result -66.185464140101. The English entry and its serialized identity were reviewed together; an ODF canonical spelling alone cannot distinguish every core function from its compatibility add-in.

An earlier generated ODF used fully qualified Analysis service names. All eight import-path attempts for this function displayed #NAME?, despite passing recalculation controls. Those errors do not establish that the English function is unsupported. They also do not count as successful reference-case executions. Do not copy a fully qualified storage name into a normal formula expecting it to behave like the English name.

CUMIPMT, IPMT, PMT.

• Function-specific release implementation
• Separate English and ODF add-in identities
• GetRmz calculation helper
• GetZw calculation helper

Only the single direct-entry case above is successful native function evidence in this guide. The remaining table values and explanatory identities are independently calculated. The failed generated-ODF workbook, including its informational attribute-load warning, is retained separately. No original XLSX execution, other locale, platform or release is implied.