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\mathrm{.}23\%)$ unless

otherwise indicated.

$KOMSFTMKT$

$2016\frac{1\mathrm{.}75}{\%}\frac{19\mathrm{.}44}{\%}-0\mathrm{.}73\%$

$2017-\frac{3\mathrm{.}49}{\%}\frac{12}{\%}\frac{9\mathrm{.}54}{\%}$

$2018\frac{10\mathrm{.}66}{\%}\frac{37\mathrm{.}66}{\%}\frac{19\mathrm{.}42}{\%}$

$2019\frac{3\mathrm{.}20}{\%}\frac{18\mathrm{.}74}{\%}-\frac{6\mathrm{.}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 $4$th decimal

places$)$

What is the correlation of the two stocks $($if $S_{KO}=5\mathrm{.}84\%)?($can be in either unit; Round to

the $4$ th 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\mathrm{.}5?$

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\mathrm{.}23\%)$ unless

otherwise indicated.

$KOMSFTMKT$

$2016\frac{1\mathrm{.}75}{\%}\frac{19\mathrm{.}44}{\%}-0\mathrm{.}73\%$

$2017-\frac{3\mathrm{.}49}{\%}\frac{12}{\%}\frac{9\mathrm{.}54}{\%}$

$2018\frac{10\mathrm{.}66}{\%}\frac{37\mathrm{.}66}{\%}\frac{19\mathrm{.}42}{\%}$

$2019\frac{3\mathrm{.}20}{\%}\frac{18\mathrm{.}74}{\%}-\frac{6\mathrm{.}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 $4$th decimal

places$)$

What is the correlation of the two stocks $($if $S_{KO}=5\mathrm{.}84\%)?($can be in either unit; Round to

the $4$th 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\mathrm{.}5?$

Please write the calculation for $5$ And $6$

Thanks