Sunday, February 17, 2013

FDIC Failed Bank List Continued...

How much money has the FDIC lost through time? The failed bank list (here) has an estimated loss for when a bank failed or assistance was required. However, of the 4353 observations in the data (My Data in CSV) about 1612 have NA's for Estimated Loss. Fortunately these observations have Total Deposits and Total Assets. Below is a scatterplot of log(Estimated loss) on log(Total Deposits) for the complete observations. (Total Deposits has a slightly stronger relationship with Estimated Loss then Total Assets so I will use it for the analysis.)



There is a strong relationship between Estimated Loss and Total Deposits. However, there are several large deposit values that correspond to a zero loss for the FDIC. Since these observations are randomly located throughout the US and are in different time periods I'm assuming that there is nothing special about these points. (Hopefully they were entered in correctly and the zero values shouldn't NA's). Therefore, using this data the fitted values of the regression is:

Log(Estimated Loss) = -0.06  + 0.852* log(Total. Deposits) + Error
                                       (.18)      (.016)
RSE = 1.26
R^2=.54 


From this regression I impute the values that are NA for Estimated Loss (there were 35 values that had no Deposit information so they are excluded). Below is the graphs through time of FDIC losses, log losses, and number of troubled banks.


One sees most losses are in late 1980's and lat 2000's. Surprisingly, There were no losses in 2005 and 2006. Since this period is right before the 'great recession' it perhaps shows a "This time is different mentality".

Next post I'll compare the $ value FDIC Loss with the $ value of checkable and time deposits. This should compare the actual losses of the FDIC with the potential liabilities of the FDIC.


FDIC Failed Banks

Link to Video

I used data from FDIC (from FDIC site) Failures and Assistance Transactions from 1934 through 2012.   I then found the coordinates and graphed them in R. The result is a by quarter movie of where and when a bank failed or assistance was needed from FDIC.

No real findings here. I couldn't really see anything extraordinary from locations. However, I do like when the 1980's come along and all the FSLIC  banks (which is included in data) go under and the entire country blows up. Similar results happen late 2000's.

FDIC Failed Banks

https://docs.google.com/file/d/0B9nc4zDDl2T-WEkzSGJsOG5MTjg/edit?usp=sharing