IPMT Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

• Introduced: The original release and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. This unversioned reference does not establish support in every older build or mobile client.
• Checked: October 14, 2026, against the official IPMT reference. Documentation check; not a new native test.

=IPMT(rate, per, nper, pv, [fv], [type])

Square brackets mark optional arguments; do not type them. A positive loan advance represents money received, while the repayment components are negative outflows. These conventions and defaults follow the official IPMT help.

In a blank worksheet enter the following. Keep these inputs unchanged when trying the formulas below in unused cells.

=PMT(B2,B3,B4,B5,B6) gives an expected payment of -193.328015. IPMT returns only the interest within that payment, not the full installment.

Understand the first two months

The first month’s interest is -10000 × 0.005 = -50. Subtract that interest from the full payment to obtain signed principal: -193.328015294 - (-50) = -143.328015294. The remaining balance becomes 9856.671984706, so month two’s interest is about -49.283359924.

Interest falls as this loan’s balance falls. A smaller absolute IPMT amount does not mean the payment itself has changed.

Enter period numbers 1 through 60 in D2:D61. In E2, enter:

=IPMT($B$2,D2,$B$3,$B$4,$B$5,$B$6)

Fill down through E61. The absolute references keep the loan assumptions fixed; the relative D2 advances the payment number.

• =SUM(E2:E13) totals months 1–12: approximately -551.904511.
• =SUM(E2:E61) totals the full term: approximately -1599.680918.
• =60*PMT(B2,B3,B4)+B4 provides a separate full-term interest check with the same expected result.

For each period, IPMT + PPMT = PMT when all inputs match. The first payment therefore combines interest -50 and principal -143.328015 into -193.328015 before display rounding.

With type=1, the first payment is made before any period’s interest accrues. Its interest component is zero and the payment is entirely principal. Change timing consistently in PMT, IPMT and PPMT; keeping the old PMT amount would mix two schedules.

For the table’s fv=-2000 case, scheduled payments leave a positive modeled debt balance of 2,000. The signed terminal amount is negative from the borrower’s perspective. This is not an extra recurring payment: it changes the payment calculation. Check a contract separately before treating it as a balloon-loan quote.

• Unexpected sign: Positive loan proceeds produce negative repayment components. Negate a result for a positive cost or debt-reduction display, but retain signed values in reconciliation formulas.
• Wrong rate or term: Match units. For a nominal 6% annual rate and monthly payments, use 6%/12 and 60, not 6 and 5.
• Invalid period: Use whole-number payment indices from 1 through nper. A range must have its start no later than its end.
• Totals differ by cents: Format results for display without rounding intermediate formulas. A lender that rounds each installment, uses daily interest or changes the last payment can produce different totals.
• Formula error: Check numeric inputs, period bounds, timing and the configured formula language. The short official reference does not specify every error token or text/blank coercion rule.

These examples assume fixed rates, equal periods and the scheduled payments. Extra payments, skipped installments, fees and variable rates need a separate cash-flow schedule.

• PMT calculates the complete periodic payment.
• IPMT and PPMT split one payment into interest and principal.
• CUMIPMT and CUMPRINC total a selected range.
• SUM adds worksheet components; ROUND is useful when a model explicitly calls for rounded amounts.

The function-entry guide explains the function dialog. Advanced Settings covers formula language and regional settings; examples here use English names, decimal points and commas.

Example verification: Results were independently calculated with high-precision annuity equations and a separate discounted-payment/amortization model. Values shown use six-decimal half-up display rounding; no example was executed in ONLYOFFICE.