Ian McIsaac

Financial Training and Consultancy

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


    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

 

 

 

 

 

 

 

 

 

-