|
Back
to main menu
|
5 |
Tesco Financials and Ratios |
|
|
|
|
|
Tesco’s financial ratios have been remarkably robust over
the last five years. The profitability ratios have been very consistent
reflecting the retailer’s ability to pass back benefits to
the consumer and thereby increase sales (a virtuous circle unlike
Marks and Spencer which tried to increase its margins dramatically
in the 1990s but quality and service both suffered).
The cash conversion cycle (explained in the Guide to Financial
Statements) has varied between –11 and –14 days. In
other words, the faster the company grows, the more cash it generates
from its working capital cycle. However despite this source of cash
to the business, the huge capital expenditure programme of the last
few years led to an increase in gearing between 2000 and 2003. This
reduced in 2004 as a result of the £810 million placement
of shares. The company also raised cash through an innovative property
deal at the beginning of 2004.
It is interesting to note the steady decline in the asset turnover
ratio (sales generated from total assets) until 2003. The key to
Tesco’s future success is perhaps best summed up by Lex in
the FT in September 2004: “Investment is good if it makes
decent returns. Historically UK food retailing has proved excessively
capital intensive and generated poor returns. The problem with UK
supermarkets is their habit of spending profits on UK supermarkets,
not shareholders. Tesco, in spite of its recent dazzle, now risks
falling into an old trap.”
A spreadsheet for Tesco is also shown below. |
|
|
|
Feb 00 |
Feb 02 |
Feb 02 |
Feb 03 |
Feb 04 |
LIQUIDITY |
|
|
|
|
|
Current Ratio |
0.38 |
0.38 |
0.43 |
0.45 |
0.56 |
Acid Test |
0.20 |
0.20 |
0.24 |
0.24 |
0.35 |
|
|
|
|
|
|
ASSET MANAGEMENT |
|
|
|
|
|
Asset Turnover |
1.92 |
1.79 |
1.74 |
1.58 |
1.66 |
Trade Debtor Days |
2 |
2 |
2 |
2 |
2 |
Stock Days |
13 |
14 |
15 |
17 |
15 |
Trade Creditor Days |
26 |
29 |
30 |
33 |
31 |
Cash Conversion Cycle |
-11 |
-13 |
-13 |
-14 |
-14 |
|
|
|
|
|
|
PROFITABILITY |
|
|
|
|
|
Gross Margin / Sales % |
7.6 |
7.6 |
7.6 |
7.7 |
7.8 |
Operating Profit / Sales % |
5.5 |
5.6 |
5.6 |
5.7 |
5.6 |
Profit after Tax/Equity (ROE) % |
14.0 |
14.4 |
14.9 |
14.5 |
13.8 |
PBIT/Assets (ROA) % |
10.5 |
10.0 |
10.0 |
9.3 |
9.8 |
|
|
|
|
|
|
RISK |
|
|
|
|
|
Total Debt/Net Worth (Gearing) |
50.1 |
66.6 |
76.0 |
81.9 |
65.0 |
Interest Cover |
4.9x |
4.9x |
4.8x |
5.0x |
5.4x |
|
|
|
|
|
|
|
Feb 01 |
Feb 02 |
Feb 03 |
Feb 04 |
BALANCE SHEET |
£millions |
£millions |
£millions |
£millions |
|
|
|
|
|
CAPITAL/ LIABILITIES |
|
|
|
|
Capital |
|
|
|
|
Share Capital |
347 |
350 |
362 |
384 |
Share premium |
1,870 |
2,004 |
2,465 |
3,470 |
Revaluation resesrves |
|
|
|
|
Retained profits |
2,721 |
3,136 |
3,649 |
4,051 |
Other researves |
40 |
40 |
40 |
40 |
Minority Interests |
36 |
36 |
43 |
45 |
Total shareholders' funds |
5,014 |
5,566 |
6,559 |
7,990 |
|
|
|
|
|
Term liabilities |
|
|
|
|
Term debt |
1,908 |
2,727 |
3,863 |
4,180 |
Finance leases |
17 |
14 |
171 |
166 |
Other non-current creditors |
2 |
|
15 |
22 |
Deferred tax |
402 |
440 |
505 |
572 |
Other provisions |
|
|
16 |
14 |
Total long-term liabilities |
2,329 |
3,181 |
4,570 |
4,954 |
|
|
|
|
|
Current Liabilities |
|
|
|
|
Trade Creditors |
1,538 |
1,830 |
2,196 |
2,434 |
Bank loans & o/d |
1,389 |
1,474 |
1,286 |
775 |
Corporation tax |
292 |
259 |
230 |
308 |
Misc. taxes payable |
114 |
52 |
170 |
190 |
Proposed dividend |
246 |
283 |
319 |
370 |
HP creditors/finance leases |
24 |
15 |
55 |
69 |
Other creditors |
627 |
732 |
853 |
1,152 |
Accruals & deferred income |
159 |
164 |
263 |
320 |
Total current liabilities |
4,389 |
4,809 |
5,372 |
5,618 |
|
|
|
|
|
|
|
|
|
|
TOTAL CAPITAL & LIABILITIES |
11,732 |
13,556 |
16.501 |
18,562 |
|
|
|
|
|
|
|
|
|
Feb 01 |
Feb 02 |
Feb 03 |
Feb 04 |
BALANCE SHEET |
£millions |
£millions |
£millions |
£millions |
|
|
|
|
|
ASSETS |
|
|
|
|
Tangible Assets |
|
|
|
|
Land / Buildings |
9,471 |
10,849 |
12,493 |
13,718 |
Plant / Equipment |
3,212 |
3,661 |
4,132 |
4,479 |
Fixtures/fittings/vehicles |
|
|
|
|
Other tangible assets |
|
|
|
|
Less acc. depreciation |
-3,103 |
-3,478 |
-3,797 |
-4,103 |
Total tangible fixed assets |
9,580 |
11,032 |
12,828 |
14,094 |
|
|
|
|
|
Investments |
|
|
|
|
Investments |
101 |
69 |
59 |
34 |
Subsidiaries/associates |
|
16 |
18 |
21 |
Joint ventures |
203 |
232 |
266 |
309 |
Total investments |
304 |
317 |
343 |
364 |
|
|
|
|
|
Other non-current assets |
|
|
|
|
Debtors due >1 year |
|
|
|
|
Goodwill |
154 |
154 |
890 |
965 |
Total other non-current assets |
154 |
154 |
890 |
965 |
TOTAL FIXED ASSETS |
10,038 |
11,503 |
14,061 |
15,423 |
|
|
|
|
|
Current Assets |
|
|
|
|
Stocks/Work in progress |
814 |
908 |
1,122 |
1,196 |
Investments |
255 |
225 |
239 |
430 |
Other Debotrs |
261 |
339 |
507 |
671 |
Cash/bank balance |
279 |
445 |
399 |
670 |
Prepayments |
18 |
47 |
48 |
49 |
Due from Associates |
43 |
68 |
107 |
120 |
Development Property |
24 |
21 |
18 |
3 |
Total current assets |
1,694 |
2,053 |
2,440 |
3,139 |
TOTAL ASSETS |
11,732 |
13,556 |
16,501 |
18,562 |
|
|
|
|
|
Back
to main menu
|
|
|