II. Risk 8. Risk and Return
Visit us at www.mhhe.com/bm7e
216 PART II Risk
6. Download the “Monthly Adjusted Prices” spreadsheets for Boeing and Pfizer from the
Standard & Poor’s Market Insight website (www
.mhhe.com/edumarketinsight
).
a. Calculate the annual standard deviation for each company, using the most recent
three years of monthly returns. Use the Excel function STDEV. Multiply by the square
root of 12 to convert to annual units.
b. Use the Excel function CORREL to calculate the correlation coefficient between the
stocks’ monthly returns.
c. Use the CAPM to estimate expected rates of return. Calculate betas, or use the most
recent beta reported under “Monthly Valuation Data” on the Market Insight website.
Use the current Treasury bill rate and a reasonable estimate of the market risk
premium.
d. Construct a graph like Figure 8.5. What combination of Boeing and Pfizer has the
lowest portfolio risk? What is the expected return for this minimum-risk portfolio?
7. The Treasury bill rate is 4 percent, and the expected return on the market portfolio is 12
percent. On the basis of the capital asset pricing model:
a. Draw a graph similar to Figure 8.7 showing how the expected return varies with beta.
b. What is the risk premium on the market?
c. What is the required return on an investment with a beta of 1.5?
d. If an investment with a beta of .8 offers an expected return of 9.8 percent, does it
have a positive NPV?
e. If the market expects a return of 11.2 percent from stock X, what is its beta?
8. Most of the companies in Table 8.2 are covered in the Standard & Poor’s Market In-
sight website (www
.mhhe.com/edumarketinsight). For those that are covered, use
the Excel SLOPE function to recalculate betas from the monthly returns on the
“Monthly Adjusted Prices” spreadsheets. Use as many monthly returns as available,
up to a maximum of 60 months. Recalculate expected rates of return from the CAPM
formula, using a current risk-free rate and a market risk premium of 8 percent. How
have the expected returns changed from the figures reported in Table 8.2?
9. Go to the Standard & Poor’s Market Insight website (www
.mhhe.com/edumarket
insight), and find a low-risk income stock—Exxon Mobil or Kellogg might be good
candidates. Estimate the company’s beta to confirm that it is well below 1.0. Use
monthly rates of return for the most recent three years. For the same period, estimate
the annual standard deviation for the stock, the standard deviation for the S&P 500,
and the correlation coefficient between returns on the stock and the S&P 500. (The
Excel functions are given in Practice Questions above.) Forecast the expected rate of
return for the stock, assuming the CAPM holds, with a market return of 12 percent
and a risk-free rate of 5 percent.
a. Plot a graph like Figure 8.5 showing the combinations of risk and return from a
portfolio invested in your low-risk stock and in the market. Vary the fraction
invested in the stock from zero to 100 percent.
b. Suppose you can borrow or lend at 5 percent. Would you invest in some
combination of your low-risk stock and the market? Or would you simply invest in
the market? Explain.
c. Suppose you forecast a return on the stock that is 5 percentage points higher than
the CAPM return used in part (a). Redo parts (a) and (b) with this higher
forecasted return.
d. Find a high-beta stock and redo parts (a), (b), and (c).
10. Percival Hygiene has $10 million invested in long-term corporate bonds. This bond
portfolio’s expected annual rate of return is 9 percent, and the annual standard devia-
tion is 10 percent.
Amanda Reckonwith, Percival’s financial adviser, recommends that Percival con-
sider investing in an index fund which closely tracks the Standard and Poor’s 500 in-