calculate-loan

01 Loan payments

Home Loan Interest Rate Savings Calculator

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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.

This calculator shows how much total interest you can save on a home loan by making extra payments or by choosing a shorter loan term. You enter your loan amount, interest rate (APR), and current term, then optionally add an extra monthly payment or a target payoff time; the calculator returns your monthly payment, total interest, and the interest savings compared to the standard schedule.

Formula

The standard monthly payment for a fixed-rate loan is calculated using the amortization formula:

M = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • M = monthly payment (in dollars)
  • P = loan principal (in dollars)
  • r = monthly interest rate = APR / 1200 (as a decimal)
  • n = total number of monthly payments (years × 12)

To find the payoff time with an extra payment, we solve for the number of months k such that the remaining balance reaches zero:

k = ceil( −ln(1 − r × P / (M + E)) / ln(1 + r) )

Where E is the extra monthly payment. The total interest paid with the extra payment is then (M + E) × k − P. Savings are simply the standard total interest minus the new total interest.

Worked Example

Using the default values: loan amount $200,000, APR 6.5%, term 30 years, extra payment $200 per month.

  1. Monthly rate: r = 6.5 / 1200 = 0.0054166667
  2. Number of payments: n = 30 × 12 = 360
  3. Standard monthly payment: M = 200000 × (0.0054166667 × (1.0054166667)^360) / ((1.0054166667)^360 − 1) = $1,264.14 (rounded to cents)
  4. Standard total interest: 1264.14 × 360 − 200000 = $455,090.40 − 200,000 = $255,090.40
  5. Payment with extra: 1264.14 + 200 = $1,464.14
  6. Months to payoff: k = ceil( −ln(1 − 0.0054166667 × 200000 / 1464.14) / ln(1.0054166667) ) = ceil( −ln(1 − 0.7397) / 0.005401 ) = ceil( −ln(0.2603) / 0.005401 ) = ceil( 1.346 / 0.005401 ) = ceil(249.2) = 250 months
  7. Total interest with extra: 1464.14 × 250 − 200000 = $366,035 − 200,000 = $166,035
  8. Interest savings: 255,090.40 − 166,035 = $89,055.40

The calculator shows the same figures: monthly payment $1,264.14, standard total interest $255,090.40, payoff in 250 months, total interest with extra $166,035, and savings of $89,055.40.

Assumptions

  • The interest rate is fixed for the entire loan term.
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR / 12.
  • The extra payment is applied directly to the principal, not to future payments.
  • No fees, taxes, insurance, PMI, or escrow amounts are included.
  • The result is an estimate; your lender’s disclosure gives exact figures.

How to Use This Calculator

Enter your current loan balance, your annual interest rate (APR), and the remaining term in years. Then decide what you want to test:

  • Extra monthly payment: Type an amount you can add each month (e.g., $100, $250). The calculator shows how many months you shave off and the total interest saved.
  • Compare scenarios: Run the calculator once with $0 extra to get the baseline, then again with your proposed extra payment. The difference in total interest is your savings.

You can also use the calculator to see the effect of a shorter term: set the term to 15 years instead of 30, with no extra payment, and compare the total interest. That gives you a direct comparison of two different loan structures.

Common Mistakes and Misconceptions

  • Using the nominal rate instead of APR: The APR includes some fees and is the correct rate to use for payment calculations. Using a lower teaser rate will understate your payment.
  • Forgetting that extra payments reduce principal: Some borrowers think extra payments just sit in an account. In this calculation, the extra amount is applied directly to the principal each month, which is how most lenders handle it if you request it.
  • Ignoring the time value of money: Saving $89,000 in interest over 20 years is not the same as having $89,000 cash today. The calculator does not discount future dollars; it simply sums the nominal interest paid.
  • Rounding too early: If you round the monthly payment to $1,264 before computing payoff months, you may get a slightly different number. The calculator uses the exact payment internally and only rounds the display.

When to Use This Calculator

Use it when you are considering making extra payments on an existing mortgage, or when comparing a 30-year versus a 15-year loan at the same rate. It also helps you see how a lump-sum payment (entered as an extra monthly amount) affects your total interest. It is not a substitute for a full amortization schedule, but it gives a quick, accurate estimate of the savings.

If you have a variable-rate loan, the calculation is only valid for the period when the rate stays constant. For adjustable-rate mortgages, you would need to re-run the calculation each time the rate changes.

Limitations of the Formula

The standard amortization formula assumes level payments and a constant interest rate. It does not account for:

  • Prepayment penalties that some lenders charge
  • Changes in interest rates for adjustable loans
  • Property taxes and insurance that are often escrowed
  • Biweekly payment plans (which effectively make an extra payment per year)

For biweekly payments, you would need to adjust the inputs: set the term to 26 years (since 26 half-payments equal 13 full payments per year) and divide your monthly payment by 2. That is a separate calculation not covered here.

Frequently Asked Questions

Does making extra payments always save interest?

Yes, as long as the extra amount is applied to the principal and the loan has no prepayment penalty. The earlier you make the extra payment, the more interest you save because the principal balance is reduced sooner, lowering the base on which future interest is calculated.

What is better: a shorter term or extra payments?

Mathematically, both reduce total interest. A shorter term (e.g., 15 years) typically forces a higher monthly payment, while extra payments on a 30-year term give you flexibility. The calculator lets you compare both scenarios side by side by changing the term or the extra amount. Neither is universally “better” – it depends on your cash flow and goals.

How do I know my real APR?

Your APR is stated on your loan estimate or closing disclosure. It includes the interest rate plus certain fees and points. If you are shopping for a new loan, the lender must provide the APR. Use that number in the calculator, not the advertised nominal rate.

Can I use this calculator for a refinance?

Yes. Enter the new loan amount (your remaining balance plus any refinance costs), the new APR, and the new term. The calculator will show the monthly payment and total interest for the new loan. To compare with your current loan, run the calculator with your current balance and rate first.

What if I make a lump-sum payment instead of monthly extra?

This calculator is designed for monthly extra payments. For a one-time lump sum, you would need to recalculate the balance after the lump sum and then run the calculator again with the reduced balance. A rough approximation is to divide the lump sum by your monthly payment to see how many months it would skip, but the interest savings will be slightly different because interest accrues daily.

Why does the calculator show “Cannot compute” for some inputs?

That happens when the extra payment is so large that the monthly payment (including extra) exceeds the principal plus interest in the first month, or when the payment does not cover the monthly interest. If the extra payment is more than the standard payment, the loan would be paid off in a few months, which is fine, but the formula for payoff months assumes a positive balance. Check that your extra payment is not larger than the standard payment.

This calculator provides an estimate for educational purposes; your lender’s amortization schedule and disclosure will provide the exact figures.

Related

Formula used
in p | Loan amount | $ | 200000 | 1 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Loan term | years | 30 | 1 | 50
in extra | Extra monthly payment | $ | 200 | 0 | 1000000
out pmt | Monthly payment (without extra) | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int_std | Total interest (standard) | $ | pmt * yrs * 12 - p | 2
out months_new | Months to payoff with extra | months | ceil(round(-ln(1 - (apr / 1200) * p / (pmt + extra)) / ln(1 + apr / 1200), 6)) | 0
out int_new | Total interest with extra | $ | (pmt + extra) * months_new - p | 2
out savings | Interest savings | $ | int_std - int_new | 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 →