Question: 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

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 (For example: 1.23%) unless otherwise indicated 2015 2016 2017 2018 KOMSFT MKT 1.75% 19.44% -0.73% -3.49% 12% 9.54% 10.66% 37.66% 19.42% 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 MSF is 70%? 5. What is the standard deviation of the portfolio? 6. What is the covariance of the two stock? (Round to the4th decimal Places) 7. What is the correlation of the two stocks (if Sko = 5.84%)? (Round to the 4th decimal Places) 8. What is the Sharpe ratio of the portfolio if the risk-free rate is 2%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The DirectCast cable TV company is a national chain that services the small college town that is home to Tech, with a student population of almost 30,000. The company has generally been able to...

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...

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....

step by step please 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...

please help from 5-9 only please You are alyzing two different stocks Coca-Cola (KO) and Microsoft (MSFT). Use the following information to 12355) less otherwise indicated wwer questions, make sure...

only need help with questions 5-9! thank you Yes Excel will do, just need the answers please You are analyzing two different stocks: Coca-Cola (KO) and Apple (AAPL). Use the following Information to...

1. (3 marks) What are the main differences between the born global and the Uppsala's internationalisation approaches? Briefly explain in no more than 250 words. 2. (5 marks) Now focus on the case...

Compare the three statistical models. Describe the connections among the t-test, ANOVA, and regression. Why are the p-values the same for all three models?

OBrian Service Company purchased a copier on January 1, 2012, for $17,000 and paid an additional $200 for delivery charges. The copier was estimated to have a life of four years or 800,000 copies....

What is the value of a call option at expiration?

Vehicle identification number, color, weight, and horsepower best exemplify: Select one: a . entity types. b . identifiers. c . entities. d . data markers. e . attributes.