Special offer

Stacking up valuation models against the real world

By
Real Estate Appraiser

Most of us have seen comparisons between appraised values and the valuation models accessible via the web. I hadn’t seen an actual comparison to recent closed sales and these models, so thought it would be an interesting exercise to see how they stack up with properties that closed within the past couple of weeks in my local MLS.

The data that follows is a compilation of 21 recent sales in the Ann Arbor school district that closed in mid to late December 2013. These houses were exposed through the local MLS and picked up by a number of different valuation models. Since these houses were exposed on the open market, my thinking was that these models would be fairly accurate, but nothing seems to be further from the truth!  The value estimates are really all over the board as far as too high, or too low, with only a few exceptions.

The sales above are sorted by sales price. To help you read this chart, the layout is as follows: zip code and some comments about the property. The next column is the actual sales price, followed by a valuation model, followed by the percent difference between valuation model and sales price. For example, on the first sale, the sales price was $80,000 and the first estimate was $104,654 or 30.82% over-estimated compared to the sales price. There are a total of four different models used as well as the State Equalized Value from the tax roll (multiplied times two as is practice in Michigan). 

In general, the lower priced sales were over-estimated and the higher priced sales were under-estimated, but even standard subdivision houses that were exposed through the MLS had discrepancies in the variance. This was unexpected as they were on the market, in homogeneous areas, and not in need of work, so why did the models fail?

The models fail in my opinion, because the market is simply not perfect and can’t easily be measured by pure statistics. Value really relates to a specific market, buyer preferences, condition (can’t be measured by computer model) and locational nuances.

Instead of either overpricing a property based on potentially erroneous information in these models, or leaving money on the table by underpricing; hire a local expert to provide you an analysis of the market and how your property fits within it.

 

 

 

Wayne Johnson
Coldwell Banker D'Ann Harper REALTORS® - San Antonio, TX
San Antonio REALTOR, San Antonio Homes For Sale

Rachel-Your analysis shows that home Buyers and statistical valuations can and do see the same fact situations but can come to different conclusions. Statistics are rational, people, sometimes, have other drivers. 

Jan 04, 2014 01:58 PM
Rachel Massey, SRA, AI-RRS
Ann Arbor, MI
Proudly appraising Washtenaw County since 1989
Thanks for your comment. I see it a bit differently. What I see is the inability of a machine to analyze nuances related to condition, upgrades, floor plans and location. Also that machine cannot know what is truly comparable and uses more aggregate of un verified and quasi-filtered data. A Realtor or appraiser who knows the market will use what a likely buyer would look at, therefore narrowing data to what is comparable in terms of measuring likely sales price. While buyers can and often act irrationally, it is fairly rare to see variances anywhere near the level of these misses. Shown above, except the small ones. The times you see really large discrepancies on appraisals tend to be unusual properties with nothing comparable.
Jan 04, 2014 07:50 PM