FinanceFormula-based · Runs in your browser

Loan Payment Table Generator

Generate a comparison grid of periodic payments across multiple interest rates and loan terms.

Preparing saved example…

Inputs

Enter the values you know. Optional fields may be left empty.

Local save controls below
Required
$
Required
Required
Required

Result

Updates as valid inputs change.

Calculated locally
Payment scenarios
Lowest periodic payment
Highest periodic payment
Compared loan amount

Saved locally, explained clearly

Drafts, calculations, scenarios, and workflow progress stay in this browser unless you export them.

Opening local database…

Calculation steps

Follow what happened from the selected formula to the displayed answer.

Show substituted values and intermediate working
Calculate current inputs to see the working.
  1. 1

    Formula selected

    The calculator uses the following formula or method.

    payment = principal × i ÷ [1 − (1+i)^−n] for each rate-and-term combination

  2. 2

    Values entered

    Your values are placed into the calculation.

    Enter values to see what is used in this step.

  3. 3

    Result calculated

    The formula or method produces the following result values.

    Results will appear after a successful calculation.

  4. 4

    Answer formatted

    Displayed values are rounded and formatted using each output’s configured precision.

Scenario comparison

Save working scenarios, then select two or three to compare. Formula versions and inputs remain visible.

No scenarios saved for this calculator yet.

Recent calculations

Successful calculations are retained locally according to your privacy settings.

No local history for this calculator yet.

Data and privacy

What this calculator does

Generate a comparison grid of periodic payments across multiple interest rates and loan terms.

How it works

The calculator evaluates payment = principal × i ÷ [1 − (1+i)^−n] for each rate-and-term combination. Inputs are checked before calculation, and invalid values such as zero denominators or out-of-range selections produce a clear error instead of a misleading result.

Input query strings and outputs

Use an input name in this page’s URL as ?name=value, and join additional inputs with &. Portable shared links may instead use the compact ?ac= state parameter.

Input query strings

4
  • ?loanAmount= Loan amount

    Money · Required · Default: 250,000

  • ?annualRates= Annual rates (%)

    Text · Required · Default: 5, 6, 7, 8

  • ?termsYears= Terms in years

    Text · Required · Default: 15, 20, 30

  • ?paymentsPerYear= Payments per year

    Number · Required · Default: 12

Outputs

4
  • scenarioCount Payment scenarios

    Whole number · Primary output

  • lowestPayment Lowest periodic payment

    Currency

  • highestPayment Highest periodic payment

    Currency

  • loanAmountOutput Compared loan amount

    Currency

Inputs and results

The inputs are Loan amount, Annual rates (%), Terms in years, Payments per year. Results include Payment scenarios, Lowest periodic payment, Highest periodic payment, Compared loan amount.

Sources
  • No external reference is listed for this calculator. Its formula and variable definitions are shown above.
Limitations
  • Estimates use the rates, timing, and assumptions entered. Fees, taxes, lender rules, and future changes are included only where explicitly shown.