Slide 1: 2018 Half-year Results Supplementary Information
2018 Half-year Results Supplementary Information Wednesday, 21 February 2018 (to be read in conjunction with the 2018 Half-year Results Briefing Presentation)
Slide 2: Presentation outline
Presentation outline Item Page Group Balance Sheet & Cash Flow 3 Bunnings Australia & New Zealand 6 Bunnings United Kingdom & Ireland 9 Coles 12 Department Stores 16 Officeworks 20 Industrials 23 2018 Half-year results | 2
Slide 3: Group Balance Sheet & Cash Flow
Group Balance Sheet & Cash Flow
Slide 4: Group management balance sheet – overview
Group management balance sheet – overview ($m)1 1H18 FY17 1H17 Commentary (versus FY17) Inventories 6,979 6,530 6,852 Receivables & prepayments 2,096 1,936 2,083 Detailed working capital discussion Trade & other payables (7,890) (6,616) (7,624) provided on slide 5 Other 805 410 580 Net working capit
Slide 5: Balance sheet – working capital
Balance sheet – working capital ($m)1 1H18 FY17 1H17 Commentary (versus 1H17) • Increase reflects sales & store network Inventories 6,979 6,530 6,852 growth, partly offset by lower inventory in Target & BUKI Receivables & prepayments 2,096 1,936 2,083 • Increase reflects higher payables due to Trade
Slide 6: Bunnings Australia & New Zealand
Bunnings Australia & New Zealand
Slide 7: Bunnings Australia & NZ: store network
Bunnings Australia & NZ: store network As at 31 December 2017 253 Warehouse stores 77 Smaller format stores 3 33 Trade Centres 42 15 7 29 10 3 14 3 2 74 17 7 57 13 5 7 1 21 19 7 6 1 2018 Half-year results | 7
Slide 8: Bunnings Australia & New Zealand: store network locations
Bunnings Australia & New Zealand: store network locations Open at Open at Under 31 July Opened Closed 31 Dec Expanded construction 2017 2017 31 Dec 2017 Bunnings Warehouse 249 8 (4) 253 4 17 Bunnings smaller formats 77 2 (2) 77 - 2 Bunnings Trade Centres 33 1 (1) 33 - 1 2018 Half-year results | 8
Slide 9: Bunnings United Kingdom & Ireland
Bunnings United Kingdom & Ireland
Slide 10: Bunnings UK & Ireland: store network
Bunnings UK & Ireland: store network As at 31 December 2017 17 15 Bunnings stores 234 Homebase stores 9 11 11 15 186 2018 Half-year results | 10
Slide 11: Bunnings United Kingdom & Ireland: store network locations
Bunnings United Kingdom & Ireland: store network locations Open at Open at Under 31 July Opened Closed 31 Dec Expanded construction 2017 2017 31 Dec 2017 Bunnings 4 11 - 15 - 4 Homebase 251 - (17) 234 - - 2018 Half-year results | 11
Slide 12: Coles
Coles coles colescomau CRIES. ME spitit coles Financial Services press
Slide 13: Coles network
Coles network as at 31 December 2017 Selling Area Supermarkets (sqm) 1,857,314 8 8 11 Liquor (sqm) – ex hotels 212,971 167 239 76 96 118 4 84 142 806 Supermarkets 56 35 7 46 894 Liquor stores 254 280 1 88 Hotels 216 198 712 Convenience 209 214 16 15 2018 Half-year results | 13
Slide 14: Store network movements
Store network movements Open at Open at Opened Closed Re-branded 1 July 2017 31 Dec 2017 Supermarkets Coles 800 14 (8) - 806 Bi-Lo 1 - (1) - - Total Supermarkets 801 14 (9) - 806 Liquor First Choice 99 - (1) - 98 Vintage Cellars 82 2 - - 84 Liquorland 702 21 (11) - 712 Hotels 89 - (1) - 88 Total Liq
Slide 15: Revenue reconciliation
Revenue reconciliation Half-year ended 31 December 2017 2016 ($m) Food & Food & Conv. Total Conv. Total Liquor Liquor Segment revenue (Gregorian)1 17,056 2,922 19,978 16,878 3,178 20,056 Less: Other revenue (126) (8) (134) (226) (6) (232) Headline sales (Gregorian) 16,930 2,914 19,844 16,652 3,172 1
Slide 16: Department Stores
Department Stores © Target
Slide 17: Department Stores network
Department Stores network As at 31 December 2017 3 4 2 1 224 Kmart stores 46 55 254 KTAS centres 34 29 25 26 189 Target large stores 23 12 15 17 118 Target small stores 18 9 56 76 59 41 54 72 16 48 25 5 4 4 5 1 2018 Half-year results | 17
Slide 18: Store network movements
Store network movements Open at 1 July Open at Opened Closed 2017 31 Dec 2017 Kmart 220 5 (1) 224 Kmart Tyre & Auto 251 4 (1) 254 Total Kmart 471 9 (2) 478 Target Large 184 5 - 189 Target Small 119 1 (2) 118 Total Target 303 6 (2) 307 Total Department Stores 774 15 (4) 785 2018 Half-year results | 1
Slide 19: Revenue reconciliation
Revenue reconciliation Half-year ended 31 December ($m) 2017 2016 Segment revenue (Gregorian) 4,769 4,619 Less: Non sales revenue (3) (2) Headline sales (Gregorian) 4,766 4,617 Add: Gregorian adjustment1 106 96 Headline sales revenue (Retail)2 4,872 4,713 1. Adjustment to headline sales revenue to r
Slide 20: Officeworks
Officeworks rf 9 a = ® = =, 8 =]
Slide 21: Officeworks network
Officeworks network 1 165 Officeworks Stores 3 Fulfilment Centres 30 16 1 1 Call Centre 10 1 Print Hub 57 1 1 1 49 1 2 2018 Half-year results | 21
Slide 22: Store network movements
Store network movements Open at Open at Opened Closed 1 July 2017 31 Dec 2017 Officeworks 164 3 (2) 165 2018 Half-year results | 22
Slide 23: Industrials
Industrials ws vesarmesremicas, MA RY ace (IDI =¥2t Mizenheat [Jmoowoco Q guzgen Energy & Fertilisers CSBP Meatanvins ws G Wesfarmers Blackwoods: NZ SafetyBlackwor 'WORK\ Industrial and Safety = jackewoods WER Corecss = RAGS ae aRAGH ‘Wesfarmers Resources
Slide 24: Chemicals, Energy & Fertilisers - Sales, pricing & production
Chemicals, Energy & Fertilisers - Sales, pricing & production Higher 1H18 volumes due to late season application Volatility in global ammonia pricing kt $/t 1,200 800 Ammonia (US$, FOB Middle East) 2nd Half 1st Half 700 Ammonia (A$, FOB Middle East) 1,000 600 800 500 776 866 600 722 400 779 300 400
Slide 25: Industrial & Safety - Distribution network
Industrial & Safety - Distribution network as at 31 December 2017 444 locations with 180 branches, 200 gas distribution points & 64 Workwear franchises 125 Blackwoods 91 Workwear Group (incl. 64 franchised) 3 3 1 1 22 61 218 Coregas (incl. 200 distribution points) 20 18 27 1 10 Greencap 15 1 6 31 5
Slide 26: 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 27: Curragh export metallurgical sales product mix
Curragh export metallurgical sales product mix 1H18 Actual FY18 Forecast 4.5 million tonnes 8.5 – 8.8 million tonnes SEMI SEMI 12% 12% HARD HARD 48% 46% PCI PCI 40% 42% 2012/2013 Actual 2012/2013 Actual 2018 Half-year results | 27
Slide 28: Resources – coal production and sales volumes
Resources – coal production and sales volumes Production Half-year ended (‘000 tonnes) Mine Ownership Coal Type December 2017 December 2016 Curragh, QLD 100% Metallurgical 4,106 3,919 Steaming 1,873 1,899 Bengalla, NSW1 40% Steaming 1,880 1,714 Total 7,859 7,532 Sales Half-year ended (‘000 tonnes) M
Slide 29: Resources – financial summary
Resources – financial summary Half-year ended 31 December1 ($m) 2017 2016 Commentary Export revenue Produced – Realised 1,003 699 • Higher coal prices, increased sales volumes & reduced hedge book losses, partly offset by a higher Australian dollar – Hedge book gains / (losses) (17) (45) Total 986 6
Slide 30: Wesfarmers
os Wesfarmers