Case-Shiller from 3 months into the future

Saturday, August 1, 2009

July '09

City average: 39.1% off the peak, 57.9% above Dec 1999
Top tier: 20.1% off the peak, 80.1% above Dec 1999
Middle tier: 39.9% off the peak, 55.3% above Dec 1999
Bottom tier: 50.9% off the peak, 42.5% above Dec 1999





The market is really heating up. The overall city index is up 5% in one month, which is the highest rate of change in the recent history, even exceeding records set during the spring of 2004.

There's one caveat, though - this exponential-looking growth is partly caused by a change in sales structure: the ratio of top tier sales to middle tier sales seems to be up about 20% compared with the previous month. Middle tier by itself is up "only" 3%. It may be an artifact in my data, since some sales may not yet be reported yet, maybe top tier sales are reported faster. I'll update charts and numbers when late-reporters become available.

Also, it's already August and the frenzy may subside in a month or two.

Here's my forecast of the official Case-Shiller index for the next three months:



I've rescaled the "SDHPI" curve to match up exactly with last month's official reading.

Final point is less certain since I need August sales to calculate it precisely - but it should be roughly in that area.

Friday, July 3, 2009

What moves the top tier?

Just an interesting observation:


Thursday, July 2, 2009

June '09

City average: 42.1% off the peak, 50.1% above Dec 1999
Top tier: 21.2% off the peak, 77.3% above Dec 1999
Middle tier: 41.6% off the peak, 50.9% above Dec 1999
Bottom tier: 51.8% off the peak, 40.0% above Dec 1999

City average is up for the third month in a row, so far up 5.7% from March trough.



Monday, June 1, 2009

May '09

May index is up slightly in all tiers and most sub-areas.

City average: 42.7% off the peak, 48.1% above Dec 1999
Top tier: 21.3% off the peak, 77.3% above Dec 1999
Middle tier: 42.7% off the peak, 47.8% above Dec 1999
Bottom tier: 51.4% off the peak, 41.1% above Dec 1999

Short term, upward movement should continue for at least a couple of months, due to tight MLS inventory and active homebuying among families with school-age children - unless mortgage rates spike past 7% or something else equally bad happens. Things will get more interesting in September-October. There's talk of considerable "shadow inventory" due to foreclosure moratoria & such, I'll try to address this issue in a later post.

Regarding the official Case-Shiller index with 3-month averaging, next month's numbers for San Diego should be flat or slightly down, but May C-S will definitely be up (due to be released July 28, if I'm not mistaken) and so far it looks like June C-S (due end of August) will be up as well.



Sunday, May 24, 2009

UC enrollment stats

Last year, just over 2200 high school graduates from San Diego County enrolled into one of the UC universities.

Which high schools were the most likely to send their students to the UC system?

I found the admissions database and used it to compute 3-year average enrollment rates for all major San Diego high schools ("major" defined as having 1000 or more students in 2008).

The overall ranking should not be very surprising to anyone who spent any time studying school characteristics such as API - quite naturally, Torrey Pines High is on top, with 19.4% UC enrollment rate; three out of four Poway USD schools are in the top 10, the exception being Poway High at #12; three SDUSD schools made top 10, namely La Jolla High (#4, 14.5%), Scripps Ranch High (#8, 12.1%), University City High (#9, 9.8%).

There are some deviations from the common API rating. As mentioned, University City High is in the top 10 (an average of 46 students or 9.8%), even though it's only API rank 7. San Marcos High (also API rank 7) had a remarkably bad showing during the last few years, sending an average of 13 students or 2.8% of its graduating class to UC during 2006-08. But overall the pattern is familiar.

What's interesting though is that the distribution is not quite as extreme as one could have expected. On one hand, high-end percentages are surprisingly low. Sure, some students from TPHS go to private schools such as Stanford or Ivy League universities ... but there are probably fewer of those than the number admitted to UC. On the other hand, the distribution has a long thick tail. Combined together, San Dieguito, Carlsbad, and Poway schools provide only a third of all UC freshmen. Why? Because even schools like Morse High (SE San Diego) and Fallbrook High have UC enrollment rates in 4-5% range.

Top 20:

1 Torrey Pines High 19.4%
2 San Dieguito High Academy 18.3%
3 Westview High 15.5%
4 La Jolla Senior High 14.5%
5 Canyon Crest Academy 13.3%
6 Rancho Bernardo High 12.8%
7 La Costa Canyon High 12.5%
8 Scripps Ranch High 12.1%
9 University City High 9.8%
10 Mt. Carmel High 9.6%
11 Coronado High 8.4%
12 Poway High 8.3%
13 Mira Mesa High 7.8%
14 Carlsbad High 7.5%
15 Bonita Vista Senior High 7.1%
16 Henry High 6.8%
17 Eastlake High 5.9%
18 Otay Ranch Senior High 5.7%
19 San Pasqual High 5.6%
20 Point Loma High 5.5%

Saturday, May 2, 2009

April '09

City average: 44.5% off the peak, 43.3% above Dec 1999
Top tier: 24.0% off the peak, 71.1% above Dec 1999
Middle tier: 43.9% off the peak, 44.8% above Dec 1999
Bottom tier: 53.0% off the peak, 36.5% above Dec 1999



Wednesday, April 1, 2009

March '09

(Will be updated in a few days to include late reporters and more graphs)

City average: 45.2% off the peak, 41.5% above Dec 1999 (Case-Shiller index: 141.5); 2.5% down month to month, 22.6% down year over year
Top tier: 24.0% o8ff the peak, 71.1% above Dec 1999
Middle tier: 43.7% off the peak, 44.8% above Dec 1999
Bottom tier: 51.8% off the peak, 39.6% above Dec 1999