With the information given above, answer the both portfolio betas and portfolio expected returns (annual) in question 9 using Excel format.

Question 7 Average monthly return Standard deviation of return \begin{tabular}{|r|r|r|r|} \multicolumn{1}{c}{\multicolumn{1}{c}{ TSLA }} & \multicolumn{1}{c}{ TGT } & \multicolumn{1}{c}{ S\&P 500 } & \multicolumn{1}{c}{ T-Bill } \\ \hline 5.22% & 2.19% & 1.05% & 0.12% \\ \hline 20.42% & 9.25% & 5.11% & 0.10% \\ \hline \end{tabular} Question 8 TSLA Beta Expected return (annual) \begin{tabular}{|r|r|} \hline 1.97 & 1.02 \\ \hline 23.37% & 12.78% \\ \hline \end{tabular} Question 9 Weight of TSLA Weight of TGT \begin{tabular}{|l|} \hline 30.00% \\ \hline 70.00% \\ \hline \end{tabular} Portfolio Beta Portfolio Expected return (annual) \begin{tabular}{|l|l|} \hline & \\ \hline & \\ \hline \end{tabular}