Question
Mr. Morris had $100,000 in his account. Using this fund, he made a portfolio of two NYSE listed stocks Johnson and Johnson (J&J) and IBM
Mr. Morris had $100,000 in his account. Using this fund, he made a portfolio of two NYSE listed stocks Johnson and Johnson (J&J) and IBM on 01 Jan 2019 in the ratio of 60:40, i.e. 60% funds in J&J & 40% funds in IBM.
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 1st Jan 2020.
Using the stock data of the two stocks, you are required to explain the below concepts and then compute for the given stocks:
a. Annual return of both J&J and IBM. (10 marks)
b. Annualized standard deviation of returns of both J&J and IBM (10 marks)
c. Correlation coefficient of returns of J&J and IBM. What does this correlation coefficient signify about the correlation of the two stocks and
corresponding decision from an investor? (10 marks)
d. Portfolio return of the portfolio of two stocks. (10 marks)
e. Portfolio risk (standard deviation) of the portfolio of two stocks. (10 marks)
f. Critically analyze your investment decision in these two companies (10 Marks). 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)
Please someone help me with this question.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started