calculate-loan

01 Loan payments

Plan Comparison Table Calculator

Calculator No. 01-17919 · Updated · Formula and assumptions shown below

Plan A monthly payment $405.53
Plan B monthly payment
$396.02
Level-payment formula, rounded to the cent
Payment difference, A minus B
$9.51
= Plan a monthly payment − plan b monthly payment
Interest difference, A minus B
$570.60
= (plan a monthly payment − plan b monthly payment) × loan term × 12
You enter
Loan amount ($), Plan A interest rate (APR) (%), Plan B interest rate (APR) (%), Loan term (years)
You get
Plan A monthly payment ($), Plan B monthly payment ($), Payment difference, A minus B ($), Interest difference, A minus B ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A plan comparison table helps you compare the payment and total interest for two fixed-rate loans using the same loan amount and term. Enter the amount, annual APR, and term for each plan to see the monthly payment and total interest side by side; the results are estimates, not lender quotes.

Formula

This comparison uses the standard fixed-payment, fully amortizing loan formula. For each plan, the monthly payment is:

M = round[P × r / (1 − (1 + r)−n), 2]

  • P is the loan principal, in dollars.
  • r is the monthly rate as a decimal: annual APR ÷ 1,200. For example, 8% APR gives 0.08 ÷ 12.
  • n is the number of monthly payments: term in years × 12.
  • M is the monthly payment in dollars, rounded to cents.

The calculator applies this calculation separately to Plan A and Plan B. “Payment difference” is Plan A’s payment minus Plan B’s. A positive result means A’s calculated payment is higher; a negative result means it is lower. “Interest difference” is the payment difference multiplied by the number of payments. Since both plans use the same principal and term, subtracting their total payments also subtracts the same principal, leaving the difference in estimated interest.

Worked Example

Using the default entries: a $20,000 loan, a five-year term, 8% APR for Plan A, and 7% APR for Plan B.

  1. Convert the term to payments: 5 × 12 = 60 months.
  2. Plan A’s monthly rate is 0.08 ÷ 12 = 0.0066667. Its unrounded payment is approximately $405.53, so the payment rounded to cents is $405.53.
  3. Plan B’s monthly rate is 0.07 ÷ 12 = 0.0058333. Its unrounded payment is approximately $396.02, so the payment rounded to cents is $396.02.
  4. Payment difference: $405.53 − $396.02 = $9.51 per month.
  5. Interest difference over 60 payments: $9.51 × 60 = $570.60.

These are formula-based values using rounded monthly payments. They do not represent an offer or a guarantee that a lender will calculate a loan in precisely the same way.

Assumptions

  • The APR remains fixed for the full term, and payments are level.
  • Payments occur monthly at the end of each monthly period.
  • Interest is calculated monthly using APR divided by 12.
  • The comparison excludes fees, taxes, insurance, PMI, escrow, discounts, and other charges because they are not inputs.

How to Read a Plan Comparison

The first two outputs show the estimated monthly payments. The third makes the monthly difference explicit, while the fourth estimates the difference in interest across the full term. The sign matters: a negative “A minus B” value means Plan A has the smaller calculated payment or interest total under these inputs.

For example, a payment difference of $9.51 does not by itself establish which plan has lower overall cost. A plan may include fees, a variable rate, a different term, or other conditions that the calculator does not model. A complete comparison needs equivalent loan amounts and terms, plus the actual payment schedule and charges disclosed for each offer.

What This Calculator Does Not Compare

The calculator compares only the principal, APR, and shared term. It assumes both plans are fixed-rate and fully amortizing, meaning the scheduled payments repay principal and interest by the end of the term. It does not model an introductory rate, rate changes, deferred payments, a balloon payment, or a payment that changes over time.

Fees can materially change the amount paid or the amount financed. If fees are paid separately or added to principal, the calculation will not reflect that unless the loan amount you enter already accounts for the financed amount. Taxes, insurance, escrow, and other recurring costs are likewise outside the result. Get each plan’s complete figures from the lender and check that you are comparing the same borrowing amount and repayment period.

Common Comparison Mistakes

  • Comparing different terms as if they were equivalent: a longer term can reduce the monthly payment while increasing the number of payments. This calculator uses one term for both plans.
  • Entering a percentage as a decimal: enter 8 for 8% APR, not 0.08. The formula converts the percentage to a monthly decimal rate.
  • Treating APR as every borrowing cost: the calculator uses APR in its payment formula, but does not separately add fees or other costs. Review the lender’s written figures.
  • Ignoring rounding: payments are rounded to cents before the interest difference is calculated. A lender’s schedule can differ slightly because of payment dates, daily interest, or its rounding method.
  • Assuming a lower payment means less interest: payment size depends on both rate and term. Compare the total scheduled payments and the full offer details, not only the monthly figure.

Frequently Asked Questions

What does a plan comparison table show?
It lays out key figures for multiple borrowing plans so they can be reviewed side by side. This calculator compares estimated monthly payments and the difference in interest for two fixed-rate plans with the same principal and term.

Can I compare plans with different loan terms?
Not directly with this calculator, because it has one shared term input. To examine different terms, calculate each separately using its own term and compare the resulting payment and total repayment, while noting that the schedules differ.

Does APR include all loan fees?
This calculator does not determine which charges are included in a quoted APR. It treats the entered APR as the annual rate for the payment formula and does not add separate fees. Refer to the lender’s disclosure for the offer’s stated costs.

Why might my lender’s payment differ?
The lender may use different rounding, payment dates, daily-interest calculations, financed charges, or terms not represented here. Confirm the principal, rate, payment count, and schedule against the lender’s disclosed figures.

Can I use this for a variable-rate plan?
Not reliably. The formula assumes one fixed APR throughout the repayment period. A variable-rate plan can change its rate and payment, so its future total cannot be represented by this fixed-rate comparison.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr1 | Plan A interest rate (APR) | % | 8 | 0.01 | 100
in apr2 | Plan B interest rate (APR) | % | 7 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt1 | Plan A monthly payment | $ | round(p * (apr1 / 1200) / (1 - (1 + apr1 / 1200) ^ -(yrs * 12)), 2) | 2
out pmt2 | Plan B monthly payment | $ | round(p * (apr2 / 1200) / (1 - (1 + apr2 / 1200) ^ -(yrs * 12)), 2) | 2
out diff | Payment difference, A minus B | $ | pmt1 - pmt2 | 2
out intdiff | Interest difference, A minus B | $ | (pmt1 - pmt2) * yrs * 12 | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →