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:	FS10	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
248.30	0.8 [0.32]	248.20	248.40	247.90	250.50	247.50	3,701,424
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52-Wks-Range
19,079.94	7,684.23	0.04	19.34	10.90	12.84	4.39	302.55 - 194.35

Tesco Key Figures

(at previous day's close)
Market Cap.	19,079.94	m
Shares In Issue	7,684.23	m
Prev. Close	247.50
PE Ratio	12.84
Dividend Yield	4.39	%
EPS - basic	19.34	p
Dividend PS	10.90	p
Dividend Cover	1.77
Cash Flow PS	48.89	p
Return On Equity (ROE)	9.46	%
Operating Margin	3.31	%
PEG Factor	-0.18
EPS Growth Rate	-69.69	%
Dividends PS Growth Rate	19.13	%
Net Debt	31,362.00	m
Gross Gearing	68.30	%
Quick Assets	10,803.00	m
Net Working Capital	-2,983.00	m
Intangibles / Fixed Assets	14.80	%
Turnover PS	798.31	p
Pre-Tax Profit PS	26.46	p
Retained Profit PS	9.76	p
Cash PS	30.52	p
Net Cash PS	-179.33	p
Net Tangible Asset Value PS *	134.04	p
Net Asset Value PS	203.59	p
Spread	0.20 (0.08%)
* 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	250.50	243.40
4 weeks	251.30	237.60
12 weeks	251.30	220.00
1 year	302.55	194.35

Share Price Chart (5 years)

Tesco Historic Returns

Period ^†	Open	Change	%	Open Avg.	Avg. Daily Vol [m]	Total Vol [m]	VWAP
1 week	244.50	3.80	1.55	243.40	24.50		246.71
4 weeks	238.00	10.30	4.33	237.60	22.86		246.07
12 weeks	227.60	20.70	9.09	220.00	22.11		234.50
26 weeks	264.60	-16.30	-6.16	194.35	20.81		230.76
1 year	302.50	-54.20	-17.92	194.35	22.32		250.35
3 years	247.40	0.90	0.36	194.35	23.12		240.78
5 years	205.70	42.60	20.71	187.05	24.81		235.72
† 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	4.51
PE Ratio	12.84
Tobin's Q Ratio	0.40
Tobin's Q Ratio (excl. intangibles)	0.49
Dividend Yield	4.39	%
Market-to-Book Ratio	1.22
Price-to-Pre-Tax Profit PS	9.39
Price-to-Retained Profit PS	25.44
Price-to-Cash Flow PS	5.08
Price-to-Sales PS	0.31
Price-to-Net Tangible Asset Value PS	1.86
Price-to-Cash PS	8.14
Net Working Capital PS	-38.82
Price Pct to Working Capital PS	-6.40	%
Earnings Yield	7.79	%
Average PE	14.29
Years in average	5
PE to PE average	89.85	%

Tesco Financial Ratios

(Leverage Ratios)
Debt Ratio	52.92	%
Debt-to-Equity Ratio	1.12
Debt-to-Equity Ratio (excl. Intgbl)	1.71
Debt-to-Equity Market Value	0.92
Net Gearing	63.55	%
Net Gearing (excl. Intangibles)	71.29	%
Gross Gearing	68.30	%
Gross Gearing (excl. Intangibles)	76.62	%
Gearing Under 1 Year	32.67	%
Gearing Under 1 Year (excl. Intgbl)	36.66	%
Assets/Equity	3.15
Cash/Equity	14.99
(Liquidity Ratios)
Net Working Capital to Total Assets	-6.04	%
Current Ratio	0.82
Quick Ratio (Acid Test)	0.67
Liquidity Ratio	0.15
Cash & Equiv/Current Assets	17.84	%
(Solvency Ratios)
Enterprise Value	34,300.94	m
CFO/Sales	0.06
CFO/Attributable Profit	2.54
CFO/Assets	0.08
CFO/Debt	0.11
Total Debt/Equity Market Value	1.77
Total Debt/Sales	0.55
Total Debt/Pre-Tax Profit	16.58
Total Debt	33,707.00	m
Total Debt/Net Current Assets	-11.30	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	24.63	%
5 yr Compound Earnings Growth	5.54	%
10 yr Compound Earnings Growth	28.79	%
Earn drops > 5% in 10yrs	6

Beta (60-Mnth)	Beta (36-Mnth)
0.0406	0.0438

Tesco Operating Ratios

(Profitability Ratios)
Return On Capital Employed (ROCE)	6.12	%
Return On Assets (ROA)	3.11	%
Net Profit Margin	2.41	%
Assets Turnover	1.29
Return On Equity (ROE)	9.46	%
Return On Investment (ROI)	4.68	%
Dividend Payout Ratio	56.36	%
Plowback Ratio	43.64	%
Growth from Plowback Ratio	4.62	%
Net Income Of Revenues	1.22	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	4.38
Fixed Assets Turnover	1.82
Current Assets Turnover	4.42
Net Working Capital Turnover
Inventory Turnover	27.83
(Other Operating Ratios)
Total Assets-to-Sales	0.78
Debtors-to-Sales	13.46	%
Debt Collection Period	49.14	Days

Tesco Dividends

Announcement Date	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
13 Apr 2022	Final	GBX	7.70	26/02/2021	26/02/2022	19/05/2022	20/05/2022	24/06/2022	10.90
06 Oct 2021	Interim	GBX	3.20	28/02/2021	28/08/2021	14/10/2021	15/10/2021	26/11/2021	-
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

	23 Feb 2019 (GBP)		29 Feb 2020 (GBP)		27 Feb 2021 (GBP)		26 Feb 2022 (GBP)
turnover	63,911.00	100.00%	64,760.00	100.00%	57,887.00	100.00%	61,344.00	100.00%	m
pre tax profit	1,674.00	2.62%	1,315.00	2.03%	825.00	1.43%	2,033.00	3.31%	m
attributable profit	1,322.00	2.07%	971.00	1.50%	6,143.00	10.61%	1,481.00	2.41%	m
retained profit	965.00	1.51%	315.00	0.49%	285.00	0.49%	750.00	1.22%	m
eps - basic (p)	13.65		9.99		63.80		19.34
eps - diluted (p)	13.55		9.93		63.62		19.64
dividends per share	5.67		9.15		9.15		10.90

Tesco Balance Sheet

	23 Feb 2019 (GBP)		29 Feb 2020 (GBP)		27 Feb 2021 (GBP)		26 Feb 2022 (GBP)


	23 Feb 2019 (GBP)		29 Feb 2020 (GBP)		27 Feb 2021 (GBP)		26 Feb 2022 (GBP)
ASSETS
fixed assets	19,023.00	38.79%	19,234.00	36.77%	17,211.00	37.60%	22,780.00	46.16%	m
intangibles	6,264.00	12.77%	12,993.00	24.84%	11,344.00	24.78%	5,360.00	10.86%	m
fixed investments	3,406.00	6.94%	3,623.00	6.93%	2,600.00	5.68%	8,069.00	16.35%	m
current assets - other	98.00	0.20%	285.00	0.54%	1,616.00	3.53%	368.00	0.75%	m
stocks	2,617.00	5.34%	2,433.00	4.65%	2,069.00	4.52%	2,339.00	4.74%	m
debtors	14,723.00	30.02%	10,326.00	19.74%	8,428.00	18.41%	8,090.00	16.39%	m
cash & securities	2,916.00	5.95%	3,408.00	6.52%	2,510.00	5.48%	2,345.00	4.75%	m

TOTAL	49,047.00	100%	52,302.00	100%	45,778.00	100%	49,351.00	100%	m

LIABILITIES
creditors - short	20,680.00	42.16%	17,927.00	34.28%	15,721.00	34.34%	16,125.00	32.67%	m
creditors - long	13,533.00	27.59%	21,122.00	40.38%	17,456.00	38.13%	17,568.00	35.60%	m
creditors - other	-	-%	-	-%	276.00	0.60%	14.00	0.03%	m
subordinated loans	-	-%	-	-%	-	-%	-	-%	m
insurance funds	-	-%	-	-%	-	-%	-	-%	m

TOTAL	34,213.00	69.76%	39,049.00	74.66%	33,453.00	73.08%	33,707.00	68.30%	m

EQUITY
ord cap, reserves	14,858.00	30.29%	13,275.00	25.38%	12,343.00	26.96%	15,660.00	31.73%	m
prefs, minorities	-24.00	-0.05%	-22.00	-0.04%	-18.00	-0.04%	-16.00	-0.03%	m

TOTAL	14,834.00	30.24%	13,253.00	25.34%	12,325.00	26.92%	15,644.00	31.70%	m

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

Tesco Cash Flow Statement

	23 Feb 2019 (GBP)	29 Feb 2020 (GBP)	27 Feb 2021 (GBP)	26 Feb 2022 (GBP)
Operating CF	1,966.00	38.00	602.00	3,757.00	m
Pre-Financing CF	823.00	2,446.00	6,773.00	2,022.00	m
Retained CF	-1,158.00	534.00	-1,068.00	-212.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