Question

In: Accounting

Mr. Morris had $100,000 in his account. Using this fund, he made a portfolio of two...

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.

b. Annualized standard deviation of returns of both J&J and IBM
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?

  1. Portfolio return of the portfolio of two stocks.

  2. Portfolio risk (standard deviation) of the portfolio of two stocks.

  3. Critically analyze your investment decision in these two companies . 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?

Solutions

Expert Solution


Related Solutions

Luis has $100,000 in his retirement account at his present company. Because he is assuming a...
Luis has $100,000 in his retirement account at his present company. Because he is assuming a position with another company, Luis is planning to "roll over" his assets to a new account. Luis also plans to put $3000/quarter into the new account until his retirement 20 years from now. If the new account earns interest at the rate of 4.5%/year compounded quarterly, how much will Luis have in his account at the time of his retirement? Hint: Use the compound...
Mr. S. P. Johnson is creating a college fund for his daughter. He plans to make...
Mr. S. P. Johnson is creating a college fund for his daughter. He plans to make 7-yearly payments of $10,000 each with the first payment deposited today on his daughter’s 6th birthday (happy birthday!) Assuming his daughter will need three equal withdrawals from this account to pay for her law-school education beginning when she is twenty-two (i.e. 22, 23, 24), how much will she have on a yearly basis for her law school career? Mr. Johnson expects to earn a...
John has his portfolio invested in a diversified mutual fund portfolio. Recently, his portfolio (which is...
John has his portfolio invested in a diversified mutual fund portfolio. Recently, his portfolio (which is up 9% per year annually for the past 10 years), has dropped almost 15%. What type of risk is John’s portfolio exposed to? Idiosyncratic Risk Behavioral Risk Systematic Risk Industry Risk Lenny, after studying the income statement & cash flow statement of four technology companies, decides that his best option for the long term is T Mobile stock. What type of analysis did Lenny...
Mr. Mark Smith loved gardening. He had several expensive tools that he kept in his yard....
Mr. Mark Smith loved gardening. He had several expensive tools that he kept in his yard. He lived in a good neighborhood and did not worry about his expensive tools stored outside. One weekend, he found a couple of tools missing; puzzled he asked his family if they had moved the tools. Everyone told him that they had not touched the tools. Next weekend, he noticed that another tool was gone. At that point, he was frustrated and wanted to...
Mr Jones is allocated to you. He had a knee replacement two months ago and had...
Mr Jones is allocated to you. He had a knee replacement two months ago and had developed an infection. He is on long term antibiotics for this. He has a PICC line inserted in his left arm. What are the special precautions and care you need to do for him during you morning shift?
Alice and Bob are portfolio managers from two fund houses. They are both using modern portfolio...
Alice and Bob are portfolio managers from two fund houses. They are both using modern portfolio theory, specifically mean-variance optimisation, to construct their portfolios. The following table shows the weightings of their portfolios: Manager     risk-free asset     Stock A     Stock B     Stock C     Stock D     Stock E     Alice 10% 20% 25% 30% 5% 10% Bob 15% 5% 20% 10% 30% 20% Give three possible reasons why Alice and Bob result in different portfolios.
Katie is reviewing his stock portfolio return from the last 5 years. He initially invested 100,000...
Katie is reviewing his stock portfolio return from the last 5 years. He initially invested 100,000 and his annual returns were: Year 1: 20.0% Year 2: 5.0% Year 3: -17.0% Year 4: 15.5% Year 5: 52.1% What is Katies arithmatic average annual return? What is Katies geometric average annual return? What is the standard deviationof Katies returns for this 5 year period?
Mr. Tom Costa, age 71, had a stroke last year that made his right upper and...
Mr. Tom Costa, age 71, had a stroke last year that made his right upper and lower extremities quite weak. He has smoked for 55 years and is obese. He was diagnosed with atrial fibrillation, high blood pressure, and type 2 diabetes mellitus while he was hospitalized with his stroke. His father died of a heart attack at age 50; his paternal grandfather had a stroke and died a year later after a second stroke. His mother and both of...
Mr. Nailor invests $20,000 in a money market account at his local bank. He receives annual...
Mr. Nailor invests $20,000 in a money market account at his local bank. He receives annual interest of 6% for 5 years. How much return will his investment earn during this time period? Use Appendix A to calculate the answer. Multiple Choice $14,940 $6,760 $24,444 $26,760
Ron decided to go with Bloom mutual fund. And he wants to simulate his returns had...
Ron decided to go with Bloom mutual fund. And he wants to simulate his returns had he invested in Bloom fund during the previous year. Ron was provided with the following information from Bloom regarding the previous year: Bloom started last year with a net asset value of $13 per share. And net asset value is $15 by year end. At the beginning of the year, the fund was selling at a premium of 5%, while by the end of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT