McDonald's (MCD) Valuation Sheet

Comparable Valuation Sheet McDonald's YUM! Brands Wendy's Burger King Average Market Cap $97bn $32bn $3bn $7bn $35bn 2012 Revenues $27.5bn $13.6bn $2.5bn $1.9bn $11.4bn Same Store Sales Growth Gross Margins 0.9% -2.0% 3.2% 0.9% 0.75% 40% 70% 27% 94% 58% Operating Margins 3yr Revenue CAGR Dividend Yield 33% 17% 8% 53% 28% 6.6% 7.9% -11.2% -8.1% -1.2% 3.2% 1.9% 2.0% 0.8% 2.0% P/E (ttm*) 16.4x 21.7x 31.2x 23.1x 23.1 1yr Forward P/E 16.2x 20.4x 29.5x 22.5x 22.5x Return on 38% 50% 2% 17% 27% Equity Debt/Equity 89% 127% 77% 218% 128% *trailing twelve months Yum! Wendy's BURGER KING Operates Pizza Hut, KFC and Taco Bell. Major changes are underway. Has initiated an Taken public in 2010, the company is now Image Activation' emphasizing more on selling Over 10,000 program. Rebranded stores have restaurants to franchisees in order to lower costs for the outlets in China. subsequently experienced sales growth of upto Suffered losses due to the avian flu scare; sales fell by parent company. Calculation of McDonald's Share Price at Various Multiples Competitors' ETF Average S&P 500 MCD BKW WEN YUM (XLY*) Forward 22.5 17.6 14.8 16.2 22.5 29.5 20.4 Price/ Earnings (x) Calculation of McDonald's stock price based on various multiples XLF's P/E Multiple 17.6x Competitors' Average Multiple 22.5x Forecasted EPS (FY14) $6.02 Forecasted EPS (FY14) $6.02 Price $105.9 Price $135.4 S&P 500 Multiple 14.8x 5Yr Historical Average P/E 15.4x Forecasted EPS (FY14) $6.02 Forecasted EPS (FY14) $6.02 Price $89.1 Price $92.7 *XLY is the S&P Consumer Discretionary Select Sector SPDR® exchange-traded fund (ETF). BIDNESS SOURCES: Company Data, SEC filings, Bloomberg Professional Services Etc. DISCLAIMER: Bidness Etc(TM) and related marks are owned by Bidness Etc. Any other trademarks appearing on this website are the property of their respective owners, and are not used to indicate the origin of goods or services offered or provided by Bidness Etc herein or to suggest approval for or affiliation with Bidness Etc.