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.

KO

MSFT

MKT

$2016$

$1\mathrm{.}75\%$

$19\mathrm{.}44\%$

$-0\mathrm{.}73\%$

$2017$

$-3\mathrm{.}49\%$

$12\%$

$9\mathrm{.}54\%$

$2018$

$10\mathrm{.}66\%$

$37\mathrm{.}66\%$

$19\mathrm{.}42\%$

$2019$

$3\mathrm{.}20\%$

$18\mathrm{.}74\%$

$-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 SKO $=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?$