Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are analyzing two different stocks: Coca-Cola (KO) and Microsoft (MSFT). Use the following information to answer questions, make sure to type the final answers
You are analyzing two different stocks: Coca-Cola (KO) and Microsoft (MSFT).
Use the following information to answer questions, make sure to type the final answers clearly in percent form. Round to the nearest 2 decimals (For example: 1.23%) unless otherwise indicated.
KO | MSFT | MKT | |
2016 | 1.75% | 19.44% | -0.73% |
2017 | -3.49% | 12% | 9.54% |
2018 | 10.66% | 37.66% | 19.42% |
2019 | 3.20% | 18.74% | -6.24% |
- What is the arithmetic mean of MSFT?
- What is the Geometric mean of MSFT?
- What is the Standard deviation of MSFT?
- What is the portfolio mean if the weight in KO is 30% and MSFT is 70%?
- What is the standard deviation of the portfolio?
- What is the covariance of the two stock? (can be in either unit; Round to the 4th decimal places)
- What is the correlation of the two stocks (if SKO = 5.84%)? (can be in either unit; Round to the 4th decimal places)
- What is the Sharpe ratio of the portfolio if the risk-free rate is 2%?
- What is the expected return of the portfolio (using CAPM) if the Beta of the portfolio is 0.5?
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