Mishkin • Instructor’s Manual for The Economics of Money, Banking, and Financial Markets, Twelfth Edition 134
ANSWERS TO DATA ANALYSIS PROBLEMS
1. Go to the St. Louis Federal Reserve FRED database and find data on the number of
commercial banks in the United States in each of the following categories: average assets
less than $100 million (US100NUM), average assets between $100 million and $300 million
(US13NUM), average assets between $300 million and $1 billion (US31NUM), average
assets between $1 billion and $15 billion (US115NUM), and average assets greater than $15
billion (USG15NUM). Download the data into a spreadsheet. Calculate the percentage of
banks in the smallest (less than $100 million) and largest (greater than $15 billion)
categories, as a percentage of the total number of banks, for the most recent quarter of data
available and for 1990:Q1. What has happened to the proportion of very large banks? What
has happened to the proportion of very small banks? What does this say about the “too-big-
to-fail” problem and moral hazard?
In 1990:Q1, there were 25 ‘very large’ banks, and 9,529 ‘very small’ banks, representing
0.2% and 76.5% of total commercial banks in the United States, respectively. For the most
recent quarter of 2017:Q1, there were 77 ‘very large’ banks, and 1,324 ‘very small’ banks,
2. Go to the St. Louis Federal Reserve FRED database and find data on the residual of assets
less liabilities, or bank capital (RALACBM027SBOG), and total assets of commercial banks
(TLAACBM027SBOG). Download the data from January 1990 through the most recent
month available into a spreadsheet. For each monthly observation, calculate the bank
leverage ratio as the ratio of bank capital to total assets. Create a line graph of the leverage
ratio over time. All else being equal, what can you conclude about leverage and moral
hazard in commercial banks over time?