Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet. Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect? Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Question

Want to see the full answer?

Answer 1

Question

Chapter 8, Problem 1DAP

To determine

Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet.

Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect?

Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 2

Question

Chapter 8, Problem 1DAP

To determine

Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet.

Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect?

Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 8, Problem 1DAP

To determine

Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet.

Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect?

Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 8, Problem 1DAP

To determine

Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet.

Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect?

Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 8, Problem 1DAP

To determine

Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet.

Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect?

Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Answer 6

Chapter 8, Problem 1DAP

To determine

Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet.

Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect?

Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Answer 7

Chapter 8, Problem 1DAP

To determine

Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of loans secured by collateral for all commercial and industrial loans (ESANQ) and the net percentage of domestic banks tightening standards for commercial and industrial loans to large and middle- market firms (DRTSCILM). Download the data into spreadsheet.

Calculate the average, over the most recent four quarters and the four quarters prior to that, for the bank standards indicator and the “percent of loans secured by collateral” indicator. Do these averages behave as you would expect?

Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two data series from 1997:Q3 to the most recent quarter of data available. What can you conclude about the relationship between collateral and bank C&I lending standards? Is this result consistent with efforts to reduce asymmetric information?

Answer 8

Expert Solution & Answer

Answer 9

Expert Solution & Answer

Answer 10

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 11

Ch. 8 - Prob. 1LO Ch. 8 - Prob. 2LO Ch. 8 - Prob. 3LO Ch. 8 - Prob. 4LO Ch. 8 - Prob. 5LO Ch. 8 - Prob. 6LO Ch. 8 - Prob. 1Q Ch. 8 - Prob. 2Q Ch. 8 - Prob. 3Q Ch. 8 - Prob. 4Q

Want to see the full answer?

Chapter 8 Solutions