Analytics mindset (Bank investment portfolios) Part 3 Interpret and share the results with stakeholders Assume that you are a data analyst for the Federal Reserve The Federal Reserve Board would like your help in answering the questions below Assume that the Board has access to the Tableau visualizations you created in Part 2 When answering the questions below you should reference the appropriate Tableau dashboard to make your point Your answers should be concise and you may use bullet points to organize your answer Again, answers from three to six sentences should be enough to make your points What are the trends in the average amount of HTM and AFS investments held during the sample period What are the trends in the composition of banks investment portfolios during the sample period In particular, how did the average HTM percentage change during the sample period What are the trends at the individual bank level in the change in the HTM percentage of investments held for large banks from 2013 to 2018 (the period after which the change in regulation took place) For the three banks that had the biggest increase in the HTM percentage from 2013 to 2018, name these banks and describe how increases or decreases in HTM and AFS investments held contributed to the shift Which large banks (if any) shifted their investment portfolios away from HTM investments during that time period What are the trends in the level of volatility for all banks of the T1R and TCR capital ratios from 2009 to 2018 What are the trends in the level of volatility for large and small banks for the same capital ratios for the same time period

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 03, 2024

Analytics mindset (Bank investment portfolios) Part 3: Interpret and share the results with stakeholders Assume that you are a data analyst for the Federal Reserve.

Analytics mindset (Bank investment portfolios)

Part 3: Interpret and share the results with stakeholders

Assume that you are a data analyst for the Federal Reserve. The Federal Reserve Board would like your help in answering the questions below. Assume that the Board has access to the Tableau visualizations you created in Part 2. When answering the questions below you should reference the appropriate Tableau dashboard to make your point. Your answers should be concise and you may use bullet points to organize your answer. Again, answers from three to six sentences should be enough to make your points.

What are the trends in the average amount of HTM and AFS investments held during the sample period?
What are the trends in the composition of banks investment portfolios during the sample period? In particular, how did the average HTM percentage change during the sample period?
What are the trends at the individual bank level in the change in the HTM percentage of investments held for large banks from 2013 to 2018 (the period after which the change in regulation took place)?
For the three banks that had the biggest increase in the HTM percentage from 2013 to 2018, name these banks and describe how increases or decreases in HTM and AFS investments held contributed to the shift. Which large banks (if any) shifted their investment portfolios away from HTM investments during that time period?
What are the trends in the level of volatility for all banks of the T1R and TCR capital ratios from 2009 to 2018? What are the trends in the level of volatility for large and small banks for the same capital ratios for the same time period?