Special offer

How Much Should I Pay for That House?

By
Industry Observer with Swanepoel T3 Group

As the housing market in St. Charles continues it’s steady improvement, more buyers are out looking for their next home. No buyer wants to overpay so I do a pretty extensive analysis to determine a fair price for the house. See an example of one of my spreadsheets below.

I use the MLS to find a decent size sample of recent comparable sales of similar property types that are in the same area as the subject property. Since few houses are exactly alike I make price adjustments for the difference in a side by side comparison. For example, if the subject property has a finished basement but the comparable sale does not, I add the value of a finished basement to the comparable so that it is more like the subject property.

After making the side by side adjustments, I put all the information into a spreadsheet (example below). A useful value to include is "Assessed Value" which is the amount that a house is taxed on. In Illinois, the township assessors try to equalize values across property types so that people pay a fair tax even though properties may be different. Assessed value is not the same as market value, but it can serve as a proxy for value in a market with few transactions (eg upper end  houses).

Finally, I take the ratios and apply them to the subject property to get a range for the predicted selling price.

  1. Sold Price as a percent of List Price
  2. Sold Price as a percent of Assessed Value
  3. Sold price per square foot.
In the example below the house was listed for $1,125,000 and we determined an estimated selling price of $1,031,000 to $1,102,000. Both buyer and seller could see that the home was offered at a fair list price. The buyer offered $1,025,000 and we quickly came to an agreement at $1,050,000. 
 

Alan Kirkpatrick
Austin Texas Homes - Round Rock, TX
Alan in Austin

Nice post and great information. Hope you have a great weekend. 

Jul 12, 2012 01:52 AM
Tim Lorenz
TIM LORENZ - Elite Home Sales Team - Mission Viejo, CA
949 874-2247

When markets turn to the upside it is often difficult to pay what it costs for a home.  Many buyers have to put in many offers losing all before they find that the market is not what they thought.

Jul 12, 2012 01:53 AM
Juli Vosmik
Dominion Fine Properties - Scottsdale, AZ
Scottsdale/Cave Creek, AZ real estate 480-710-0739

Leslie - great example of a very good cost analysis.  Now, I have to say, I'm still shocked by those taxes.  Some people pay more per month for their taxes than I pay for my entire PITI.  I know that when i moved from Wayne, my taxes were already over  $10,000 and that was 14 years ago.  WOWSERS.  

Jul 12, 2012 02:33 AM
Margaret Goss
@Properties - Winnetka, IL
Chicago's North Shore & Winnetka Real Estate

Your analysis is very detailed - I think putting it on a spreadsheet makes it so much easier to understand. 

Jul 12, 2012 03:35 AM
Adrian Willanger
206 909-7536 AdrianWillanger-broker.com - Seattle, WA
Profit from my two decades of experience

Leslie,  This is actual quite good, very through, I like the quick ratios you use after you have your totals. 

 

Thanks,

Jul 12, 2012 06:57 AM
Nick T Pappas
Assoc. Broker ABR, CRS, SFR, e-Pro, @Homes Realty Group, Broker/Providence Property Mgmnt, LLC Huntsville AL - Huntsville, AL
Madison & Huntsville Alabama Real Estate Resource

Leslie, I really do like this format, easy to read at a glance with all the right information.  Regarding Juli's comment about taxes...people don't realize how good they may have it in other areas.

Jul 12, 2012 07:57 AM
Hella Mitschke Rothwell
(831) 626-4000 - Honolulu, HI
Hawaii & California Real Estate Broker

Leslie: That's very thorough. If the sales price is higher, you will know what the market value is. And then the buyers will still ask, "how much should we offer?"

Jul 12, 2012 08:54 AM
Eric Michael
Remerica Integrity, Realtors®, Northville, MI - Livonia, MI
Metro Detroit Real Estate Professional 734.564.1519

Leslie, congrats on the feature! You do an awesome job of letting your buyers know what the price points are. Great thinking putting the spread sheet in there, too.

Jul 12, 2012 11:12 AM
Wayne Johnson
Coldwell Banker D'Ann Harper REALTORS® - San Antonio, TX
San Antonio REALTOR, San Antonio Homes For Sale

It is great when the house is priced within the market range initially, and the Buyer and Seller can come to a reasonable agreement for all concerned.

Jul 12, 2012 11:36 AM
Joan Whitebook
BHG The Masiello Group - Nashua, NH
Consumer Focused Real Estate Services

This post is very informative.  Often there are not clear cut comp or any comps in certain towns and certain price ranges.  Then, things can be very challening.

Jul 12, 2012 12:16 PM
Charles Stallions Property Manager
Charles Stallions Real Estate Services - Pace, FL
Pensacola, Pace & Gulf Breeze Property Management

Hope the folks enjoy this as much  as I did, very well put together and explains it well.

Jul 12, 2012 01:23 PM
Charlie Dresen
The Group, Inc - Steamboat Springs, CO
Steamboat Springs, CO e-Pro

I have to agree with some of the other responders that you have put together a very thorough analysis of the data.  Great post and excellent work.

Jul 12, 2012 01:52 PM
Tammie White, Broker
Franklin Homes Realty LLC - Franklin, TN
Franklin TN Homes for Sale

Leslie, I know in IL it is very common to add/subtract value for features. It just goes to show how markets vary from state to state. In TN, this is never done. I would actually prefer your way. Very thoughtful analysis. I wish more agents put in as much time as you do for your clients.

Jul 12, 2012 02:22 PM
Jordon Wheeler
The Jordon Wheeler Group - Fairburn, GA
J W Group Real Estate Sales and Service

Hi Leslie,

I go through a very similar process to help my buyers determine an offer price.  Most of them really appreciate the analytical aspect of the process.  Best of success to you and your team this year!

Jul 12, 2012 04:21 PM
Gene Mundt, IL/WI Mortgage Originator - FHA/VA/Conv/Jumbo/Portfolio/Refi
NMLS #216987, IL Lic. 031.0006220, WI Licensed. APMC NMLS #175656 - New Lenox, IL
708.921.6331 - 40+ yrs experience

So much of what we do has to be based on substantiation of information.  You have to be credible, for sure ... but you have to be able to back-up your thoughts, actions, process with facts.  Hard facts.  You do this incredibly well, Leslie ... and obviously those within this transaction reaped the benefit.  Guestimating is no longer enough ...

Gene

Jul 13, 2012 02:34 AM
Leslie Ebersole
Swanepoel T3 Group - Saint Charles, IL
I help brokers build businesses they love.

Darn, never saw that this was featured. Thanks to everyone who commented.

Jul 21, 2012 12:40 PM