calculate-loan

01 Loan payments

Loan Refinance Break Even Calculator Formula

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

Break-even months -79.5 months
New monthly payment
$386.66
Level-payment formula, rounded to the cent
Total interest on new loan
$3,199.36
= New monthly payment × new loan term × 12 − current loan balance
Current loan balance
$20,000
Input
You enter
Current loan balance ($), New interest rate (APR) (%), New loan term (years), Total refinance costs ($)
You get
Break-even months (months), New monthly payment ($), Total interest on new loan ($)
Rounding
1 dp · 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.

This calculator works out how many months it takes for the savings from a lower monthly payment to cover the upfront costs of refinancing a loan. You enter your current loan balance, the new interest rate, the new loan term, and the total closing costs, and it returns the break-even point in months, plus the monthly payment and total interest under the new loan.

Formula

The break-even formula is simple: divide the total refinance costs by the monthly savings from the new loan. In symbols:

Break-even months = Total costs ÷ (Current monthly payment − New monthly payment)

Each variable means:

  • Total costs – all fees, points, and charges to close the new loan, in dollars.
  • Current monthly payment – what you pay now, in dollars per month.
  • New monthly payment – the payment on the new loan, in dollars per month.

The monthly payment for the new loan uses the standard amortization formula:

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

where P is the loan balance, r is the monthly interest rate (APR ÷ 12, expressed as a decimal, e.g., 6% APR → 0.06 ÷ 12 = 0.005), and n is the number of monthly payments (years × 12).

In this calculator, the current monthly payment is assumed to be the payment on the same balance at the original rate (8% APR for 5 years, the default). If you want to use your actual current payment, you can compute it separately and adjust the costs input accordingly, but the calculator uses the standard formula for both to keep the comparison consistent.

Worked Example

Using the defaults: loan balance = $20,000, new rate = 6% APR, new term = 5 years, costs = $1,500. The original loan is assumed to be 8% APR for 5 years.

Step 1: Compute the current monthly payment (at 8% APR, 5 years):

r = 8 ÷ 1200 = 0.0066667, n = 5 × 12 = 60

Payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1) ≈ $405.53

Step 2: Compute the new monthly payment (at 6% APR, 5 years):

r = 6 ÷ 1200 = 0.005, n = 60

Payment = 20000 × (0.005 × (1.005)^60) / ((1.005)^60 − 1) ≈ $386.66

Step 3: Monthly savings = $405.53 − $386.66 = $18.87

Step 4: Break-even months = $1,500 ÷ $18.87 ≈ 79.5 months

The calculator rounds to 79.5 months. That means you would need to stay in the loan for about 6.6 years just to recover the $1,500 in costs.

Assumptions

  • Both loans use fixed interest rates and level monthly payments.
  • Payments are made at the end of each month.
  • Interest compounds monthly at the APR divided by 12.
  • The current payment is calculated from the same balance and the original rate; if your actual current payment differs (due to a different balance or rate), the break-even will change.
  • Refinance costs are paid upfront and are not financed into the new loan.
  • No fees, taxes, insurance, or prepayment penalties are included unless you add them to the costs input.

How to Use the Break-Even Result

The break-even point tells you the time horizon over which the refinance starts to save money. If you plan to keep the loan longer than the break-even months, the refinance may be financially beneficial; if you might sell or pay off the loan sooner, you may not recover the costs.

Compare the break-even months to your expected time in the loan. For example, a break-even of 30 months on a 5-year loan means you need to stay at least 2.5 years to come out ahead. If you expect to move in 2 years, the numbers would not favor refinancing.

Also consider the total interest paid. A lower rate usually reduces total interest, but extending the term can increase it. The calculator shows the total interest on the new loan; compare that to your remaining interest on the current loan to see the full picture.

Common Mistakes and Misconceptions

  • Ignoring costs: Some people only look at the monthly payment drop and forget the upfront fees. The break-even calculator forces you to include them.
  • Using the wrong payment: Your actual current payment may include escrow for taxes and insurance. The calculator uses principal and interest only, so subtract escrow amounts from your real payment before comparing.
  • Mixing up APR and monthly rate: Always divide the APR by 12 to get the monthly rate. Using the annual rate directly will give a wildly wrong payment.
  • Rounding too early: Rounding the monthly payment to the nearest cent before computing savings can shift the break-even by a month or two. Keep full precision until the final step.
  • Assuming the rate is the only factor: Extending the term lowers the payment but may increase total interest. The break-even only covers costs, not the long-term interest trade-off.

How to Choose the Right Refinance Term

When refinancing, you often choose a new term. A shorter term (e.g., 3 years instead of 5) usually has a higher monthly payment but lower total interest. A longer term lowers the payment but may increase total interest, which can offset the savings from a lower rate.

To use the break-even calculator for term comparison, run it once with a 3-year term and once with a 5-year term, keeping the same rate and costs. Compare the break-even months and the total interest outputs. The term that gives a break-even within your expected holding period and a total interest you are comfortable with is the one to consider—but remember, the final decision depends on your cash flow and goals.

Also consider whether you plan to make extra payments. If you intend to pay off the loan early, the break-even period may shorten because you save interest faster, but the calculator assumes level payments for the full term.

Alternatives to Refinancing

If the break-even point is too long, other options might reduce your interest costs without the upfront fees:

  • Making extra principal payments on your current loan – this shortens the term and reduces total interest, with no closing costs.
  • Recasting (if your lender allows it) – a lump-sum payment that lowers your monthly payment while keeping the same rate and term, usually for a small fee.
  • Negotiating a rate reduction with your current lender – sometimes they will lower your rate for a modest fee, less than a full refinance.
  • Paying off the loan early with savings or a windfall – the ultimate way to eliminate interest.

Each alternative has its own trade-offs, so run the numbers with your actual figures.

Frequently Asked Questions

What if my current payment is different from the calculator’s assumption?

The calculator assumes your current payment is based on the same balance at the original rate (8% APR for 5 years). If your actual payment is higher or lower (due to a different rate, term, or balance), the monthly savings will change, and so will the break-even. To get a precise result, compute your actual current payment and adjust the costs input to reflect the true savings, or use a manual calculation: divide costs by (actual current payment − new payment).

Should I include closing costs that are rolled into the new loan?

If the refinance costs are financed (added to the loan balance), you are not paying them upfront, but you still pay interest on them over the life of the loan. In that case, the effective cost is higher than the nominal fee. For a true break-even, you should either enter the costs as the amount you actually pay out of pocket, or increase the loan balance in the calculator to reflect the financed costs. The calculator assumes costs are paid upfront, so adjust accordingly.

How does the break-even change if I make extra payments?

Extra payments reduce the principal faster, which lowers the total interest and can shorten the time to recover refinance costs. However, the break-even formula based on monthly savings assumes you make the required payment only. If you plan to make extra payments, you would recover costs sooner because you save more interest each month, but the exact timing requires a more detailed amortization schedule.

Is a shorter break-even always better?

Not necessarily. A very short break-even (e.g., 6 months) might indicate a large rate drop, but it could also come with a much longer term that increases total interest. Always look at both the break-even months and the total interest output. A longer break-even might still be acceptable if the total interest savings are substantial and you plan to keep the loan for a long time.

Can I use this calculator for auto loans or student loans?

Yes, the formula works for any fixed-rate amortizing loan, including auto loans, student loans, and personal loans. Just enter the current balance, the new rate, the new term, and the refinance fees. The break-even months will tell you how long you need to keep the loan to recover the costs.

Remember that this is an estimate for educational purposes; your lender’s official disclosure will provide the exact figures for your situation.

Related

Formula used
in p | Current loan balance | $ | 20000 | 1 | 100000000
in apr | New interest rate (APR) | % | 6 | 0.01 | 100
in yrs | New loan term | years | 5 | 0.0833 | 50
in cost | Total refinance costs | $ | 1500 | 0 | 1000000
out months | Break-even months | months | cost / ((p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) - (p * (8 / 1200) / (1 - (1 + 8 / 1200) ^ -(5 * 12)))) | 1
out pmt | New monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest on new loan | $ | pmt * yrs * 12 - p | 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 →