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

please answer third slide  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 table contains the excess monthly returns for three companies and

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!