Question: please answer third slide fx Accessibility tab summary: Given information for this question is presented in rows 2 through A B C D The following


fx Accessibility tab summary: Given information for this question is presented in rows 2 through A B C D The following table contains the excess monthly returns for three companies and the market index. A1 fx Accessibility tab summary: Given information for this question is presented in rows 2 thro \begin{tabular}{|r|rrrrr|r|} & \multicolumn{1}{l}{ A } & \multicolumn{1}{l}{ B } & \multicolumn{1}{l}{ C } & D & E & F \\ \hline 24 & 8/1/2008 & 0.0723 & 0.0103 & 0.0549 & 0.0091 \\ \hline 25 & 9/1/2008 & 0.1650 & 0.0129 & 0.1436 & 0.0989 \\ 26 & 10/1/2008 & 0.5794 & 0.0687 & 0.3100 & 0.1852 \\ 27 & 11/1/2008 & 0.2282 & 0.0011 & 0.3278 & 0.0848 \\ 28 & 12/1/2008 & 0.1487 & 0.0074 & 0.1139 & 0.0221 \\ 29 & 1/1/2009 & 0.1835 & 0.1596 & 0.5328 & 0.0774 \\ 30 & 2/1/2009 & 0.0693 & 0.0447 & 0.3999 & 0.1005 \\ 31 & 3/1/2009 & 0.3148 & 0.0634 & 0.7289 & 0.0865 \\ 32 & 4/1/2009 & 1.2736 & 0.0328 & 0.3093 & 0.1092 \\ 33 & 5/1/2009 & 0.0386 & 0.0078 & 0.2619 & 0.0676 \\ 34 & 6/1/2009 & 0.0555 & 0.0263 & 0.1720 & 0.0032 \\ 35 & 7/1/2009 & 0.3178 & 0.0296 & 0.1203 & 0.0816 \\ 36 & 8/1/2009 & 0.0501 & 0.0252 & 0.1892 & 0.0313 \\ 37 & 9/1/2009 & 0.0514 & 0.0351 & 0.0376 & 0.0451 \\ 38 & 10/1/2009 & 0.0292 & 0.0120 & 0.1384 & 0.0281 \\ 39 & 11/1/2009 & 0.2700 & 0.0980 & 0.0871 & 0.0571 \\ 40 & 12/1/2009 & 0.1248 & 0.0152 & 0.0493 & 0.0284 \\ \hline \end{tabular} 42 Required: Using the monthly excess returns above, calculate the stocks' covariance with the market and their betas. (Note: 43 the covariance of the market with the market is just its variance.) (Use cells A5 to E40 from the given information to complete this question.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
