Page 312 10-31 Spreadsheet Problem A discussed in the text, beta estimates for one firm will vary depending on various factors such as the time over which the estimation is conducted, the market portfolio proxy, and the return intervals. You will demonstrate this variation using returns for Microsoft a. Using all 45 monthly returns for Microsoft and the two stock market indexes, compute Microsoft's beta using the S&P 500 Index as the market proxy. Then compute the beta using the NASDAQ index as the market portfolio proxy, Compare the two beta estimates b. Now estimate the beta using only the most recent 30 monthly returns and the S&P 500 Index Compare the beta estimate to the estimate in part (a) when using the S&P 500 Index and all 45 monthly returns c. Estimate Microsoft's beta using the following quarterly returns. Compare the estimate to the ones from parts (a) and (b). A B 2 D F G 1 J L 1 Dale MSFT S&P500 NASDAQ Date MSFT S&P500 NASDAQ Date MSFT S&P500 NASDAQ 2 Jan 2016 -6.98% -0.41% -1.215 Oct 2014 2.47% 2.454 3.47% Jul 2013 5.64 -3.134 -1.01% 3 Dec 2015 -0.70 -5.07 -7.86 Sep 2014 1.27 2.32 3.06 Jun 2013 -7.82 4.95 6.56 4 Nov 2015 2.08 -1.75 -1.98 Aug 2014 2.05 -1.55 -1.90 May 2013 -1.03 -1.50 -1.52 5 Oct 2015 3.94 0.05 1.09 Jul 2014 5.92 3.77 4.82 Apr 2013 6.18 2.08 3.82 6 Sep 2015 18.93 8.30 9.38 Jun 2014 3.50 -1.51 -0.87 Mar 2013 15.69 1.81% 1.88% 7 Aug 2015 1.20 -2.64 -3.27 May 2014 1.86 1.91 3.90 Feb 2013 2.91 3.60 8 Jul 2015 -6.19 -6.26 -6.86 Apr 2014 2.05 2.10 3.11 Jan 2013 2.11 1.11 0.57 9 Jun 2015 5.78 1.97 2.84 Mar 2014 -1.44 0.52% -2.01 Dec 2012 2.77 5.04 4.06 10 May 2015 -5.78 -2.10 -1.64 Feb 2014 7.00 0.69 -2.53 Nov 2012 0.34 0.71 0.31 11 Apr 2015 -3.03 1.05 2.60 Jun 2014 2.00 4.31 4.98 Oct 2012 -5.96 0.28 1.11 12 Mar 2015 19.63 0.85 0.83 Dec 2013 1.15 -3.56 -1.74 Sep 2012 -4.10 -1.98 -4.46 13 Feb 2015 -7.27 -1.74 -1.26 Nov 2013 -1.89 2.36 2.87 Aug 2012 -3.44 2.42 1.61 14 Jan 2015 9.31 5.49 7.08 Oct 2013 8.50 2.80 3.58 Jul 2012 5.27 1.98 4.34 15 Dec 2014 -3.10 -2.13 Sep 2013 6.40 3.93 Jun 2012 -3.56 1.26 0.15 13.02 16 Nov 2014 -2.84 -0.42 -1.16 Aug 2013 -0.36 2.97 5.06 May 2012 4.80 3.96 A B 1 Date MSFT S&P500 2 Q4 2015 25.31% 1.05% 3 Q3 2015 0.91 -6.94 4 Q2 2015 9.29 -0.23 5 Q1 2015 -11.84 0.44 6 Q4 2014 0.83 4.39 7 Q3 2014 11.87 0.62 8 Q2 2014 2.45 4.69 9 QI 2014 10.39 1.30 10 Q4 2013 13.26 9.92 11 Q3 2013 -2.97 4.69 12 Q2 2013 13.02 1.93 13 Q1 2013 8.00 10.03 14 Q4 2012 -9.51 -1.01 15 Q3 2012 -2.07 5.76 16 Q2 2012 -4.55 -3.29