Answered step by step
Verified Expert Solution
Link Copied!

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%

  1. What is the arithmetic mean of MSFT?
  2. What is the Geometric mean of MSFT?
  3. What is the Standard deviation of MSFT?
  4. What is the portfolio mean if the weight in KO is 30% and MSFT is 70%?
  5. What is the standard deviation of the portfolio?
  6. What is the covariance of the two stock? (can be in either unit; Round to the 4th decimal places)
  7. What is the correlation of the two stocks (if SKO = 5.84%)? (can be in either unit; Round to the 4th decimal places)
  8. What is the Sharpe ratio of the portfolio if the risk-free rate is 2%?
  9. 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

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

Financial Statement Analysis

Authors: Andrew P.C.

1st Edition

1520985002, 978-1520985008

More Books

Students also viewed these Finance questions