br />Public Policy 741 Case 2 (Beta Management Company) Questions
NOTE: Answers to these questions are due at the beginning of class on Monday, October
3, 2005. I highly recommend that you use EXCEL to complete this assignment. The
investment return data listed on page 3 of the Beta Management Company case (in the
coursepack) is available on the course webpage in an excel file.
1. Calculate the variability (standard deviation) of the stock returns of California REIT and
Brown Group during the past 2 years. How variable are they compared with Vanguard
Index 500 Trust? Which stock appears to be riskiest?
2. Suppose Beta position had been 99% of equity funds invested in the index fund, and 1%
in the individual stock. Calculate the variability of this portfolio using each stock. How
does each stock affect the variability of the equity investment, and which stock is riskiest?
Explain how this makes sense in view of your answer to Question #1 above.
3. Perform a regression of each stock monthly returns on the Index returns to compute the
beta for each stock. How does this relate to the situation described in Question #2 above?
NOTE: To perform a regression in excel follow these simple steps:
1. from the Tools menu, choose the Data Analysis command
2. in the data analysis dialog box, scroll the list box, select Regression, and click O.K.