Create pie charts illustrating profile of securities held

Assignment Help Portfolio Management
Reference no: EM131480957

Assignment: Investment Portfolio Analysis

For this assignment, write a 5 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 thechart 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.

Analyzes how the relative size of a bank's securities-to-total assets has changed over time; provides relevant explanations for the changes.

Compares a bank's securities portfolio with its peers and analyzes factors affecting securities choices; provides support through relevant real-life examples or resources.

Describes strategies for managing bank fund sources, provides recommendations for implementation; provides support through relevant real-life examples or resources.

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.

Reference no: EM131480957

Questions Cloud

Product design and development : There are thousands of architectural decisions to be made in the development of an automobile.
Industry that required the need for multiple models : Outline a situation in your organization or industry that required the need for multiple models.
Discuss recruiting selecting and retaining talent : Here is your discussion Topic: "Recruiting, Selecting and Retaining Talent". Hiring employees is, perhaps, the most important (and difficult) responsibility.
Examine the risks associated with your recommendation : Examine the risks associated with your recommendation and the ways Jonathan can mitigate these. Evaluate the different retirement plans available to Jonathan.
Create pie charts illustrating profile of securities held : Using thechart function in Microsoft Excel and data by columns, create four pie charts illustrating profile of securities held by your BHC and its peer group.
Using the indirect approach to create a negative? message : When using the indirect approach to create a negative? message, you should do all the following EXCEPT which? one?
What is the utilization of washers on average : The manager, Mr. Money, decided not to buy a machine. He still has 10 washers and 15 dryers. What is the utilization of washers, on average?
Company encounter while conducting market research : What problems might a company encounter while conducting market research in Vietnam?
Do a micro and macro analysis of the marketing report : Do a MICRO AND MACRO ANALYSIS OF THE MARKETING REPORT AND THE SWOT ANALYSIS - justifying the need of the product in line with the profile of the group and the micro- & macro-environment that the brand is operating within.

Reviews

Write a Review

Portfolio Management Questions & Answers

  Portfolio analysis

The stock with the lowest beta (0.76) is Apple Inc. stock. The stock with the highest beta (3.29) is Facebook Inc. stock. Beta for Apple Inc. stock is less that 1, it tells us that stock price is less volatile and risky than mark..

  Provide investment portfolio advice

Provide investment portfolio advice and management to a client.

  Evaluate total number of shares

EBV proposes to structure the investment as 5m shares of CP with FV of $5m, one-to one conversion to common, and no dividends. Total Valuation Estimated from Newco.

  Role of the imf and world bank

Economic and territorial logic of empire are not always aligned. Explain his argument in light of the role of the IMF and World Bank as forms of neo imperialism.

  Prepare a portfolio of stocks

Prepare a portfolio of stocks

  Which critically examines the benefits and risks to company

Which critically examines the benefits and risks to a company, of incorporating corporate debt into a portfolio of equity and debt.

  Compute the variance-covariance matrix

Compute the sample mean, variance, and standard deviation of these shares and compute the variance-covariance matrix V and Plot the daily share prices and daily returns for each individual asset.

  Net nominal rate of interest and net real rate of interest

What bank portfolio can guarantee the rate of return 1 to all type 1 people and the rate of return 1.2 to all type 2 people? How many goods are placed in storage? In capital?

  Right issue to improve financial status

If you are the CEO of a British company that now faces the loss of a lucrative contract in Malaysia because of the dispute. What action should you take and How do you think British government should respond to the Malaysian action?

  Calculate the cost of reinvested profits

Calculate the cost of reinvested profits and the cost of new common shares using the constant-growth DVM - Cost of reinvested profits versus new common shares-DVM

  Calculate the after-tax cost of debt

Cost of debt For each of the following bonds, calculate the after-tax cost of debt. Assume the coupons are paid semi-annually, that the tax rate is 40 percent, and that we are dealing with $1,000 of par value.

  Calculate the overall cost of capital for cartwell products

Calculate the overall cost of capital for Cartwell Products. Which projects should the firm select? Does your answer differ from your answer topart d? If so, explain why.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd