Go to the Online Learning Center at www.mhhe.com/bkm, where you will find rate of return data over 60 months for Google, the T-bill rate, and the S&P 500, which we will use as the market index portfolio.

a. Use these data and Excel’s regression function to compute Google’s excess return each period as well as its alpha, beta, and residual standard deviation, ␴(e).

b. What was the Sharpe ratio of the S&P 500 over this period?

c. What was Google’s information ratio over this period?

d. If someone whose risky portfolio is currently invested in an index portfolio such as the S&P 500 wishes to take a position in Google based on the estimates from parts

(a)–(c), what would be the optimal fraction of the risky portfolio to invest in Google?

Use Equations 6.15 and 6.16.

e. Based on Equation 6.17 and your answer to part (d), by how much would the Sharpe ratio of the optimal risky portfolio increase given the incremental position in Google? LO.1