Use Model 3.34 on the Dividend Discount Model tab of the chapter spreadsheet.)

a.) Describe the pattern of PEP's dividend growth rates over the past 5 years.
b.) Do you think the forecasted dividend growth (5%, 4%, 3%, 2% and 2%) fits well with the historical dividend growth pattern?
c.) Why is PEP's required return so low (4.833%)?
d.) Does PEP's dividend yield represent a substantial portion of its expected return?
e.) Describe PEP's overall valuation based on the dividend discount model shown in the example.
f.) Does your answer to e.) change if you stress PEP in the model and raise its beta to 0.55?
g.) Next, reset PEP's beta to its historical average by removing the alternative beta (cell D92) and reducing the long-term perpetual growth rate from 2% to 1% (cell L80). Describe PEP's valuation after reducing the expected dividend growth rates.
h.) Write a brief overview of PEP's valuation based on a dividend discount model.

3.34 PEP Pepsico, Inc February 28, 2013 Expected Dividend Growth Rates 3.0% 2015 $2.23 $2.32 $2.39 $2.44 $2.49 4.0% 2014 Annual Dividend 5.0% 20% 2.0% 2011 2007 $1.43 $1.65 $1.78 $1.89 $2.03 $2.13 2008 2009 2010 2012 2013 2016 2017 $8.34 $72.75 $81.09 $75.93 Dividend Yeld 2.94% 1-Yr Div Growth 3-Yr Div Growth 5-Yr Div Growth Risk-Free Rate 5-Yr Beta Market Premium Required Return 5.1% 6.2% 8.3% 2.0070% 0.471 6.0% 4.833% PV Dividends 1.4 PV Perpetual Div Intrinsic Value Current Price Purchase Price Expected Return $75.93 6.64% Analyst Notes: Based on a current dividend of $2.13, expected growth as shown above and a required return of 4.8%, Pepsico, Inc. is worth $81.09 per share Alternative Beta Datasource: S&Ps CapitalQ