Slide 1: 2017 Full-year Results Supplementary Information
2017 Full-year Results Supplementary Information Thursday, 17 August 2017 (to be read in conjunction with the 2017 Full-year Results Briefing Presentation)
Slide 2: Presentation outline
Presentation outline Item Page Group Balance Sheet & Cash Flow 3 Coles 6 Home Improvement 10 Department Stores 14 - Target 15 - Kmart 19 Officeworks 23 Industrials 26 2017 Full-year results | 2
Slide 3: Group Balance Sheet & Cash Flow
Group Balance Sheet & Cash Flow Terry Bowen Finance Director, Wesfarmers Limited
Slide 4: Group management balance sheet – overview
Group management balance sheet – overview Year ended 30 June ($m)1 2017 2016 Commentary Inventories 6,530 6,260 Receivables & prepayments 1,936 1,950 Detailed working capital discussion Trade & other payables (6,616) (6,492) provided on slide 5 Other 410 411 Net working capital 2,260 2,129 Decrease
Slide 5: Balance sheet – working capital
Balance sheet – working capital Year ended 30 June ($m)1 2017 2016 Commentary • Retail network growth & investment in stock depth, partly offset by lower inventory in Target Inventories 6,530 6,260 • Higher fertiliser inventory in WesCEF Receivables & prepayments 1,936 1,950 • Increase due to retail
Slide 6: Coles
Coles John Durkan Managing Director, Coles
Slide 7: Coles network as at 30 June 2017
Coles network as at 30 June 2017 Selling Area Supermarkets (sqm) 1,835,743 7 8 11 Liquor (sqm) – ex hotels 211,373 166 237 77 95 114 4 83 138 801 Supermarkets 56 34 7 46 883 Liquor stores 254 279 1 89 Hotels 214 195 702 Convenience 207 211 16 15 2017 Full-year results | 7
Slide 8: Store network movements
Store network movements Open at Open at 30 June Opened Closed Re-branded 30 June 2016 2017 Supermarkets Coles 786 21 (8) 1 800 Bi-Lo 1 - - - 1 Total Supermarkets 787 21 (8) 1 801 Liquor First Choice 97 3 (1) - 99 Vintage Cellars 81 1 - - 82 Liquorland 687 25 (10) - 702 Hotels 89 - - - 89 Total Liquo
Slide 9: Revenue reconciliation
Revenue reconciliation Year ended 30 June ($m) 2017 2016 Food & Food & Convenience Total Convenience Total Liquor Liquor Segment revenue 33,084 6,133 39,217 32,564 6,678 39,242 (Gregorian)1 Less: Other revenue (374) (12) (386) (415) (13) (428) Headline sales 32,710 6,121 38,831 32,149 6,665 38,814 (
Slide 10: Home Improvement
Home Improvement Michael Schneider Managing Director, Bunnings Group Managing Director, Bunnings Australia & New Zealand
Slide 11: Bunnings Australia & NZ: store network locations
Bunnings Australia & NZ: store network locations Bunnings Bunnings Bunnings Trade Warehouse smaller formats Centres Victoria 57 13 5 South Australia/NT 16 4 2 Tasmania 6 - 1 New South Wales/ACT 72 17 7 Queensland 42 13 7 Western Australia 29 10 4 New Zealand 27 20 7 2017 Full-year results | 11
Slide 12: Bunnings UK & Ireland: store network locations
Bunnings UK & Ireland: store network locations Homebase Bunnings1 Republic of Ireland 11 Northern Ireland 9 Scotland 21 North England 35 Midlands 37 East England 30 3 London 29 South England 68 1 Wales 11 1. Bunnings Warehouses in Hertfordshire (St Albans x 2, Hemel Hempstead) within “East of Englan
Slide 13: Home Improvement: store network locations
Home Improvement: store network locations Open at Open at Under 30 June Opened Closed 30 June Expanded construction 2016 2017 30 June 2017 Australia & New Zealand Bunnings Warehouse 244 9 (4) 249 - 10 Bunnings smaller formats 70 8 (1) 77 1 3 Bunnings Trade Centres 33 1 (1) 33 - - UK & Ireland Bunnin
Slide 14: Department Stores
Department Stores Guy Russo Chief Executive Officer, Department Stores Managing Director, Target
Slide 15: Target
Target Guy Russo Chief Executive Officer, Department Stores Managing Director, Target
Slide 16: Target network
Target network 2 1 184 Large 119 Small 33 29 21 12 18 10 57 41 48 25 5 1 2017 Full-year results | 16
Slide 17: Store network movements
Store network movements Open at Open at Opened Closed 30 June 2016 30 June 2017 Large 186 1 (3)1 184 Small 120 - (1) 119 Total 306 1 (4)1 303 1. Includes two Target stores converted to Kmart during the period. 2017 Full-year results | 17
Slide 18: Revenue reconciliation
Revenue reconciliation Year ended 30 June ($m) 2017 2016 Var % Segment revenue (Gregorian) 2,950 3,456 (14.6) Less: Non sales revenue (4) (1) Headline sales (Gregorian) 2,946 3,455 (14.7) Less: Gregorian adjustment1 (5) (16) Headline sales revenue (Retail)2 2,941 3,439 (14.5) 1. Adjustment to headli
Slide 19: Kmart
Kmart Ian Bailey Managing Director, Kmart
Slide 20: Kmart network
Kmart network 3 4 220 Kmart stores 251 KTAS centres 45 55 25 25 15 17 57 77 50 69 16 5 4 4 2017 Full-year results | 20
Slide 21: Store network movements
Store network movements Open at Open at Opened Closed 30 June 2016 30 June 2017 Kmart 209 111 - 220 Kmart Tyre & Auto 248 7 (4) 251 1. Includes two Target stores converted to Kmart during the period. 2017 Full-year results | 21
Slide 22: Revenue reconciliation
Revenue reconciliation Year ended 30 June ($m) 2017 2016 Var % Segment revenue (Gregorian) 5,578 5,190 7.5 Less: Non sales revenue (1) (2) Headline sales (Gregorian) 5,577 5,188 7.5 Add: Gregorian adjustment1 (17) (34) Headline sales revenue (Retail)2 5,560 5,154 7.9 1. Adjustment to headline sales
Slide 23: Officeworks
Officeworks Mark Ward Managing Director, Officeworks
Slide 24: Officeworks network
Officeworks network 1 164 Officeworks Stores 3 Fulfilment Centres 30 15 1 1 Call Centre 10 1 Print Hub 56 1 1 1 50 1 2 2017 Full-year results | 24
Slide 25: Store network movements
Store network movements Open at Open at Opened Closed 30 June 2016 30 June 2017 Officeworks 159 6 (1) 164 2017 Full-year results | 25
Slide 26: Industrials
Industrials Rob Scott Managing Director, Industrials
Slide 27: Chemicals, Energy & Fertilisers - Sales, pricing & production
Chemicals, Energy & Fertilisers - Sales, pricing & production kt Dry season driving lower Fertiliser sales volumes Volatility in global ammonia pricing 1,200 $/t 2nd Half 1st Half 800 Ammonia (US$, FOB Middle East) 1,000 700 Ammonia (A$, FOB Middle East) 600 800 500 776 866 600 713 722 779 400 300 4
Slide 28: Industrial & Safety - Distribution network
Industrial & Safety - Distribution network as at 30 June 2017 447 locations with 186 branches, 200 gas distribution points & 61 Workwear franchises 126 Blackwoods 93 Workwear Group (incl. 61 franchised) 3 3 1 1 22 62 218 Coregas (incl. 200 distribution points) 22 18 26 1 10 Greencap 16 1 6 31 5 1 21
Slide 29: Australian coal market prices
Australian coal market prices Australian steaming coal prices Australian hard coking coal prices US$/tonne (nominal) FOB Australia (annual versus spot) US$/tonne (nominal) FOB Australia (annual versus spot) 200 400 175 350 150 300 125 250 100 200 75 150 50 100 25 50 0 0 2004 2005 2006 2007 2008 2009
Slide 30: Curragh export metallurgical sales product mix
Curragh export metallurgical sales product mix FY17 Actual FY18 Forecast 8.2 million tonnes 8.5 – 9.0 million tonnes SEMI SEMI 23% 12% HARD HARD 42% 46% PCI PCI 35% 42% 2017 Full-year results | 30
Slide 31: Resources – Coal production volumes
Resources – Coal production volumes Year ended (‘000 tonnes) Mine Ownership Coal Type June 2017 June 2016 Curragh, QLD 100% Metallurgical 8,227 7,316 Steaming 3,801 3,263 Bengalla, NSW1 40% Steaming 3,437 3,384 Total 15,465 13,963 1. Wesfarmers attributable production. 2017 Full-year results | 31
Slide 32: Resources – Coal sales volumes
Resources – Coal sales volumes Year ended (‘000 tonnes) Mine Ownership Coal Type June 2017 June 2016 Curragh, QLD1 100% Metallurgical 8,162 7,488 Steaming 3,684 3,386 Bengalla, NSW2 40% Steaming 3,408 3,382 Total 15,254 14,256 1. Curragh metallurgical coal sales excludes traded coal. 2. Wesfarmers a
Slide 33: Resources – Financial summary
Resources – Financial summary Year ended 30 June1 ($m) 2017 2016 Commentary Export revenue Produced – Realised 1,676 1,012 Higher export coal sales prices & lower hedge book losses partially offset by a marginally higher Australian dollar – Hedge book gains / (losses) (92) (147) Total 1,584 865 High
Slide 34: Wesfarmers
os Wesfarmers