Keepin' It Real Estate: How Good is Zillow?

By Andrew Jeffery Feb 12, 2009 10:00 am
Getting to the "bottom" of the housing market.
  • Share this article:


Americans finally get it: Home prices are falling.

This may seem like a preposterous statement, what with the entire global financial system in disarray after the collapse of the US housing market, but we Americans are stubbornly optimistic people, content to ignore calamity as long as we possibly can.

A study released this week by Zillow, a real estate information website best known for its wildly inaccurate estimates of property valies, shows Americans have finally succumbed to the notion that home prices aren't going up anymore. 57% of homeowners polled believe their own home lost value during 2008, up from 38% who felt that way just 6 months earlier.

Interestingly, when asked about the future, respondents were upbeat: Only 30% estimate the value of their house will decrease in the next 6 months. Of course, their neighbors aren’t so lucky: Forty-seven percent believe home values in their local markets will fall during the same time period.

Zillow has become something of a cult phenomenon in the past few years, as it  allows homeowners to go online and see how much their house is “worth.” By its own admission, Zillow’s values are merely estimates based on amalgamating sales data from nearby homes, comparing bedroom counts, living area, lot size and other salient characteristics.

What few people realize, however, is that Zillow’s valuation algorithm isn’t just used by John Q. Homeowner: Every big lender in the country uses a similarly opaque formula to price real estate.

Wells Fargo (WFC) -- now the biggest US home lender in the country after its acquisition of Wachovia -- holds tens of thousands of mortgages on its books, each backed by a unique house. It’s impractical to regularly review each home for a fresh value, so Wells and other big banks like Citigroup (C), JP Morgan (JPM) and Bank of America (BAC) rely on analytics firms to provide property values churned out by what are called Automated Valuation Models, or AVMs.

AVMs rely heavily on recent sales data to drive their valuation estimates. This works reasonably well in a vanilla market, one where home prices move uniformly in a single direction - namely up. Even rapidly rising prices are well accounted for, since liquid markets provide reliable, normal data sets upon which calculations can be made.

AVMs are a bit behind the curve in an appreciating market, offering a conservative estimation of a home’s value. But in a declining, choppy, illiquid market like the one we’re in now, AVMs fall apart.

As sales volume dries up and prices gap down, transactions that are even 3 months old become woefully out of date. Even in distressed markets that are now seeing frenetic buying activity, active listings -- and therefore true market prices -- are well below all but the most recent sales.

By using AVMs to value housing assets, banks are constantly underestimating losses in a declining market. Unfortunately, there isn’t much of an alternative.

Small, independent valuation firms offer the most reliable estimations of value, but they specialize in local markets by definition, which limits the scale with which huge lenders can effectively use their results to evaluate nationwide portfolios of loans.

Next time you laugh at Zillow’s estimation that a home that just sold for $250,000 is really “worth” between $315,000 and $375,000, remember that your bank is looking at the same data. No wonder they keep asking Uncle Sam for so much money.
< Previous
  • 1
Next >
No positions in stocks mentioned.

The information on this website solely reflects the analysis of or opinion about the performance of securities and financial markets by the writers whose articles appear on the site. The views expressed by the writers are not necessarily the views of Minyanville Media, Inc. or members of its management. Nothing contained on the website is intended to constitute a recommendation or advice addressed to an individual investor or category of investors to purchase, sell or hold any security, or to take any action with respect to the prospective movement of the securities markets or to solicit the purchase or sale of any security. Any investment decisions must be made by the reader either individually or in consultation with his or her investment professional. Minyanville writers and staff may trade or hold positions in securities that are discussed in articles appearing on the website. Writers of articles are required to disclose whether they have a position in any stock or fund discussed in an article, but are not permitted to disclose the size or direction of the position. Nothing on this website is intended to solicit business of any kind for a writer's business or fund. Minyanville management and staff as well as contributing writers will not respond to emails or other communications requesting investment advice.

Copyright 2010 Minyanville Media, Inc. All Rights Reserved.

(12)
2009-02-12 10:27:54
Zillow? Not so much
Andrew, I just finished re-financing my 5/1 to a 30 year fixed. I had been watching my home value on Zillow fall from a high of $340k to a current value of $256k over the past year. My lender charged me $400 to send an appraiser to my house and came back with a valuation of $285K. I hope that after digesting our current financial implosion, that bankers are going to adopt the latter standard, rather than the Zillow model.
2009-02-12 10:53:19
zillow...
I sold a home in Tiburon, Ca. in late '05 for 2.5 mil...zillow now says it's worth 3.5 mil...hahahahahaha
2009-02-12 11:09:28
Crooks and Liars
"Appraisers" are nothing more than order takers, finding out what the bank needs to get to to offer you a refi or mortgage. The bank says "I need X" and surprise surprise the appraiser comes back with X.

In my area Zillow isn't that far off of what homes are selling for, and what I've seen is that the algorithm updates itself pretty quickly. Not always accurate, but at least in the ballpark.
2009-02-12 11:51:12
AVMs rely heavily on recent sales data to drive their valuation estimates. This works reasonably well in a vanilla market, one where home prices move uniformly in a single direction - namely up. Even rapidly rising prices are well accounted for, since liquid markets provide reliable, normal data sets upon which calculations can be made.
AVMs are a bit behind the curve in an appreciating market, offering a conservative estimation of a home's value. But in a declining, choppy, illiquid market like the one we're in now, AVMs fall apart.
As sales volume dries up and prices gap down, transactions that are even 3 months old become woefully out of date. Even in distressed markets that are now seeing frenetic buying activity, active listings -- and therefore true market prices -- are well below all but the most recent sales.
By using AVMs to value housing assets, banks are constantly underestimating losses in a declining market. Unfortunately, there isn't much of an alternative.


This scenario seems familiar to me, let's see where have a I heard this song before...oh yes, it's exactly what's going on with the banking derivatives crisis...except homeowners don't have to mark-to-market...I guess those trusty VaR models have the same tendencies as the AVMs!
2009-02-12 12:15:37
The falling home prices have been confirmed by the Fiserv/S&P Case-Shiller Home Price index. This is the gold standard for home prices; no matter what one may think of Zillow, it's hard to argue with the Case-Shiller data. www.estimike.com.
2009-02-12 13:21:38
Crooks and Liars
If you had accompanied the appraiser at my home, you would realize how wrong you are.
2009-02-12 15:06:32
Crooks and Liars
Loyd, when we bought our house last year, it was 'appraised' at EXACTLY the amount that we'd put in as an offer. Final sell-price was a couple grand less, and we went on our merry way.

This year we refinanced to lock in a better rate, and paid for an assessor to do a walkthrough. I now have a 12 page report, listing features, benefits, improvements, comparables, etc, and the assessed value is EXACTLY the amount that we closed on last year. I've spoken with several other people here at work and it's worked out to be exactly the same. If you need x% equity in your house for your loan, unless you're in CA, NV, FL, MI, etc, chances are your bank is going to let the appraiser know ahead of time what is the minimum number they need your house to be worth. Maybe it's different if you're in a more turbulent market or haven't refinanced your home in quite some time, but for us it was definitely a complete sham.
2009-02-12 16:17:24
Crooks and Liars
Travis,
My appraiser did not know how much I was re-financing, I asked. And I was only re-financing 30% of the assumed value, so there was no threshold to meet. She was thorough and knowledgeable. It was obivous she had appraised many properties, and knew what to look at and how to evlauate things. She also was not fooled by "comparables" in the neighborhood that were not really comparable.
The amount that my house was appraised at was miles away from from the tax assesment value, and the Zillow value, in opposite directions, so she had to support her appraisal.
As far as I know, Zillow has never been to my house. To categorize all appraisers as crooks and liars is a bit much when you laud Zillows "algorithm".
2009-02-12 17:06:46
Crooks and Liars
Shrug. We'll have to agree to disagree. Although zillow isn't reliable (by any means), it also doesn't have a financial stake on what it says my house is worth. If my appraiser came in consistently below what the bank needed him to come in at, I highly doubt that they'd continue to use him. So far I'm 0 for 2 on an appraiser being anything beyond a rubber-stamp for the banking industry. Maybe you got lucky, or your scenario was more complicated, who knows. I just know that for myself and anyone who I work with who also just refinanced, the appraiser didn't do anything but see what number he/she had to get to, put that number down on a report, and add in a bunch of supporting evidence. The walkthrough and pictures were just window dressing.
2009-02-13 00:47:41
Crooks and Liars
Lloyd,

Ultimately, I think you and Travis both have valid points. Not all appraisers are crooks, as your experience seems to point to. But Travis points out a situation that is all too common -- appraisers are beholdent to banks, regardless of what regulations they're trying to implement.

It's also very market dependent -- appraisals do not use current listings to value properties (or at least, do not report them on their appraisals) -- so depending on where your house and local market are in the cycle, listings and sales may paint a different or similar picture.

It's good to know, however, that there are a few honest souls still out there in the appraisal world.

Andrew
2009-02-13 06:43:51
Crooks and Liars
Andrew,
More than trying to support all appraisers, I was trying to point out that I would rather have computers decide our NCAA Football Champions than value my house without ever seeing it.
Thanks for another thought provoking piece, I enjoy your columns.
2009-02-13 11:09:55
Glad to hear it Lloyd!
Subject:
Comment:
Get real-time options trading ideas from Steve Smith, veteran options trader and newsletter author, plus let him show you the way to cut risk and boost your returns through the strategic use of options.  Click here for a free 14 day trial to OptionSmith by Steve Smith.





Minyanville Marketplace