\begin{tabular}{|l|r|r|r|} \hline Stock & Beta from regression & Beta Yahoo & Expected return \% \\ \hline IBM & 0.32 & 0.88 & 2.006 \\ \hline Apple & 0.07 & 1.25 & 3.756 \\ \hline Microsoft & 0.203 & 0.92 & 2.825 \\ \hline Walmart & 0.07 & 0.53 & 4.736 \\ \hline Bofa & 0.23 & 1.39 & 2.636 \\ \hline AT\&T & 0.22 & 0.72 & 2.706 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Risk free & 4.25% \\ \hline Risk Prem & 7% \\ \hline \end{tabular} 2. (a) Using regression against the S\&P 500 index, estimate beta for each of the 6 stocks above. (b) Based on the 30 -year T-Bond rate your beta estimate, a 7% market risk premium, and the CAPM, what is the required return for each of the 6 stocks above? (c) For each stock, compare this required return with the average expected return from your original data in Problem 1, and draw a preliminary conclusion on whether to take a long or short position. \begin{tabular}{|l|r|r|r|} \hline Stock & Beta from regression & Beta Yahoo & Expected return \% \\ \hline IBM & 0.32 & 0.88 & 2.006 \\ \hline Apple & 0.07 & 1.25 & 3.756 \\ \hline Microsoft & 0.203 & 0.92 & 2.825 \\ \hline Walmart & 0.07 & 0.53 & 4.736 \\ \hline Bofa & 0.23 & 1.39 & 2.636 \\ \hline AT\&T & 0.22 & 0.72 & 2.706 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Risk free & 4.25% \\ \hline Risk Prem & 7% \\ \hline \end{tabular} 2. (a) Using regression against the S\&P 500 index, estimate beta for each of the 6 stocks above. (b) Based on the 30 -year T-Bond rate your beta estimate, a 7% market risk premium, and the CAPM, what is the required return for each of the 6 stocks above? (c) For each stock, compare this required return with the average expected return from your original data in Problem 1, and draw a preliminary conclusion on whether to take a long or short position