Business Analysis and Interpretation. Accounting
atgkd153
financialdownloadWESbalancesheetInterim.xls<?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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">12/16</Data></Cell> </Row> <Row ss: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">33229000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">34660000000</Data></Cell> </Row> <Row ss: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">276000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">373000000</Data></Cell> </Row> <Row ss: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">33505000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">35033000000</Data></Cell> </Row> <Row ss: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">-30809000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-32026000000</Data></Cell> </Row> <Row ss: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">2696000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3007000000</Data></Cell> </Row> <Row ss: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">-483000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-481000000</Data></Cell> </Row> <Row ss: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">-156000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-154000000</Data></Cell> </Row> <Row ss: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">-639000000</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">EBIT</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2057000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2372000000</Data></Cell> </Row> <Row ss: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">65000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">67000000</Data></Cell> </Row> <Row ss: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">-152000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-149000000</Data></Cell> </Row> <Row ss: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">-87000000</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">PreTax Profit</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1970000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2290000000</Data></Cell> </Row> <Row ss: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">-565000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-703000000</Data></Cell> </Row> <Row ss: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">1405000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1587000000</Data></Cell> </Row> <Row ss: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">-12000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-10000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">-12000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-10000000</Data></Cell> </Row> <Row ss: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">1393000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1577000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">1126131000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1130939000</Data></Cell> </Row> <Row ss: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">1122000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1126000000</Data></Cell> </Row> <Row ss: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">124.97</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">140.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">EPS After Abnormals (cents/share)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">124.97</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">140.79</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">12/16</Data></Cell> </Row> <Row ss: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">694000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">738000000</Data></Cell> </Row> <Row ss: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">2330000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2643000000</Data></Cell> </Row> <Row ss: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">6580000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6852000000</Data></Cell> </Row> <Row ss: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">427000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">72000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">255000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">295000000</Data></Cell> </Row> <Row ss: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">10286000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10600000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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">1168000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1204000000</Data></Cell> </Row> <Row ss: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">10207000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9436000000</Data></Cell> </Row> <Row ss: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">19298000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">18999000000</Data></Cell> </Row> <Row ss: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">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 - Future Tax Benefit</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">593000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">944000000</Data></Cell> </Row> <Row ss: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">238000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">216000000</Data></Cell> </Row> <Row ss: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">31504000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30799000000</Data></Cell> </Row> <Row ss: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 - Total Assets</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">41790000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">41399000000</Data></Cell> </Row> <Row ss: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">7062000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7623000000</Data></Cell> </Row> <Row ss: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">2056000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">444000000</Data></Cell> </Row> <Row ss: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">1822000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1906000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">341000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">377000000</Data></Cell> </Row> <Row ss: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">11281000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">10350000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">4226000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5630000000</Data></Cell> </Row> <Row ss: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">1212000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1552000000</Data></Cell> </Row> <Row ss: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">109000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">100000000</Data></Cell> </Row> <Row ss: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">5547000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7282000000</Data></Cell> </Row> <Row ss: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">16828000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">17632000000</Data></Cell> </Row> <Row ss: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">21937000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22140000000</Data></Cell> </Row> <Row ss: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">138000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">243000000</Data></Cell> </Row> <Row ss: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">2887000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1384000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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">24962000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23767000000</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">12/16</Data></Cell> </Row> <Row ss: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">36082000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">37694000000</Data></Cell> </Row> <Row ss: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">-33075000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-34408000000</Data></Cell> </Row> <Row ss: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">44000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23000000</Data></Cell> </Row> <Row ss: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">66000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">67000000</Data></Cell> </Row> <Row ss: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">-143000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-129000000</Data></Cell> </Row> <Row ss: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">-547000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-537000000</Data></Cell> </Row> <Row ss: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">-23000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-62000000</Data></Cell> </Row> <Row ss: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">2404000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2648000000</Data></Cell> </Row> <Row ss: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">-1059000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-924000000</Data></Cell> </Row> <Row ss: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">384000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">524000000</Data></Cell> </Row> <Row ss: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">-59000000</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">9000000</Data></Cell> </Row> <Row ss: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 Subsidiaries</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5000000</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">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">Loan 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> </Row> <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">WES</Data></Cell> <Cell><Data ss:Type="String">Wesfarmers Limited</Data></Cell> <Cell><Data ss:Type="String">Loan 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> </Row> <Row ss: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> </Row> <Row ss: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">-739000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-417000000</Data></Cell> </Row> <Row ss: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">1000000</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">Proceeds from Borrowings</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">360000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">253000000</Data></Cell> </Row> <Row ss: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">-797000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1398000000</Data></Cell> </Row> <Row ss: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">-1246000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-959000000</Data></Cell> </Row> <Row ss: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">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">-1682000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2104000000</Data></Cell> </Row> <Row ss: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">-17000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">127000000</Data></Cell> </Row> <Row ss: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">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> </Row> <Row ss: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><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">Cash at End of Period</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">694000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">738000000</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">12/16</Data></Cell> </Row> <Row ss: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">1126131000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1130939000</Data></Cell> </Row> <Row ss: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">1122000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1126000000</Data></Cell> </Row> <Row ss: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">125.2228</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">140.9414</Data></Cell> </Row> <Row ss: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">124.1533</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">140.0533</Data></Cell> </Row> <Row ss: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 EPS</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">123.9000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">139.9000</Data></Cell> </Row> <Row ss: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">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> </Row> <Row ss: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 - Int</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 - Int (%)</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">Payout Ratio (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">72.82</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">73.16</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="100"/> <!-- year --> <Column ss:AutoFitWidth="0" ss:Width="120"/> <!-- data set revenue, expense, non-occuring --> <Column ss:AutoFitWidth="0" ss:Width="180"/> <!-- item group --> <Column ss:AutoFitWidth="0" ss:Width="180"/> <!-- item description /breakdown --> <Column ss:AutoFitWidth="0" ss:Width="100"/> <!-- values / pre tax--> <Column ss:AutoFitWidth="0" ss:Width="100"/> <!-- tax --> <Column ss:AutoFitWidth="0" ss:Width="100"/> <!-- notes --> <!-- Header--> <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">12/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">120000000</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">12/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">34654000000</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">12/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">6000000</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">12/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">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">12/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 income</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">63000000</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">12/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 - revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">190000000</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">12/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">-324000000</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">12/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">Impairmen of plant, equipment and other assets</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">12/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">-68000000</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">12/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">-23756000000</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">12/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">-539000000</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">12/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">-4198000000</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">12/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 - Contingent rental payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-38000000</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">12/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">-307000000</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">12/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">Occupancy-related expenses - Minimum lease payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1251000000</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">12/2016</Data></Cell> <Cell><Data ss:Type="String">Expense</Data></Cell> <Cell><Data ss:Type="String">Royalties Paid</Data></Cell> <Cell><Data ss:Type="String">Mining royalties(incl. Stanwell rebate)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-90000000</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">12/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">-214000000</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">12/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 expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-660000000</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">12/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">-57000000</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">12/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">Utilities and office expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-568000000</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">12/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">-481000000</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">12/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">-81000000</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">12/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 other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-73000000</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">12/2016</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairmen of plant, equipment and other assets</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">12/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">37000000</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">12/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">33223000000</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">12/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">6000000</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">12/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">65000000</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">12/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 income</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">71000000</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">12/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 - revenue</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">168000000</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">12/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">-314000000</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">12/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">Impairmen of plant, equipment and other assets</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">12/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">-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">12/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">-23178000000</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">12/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">-520000000</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">12/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">-3953000000</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">12/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 - Contingent rental payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-48000000</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">12/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">-233000000</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">12/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">Occupancy-related expenses - Minimum lease payments</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1083000000</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">12/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">Mining royalties(incl. Stanwell rebate)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-81000000</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">12/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">-203000000</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">12/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">Insurance expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-65000000</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">12/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 expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-640000000</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">12/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">Utilities and office expenses</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-503000000</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">12/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">-483000000</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">12/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">-69000000</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">12/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 other</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-87000000</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">12/2015</Data></Cell> <Cell><Data ss:Type="String">Non Recurring</Data></Cell> <Cell><Data ss:Type="String">Impairmen of plant, equipment and other assets</Data></Cell> <Cell><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-12000000</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">12/16</Data></Cell> </Row> <Row ss: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">9592000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9862000000</Data></Cell> </Row> <Row ss: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">-9225000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-9906000000</Data></Cell> </Row> <Row ss: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">367000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-44000000</Data></Cell> </Row> <Row ss: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">10207000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9436000000</Data></Cell> </Row> <Row ss: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">19298000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">18999000000</Data></Cell> </Row> <Row ss: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">-490000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-492000000</Data></Cell> </Row> <Row ss: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">29382000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27899000000</Data></Cell> </Row> <Row ss: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">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">Operating Invested Capital Incl. Goodwill</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29382000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27899000000</Data></Cell> </Row> <Row ss: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">694000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">738000000</Data></Cell> </Row> <Row ss: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">1168000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1204000000</Data></Cell> </Row> <Row ss: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">31244000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29841000000</Data></Cell> </Row> <Row ss: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">24962000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23767000000</Data></Cell> </Row> <Row ss: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">6282000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6074000000</Data></Cell> </Row> <Row ss: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">31244000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29841000000</Data></Cell> </Row> <Row ss: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">2057000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2372000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">-573100000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-561600000</Data></Cell> </Row> <Row ss: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">156000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">154000000</Data></Cell> </Row> <Row ss: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">1639900000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1964400000</Data></Cell> </Row> <Row ss: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">-547000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-537000000</Data></Cell> </Row> <Row ss: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">26100000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">24600000</Data></Cell> </Row> <Row ss: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">-573100000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-561600000</Data></Cell> </Row> <Row ss: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">1639900000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1964400000</Data></Cell> </Row> <Row ss: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">483000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">481000000</Data></Cell> </Row> <Row ss: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">2078900000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2295400000</Data></Cell> </Row> <Row ss: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">-1924000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-513000000</Data></Cell> </Row> <Row ss: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">154900000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1782400000</Data></Cell> </Row> <Row ss: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">2330000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2643000000</Data></Cell> </Row> <Row ss: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">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">Current Inventory</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6580000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6852000000</Data></Cell> </Row> <Row ss: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">427000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">72000000</Data></Cell> </Row> <Row ss: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">255000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">295000000</Data></Cell> </Row> <Row ss: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">7062000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7623000000</Data></Cell> </Row> <Row ss: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">1822000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1906000000</Data></Cell> </Row> <Row ss: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">341000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">377000000</Data></Cell> </Row> <Row ss: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">367000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-44000000</Data></Cell> </Row> <Row ss: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">944000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">313000000</Data></Cell> </Row> <Row ss: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">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 Inventory CA</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">500000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">272000000</Data></Cell> </Row> <Row ss: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">250000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-355000000</Data></Cell> </Row> <Row ss: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">-24000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">40000000</Data></Cell> </Row> <Row ss: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">694000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">561000000</Data></Cell> </Row> <Row ss: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">127000000</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">Increase Other CL</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-16000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">36000000</Data></Cell> </Row> <Row ss: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">865000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-411000000</Data></Cell> </Row> <Row ss: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">-1059000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-924000000</Data></Cell> </Row> <Row ss: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">148000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">135000000</Data></Cell> </Row> <Row ss: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">865000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-411000000</Data></Cell> </Row> <Row ss: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">-1059000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-924000000</Data></Cell> </Row> <Row ss: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">-1924000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-513000000</Data></Cell> </Row> <Row ss: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">3007000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3286000000</Data></Cell> </Row> <Row ss: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">44000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23000000</Data></Cell> </Row> <Row ss: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">66000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">67000000</Data></Cell> </Row> <Row ss: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">-143000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-129000000</Data></Cell> </Row> <Row ss: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">-23000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-62000000</Data></Cell> </Row> <Row ss: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">-1059000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-924000000</Data></Cell> </Row> <Row ss: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">1345000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1724000000</Data></Cell> </Row> <Row ss: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">384000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">524000000</Data></Cell> </Row> <Row ss: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">1729000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2248000000</Data></Cell> </Row> <Row ss: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">-1246000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-959000000</Data></Cell> </Row> <Row ss: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">483000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1289000000</Data></Cell> </Row> <Row ss: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">-59000000</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">424000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1287000000</Data></Cell> </Row> <Row ss: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">2056000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">444000000</Data></Cell> </Row> <Row ss: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">4226000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5630000000</Data></Cell> </Row> <Row ss: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">6282000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6074000000</Data></Cell> </Row> <Row ss: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">796000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1612000000</Data></Cell> </Row> <Row ss: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">-657000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1404000000</Data></Cell> </Row> <Row ss: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">139000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-208000000</Data></Cell> </Row> <Row ss: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">694000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">738000000</Data></Cell> </Row> <Row ss: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">-811000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">44000000</Data></Cell> </Row> <Row ss: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">5588000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5336000000</Data></Cell> </Row> <Row ss: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">950000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-252000000</Data></Cell> </Row> <Row ss: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">21937000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22140000000</Data></Cell> </Row> <Row ss: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">138000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">243000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">2887000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1384000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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">24962000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23767000000</Data></Cell> </Row> <Row ss: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">90000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">203000000</Data></Cell> </Row> <Row ss: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">-85000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">105000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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">213000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1503000000</Data></Cell> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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> </Row> <Row ss: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">218000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1195000000</Data></Cell> </Row> <Row ss: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">6282000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6074000000</Data></Cell> </Row> <Row ss: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">24962000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">23767000000</Data></Cell> </Row> <Row ss: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">31244000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29841000000</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data> </Cell> <Cell ss:StyleID="header01"> <Data ss:Type="String">12/16</Data> </Cell> </Row> <Row ss: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">4.52</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.31</Data></Cell> </Row> <Row ss: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.85</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.09</Data></Cell> </Row> <Row ss: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">4.59</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.95</Data></Cell> </Row> <Row ss: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">3.03</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.95</Data></Cell> </Row> <Row ss: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">1.05</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">EBITDA 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.48</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">EBIT 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.44</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.31</Data></Cell> </Row> <Row ss: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">1.38</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.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">2.09</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">16.45</Data></Cell> </Row> <Row ss: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">2.58</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.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 1 Year EAT (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.24</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13.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">EAT 3 Year EAT (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.73</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.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">EPS Reported 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.65</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">12.91</Data></Cell> </Row> <Row ss: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 Reported 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.67</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.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">Total Div. Ex Special 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.25</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13.19</Data></Cell> </Row> <Row ss: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 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.73</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.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">Total Assets 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.08</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-0.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">Total Assets 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.07</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.92</Data></Cell> </Row> <Row ss: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">0.83</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-7.55</Data></Cell> </Row> <Row ss: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">0.50</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2.09</Data></Cell> </Row> <Row ss: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">0.88</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-4.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">Total Equity 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-1.19</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2.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">Retained Profits 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.97</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-52.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">Retained Profits 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8.04</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-19.10</Data></Cell> </Row> <Row ss: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">20.48</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-4.51</Data></Cell> </Row> <Row ss: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">7.86</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.03</Data></Cell> </Row> <Row ss: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">4.27</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-5.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 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-0.08</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">-2.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">NOPLAT 1 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.14</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">19.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">NOPLAT 3 Year (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.62</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.40</Data></Cell> </Row> <Row ss: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">-90.47</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1050.68</Data></Cell> </Row> <Row ss: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">-40.16</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">29.53</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">12/16</Data></Cell> </Row> <Row ss: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.23</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.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">EBIT Margin (%</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.19</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.84</Data></Cell> </Row> <Row ss: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">8.11</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8.68</Data></Cell> </Row> <Row ss: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">5.63</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.68</Data></Cell> </Row> <Row ss: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">3.57</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.03</Data></Cell> </Row> <Row ss: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">8.16</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">9.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">Invested Capital Turnover</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.9894</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.0645</Data></Cell> </Row> <Row ss: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">5.0500</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.0584</Data></Cell> </Row> <Row ss: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">0.7951</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.8372</Data></Cell> </Row> <Row ss: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.0548</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.1254</Data></Cell> </Row> <Row ss: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">3.2555</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.6732</Data></Cell> </Row> <Row ss: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">4.73</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.10</Data></Cell> </Row> <Row ss: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.45</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.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">Wkg Capital/Revenue (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.56</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5.40</Data></Cell> </Row> <Row ss: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">17.9811</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">18.5150</Data></Cell> </Row> <Row ss: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.6741</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.7419</Data></Cell> </Row> <Row ss: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">25.17</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">25.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">Net Gearing (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22.39</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22.45</Data></Cell> </Row> <Row ss: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">23.6437</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">28.9268</Data></Cell> </Row> <Row ss: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.9118</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.0242</Data></Cell> </Row> <Row ss: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.3285</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.3621</Data></Cell> </Row> <Row ss: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.9488</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.7247</Data></Cell> </Row> <Row ss: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.7335</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.5152</Data></Cell> </Row> <Row ss: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">5.0296</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">4.2160</Data></Cell> </Row> <Row ss: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.1662</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21.0153</Data></Cell> </Row> <Row ss: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.6163</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.6526</Data></Cell> </Row> <Row ss: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">7.01</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">7.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">Inventory/Trading Rev. (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">19.80</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">19.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">Creditors/Op. Rev. (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21.25</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">21.99</Data></Cell> </Row> <Row ss: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">111.54</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">109.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">Depreciation/Capex (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">45.61</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">52.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">Capex/Operating Rev. (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.19</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.67</Data></Cell> </Row> <Row ss: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">72.2772</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">72.1575</Data></Cell> </Row> <Row ss: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">25.5936</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">27.8331</Data></Cell> </Row> <Row ss: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">77.5717</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">80.2768</Data></Cell> </Row> <Row ss: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">2.8731</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.1276</Data></Cell> </Row> <Row ss: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">29.6159</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">30.7815</Data></Cell> </Row> <Row ss: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 Share Price</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">41.6100</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">42.1400</Data></Cell> </Row> <Row ss: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">46858310910</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">47657769460</Data></Cell> </Row> <Row ss: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">5588000000</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">5336000000</Data></Cell> </Row> <Row ss: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">52446310910</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">52993769460</Data></Cell> </Row> <Row ss: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">9.7267</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">8.8117</Data></Cell> </Row> <Row ss: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">12.7483</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">11.1707</Data></Cell> </Row> <Row ss: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">16.8192</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.1103</Data></Cell> </Row> <Row ss: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.7051</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.6875</Data></Cell> </Row> <Row ss: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.8772</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.0052</Data></Cell> </Row> <Row ss: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">14.5360</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">13.5326</Data></Cell> </Row> <Row ss: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">16.7918</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.0608</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"/> <!-- asxcode --> <Column ss:AutoFitWidth="0" ss:Width="150"/> <!-- company name --> <Column ss:AutoFitWidth="0" ss:Width="200"/> <!-- items name --> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <Column ss:StyleID="aRight01" ss:Width="100.0"/> <!-- Header--> <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">12/15</Data></Cell> <Cell ss:StyleID="header01"><Data ss:Type="String">12/16</Data></Cell> </Row> <Row ss: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.66</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">1.78</Data></Cell> </Row> <Row ss: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">5.58</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">6.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">Inventory (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">15.75</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">16.55</Data></Cell> </Row> <Row ss: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">24.42</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">22.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">Intangibles (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">46.18</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">45.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">Goodwill (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.00</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">0.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">Non Current Investments (%)</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.79</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">2.91</Data></Cell> </Row> <Row ss: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">3.62</Data></Cell> <Cell ss:StyleID="numberStyle"><Data ss:Type="Number">3.69</Data></Cell> </Row> </Table> </Worksheet> </Workbook>
