Admin

Better Real Estate Through Math #2 - The Reverse Median Tax Search

By
Real Estate Agent with Baird and Warner

In this post I am going to add the Reverse Median Tax Search to the Predictive Value Model. I am fiercely proud of our profession and I am always trying to make sure that I am serving my clients at the highest level I am able to provide. We handle the largest asset in most people’s lives, and I think it’s reasonable to take that responsibility seriously.       

The Predictive Value Model is the result of that core principal and my interest in applying math and data analysis to the process. I talked about the traditional CMA as one piece of the model. There are actually seven components to the model.    

Today I would like to talk about the Reverse Median Tax Search. The idea here is to find out what similarly assessed properties actually sold for during the past 6 months. First find out the property tax for the subject property. Using that value, create a tax range of plus or minus 5% and do a search of properties that have closed in the past 6 months in the same tax district using tax range as your only filter, and find the median value.

I really like this method. It is giving you a picture of properties that the assessor has valued similarly to your subject regardless of their makeup. There are a few things to take into account when including or excluding properties here. Do not include new properties unless they are fully assessed, here in Illinois we assess in arrears and new construction will skew the sample. If you are including short sales and foreclosures, I would suggest applying compensation. This result will add another component to your value model and help to reduce the margin of error.

I want to relate a story of a home that I used the model to value at 710 Brigham Ct, Geneva IL a couple of months ago. This was a relo property and after submitting my analysis the coordinator called and asked me if I was sure that my value was accurate. Now I am used to being questioned about my values because they are usually lower than what other Realtors have given the home owner, so when he said I was $50,000 higher than the other two Realtors I was shocked and  rechecked the model. I felt that I had done the analysis correctly, but I was still pretty nervous. The home sold in 4 days for $360,000 the model predicted $359,123. I know that there is luck involved, having the right buyers show up at the right time and what competition exists, but it really impressed the coordinator. He wanted to know if I would give him the model.

  710 Brigham Ct, Geneva IL

Next time...Sold Percentage of Assessed Value.

 

Please see the other posts in this series.

Better Real Estate Through Math #1

 

Posted by

 

This post was written by Paul Chadwick, Broker Associate, Baird and Warner Real Estate.

I list and sell homes in the Fox Valley of Illinois

St Charles, Geneva, Batavia, Elburn and Wayne

I can be reached at 630-802-9406 or paul.chadwick@bairdwarner.com

Comments(2)

Show All Comments Sort:
Denise Hamlin, Broker/Owner
Cardinal Realty ~ 319-400-0268 - Iowa City, IA
Helping Happy Clients Make Smart Choices

Hi Paul ~ This is quite a series you've got going here. Definitely not for the faint of heart.

I do have one question for you. Are you pulling all your information from the MLS? Since you're talking about the assessed value here I'm wondering whether you're pulling data from the assessors page. It seems that would skew the numbers with the rise of FSBO's. Or do you adjust the compensation to make that work, as it appears you do with shortsales and foreclosures?

Nov 20, 2010 02:59 AM
Paul Chadwick
Baird and Warner - Saint Charles, IL

Denise, I use tax records, the assessor, the MLS and Realty Trac.

Distressed properties do factor in, but they need adjustment based on how difficult they are to purchase.

For example, for a move up buyer a short sale is a much more complicated move

In Illinois we assess in arrears and it is a 3 year rolling average for the assessment.

Nov 21, 2010 01:26 AM