Excel question: This question requires data collection. You can find all numbers at http://finance.yahoo.com/. The questions concern Walmart Inc. (ticker: WMT). (a) What is the current price and the current price-earnings ratio? (b) What is the current plowback ratio? (c) What is the growth rate of earnings for the next 5 years according to the analysts? Hint: look for annual growth rates under "Analysis" (d) If WMT has a beta of 1.1, the risk-free rate (Rf ) is 2%, and the market risk premium E[RM] Rf is 6%, what is the required rate of return on WMT according to the CAPM? (e) Suppose the earnings and dividends of WMT will grow at a rate equal to the forecast from part (c) forever; i.e., the Gordon growth model (GGM) applies. Using the required rate of return from (d), what price-earnings ratio does the GGM predict for WMT? (f) What growth rate is the market price-earnings ratio pricing in?