Should you refinance your mortgage? This worksheet helps you compare your existing loan with a new offer using the figures that matter: rate, balance, remaining term, monthly payment, refinancing costs, penalties, and total interest. Run the calculation whenever rates, your finances, or your loan terms change, then use the result alongside your cash-flow needs and long-term plans.
Overview
Refinancing replaces your current mortgage with a new loan, usually secured against the same property. The new loan pays off the old balance, and you then make payments under the new rate, term, and conditions.
A lower interest rate can reduce the monthly principal-and-interest payment or help you repay the loan sooner. However, a lower payment does not automatically mean a lower overall cost. Extending the repayment period, adding fees to the balance, or borrowing extra cash can increase the total amount paid.
The central question is not simply, “Is the new rate lower?” It is: Will the financial benefit of the new loan outweigh its costs during the period you expect to keep it? A useful first screen is the break-even period:
Break-even months = total refinancing costs ÷ monthly payment savings
This calculation is only a starting point. You should also compare the remaining total interest, the loan term, any early-repayment charge, and the risks of changing from a fixed rate to a variable rate or vice versa.
How to estimate
Use this five-step mortgage refinance comparison.
- Record the current loan. Note the outstanding balance, interest rate, payment frequency, monthly principal-and-interest payment, and remaining term. Check whether the current payment includes taxes, insurance, or other charges; exclude those items when comparing loan payments.
- Collect the full refinance offer. Record the proposed rate, loan amount, repayment term, payment frequency, and whether the rate is fixed, variable, or subject to a future adjustment. Ask for an itemized estimate of every cost.
- Add the refinancing costs. Include lender fees, points or rate-buydown charges, appraisal or valuation costs, legal or settlement charges, registration expenses, and any prepayment or early-repayment penalty on the existing loan. If costs are added to the new balance, include them in the loan amount rather than treating them as free.
- Calculate the new payment and savings. Compare principal-and-interest payments on an equivalent schedule. A mortgage calculator can estimate the payment, but verify the result against the lender’s disclosure because compounding and payment conventions differ.
- Test your break-even and exit date. Divide the total upfront cost by the monthly saving. If you expect to sell, move, refinance again, or repay the loan before break-even, the offer may not recover its costs.
For a deeper comparison, calculate the estimated total remaining payments under both loans. Then subtract the remaining principal from each total to estimate interest. Add upfront refinancing costs to the new loan’s interest estimate. This is more informative than comparing monthly payments alone.
Inputs and assumptions
Prepare the following worksheet before speaking with lenders:
- Current balance: the amount still owed, not the original loan amount.
- Current rate and type: fixed, variable, or another structure, including when the rate may change.
- Remaining term: the time left until the current loan is scheduled to be repaid.
- Current payment: separate principal and interest from taxes, insurance, association dues, and other housing costs.
- New rate and term: compare the same remaining term first, then test shorter and longer terms separately.
- All closing costs: request a written, itemized estimate rather than relying on a headline rate.
- Points and credits: determine whether paying more upfront lowers the rate and how long you must keep the loan to recover that cost.
- Prepayment restrictions: check the current mortgage documents and ask how the charge would be calculated.
- Cash-out amount: if you are accessing equity, include the extra borrowing in both the payment and total-interest comparison.
Keep assumptions consistent. Compare payment frequency with payment frequency, include the same number of payments in each scenario, and do not assume the property’s value will rise. A refinance may also affect loan-to-value, insurance requirements, or eligibility, so confirm those details with the lender and relevant professionals.
Worked examples
These figures are illustrative only and are not a market quote. Suppose a homeowner owes $250,000 on a loan at 6.50% with 20 years remaining. The estimated principal-and-interest payment is about $1,864 per month.
A new 20-year loan at 5.75% produces an estimated payment of about $1,757. The monthly saving is approximately $107. If refinancing costs total $6,000, the simple break-even calculation is:
$6,000 ÷ $107 = about 56 months
The homeowner would need to keep the new loan for roughly four years and eight months before the payment savings recover the refinancing costs. The actual result may differ if the rate changes, fees are financed, payments are structured differently, or the borrower makes extra payments.
Now test a longer term. A 30-year refinance at the same 5.75% rate would reduce the estimated payment to about $1,459, creating a much larger monthly saving. But the borrower would be making payments for an additional decade. Even with the lower rate, the total interest can be substantially higher than keeping a 20-year repayment schedule. This option may suit someone who needs immediate cash-flow relief, but it is not automatically the cheapest option.
Finally, compare a shorter term. A 15-year refinance at 5.75% would have a higher monthly payment than the current loan, but it could reduce the repayment timeline and interest cost. That may be appropriate for a homeowner with stable income who prioritizes faster debt reduction over lower monthly payments.
When to recalculate
Revisit the worksheet when refinance rates move enough to change the payment difference, when your credit or income changes, or when your fixed-rate period is approaching its end. Recalculate after a substantial principal payment, a change in property value, or a lender’s new offer. Also run the numbers before using cash-out refinancing for renovations, debt consolidation, or other spending; the benefit should be compared with the added interest and the fact that more of your home secures the debt.
Before applying, request comparable written offers and confirm whether each rate is fixed or variable, how long it is available, which fees are refundable, and whether points are included. Use the same loan amount and term in each quote. Then complete this action list:
- Download your latest mortgage statement.
- List every refinance cost and any current-loan penalty.
- Run same-term, shorter-term, and longer-term scenarios.
- Calculate the break-even month and your expected time in the home.
- Compare total interest, not just the new monthly payment.
- Review the final disclosure before committing and ask about any unexplained change.
A refinance is most persuasive when the savings survive a conservative comparison: realistic costs, a clear holding period, and a repayment term that matches your goal. Re-run the worksheet whenever those inputs change.