Market Data Analysis: Declining Markets

decline.jpg

Telling someone that their house has lost value won’t make many friends, but it will distinguish you as a real estate professional if you can analyze a market and be honest. The national news has talked about housing prices increasing yearly for nearly a decade now, and some areas of greater Pittsburgh has matched those trends at some times, others have remained flat, and others have declined. Today we look at some declining markets, and how to use simple tools to visually determine if there is a decline, and at what rate.

The above is the national median sales price trend since 1990 vs. the builder cost trend. We can see the slow down in real estate around 1990, the decline of 2008 some possible trends emerging now. However, the first thing that we should note is tha…

The above is the national median sales price trend since 1990 vs. the builder cost trend. We can see the slow down in real estate around 1990, the decline of 2008 some possible trends emerging now. However, the first thing that we should note is that VERY FEW areas in the greater Pittsburgh area have seen increases this aggressive. SO, before any seller says, “I bought my house 3 years ago, and houses have gone up nationwide by 3% per year… so my house is worth 9% more?”

The above are homes that are from across Indiana County that are of a higher quality construction. This is not merely a limit of, for example $200,000 and above (limiting a data search by a hard number like that will skew the results of the analysis…

The above are homes that are from across Indiana County that are of a higher quality construction. This is not merely a limit of, for example $200,000 and above (limiting a data search by a hard number like that will skew the results of the analysis). In appraisal language, these properties are all Q2-3 homes (For the definition: http://www.bradfordsoftware.com/uad/UAD_Glossary.pdf)).

Over the last 3 years (after a reassessment in Indiana County that sparked a spike in selling, and reduction in property values) the above data points represent the higher quality sales across the county. Once selected, these sales (with sale date, sale price, and original sales price) were placed in an Excel Spreadsheet. The data points were then graphed and a trend line calculated for each using the tools within Excel. We observe a few things above:

  1. There is a clear convergence of the scatter plot around a downward trend (with the exception of a few recent sales. Those two sales were some of the largest properties in the analysis, and one of them sold 23% below the original list price and stayed on the market for 2 years).

  2. The trend line indicates a median decline of $19.45 per day. When calculated with the median sales price of $325,500 this comes out to an annual decline of 2.18% per year among these homes. This is then a starting point from which we can refine the decline - however, this is a great starting point from which to make sure we’re taking a possible declining market into consideration.

  3. From other analysis of Indiana County as a whole, we’ve seen that some of the hardest-hit areas “may” be finding a bottom. There is the possibility that those recent high sales will result in a similar possible turn OR those recent lower sales would indicate that the decline continues. In six months, we’ll know for sure what is happening right now.

That is perhaps the most frustrating part of market analysis. Its always rear looking. While our “gut” might tell us that the market is “hot,” data is needed to be a professional. Look at the above graph one last time. The original list price trend is falling at 3.98%, 180% faster than sales prices. Why? Because sellers and their agents were way off 3 years ago, and are only recently starting to get to close to realistic sales prices. Our gut is susceptible to “confirmation bias,” in this case, the desire to see a stronger market than what really exists.

Do yourself a favor,

  1. Run the data on your market areas on at least an annual basis to stay on top of what the markets are really doing.

  2. Read our county reports that we distribute throughout the year for wider trends.

  3. Stay abreast of the national market data, but don’t put too much weight on it.