Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mr. Morris had $100,000 in his account. Using this fund, he made a portfolio of two NYSE listed stocks-General Electric and Pfizer on 01 Jan

Mr. Morris had $100,000 in his account. Using this fund, he made a portfolio of two NYSE listed stocks-General Electric and Pfizer on 01 Jan 2019 in the ratio of 60:40, i.e. 60% funds in General Electric & 40% funds in Pfizer.

The daily stock data of both stocks can be found on market websites such as finance.yahoo.com. Download daily data for 1 year from 1 Jan 2019-1stJan 2020.

Using the stock data of the two stocks, you are required toexplain the below concepts and then compute for the given stocks:

  1. Annual return of both General Electric and Pfizer (5 marks)
  2. Annualized standard deviation of returns of both General Electric and Pfizer (5
  3. marks)

4. Correlation coefficient of returns of General Electric and Pfizer. What does this correlation coefficient signify about the correlation of the two stocks and corresponding decision from an investor? (5 marks)

5.Portfolio return of the portfolio of two stocks. (5 marks)

6.Portfolio risk (standard deviation) of the portfolio of two stocks. (5 marks)

7.Critically analyze your investment decision in these two companies(5 Marks).

8.Given an option, would you like to invest in any other company? Or would you like to have a different ratio of investment in the two? (10 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Succeeding in Business with Microsoft Excel 2013 A Problem Solving Approach

Authors: Debra Gross, Frank Akaiwa, Karleen Nordquist

1st edition

978-1285099149, 9781285963969, 1285099141, 1285963962, 978-1285715346

More Books

Students also viewed these Finance questions

Question

How could an organization's culture be used as a control mechanism?

Answered: 1 week ago

Question

23. What is vendor-managed inventory?

Answered: 1 week ago

Question

19. What information is typically stored in a bar code or RFID tag?

Answered: 1 week ago

Question

18. When are some good times to count inventory?

Answered: 1 week ago