| Company Name: | PepsiCo Inc | | Ticker Symbol: | PEP | | | WWW Address: | www.pepsico.com |
| CEO: | Indra K. Nooyi | | No. of Employees: | 278,000 |
| Common Issue Type: | CS | | Business Description: | PepsiCo, Inc is a food, snack and beverage company, which manufactures or uses contract manufacturers, markets and sells a variety of salty, convenient, sweet and grain-based snacks, carbonated and non-carbonated beverages and foods.
|
| | | Industry Information: | FOOD & BEVERAGE - Beverages - Soft Drink [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 82.59 |  -1.21 | - | - | 83.79 | 83.84 | 82.47 | 3958151 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 127,718.5 | 1,546.4 | 0.50 | 3.92 | 2.13 | 21.2 | 2.7 | 84.78 - 66.66 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 82.59 | $ | | PE Ratio - LTM | 21.2 | |
| Market Capitalisation | 127,718.5 | mil |
| Latest Shares Outstanding | 1,546.4 | mil |
| Earnings pS (EPS) | 3.92 | $ |
| Dividend pS (DPS) | 2.13 | ¢ |
| Dividend Yield | 2.7 | % |
| Dividend Payout Ratio | 54 | % |
| Revenue per Employee | 235,583 | $ |
| Effective Tax Rate | 25.2 | % |
| Float | 1,560.3 | mil |
| Float as % of Shares Outstanding | 99.9 | % |
| Foreign Sales | 32,144 | mil |
| Domestic Sales | 33,348 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 38.50 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 56.3 | % |
| EBITDA Margin | 17.9 | % |
| Pre-Tax Profit Margin | 12.5 | % |
| Assets Turnover | 0.9 | % |
| Return on Assets (ROA) | 8.2 | % |
| Return on Equity (ROE) | 27.4 | % |
| Return on Capital Invested (ROCI) | 13.5 | % |
| Current Ratio | 1.1 | |
| Leverage Ratio (Assets/Equity) | 3.4 | |
| Interest Cover | 10.0 | |
| Total Debt/Equity (Gearing Ratio) | 1.31 | |
| LT Debt/Total Capital | 51.0 | % |
| Working Capital pS | 1.24 | $ |
| Cash pS | 4.34 | $ |
| Book-Value pS | 14.53 | $ |
| Tangible Book-Value pS | -7.01 | $ |
| Cash Flow pS | 5.72 | $ |
| Free Cash Flow pS | 2.41 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 5.68 | |
| Price/Tangible Book Ratio | -11.78 | |
| Price/Cash Flow | 14.4 | |
| Price/Free Cash Flow | 34.3 | |
| P/E as % of Industry Group | 83.0 | % |
| P/E as % of Sector Segment | 98.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 04/29/2013 |
| Dividend Ex-Date | 06/04/2013 |
| Dividend Record Date | 06/06/2013 |
| Dividend Pay Date | 06/27/2013 |
| Dividend Amount | 567 |
| Type of Payment | Cash Payment |
| Dividend Rate | 2.27 |
| Current Dividend Yield | 2.7 |
| 5-Y Average Dividend Yield | 3.1 |
| Payout Ratio | 54.0 |
| 5-Y Average Payout Ratio | 50.0 |
|  | | Share price performance previous 3 years |
|
 | | | Share price performance intraday |
|
 | | | | | PRICE/VOLUME | High | Low | Close | % Price Chg | % Price Chg vs. Mkt. | Avg. Daily Vol | Total Vol |
| 1 Week | - | - | - | -1.4 | 99 | 39,258 | 39,176 |
| 4 Weeks | 84.78 | 82.02 | 82.51 | 0.1 | 95 | 37,684 | 602,949 |
| 13 Weeks | 84.78 | 74.53 | 75.57 | 9.3 | 99 | 51,780 | 3,106,825 |
| 26 Weeks | 84.78 | 67.39 | 70.19 | 17.7 | 100 | 53,851 | 6,515,963 |
| 52 Weeks | 84.78 | 66.66 | 68.64 | 20.3 | 95 | 55,217 | 13,528,076 |
| YTD | 84.78 | 68.64 | - | 20.7 | 103 | 55,133 | 5,292,757 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 83.58 | 83.34 | 80.86 | 74.66 | 73.63 | 0.50 | 0.35 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 11.46 | 86.8 | 11.20 |
| Income | 3.61 | 62.0 | -0.01 |
| Dividend | 6.76 | 97.8 | 5.39 |
| Capital Spending | 7.80 | NA | 8.10 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 0.00 | NA | 0.00 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | 1.2 | 1.2 | -1.5 |
| Earnings % | -4.2 | -4.2 | -3.8 |
| EPS % | -2.8 | -2.8 | -2.7 |
| EPS $ | -0.02 | -0.02 | -0.11 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | 2.19 |
| Current Ratio | 1.1 |
| Quick Ratio (Acid Test) | 0.8 |
| Liquidity Ratio (Cash) | 0.39 |
| Receivables Turnover | 9.4 |
| Average Collection Period | 38 |
| Working Capital/Equity | 7.3 |
| Working Capital pS | 1.06 |
| Cash-Flow pS | 5.77 |
| Free Cash-Flow pS | 1.51 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 2.98 |
| Financial Leverage Ratio (Assets/Equity) | 3.3 |
| Debt Ratio | 70.0 |
| Total Debt/Equity (Gearing Ratio) | 1.27 |
| LT Debt/Equity | 1.05 |
| LT Debt/Capital Invested | 76.4 |
| LT Debt/Total Liabilities | 45.1 |
| Interest Cover | 10.2 |
| Interest/Capital Invested | 1.56 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 22.98 |
| Tobin's Q Ratio | 1.71 |
| Current P/E Ratio - LTM | 21.20 |
| Enterprise Value (EV)/EBITDA | 14.69 |
| Enterprise Value (EV)/Free Cash Flow | 79.77 |
| Dividend Yield | 2.7 |
| Price/Tangible Book Ratio - LTM | -11.78 |
| Price/Book Ratio - LTM | 5.68 |
| Price/Cash Flow Ratio | 14.4 |
| Price/Free Cash Flow Ratio - LTM | 34.3 |
| Price/Sales Ratio | 1.95 |
| P/E Ratio (1 month ago) - LTM | 21.2 |
| P/E Ratio (26 weeks ago) - LTM | 18.7 |
| P/E Ratio (52 weeks ago) - LTM | 17.1 |
| 5-Y High P/E Ratio | 24.9 |
| 5-Y Low P/E Ratio | 11.6 |
| 5-Y Average P/E Ratio | 16.8 |
| Current P/E Ratio as % of 5-Y Average P/E | 126 |
| P/E as % of Industry Group | 83.0 |
| P/E as % of Sector Segment | 98.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 21.2 |
| PER SHARE FIGURES |
| LT Debt pS | 15.25 |
| Current Liabilities pS | 11.07 |
| Tangible Book Value pS - LTM | -7.01 |
| Book Value pS - LTM | 14.53 |
| Capital Invested pS | 29.72 |
| Cash pS - LTM | 4.34 |
| Cash Flow pS - LTM | 5.72 |
| Free Cash Flow pS - LTM | 2.41 |
| Earnings pS (EPS) | 3.92 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 3.57 |
| Free Cash Flow Margin 5YEAR AVG | 1.75 |
| Net Profit Margin | 9.5 |
| Net Profit Margin - 5YEAR AVRG. | 6.9 |
| Equity Productivity | 2.92 |
| Return on Equity (ROE) | 27.7 |
| Return on Equity (ROE) - 5YEAR AVRG. | 20.4 |
| Capital Invested Productivity | 1.42 |
| Return on Capital Invested (ROCI) | 13.5 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 11.0 |
| Assets Productivity | 0.90 |
| Return on Assets (ROA) | 8.3 |
| Return on Assets (ROA) - 5YEAR AVRG. | 6.5 |
| Gross Profit Margin | 56.3 |
| Gross Profit Margin - 5YEAR AVRG. | 56.8 |
| EBITDA Margin - LTM | 17.9 |
| EBIT Margin - LTM | 13.9 |
| Pre-Tax Profit Margin | 12.7 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 14.6 |
| Effective Tax Rate | 25.2 |
| Effective Tax Rate - 5YEAR AVRG. | 25.6 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 85 |
| Revenue per Employee | 235,583 |
| Net Income per Employee | 22,353 |
| Average Collection Period | 39 |
| Receivables Turnover | 9.4 |
| Day's Inventory Turnover Ratio | 46 |
| Inventory Turnover | 7.8 |
| Inventory/Sales | 5.5 |
| Accounts Payble/Sales | 6.80 |
| Assets/Revenue | 1.11 |
| Net Working Capital Turnover | 40.15 |
| Fixed Assets Turnover | 1.17 |
| Total Assets Turnover | 0.9 |
| Revenue per $ Cash | 10.40 |
| Revenue per $ Plant | 3.42 |
| Revenue per $ Common Equity | 2.92 |
| Revenue per $ Capital Invested | 1.42 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 38.1 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 37.6 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
| | |  |  | |
| |
