4 Using the following information to answer question 2-10 \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{5} & \multicolumn{3}{c|}{ Using the following information to answer question 2-10 } \\ \cline { 2 - 4 } & \multicolumn{3}{c|}{ Microsoft } \\ \hline \multirow{2}{*}{7} & Date & Market Price & Dividends \\ \hline 8 & 10/1/2016 & 59.92 & \\ \hline 9 & 11/1/2016 & 60.26 & 0.39 \\ \hline 10 & 12/1/2016 & 62.14 & \\ \hline 11 & 1/1/2017 & 64.65 & \\ \hline 12 & 2/1/2017 & 63.98 & 0.39 \\ \hline 13 & 3/1/2017 & 65.86 & \\ \hline 14 & 4/1/2017 & 68.46 & \\ \hline 15 & 5/1/2017 & 69.84 & 0.39 \\ \hline 16 & 6/1/2017 & 68.93 & \\ \hline 17 & 7/1/2017 & 72.70 & \\ \hline 18 & 8/1/2017 & 74.77 & 0.39 \\ \hline 19 & 9/1/2017 & 74.49 & \\ \hline 20 & 10/1/2017 & 78.63 & \\ \hline 21 & 10/27/2017 & 83.81 & \\ \hline 22 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ Facebook } \\ \hline Date & Market Price \\ \hline 10/1/2016 & 130.99 \\ \hline 11/1/2016 & 118.42 \\ \hline 12/1/2016 & 115.05 \\ \hline 1/1/2017 & 130.32 \\ \hline 2/1/2017 & 135.54 \\ \hline 3/1/2017 & 142.05 \\ \hline 4/1/2017 & 150.25 \\ \hline 5/1/2017 & 151.46 \\ \hline 6/1/2017 & 150.98 \\ \hline 7/1/2017 & 169.25 \\ \hline 8/1/2017 & 171.97 \\ \hline 9/1/2017 & 170.87 \\ \hline 10/1/2017 & 170.60 \\ \hline 10/27/2017 & 177.88 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Stock Beta & \\ \hline & \\ \hline Microsoft & 1.45 \\ \hline Facebook & 0.58 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline A & B & C & D & E & F \\ \hline \end{tabular} Question 2: Calculate monthly holding period return for Microsoft (MSFT). Question 3: What is the average monthly return for MSFT? 51 52 53 Question 4: Calculate monthly holding period return for Facebook (FB). \begin{tabular}{l} 64 \\ \hline 65 \\ \hline 66 \\ 67 \\ \hline 68 \\ \hline 69 \\ 70 \end{tabular} 71 72 73 74 75 76 78 Question 5: 79 What is the average monthly return for FB ? Question 6: If you are investing $45,000 in MSFT and $65,000 in FB, calculate the portfolio return. \begin{tabular}{l|l} \hline 120 & \\ \hline 121 & \\ \hline 122 & \\ \hline 123 & Question 7: \end{tabular} 124 Using the beta for MSFT and FB, calculate portfolio beta