Case-Shiller from 3 months into the future

Friday, January 2, 2009

December '08 HPI

City average: 42.4% off the peak, 46.9% above December 1999 level
Top tier: 19.7% off the peak, 77.5% above December 1999 level
Middle tier: 41.5% off the peak, 49.1% above December 1999 level
Bottom tier: 48.2% off the peak, 49.4% above December 1999 level

Two lower tiers are cheapest they were since the summer of 2002. If you take inflation and low interest rates into account, houses in San Diego have not been so affordable since 1999.

Monday, December 15, 2008

November '08 HPI

City average: 41.1% off the peak
Top tier: 20.3% off the peak
Middle tier: 39.1% off the peak
Bottom tier: 47.9% off the peak

4% drop in one month in the top tier. Sales volume took a hard hit, too. The number of repeat sales in the top tier is down 50% month-to-month. This is probably the consequence of the stock market crash - that's where people with significant stock portfolios shop for their houses. Sales volumes in the other two tiers dropped by much smaller amounts - 10% and 14%.

Bottom tier as a whole is back to May '02, middle tier is back to September '02. 54-94 area solidified its position as the place with most severe price declines: a typical house in 54-94 is worth 48.4% of what it would've gone for at the peak in April-May '06.





Sunday, December 7, 2008

Neg-ams in San Diego

Downward pressure on house prices in San Diego has been in part caused by foreclosures. In the last few months, the supply of new foreclosures on the market has been reduced to a trickle. Mortgage modifications are getting increasingly popular. In a mortgage modification, lender agrees to lower the principal or the interest rate for a delinquent borrower and/or to transfer the modified loan to FHA. Jim the Realtor has a number of comments on this subject.

There's a catch. The lender will not reduce the principal much lower than the market value, and the borrower must qualify for a modified mortgage, fully documenting his income, with strict income limits.

And that's what brings us to neg-ams. A negative amortization loan is the one where monthly payment is insufficient to cover all interest accrued, making the principal grow rather than shrink over time. Neg-am borrowers' houses are way bigger and more expensive than they can realistically afford. Even after 30+% principal reductions, they are very unlikely to be able to pay modified mortgages. In addition, many neg-am borrowers were "investors" (owners of multiple non-owner-occupied properties), these obviously aren't getting any modifications. Areas with high densities of neg-ams will continue to produce foreclosures well into 2009 and possibly 2010. So, it's good to know where they are. Unfortunately, this kind of information is not readily available. We have to improvise.

I went through a database of all foreclosures that took place in San Diego County between July and November. There were approximately 10,000 of them. For every foreclosure, public sources give us 1) the initial loan amount, 2) the delinquency amount ( sum of all missed payments when the loan was declared in default ), 3) "sale amount" - the amount which the bank hopes to recover through foreclosure. #3 includes the balance on the loan on the day the borrower stopped paying, missed payments, late fees, and legal fees incurred by the bank. By subtracting #2 from #3, we can estimate the balance.

Inspection of the data quickly reveals a pattern. Half of all foreclosures have #3-#2 in the range between 101% and 104% of the initial balance. These are well known subprime interest-only loans. The bank needs to get back full amount loaned, and probably 1-4% of loan balance in legal fees.

Another big group of foreclosures has #3-#2 between 107% and 115% of the initial balance. These loans have lower interest rates. In this group, there's a noticeable correlation between the "sale amount" and the age of the loan. Loans in this category tend to grow 4-5% a year - the characteristic feature of a neg-am.

Overall, approximately a quarter of all foreclosures since July appear to have been caused by a neg-am. Neg-ams are everywhere. They are somewhat overrepresented in South Bay (44% of foreclosures in 91914, 37% in 91913, 32% in 92154). 92154 (San Ysidro) had the largest absolute number of suspected neg-ams in the dataset. 92037 (La Jolla) and 92109 (Pacific Beach) had relatively few foreclosures, but many of these were neg-ams. Weak prices in these areas should be expected to continue for some time, despite modification efforts.

Here's a random example of negative amortization. On 5/17/2006, Michael Ghanayem bought a 1,827 sf unit D102 in Seahaus condo complex in La Jolla, two blocks from the beach, for $1,090,000 with 10% down. Two months later, he refinanced into a $990,000 loan from "No Red Tape Mortgage" (later adding a $250k second from WaMu). On 11/17/2008, the condo was repossessed by the bank. Sale amount was $1,143,400. In two years, loan balance has grown at least 10%.

Here's another one. On 12/10/2003, Therese Ghanayem bought a house in a gated community in Santaluz (7378 Los Brazos) for $823,500. On 7/12/2005, the house was refinanced into two loans with Countrywide, $995k and $350k. First loan ended up in foreclosure on 8/15/2008. Sale amount was $1,133,294.

Both Seahaus D102 and 7378 Los Brazos are currently bank-owned and off the market. It's not clear what happened to Michael & Therese Ghanayem. With more than half a million tax-free dollars pulled out just from these two properties using cash-out refis, they can probably afford to retire in the Caribbean. (Incidentally, Michael is a 1998 Mt. Carmel High alumnus. That makes him 28 or so today.) But I digress.

Rural areas appear to have escaped this problem to some degree. Ramona (92065), north Escondido (92026), El Cajon (92020, 92021) have considerable numbers of foreclosures caused by "old-fashioned" subprime loans, but neg-am percentages in all these are below 20%.

Saturday, November 22, 2008

Election map

Perhaps you'll find this interesting:





Election results are from San Diego Registrar of Voters; precinct boundaries are from SanGIS, parsed with Shapefile library. I used the map of Congressional Districts as the background - that was the highest-resolution map of San Diego I could find. (I tried to stitch together a map from Google Maps screenshots, but that didn't work so well - I couldn't get the election overlay to match geographic features perfectly.)

All precincts with 20 or more recorded votes are shown.

It's striking how little opposition there is for Prop 8 outside North County coast and central neighborhoods (Hillcrest, South Park & such). Most neighborhoods south of 94 vote for Obama and Yes on 8. Same with Indian reservations (Pala, Barona, Santa Ysabel) and democratic pockets in Escondido and El Cajon.

Sunday, November 9, 2008

Mandatory election post

Every blogger seems to have something to say about our recent election. Here's my try.

This is how different parts of San Diego County voted on November 4th.


NeighborhoodVotes for McCainVotes for Obama% for Obama% Yes on Prop 8
Alpine4202193931.6%69.4%
Ballena31013330.0%69.4%
Bonita2748242746.9%62.6%
Bonsall69035834.2%65.9%
Borrego Springs47751852.1%56.3%
Bostonia3786275542.1%66.3%
Boulevard34116432.5%72.8%
Buena1845139043.0%62.0%
Campo41415927.7%77.4%
Carlsbad216372184350.2%51.2%
Centre City1893416568.8%36.5%
Chollas Park716457186.5%65.0%
Chula Vista246753631859.5%62.5%
City Heights1059328475.6%49.9%
Clairemont E6240773155.3%51.8%
Clairemont N4458599357.3%47.7%
Clairemont S3605536359.8%43.3%
Coronado4224309542.3%54.8%
Crest84043734.2%69.2%
Dehesa19513240.4%63.5%
Del Dios2372215147.6%58.1%
Del Mar812143963.9%32.6%
Del Mar Heights5604836259.9%40.3%
Descanso113447429.5%70.1%
El Cajon130041132446.5%63.9%
Elfin Forest12410445.6%55.3%
Encanto E2857579067.0%68.7%
Encanto W1660635679.3%66.5%
Encinitas99811653862.4%38.3%
Escondido186351571145.7%64.1%
Fairbanks Ranch50325033.2%58.7%
Fallbrook8732481635.5%68.1%
Felicita Park89249935.9%62.0%
Foothill28721943.3%60.6%
Golden Hill413209883.6%30.7%
Harbison Canyon30114732.8%63.2%
Harbor74564346.3%50.1%
Helix3030275247.6%55.8%
Hidden Meadows2131107633.6%69.1%
Hillcrest1481779184.0%16.4%
Imperial Beach2553351157.9%55.9%
Jacumba587355.7%65.6%
Jamacha66137336.1%67.0%
Jamul1963113936.7%66.7%
Julian78950439.0%60.1%
La Jolla6467888657.9%40.0%
La Mesa91331173056.2%50.7%
La Playa1929200451.0%47.9%
Lake Morena33115331.6%71.4%
Lake San Marcos151592738.0%65.9%
Lakeside7590386833.8%69.0%
Lakeview Flinn3491163431.9%70.4%
Lemon Grove2919411458.5%61.4%
Lincoln Acres17231965.0%65.7%
Linda Vista2787448861.7%48.9%
Loma Portal2668340856.1%44.9%
Lomas Santa Fe23131457.6%36.8%
Middletown1863503073.0%28.1%
Midway Old Town1498273464.6%40.0%
Mira Mesa94641122054.2%57.2%
Mission Bay659108762.3%33.8%
Mission Hills1286322071.5%27.7%
Mission Valley1459296667.0%35.1%
Montezuma2004452669.3%33.8%
Montgomery29644960.3%44.6%
National City3273606564.9%65.9%
Navajo6324723853.4%50.5%
Nestor3488646064.9%65.0%
Normal Heights32271006375.7%34.4%
North Park23221183483.6%23.5%
Oak Grove26818841.2%68.1%
Ocean Beach2217632874.1%26.9%
Oceanside253852633450.9%59.5%
Otay2170365562.7%66.4%
Pacific Beach53901102167.2%31.6%
Pala5711566.9%59.7%
Paradise Hills3374480858.8%68.4%
Pauma Valley17420554.1%62.9%
Pomerado8297883051.6%52.1%
Potrero16114046.5%75.1%
Poway11416792041.0%60.0%
Rainbow28720041.1%65.7%
Ramona8215388632.1%68.0%
Ranchita15610941.1%64.4%
Rancho Bernardo9423862547.8%57.4%
Rancho El Cajon145363730.5%72.3%
Rancho Santa Fe165283733.6%57.7%
Rho Monserate43224736.4%72.1%
Rho Penasquitos149721647552.4%52.7%
Rincon D Diablo2045118836.7%64.4%
Rock Springs43126738.3%65.3%
Rolando Redwood3380757569.1%51.4%
San Carlos5361586352.2%51.7%
San Marcos114461118149.4%59.8%
San Ysidro1709421771.2%65.4%
Santee12007786939.6%62.7%
Se San Diego E339211686.2%65.4%
Se San Diego W289183886.4%61.0%
Serra Mesa3130384555.1%52.0%
Solana Beach2571344557.3%41.1%
South Park1400562880.1%25.2%
Spring Valley7093875655.2%64.1%
Sweetwater40541550.6%66.6%
Tierrasanta4455543755.0%48.2%
University N38121190475.7%29.7%
University S2791406359.3%43.8%
Valle De Oro6877450639.6%63.6%
Valley Center3869180631.8%70.2%
Vista112081093449.4%60.8%
Vista Acres72455643.4%61.6%
Whispering Palms80448437.6%56.1%
Yaqui Wells616451.2%57.3%




All numbers come from here.


Rural areas are pro-McCain, central San Diego neighborhoods (e.g. Golden Hill, South Park) are heavily pro-Obama. Hillcrest and North Park favor Obama 5 to 1. In Fairbanks Ranch and Rancho Santa Fe, 67% of votes went for McCain, but neighboring Del Mar Heights and Solana Beach vote 57-59% for Obama. (Carmel Valley is probably part of Del Mar Heights in their definition)

Hillcrest is the most liberal, deep East County (Campo, Descanso, Boulevard) is the most conservative. Chollas Park, Encanto, San Ysidro, National City vote for Obama and Yes on 8 at the same time.

Next, I'll try to build a map. I'll either have to find 2008 precinct definitions or adapt 2006 definitions somehow.

Friday, November 7, 2008

San Diego HPI - October '08

City average: 37.9% off the peak
Top tier: 15.5% off the peak
Middle tier: 37.4% off the peak
Bottom tier: 45.9% off the peak



These numbers represent transactions that went into escrow in late August or early September. Stock market began tanking in the last week of September. I expect to see some impact of the stock market crash in November and December data.

Wednesday, October 1, 2008

San Diego HPI - September '08

City average: 37.5% off the peak
Top tier: 15.3% off the peak
Middle tier: 37.6% off the peak
Bottom tier: 44.9% off the peak



Note: the chart is rebased to use December '99 = 100%, this way my numbers can be directly compared with Case-Shiller.


Month S&P Case-Shiller SDHPI
January '08197.45198.06
February '08190.34190.64
March '08185.42184.87
April '08180.56179.99
May '08178.03176.52
June '08175.37174.37
July '08172.20171.42
August '08 168.25
September '08 164.32
October '08 159.23