Wednesday, October 15, 2008

Ranking Commercial Banks, Homebuilders, Insurers

I created this in mid-June, but it still might be of some use going forward. It's a relative ranking along with a bankruptcy rating:

http://efranco.googlepages.com/mortgagecomp6.xlsx

I'm a big fan of visual displays and built the spreadsheet accordingly:

Maroon = very likely to go into bankruptcy, conservatorship, or forced marriage
Red = significant likelihood of bankruptcy, conservatorship, or forced marriage
Orange = weak capital position
Yellow = decent capital position
Bright green = strong capital position

No comments: