1. Calculate the monthly excess returns, I'M-If, on the market portfolio. 2. MSFT is not currently paying dividend. The closing price in December 1990 (adjusted for stock splits) was $ 16.72. Calculate the monthly excess returns, IMSFT-If, on Microsoft common stock. 3. a. Estimate the B for MSFT using the linear regression model I'MSFT - If = a + B(I'M - If) b. What is the adjusted R' for the regression model (that is, what proportion of the variation in I'MSFT - If is explained by variation in I'M - If ) ? You can use the CAPM to estimate Microsoft's required return. You calculated Microsoft's beta in question 3. You will need the following additional information : Riskless Rate at Year-End Market Risk Premium 1995 (I'M - rf) Short-term 5.13 % 8.40 % Intermediate-term 5.50% 7.40 % Long-term 6.00 % 7.00 % 4. Estimate MSFT's required return (re) using the CAPM and the short-term riskless rate. 5. Esimate re using the CAPM and the intermediate-term riskless rate. 6. Estimate re using the CAPM and the long-term riskless rate. 7. Compare your answers to questions 4,5, and 6. Can you explain why they differ ? 8. Why is it important to be consistent in choosing the riskless rate and the market risk premium when you use the CAPM ?GROUP TASK REAL WORLD APPLICATION ESTIMATING MICROSOFT'S REQUIRED RETURN %%% % %%_ .mAW _ 00000000000 5.3. %%%%%%%%%%%%%%W; mm \"News New ... mmmmmmmmmmmmmmmmmmmmmmmm w; software in the world. Its common stock is traded in the overthecounter market and listed in NASDAQ. The following table shown MSFT's monthly closing price dining Microsoft Corporation (stock symbol MSFT) is one of the leading providers of computer 1991-1995