Continuing with the previous data, see attached, regarding Market Index $($S&P$500),$ and $1-$YR US T$-$bill rates $($Risk$-$free rate proxy$),$ we have the following tabular data, see attached,

Calculate the following $($refer $8-4)$:

Market Risk Premium $($RPm$)$

Risk Premium for MSFT

Risk Premium for TSLA

What are the average values for each of the above?

$\backslash$table$[[,$Returns in $\%,$Returns in $\%,$Returns in $\%,$Returns in $\%],[$Year$,$MSFT$,$TSLA,S&P$500,1-$ YR T$-$Bill$],[2012,5\mathrm{.}84,18\mathrm{.}59,13\mathrm{.}41,0\mathrm{.}16],[2013,44\mathrm{.}28,344\mathrm{.}14,29\mathrm{.}60,0\mathrm{.}13],[2014,27\mathrm{.}54,47\mathrm{.}85,11\mathrm{.}39,0\mathrm{.}25],[2015,22\mathrm{.}70,7\mathrm{.}91,-0\mathrm{.}73,0\mathrm{.}65],[2016,15\mathrm{.}07,-10\mathrm{.}97,9\mathrm{.}54,0\mathrm{.}81],[2017,40\mathrm{.}72,45\mathrm{.}70,19\mathrm{.}42,1\mathrm{.}73],[2018,20\mathrm{.}80,6\mathrm{.}89,-6\mathrm{.}24,2\mathrm{.}63],[2019,57\mathrm{.}03,25\mathrm{.}70,28\mathrm{.}88,1\mathrm{.}59],[2020,42\mathrm{.}53,743\mathrm{.}44,16\mathrm{.}26,0\mathrm{.}10],[2021,52\mathrm{.}48,49\mathrm{.}76,26\mathrm{.}89,0\mathrm{.}39],[2022,-28\mathrm{.}02,-65\mathrm{.}03,-19\mathrm{.}44,4\mathrm{.}73],[2023,16\mathrm{.}50,17\mathrm{.}50,7\mathrm{.}50,3\mathrm{.}52]]$Regress Stock.Risk.Premium as Dependent Y variable again Market Risk Premium for both MSFT and TSLA $($Refer Eqn $8\mathrm{.}6.$ Use Excel Data Manu $->$ Data Analysis $->$ Regression $->$ Status your Inputs Y and X$)$

What findings do your two regressions show?

What is the respective systematic risk $($betas$)$ for MSFT and for TSLA $($refer $8-4$C$)$

Conceptualize your analysis by summarizing your findings.