How has the relative size of your bank’s securities-to-total assets changed across the periods?, assignment help

For this assignment, write a 5–6 page report examining the types of securities in your bank’s investment portfolio. You will also make some inferences about the factors that played a role in the selection of securities for that portfolio. The possible factors are discussed in your text and this assignment also examines the maturity structure of your bank’s securities portfolio.

Investment Data

Access the data for your chosen bank through the FDIC’s Statistics on Depository Institutions. Use the Statistics on Depository Institutions (SDI) to create a four-column report of your bank’s information and its peer group information. This report should span across the years. Note: For Report Selection use the pull-down menu to select Securities and view this in Percentages of Total Assets.

Analysis

For your analysis consider the following questions:

• How has the relative size of your bank’s securities-to-total assets changed across the periods?
• Does your bank have more or less liquidity than the group of comparable institutions?

Using the chart function in Microsoft Excel and the data by columns, create four pie charts illustrating the profile of securities held by your BHC and its peer group. Provide titles, labels, and percentages.

Using the above information, create a report of your bank’s securities portfolio and how it compares to its peers. Provide inferences concerning the factors, such as expected return, interest rate risk, and others, affecting the choice of securities.

Inferences for the Industry

Based on the analysis of the investment portfolio for this company, and bank management theory, as covered in course readings and research, what strategies and recommendations can you offer for managing the sources of bank funds? Provide support for your position from relevant sources.

The company that i have chosen for this is JP Morgan Chase 

I have attached the previous paper to help with this paper if needed. 

Please let me know if you need anything 

https://www5.fdic.gov/sdi/main.asp?formname=compare

Here is the link to the FDIC.