# Getting Real

## Understanding The True Value Of A Lower Mortgage Rate

A couple of weeks ago I published a guest post on using APR to shop for a mortgage. In short…it gets complicated. One of the more challenging aspects of analyzing different mortgage options is figuring out the tradeoff between the up front fees and the mortgage rate. In other words…are you better off with lower fees and a higher interest rate or higher fees and a lower interest rate?

If you thought the APR discussion was complicated this gets even more complicated and we didn’t want to get into all the details in that particular post. So I thought I would revisit the issue today. Here are some of the key points:

• It’s not as simple as looking at the difference in the monthly payments and adding them up. Two different rates result in different principal repayment schedules and you have to factor that in also.
• You have to factor in how long you are likely to keep the loan because the vast majority of mortgages are refinanced or paid off (e.g. property sold) in only a few years.
• You have to factor in the time value of money – i.e. one dollar saved today is worth more than one dollar saved tomorrow

To figure out the dollar savings from a lower rate I actually had to create a spreadsheet with multiple formulas. If I want to run the analysis in reverse – how much of a rate reduction is required to offset lower up front charges – I actually have to use Excel’s goal seek functionality.

So, let me give you an example using the following base case: you are buying a \$400K home with 20% down and looking at a 3.75% 30 year amortized mortgage that will be kept for 5 years (a reasonable assumption from what I’ve read). Now, another lender comes along who can save you 1/8%. That’s worth \$1736. So basically the first lender needs to come in with \$1736 in lower up front costs to be competitive with the second lender.

On a related note you can use this same methodology to figure out if it’s worth buying down the rate on your mortgage. Well, actually you can’t because you don’t have my spreadsheet ðŸ™‚ But in the example above if you could buy the rate down by 1/8% for no more than \$1736 it would be a good deal.

So you don’t have my spreadsheet but you might be able to get close enough by running the two amortization schedules side by side and adding up the interest savings over time. Of course, to really do it right you would need to discount the savings over time. But simply adding them up might get you close enough if the time frame is short enough. It’s better than just winging it.

#MortgageRates #Mortgages

Gary Lucido is the President of Lucid Realty, the Chicago area’s full service real estate brokerage that offers home buyer rebates and discount commissions. If you want to keep up to date on the Chicago real estate market or get an insider’s view of the seamy underbelly of the real estate industry you can Subscribe to Getting Real by Email using the form below. Please be sure to verify your email address when you receive the verification notice.

Filed under: Mortgages

Tags: mortgage rates, Mortgages

• Welcome to ChicagoNow.

• ## Subscribe To Getting Real

Delivered by FeedBurner

• ### Meet The Blogger

#### Gary Lucido

After 20 years in the corporate world and running an Internet company, Gary started Lucid Realty with his partner, Sari. The company provides full service, while discounting commissions for sellers and giving buyers rebates.

• ### Recent posts

• #### Chicago Foreclosure Activity: No Signs Of The Feared Surge »

Gary Lucido on Getting Real
Posted May 20, 2022 at 11:56 am
• #### Chicago City Council Chops Up Neighborhoods In New Ward Map »

Gary Lucido on Getting Real
Posted May 18, 2022 at 11:05 am
• #### Chicago Real Estate Market Update: 2nd Highest April Sales In 17 Years »

Gary Lucido on Getting Real
Posted May 9, 2022 at 7:31 am
• #### Case Shiller: Strongest Growth In Chicago Area Home Prices In More Than 3 Decades »

Gary Lucido on Getting Real
Posted April 26, 2022 at 1:29 pm
• #### Chicago Foreclosure Activity Returning To Pre-Pandemic Levels »

Gary Lucido on Getting Real
Posted April 25, 2022 at 7:30 am

• ### Latest on ChicagoNow

• #### June's art fests will get your summer rolling

from Chicagoâ€™s Art and Beer Scene by Sher
posted today at 8:44 am
• #### "It's So Quiet, It's Loud" -Ryan Adams

from Cut Out Kid by radstarr
posted today at 6:14 am
• #### My ten-year plan goals at age seventy is to live long enough to make another ten-year plan

from I've Got The Hippy Shakes by Howard Moore
posted today at 6:11 am
• #### Four cast members leaving is not the end of Saturday Night Live

from I've Got The Hippy Shakes by Howard Moore
posted Monday at 12:16 pm
• #### The Third Soup

from Pantry to Plate by Barbara Revsine
posted Monday at 10:31 am