Tesco (TSCO)

[ADVERT]

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
233.60	0.6 [0.26]	233.55	233.70	234.00	234.30	231.75	5,570,749
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52-Wks-Range
18,075.29	7,737.71	0.01	63.80	9.15	3.66	3.92	250.60 - 202.00

Tesco Key Figures

(at previous day's close)
Market Cap.	18,075.29	m
Shares In Issue	7,737.71	m
Prev. Close	233.00
PE Ratio	3.66
Dividend Yield	3.92	%
EPS - basic	63.80	p
Dividend PS	9.15	p
Dividend Cover	6.97
Cash Flow PS	7.78	p
Return On Equity (ROE)	49.77	%
Operating Margin	1.43	%
PEG Factor	0.01
EPS Growth Rate	538.64	%
Dividends PS Growth Rate	-	%
Net Debt	30,943.00	m
Gross Gearing	73.08	%
Quick Assets	12,554.00	m
Net Working Capital	-1,098.00	m
Intangibles / Fixed Assets	36.41	%
Turnover PS	748.12	p
Pre-Tax Profit PS	10.66	p
Retained Profit PS	3.68	p
Cash PS	32.44	p
Net Cash PS	-170.74	p
Net Tangible Asset Value PS *	12.91	p
Net Asset Value PS	159.28	p
Spread	0.15 (0.06%)
* 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	235.15	230.55
4 weeks	240.85	225.10
12 weeks	240.85	221.70
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	233.15	0.45	0.19	230.55	17.18		233.23
4 weeks	225.15	8.45	3.75	225.10	18.50		233.86
12 weeks	227.80	5.80	2.55	221.70	20.29		228.96
26 weeks	243.70	-10.10	-4.14	217.10	23.30		228.92
1 year	217.20	16.40	7.55	202.00	22.66		226.96
3 years	257.90	-24.30	-9.42	187.05	25.73		228.64
5 years	154.70	78.90	51.00	153.05	27.31		216.33
† 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	41.98
PE Ratio	3.66
Tobin's Q Ratio	0.37
Tobin's Q Ratio (excl. intangibles)	0.49
Dividend Yield	3.92	%
Market-to-Book Ratio	1.46
Price-to-Pre-Tax Profit PS	21.91
Price-to-Retained Profit PS	63.42
Price-to-Cash Flow PS	30.03
Price-to-Sales PS	0.31
Price-to-Net Tangible Asset Value PS	18.43
Price-to-Cash PS	7.20
Net Working Capital PS	-14.19
Price Pct to Working Capital PS	-16.46	%
Earnings Yield	27.31	%
Average PE	14.16
Years in average	4
PE to PE average	25.86	%

Tesco Financial Ratios

(Leverage Ratios)
Debt Ratio	58.99	%
Debt-to-Equity Ratio	1.44
Debt-to-Equity Ratio (excl. Intgbl)	18.08
Debt-to-Equity Market Value	0.98
Net Gearing	67.59	%
Net Gearing (excl. Intangibles)	89.86	%
Gross Gearing	73.08	%
Gross Gearing (excl. Intangibles)	97.15	%
Gearing Under 1 Year	34.34	%
Gearing Under 1 Year (excl. Intgbl)	45.66	%
Assets/Equity	3.71
Cash/Equity	20.37
(Liquidity Ratios)
Net Working Capital to Total Assets	-2.40	%
Current Ratio	0.93
Quick Ratio (Acid Test)	0.80
Liquidity Ratio	0.16
Cash & Equiv/Current Assets	17.16	%
(Solvency Ratios)
Enterprise Value	33,279.29	m
CFO/Sales	0.01
CFO/Attributable Profit	0.10
CFO/Assets	0.01
CFO/Debt	0.02
Total Debt/Equity Market Value	1.85
Total Debt/Sales	0.58
Total Debt/Pre-Tax Profit	40.55
Total Debt	33,453.00	m
Total Debt/Net Current Assets	-30.47	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	67.20	%
5 yr Compound Earnings Growth	-	%
10 yr Compound Earnings Growth	6.22	%
Earn drops > 5% in 10yrs	5

Beta (60-Mnth)	Beta (36-Mnth)
0.0061	0.0187

Tesco Operating Ratios

(Profitability Ratios)
Return On Capital Employed (ROCE)	2.74	%
Return On Assets (ROA)	12.53	%
Net Profit Margin	10.61	%
Assets Turnover	1.18
Return On Equity (ROE)	49.77	%
Return On Investment (ROI)	19.07	%
Dividend Payout Ratio	14.34	%
Plowback Ratio	85.66	%
Growth from Plowback Ratio	41.08	%
Net Income Of Revenues	0.49	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	4.52
Fixed Assets Turnover	1.73
Current Assets Turnover	3.73
Net Working Capital Turnover
Inventory Turnover	25.72
(Other Operating Ratios)
Total Assets-to-Sales	0.85
Debtors-to-Sales	16.20	%
Debt Collection Period	59.13	Days

Tesco Dividends

Announcement Date	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
14 Apr 2021	Final	GBX	5.95	27/02/2020	27/02/2021	20/05/2021	21/05/2021	02/07/2021	9.15
07 Oct 2020	Interim	GBX	3.20	29/02/2020	29/08/2020	15/10/2020	16/10/2020	27/11/2020	-
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

	24 Feb 2018 (GBP)		23 Feb 2019 (GBP)		29 Feb 2020 (GBP)		27 Feb 2021 (GBP)
turnover	57,491.00	100.00%	63,911.00	100.00%	64,760.00	100.00%	57,887.00	100.00%	m
pre tax profit	1,298.00	2.26%	1,674.00	2.62%	1,315.00	2.03%	825.00	1.43%	m
attributable profit	1,206.00	2.10%	1,322.00	2.07%	971.00	1.50%	6,143.00	10.61%	m
retained profit	1,124.00	1.96%	965.00	1.51%	315.00	0.49%	285.00	0.49%	m
eps - basic (p)	14.77		13.65		9.99		63.80
eps - diluted (p)	14.72		13.55		9.93		63.62
dividends per share	3.00		5.67		9.15		9.15

Tesco Balance Sheet

	24 Feb 2018 (GBP)		23 Feb 2019 (GBP)		29 Feb 2020 (GBP)		27 Feb 2021 (GBP)


	24 Feb 2018 (GBP)		23 Feb 2019 (GBP)		29 Feb 2020 (GBP)		27 Feb 2021 (GBP)
ASSETS
fixed assets	18,521.00	41.28%	19,023.00	38.79%	19,234.00	36.77%	17,211.00	37.60%	m
intangibles	2,661.00	5.93%	6,264.00	12.77%	12,993.00	24.84%	11,344.00	24.78%	m
fixed investments	3,890.00	8.67%	3,406.00	6.94%	3,623.00	6.93%	2,600.00	5.68%	m
current assets - other	149.00	0.33%	98.00	0.20%	285.00	0.54%	1,616.00	3.53%	m
stocks	2,263.00	5.04%	2,617.00	5.34%	2,433.00	4.65%	2,069.00	4.52%	m
debtors	13,319.00	29.69%	14,723.00	30.02%	10,326.00	19.74%	8,428.00	18.41%	m
cash & securities	4,059.00	9.05%	2,916.00	5.95%	3,408.00	6.52%	2,510.00	5.48%	m

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

LIABILITIES
creditors - short	19,238.00	42.88%	20,680.00	42.16%	17,927.00	34.28%	15,721.00	34.34%	m
creditors - long	15,166.00	33.81%	13,533.00	27.59%	21,122.00	40.38%	17,456.00	38.13%	m
creditors - other	-	-%	-	-%	-	-%	276.00	0.60%	m
subordinated loans	-	-%	-	-%	-	-%	-	-%	m
insurance funds	-	-%	-	-%	-	-%	-	-%	m

TOTAL	34,404.00	76.69%	34,213.00	69.76%	39,049.00	74.66%	33,453.00	73.08%	m

EQUITY
ord cap, reserves	10,480.00	23.36%	14,858.00	30.29%	13,275.00	25.38%	12,343.00	26.96%	m
prefs, minorities	-22.00	-0.05%	-24.00	-0.05%	-22.00	-0.04%	-18.00	-0.04%	m

TOTAL	10,458.00	23.31%	14,834.00	30.24%	13,253.00	25.34%	12,325.00	26.92%	m

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

Tesco Cash Flow Statement

	24 Feb 2018 (GBP)	23 Feb 2019 (GBP)	29 Feb 2020 (GBP)	27 Feb 2021 (GBP)
Operating CF	2,782.00	1,966.00	38.00	602.00	m
Pre-Financing CF	3,448.00	823.00	2,446.00	6,773.00	m
Retained CF	212.00	-1,158.00	534.00	-1,068.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