FIN$3320$ Assignment $3-$ Risk and Returns

Please complete the highlighted yellow cells in both tabs $-$ Risk and Return, and Stock Portfolio Analysis

Holding period returns

Capital appreciation, current return and total return

$\backslash$table$[[$Period$,,$Price,,Dividend,Capital appreciation,Current return,Total HPR$],[0,$S$,20\mathrm{.}00,,,,,],[1,$S$,21\mathrm{.}25,$S$,1\mathrm{.}20,,,],[2,$S$,20\mathrm{.}75,5,1\mathrm{.}20,,,],[3,$S$,22\mathrm{.}10,$S$,1\mathrm{.}22,,,]]$

$HPR=\frac{P_1-P_{0}CF}{P_0}=\frac{P_1-P_0}{P_0}\frac{CF}{P_0}$

Risk and Return for a stand$-$alone investment

$\backslash$table$[[$Condition$,$Probability,Outcome ABC,$[$ Outcome $],[xYZ],\backslash$table$[[\frac{?}{\text{b}\text{a}\text{r}}(ABC)$

I need answers to the preactice question in the highlighted areas. Elaborate calculations for answers. Thanks!