PPMT 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 PPMT reference. Documentation check; not a new native test.

=PPMT(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 PPMT 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. PPMT returns only the principal within that payment, not the full installment.

Why principal grows over time

The full payment is fixed, but interest is charged on a declining balance. In month one, -193.328015294 - (-50) gives principal -143.328015294. By month sixty, only about -0.961831 of the installment is interest, leaving approximately -192.366184 as principal.

Do not calculate principal as 10000/60: that would assume equal principal reductions rather than equal total payments.

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

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

Fill down through E61. In F2, enter the following and fill down through F61:

=$B$4+SUM($E$2:E2)

The sum’s first endpoint stays fixed while its second endpoint expands. Add the negative principal components to the positive opening balance.

The full-term sum =SUM(E2:E61) is -10000 in the mathematical model. Tiny numerical residues may appear in a spreadsheet. This ledger assumes the unchanged scheduled payments; an extra repayment requires recalculating subsequent balances and interest.

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.