PPMT in WPS Spreadsheet: Principal Repaid in One Period

=PPMT(rate, per, nper, pv, fv, type)

Rate applies to each payment interval, per selects a payment numbered 1 through nper, and pv is the initial present value. Fv specifies the final balance; the lesson documents zero when it is omitted. Type specifies end-period or beginning-period payments. All original formulas supply fv = 0 and type = 0 explicitly; they do not depend on omitted arguments or establish beginning-period results.

Use matching rate and period units. The walkthrough labels its rate as annual because its schedule pays annually; that label does not make every PPMT rate an annual rate.

For pv = 210, rate = 0.1 and nper = 2, the constant end-period payment has magnitude 121. First-period interest is 21, leaving 100 of principal repaid. The balance becomes 110. Second-period interest is 11, leaving 110 of principal repaid and a zero final balance.

1. Enter the rate 0.1, total periods 2 and present value 210 in B1:B3.
2. Put period numbers 1 and 2 in A6:A7.
3. Enter =PPMT($B$1,A6,$B$2,$B$3,0,0) in B6 and copy down.
4. Independently expected outputs are −100 and −110.

The negatives are repayment cash flows. To reconstruct the balance using these signed outputs, add each negative principal component to the opening balance: 210 + (−100) = 110, then 110 + (−110) = 0.

For the second pair, the equal payment magnitude is 72. Interest magnitudes 22 and 12 leave principal magnitudes 50 and 60. The third pair is a scaled version of the first schedule.

A payment schedule should reconcile three ways. First, principal repayments should sum to the reduction in balance. Second, principal plus interest should equal the full payment in each period. Third, the closing balance of one period should equal the opening balance of the next.

For the first schedule, signed principal totals −210 and signed interest totals −32, giving total payments −242. Dividing the original principal evenly would produce 105 per period, a different repayment model. Equal payments do not mean equal principal components.

PMT concerns the complete payment. CUMIPMT concerns accumulated interest, while SUM can help check a separately constructed schedule. Keep fees and other contractual charges separate unless the model explicitly incorporates them.

The WPS demonstration uses 7.3%, five annual payments and principal 400000. Its displayed principal amounts increase from approximately 69141.19 to 91650.69. Rounded displayed rows can differ by a small currency rounding amount from their full-precision total; the mathematical schedule repays the original principal.

Preserve absolute references to shared inputs when copying the formula and a relative reference to the current period. A period below 1 or above nper falls outside the documented definition. The lesson does not establish a comprehensive invalid-input error table, fractional-period behavior or the handling of real-world rounding policies. These controls use positive rates and integer periods only.

The official WPS lesson is dated 2019-05-28 and explicitly labels WPS Office for Windows Personal. Its numeric build is unspecified. This documents the function by that date; it does not establish first introduction, the last functioning build, other-platform parity or a retirement/deprecation history.

The complete lesson and its formula images and walkthrough were inspected on October 18, 2026. Original examples are documentation-derived independent calculations, not WPS or other spreadsheet-engine executions. These fictional financial calculations explain a function, not the suitability of a financial product.