Mortgage Refinance Calculators: What Should They Tell You?
Deciding whether or not to refinance can be a complicated decision for borrowers, and a lot rides on getting it right. The good news is that many financial calculators designed to help in the decision process are freely available on the web. The bad news is that most borrowers have great difficulty finding a calculator that will help them, partly because they aren’t sure what their question is, and partly because they aren't sure how an answer ought to be formulated.
To do it right requires three steps. Step 1 is to clarify the question you want answered. Step 2 is to understand how the question ought to be answered. Step 3, discussed next week, is to find the online calculator that will answer your question properly.
Formulating the Question
Calculators are designed to answer a specific question, and it is important for the borrower to get the question right before looking for the calculator that will answer it. If your question is whether or not refinancing will reduce your mortgage payment, for example, you don’t need a refinance calculator – a simple mortgage payment calculator will do.
Most borrowers contemplating a refinance want to know whether the financial gain from a lower interest rate more than offsets the refinance costs. Most of the calculators on the web are directed to this question. Other reasons to refinance, such as raising cash or consolidating debts, receive little attention, as noted next week.
Comparing Refinance and StayPut Scenarios
A refinance decision involves a comparison of net costs under two scenarios, one where the borrower refinances, the other where he retains his current mortgage, over some future period. The period should be the borrower’s best guess as to how long it will be until the house is sold and the mortgage is paid off. For convenience, lets assume that period is 5 years.
In both scenarios, the borrower must pay principal and interest monthly for 5 years, and the balance outstanding at the end of the period. If he refinances, the new monthly payment and/or the balance after 5 years may be lower than if he stays put, but the borrower must also pay the upfront cost of refinance.
Measuring Net Costs
Economists would compare the two scenarios in terms of the net present value (NPV) of costs, or net future value (NFV), which if done correctly will always yield the same result. With NPV, all costs are valued at the beginning of the period, whereas with NFV, costs are valued at the end. I use NFV because I find that most people find it easier to grasp.
If the NFV is to be accurate, it must account for everything that impacts the cost net of benefits of both scenarios. This includes a) tax savings on interest and points using the borrower’s tax rate, b) mortgage insurance if it is required, c) the interest loss on payments made upfront and monthly using the borrower’s investment rate, d) whether the borrower elects to pay upfront costs in cash or add them to the loan balance, and e) whether and how the borrower plans to make extra payments in both scenarios.
Here is an example of an NFV calculation. Jones took out a $300,000 30year FRM at 6% 5 years ago which now has a balance of $279,163, and is considering refinancing into a 10year FRM at 5% with refinance costs of 1 point ($2792) plus $5,000 in fees. Jones is in the 31% tax bracket, earns 2% on his investments, and expects to be in his house another 5 years. Jones pays upfront refinance costs in cash rather than financing them, does not require mortgage insurance, and does not contemplate making extra monthly payments during the 5year period.
Over the 5 years, monthly payments will total $69,738 more if he refinances, reflecting the short term on the new mortgage. The refinance also involves $7792 in upfront refinance costs, $2975 more lost interest, and $7791 less tax savings than staying put. However, Jones will pay down his loan balance by $94,154 more if he refinances, resulting in an overall net gain of $6738. Breakeven, the period over which the gains just balance the losses, is 36 months.
Future Value Costs of Refinance Versus Costs of Staying Put

Refinance Costs 
Stay Put Costs 
Refinance Saving 
Total Monthly Payments 
$177,658 
$107,920 
$69,738 
Points on Refinance 
2,792 
2,792 

Other Refinance Costs 
5,000 
5,000 

Lost Interest on Refi Cost 
556 
556 

Lost Interest on Monthly Payments 
6,163 
3,744 
2,419 
Tax Savings on Interest 
17,825 
25,616 
7,791 
Reduction in Loan Balance 
 122,260 
28,106 
94,154 
Tax Savings on Points 
 880 
880 

Total 
$51,204 
$57,942 
$6,738 
I had a reason for selecting this particular example. The entire benefit is in the larger balance reduction, which borrowers preoccupied with the monthly payment, a malady I call “payment myopia”, tend to overlook. A properly designed calculator is not vulnerable to payment myopia.
For a discussion of how well internetbased refinance calculators do, see Do InternetBased Refinance Calculators Tell You the Truth?