Tesco (TSCO)

Company name:	Tesco Plc
Company Description:	The principal activity of the Group is retailing and associated activities in the UK Eire Hungary Poland the Czech Republic Slovakia Turkey Thailand South Korea Japan China and Taiwan
EPIC:	TSCO	Trading Currency:	GBX
Market Sector:	FE10	ISIN:	GB00BLGZ9862
Market Segment:	SET1	Share Type:	DE
WWW Address:	http://www.tesco.com/corporate	Description:	ORD 6 1/3P
Industry Sector:	FOOD & DRUG RETAILERS

Price	Price Change [%]	Bid	Offer	Open	High	Low	Volume
224.00	4.7 [2.14]	224.10	224.20	218.40	224.60	217.10	25,361,580
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52-Wks-Range
17,332.47	7,737.71	0.02	9.99	9.15	22.42	4.08	250.60 - 202.00

Tesco Key Figures

(at previous day's close)
Market Cap.	17,332.47	m
Shares In Issue	7,737.71	m
Prev. Close	219.30
PE Ratio	22.42
Dividend Yield	4.08	%
EPS - basic	9.99	p
Dividend PS	9.15	p
Dividend Cover	1.09
Cash Flow PS	0.49	p
Return On Equity (ROE)	7.31	%
Operating Margin	2.03	%
PEG Factor	-0.84
EPS Growth Rate	-26.81	%
Dividends PS Growth Rate	61.38	%
Net Debt	35,641.00	m
Gross Gearing	74.66	%
Quick Assets	14,019.00	m
Net Working Capital	-1,475.00	m
Intangibles / Fixed Assets	36.24	%
Turnover PS	836.94	p
Pre-Tax Profit PS	16.99	p
Retained Profit PS	4.07	p
Cash PS	44.04	p
Net Cash PS	-187.64	p
Net Tangible Asset Value PS *	3.64	p
Net Asset Value PS	171.28	p
Spread	0.10 (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.

Tesco Balance Sheet

Share Price Performance

Sample Period ^†	High	Low
1 week	229.20	217.10
4 weeks	247.90	217.10
12 weeks	250.60	217.10
1 year	250.60	202.00

Share Price Chart (5 years)

Tesco Historic Returns

Period ^†	Open	Change	%	Open Avg.	Avg. Daily Vol [m]	Total Vol [m]	VWAP
1 week	225.00	-1.00	-0.44	217.10	63.41		222.77
4 weeks	244.00	-20.00	-8.20	217.10	37.12		230.38
12 weeks	231.20	-7.20	-3.11	217.10	26.84		234.31
26 weeks	215.90	8.10	3.75	202.00	25.20		226.88
1 year	241.30	-17.30	-7.17	202.00	27.59		226.69
3 years	204.60	19.40	9.48	187.05	27.25		229.86
5 years	189.90	34.10	17.96	143.45	27.90		211.94
† periods calculated are whole weeks rather than calendar months

Tesco Key Management Ratios

Tesco Investment Ratios

(Market value analysis) at previous day's close
PQ Ratio	651.02
PE Ratio	22.42
Tobin's Q Ratio	0.34
Tobin's Q Ratio (excl. intangibles)	0.42
Dividend Yield	4.08	%
Market-to-Book Ratio	1.31
Price-to-Pre-Tax Profit PS	13.18
Price-to-Retained Profit PS	55.02
Price-to-Cash Flow PS	456.12
Price-to-Sales PS	0.27
Price-to-Net Tangible Asset Value PS	66.66
Price-to-Cash PS	5.09
Net Working Capital PS	-19.06
Price Pct to Working Capital PS	-11.75	%
Earnings Yield	4.46	%
Average PE	40.36
Years in average	4
PE to PE average	55.56	%

Tesco Financial Ratios

(Leverage Ratios)
Debt Ratio	61.45	%
Debt-to-Equity Ratio	1.59
Debt-to-Equity Ratio (excl. Intgbl)	81.24
Debt-to-Equity Market Value	1.22
Net Gearing	68.14	%
Net Gearing (excl. Intangibles)	90.67	%
Gross Gearing	74.66	%
Gross Gearing (excl. Intangibles)	99.34	%
Gearing Under 1 Year	34.28	%
Gearing Under 1 Year (excl. Intgbl)	45.61	%
Assets/Equity	3.95
Cash/Equity	25.71
(Liquidity Ratios)
Net Working Capital to Total Assets	-2.82	%
Current Ratio	0.92
Quick Ratio (Acid Test)	0.78
Liquidity Ratio	0.19
Cash & Equiv/Current Assets	20.71	%
(Solvency Ratios)
Enterprise Value	35,024.47	m
CFO/Sales	0.00
CFO/Attributable Profit	0.04
CFO/Assets	0.00
CFO/Debt	0.00
Total Debt/Equity Market Value	2.25
Total Debt/Sales	0.60
Total Debt/Pre-Tax Profit	29.70
Total Debt	39,049.00	m
Total Debt/Net Current Assets	-26.47	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	-	%
5 yr Compound Earnings Growth	42.50	%
10 yr Compound Earnings Growth	-	%
Earn drops > 5% in 10yrs	5

Beta (60-Mnth)	Beta (36-Mnth)
0.0194	0.0235

Tesco Operating Ratios

(Profitability Ratios)
Return On Capital Employed (ROCE)	3.83	%
Return On Assets (ROA)	1.92	%
Net Profit Margin	1.50	%
Assets Turnover	1.28
Return On Equity (ROE)	7.31	%
Return On Investment (ROI)	3.10	%
Dividend Payout Ratio	91.59	%
Plowback Ratio	8.41	%
Growth from Plowback Ratio	0.58	%
Net Income Of Revenues	0.49	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	4.60
Fixed Assets Turnover	2.01
Current Assets Turnover	3.52
Net Working Capital Turnover
Inventory Turnover	25.65
(Other Operating Ratios)
Total Assets-to-Sales	0.78
Debtors-to-Sales	19.34	%
Debt Collection Period	70.59	Days

Tesco Dividends

Announcement Date	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
08 Apr 2020	Final	GBX	6.50	01/03/2019	29/02/2020	21/05/2020	22/05/2020	03/07/2020	9.15
02 Oct 2019	Interim	GBX	2.65	03/03/2019	31/08/2019	10/10/2019	11/10/2019	22/11/2019	-
10 Apr 2019	Final	GBX	4.10	23/02/2018	23/02/2019	16/05/2019	17/05/2019	21/06/2019	5.67
03 Oct 2018	Interim	GBX	1.67	25/02/2018	25/08/2018	11/10/2018	12/10/2018	23/11/2018	-
11 Apr 2018	Final	GBX	2.00	24/02/2017	24/02/2018	17/05/2018	18/05/2018	22/06/2018	3.00
04 Oct 2017	Interim	GBX	1.00	26/02/2017	26/08/2017	12/10/2017	13/10/2017	24/11/2017	-
23 Oct 2014	Interim	GBX	1.16	23/02/2014	23/08/2014	30/10/2014	31/10/2014	19/12/2014	1.16
16 Apr 2014	Final	GBX	10.13	22/02/2013	22/02/2014	30/04/2014	02/05/2014	04/07/2014	14.76
02 Oct 2013	Interim	GBX	4.63	24/02/2013	24/08/2013	09/10/2013	11/10/2013	20/12/2013	-
17 Apr 2013	Final	GBX	10.13	23/02/2012	23/02/2013	24/04/2013	26/04/2013	05/07/2013	14.76
03 Oct 2012	Interim	GBX	4.63	25/02/2012	25/08/2012	10/10/2012	12/10/2012	21/12/2012	-
18 Apr 2012	Final	GBX	10.13	25/02/2011	25/02/2012	25/04/2012	27/04/2012	06/07/2012	14.76
05 Oct 2011	Interim	GBX	4.63	27/02/2011	27/08/2011	12/10/2011	14/10/2011	23/12/2011	-
19 Apr 2011	Final	GBX	10.09	26/02/2010	26/02/2011	27/04/2011	03/05/2011	08/07/2011	14.46
05 Oct 2010	Interim	GBX	4.37	28/02/2010	28/08/2010	13/10/2010	15/10/2010	24/12/2010	-
20 Apr 2010	Final	GBX	9.16	27/02/2009	27/02/2010	28/04/2010	30/04/2010	09/07/2010	13.05
09 Oct 2009	Interim	GBX	3.89	01/03/2009	29/08/2009	14/10/2009	16/10/2009	24/12/2009	-
21 Apr 2009	Final	GBX	8.39	28/02/2008	28/02/2009	29/04/2009	01/05/2009	10/07/2009	11.96
30 Sep 2008	Interim	GBX	3.57	23/02/2008	23/08/2008	08/10/2008	10/10/2008	19/12/2008	-
15 Apr 2008	Final	GBX	7.70	23/02/2007	23/02/2008	23/04/2008	25/04/2008	04/07/2008	10.90
02 Oct 2007	Interim	GBX	3.20	25/02/2007	25/08/2007	10/10/2007	12/10/2007	21/12/2007	-
17 Apr 2007	Final	GBX	6.83	24/02/2006	24/02/2007	25/04/2007	27/04/2007	06/07/2007	9.64
03 Oct 2006	Interim	GBX	2.81	26/02/2006	26/08/2006	11/10/2006	13/10/2006	22/12/2006	-
25 Apr 2006	Final	GBX	6.10	25/02/2005	25/02/2006	03/05/2006	05/05/2006	14/07/2006	8.63
20 Sep 2005	Interim	GBX	2.53	13/02/2005	13/08/2005	28/09/2005	30/09/2005	09/12/2005	-
12 Apr 2005	Final	GBX	5.27	26/02/2004	26/02/2005	20/04/2005	22/04/2005	01/07/2005	7.56
21 Sep 2004	Interim	GBX	2.29	14/02/2004	14/08/2004	29/09/2004	01/10/2004	26/11/2004	-
20 Apr 2004	Final	GBX	4.77	28/02/2003	28/02/2004	28/04/2004	30/04/2004	25/06/2004	6.84
16 Sep 2003	Interim	GBX	2.07	09/02/2003	09/08/2003	24/09/2003	26/09/2003	28/11/2003	-
08 Apr 2003	Final	GBX	4.33	22/02/2002	22/02/2003	20/04/2003	22/04/2003	27/06/2003	6.20
17 Sep 2002	Interim	GBX	1.87	11/02/2002	11/08/2002	25/09/2002	27/09/2002	29/11/2002	-
10 Apr 2002	Final	GBX	3.93	23/02/2001	23/02/2002	17/04/2002	19/04/2002	28/06/2002	5.60
18 Sep 2001	Interim	GBX	1.67	11/08/2000	11/08/2001	26/09/2001	28/09/2001	30/11/2001	-
10 Apr 2001	Final	GBX	3.50	24/02/2000	24/02/2001	18/04/2001	20/04/2001	29/06/2001	4.98
19 Sep 2000	Interim	GBX	1.48	12/08/1999	12/08/2000	25/09/2000	29/09/2000	01/12/2000	-
11 Apr 2000	Final	GBX	3.14	26/02/1999	26/02/2000	17/04/2000	25/04/2000	30/06/2000	4.48
21 Sep 1999	Interim	GBX	1.34	14/08/1998	14/08/1999	27/09/1999	01/10/1999	01/12/1999	-
13 Apr 1999	Final	GBX	2.87	26/02/1998	26/02/1999	19/04/1999	23/04/1999	01/07/1999	4.12
22 Sep 1998	Interim	GBX	1.25	15/08/1997	15/08/1998	28/09/1998	02/10/1998	30/11/1998	-
21 Apr 1998	Final	GBX	2.68	28/02/1997	28/02/1998	27/04/1998	01/05/1998	01/07/1998	3.87

Tesco Fundamentals

	25 Feb 2017 (GBP)		24 Feb 2018 (GBP)		23 Feb 2019 (GBP)		29 Feb 2020 (GBP)
turnover	55,917.00	100.00%	57,491.00	100.00%	63,911.00	100.00%	64,760.00	100.00%	m
pre tax profit	145.00	0.26%	1,298.00	2.26%	1,674.00	2.62%	1,315.00	2.03%	m
attributable profit	-40.00	-0.07%	1,206.00	2.10%	1,322.00	2.07%	971.00	1.50%	m
retained profit	-40.00	-0.07%	1,124.00	1.96%	965.00	1.51%	315.00	0.49%	m
eps - basic (p)	-0.49		14.77		13.65		9.99
eps - diluted (p)	-0.49		14.72		13.55		9.93
dividends per share	-		3.00		5.67		9.15

Tesco Balance Sheet

	25 Feb 2017 (GBP)		24 Feb 2018 (GBP)		23 Feb 2019 (GBP)		29 Feb 2020 (GBP)


	25 Feb 2017 (GBP)		24 Feb 2018 (GBP)		23 Feb 2019 (GBP)		29 Feb 2020 (GBP)
ASSETS
fixed assets	18,108.00	39.49%	18,521.00	41.28%	19,023.00	38.79%	19,234.00	36.77%	m
intangibles	2,717.00	5.93%	2,661.00	5.93%	6,264.00	12.77%	12,993.00	24.84%	m
fixed investments	6,226.00	13.58%	3,890.00	8.67%	3,406.00	6.94%	3,623.00	6.93%	m
current assets - other	344.00	0.75%	149.00	0.33%	98.00	0.20%	285.00	0.54%	m
stocks	2,301.00	5.02%	2,263.00	5.04%	2,617.00	5.34%	2,433.00	4.65%	m
debtors	12,336.00	26.90%	13,319.00	29.69%	14,723.00	30.02%	10,326.00	19.74%	m
cash & securities	3,821.00	8.33%	4,059.00	9.05%	2,916.00	5.95%	3,408.00	6.52%	m

TOTAL	45,853.00	100%	44,862.00	100%	49,047.00	100%	52,302.00	100%	m

LIABILITIES
creditors - short	19,234.00	41.95%	19,238.00	42.88%	20,680.00	42.16%	17,927.00	34.28%	m
creditors - long	20,034.00	43.69%	15,166.00	33.81%	13,533.00	27.59%	21,122.00	40.38%	m
creditors - other	171.00	0.37%	-	-%	-	-%	-	-%	m
subordinated loans	-	-%	-	-%	-	-%	-	-%	m
insurance funds	-	-%	-	-%	-	-%	-	-%	m

TOTAL	39,439.00	86.01%	34,404.00	76.69%	34,213.00	69.76%	39,049.00	74.66%	m

EQUITY
ord cap, reserves	6,438.00	14.04%	10,480.00	23.36%	14,858.00	30.29%	13,275.00	25.38%	m
prefs, minorities	-24.00	-0.05%	-22.00	-0.05%	-24.00	-0.05%	-22.00	-0.04%	m

TOTAL	6,414.00	13.99%	10,458.00	23.31%	14,834.00	30.24%	13,253.00	25.34%	m

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

Tesco Cash Flow Statement

	25 Feb 2017 (GBP)	24 Feb 2018 (GBP)	23 Feb 2019 (GBP)	29 Feb 2020 (GBP)
Operating CF	1,989.00	2,782.00	1,966.00	38.00	m
Pre-Financing CF	2,268.00	3,448.00	823.00	2,446.00	m
Retained CF	881.00	212.00	-1,158.00	534.00	m

Tesco 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