virgin blue

virgin blue - Sheet1 <?xml...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sheet1 <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" x mlns:o="urn:schemas-microsoft-com:office:office" x mlns:x="urn:schemas-microsoft-com:office:excel" x mlns:ss="urn:schemas-microsoft-com:office:spreadsheet" x mlns:html="http://www.w3.org/TR/REC-html40"> < DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> < Author>Morningstar</Author> < LastAuthor>think</LastAuthor> < LastSaved>2011-10-09T06:11:33Z</LastSaved> < Company>Morningstar Research (Thailand)</Company> < Version>11.9999</Version> < /DocumentProperties> < ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> < WindowHeight>7935</WindowHeight> < WindowWidth>15195</WindowWidth> < WindowTopX>0</WindowTopX> < WindowTopY>75</WindowTopY> < ActiveSheet>1</ActiveSheet> < ProtectStructure>False</ProtectStructure> < ProtectWindows>False</ProtectWindows> < /ExcelWorkbook> < Styles> < Style ss:ID="Default" ss:Name="Normal"> < Alignment ss:Vertical="Bottom"/> < Borders/> < Font x:Family="Swiss"/> < Interior/> < NumberFormat/> < Protection/> < /Style> < Style ss:ID="s21"> < Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> < /Style> < Style ss:ID="s22"> < Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> < Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000" s s:Bold="1"/> < Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/> < /Style> < Style ss:ID="s23"> < Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> < NumberFormat ss:Format="#,##0"/> < /Style> < Style ss:ID="s24"> < Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> < NumberFormat/> < /Style> < Style ss:ID="s25"> < Alignment ss:Vertical="Justify"/> < Font ss:FontName="Tahoma" x:Family="Swiss" ss:Bold="1" ss:Italic="1"/> < /Style> < Style ss:ID="s26"> < Alignment ss:Vertical="Justify"/> < Font ss:FontName="Tahoma" x:Family="Swiss"/> < /Style> < /Styles> < Names> < NamedRange ss:Name="Balance_sheet_Accounts" s s:RefersTo="='Standardised Accounts'!R18C1:R38C1"/> < NamedRange ss:Name="Cash_Flow_Accounts" s s:RefersTo="='Standardised Accounts'!R42C1:R52C1"/> < NamedRange ss:Name="Income_Statement_Accounts" s s:RefersTo="='Standardised Accounts'!R3C1:R14C1"/> < /Names> < Worksheet ss:Name="Profit and Loss"> < Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="25" x:FullColumns="1" x :FullRows="1" ss:DefaultRowHeight="15"> < Column ss:AutoFitWidth="0" ss:Width="150"/> < Column ss:AutoFitWidth="0" ss:Width="200.25"/> < Column ss:StyleID="s21" ss:Width="99.75" ss:Span="5"/> < Row ss:AutoFitHeight="0"> < Cell ss:StyleID="s22"><Data ss:Type="String">Standard Accounts</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">Item</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2007</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2008</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2009</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2010</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2011</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Sales</Data></Cell> < Cell><Data ss:Type="String">Operating Revenue</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2039000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2149400000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2362600000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2706600000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2955000000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Other Income</Data></Cell> < Cell><Data ss:Type="String">Other Revenue</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">127700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">198700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">272400000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">274600000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">315800000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Total Revenue Excluding Interest</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2166700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2348100000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2635000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">2981200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">3270800000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Cost of Sales (by function)</Data></Cell> < Cell><Data ss:Type="String">Operating Expenses</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-1742200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-2056700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-2570300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-2690200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-3063400000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">EBITDA</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">424500000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">291400000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">64700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">291000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">207400000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Depreciation</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-97000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-123700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-183700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-203800000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-225800000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Amortisation</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-3200000</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Depreciation and Amortization (by nature)</Data></Cell> < Cell><Data ss:Type="String">Depreciation And Amortisation</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-100200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-123700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-183700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-203800000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-225800000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">EBIT</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">324300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">167700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-119000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">87200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-18400000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Interest Revenue</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">41900000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">41900000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">26600000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">27700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">36100000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Interest Expense</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-57700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-69200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-90500000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-83900000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-84300000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Net Interest Expense or Income</Data></Cell> < Cell><Data ss:Type="String">Net Interest Expense</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-15800000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-27300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-63900000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-56200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-48200000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">PreTax Profit</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">308500000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">140400000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-182900000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">31000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-66600000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Tax Expense</Data></Cell> < Cell><Data ss:Type="String">Tax Expense</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-92700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-42700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">66200000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-13000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">27000000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Minority Interest</Data></Cell> < Cell><Data ss:Type="String">Outside Equity Interests</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Net Profit after Tax Before Abnormals</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">215800000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">97700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-116700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">18000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-39600000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Abnormals</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-43300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">3300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-28200000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Abnormal Tax</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Net Abnormals</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-43300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">3300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-28200000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Net Profit/Loss</Data></Cell> < Cell><Data ss:Type="String">Reported NPAT After Abnormals</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">215800000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">97700000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-160000000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">21300000</Data></Cell> < Cell ss:StyleID="s23"><Data ss:Type="Number">-67800000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Shares Outstanding at Period End</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Weighted Average Number Of Shares</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">EPS Adjusted (cents/share)</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">20.5</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">9.3</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">-11.1</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">0.9</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">-1.8</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">EPS After Abnormals (cents/share)</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">20.5</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">9.3</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">-15.2</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">1</Data></Cell> < Cell ss:StyleID="s24"><Data ss:Type="Number">-3.1</Data></Cell> < /Row> < /Table> < WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> < Unsynced/> < Print> < ValidPrinterInfo/> < PaperSizeIndex>9</PaperSizeIndex> < HorizontalResolution>600</HorizontalResolution> < VerticalResolution>600</VerticalResolution> < /Print> < Panes> < Pane> < Number>3</Number> < ActiveRow>20</ActiveRow> < /Pane> < /Panes> < ProtectObjects>False</ProtectObjects> < ProtectScenarios>False</ProtectScenarios> < /WorksheetOptions> < DataValidation xmlns="urn:schemas-microsoft-com:office:excel"> < Range>R2C1:R25C1</Range> < Type>List</Type> < Value>Income_Statement_Accounts</Value> < /DataValidation> < /Worksheet> < Worksheet ss:Name="Balance Sheet"> < Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="44" x:FullColumns="1" x :FullRows="1" ss:DefaultRowHeight="15"> < Column ss:AutoFitWidth="0" ss:Width="150"/> < Column ss:AutoFitWidth="0" ss:Width="200.25"/> < Column ss:StyleID="s21" ss:Width="99.75" ss:Span="4"/> < Row ss:AutoFitHeight="0"> < Cell ss:StyleID="s22"><Data ss:Type="String">Standard Accounts</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">Item</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2007</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2008</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2009</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2010</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2011</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Current Assets</Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Cash and Marketable Securities</Data></Cell> < Cell><Data ss:Type="String">Cash</Data></Cell> < Cell><Data ss:Type="String">704,000,000.00</Data></Cell> < Cell><Data ss:Type="String">603,900,000.00</Data></Cell> < Cell><Data ss:Type="String">475,900,000.00</Data></Cell> < Cell><Data ss:Type="String">814,700,000.00</Data></Cell> < Cell><Data ss:Type="String">731,300,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Trade Receivables</Data></Cell> < Cell><Data ss:Type="String">Receivables</Data></Cell> < Cell><Data ss:Type="String">55,300,000</Data></Cell> < Cell><Data ss:Type="String">79,500,000</Data></Cell> < Cell><Data ss:Type="String">100,400,000</Data></Cell> < Cell><Data ss:Type="String">125,000,000</Data></Cell> < Cell><Data ss:Type="String">199,500,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Other Current Assets</Data></Cell> < Cell><Data ss:Type="String">Prepaid Expenses</Data></Cell> < Cell><Data ss:Type="String">19,000,000.00</Data></Cell> < Cell><Data ss:Type="String">29,000,000.00</Data></Cell> < Cell><Data ss:Type="String">21,900,000.00</Data></Cell> < Cell><Data ss:Type="String">16,100,000.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Inventories</Data></Cell> < Cell><Data ss:Type="String">Inventories</Data></Cell> < Cell><Data ss:Type="String">400,000.00</Data></Cell> < Cell><Data ss:Type="String">600,000.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">5,100,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Cash and Marketable Securities</Data></Cell> < Cell><Data ss:Type="String">Investments</Data></Cell> < Cell><Data ss:Type="String">26,400,000.00</Data></Cell> < Cell><Data ss:Type="String">187,700,000.00</Data></Cell> < Cell><Data ss:Type="String">11,900,000.00</Data></Cell> < Cell><Data ss:Type="String">36,900,000.00</Data></Cell> < Cell><Data ss:Type="String">12,900,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Other Current Assets</Data></Cell> < Cell><Data ss:Type="String">NCA Held Sale</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Other Current Assets</Data></Cell> < Cell><Data ss:Type="String">Other</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">23,500,000.00</Data></Cell> < Cell><Data ss:Type="String">1,700,000.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">800,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Total Current Assets</Data></Cell> < Cell><Data ss:Type="String">805,100,000</Data></Cell> < Cell><Data ss:Type="String">924,200,000</Data></Cell> < Cell><Data ss:Type="String">611,800,000</Data></Cell> < Cell><Data ss:Type="String">992,700,000</Data></Cell> < Cell><Data ss:Type="String">949,600,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Non-Current Assets</Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Other Non-Current Assets</Data></Cell> < Cell><Data ss:Type="String">Receivables</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">300,000.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Inventories</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Other Non-Current Assets</Data></Cell> < Cell><Data ss:Type="String">Investments</Data></Cell> < Cell><Data ss:Type="String">27,600,000.00</Data></Cell> < Cell><Data ss:Type="String">30,300,000.00</Data></Cell> < Cell><Data ss:Type="String">57,600,000.00</Data></Cell> < Cell><Data ss:Type="String">65,700,000.00</Data></Cell> < Cell><Data ss:Type="String">53,300,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Non-Current Tangible Assets</Data></Cell> < Cell><Data ss:Type="String">PP&amp E</Data></Cell> < Cell><Data ss:Type="String">1,425,000,000</Data></Cell> < Cell><Data ss:Type="String">2,336,000,000</Data></Cell> < Cell><Data ss:Type="String">2,645,700,000</Data></Cell> < Cell><Data ss:Type="String">2,753,900,000</Data></Cell> < Cell><Data ss:Type="String">2,754,900,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Non-Current Intangible Assets</Data></Cell> < Cell><Data ss:Type="String">Intangibles(ExGW)</Data></Cell> < Cell><Data ss:Type="String">3,500,000.00</Data></Cell> < Cell><Data ss:Type="String">2,900,000.00</Data></Cell> < Cell><Data ss:Type="String">7,300,000.00</Data></Cell> < Cell><Data ss:Type="String">9,500,000.00</Data></Cell> < Cell><Data ss:Type="String">69,100,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Non-Current Intangible Assets</Data></Cell> < Cell><Data ss:Type="String">Goodwill</Data></Cell> < Cell><Data ss:Type="String">43,800,000.00</Data></Cell> < Cell><Data ss:Type="String">43,800,000.00</Data></Cell> < Cell><Data ss:Type="String">43,800,000.00</Data></Cell> < Cell><Data ss:Type="String">43,800,000.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Deferred Taxes - Non-Current Asset</Data></Cell> < Cell><Data ss:Type="String">Future Tax Benefit</Data></Cell> < Cell><Data ss:Type="String">700,000.00</Data></Cell> < Cell><Data ss:Type="String">700,000.00</Data></Cell> < Cell><Data ss:Type="String">700,000.00</Data></Cell> < Cell><Data ss:Type="String">6,000,000.00</Data></Cell> < Cell><Data ss:Type="String">8,000,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Other Non-Current Assets</Data></Cell> < Cell><Data ss:Type="String">Other</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">6,400,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Total NCA</Data></Cell> < Cell><Data ss:Type="String">1,500,600,000</Data></Cell> < Cell><Data ss:Type="String">2,413,700,000</Data></Cell> < Cell><Data ss:Type="String">2,755,100,000</Data></Cell> < Cell><Data ss:Type="String">2,879,200,000</Data></Cell> < Cell><Data ss:Type="String">2,891,700,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Total Assets</Data></Cell> < Cell><Data ss:Type="String">Total Assets</Data></Cell> < Cell><Data ss:Type="String">2,305,700,000</Data></Cell> < Cell><Data ss:Type="String">3,337,900,000</Data></Cell> < Cell><Data ss:Type="String">3,366,900,000</Data></Cell> < Cell><Data ss:Type="String">3,871,900,000</Data></Cell> < Cell><Data ss:Type="String">3,841,300,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Current Liabilities</Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Trade Payables</Data></Cell> < Cell><Data ss:Type="String">Account Payable</Data></Cell> < Cell><Data ss:Type="String">163,300,000.00</Data></Cell> < Cell><Data ss:Type="String">224,400,000.00</Data></Cell> < Cell><Data ss:Type="String">268,700,000.00</Data></Cell> < Cell><Data ss:Type="String">323,800,000.00</Data></Cell> < Cell><Data ss:Type="String">395,900,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell><Data ss:Type="String">Current Debt</Data></Cell> < Cell><Data ss:Type="String">Short-Term Debt</Data></Cell> < Cell><Data ss:Type="String">86,700,000.00</Data></Cell> < Cell><Data ss:Type="String">303,700,000.00</Data></Cell> < Cell><Data ss:Type="String">233,300,000.00</Data></Cell> < Cell><Data ss:Type="String">251,500,000.00</Data></Cell> < Cell><Data ss:Type="String">227,300,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Provisions</Data></Cell> < Cell><Data ss:Type="String">149,100,000.00</Data></Cell> < Cell><Data ss:Type="String">119,400,000.00</Data></Cell> < Cell><Data ss:Type="String">163,700,000.00</Data></Cell> < Cell><Data ss:Type="String">117,300,000.00</Data></Cell> < Cell><Data ss:Type="String">143,600,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">NCL Held Sale</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Other</Data></Cell> < Cell><Data ss:Type="String">332,700,000.00</Data></Cell> < Cell><Data ss:Type="String">408,200,000.00</Data></Cell> < Cell><Data ss:Type="String">493,200,000.00</Data></Cell> < Cell><Data ss:Type="String">616,300,000.00</Data></Cell> < Cell><Data ss:Type="String">699,900,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Total Curr. Liabilities</Data></Cell> < Cell><Data ss:Type="String">731,800,000</Data></Cell> < Cell><Data ss:Type="String">1,055,700,000</Data></Cell> < Cell><Data ss:Type="String">1,158,900,000</Data></Cell> < Cell><Data ss:Type="String">1,308,900,000</Data></Cell> < Cell><Data ss:Type="String">1,466,700,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Non-Current Liabilities</Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Accounts Payable</Data></Cell> < Cell><Data ss:Type="String">500,000.00</Data></Cell> < Cell><Data ss:Type="String">300,000.00</Data></Cell> < Cell><Data ss:Type="String">100,000.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">3,800,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Long-Term Debt</Data></Cell> < Cell><Data ss:Type="String">759,700,000.00</Data></Cell> < Cell><Data ss:Type="String">1,182,500,000.00</Data></Cell> < Cell><Data ss:Type="String">1,546,100,000.00</Data></Cell> < Cell><Data ss:Type="String">1,536,300,000.00</Data></Cell> < Cell><Data ss:Type="String">1,412,600,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Provisions</Data></Cell> < Cell><Data ss:Type="String">67,900,000.00</Data></Cell> < Cell><Data ss:Type="String">172,300,000.00</Data></Cell> < Cell><Data ss:Type="String">83,600,000.00</Data></Cell> < Cell><Data ss:Type="String">92,800,000.00</Data></Cell> < Cell><Data ss:Type="String">31,900,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Other</Data></Cell> < Cell><Data ss:Type="String">2,300,000.00</Data></Cell> < Cell><Data ss:Type="String">1,800,000.00</Data></Cell> < Cell><Data ss:Type="String">1,100,000.00</Data></Cell> < Cell><Data ss:Type="String">600,000.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Total NCL</Data></Cell> < Cell><Data ss:Type="String">830,400,000</Data></Cell> < Cell><Data ss:Type="String">1,356,900,000</Data></Cell> < Cell><Data ss:Type="String">1,630,900,000</Data></Cell> < Cell><Data ss:Type="String">1,629,700,000</Data></Cell> < Cell><Data ss:Type="String">1,448,300,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Total Liabilites</Data></Cell> < Cell><Data ss:Type="String">1,562,200,000</Data></Cell> < Cell><Data ss:Type="String">2,412,600,000</Data></Cell> < Cell><Data ss:Type="String">2,789,800,000</Data></Cell> < Cell><Data ss:Type="String">2,938,600,000</Data></Cell> < Cell><Data ss:Type="String">2,915,000,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Shareholders Equity</Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < Cell><Data ss:Type="String"></Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Share Capital</Data></Cell> < Cell><Data ss:Type="String">405,300,000.00</Data></Cell> < Cell><Data ss:Type="String">406,200,000.00</Data></Cell> < Cell><Data ss:Type="String">407,700,000.00</Data></Cell> < Cell><Data ss:Type="String">632,500,000.00</Data></Cell> < Cell><Data ss:Type="String">633,300,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Reserves Ex. SPR</Data></Cell> < Cell><Data ss:Type="String">-49,100,000</Data></Cell> < Cell><Data ss:Type="String">75,800,000</Data></Cell> < Cell><Data ss:Type="String">-113,900,000</Data></Cell> < Cell><Data ss:Type="String">-3,800,000</Data></Cell> < Cell><Data ss:Type="String">72,800,000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Share Prem Reserves</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Retained Earnings</Data></Cell> < Cell><Data ss:Type="String">387,300,000.00</Data></Cell> < Cell><Data ss:Type="String">443,300,000.00</Data></Cell> < Cell><Data ss:Type="String">283,300,000.00</Data></Cell> < Cell><Data ss:Type="String">304,600,000.00</Data></Cell> < Cell><Data ss:Type="String">220,200,000.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Other Equity</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Convertible Equity</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Outside Equity</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < Cell><Data ss:Type="String">0.00</Data></Cell> < /Row> < Row ss:AutoFitHeight="0"> < Cell ss:Index="2"><Data ss:Type="String">Total Equity</Data></Cell> < Cell><Data ss:Type="String">743,500,000</Data></Cell> < Cell><Data ss:Type="String">925,300,000</Data></Cell> < Cell><Data ss:Type="String">577,100,000</Data></Cell> < Cell><Data ss:Type="String">933,300,000</Data></Cell> < Cell><Data ss:Type="String">926,300,000</Data></Cell> < /Row> < /Table> < WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> < Unsynced/> < Selected/> < Panes> < Pane> < Number>3</Number> < ActiveRow>24</ActiveRow> < /Pane> < /Panes> < ProtectObjects>False</ProtectObjects> < ProtectScenarios>False</ProtectScenarios> < /WorksheetOptions> < DataValidation xmlns="urn:schemas-microsoft-com:office:excel"> < Range>R2C1:R44C1</Range> < Type>List</Type> < Value>Balance_sheet_Accounts</Value> < /DataValidation> < /Worksheet> < Worksheet ss:Name="Standardised Accounts"> < Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="52" x:FullColumns="1" x :FullRows="1"> < Column ss:AutoFitWidth="0" ss:Width="181.5"/> < Column ss:AutoFitWidth="0" ss:Width="102.75"/> < Column ss:AutoFitWidth="0" ss:Width="78.75"/> < Column ss:AutoFitWidth="0" ss:Width="76.5"/> < Column ss:AutoFitWidth="0" ss:Width="71.25"/> < Column ss:AutoFitWidth="0" ss:Width="73.5"/> < Row ss:AutoFitHeight="0" ss:Height="15"> < Cell ss:StyleID="s25"><Data ss:Type="String">Standardized Income Statements</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2007</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2008</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2009</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2010</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2011</Data></Cell> < Cell ss:Index="8" ss:StyleID="s22"><Data ss:Type="String">Standard Accounts</Data></Cell> < /Row> < Row> < Cell ss:Index="2" s s:Formula="=DSUM('Profit and Loss'!R1C1:R25C7,R[-1]C,R1C8:R2C8)"><Data s s:Type="Number">3755400041</Data></Cell> < Cell ss:Formula="=DSUM('Profit and Loss'!R1C1:R25C7,R[-1]C,R1C8:R2C8)"><Data s s:Type="Number">3089700018.6000004</Data></Cell> < Cell ss:Formula="=DSUM('Profit and Loss'!R1C1:R25C7,R[-1]C,R1C8:R2C8)"><Data s s:Type="Number">1670199973.7</Data></Cell> < Cell ss:Formula="=DSUM('Profit and Loss'!R1C1:R25C7,R[-1]C,R1C8:R2C8)"><Data s s:Type="Number">3194300001.9000001</Data></Cell> < Cell ss:Formula="=DSUM('Profit and Loss'!R1C1:R25C7,R[-1]C,R1C8:R2C8)"><Data s s:Type="Number">2915799995.0999999</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Sales</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">2039000000</Data></Cell> < Cell><Data ss:Type="Number">2149400000</Data></Cell> < Cell><Data ss:Type="Number">2362600000</Data></Cell> < Cell><Data ss:Type="Number">2706600000</Data></Cell> < Cell><Data ss:Type="Number">2955000000</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Cost of Sales (by function)</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">-1742200000</Data></Cell> < Cell><Data ss:Type="Number">-2056700000</Data></Cell> < Cell><Data ss:Type="Number">-2570300000</Data></Cell> < Cell><Data ss:Type="Number">-2690200000</Data></Cell> < Cell><Data ss:Type="Number">-3063400000</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">SG&amp A (by function)</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row ss:AutoFitHeight="0" ss:Height="25.5"> < Cell ss:StyleID="s26"><Data ss:Type="String">Depreciation and Amortization (by nature)</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">-100200000</Data></Cell> < Cell><Data ss:Type="Number">-123700000</Data></Cell> < Cell><Data ss:Type="Number">-183700000</Data></Cell> < Cell><Data ss:Type="Number">-203800000</Data></Cell> < Cell><Data ss:Type="Number">-225800000</Data></Cell> < /Row> < Row ss:AutoFitHeight="0" ss:Height="25.5"> < Cell ss:StyleID="s26"><Data ss:Type="String">Other Operating Income, Net of Other Operating Expenses (by function)</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Net Interest Expense or Income</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">-15800000</Data></Cell> < Cell><Data ss:Type="Number">-27300000</Data></Cell> < Cell><Data ss:Type="Number">-63900000</Data></Cell> < Cell><Data ss:Type="Number">-56200000</Data></Cell> < Cell><Data ss:Type="Number">-48200000</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Investment Income</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Other Income</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">127700000</Data></Cell> < Cell><Data ss:Type="Number">198700000</Data></Cell> < Cell><Data ss:Type="Number">272400000</Data></Cell> < Cell><Data ss:Type="Number">274600000</Data></Cell> < Cell><Data ss:Type="Number">315800000</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Other Expense</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Tax Expense</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">-92700000</Data></Cell> < Cell><Data ss:Type="Number">-42700000</Data></Cell> < Cell><Data ss:Type="Number">66200000</Data></Cell> < Cell><Data ss:Type="Number">-13000000</Data></Cell> < Cell><Data ss:Type="Number">27000000</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Minority Interest</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Net Profit/Loss</Data><NamedCell s s:Name="Income_Statement_Accounts"/></Cell> < Cell><Data ss:Type="Number">215800000</Data></Cell> < Cell><Data ss:Type="Number">97700000</Data></Cell> < Cell><Data ss:Type="Number">-160000000</Data></Cell> < Cell><Data ss:Type="Number">21300000</Data></Cell> < Cell><Data ss:Type="Number">-67800000</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"/> < /Row> < Row ss:AutoFitHeight="0" ss:Height="15"> < Cell ss:StyleID="s25"><Data ss:Type="String">Standardized Balance Sheets</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2007</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2008</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2009</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2010</Data></Cell> < Cell ss:StyleID="s22"><Data ss:Type="String">FY 2011</Data></Cell> < Cell ss:Index="8" ss:StyleID="s22"><Data ss:Type="String">Standard Accounts</Data></Cell> < /Row> < Row> < Cell ss:Index="2" s s:Formula="=DSUM('Balance Sheet'!R1C1:R44C7,R[-1]C,R16C8:R17C8)"><Data s s:Type="Number">0</Data></Cell> < Cell ss:Formula="=DSUM('Balance Sheet'!R1C1:R44C7,R[-1]C,R16C8:R17C8)"><Data s s:Type="Number">0</Data></Cell> < Cell ss:Formula="=DSUM('Balance Sheet'!R1C1:R44C7,R[-1]C,R16C8:R17C8)"><Data s s:Type="Number">0</Data></Cell> < Cell ss:Formula="=DSUM('Balance Sheet'!R1C1:R44C7,R[-1]C,R16C8:R17C8)"><Data s s:Type="Number">0</Data></Cell> < Cell ss:Formula="=DSUM('Balance Sheet'!R1C1:R44C7,R[-1]C,R16C8:R17C8)"><Data s s:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Cash and Marketable Securities</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Trade Receivables</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Inventories</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Deferred Taxes - Current Asset</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Other Current Assets</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Non-Current Tangible Assets</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Non-Current Intangible Assets</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Deferred Taxes - Non-Current Asset</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Other Non-Current Assets</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Total Assets</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Current Debt</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Trade Payables</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Other Current Liabilities</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Deferred Taxes - Current Liability</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Non-Current Debt</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Deferred Taxes - Non-Current Liability</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row ss:AutoFitHeight="0" ss:Height="25.5"> < Cell ss:StyleID="s26"><Data ss:Type="String">Other Non-Current Liabilities (non interest bearing)</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Minority Interest</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Preference Shares</Data><NamedCell s s:Name="Balance_sheet_Accounts"/></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < Cell><Data ss:Type="Number">0</Data></Cell> < /Row> < Row> < Cell ss:StyleID="s26"><Data ss:Type="String">Ordinary Shareholders' Equity</Data><NamedCell Page 1 ...
View Full Document

Ask a homework question - tutors are online