Diageo (DGE)

Company name:	Diageo
Company Description:	A group engaged in the manufacture and distribution of spirits wines and beer
EPIC:	DGE	Trading Currency:	GBX
Market Sector:	FE10	ISIN:	GB0002374006
Market Segment:	SET1	Share Type:	DE
WWW Address:	http://www.diageo.com/	Description:	ORD 28 101/108P
Industry Sector:	BEVERAGES

Price	Price Change [%]	Bid	Offer	Open	High	Low	Volume
2,465.00	1.0 [0.04]	2,461.50	2,462.50	2,473.00	2,483.00	2,456.50	3,059,904
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52-Wks-Range
61,152.82	2,480.84	0.86	106.00	62.20	23.25	2.52	2,735.50 - 2,186.50

Diageo Key Figures

(at previous day's close)
Market Cap.	61,152.82	m
Shares In Issue	2,480.84	m
Prev. Close	2,464.00
PE Ratio	23.25
Dividend Yield	2.52	%
EPS - basic	106.00	p
Dividend PS	62.20	p
Dividend Cover	1.70
Cash Flow PS	126.25	p
Return On Equity (ROE)	25.81	%
Operating Margin	19.65	%
PEG Factor	1.26
EPS Growth Rate	18.44	%
Dividends PS Growth Rate	5.07	%
Net Debt	15,629.00	m
Gross Gearing	58.31	%
Quick Assets	3,975.00	m
Net Working Capital	2,103.00	m
Intangibles / Fixed Assets	62.56	%
Turnover PS	730.15	p
Pre-Tax Profit PS	143.46	p
Retained Profit PS	46.23	p
Cash PS	48.01	p
Net Cash PS	-220.45	p
Net Tangible Asset Value PS *	-90.82	p
Net Asset Value PS	484.83	p
Spread	1.00 (0.04%)
* Calculation based on Ordinary Capital figure as contained in last annual report, and the most recent shares in issue figure. Therefore the ratio might be exposed to inaccuracies.

Diageo Balance Sheet

Share Price Performance

Sample Period ^†	High	Low
1 week	2,499.00	2,436.50
4 weeks	2,535.00	2,345.50
12 weeks	2,568.00	2,345.50
1 year	2,735.50	2,186.50

Share Price Chart (5 years)

Diageo Historic Returns

Period ^†	Open	Change	%	Open Avg.	Avg. Daily Vol [m]	Total Vol [m]	VWAP
1 week	2,498.50	-33.50	-1.34	2,436.50	3.41		2,461.32
4 weeks	2,357.50	107.50	4.56	2,345.50	3.60		2,448.79
12 weeks	2,550.50	-85.50	-3.35	2,345.50	4.20		2,456.72
26 weeks	2,565.00	-100.00	-3.90	2,345.50	4.19		2,538.78
1 year	2,199.00	266.00	12.10	2,186.50	4.24		2,471.39
3 years	1,872.00	593.00	31.68	1,592.50	4.43		2,127.32
5 years	1,950.00	515.00	26.41	1,592.50	4.29		2,039.09
† periods calculated are whole weeks rather than calendar months

Diageo Key Management Ratios

Diageo Investment Ratios

(Market value analysis) at previous day's close
PQ Ratio	37.71
PE Ratio	23.25
Tobin's Q Ratio	2.13
Tobin's Q Ratio (excl. intangibles)	3.77
Dividend Yield	2.52	%
Market-to-Book Ratio	5.93
Price-to-Pre-Tax Profit PS	17.18
Price-to-Retained Profit PS	53.32
Price-to-Cash Flow PS	19.53
Price-to-Sales PS	3.38
Price-to-Net Tangible Asset Value PS	-113.67
Price-to-Cash PS	51.35
Net Working Capital PS	84.77
Price Pct to Working Capital PS	29.08	%
Earnings Yield	4.30	%
Average PE	20.58
Years in average	5
PE to PE average	113.01	%

Diageo Financial Ratios

(Leverage Ratios)
Debt Ratio	45.79	%
Debt-to-Equity Ratio	0.84
Debt-to-Equity Ratio (excl. Intgbl)	-18.88
Debt-to-Equity Market Value	0.17
Net Gearing	54.18	%
Net Gearing (excl. Intangibles)	95.99	%
Gross Gearing	58.31	%
Gross Gearing (excl. Intangibles)	103.30	%
Gearing Under 1 Year	23.09	%
Gearing Under 1 Year (excl. Intgbl)	40.90	%
Assets/Equity	2.40
Cash/Equity	9.90
(Liquidity Ratios)
Net Working Capital to Total Assets	7.29	%
Current Ratio	1.32
Quick Ratio (Acid Test)	0.60
Liquidity Ratio	0.18
Cash & Equiv/Current Assets	13.59	%
(Solvency Ratios)
Enterprise Value	71,836.82	m
CFO/Sales	0.17
CFO/Attributable Profit	1.18
CFO/Assets	0.11
CFO/Debt	0.19
Total Debt/Equity Market Value	0.28
Total Debt/Sales	0.93
Total Debt/Pre-Tax Profit	4.73
Total Debt	16,820.00	m
Total Debt/Net Current Assets	8.00	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	3.72	%
5 yr Compound Earnings Growth	1.31	%
10 yr Compound Earnings Growth	5.98	%
Earn drops > 5% in 10yrs	6

Beta (60-Mnth)	Beta (36-Mnth)
0.8560	0.8749

Diageo Operating Ratios

(Profitability Ratios)
Return On Capital Employed (ROCE)	16.04	%
Return On Assets (ROA)	9.29	%
Net Profit Margin	14.70	%
Assets Turnover	0.63
Return On Equity (ROE)	25.81	%
Return On Investment (ROI)	11.97	%
Dividend Payout Ratio	58.68	%
Plowback Ratio	41.32	%
Growth from Plowback Ratio	11.67	%
Net Income Of Revenues	6.33	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	1.92
Fixed Assets Turnover	0.91
Current Assets Turnover	2.07
Net Working Capital Turnover
Inventory Turnover	3.87
(Other Operating Ratios)
Total Assets-to-Sales	1.58
Debtors-to-Sales	16.05	%
Debt Collection Period	58.58	Days

Diageo Dividends

Announcement Date	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
25 Jan 2018	Interim	GBX	24.90	30/06/2017	30/06/2018	22/02/2018	23/02/2018	06/04/2018	-
27 Jul 2017	Final	GBX	38.50	30/06/2016	30/06/2017	10/08/2017	11/08/2017	05/10/2017	62.20
26 Jan 2017	Interim	GBX	23.70	30/06/2016	30/06/2017	23/02/2017	24/02/2017	06/04/2017	-
28 Jul 2016	Final	GBX	36.60	30/06/2015	30/06/2016	11/08/2016	12/08/2016	06/10/2016	59.20
28 Jan 2016	Interim	GBX	22.60	30/06/2015	30/06/2016	25/02/2016	26/02/2016	07/04/2016	-
30 Jul 2015	Final	GBX	34.90	30/06/2014	30/06/2015	12/08/2015	13/08/2015	08/10/2015	56.40
29 Jan 2015	Interim	GBX	21.50	30/06/2014	30/06/2015	26/02/2015	27/02/2015	07/04/2015	-
31 Jul 2014	Final	GBX	32.00	30/06/2013	30/06/2014	13/08/2014	15/08/2014	02/10/2014	51.70
30 Jan 2014	Interim	GBX	19.70	30/06/2013	30/06/2014	26/02/2014	28/02/2014	07/04/2014	-
31 Jul 2013	Final	GBX	29.30	30/06/2012	30/06/2013	14/08/2013	16/08/2013	03/10/2013	47.40
31 Jan 2013	Interim	GBX	18.10	30/06/2012	30/06/2013	27/02/2013	01/03/2013	12/04/2013	-
23 Aug 2012	Final	GBX	26.90	30/06/2011	30/06/2012	05/09/2012	07/09/2012	22/10/2012	43.50
09 Feb 2012	Interim	GBX	16.60	30/06/2011	30/06/2012	29/02/2012	02/03/2012	10/04/2012	-
25 Aug 2011	Final	GBX	24.90	30/06/2010	30/06/2011	07/09/2011	09/09/2011	24/10/2011	40.40
10 Feb 2011	Interim	GBX	15.50	30/06/2010	30/06/2011	02/03/2011	04/03/2011	06/04/2011	-
26 Aug 2010	Final	GBX	24.20	30/06/2009	30/06/2010	08/09/2010	10/09/2010	19/10/2010	38.10
11 Feb 2010	Interim	GBX	14.60	01/07/2009	31/12/2009	03/03/2010	05/03/2010	06/04/2010	-
27 Aug 2009	Final	GBX	22.20	30/06/2008	30/06/2009	09/09/2009	11/09/2009	19/10/2009	36.10
12 Feb 2009	Interim	GBX	13.90	01/07/2008	31/12/2008	04/03/2009	06/03/2009	06/04/2009	-
28 Aug 2008	Final	GBX	21.15	30/06/2007	30/06/2008	10/09/2008	12/09/2008	20/10/2008	34.35
14 Feb 2008	Interim	GBX	13.20	01/07/2007	31/12/2007	05/03/2008	07/03/2008	07/04/2008	-
20 Aug 2007	Final	GBX	20.15	30/06/2006	30/06/2007	12/09/2007	14/09/2007	22/10/2007	36.51
13 Feb 2007	Interim	GBX	12.55	01/07/2006	31/12/2006	07/03/2007	09/03/2007	10/04/2007	-
31 Aug 2006	Final	GBX	19.15	30/06/2005	30/06/2006	13/09/2006	15/09/2006	23/10/2006	31.10
16 Feb 2006	Interim	GBX	11.95	01/07/2005	31/12/2005	08/03/2006	10/03/2006	06/04/2006	-
01 Sep 2005	Final	GBX	18.20	30/06/2004	30/06/2005	14/09/2005	16/09/2005	24/10/2005	29.55
17 Feb 2005	Interim	GBX	11.35	01/07/2004	31/12/2004	02/03/2005	04/03/2005	06/04/2005	-
02 Sep 2004	Final	GBX	17.00	30/06/2003	30/06/2004	15/09/2004	17/09/2004	25/10/2004	27.60
19 Feb 2004	Interim	GBX	10.60	01/07/2003	31/12/2003	03/03/2004	05/03/2004	06/04/2004	-
04 Sep 2003	Final	GBX	15.70	30/06/2002	30/06/2003	17/09/2003	19/09/2003	27/10/2003	25.60
20 Feb 2003	Interim	GBX	9.90	01/07/2002	31/12/2002	05/03/2003	07/03/2003	07/04/2003	-
05 Sep 2002	Final	GBX	14.50	30/06/2001	30/06/2002	18/09/2002	20/09/2002	04/11/2002	23.80
21 Feb 2002	Interim	GBX	9.30	01/07/2001	31/12/2001	06/03/2002	08/03/2002	22/04/2002	-
06 Sep 2001	Final	GBX	13.40	30/06/2000	30/06/2001	19/09/2001	21/09/2001	05/11/2001	22.30
22 Feb 2001	Interim	GBX	8.90	01/07/2000	31/12/2000	07/03/2001	09/03/2001	23/04/2001	-
07 Sep 2000	Final	GBX	12.60	30/06/1999	30/06/2000	09/10/2000	13/10/2000	15/11/2000	21.00
24 Feb 2000	Interim	GBX	8.40	01/07/1999	31/12/1999	06/03/2000	10/03/2000	13/04/2000	-
16 Sep 1999	Final	GBX	11.70	30/06/1998	30/06/1999	04/10/1999	08/10/1999	15/11/1999	19.50
11 Mar 1999	Interim	GBX	7.80	01/07/1998	31/12/1998	22/03/1999	26/03/1999	30/04/1999	-
24 Sep 1998	Final	GBX	10.80	30/06/1997	30/06/1998	05/10/1998	09/10/1998	30/11/1998	23.30
31 Mar 1998	Interim	GBX	12.50	01/07/1997	31/12/1997	30/03/1998	03/04/1998	24/04/1998	-

Diageo Fundamentals

	30 Jun 2014 (GBP)		30 Jun 2015 (GBP)		30 Jun 2016 (GBP)		30 Jun 2017 (GBP)
turnover	13,980.00	100.00%	15,966.00	100.00%	15,641.00	100.00%	18,114.00	100.00%	m
pre tax profit	2,711.00	19.39%	2,933.00	18.37%	2,858.00	18.27%	3,559.00	19.65%	m
attributable profit	2,248.00	16.08%	2,381.00	14.91%	2,244.00	14.35%	2,662.00	14.70%	m
retained profit	1,020.00	7.30%	1,040.00	6.51%	801.00	5.12%	1,147.00	6.33%	m
eps - basic (p)	89.70		95.00		89.50		106.00
eps - diluted (p)	89.30		94.60		89.10		105.50
dividends per share	51.70		56.40		59.20		62.20

Diageo Balance Sheet

	30 Jun 2014 (GBP)		30 Jun 2015 (GBP)		30 Jun 2016 (GBP)		30 Jun 2017 (GBP)


	30 Jun 2014 (GBP)		30 Jun 2015 (GBP)		30 Jun 2016 (GBP)		30 Jun 2017 (GBP)
ASSETS
fixed assets	3,433.00	14.95%	3,690.00	14.30%	3,881.00	13.62%	4,014.00	13.91%	m
intangibles	7,891.00	34.36%	11,231.00	43.52%	12,370.00	43.42%	12,566.00	43.56%	m
fixed investments	3,936.00	17.14%	3,024.00	11.72%	3,539.00	12.42%	3,505.00	12.15%	m
current assets - other	8.00	0.03%	143.00	0.55%	3.00	0.01%	-	-%	m
stocks	4,222.00	18.39%	4,574.00	17.73%	4,579.00	16.07%	4,788.00	16.60%	m
debtors	2,852.00	12.42%	2,670.00	10.35%	3,030.00	10.63%	2,784.00	9.65%	m
cash & securities	622.00	2.71%	472.00	1.83%	1,089.00	3.82%	1,191.00	4.13%	m

TOTAL	22,964.00	100%	25,804.00	100%	28,491.00	100%	28,848.00	100%	m

LIABILITIES
creditors - short	4,851.00	21.12%	5,290.00	20.50%	6,187.00	21.72%	6,660.00	23.09%	m
creditors - long	10,523.00	45.82%	11,258.00	43.63%	12,124.00	42.55%	10,160.00	35.22%	m
creditors - other	-	-%	-	-%	-	-%	-	-%	m
subordinated loans	-	-%	-	-%	-	-%	-	-%	m
insurance funds	-	-%	-	-%	-	-%	-	-%	m

TOTAL	15,374.00	66.95%	16,548.00	64.13%	18,311.00	64.27%	16,820.00	58.31%	m

EQUITY
ord cap, reserves	6,823.00	29.71%	7,771.00	30.12%	8,530.00	29.94%	10,313.00	35.75%	m
prefs, minorities	767.00	3.34%	1,485.00	5.75%	1,650.00	5.79%	1,715.00	5.94%	m

TOTAL	7,590.00	33.05%	9,256.00	35.87%	10,180.00	35.73%	12,028.00	41.69%	m

OTHER
NAV Basic	-		-		-		-
NAV Diluted	-		-		-		-

Diageo Cash Flow Statement

	30 Jun 2014 (GBP)	30 Jun 2015 (GBP)	30 Jun 2016 (GBP)	30 Jun 2017 (GBP)
Operating CF	1,790.00	2,551.00	2,548.00	3,132.00	m
Pre-Financing CF	701.00	1,657.00	3,144.00	2,580.00	m
Retained CF	-921.00	-77.00	343.00	122.00	m

Diageo Brokers

Name	Activity	Type	Mnemonic	Code
Evolution Securities Limited	Market Maker(MME)	Broker/Dealer	EVO	EVBGGB21MMT
Winterflood Securities Ltd	Market Maker(MME)	Broker/Dealer	WINS	WNTSGB2LBIC