Data for the map was filtered from a 7500+ list of FDIC governed banks. It includes banks with a Texas Ratio greater than 100% as well as all banks with Total Capital less than 6%. The list does not include Savings and Loan Associations, Credit Unions, or Thrifts.
Banks with a combination of high Texas Ratio and very low capitalization are likely at extreme risk of failure. You can find these banks by various sorts.
The map contains a lot of data and it may take extra time to load. Please be patient. It takes an extra 3-5 seconds on my computer. Your results may vary. If you have an inadequate memory, the map may be slow or inoperable.
- Hover your mouse over any point for more details.
- Fields are sortable and filterable.
- Please scroll down below the "Bank Detail" list for usage tips and how to sort bank details by other than Texas Ratio.
Sorting Fields
DoubleClick the detail header to highlight a column in blue. Then click on the sort icon at the bottom.
Viewing Details
To view additional details, hover over a point on the map or one of the fields in the scrollable detail.
Column Descriptions
Texas Ratio: From Wikipedia - The Texas Ratio is a measure of a bank's credit troubles. Developed by Gerard Cassidy and others at RBC Capital Markets, it is calculated by dividing the value of the lender's non-performing assets (Non performing loans + Real Estate Owned) by the sum of its tangible common equity capital and loan loss reserves.
In analyzing Texas banks during the early 1980s recession, Cassidy noted that banks tended to fail when this ratio reached 1:1, or 100%. He noted a similar pattern among New England banks during the recession of the early 1990s.
There are nearly 380 banks with a Texas Ratio greater than 100%, 190 banks with a Texas Ratio above 150%, and 122 banks with a Texas Ratio above 200%.
Capitalization: Capitalization is the ratio of tangible equity to assets expressed as a percentage. Well capitalized banks have a ratio above 6%.
19 banks in the pool have a ratio under 1%, 35 banks have a ratio under 2%, 62 banks have a ratio under 3%, and 105 banks have a ratio under 4%.
30+ Days: This is the ratio of loans 30 days or longer delinquent to total assets. It is a measure of loan quality.
Non-Accrual: This is the ratio of non-accrual loans to total assets. It is a measure of loan quality.
Construction: This is the percentage of construction loans to total loans. Construction loans are particularly at risk. Note: this is a relative number and if a bank has made few loans and is otherwise sitting on cash, a high number may not be indicative of a significant problem.
Miscellaneous Notes
There are over 7,000 banks in the FDIC database. As measured by Texas Ratio, 392 of those banks are not exactly in good shape. I started with a spreadsheet of all the banks as of February 9th. The actual underlying data is from the 4th quarter of 2009. The data comes out quarterly. My source for the original spreadsheet wishes to remain anonymous.
It took about 6 hours just to add a column of addresses to the over 400 banks meeting either selection criteria (Texas Ratio greater than 100% OR banks with a Total Capital less than 6%).
Some of the listed addresses may match branches and not the main bank office.
It took a 24 hour day spread out over weeks to get this map working the way I wanted.
A couple of banks had negative Texas Ratios in the original spreadsheet. They are marked with an "*" in the name. One of them is Charter Bank, a failed bank in New Mexico. I reversed the sign.
I excluded one bank from Hawaii so as to not waste a lot of precious space showing the Pacific Ocean.
The list does not contain data on Savings and Loan Associations, Credit Unions, or Thrifts.
I will soon publish the complete list of the 7000+ banks I do have, so you will be able to see just where your bank stands. The full list will not contain an interactive map.
Credits
I received a lot of help to put this map together from Ellie Fields, Director of Product Marketing at Tableau, and also from Tim Ellis at Seattle Bubble.
Tim spent several hours with me on Wednesday, to put finishing touches on the map.
Disclaimers
I am not responsible for typos, omissions, data errors, etc. I welcome corrections as time permits.
Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com
Click Here To Scroll Thru My Recent Post List
0 comments:
Post a Comment