| Company Name: | Diageo PLC | | Ticker Symbol: | DEO | | | WWW Address: | www.diageo.com |
| CEO: | Mr. Paul Stephen Walsh | | No. of Employees: | 25,698 |
| Common Issue Type: | AD | | Business Description: | Diageo PLC is engaged in premium drinks business with a collection of beverage alcohol brands across spirits, wines and beer categories.
|
| | | Industry Information: | FOOD & BEVERAGE - Beverages - Wineries & Distillers [more like this] |
|
| Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 121.81 |  -1.35 | - | - | 121.9 | 122.08 | 120.36 | 409272 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 76,385.6 | 627.1 | 0.78 | 2.37 | 2.64 | 51.3 | 1.8 | 132.10 - 93.05 |
|
| KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 121.81 | $ | | PE Ratio - LTM | 51.3 | |
| Market Capitalisation | 76,385.6 | mil |
| Latest Shares Outstanding | 627.1 | mil |
| Earnings pS (EPS) | 2.37 | $ |
| Dividend pS (DPS) | 2.64 | ¢ |
| Dividend Yield | 1.8 | % |
| Dividend Payout Ratio | 111 | % |
| Revenue per Employee | 657,788 | $ |
| Effective Tax Rate | 33.3 | % |
| Float | 0.0 | mil |
| Float as % of Shares Outstanding | 0.0 | % |
| Foreign Sales | 20,306 | mil |
| Domestic Sales | 2,617 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 0.00 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 0.0 | % |
| EBITDA Margin | 0.0 | % |
| Pre-Tax Profit Margin | 0.0 | % |
| Assets Turnover | 0.0 | % |
| Return on Assets (ROA) | 0.0 | % |
| Return on Equity (ROE) | 0.0 | % |
| Return on Capital Invested (ROCI) | 0.0 | % |
| Current Ratio | 1.3 | |
| Leverage Ratio (Assets/Equity) | 3.7 | |
| Interest Cover | 0.0 | |
| Total Debt/Equity (Gearing Ratio) | 1.34 | |
| LT Debt/Total Capital | 50.0 | % |
| Working Capital pS | 4.73 | $ |
| Cash pS | 1.82 | $ |
| Book-Value pS | 16.30 | $ |
| Tangible Book-Value pS | -6.66 | $ |
| Cash Flow pS | 6.22 | $ |
| Free Cash Flow pS | 1.10 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 7.47 | |
| Price/Tangible Book Ratio | -18.30 | |
| Price/Cash Flow | 19.6 | |
| Price/Free Cash Flow | 110.4 | |
| P/E as % of Industry Group | 206.0 | % |
| P/E as % of Sector Segment | 127.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 01/30/2013 |
| Dividend Ex-Date | 02/26/2013 |
| Dividend Record Date | 02/28/2013 |
| Dividend Pay Date | 04/11/2013 |
| Dividend Amount | 1104 |
| Type of Payment | Cash Payment |
| Dividend Rate | 2.21 |
| Current Dividend Yield | 1.8 |
| 5-Y Average Dividend Yield | 2.6 |
| Payout Ratio | 111.0 |
| 5-Y Average Payout Ratio | 66.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.1 | 100 | 5,040 | 23,977 |
| 4 Weeks | 126.29 | 120.36 | 120.34 | 1.2 | 97 | 4,878 | 92,676 |
| 13 Weeks | 127.51 | 117.51 | 120.91 | 0.7 | 93 | 5,572 | 351,039 |
| 26 Weeks | 127.51 | 114.52 | 120.69 | 0.9 | 86 | 5,433 | 673,662 |
| 52 Weeks | 132.10 | 93.05 | 94.61 | 28.7 | 103 | 5,602 | 1,389,411 |
| YTD | 127.51 | 114.52 | - | 4.5 | 90 | 5,319 | 526,570 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 123.05 | 123.99 | 122.89 | 119.64 | 116.97 | 0.78 | 0.82 |
|
| |
| GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 1.50 | 29.6 | 3.84 |
| Income | -8.39 | 38.2 | -14.35 |
| Dividend | 0.71 | 4.4 | 5.18 |
| Capital Spending | 15.58 | NA | 51.90 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 3.12 | NA | 6.36 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | 5.8 | 0.0 | 5.8 |
| Earnings % | 74.9 | 0.0 | 0.4 |
| EPS % | -51.4 | 0.0 | -51.4 |
| EPS $ | -2.51 | 0.00 | -2.51 |
|
| |
| SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | 11.05 |
| Current Ratio | 1.5 |
| Quick Ratio (Acid Test) | 0.6 |
| Liquidity Ratio (Cash) | 0.23 |
| Receivables Turnover | 5.7 |
| Average Collection Period | 63 |
| Working Capital/Equity | 44.2 |
| Working Capital pS | 5.63 |
| Cash-Flow pS | 5.66 |
| Free Cash-Flow pS | -2.09 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 3.13 |
| Financial Leverage Ratio (Assets/Equity) | 4.0 |
| Debt Ratio | 75.0 |
| Total Debt/Equity (Gearing Ratio) | 1.54 |
| LT Debt/Equity | 1.32 |
| LT Debt/Capital Invested | 92.2 |
| LT Debt/Total Liabilities | 44.1 |
| Interest Cover | 5.8 |
| Interest/Capital Invested | 3.67 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 124.02 |
| Tobin's Q Ratio | 2.18 |
| Current P/E Ratio - LTM | 51.30 |
| Enterprise Value (EV)/EBITDA | 18.01 |
| Enterprise Value (EV)/Free Cash Flow | -63.76 |
| Dividend Yield | 1.8 |
| Price/Tangible Book Ratio - LTM | -18.30 |
| Price/Book Ratio - LTM | 7.47 |
| Price/Cash Flow Ratio | 19.6 |
| Price/Free Cash Flow Ratio - LTM | 110.4 |
| Price/Sales Ratio | 4.52 |
| P/E Ratio (1 month ago) - LTM | 51.9 |
| P/E Ratio (26 weeks ago) - LTM | 50.9 |
| P/E Ratio (52 weeks ago) - LTM | 0.0 |
| 5-Y High P/E Ratio | 44.2 |
| 5-Y Low P/E Ratio | 9.6 |
| 5-Y Average P/E Ratio | 21.0 |
| Current P/E Ratio as % of 5-Y Average P/E | 244 |
| P/E as % of Industry Group | 206.0 |
| P/E as % of Sector Segment | 127.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 24.9 |
| PER SHARE FIGURES |
| LT Debt pS | 16.88 |
| Current Liabilities pS | 10.91 |
| Tangible Book Value pS - LTM | -6.66 |
| Book Value pS - LTM | 16.30 |
| Capital Invested pS | 32.53 |
| Cash pS - LTM | 1.82 |
| Cash Flow pS - LTM | 6.22 |
| Free Cash Flow pS - LTM | 1.10 |
| Earnings pS (EPS) | 2.37 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | -8.49 |
| Free Cash Flow Margin 5YEAR AVG | 1.33 |
| Net Profit Margin | 19.3 |
| Net Profit Margin - 5YEAR AVRG. | 19.2 |
| Equity Productivity | 1.93 |
| Return on Equity (ROE) | 37.1 |
| Return on Equity (ROE) - 5YEAR AVRG. | 42.6 |
| Capital Invested Productivity | 0.83 |
| Return on Capital Invested (ROCI) | 16.0 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 16.1 |
| Assets Productivity | 0.50 |
| Return on Assets (ROA) | 9.3 |
| Return on Assets (ROA) - 5YEAR AVRG. | 9.6 |
| Gross Profit Margin | 0.0 |
| Gross Profit Margin - 5YEAR AVRG. | 62.7 |
| EBITDA Margin - LTM | 0.0 |
| EBIT Margin - LTM | 0.0 |
| Pre-Tax Profit Margin | 29.0 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 24.7 |
| Effective Tax Rate | 33.3 |
| Effective Tax Rate - 5YEAR AVRG. | 21.7 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 416 |
| Revenue per Employee | 657,788 |
| Net Income per Employee | 126,643 |
| Average Collection Period | 65 |
| Receivables Turnover | 5.7 |
| Day's Inventory Turnover Ratio | 351 |
| Inventory Turnover | 1.0 |
| Inventory/Sales | 36.7 |
| Accounts Payble/Sales | 27.85 |
| Assets/Revenue | 2.00 |
| Net Working Capital Turnover | 4.36 |
| Fixed Assets Turnover | 0.71 |
| Total Assets Turnover | 0.5 |
| Revenue per $ Cash | 10.00 |
| Revenue per $ Plant | 3.62 |
| Revenue per $ Common Equity | 1.93 |
| Revenue per $ Capital Invested | 0.83 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 31.1 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 32.2 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
|
| |
 |  |
