Loan payment calculators
Loan Payment Calculator Formula: 12 Amortization Tests
An auditable fixed-rate payment formula, amortization schedule contract and twelve executed boundary tests for principal-and-interest calculators.
Direct answer
For an end-of-period, fixed-rate amortizing loan, calculate Payment = P × r ÷ (1 − (1 + r)^−n), where P is principal, r is the interest rate per payment period and n is the number of payments. If r is zero, use P ÷ n. State the rate convention, payment timing, excluded fees and rounding policy, then reconcile the final schedule row to the remaining unrounded balance.
Definition
A fixed-payment loan calculator estimates equal periodic principal-and-interest payments for a constant-rate amortizing loan. A reproducible result defines principal, periodic rate, payment count, payment timing, target final balance, excluded fees and rounding; it does not assume the displayed principal-and-interest amount is the borrower's complete bill.
Key findings
Verified 19 October 2026
- A fictional $10,000 principal at a 12% nominal annual rate over twelve monthly end-of-period payments returns $888.49 per month under the published contract.
- The same principal and term with payments at the beginning of each period returns $879.69 because every payment occurs one period earlier.
- A zero rate needs its own principal-divided-by-periods branch; feeding zero into the annuity denominator creates an undefined expression.
- The reference schedule totals $661.85 of interest and explicitly adjusts the final principal row to zero instead of exposing a floating-point residual.
What must a loan payment calculator define?
The formula is only one part of the contract. Store the inputs and policy version with the result so a schedule, CRM record and later explanation can be replayed.
LOAN-PAYMENT-FIXTURES
| Field | Published example | Why it changes the result |
|---|---|---|
| Principal | $10,000 | Amount amortized by the payment |
| Annual rate | 12% nominal | Must not be confused with an APR that includes fees |
| Periodic rate | 12% ÷ 12 = 1% | Matches the payment period |
| Payment count | 12 | Defines the amortization horizon |
| Timing | End of period | Beginning-period payments have a different present value |
| Final balance | $0 | Balloon loans need a different target |
| Rounding | Currency display; unrounded balance | Prevents compounding display-rounding drift |
What is the fixed loan payment formula?
For a positive periodic rate and end-of-period payments, use P × r ÷ (1 − (1 + r)^−n). The equivalent form P × r × (1 + r)^n ÷ ((1 + r)^n − 1) produces the same mathematical result. When r equals zero, use P ÷ n rather than evaluating a zero denominator.
Microsoft documents PMT for constant payments and a constant interest rate. That boundary matters: a variable-rate, irregular-date, interest-only, balloon or precomputed-interest contract is not validated merely because a PMT-shaped expression returns a number.
Worked example: $10,000 over twelve months
For a fictional $10,000 principal, 12% nominal annual rate, twelve monthly end-of-period payments and no fees, r = 0.12 ÷ 12 = 0.01 and n = 12. The formula returns $888.4878…, displayed as $888.49.
The reference schedule calculates each period's interest from the prior unrounded balance, applies the rest of the payment to principal and uses the exact remaining principal in the last row. It totals $661.85 of interest under the executed implementation and ends at zero.
What did the twelve boundary tests cover?
All twelve cases ran against the published reference implementation on 19 October 2026. They validate this narrow contract, not a named lender or every spreadsheet engine.
| ID | Boundary | Expected result |
|---|---|---|
| L01 | $10,000; 12%; twelve monthly periods | $888.49 |
| L02 | $1,200; 0%; twelve periods | $100.00 |
| L03 | Zero principal | Invalid input |
| L04 | Negative rate | Invalid input |
| L05 | Five years × twelve payments | 60 periods |
| L06 | 6% nominal ÷ twelve | 0.005 periodic rate |
| L07 | Beginning-period payment | $879.69 |
| L08 | Final amortization row | Zero remaining balance |
| L09 | Zero-rate schedule | Zero interest |
| L10 | Worked-example interest sum | $661.85 |
| L11 | Zero payment frequency | Invalid input |
| L12 | Zero term | Invalid input |
Why should interest rate and APR stay separate?
CFPB distinguishes the loan interest rate—the cost charged for borrowing—from APR, which measures the interest rate plus additional loan fees. A calculator should label the rate it uses and should not substitute APR into a contract-rate formula merely because both are percentages.
If the product estimates a broader cost of borrowing, model every included charge explicitly and explain the method. Otherwise, show principal and interest as a limited estimate and direct users to the lender's disclosures for the actual payment.
How should the amortization schedule reconcile?
Calculate interest from the prior unrounded balance. Subtract interest from the unrounded payment to obtain principal, then reduce the balance. Round only the values shown to the reader unless the actual contract specifies a different allocation rule.
On the last row, use the remaining principal rather than mechanically applying another displayed payment. Preserve both the computed payment and the adjusted final payment so the schedule explains any small difference caused by currency display.
Loan calculator release checklist
Release only when the interface, formula, schedule and downstream result use the same contract.
- Label the rate as nominal, effective or contract-specific.
- Distinguish the note rate from APR and list excluded fees.
- State payment frequency and beginning- or end-period timing.
- Define the zero-rate branch and reject invalid inputs.
- Keep unrounded balances while displaying rounded currency.
- Reconcile the final payment instead of showing a residual cent.
- Keep principal and interest separate from taxes, insurance and optional products.
- Give every input a visible label, expected format and accessible error.
Verification and correction path
The three primary guidance sources and all twelve deterministic fixtures were checked on 19 October 2026. If a result appears wrong, use the correction form and include principal, exact rate label, compounding or conversion convention, payment frequency, timing, term, target balance, fees, rounding policy and the expected schedule row.
Method and evidence
Evidence type: Versioned fixed-payment contract, worked amortization example and twelve executed deterministic boundary fixtures
- Defined principal, nominal annual rate, payments per year, term, payment timing, target final balance and excluded charges before applying the annuity formula.
- Separated the zero-rate branch from the standard fixed-payment formula and kept schedule balances unrounded until the display boundary.
- Executed twelve deterministic fixtures covering ordinary and beginning-period payments, zero interest, invalid inputs, frequency conversion, the final balance and interest reconciliation.
- Rechecked current Microsoft PMT documentation, CFPB amortization and interest-rate-versus-APR guidance, and W3C visible form-instruction guidance on 19 October 2026.
Topic score: 4.74 / 5. Business fit 4.8, verified demand 4.9, distinct intent 4.8, original evidence 4.8, citation usefulness 4.5, feasibility 4.4.
Primary sources
- Microsoft PMT function ↗Official syntax and scope for constant payments and a constant rate; checked 19 October 2026.
- CFPB amortization explainer ↗Official explanation of principal and interest allocation over an amortizing loan; checked 19 October 2026.
- CFPB interest rate versus APR ↗Official distinction between the interest rate and APR including additional fees; page updated 31 August 2026 and checked 19 October 2026.
- W3C form instructions ↗Visible labels, required-state and expected-format guidance for inputs; checked 19 October 2026.
Limitations
- This is an educational implementation and test model, not lending, legal, accounting or financial advice.
- The reference does not model adjustable rates, daily simple interest, irregular dates, negative amortization, precomputed interest, balloon balances, extra payments, fees, taxes, insurance or lender-specific allocation rules.
- The 12% example is fictional and is not a current market quote, recommendation or claim about available credit.
- No lender, spreadsheet product, named calculator builder, browser, assistive technology or production loan dataset was tested.
- Jurisdiction-specific disclosures, tolerances and consumer-credit rules are outside the fixture set.
Verification and corrections
Microsoft PMT, CFPB amortization and APR guidance, W3C form instructions and twelve deterministic formula fixtures verified 19 October 2026.
Recommended retest: Recheck after any rate convention, payment timing, fee, balloon, rounding, amortization or disclosure change.
Found an error or a changed standard? Use the correction process and include the page URL and primary evidence.
Next step
Apply the evidence to your next release
Use the published method, keep a dated test record and revisit the result after the calculator or its operating rules change.
Open the testing protocol