Using the following information to answer question 210 Question 2: Calculate monthly holding period retum for Microsoft (MSFT) Question 2: Calculate monthly holding period return for Microsoft (MSFT) Click Saue and Submit to save and submit. Click Save All Answers to save all answers. \begin{tabular}{|c|c|c|c|} \hline 2/1/2017 & 63.98 & 0.39 & 0.004331044 \\ \hline 3/1/2017 & 65.86 & & 0.029384198 \\ \hline 4/1/2017 & 68.46 & & 0.039477649 \\ \hline 5/1/2017 & 69.84 & 0.39 & 0.02585447 \\ \hline 6/1/2017 & 68.93 & & 0.013029726 \\ \hline 7/1/2017 & 72.70 & 0.39 & 0.060351037 \\ \hline 8/1/2017 & 74.77 & 0.39 & 0.033837691 \\ \hline 9/1/2017 & 74.49 & 0.39 & 0.001471192 \\ \hline 10/1/2017 & 78.63 & 0.39 & 0.06081352 \\ \hline 10/27/2017 & 83.81 & & 0.065878179 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Date & Market Price & Dividends & HRP \\ \hline 10/1/2016 & 59.92 & & 0 \\ \hline 11/1/2016 & 60.26 & 0.39 & 0.012182911 \\ \hline 12/1/2016 & 62.14 & & 0.031198159 \\ \hline 1/1/2017 & 64.65 & & 0.040392711 \\ \hline 2/1/2017 & 63.98 & 0.39 & 0.004331044 \\ \hline 3/1/2017 & 65.86 & & 0.029384198 \\ \hline 4/1/2017 & 68.46 & & 0.039477649 \\ \hline 5/1/2017 & 69.84 & & 0.020157713 \\ \hline 6/1/2017 & 68.93 & & 0.013029726 \\ \hline 7/1/2017 & 72.70 & & 0.054693123 \\ \hline 8/1/2017 & 74.77 & & 0.028473179 \\ \hline 9/1/2017 & 74.49 & & 0.003744804 \\ \hline 10/1/2017 & 78.63 & & 0.055577918 \\ \hline 10/27/2017 & 83.81 & & 0.065878179 \\ \hline \end{tabular} Question 3: What is the average monthly return for MSFT 0.05890.03640.0283 QUESTION 4 Question 4: Calculate monthly holding period return for Facebook (FB). Question 4: Calculate monthly holding period return for Facebook (FB). Click Save and Sulmit to nate and submit. Clicks Sate All Answers to sate all anstwers, \begin{tabular}{|c|c|c|} \hline 3/1/2017 & 157.30 & 0.161 \\ \hline 4/1/2017 & 150.25 & 0.045 \\ \hline 5/1/2017 & 157.60 & 0.049 \\ \hline 6/1/2017 & 136.80 & 0.132 \\ \hline 7/1/2017 & 178.20 & 0.303 \\ \hline 8/1/2017 & 171.97 & 0.035 \\ \hline 9/1/2017 & 171.50 & 0.003 \\ \hline 10/1/2017 & 170.60 & 0.005 \\ \hline 10/27/2017 & 177.88 & 0.043 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Facebook } \\ \hline Date & Market Price & HPR \\ \hline 10/1/2016 & 130.99 & 0 \\ \hline 11/1/2016 & 118.42 & 0.096 \\ \hline 12/1/2016 & 115.05 & 0.028 \\ \hline 1/1/2017 & 130.32 & 0.133 \\ \hline 2/1/2017 & 135.54 & 0.04 \\ \hline 3/1/2017 & 142.05 & 0.048 \\ \hline 4/1/2017 & 150.25 & 0.058 \\ \hline 5/1/2017 & 151.46 & 0.008 \\ \hline 6/1/2017 & 150.98 & 0.003 \\ \hline 7/1/2017 & 16925 & 0.121 \\ \hline 8/1/2017 & 171.97 & 0.016 \\ \hline 9/1/2017 & 170.87 & 0.006 \\ \hline 10/1/2017 & 170.60 & 0.002 \\ \hline 10/27/2017 & 177.88 & 0.043 \\ \hline \end{tabular} Question 5: What is the average monthly retum for FB? 0.0250.0360.048 QUESTION 6 Question 6: If you are investing $45,000 in MSF and $65,000 in FB, calculate the portfolio return. 3.78% 2.66% 2.41% QUESTION 7 Question 7: Using the beta for MSFT and FB, calculate portfolio beta. 0.936 0.541 0.786 Question 8: If the average monthly return on market portfolio (S\&P 500) is 1.51% and 1-month risk free rate is 0.95%, calculate the expected return for MSFT. 1.98% 1.24% 1.76% QUESTION 9 Question 9: If the averaje monthly return on market portfolio (S8. 500) is 1.51\% and 1-month risk free rate is 0.95%, calculate the expecied retum for FB, 1.53% 1.27% 1.85\% QUESTION 10 Question 10: Calculate the portiolio expected relurn. 1.47% 1 b574 1.37x