Question: 9. Spreadsheet Problem As discussed in the text, beta estimates for one firm will vary depending on various factors like such as the time over

 9. Spreadsheet Problem As discussed in the text, beta estimates for
one firm will vary depending on various factors like such as the

9. Spreadsheet Problem As discussed in the text, beta estimates for one firm will vary depending on various factors like 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 three stock market indices, compute Microsoft's beta using the S&P 500 Index as the market proxy. Then compute the beta using the DJIA and the NASDAQ indices as the market portfolio proxy. Compare the three 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!