Business Analysis and Interpretation. Accounting

financialdownloadWESbalancesheetAnnual.xls

Home >Business & Finance homework help >Accounting homework help >Business Analysis and Interpretation. Accounting

<?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <Styles> <Style ss:ID="percentStyle" ss:Name="Normal"> <NumberFormat ss:Format="Percent"/> </Style> <Style ss:ID="shortDate01"> <NumberFormat ss:Format="Short Date"/> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> </Style> <Style ss:ID="header01"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/> <Interior ss:Color="#CCCCCC" ss:Pattern="Solid"/> </Style> <Style ss:ID="header02"> <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="aRight01"> <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> </Style> <Style ss:ID="centerBottom"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> </Style> <Style ss:ID="numberStyle"> <NumberFormat ss:Format="#,##0.00"/> </Style> <Style ss:ID="percentCommaStyle"> <NumberFormat ss:Format="#,##0.00%"/> </Style> </Styles> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Profit Loss"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/16</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/17</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">62102000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">65512000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">68015000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">648000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">573000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">633000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Revenue Excluding Interest</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">62750000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">66085000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">68648000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-57912000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-61516000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-63130000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBITDA</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4838000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4569000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5518000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Depreciation</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-934000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-981000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-960000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Amortisation</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-118000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-134000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-158000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Depreciation and Amortisation</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1052000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1115000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1118000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBIT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3786000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3454000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4400000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interest Revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">131000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">84000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interest Expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-315000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-308000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-264000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Interest Expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-288000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-177000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-180000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">PreTax Profit</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3498000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3277000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4220000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Tax Expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1004000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-631000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1265000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Profit after Tax Before Abnormals</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2494000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2646000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2955000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Abnormals</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-54000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-82000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Abnormals Tax</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Abnormals</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-54000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-82000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Reported NPAT After Abnormals</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2440000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">407000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2873000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Outside Equity Interests</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Shares Outstanding at Period End</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1123753000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1126131000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1131752000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Weighted Average Number of Shares</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1129000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1123000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1128000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EPS Adjusted (cents/share)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">220.47</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">235.62</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">261.46</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EPS After Abnormals (cents/share)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">215.70</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">36.24</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">254.20</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Balance Sheet"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/16</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/17</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CA - Cash</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">711000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">611000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1013000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CA - Receivables</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1463000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1628000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1633000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CA - Prepaid Expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">806000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">835000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CA - Inventories</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5497000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6260000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6530000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CA - Investments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">428000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">54000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">247000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CA - NCA Held Sale</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CA - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">188000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">296000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">244000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Current Assets</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9093000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9684000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9667000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - Receivables</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - Inventories</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - Investments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1056000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1170000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">949000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - PP&E</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10205000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9612000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9440000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - Intangibles(ExGW)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4601000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4625000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4576000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - Goodwill</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14708000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14448000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14360000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - Future Tax Benefit</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">558000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1042000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">971000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCA - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">181000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">202000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">152000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total NCA</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">31309000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">31099000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30448000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Assets</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">40402000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">40783000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">40115000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CL - Account Payable</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5761000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6491000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6615000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CL - Short-Term Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1913000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1632000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1347000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CL - Provisions</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1811000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2050000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2189000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CL - NCL Held Sale</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">CL - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">241000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">251000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">266000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Curr. Liabilities</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9726000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10424000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10417000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCL - Account Payable</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCL - Long-Term Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4615000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5671000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4066000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCL - Provisions</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1165000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1635000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1535000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NCL - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">115000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">104000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">156000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total NCL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5895000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7410000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5757000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Liabilities</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15621000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">17834000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">16174000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Share Capital</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21844000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21909000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22242000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Reserves</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">195000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">166000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">190000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Retained Earnings</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2742000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">874000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1509000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Convertible Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">SE Held Sale</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Outside Equity</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24781000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22949000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23941000000</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Cash Flow"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/16</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/17</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Receipts from Customers</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">67484000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">71157000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">74042000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Payments to Suppliers and Employees</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-62369000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-66671000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-68713000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dividends Received</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">42000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">74000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">46000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interest Received</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">131000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">83000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interest Paid</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-283000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-288000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-234000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Tax Paid</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1102000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1009000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-951000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Operating Cashflows</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-8000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-29000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-47000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Operating Cashflows</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3791000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3365000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4226000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Payment for Purchase of PPE</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1899000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1681000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Proceeds From Sale of PPE</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">687000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">563000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">653000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Investments Purchased</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-131000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-49000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Proceeds From Sale of Investments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">54000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Payments for Purchase of Subsidiaries</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-339000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-748000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-24000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Proceeds from Sale of Subsidiaries</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">124000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">947000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Loans Granted</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Loans Repaid</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Investing Cashflows</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Investing Cashflows</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1898000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2132000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-53000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Proceeds from Issues</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Proceeds from Borrowings</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">930000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2360000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">220000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Repayment of Borrowings</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-722000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1424000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1994000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dividends Paid</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2597000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2270000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1998000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Financing Cashflows</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-864000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Financing Cashflows</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-3249000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1333000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-3771000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Increase in Cash</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1356000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-100000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">402000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Cash at Beginning of Period</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2067000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">711000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">611000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Exchange Rate Adj</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Cash Adjustments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Cash at End of Period</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">711000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">611000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1013000000</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Per Share Statisticts"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/16</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/17</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Shares Outstand. (EOP)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1123753000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1126131000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1131752000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Weighted Avg. Shares</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1129000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1123000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1128000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EPS Bef. Abs</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">216.1205</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">36.2422</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">254.6986</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EPS Aft. Abs.</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">215.7000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">36.2000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">254.2000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dilution Factor</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Cumulative</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Reportd EPS Bef. Abs.Adj</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">220.4700</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">235.6200</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">261.4600</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">DPS - Adj Ex. Special</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">200.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">186.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">223.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">DPS - Adj.</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">225.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">186.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">223.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interim Div - Ordinary</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">89.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">91.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">103.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interim Franking - Ord (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Interim Div - Ord</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">127.1429</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">130.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">147.1429</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Final Dividend - Ordinary</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">111.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">95.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">120.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Final Franking - Ordinary (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Final Div - Ord</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">158.5714</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">135.7143</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">171.4286</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Special Dividend - Ord</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">25.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Special Franking - Ord (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Special Div - Ord</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">35.7143</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Div - Ex. Special</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">200.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">186.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">223.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Div - Inc. Special</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">225.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">186.0000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">223.0000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Franking - Ex. Spec</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Franking - Inc. Spec (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100.00</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Gross Div- Ex.Spec</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">285.7143</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">265.7143</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">318.5714</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Gross Div- Inc.Spec</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">321.4286</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">265.7143</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">318.5714</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Tax Rate (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">28.70</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">19.26</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29.98</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Corporate Tax Rate (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30.00</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Payout Ratio Ex. Special (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">90.72</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">78.94</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">85.29</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Payout Ratio (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">102.05</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">78.94</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">85.29</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dividend Yield (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.76</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.64</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.56</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dividend Yield Ex. Spec (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.12</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.64</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.56</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dividend Cover (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">110.24</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">126.68</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">117.25</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Div. Yield (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8.24</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.63</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.94</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Div. Yield Ex. Spec (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.32</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.63</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.94</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Revenue Expense"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="100"/>  <Column ss:AutoFitWidth="0" ss:Width="120"/>  <Column ss:AutoFitWidth="0" ss:Width="180"/>  <Column ss:AutoFitWidth="0" ss:Width="180"/>  <Column ss:AutoFitWidth="0" ss:Width="100"/>  <Column ss:AutoFitWidth="0" ss:Width="100"/>  <Column ss:AutoFitWidth="0" ss:Width="100"/>   <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Year</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Data Set</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Items</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item BreakDown</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Values</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Tax</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Notes</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Gain/(Loss) on sales of PPE</Data></Cell> <Cell><Data ss:Type="String">Gains on disposal of property, plant and equipment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">123000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Operating Revenue (sales)</Data></Cell> <Cell><Data ss:Type="String">Rendering of services</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">12000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Operating Revenue (sales)</Data></Cell> <Cell><Data ss:Type="String">Sale of goods</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">68003000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Gross Interest Income</Data></Cell> <Cell><Data ss:Type="String">Interest revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">84000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Other Non-Operating Revenue (ordinary activities)</Data></Cell> <Cell><Data ss:Type="String">Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">345000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Other Non-Operating Revenue (ordinary activities)</Data></Cell> <Cell><Data ss:Type="String">Other income - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">165000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Expenses related to pension plan</Data></Cell> <Cell><Data ss:Type="String">Superannuation expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-635000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Impairment of tangible assets</Data></Cell> <Cell><Data ss:Type="String">Impairment of property, plant and equipment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-27000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Impairment of tangible assets</Data></Cell> <Cell><Data ss:Type="String">Impairment of freehold property</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-22000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Share based payment expenditure</Data></Cell> <Cell><Data ss:Type="String">Share based payments expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-105000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Materials and other input costs</Data></Cell> <Cell><Data ss:Type="String">Raw materials and inventory </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-46359000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Distribution expenses</Data></Cell> <Cell><Data ss:Type="String">Freight and other related expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1096000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Staff and Employee Expenses</Data></Cell> <Cell><Data ss:Type="String">Remuneration, bonuses and on-costs</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-8392000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Occupancy Expenses</Data></Cell> <Cell><Data ss:Type="String">Occupancy related expenses - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-615000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Occupancy Expenses</Data></Cell> <Cell><Data ss:Type="String">Contingent rental payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-215000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Administration Expenses</Data></Cell> <Cell><Data ss:Type="String">Utilities and office expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1106000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Operating lease expense</Data></Cell> <Cell><Data ss:Type="String">Minimum lease payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2399000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Directors' Remuneration</Data></Cell> <Cell><Data ss:Type="String">Directors' remuneration</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-15014247</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Audit and review of financial reports - Ernst & Young (Australia</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5723000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Audit and review of financial reports - Ernst & Young (Overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-702000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Auditors other than the Main Auditor</Data></Cell> <Cell><Data ss:Type="String">Assurance-related services - Other audit firms</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-218000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Assurance-related services - Ernst & Young (Australian & overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1272000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Tax compliance - Ernst & Young (Australian & overseas network firms</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1088000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Other - Ernst & Young (Australian & overseas network firms</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1219000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Repairs and maintenance</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-415000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Mining royalties - Stanwell rebate</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-262000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Other </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1410000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Insurance expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-153000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Amortisation other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-148000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Depreciation</Data></Cell> <Cell><Data ss:Type="String">Depreciation </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-960000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Amortisation</Data></Cell> <Cell><Data ss:Type="String">Amortisation of intangibles</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-158000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairment of freehold property</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-22000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairment of property, plant and equipment</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-27000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2017</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Transition and restructuring costs</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-33000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Gain/(Loss) on sales of PPE</Data></Cell> <Cell><Data ss:Type="String">Gains on disposal of property, plant and equipment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">61000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Operating Revenue (sales)</Data></Cell> <Cell><Data ss:Type="String">Rendering of services</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">12000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Operating Revenue (sales)</Data></Cell> <Cell><Data ss:Type="String">Sale of goods</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">65500000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Gross Interest Income</Data></Cell> <Cell><Data ss:Type="String">Interest revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">131000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Other Non-Operating Revenue (ordinary activities)</Data></Cell> <Cell><Data ss:Type="String">Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">338000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Other Non-Operating Revenue (ordinary activities)</Data></Cell> <Cell><Data ss:Type="String">Other </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">174000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Expenses related to pension plan</Data></Cell> <Cell><Data ss:Type="String">Superannuation expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-624000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Impairment of goodwill</Data></Cell> <Cell><Data ss:Type="String">Impairment of goodwill</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1208000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Impairment of tangible assets</Data></Cell> <Cell><Data ss:Type="String">Impairment of freehold property</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-10000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Impairment of tangible assets</Data></Cell> <Cell><Data ss:Type="String">Impairment of property, plant and equipment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-954000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Share based payment expenditure</Data></Cell> <Cell><Data ss:Type="String">Share based payments expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-103000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Materials and other input costs</Data></Cell> <Cell><Data ss:Type="String">Raw materials and inventory </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-45525000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Distribution expenses</Data></Cell> <Cell><Data ss:Type="String">Freight and other related expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1078000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Staff and Employee Expenses</Data></Cell> <Cell><Data ss:Type="String">Remuneration, bonuses and on-costs</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-8120000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Occupancy Expenses</Data></Cell> <Cell><Data ss:Type="String">Contingent rental payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-91000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Occupancy Expenses</Data></Cell> <Cell><Data ss:Type="String">Occupancy related expenses - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-538000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Administration Expenses</Data></Cell> <Cell><Data ss:Type="String">Utilities and office expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1044000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Operating lease expense</Data></Cell> <Cell><Data ss:Type="String">Minimum lease payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2330000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Audit and review of financial reports-Ernst & Young (Australia)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5780000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Audit and review of financial reports-Ernst & Young (Overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-577000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Assurance related services-Ernst & Young (Australian & overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2215000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Assurance related services-Non-Ernst & Young audit firms</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-112000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Non-assurance related services- tax compliance-Ernst & Young (Australian & overseas network firms</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1096000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Non-assurance related services-other-Ernst & Young (Australian & overseas network firms</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-882000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Other </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1336000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Repairs and maintenance</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-405000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Amortisation other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-181000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Insurance expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-179000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Mining royalties - Stanwell rebate</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-143000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Depreciation</Data></Cell> <Cell><Data ss:Type="String">Depreciation </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-981000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Amortisation</Data></Cell> <Cell><Data ss:Type="String">Amortisation of intangibles</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-134000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Cease PVC manufacturing in WesCEF</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-32000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairment of freehold property</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-10000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairment of goodwill</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1208000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairment of plant, equipment and other assets</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-954000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2016</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Restructuring costs</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-35000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Gain/(Loss) on sales of non current assets</Data></Cell> <Cell><Data ss:Type="String">Gain on sale of controlled entities</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Gain/(Loss) on sales of PPE</Data></Cell> <Cell><Data ss:Type="String">Gains on disposal of property, plant and equipment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">54000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Operating Revenue (sales)</Data></Cell> <Cell><Data ss:Type="String">Sale of goods</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">62089000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Operating Revenue (sales)</Data></Cell> <Cell><Data ss:Type="String">Rendering of services</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Gross Interest Income</Data></Cell> <Cell><Data ss:Type="String">Interest revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Other Non-Operating Revenue (ordinary activities)</Data></Cell> <Cell><Data ss:Type="String">Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">318000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Revenue</Data></Cell> <Cell><Data ss:Type="String">Other Non-Operating Revenue (ordinary activities)</Data></Cell> <Cell><Data ss:Type="String">Other </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">269000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Expenses related to pension plan</Data></Cell> <Cell><Data ss:Type="String">Superannuation expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-584000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Impairment of tangible assets</Data></Cell> <Cell><Data ss:Type="String">Impairment of freehold property</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-22000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Impairment of tangible assets</Data></Cell> <Cell><Data ss:Type="String">Impairment of property, plant and equipment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-19000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Share based payment expenditure</Data></Cell> <Cell><Data ss:Type="String">Share based payments expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-94000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Materials and other input costs</Data></Cell> <Cell><Data ss:Type="String">Raw materials and inventory </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-43045000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Distribution expenses</Data></Cell> <Cell><Data ss:Type="String">Freight and other related expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1019000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Staff and Employee Expenses</Data></Cell> <Cell><Data ss:Type="String">Remuneration, bonuses and on-costs</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-7520000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Occupancy Expenses</Data></Cell> <Cell><Data ss:Type="String">Occupancy related expenses - Other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-486000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Occupancy Expenses</Data></Cell> <Cell><Data ss:Type="String">Contingent rental payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-83000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Administration Expenses</Data></Cell> <Cell><Data ss:Type="String">Utilities and office expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1020000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Operating lease expense</Data></Cell> <Cell><Data ss:Type="String">Minimum lease payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2068000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Royalties Paid</Data></Cell> <Cell><Data ss:Type="String">Government mining royalties</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-100000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Directors' Remuneration</Data></Cell> <Cell><Data ss:Type="String">Director's Remuneration</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-18052659</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Audit and review of financial reports - Ernst & Young (Australia)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5162000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Audit and review of financial reports - Ernst & Young (Overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-248000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Assurance related services - Ernst & Young (Australian & overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1062000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Assurance related services - Non-Ernst & Young audit firms</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-32000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Non-assurance related services: Tax compliance - Ernst & Young (Australian & overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-660000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Audit Fee for Non-audit Paid by Consolidated Entity to Main Auditor including related firms</Data></Cell> <Cell><Data ss:Type="String">Non-assurance related services: Other - Ernst & Young (Australian & overseas network firms)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-360000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Other </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1375000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Repairs and maintenance</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-379000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Amortisation other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-167000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Operating Expenses</Data></Cell> <Cell><Data ss:Type="String">Stanwell rebate</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-67000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Depreciation</Data></Cell> <Cell><Data ss:Type="String">Depreciation </Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-934000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Other Amortisation</Data></Cell> <Cell><Data ss:Type="String">Amortisation of intangibles</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-118000000</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Gain on sale of controlled entities</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairment of freehold property</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-22000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairment of plant, equipment and other assets</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-19000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">06/2015</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Restructuring costs</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-20000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell><Data ss:Type="String">--</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Sundry Analysis"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/16</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/17</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Current Assets</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8382000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9073000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8654000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Non Int Bearing CL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-7813000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-8792000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-9070000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Wkg Capital</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">569000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">281000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-416000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net PP&E</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10205000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9612000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9440000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Intangibles Ex.Goodwill</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4601000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4625000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4576000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Oth Operating Assets</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-541000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-495000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-568000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Invested Capital Ex-Goodwill</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14834000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14023000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13032000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Goodwill</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14708000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14448000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14360000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Invested Capital Incl. Goodwill</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29542000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">28471000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27392000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Cash</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">711000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">611000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1013000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Non Current Investments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1056000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1170000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">949000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Investor Funds</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">31309000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30252000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29354000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24781000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22949000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23941000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Borrowings</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6528000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7303000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5413000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Investor Funds</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">31309000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30252000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29354000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBIT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3786000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3454000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4400000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Corp Tax Rate (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30.00</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Tax on EBIT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1090400000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-684100000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1319000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Amortisation</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">118000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">134000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">158000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NOPLAT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2813600000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2903900000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3239000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Tax Expense</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1004000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-631000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1265000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Tax Shield</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">86400000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">53100000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">54000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Tax on EBIT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1090400000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-684100000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1319000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NOPLAT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2813600000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2903900000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3239000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Depreciation</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">934000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">981000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">960000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Cash Flow</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3702200000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3532800000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4198000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Investment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-3048000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1611000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-984000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Free Cash Flow</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">654200000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1921800000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3214000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Current Debtors</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1463000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1628000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1633000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Prepayments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">806000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">835000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Current Inventory</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5497000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6260000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6530000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Current Investments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">428000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">54000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">247000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Oth Current Assets</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">188000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">296000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">244000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Creditors CL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5761000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6491000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6615000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Provisions CL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1811000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2050000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2189000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Curr Liab</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">241000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">251000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">266000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Working Capital</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">569000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">281000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-416000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Debtors</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-121000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">165000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Prepay</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">806000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-835000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Inventory CA</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">161000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">763000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">270000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Curr Invest</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">362000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-374000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">193000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Oth CA</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-70000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">108000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-52000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Creditors CL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">344000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">730000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">124000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Provisions CL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-6000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">139000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Other CL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-9000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Wkg Capital</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">809000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-288000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-697000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Capex</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1899000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1681000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Capex</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-6000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">340000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">218000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Wkg Capital</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">809000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-288000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-697000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Capex</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1899000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1681000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Investment</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-3048000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1611000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-984000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Funds from Operations</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5115000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4486000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5329000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dividends Received</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">42000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">74000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">46000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interest Received</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">131000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">83000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Interest Paid</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-283000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-288000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-234000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Operating Cash</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-8000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-29000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-47000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Purchase of PPE</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1899000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1681000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Surplus Funds - Post Capex</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1552000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1466000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2545000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Proceeds from PPE</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">687000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">563000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">653000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Surplus Funds - Post PPE</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2239000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2029000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3198000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Dividends Paid</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2597000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2270000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1998000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Surplus Funds - Post Div.</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-358000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-241000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1200000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Purchase of Investments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-131000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-49000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Surplus Funds - Post Acquis.</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-489000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-290000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1198000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">S/T Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1913000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1632000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1347000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">L/T Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4615000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5671000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4066000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Gross Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6528000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7303000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5413000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase S/T Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1168000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-281000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-285000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase L/T Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">295000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1056000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1605000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Change Gross Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1463000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">775000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1890000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Cash</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">711000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">611000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1013000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Cash</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1356000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-100000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">402000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5817000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6692000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4400000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Net Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2819000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">875000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2292000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Capital</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21844000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21909000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22242000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Reserves Ex-SPR</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">195000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">166000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">190000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Share Prem Reserve</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Retained Profits</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2742000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">874000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1509000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Convertible Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Outside Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24781000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22949000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23941000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase in Capital</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-834000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">65000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">333000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Incr Reserves Ex-SPR</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-213000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-29000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Incr. Share Prem Res</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Retain Profits</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-159000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1868000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">635000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Other Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Convert Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Outside Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Increase Total Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1206000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1832000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">992000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Gross Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6528000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7303000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5413000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Equity</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24781000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22949000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23941000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Capital Invested</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">31309000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30252000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29354000000</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Growth Rates"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"> <Data ss:Type="String">ASX Code</Data> </Cell> <Cell ss:StyleID="header01"> <Data ss:Type="String">Company Name</Data> </Cell> <Cell ss:StyleID="header01"> <Data ss:Type="String">Item</Data> </Cell> <Cell ss:StyleID="header01"> <Data ss:Type="String">06/15</Data> </Cell> <Cell ss:StyleID="header01"> <Data ss:Type="String">06/16</Data> </Cell> <Cell ss:StyleID="header01"> <Data ss:Type="String">06/17</Data> </Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Rev. 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.69</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.49</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.82</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Rev. 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.49</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.31</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.33</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Rev. 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.82</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.74</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.35</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Exp. 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.65</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.22</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.62</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Exp. 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.41</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.60</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.15</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Operating Exp. 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.74</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.83</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.20</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBITDA 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.09</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5.56</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">20.77</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBITDA 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.21</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-0.23</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.89</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBITDA 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.87</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.64</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.63</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBIT 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.17</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-8.77</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27.39</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBIT 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.60</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-0.72</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.26</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBIT 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.84</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.27</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.26</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBT After Abs. 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">35.38</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-69.86</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">298.65</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBT After Abs. 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.20</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-31.48</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">17.60</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBT After Abs. 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.23</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-17.44</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.33</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EAT 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-9.26</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-83.32</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">605.90</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EAT 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.70</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-43.54</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.23</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EAT 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.29</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-26.69</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.21</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EPS Adj 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">12.35</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.87</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.97</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EPS Adj 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.88</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.05</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.04</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EPS Adj 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.01</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.08</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Div. Ex Spec 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.26</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-7.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">19.89</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Div. Ex Spec 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.62</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.10</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.48</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Div. Ex Spec 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.86</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.40</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.21</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">DPS Adj Ex Spec 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.26</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-7.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">19.89</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">DPS Adj Ex Spec 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.27</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.76</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.48</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">DPS Adj Ex Spec 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.64</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.19</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.00</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Assets 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.70</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.94</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.64</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Assets 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.53</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.87</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.32</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Assets 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.59</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-0.02</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.06</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net PP&E 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.54</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5.81</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.79</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net PP&E 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.55</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.84</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.75</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net PP&E 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.23</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.97</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-0.05</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Equity 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-4.64</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-7.39</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.32</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Equity 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.11</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-4.10</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2.70</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Total Equity 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.07</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.95</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.35</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Retained Profits 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5.48</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-68.13</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">72.65</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Retained Profits 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.25</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-28.34</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-19.58</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Retained Profits 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">14.16</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-13.20</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-6.42</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Debt 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">94.03</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.04</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-34.25</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Debt 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.08</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.79</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13.64</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Debt 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.99</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.95</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-6.05</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Invested Capital 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.74</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5.47</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-7.07</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Invested Capital 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.37</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.42</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.21</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Invested Capital 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.84</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.88</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2.34</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NOPLAT 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.12</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.21</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.54</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NOPLAT 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.11</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.73</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.23</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NOPLAT 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.02</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.24</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.76</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Free Cashflow 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-77.22</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">193.76</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">67.24</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Free Cashflow 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-16.77</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.42</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.82</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Free Cashflow 5 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-12.44</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">40.51</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23.15</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Ratio Analysis"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/16</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/17</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Profit Margin (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.02</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.04</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.34</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBIT Margin (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.10</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.27</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.47</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBITA Margin (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.29</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.48</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.70</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EBITDA Margin (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.79</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.97</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8.11</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">ROE (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.06</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.53</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">12.34</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">ROA (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.72</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.02</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.83</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">ROIC (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">18.97</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">20.71</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24.85</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NOPLAT Margin (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.53</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.43</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.76</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Invested Capital Turnover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.1865</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.6718</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.2191</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Inventory Turnover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.2974</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.4652</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.4158</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Asset Turnover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.5371</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.6064</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.6955</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">LT Asset Turnover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.9835</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.1066</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.2338</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">PPE Turnover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.0854</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.8156</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.2050</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Depreciation/PP&E (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.46</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.42</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.13</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Depreciation/Revenue (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.50</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.50</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.41</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Wkg Capital/Revenue (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.92</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.43</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-0.61</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Working Cap Turnover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">109.1424</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">233.1388</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-163.4976</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Financial Leverage</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.6304</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.7771</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.6756</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Gearing (D/E) (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">26.34</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">31.82</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22.61</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Gearing (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23.47</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29.16</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">18.38</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Interest Cover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13.1458</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">19.5141</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24.4444</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Current Ratio</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.9349</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.9290</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.9280</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Quick Ratio</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.3697</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.3285</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.3011</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross Debt/CF</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.7633</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.0672</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.2894</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Debt/CF</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.5712</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.8942</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.0481</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">NTA per Share ($)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.8694</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.4419</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.4223</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">BV per Share ($)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22.0520</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">20.3786</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21.1539</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Cash per Share ($)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.6327</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.5426</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.8951</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Receivables/Op. Rev. (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.75</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.87</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.82</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Inventory/Trading Rev. (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8.85</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.56</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.60</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Creditors/Op. Rev. (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.28</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.91</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.73</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Funds from Ops./EBITDA (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">105.73</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">98.18</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">96.57</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Depreciation/Capex (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">41.72</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">51.66</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">57.11</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Capex/Operating Rev. (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.61</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.90</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.47</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Days Inventory</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">32.3082</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">34.8776</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">35.0430</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Days Receivables</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.3770</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.8195</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.6544</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Days Payables</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">33.8599</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">36.1646</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">35.4992</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Gross CF per Share ($)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.2728</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.1459</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.7143</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Sales per Share ($)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">54.8992</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">58.3366</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">60.1790</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Year End Share Price</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">39.0300</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">40.1000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">40.1200</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Market Cap.</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">43860079590</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">45157853100</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">45405890240</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Net Debt</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5817000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6692000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4400000000</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Enterprise Value</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">49677079590</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">51849853100</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">49805890240</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EV/EBITDA</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.2681</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.3482</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.0261</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">EV/EBIT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13.1213</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.0115</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.3195</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Market Cap./Rep NPAT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">17.9754</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">110.9530</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.8043</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Market Cap./Trading Rev.</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.7063</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.6893</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.6676</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Price/Book Value</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.7699</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.9677</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.8966</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Price/Gross Cash Flow</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.8470</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">12.7825</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10.8161</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">PER</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">17.7031</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">17.0189</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.3446</Data></Cell> </Row> </Table> </Worksheet> <Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Asset Base Analysis"> <Table ss:DefaultRowHeight="15"> <Column ss:AutoFitWidth="0" ss:Width="80"/>  <Column ss:AutoFitWidth="0" ss:Width="150"/>  <Column ss:AutoFitWidth="0" ss:Width="200"/>  <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/>  <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="header01"><Data ss:Type="String">ASX Code</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Company Name</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">Item</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/16</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">06/17</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Cash (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.76</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.50</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.53</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Trade Debtors (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.62</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.99</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.07</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Inventory (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13.61</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.35</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">16.28</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Plant & Equipment (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">25.26</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23.57</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23.53</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Intangibles (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.39</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.34</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.41</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Goodwill (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">36.40</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">35.43</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">35.80</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Non Current Investments (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.61</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.87</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.37</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Other (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.35</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.96</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.02</Data></Cell> </Row> </Table> </Worksheet> </Workbook>