mortgage refinancing, refinancing decision, calculators, refinance, when to refinance, where to refinance, refinance calculator, break-even period, refinancing, mortgage refinance, refinance rule of thumb

Do Internet-Based Refinance Calculators Tell You the Truth?
February 28, 2011

In Mortgage Refinance Calculators: What Should They Tell You? I suggested that the net benefit of a refinance to the borrower should be measured by the net present value (NPV) or net future value (NFV) of all benefits and costs. Whether the refinance increases or decreases the rate at which the loan balance is paid down is an important but often overlooked benefit or cost that should be captured by a refinance calculator.

## Testing Calculators

I use two examples to test how a calculator works, In one I assume a significantly lower rate on the new loan and low refinance costs, but the new loan carries a 10-year term and therefore a higher payment than the old loan. The calculator should recognize that this is a great refinance for the borrower who can afford the new payment because of the rapid pay-down of the balance.

In the second test scenario, the new loan has a higher interest rate than the old loan but because the new term is much longer than the remaining term on the old loan, the new payment is lower. The calculator should recognize that unless the borrower needs the lower payment to avoid default, the refinance is a loser because of the much slower reduction in the balance.

## Early Web-Based Calculators

I first looked at web-based refinance calculators about 10 years ago when I found a fairly consistent error in most of them. They defined the break-even period as the cost of the new loan divided by the reduction in the monthly mortgage payment. In my first test scenario, they erroneously told borrowers that this refinance was a loser.

This approach panders to the preoccupation of many borrowers with the monthly payment, and it is wrong. It totally ignores differences between the old mortgage and the new one in how rapidly the loan balance is paid down.

## Current Web-Based Calculators

Recently, I set out to see what difference 10 years has made. To select the sites, I entered “mortgage refinance calculators” in Google and examined the first 10 that appeared. These are among the most widely used calculators, and several of these sites are in  the business of licensing their calculators to other sites.

HSH.com and BankRate.com continue the erroneous practice of measuring breakeven as the ratio of refinance cost to payment change. These are very good web sites, but don’t use their refinance calculators. Note: After this article was published, HSH informed me that the calculator I looked at was an old one that had been replaced by a better one, except that the old one had never been taken down -- presumably because Google liked it! The new calculator is clearly better but I have not assessed it.

Calculators4mortgages.com uses total interest payments as its sole measure of the net benefit from refinancing, which also ignores changes in the balance. This site, furthermore, considers the down payment to be part of the refinance costs, which is nonsensical. Don’t go near this calculator.

LendingTree.com has a payment calculator only and should never have come up in my search.

Five sites calculated the break-even period as the ratio of refinance cost to the cumulated monthly interest savings, a measure I had never seen before. After dissecting it, I concluded that this measure is not as good as NFV because it does not explicitly take account of differences in balance pay-down, but it does do it indirectly and the error is small. The sites are Mortgage-calc.com, Realtor.com, Refinancecalculatormortgage.org, MortgageLoan.com, and Dinkytown.net. These are acceptable calculators.

The best of the 10 is mortgagecalculator.org, the only  that use NFV to measure the gains and losses from refinance. However, this calculator does not include lost interest or mortgage insurance, and does not allow the user to include refinance costs in the new loan balance, or make extra payments. My calculator Refinancing One FRM Into Another to Lower Cost does all that, but it doesn‘t come up in the first 10.

## Refinance Issues Most Calculators Don’t Cover

The 10 refinance calculators examined above all focus on the question of whether it pays to refinance one fixed-rate mortgage (FRM) into another. None deal with any of the following situations:

*Borrower wants to lower his rate, but has two existing mortgages to be refinanced into one or two new mortgages. See my Refinancing Two FRMs Into One to Lower Net Cost.

*Same but borrower also has short–term debt to be refinanced into one or two new mortgages. See my Debt Consolidation When Home Owner Has Two Mortgages

*Borrower wants to raise cash and needs to compare the cost of a cash-out refinance with the cost of a second mortgage. See my Cash-Out Refi of FRM Versus FRM Second Mortgage.

*Borrower has an adjustable rate mortgage (ARM) and wants to compare the cost of refinancing into an FRM with the benefit of reduced payment risk. See my Refinancing an ARM into an FRM to Lower Risk.

*Borrower wants to know whether paying down the loan balance to lower the cost of the refinance is a good investment. See my Refinancing an FRM with Balance Pay-Down.