Diageo (DGE)

[ADVERT]

Company name:	Diageo Plc
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
3,607.50	-8.0 [-0.22]	3,610.50	3,611.50	3,596.00	3,616.50	3,577.50	2,772,198
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52-Wks-Range
84,376.72	2,338.92	0.32	113.80	72.55	31.70	2.01	3,666.00 - 2,474.00

Diageo Key Figures

(at previous day's close)
Market Cap.	84,376.72	m
Shares In Issue	2,338.92	m
Prev. Close	3,615.50
PE Ratio	31.70
Dividend Yield	2.01	%
EPS - basic	113.80	p
Dividend PS	72.55	p
Dividend Cover	1.57
Cash Flow PS	156.23	p
Return On Equity (ROE)	38.57	%
Operating Margin	19.35	%
PEG Factor	0.35
EPS Growth Rate	89.35	%
Dividends PS Growth Rate	3.82	%
Net Debt	20,773.00	m
Gross Gearing	73.61	%
Quick Assets	5,415.00	m
Net Working Capital	4,318.00	m
Intangibles / Fixed Assets	52.53	%
Turnover PS	818.88	p
Pre-Tax Profit PS	158.45	p
Retained Profit PS	43.35	p
Cash PS	117.53	p
Net Cash PS	-187.82	p
Net Tangible Asset Value PS *	-165.33	p
Net Asset Value PS	360.46	p
Spread	1.00 (0.03%)
* 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	3,650.00	3,517.50
4 weeks	3,666.00	3,410.50
12 weeks	3,666.00	3,390.00
1 year	3,666.00	2,474.00

Share Price Chart (5 years)

Diageo Historic Returns

Period ^†	Open	Change	%	Open Avg.	Avg. Daily Vol [m]	Total Vol [m]	VWAP
1 week	3,540.00	67.50	1.91	3,517.50	2.44		3,595.68
4 weeks	3,433.50	174.00	5.07	3,410.50	2.78		3,538.92
12 weeks	3,489.50	118.00	3.38	3,390.00	2.64		3,534.23
26 weeks	3,232.50	375.00	11.60	3,167.50	2.69		3,453.35
1 year	2,671.00	936.50	35.06	2,474.00	3.11		3,155.72
3 years	2,572.00	1,035.50	40.26	2,139.00	4.08		3,011.40
5 years	2,186.00	1,421.50	65.03	1,946.00	4.12		2,781.34
† 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	43.34
PE Ratio	31.70
Tobin's Q Ratio	2.59
Tobin's Q Ratio (excl. intangibles)	3.91
Dividend Yield	2.01	%
Market-to-Book Ratio	12.23
Price-to-Pre-Tax Profit PS	22.77
Price-to-Retained Profit PS	83.21
Price-to-Cash Flow PS	23.09
Price-to-Sales PS	4.41
Price-to-Net Tangible Asset Value PS	-36.17
Price-to-Cash PS	30.69
Net Working Capital PS	184.61
Price Pct to Working Capital PS	19.54	%
Earnings Yield	3.15	%
Average PE	29.07
Years in average	5
PE to PE average	109.03	%

Diageo Financial Ratios

(Leverage Ratios)
Debt Ratio	66.02	%
Debt-to-Equity Ratio	1.94
Debt-to-Equity Ratio (excl. Intgbl)	-7.02
Debt-to-Equity Market Value	0.19
Net Gearing	65.01	%
Net Gearing (excl. Intangibles)	98.04	%
Gross Gearing	73.61	%
Gross Gearing (excl. Intangibles)	111.01	%
Gearing Under 1 Year	22.35	%
Gearing Under 1 Year (excl. Intgbl)	33.71	%
Assets/Equity	3.79
Cash/Equity	32.61
(Liquidity Ratios)
Net Working Capital to Total Assets	13.51	%
Current Ratio	1.60
Quick Ratio (Acid Test)	0.76
Liquidity Ratio	0.38
Cash & Equiv/Current Assets	23.99	%
(Solvency Ratios)
Enterprise Value	99,541.72	m
CFO/Sales	0.19
CFO/Attributable Profit	1.37
CFO/Assets	0.11
CFO/Debt	0.16
Total Debt/Equity Market Value	0.28
Total Debt/Sales	1.23
Total Debt/Pre-Tax Profit	6.35
Total Debt	23,522.00	m
Total Debt/Net Current Assets	5.45	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	-	%
5 yr Compound Earnings Growth	1.43	%
10 yr Compound Earnings Growth	3.88	%
Earn drops > 5% in 10yrs	7

Beta (60-Mnth)	Beta (36-Mnth)
0.3229	0.8228

Diageo Operating Ratios

(Profitability Ratios)
Return On Capital Employed (ROCE)	14.94	%
Return On Assets (ROA)	8.15	%
Net Profit Margin	13.89	%
Assets Turnover	0.59
Return On Equity (ROE)	38.57	%
Return On Investment (ROI)	10.31	%
Dividend Payout Ratio	63.75	%
Plowback Ratio	36.25	%
Growth from Plowback Ratio	14.11	%
Net Income Of Revenues	5.29	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	2.80
Fixed Assets Turnover	0.91
Current Assets Turnover	1.66
Net Working Capital Turnover
Inventory Turnover	3.24
(Other Operating Ratios)
Total Assets-to-Sales	1.70
Debtors-to-Sales	13.40	%
Debt Collection Period	48.90	Days

Diageo Dividends

Announcement Date	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
29 Jul 2021	Final	GBX	44.59	30/06/2020	30/06/2021	26/08/2021	27/08/2021	07/10/2021	72.55
28 Jan 2021	Interim	GBX	27.96	30/06/2020	30/06/2021	25/02/2021	26/02/2021	08/04/2021	-
04 Aug 2020	Final	GBX	42.47	30/06/2019	30/06/2020	13/08/2020	14/08/2020	08/10/2020	69.88
30 Jan 2020	Interim	GBX	27.41	30/06/2019	30/06/2020	27/02/2020	28/02/2020	09/04/2020	-
25 Jul 2019	Final	GBX	42.47	30/06/2018	30/06/2019	08/08/2019	09/08/2019	03/10/2019	68.57
31 Jan 2019	Interim	GBX	26.10	30/06/2018	30/06/2019	28/02/2019	01/03/2019	11/04/2019	-
26 Jul 2018	Final	GBX	40.40	30/06/2017	30/06/2018	09/08/2018	10/08/2018	04/10/2018	65.30
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 2018 (GBP)		30 Jun 2019 (GBP)		30 Jun 2020 (GBP)		30 Jun 2021 (GBP)
turnover	18,432.00	100.00%	19,294.00	100.00%	17,697.00	100.00%	19,153.00	100.00%	m
pre tax profit	3,740.00	20.29%	4,235.00	21.95%	2,043.00	11.54%	3,706.00	19.35%	m
attributable profit	3,144.00	17.06%	3,160.00	16.38%	1,409.00	7.96%	2,660.00	13.89%	m
retained profit	1,563.00	8.48%	1,537.00	7.97%	-237.00	-1.34%	1,014.00	5.29%	m
eps - basic (p)	121.70		130.70		60.10		113.80
eps - diluted (p)	121.10		130.10		59.90		113.40
dividends per share	65.30		68.57		69.88		72.55

Diageo Balance Sheet

	30 Jun 2018 (GBP)		30 Jun 2019 (GBP)		30 Jun 2020 (GBP)		30 Jun 2021 (GBP)


	30 Jun 2018 (GBP)		30 Jun 2019 (GBP)		30 Jun 2020 (GBP)		30 Jun 2021 (GBP)
ASSETS
fixed assets	4,089.00	13.76%	4,455.00	14.24%	4,926.00	14.79%	4,915.00	15.38%	m
intangibles	12,572.00	42.31%	12,557.00	40.12%	11,351.00	34.08%	10,764.00	33.69%	m
fixed investments	4,048.00	13.62%	4,847.00	15.49%	5,470.00	16.42%	4,814.00	15.07%	m
current assets - other	-	-%	65.00	0.21%	-	-%	-	-%	m
stocks	5,015.00	16.88%	5,472.00	17.48%	5,772.00	17.33%	6,045.00	18.92%	m
debtors	3,117.00	10.49%	2,968.00	9.48%	2,466.00	7.40%	2,666.00	8.34%	m
cash & securities	874.00	2.94%	932.00	2.98%	3,323.00	9.98%	2,749.00	8.60%	m

TOTAL	29,715.00	100%	31,296.00	100%	33,308.00	100%	31,953.00	100%	m

LIABILITIES
creditors - short	6,360.00	21.40%	7,003.00	22.38%	6,496.00	19.50%	7,142.00	22.35%	m
creditors - long	11,642.00	39.18%	14,137.00	45.17%	18,372.00	55.16%	16,380.00	51.26%	m
creditors - other	-	-%	-	-%	-	-%	-	-%	m
subordinated loans	-	-%	-	-%	-	-%	-	-%	m
insurance funds	-	-%	-	-%	-	-%	-	-%	m

TOTAL	18,002.00	60.58%	21,140.00	67.55%	24,868.00	74.66%	23,522.00	73.61%	m

EQUITY
ord cap, reserves	9,948.00	33.48%	8,361.00	26.72%	6,772.00	20.33%	6,897.00	21.58%	m
prefs, minorities	1,765.00	5.94%	1,795.00	5.74%	1,668.00	5.01%	1,534.00	4.80%	m

TOTAL	11,713.00	39.42%	10,156.00	32.45%	8,440.00	25.34%	8,431.00	26.39%	m

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

Diageo Cash Flow Statement

	30 Jun 2018 (GBP)	30 Jun 2019 (GBP)	30 Jun 2020 (GBP)	30 Jun 2021 (GBP)
Operating CF	3,084.00	3,248.00	2,320.00	3,654.00	m
Pre-Financing CF	1,933.00	2,978.00	1,515.00	2,563.00	m
Retained CF	-185.00	54.00	2,552.00	-231.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