Zoho Sheet PPMT: Principal Payments and Remaining Loan Balance

• Introduced: The original introduction release and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no numbered release or retirement endpoint is established.
• Scope: English-language web-service documentation. Exact mobile and offline-client parity is not established here.
• Checked: October 14, 2026, against the official PPMT reference. Documentation and independent cash-flow calculations; no native Zoho Sheet test.

=PPMT(rate; period; nper; pv; [fv]; [type])

The required arguments are periodic rate, selected payment period, total number of periods and initial present value. Zoho explicitly places period between 1 and nper. Optional fv defaults to 0; optional type defaults to 0, meaning end-period payments. Type 1 means beginning-period payments.

Supply the fv position when selecting type explicitly. =PPMT(10%;2;4;4641;0;1) uses zero future balance and beginning-period timing; putting 1 in the fifth position instead would change future value, not timing.

A monthly formula needs a monthly rate and a total count of monthly payments. These examples follow Zoho’s semicolon argument separators. The cash received at the start and the amounts paid out later have opposite signs.

Create PrincipalParts. Enter 10%, 4, 4641, 0, 0 in B2:B6 for periodic rate, payment count, borrowed amount, final balance and timing. Enter matching labels in A. This high-rate, short-term fixture is chosen to make the component arithmetic easy to inspect.

In B7 enter =PMT(B2;B3;B4;B5;B6); expect −1464.1. Put Period, Opening, Principal, Interest, Total payment and Closing in A10:F10. Enter periods 1–4 in A11:A14.

• B11: =$B$4
• B12: =F11, then fill through B14
• C11: =PPMT($B$2;A11;$B$3;$B$4;$B$5;$B$6), fill through C14
• D11: =IPMT($B$2;A11;$B$3;$B$4;$B$5;$B$6), fill through D14
• E11: =C11+D11, fill through E14
• F11: =B11+C11, fill through F14

The principal magnitude grows because the balance attracting interest shrinks while the total payment remains fixed. E is the sum of two signed outflows. F adds the negative principal to the positive outstanding balance.

In H11 enter =$B$7+B11*$B$2 and fill through H14. This reconstructs each principal component from the fixed payment plus positive interest accrued; it matches C. In J2 enter =SUM(C11:C14): expect −4641. In J3 enter =$B$4+J2: expect 0 remaining balance.

Keep the main sheet unchanged. Create BeginningPrincipal, enter periods 1–4 in A2:A5, and enter =PPMT(10%;A2;4;4641;0;1) in B2. Fill through B5. Expect −1331,−1000,−1100,−1210.

In D2 enter =PMT(10%;4;4641;0;1); expect −1331. The first payment happens immediately and is all principal, leaving 3310. In D3 enter =SUM(B2:B5); expect −4641 again. The same initial principal is repaid, but the timing and interest total differ.

For a sign control in D4, enter =PPMT(10%;2;4;-4641;0;0); expect 1100. Reversing the initial cash-flow sign reverses this component in the mathematical model. It does not make a borrowed amount and an invested amount the same business arrangement.

Create BalloonPrincipal. Put periods 1 and 2 in A2:A3. Enter =PPMT(10%;A2;2;1000;-500;0) in B2 and fill to B3. Expected principal components are approximately −238.0952380952 and −261.9047619048.

In D2 enter =SUM(B2:B3); expect −500. In D3 enter =1000+D2; expect 500, the remaining positive loan balance. In D4 enter =PMT(10%;2;1000;-500;0); expect approximately −338.0952380952 per regular payment.

The two regular installments repay only half the initial principal. Settling the remaining 500 requires a separate cash outflow; it is not already included in the PPMT sum. Zoho’s FV documentation explains positive received and negative paid cash flows.

In D5 enter =PPMT(10%;2;2;1000;0;0); expect approximately −523.8095238095. This zero-future-balance comparison repays more principal in its second installment. Specify the intended final balance before comparing payment schedules.

Do not omit period, use a fractional payment index or ask for a position outside the stated 1…nper term. The short reference does not fully describe native error codes, zero-rate behavior or every imported input type. The generic possible-errors table is not a complete annuity-domain specification.

Keep formulas at full precision when reconstructing the balance. Currency display rounding alone leaves the stored value unchanged; rounding each real payment or principal entry can create a different final balance. Actual irregular dates, fees or changing rates are outside this constant-period fixture.

IPMT supplies interest and PMT the whole installment. CUMPRINC totals principal for a selected span, with its own required arguments. SUM checks the explicit principal column.