Hello

Question 1. Please solve for the gross margin profitability ratio using the statements below and show cell work in excel format.

Not sure if all sheets are necessary but this is the information that was provided.

1- Profitability Ratios Gross Margin (Solve for Gross Margin Profitability Ratio)

INCOME STATEMENT

BALANCE SHEET

CASH FLOW

of Revenue 2018 2017 2016 2015 2014 16,753,000,000 15,110,000,000 12,318,000,000 11,327,000,000 10,320,000,000 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000 25,156,000,000 22,082,000,000 17,668,000,000 15,918,000,000 14,524,000,000 -5,491,000,000 -4,565, 1,565,000,000 -3,409,000,000 -2,861,000,000 -2,592,000,000 944,000,000 841,000,000 823,000,000 823,000,000 770,000 -3,856,000,000 -3,248,000,000 -2,764,000,000 -2,553,000,000 -2,382,000,000 -3,170,000,000 -2,628,000,000 -2,226,000,000 -2,079,000,000 -1,875,000,000 -686,000,000 -620,000,000 -538,000,000 . -474,000,000 -507,000,000 -3,192,000,000 -2,947,000,000 -2,556,000,000 -2,249,000,000 -2,170,000,000 -2,579,000,000 -2,391,000,000 -2,054,000,000 -1,755,000,000 -1,735,000,000 -1,145,000,000 -1,060,000,000 -796,000,000 -547,000,000 -507,000,000 -446,000,000 -409,000,000 -389,000,000 -336,000,000 -328,000,000 -446,000,000 -409,000,000 -389.000.000 -336,000.000 -328,000,000 -988,000,000 -922,000,000 -869,000,000 -872.000.000 -900,000,000 -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000 -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000 13,561,000,000 12,163,000,000 9,762,000,000 9,078,000,000 8,150,000,000 -755,000,000 -469,000,000 -1,750,000,000 -83,000,000 -426,000,000 -612,000,000 -563,000,000 -427,000,000 -612,000,000 -563,000,000 -427,000,000 -612,000,000 -563,000,000 -427,000,000 Name Gross Profit Total Revenue Business Revenue Sales Return and Allowances/Discounts Other Revenue Cost of Staff Cost, Cost of Revenue Other Cost of Revenue Operating Income/Expenses Selling, General and Administrative Expenses General and Administrative Expenses Legal, Accounting, Auditing and Consulting Fees Other Professional Accounting and Consulting Fees Selling and Marketing Expenses Depreciation, Amortization and Depletion Depreciation and Amortization Total Operating Profit/Loss Non-Operating Income/Expenses, Total Total Net Finance Income/Expense Net Interest Income/Expense Interest Expense Net of Capitalized Interest Net Investment Income Dividend and Investment Income Gain/Loss on Investments and Other Financial Instruments Fair Value or Unrealized Gain/Loss on Financial Assets Income from Associates, Joint Ventures and Other Participating Interests Other Investment Income Irregular Income/Expenses Litigation Income/Expense Other Irregular Income/Expenses Impairment/ Write Off/Write Down of Other Assets Other Income/Expense, Non-Operating Pretax Income Provision for Income Tax Net Income from Continuing Operations Net Income after Extraordinary Items and Discontinued Operations Net Income after Non-Controlling/Minority Interests Net Income Available to Common Stockholders Net Income Available to Common Stockholders Other Adjustments to Net Income Available to Common Stockholders to Earnings Non-Controlling/Minority Interests Reported Total Revenue Reported Operating Expense Reported Total Operating Profit/Loss Reported Normalized Income Reported Effective Tax Rate Reported Normalized Operating Profit Fiscal year ends in Sep 30 USD -607,000,000 -19,000,000 -1,879,000,000 -14,000,000 -453,000,000 -607,000,000 - 19,000,000 -2,000,000 -14,000,000 -453,000,000 07 0 -1,877,000,000 464,000,000 113,000,000 556,000,000 -69,000,000 27,000,000 12,806,000,000 11,694,000,000 8,012,000,000 8,995,000,000 7,724,000,000 -2,505,000,000 -4,995,000,000 -2,021,000,000 -2,667,000,000 -2,286,000,000 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000 10,301,000,000' 6,699,000,000' 5,991,000,000' 6,328,000,000 5,438,000,000 10,301,000,000' 6,699,000,000' 5,991,000,000 6,328,000,000' 5,438,000,000 9,942,000,000 6.467,000,000 5,929,000,000 6313,000,000 5,421,000,000 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000 -359,000,000 -232,000,000 -62,000,000 -15,000,000 -17,000,000 359,000,000 232,000,000 62,000,000 15,000,000 17,000,000 0 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000 7,655,000,000 -6,214,000,000 -7,199,000,000 -4,816,000,000 -5,005,000,000 12,954,000,000 12,144,000,000 7,883,000,000 9,064,000,000 7,697,000,000 10,729,000,000 8,335,000,000 6,862,000,000' 6,438,000,000' 5,721,000,000 0 0 07 13,749,000,000 Diluted Net Dilution 0 0 2014 Restricted or Pledged, Current 803,000,000 031 000 000 Name 2018 2017 2016 2015 Total Assets 69,225,000,000 67,977,000,000 64,035,000,000 40,236,000,000 38,569,000,000 Total Current Assets 18,216,000,000 19,023,000,000 14,313,000,000 10,892,000,000 9,562,000,000 Cash, Cash Equivalents and Short Term Investments 11,709,000,000 13,438,000,000 8,938,000,000 6,015,000,000 3,950,000,000 Cash and Cash Equivalents 0,000 9,874,000,000 5,619,000,000 3,518,000,000 1,971,000,000 Short Term Investments 3,547,000,000 3,564,000,000 3,319,000,000 2,497,000,000 1,979,000,000 Trading/Listed Investments, Current 98,000,000 82,000,000 71.000.000 66,000,000 69,000,000 0:00:00 Available-for-Sale Securities, Current 3,449,000,000 3,482,000,000 3,248,000,000 2,431,000,000 1,910,000,000 Cash Restricted or 2,815,000,000 2,137,000,000 2,028,000,000 2,095,000,000 2,459,000,000 Trade and Other Receivables, Current 2,790,000,000 2,554,000,000 2,740,000,000 1,332,000,000 1,699,000,000 Trade/Accounts Receivable, Current 1,208,000,000 1,132,000,000 1,041,000,000 847,000,000 822,000,000 Other Receivables, Current 1,582,000,000 1,422,000,000 1,467,000,000 408,000,000 786,000,000 Taxes Receivable, Current 232,000,000 77,000,000 91.000.000 Prepayments and Deposits, Current 562,000,000 550,000,000 151,000,000 137,000,000 103,000,000 Other Current Assets 340,000,000 344,000,000 406,000,000 366.000.000 283,000,000 Derivative Investment and Hedging Assets, Current 50,000,000 76,000,000 40,000,000 Deferred Tax Assets, Current 871,000,000 1,028,000,000 Deferred Costs/Assets, Current Total Non-Current Assets 51,009,000,000 48,954,000,000 49,722,000,000 29,344,000,000 29,007,000,000 Net Property, Plant and Equipment 2,472,000,000 2,253,000,000 2,150,000,000 1,888,000,000 1,892,000,000 Gross Property, Plant and Equipment 5,697,000,000 5,143,000,000 4,798,000,000 4,283,000,000 3,915,000,000 Properties 967,000,000 937,000,000 913,000,000 874,000,000 858,000,000 Land and Improvements 69,000,000 72,000,000 74,000,000 71,000,000 71,000,000 Buildings and Improvements 898,000,000 865,000,000 839,000,000 787,000,000 Machinery, Furniture and Equipment 4,577,000,000 4,067,000,000 3,760,000,000 3,289,000,000 2,981,000,000 Furniture, Fixtures and Office Equipment 4,577,000,000 4,067,000,000 3,760,000,000 3,289,000,000 2,981,000,000 Construction in Progress and Advance Payments 153,000,000 139,000,000 125,000,000 120,000,000 76,000,000 Accumulated Depreciation and Impairment -3,225,000,000 -2,890,000,000 -2,648,000,000 -2,395,000,000 -2,023,000,000 Accumulated Depreciation -3,225,000,000 -2,890,000,000 -2,648,000,000 -2,395,000,000 -2,023,000,000 Net Intangi Ass 42,752,000,000 42,958,000,000 42,300,000,000 23,186,000,000 23,164,000,000 Gross Goodwill and Other Intangible Assets 43,225,000,000 43,376,000,000 42,679,000,000 23,525,000,000 23,440,000,000 Goodwill 15,194,000,000 15,110,000,000 15,066,000,000 11,825,000,000 11,753,000,000 Intangibles other than Goodwill 28,031,000,000 28,266,000,000 27,613,000,000 11,700,000,000 11,687,000,000 Trademarks and Patents 4,283,000,000 4,279,000,000 4,276,000,000 192,000,000 192,000,000 Customer Relationships 23,636,000,000 23,875,000,000 23,224,000,000 339,000,000 Other Intangible Assets 112,000,000 112,000,000 113,000,000 11,157,000,000 11,156,000,000 Licenses and Rights Accumulated Amortization and Impairment -473,000,000 -418,000,000 -379,000,000 -339,000,000 -276,000,000 Accumulated Amortization of Intangible Assets -473,000,000 -418,000,000 -379,000,000 -339,000,000 -276.000,000 Accumulated Amortization of Intangibles other than Goodwill -473,000,000 -418.000.000 -379,000,000 -339,000,000 -276,000,000 Accumulated Amortization of Trademarks and Patents -106,000,000 -93,000,000 -80,000,000 -67,000,000 -54,000,000 Accumulated Amortization of Customer Relationships -274,000,000 -237,000,000 -220,000,000 -196,000,000 -162,000,000 Accumulated Amortization of Other Intangible Assets -93,000,000 -88,000,000 -79,000,000 -76,000,000 -60,000,000 Total Long Term Investments 4,082,000,000 1,926,000,000 3,977,000,000 3,429,000,000 3,050,000,000 Investment in Financial Assets, Non-Current 4,082,000,000 1,926,000,000 3,931,000,000 3,384,000,000 2015,000,000 Financial Investment Securities, Available-for-Sale & Held-to-Maturity, Non-Current 4,082,000,000 1,926,000,000 3,931, ,384,000,000 3,015,000,000 Available-for-Sale Securities, Non-Current 4,082,000,000 1,926,000,000 3,931,000,000 3,384,000,000 3,015,000,000 Other Investments, ents, Non-Current 25 000 000 46,000,000 45,000,000 35,000,000 Other Non-Current Assets 1,703,000,000 1,817,000,000 448,000,000 110,000,000 24 000 000 81,000,000 Trade and Other Receivables, Non-Current 731,000,000 627,000,000 597,000,000 Taxes Receivable, Non-Current 731,000,000 627,000,000 597,000,000 Prepayments and Deposits, Non-Current 72,000,000 57,000,000 51,000,000 Prepayments, Non-Current 72,000,000 57,000,000 51,000,000 Deferred Tax Assets, Non-Current 22,000,000 11,000,000 8,000,000 Pension and Other Employee Benefits, Non-Current 22,000,000 36,000,000 164,000,000 Cash Restricted or Pledged, Non-Current 351,000,000 Cash Restricted or Pledged, Non-Current Total Liabilities Total Current Liabilities Payables and Accrued Expenses, Current Trade and Other Payables, Current Trade/Accounts Payable, Current Other Payable, Current Interest Payable, Current Taxes Payable, Current Accrued Expenses, Current Provisions, Current Provision for Employee Entitlements, Current Deferred Liabilities, Current Other Deferred Liabilities, Current Deferred Income/Customer Advances/Billings in Excess of Cost, Current Other Current Liabilities Financial Liabilities, Current Current Debt and Capital Lease Obligation Current Portion of Long Debt and Capital Lease Current Portion of Long Term Debt Other Current Portion of LT Debt Derivative and Hedging Liabilities, Current Total Non-Current Liabilities Financial Liabilities, Non-Current Long Term Debt and Capital Lease Obligation Long Term Debt Notes Payables, Non-Current Tax Liabilities, Non-Current Deferred Tax Liabilities, Non-Current Other Non-Current Liabilities Deferred Liabilities, Non-Current Other Deferred Liabilities, Non-Current Provisions, Non-Current Provision for Employee Entitlements, Non-Current Pension and Other Post-Retirement Benefit Plans, Non-Current Payables and Accrued Expenses, Non-Current Trade and Other Payables, Non-Current Taxes Payable, Non-Current Accrued Expenses, Non-Current Total Equity Equity Attributable to Parent Stockholders Paid in Capital Capital Stock Common Stock Common Stock, with Par Value Preferred Stock Additional Paid Capital/Share Premium Treasury Stock Retained Earnings/Accumulated Deficit Reserves/Accumulated Comprehensive Income/Losses Cumulative Foreign Exchange Translation Reserves/Accum. Comp. Inc Available for Sale Financial Investments Reserves/Accum. Comp. Inc Gain/Loss from Cash Flow Hedges Reserves/Accum. Comp. Inc Pension and Other Post-Retirement Benefit Plans Reserves/Accum. Comp. Inc Other Equity Interest Non-Controlling/Minority Interests Common Shares Issued Common Shares Outstanding Common Shares Treasury Fiscal year ends in Sep 30 USD 35,219,000,000 35,217,000,000 31,123,000,000 10,394,000,000 11,156,000,000 11,305,000,000 9,994,000,000 8,046,000,000 5,374,000,000 6,006,000,000 4,945,000,000 3,990,000,000 3,913,000,000 2,263,000,000 3,218,000,000 2,351,000,000 2,574,000,000 2,585,000,000 982,000,000 1,552,000,000 183,000,000 179,000,000 203,000,000 127,000,000 147,000,000 2,168,000,000 2,003,000,000 2,084,000,000 780,000,000 1,332,000,000 149,000,000 145,000,000 243,000,000 153,000,000 75.000.000 73.000.000 2,594,000,000 1,416,000,000 1,328,000,000 1,281,000,000 1,666,000,000 901,000,000 757,000,000 673,000,000 503,000,000 450,000,000 901,000,000 757,000,000 673,000,000 503,000,000 450,000,000 1,300,000,000 81,000,000 82,000,000 1,300,000,000 81,000,000 82,000,000 4,159,000,000 3,498,000,000 3,460,000,000 2,272,000,000 2,111,000,000 0 1,749,000,000 0 255,000,000 145,000,000 0 1,749,000,000 1,749,000,000 1,749,000,000 1,749,000,000 0 255,000,000 145,000,000 23,914,000,000 25,223,000,000 23,077,000,000 5,020,000,000 5,150,000,000 16,630,000,000 16,618,000,000 15,882,000,000 16,630,000,000 16,618,000,000 15,882,000,000 16,630,000,000 16,618,000,000 15,882,000,000 16,630,000,000 16,618,000,000 15,882,000,000 4,618,000,000 5,980,000,000 4,808,000,000 4,123,000,000 4,145,000,000 4,618,000,000 5,980,000,000 4,808,000,000 4,123,000,000 4,145,000,000 2,666,000,000 167,000,000 114,000,000 68,000,000 58,000,000 0 1,304,000,000 1,225,000,000 0 1,304,000,000 1,225,000,000 62.000.000 137,000,000 77,000,000 92,000,000 62,000,000 137,000,000 77,000,000 92,000,000 1,092,000,000 1,092,000,000 1,092,000,000 911,000,000 911,000,000 911,000,000 752,000,000 752,000,000 752,000,000 855,000,000 855,000,000 855,000,000 34,006,000,000 32,760,000,000 32,912,000,000 29,842,000,000 27,413,000,000 34,006,000,000 32,760,000,000 32,912,000,000 29,842,000,000 27,413,000,000 22,148,000,000 22,426,000,000 22,942,000,000 18,073,000,000 18,299,000,000 22,148,000,000 22,426,000,000 23,112,000,000 18,073,000,000 18,299,000,000 0 0 0 O 0 0 0 0 5,470,000,000 5,526,000,000 5,717,000,000 0 0 16,678,000,000 16,900,000,000 17,395,000,000 18,073,000,000 18,299,000,000 0 -170,000,000 11,318,000,000 9,508,000,000 10,462,000,000 11,843,000,000 9,131,000,000 547,000,000 878,000,000 -458,000,000 -74,000,000 -17,000,000 565,000,000 917,000,000 -219,000,000 -1,000,000 -2,000,000 -17,000,000 73,000,000 36,000,000 5,000,000 31,000,000 60,000,000 -36,000,000 -50,000,000 83,000,000 38,000,000 -61,000,000 -76,000,000 -225,000,000 - 161,000,000 -84,000,000 -7,000,000 -52,000,000 -34,000,000 2,213,586,000 2,335,160,000 2,404,160,000 2,427,586,000 2,465,586,000 2,213,586,000 2,335,160,000 2,404,160,000 2,427,586,000 2,465,586,000 0 0 0 0 0 2018 2017 12,713,000,000 9,208,000,000 12,713,000,000 9,208,000,000 12,713,000,000 9,208,000,000 10,301,000,000 6,699,000,000 5,069,000,000 7,089,000,000 613,000,000 556,000,000 613,000,000 556,000,000 327,000,000 235,000,000 -1,277,000,000 1,700,000,000 0 192,000,000 0 192,000,000 2016 2015 2014 5,574,000,000 14,000,000 5,000,000 5,574,000,0004,000,000 5,000,000 5,574,000,000:4,000,000 5,000,000 5,991,000,000:8,000,000 8,000,000 3,109,000,00011,000,000 9,000,000 502,000,000 14,000,000 5,000,000 502,000,00014,000,000 5,000,000 221,000,00017,000,000 2,000,000 -764,000,000 15,000,000,0,000,000 5,491,000,000 4,565,000,000 -85,000,000 -159,000,000 0 0 0 0 0 0 3,409,000,000 1,000,000 2,000,000 55,000,000:4,000,000 7,000,000 -63,000,000 14,000,000 10,000,000 -255,000,000 0,000,000 -255,000,000 0,000,000 4,000,000 4,000,000 3,000,000 -2,657,000,000 -4,580,000,000 -3,526,000,000 15,000,000 2,000,000 -293,000,000 40,000,000 326,000,000 19,000,000 1,000,000 -70,000,000 -54,000,000 -65,000,000 9,000,000 3,000,000 -223,000,000 94.000.000 391,000,000 8,000,000 3,000,000 11,000,000 -4,842,000,000 -4.880,000,000 -3,823,000,000 1,000,000 5,000,000 2,478,000,000 260,000,000 -29,000,000 13,000,000 2,000,000 265,000,000 -206,000,000 -259,000,000 15,000,000 1,000,000 3,000,000 -30,000,000 43,000,000 3,000,000 6,000,000 262,000,000 -176,000,000 -302,000,000 2,000,000 7,000,000 2,213,000,000 466,000,000 230,000,000!8,000,000 1,000,000 Name Cash Flow from Operating Activities, Indirect Net Cash Flow from Continuing Operating Activities, Indirect Cash Generated from Operating Activities Income/Loss before Non-Cash Adjustment Total Adjustments for Non-Cash Items Depreciation, Amortization and Depletion, Non-Cash Adjustment Depreciation and Amortization, Non-Cash Adjustment Stock-Based Compensation, Non-Cash Adjustment Taxes, Non-Cash Adjustment Irregular Income/Loss, Non-Cash Adjustment Other Irregular Income/Loss, Non-Cash Adjustment Gain/Loss on Disposals, Non-Cash Adjustment Impairment/Write Off/Write Down of Capital Assets Loss/Reversal, Non-Cash Adjustment Other Operating Gain/Loss, Non-Cash Adjustment Other Non-Cash Items Excess Tax Benefit from Stock-Based Compensation, Non-Cash Adjustment Net Investment Income/Loss, Non-Cash Adjustment Unrealized Gain/Loss on Financial Instruments, Non-Cash Adjustment Gain/Loss on Financial Instruments, Non-Cash Adjustment Share of Profit/Loss from Associates, Joint Ventures and other Equity Investments, Non-Cash Adjustment Other Provisions, Non-Cash Adjustment Amortization of Securities, Non-Cash Adjustment Interest and Finance Income/Expenses, Non-Cash Adjustment Changes in Operating Capital Change in Trade and Other Receivables Change in Trade/Accounts Receivable Change in Other Receivables Change in Tax Receivables Change in Other Current Assets Change in Payables and Accrued Expenses Change in Trade and Other Payables Change in Trade/Accounts Payable Change in Other Payables Change in Accrued Expenses Change in Other Operating Capital Cash Flow from Investing Activities Cash Flow from Continuing Investing Activities Capital Expenditure, Reported Purchase/Sale and Disposal of Property, Plant and Equipment, Net Sale and Disposal of Property, Plant and Equipment Purchase of Property, Plant and Equipment Purchase/Sale of Business, Net Purchase/Acquisition of Business Purchase/Sale of Investments, Net Purchase of Investments Sale of Investments Other Investing Cash Flow Dividends Received/Paid, CFI Cash Flow from Financing Activities Cash Flow from Continuing Financing Activities Issuance of/Payments for Common Stock, Net Payments for Common Stock Issuance of/Repayments for Debt, Net Issuance of/Repayments for Long Term Debt, Net Proceeds from Issuance of Long Term Debt Repayments for Long Term Debt Issue and Financing Costs Debt Issuance Costs Cash Dividends and Interest Paid Cash Dividends Paid Preferred Stock Dividends Paid Common Stock Dividends Paid Proceeds from Issuance/Exercising of Stock Options/Warrants Other Financing Cash Flow Excess Tax Benefit from Share-Based Compensation, Financing Activities Issuance of/Repayments for Lease Financing Repayments for Lease Financing Cash and Cash Equivalents, End of Period Change in Cash Effect of Exchange Rate Changes Cash and Cash Equivalents, Beginning of Period Change in Cash As Reported, Supplemental Income Tax Paid, Supplemental Interest Paid, Supplemental -3,084,000,000 735,000,000 -10,916,000,000 5,000,000 1,000,000 -3,084,000,000 735,000,000 -10,916,000,000 15,000,000 1,000,000 -718,000,000 -707,000,000 -523,000,000 4,000,000 3,000,000 14,000,000 12,000,000 00,000,000 0 14,000,000 12,000,000 00,000,000 0 - 196,000,000 -302,000,000 -9,082,000,000 13,000,000-9,000,000 -196,000,000 -302,000,000 -9,082,000,000 13,000,000-9,000,000 -2,184,000,000 1,732,000,000 -1,311,000,000 8,000,000:9,000,000 -5,822,000,000 -3,284,000,000 -28,014,000,0005,000,000:1,000,000 3,638,000,000 5,016,000,000 26,703,000,000 17,000,000 2,000,000 w -11,240,000,000 -5,924,000,000 7,477,000,000 13,000,000 8,000,000 -11,240,000,000 -5,924,000,000 7,477,000,00013,000,000 8,000,000 -7,192,000,000 -6,891,000,000 -7,157,000,000 0,000,000 8,000,000 -7,192,000,000 -6,891,000,000 -7,157,000,000 0,000,000 8,000,000 -1,750,000,000 2,488,000,000 15,971,000,000 -1,750,000,000 2,488,000,000 15,971,000,000 0 2,488,000,000 15,971,000,000 -1,750,000,000 0 -15,000,000 -98,000,000 07 -15,000,000 -98,000,000 -1,918,000,000 -1,579,000,000 -1,350,000,000 7,000,000 6,000,000 -1,918,000,000 -1,579,000,000 -1,350,000,000 7,000,000 6,000,000 -1,579,000,000 7,000,000 16,000,000 164,000,000 149,000,000 95,000,000 2,000,000 1,000,000 -544,000,000 -76,000,000 -47,000,000 8,000,000 5,000,000 0 0 63,000,000 14,000,000 10,000,000 0 0 0 0 8,162,000,000 9,874,000,000' 5,619,000,000 8,000,000 1,000,000 -1,611,000,000 4,019,000,000' 2,135,000,000 6,000,000 4,000,000 -101,000,000 236,000,000 -34,000,000 1,000,000 1,000,000 9,874,000,000 5,619,000,000 3,518,000,000 1,000,000 6,000,000 -1,712,000,000 4,255,000,000' 2,101,000,0007,000,000 5,000,000 -2,285,000,000 -3,038,000,000 -2.842,000,000 16,000,000 6,000,000 -545,000,000 -489,000,000 -244,000,000 of Revenue 2018 2017 2016 2015 2014 16,753,000,000 15,110,000,000 12,318,000,000 11,327,000,000 10,320,000,000 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000 25,156,000,000 22,082,000,000 17,668,000,000 15,918,000,000 14,524,000,000 -5,491,000,000 -4,565, 1,565,000,000 -3,409,000,000 -2,861,000,000 -2,592,000,000 944,000,000 841,000,000 823,000,000 823,000,000 770,000 -3,856,000,000 -3,248,000,000 -2,764,000,000 -2,553,000,000 -2,382,000,000 -3,170,000,000 -2,628,000,000 -2,226,000,000 -2,079,000,000 -1,875,000,000 -686,000,000 -620,000,000 -538,000,000 . -474,000,000 -507,000,000 -3,192,000,000 -2,947,000,000 -2,556,000,000 -2,249,000,000 -2,170,000,000 -2,579,000,000 -2,391,000,000 -2,054,000,000 -1,755,000,000 -1,735,000,000 -1,145,000,000 -1,060,000,000 -796,000,000 -547,000,000 -507,000,000 -446,000,000 -409,000,000 -389,000,000 -336,000,000 -328,000,000 -446,000,000 -409,000,000 -389.000.000 -336,000.000 -328,000,000 -988,000,000 -922,000,000 -869,000,000 -872.000.000 -900,000,000 -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000 -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000 13,561,000,000 12,163,000,000 9,762,000,000 9,078,000,000 8,150,000,000 -755,000,000 -469,000,000 -1,750,000,000 -83,000,000 -426,000,000 -612,000,000 -563,000,000 -427,000,000 -612,000,000 -563,000,000 -427,000,000 -612,000,000 -563,000,000 -427,000,000 Name Gross Profit Total Revenue Business Revenue Sales Return and Allowances/Discounts Other Revenue Cost of Staff Cost, Cost of Revenue Other Cost of Revenue Operating Income/Expenses Selling, General and Administrative Expenses General and Administrative Expenses Legal, Accounting, Auditing and Consulting Fees Other Professional Accounting and Consulting Fees Selling and Marketing Expenses Depreciation, Amortization and Depletion Depreciation and Amortization Total Operating Profit/Loss Non-Operating Income/Expenses, Total Total Net Finance Income/Expense Net Interest Income/Expense Interest Expense Net of Capitalized Interest Net Investment Income Dividend and Investment Income Gain/Loss on Investments and Other Financial Instruments Fair Value or Unrealized Gain/Loss on Financial Assets Income from Associates, Joint Ventures and Other Participating Interests Other Investment Income Irregular Income/Expenses Litigation Income/Expense Other Irregular Income/Expenses Impairment/ Write Off/Write Down of Other Assets Other Income/Expense, Non-Operating Pretax Income Provision for Income Tax Net Income from Continuing Operations Net Income after Extraordinary Items and Discontinued Operations Net Income after Non-Controlling/Minority Interests Net Income Available to Common Stockholders Net Income Available to Common Stockholders Other Adjustments to Net Income Available to Common Stockholders to Earnings Non-Controlling/Minority Interests Reported Total Revenue Reported Operating Expense Reported Total Operating Profit/Loss Reported Normalized Income Reported Effective Tax Rate Reported Normalized Operating Profit Fiscal year ends in Sep 30 USD -607,000,000 -19,000,000 -1,879,000,000 -14,000,000 -453,000,000 -607,000,000 - 19,000,000 -2,000,000 -14,000,000 -453,000,000 07 0 -1,877,000,000 464,000,000 113,000,000 556,000,000 -69,000,000 27,000,000 12,806,000,000 11,694,000,000 8,012,000,000 8,995,000,000 7,724,000,000 -2,505,000,000 -4,995,000,000 -2,021,000,000 -2,667,000,000 -2,286,000,000 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000 10,301,000,000' 6,699,000,000' 5,991,000,000' 6,328,000,000 5,438,000,000 10,301,000,000' 6,699,000,000' 5,991,000,000 6,328,000,000' 5,438,000,000 9,942,000,000 6.467,000,000 5,929,000,000 6313,000,000 5,421,000,000 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000 -359,000,000 -232,000,000 -62,000,000 -15,000,000 -17,000,000 359,000,000 232,000,000 62,000,000 15,000,000 17,000,000 0 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000 7,655,000,000 -6,214,000,000 -7,199,000,000 -4,816,000,000 -5,005,000,000 12,954,000,000 12,144,000,000 7,883,000,000 9,064,000,000 7,697,000,000 10,729,000,000 8,335,000,000 6,862,000,000' 6,438,000,000' 5,721,000,000 0 0 07 13,749,000,000 Diluted Net Dilution 0 0 2014 Restricted or Pledged, Current 803,000,000 031 000 000 Name 2018 2017 2016 2015 Total Assets 69,225,000,000 67,977,000,000 64,035,000,000 40,236,000,000 38,569,000,000 Total Current Assets 18,216,000,000 19,023,000,000 14,313,000,000 10,892,000,000 9,562,000,000 Cash, Cash Equivalents and Short Term Investments 11,709,000,000 13,438,000,000 8,938,000,000 6,015,000,000 3,950,000,000 Cash and Cash Equivalents 0,000 9,874,000,000 5,619,000,000 3,518,000,000 1,971,000,000 Short Term Investments 3,547,000,000 3,564,000,000 3,319,000,000 2,497,000,000 1,979,000,000 Trading/Listed Investments, Current 98,000,000 82,000,000 71.000.000 66,000,000 69,000,000 0:00:00 Available-for-Sale Securities, Current 3,449,000,000 3,482,000,000 3,248,000,000 2,431,000,000 1,910,000,000 Cash Restricted or 2,815,000,000 2,137,000,000 2,028,000,000 2,095,000,000 2,459,000,000 Trade and Other Receivables, Current 2,790,000,000 2,554,000,000 2,740,000,000 1,332,000,000 1,699,000,000 Trade/Accounts Receivable, Current 1,208,000,000 1,132,000,000 1,041,000,000 847,000,000 822,000,000 Other Receivables, Current 1,582,000,000 1,422,000,000 1,467,000,000 408,000,000 786,000,000 Taxes Receivable, Current 232,000,000 77,000,000 91.000.000 Prepayments and Deposits, Current 562,000,000 550,000,000 151,000,000 137,000,000 103,000,000 Other Current Assets 340,000,000 344,000,000 406,000,000 366.000.000 283,000,000 Derivative Investment and Hedging Assets, Current 50,000,000 76,000,000 40,000,000 Deferred Tax Assets, Current 871,000,000 1,028,000,000 Deferred Costs/Assets, Current Total Non-Current Assets 51,009,000,000 48,954,000,000 49,722,000,000 29,344,000,000 29,007,000,000 Net Property, Plant and Equipment 2,472,000,000 2,253,000,000 2,150,000,000 1,888,000,000 1,892,000,000 Gross Property, Plant and Equipment 5,697,000,000 5,143,000,000 4,798,000,000 4,283,000,000 3,915,000,000 Properties 967,000,000 937,000,000 913,000,000 874,000,000 858,000,000 Land and Improvements 69,000,000 72,000,000 74,000,000 71,000,000 71,000,000 Buildings and Improvements 898,000,000 865,000,000 839,000,000 787,000,000 Machinery, Furniture and Equipment 4,577,000,000 4,067,000,000 3,760,000,000 3,289,000,000 2,981,000,000 Furniture, Fixtures and Office Equipment 4,577,000,000 4,067,000,000 3,760,000,000 3,289,000,000 2,981,000,000 Construction in Progress and Advance Payments 153,000,000 139,000,000 125,000,000 120,000,000 76,000,000 Accumulated Depreciation and Impairment -3,225,000,000 -2,890,000,000 -2,648,000,000 -2,395,000,000 -2,023,000,000 Accumulated Depreciation -3,225,000,000 -2,890,000,000 -2,648,000,000 -2,395,000,000 -2,023,000,000 Net Intangi Ass 42,752,000,000 42,958,000,000 42,300,000,000 23,186,000,000 23,164,000,000 Gross Goodwill and Other Intangible Assets 43,225,000,000 43,376,000,000 42,679,000,000 23,525,000,000 23,440,000,000 Goodwill 15,194,000,000 15,110,000,000 15,066,000,000 11,825,000,000 11,753,000,000 Intangibles other than Goodwill 28,031,000,000 28,266,000,000 27,613,000,000 11,700,000,000 11,687,000,000 Trademarks and Patents 4,283,000,000 4,279,000,000 4,276,000,000 192,000,000 192,000,000 Customer Relationships 23,636,000,000 23,875,000,000 23,224,000,000 339,000,000 Other Intangible Assets 112,000,000 112,000,000 113,000,000 11,157,000,000 11,156,000,000 Licenses and Rights Accumulated Amortization and Impairment -473,000,000 -418,000,000 -379,000,000 -339,000,000 -276,000,000 Accumulated Amortization of Intangible Assets -473,000,000 -418,000,000 -379,000,000 -339,000,000 -276.000,000 Accumulated Amortization of Intangibles other than Goodwill -473,000,000 -418.000.000 -379,000,000 -339,000,000 -276,000,000 Accumulated Amortization of Trademarks and Patents -106,000,000 -93,000,000 -80,000,000 -67,000,000 -54,000,000 Accumulated Amortization of Customer Relationships -274,000,000 -237,000,000 -220,000,000 -196,000,000 -162,000,000 Accumulated Amortization of Other Intangible Assets -93,000,000 -88,000,000 -79,000,000 -76,000,000 -60,000,000 Total Long Term Investments 4,082,000,000 1,926,000,000 3,977,000,000 3,429,000,000 3,050,000,000 Investment in Financial Assets, Non-Current 4,082,000,000 1,926,000,000 3,931,000,000 3,384,000,000 2015,000,000 Financial Investment Securities, Available-for-Sale & Held-to-Maturity, Non-Current 4,082,000,000 1,926,000,000 3,931, ,384,000,000 3,015,000,000 Available-for-Sale Securities, Non-Current 4,082,000,000 1,926,000,000 3,931,000,000 3,384,000,000 3,015,000,000 Other Investments, ents, Non-Current 25 000 000 46,000,000 45,000,000 35,000,000 Other Non-Current Assets 1,703,000,000 1,817,000,000 448,000,000 110,000,000 24 000 000 81,000,000 Trade and Other Receivables, Non-Current 731,000,000 627,000,000 597,000,000 Taxes Receivable, Non-Current 731,000,000 627,000,000 597,000,000 Prepayments and Deposits, Non-Current 72,000,000 57,000,000 51,000,000 Prepayments, Non-Current 72,000,000 57,000,000 51,000,000 Deferred Tax Assets, Non-Current 22,000,000 11,000,000 8,000,000 Pension and Other Employee Benefits, Non-Current 22,000,000 36,000,000 164,000,000 Cash Restricted or Pledged, Non-Current 351,000,000 Cash Restricted or Pledged, Non-Current Total Liabilities Total Current Liabilities Payables and Accrued Expenses, Current Trade and Other Payables, Current Trade/Accounts Payable, Current Other Payable, Current Interest Payable, Current Taxes Payable, Current Accrued Expenses, Current Provisions, Current Provision for Employee Entitlements, Current Deferred Liabilities, Current Other Deferred Liabilities, Current Deferred Income/Customer Advances/Billings in Excess of Cost, Current Other Current Liabilities Financial Liabilities, Current Current Debt and Capital Lease Obligation Current Portion of Long Debt and Capital Lease Current Portion of Long Term Debt Other Current Portion of LT Debt Derivative and Hedging Liabilities, Current Total Non-Current Liabilities Financial Liabilities, Non-Current Long Term Debt and Capital Lease Obligation Long Term Debt Notes Payables, Non-Current Tax Liabilities, Non-Current Deferred Tax Liabilities, Non-Current Other Non-Current Liabilities Deferred Liabilities, Non-Current Other Deferred Liabilities, Non-Current Provisions, Non-Current Provision for Employee Entitlements, Non-Current Pension and Other Post-Retirement Benefit Plans, Non-Current Payables and Accrued Expenses, Non-Current Trade and Other Payables, Non-Current Taxes Payable, Non-Current Accrued Expenses, Non-Current Total Equity Equity Attributable to Parent Stockholders Paid in Capital Capital Stock Common Stock Common Stock, with Par Value Preferred Stock Additional Paid Capital/Share Premium Treasury Stock Retained Earnings/Accumulated Deficit Reserves/Accumulated Comprehensive Income/Losses Cumulative Foreign Exchange Translation Reserves/Accum. Comp. Inc Available for Sale Financial Investments Reserves/Accum. Comp. Inc Gain/Loss from Cash Flow Hedges Reserves/Accum. Comp. Inc Pension and Other Post-Retirement Benefit Plans Reserves/Accum. Comp. Inc Other Equity Interest Non-Controlling/Minority Interests Common Shares Issued Common Shares Outstanding Common Shares Treasury Fiscal year ends in Sep 30 USD 35,219,000,000 35,217,000,000 31,123,000,000 10,394,000,000 11,156,000,000 11,305,000,000 9,994,000,000 8,046,000,000 5,374,000,000 6,006,000,000 4,945,000,000 3,990,000,000 3,913,000,000 2,263,000,000 3,218,000,000 2,351,000,000 2,574,000,000 2,585,000,000 982,000,000 1,552,000,000 183,000,000 179,000,000 203,000,000 127,000,000 147,000,000 2,168,000,000 2,003,000,000 2,084,000,000 780,000,000 1,332,000,000 149,000,000 145,000,000 243,000,000 153,000,000 75.000.000 73.000.000 2,594,000,000 1,416,000,000 1,328,000,000 1,281,000,000 1,666,000,000 901,000,000 757,000,000 673,000,000 503,000,000 450,000,000 901,000,000 757,000,000 673,000,000 503,000,000 450,000,000 1,300,000,000 81,000,000 82,000,000 1,300,000,000 81,000,000 82,000,000 4,159,000,000 3,498,000,000 3,460,000,000 2,272,000,000 2,111,000,000 0 1,749,000,000 0 255,000,000 145,000,000 0 1,749,000,000 1,749,000,000 1,749,000,000 1,749,000,000 0 255,000,000 145,000,000 23,914,000,000 25,223,000,000 23,077,000,000 5,020,000,000 5,150,000,000 16,630,000,000 16,618,000,000 15,882,000,000 16,630,000,000 16,618,000,000 15,882,000,000 16,630,000,000 16,618,000,000 15,882,000,000 16,630,000,000 16,618,000,000 15,882,000,000 4,618,000,000 5,980,000,000 4,808,000,000 4,123,000,000 4,145,000,000 4,618,000,000 5,980,000,000 4,808,000,000 4,123,000,000 4,145,000,000 2,666,000,000 167,000,000 114,000,000 68,000,000 58,000,000 0 1,304,000,000 1,225,000,000 0 1,304,000,000 1,225,000,000 62.000.000 137,000,000 77,000,000 92,000,000 62,000,000 137,000,000 77,000,000 92,000,000 1,092,000,000 1,092,000,000 1,092,000,000 911,000,000 911,000,000 911,000,000 752,000,000 752,000,000 752,000,000 855,000,000 855,000,000 855,000,000 34,006,000,000 32,760,000,000 32,912,000,000 29,842,000,000 27,413,000,000 34,006,000,000 32,760,000,000 32,912,000,000 29,842,000,000 27,413,000,000 22,148,000,000 22,426,000,000 22,942,000,000 18,073,000,000 18,299,000,000 22,148,000,000 22,426,000,000 23,112,000,000 18,073,000,000 18,299,000,000 0 0 0 O 0 0 0 0 5,470,000,000 5,526,000,000 5,717,000,000 0 0 16,678,000,000 16,900,000,000 17,395,000,000 18,073,000,000 18,299,000,000 0 -170,000,000 11,318,000,000 9,508,000,000 10,462,000,000 11,843,000,000 9,131,000,000 547,000,000 878,000,000 -458,000,000 -74,000,000 -17,000,000 565,000,000 917,000,000 -219,000,000 -1,000,000 -2,000,000 -17,000,000 73,000,000 36,000,000 5,000,000 31,000,000 60,000,000 -36,000,000 -50,000,000 83,000,000 38,000,000 -61,000,000 -76,000,000 -225,000,000 - 161,000,000 -84,000,000 -7,000,000 -52,000,000 -34,000,000 2,213,586,000 2,335,160,000 2,404,160,000 2,427,586,000 2,465,586,000 2,213,586,000 2,335,160,000 2,404,160,000 2,427,586,000 2,465,586,000 0 0 0 0 0 2018 2017 12,713,000,000 9,208,000,000 12,713,000,000 9,208,000,000 12,713,000,000 9,208,000,000 10,301,000,000 6,699,000,000 5,069,000,000 7,089,000,000 613,000,000 556,000,000 613,000,000 556,000,000 327,000,000 235,000,000 -1,277,000,000 1,700,000,000 0 192,000,000 0 192,000,000 2016 2015 2014 5,574,000,000 14,000,000 5,000,000 5,574,000,0004,000,000 5,000,000 5,574,000,000:4,000,000 5,000,000 5,991,000,000:8,000,000 8,000,000 3,109,000,00011,000,000 9,000,000 502,000,000 14,000,000 5,000,000 502,000,00014,000,000 5,000,000 221,000,00017,000,000 2,000,000 -764,000,000 15,000,000,0,000,000 5,491,000,000 4,565,000,000 -85,000,000 -159,000,000 0 0 0 0 0 0 3,409,000,000 1,000,000 2,000,000 55,000,000:4,000,000 7,000,000 -63,000,000 14,000,000 10,000,000 -255,000,000 0,000,000 -255,000,000 0,000,000 4,000,000 4,000,000 3,000,000 -2,657,000,000 -4,580,000,000 -3,526,000,000 15,000,000 2,000,000 -293,000,000 40,000,000 326,000,000 19,000,000 1,000,000 -70,000,000 -54,000,000 -65,000,000 9,000,000 3,000,000 -223,000,000 94.000.000 391,000,000 8,000,000 3,000,000 11,000,000 -4,842,000,000 -4.880,000,000 -3,823,000,000 1,000,000 5,000,000 2,478,000,000 260,000,000 -29,000,000 13,000,000 2,000,000 265,000,000 -206,000,000 -259,000,000 15,000,000 1,000,000 3,000,000 -30,000,000 43,000,000 3,000,000 6,000,000 262,000,000 -176,000,000 -302,000,000 2,000,000 7,000,000 2,213,000,000 466,000,000 230,000,000!8,000,000 1,000,000 Name Cash Flow from Operating Activities, Indirect Net Cash Flow from Continuing Operating Activities, Indirect Cash Generated from Operating Activities Income/Loss before Non-Cash Adjustment Total Adjustments for Non-Cash Items Depreciation, Amortization and Depletion, Non-Cash Adjustment Depreciation and Amortization, Non-Cash Adjustment Stock-Based Compensation, Non-Cash Adjustment Taxes, Non-Cash Adjustment Irregular Income/Loss, Non-Cash Adjustment Other Irregular Income/Loss, Non-Cash Adjustment Gain/Loss on Disposals, Non-Cash Adjustment Impairment/Write Off/Write Down of Capital Assets Loss/Reversal, Non-Cash Adjustment Other Operating Gain/Loss, Non-Cash Adjustment Other Non-Cash Items Excess Tax Benefit from Stock-Based Compensation, Non-Cash Adjustment Net Investment Income/Loss, Non-Cash Adjustment Unrealized Gain/Loss on Financial Instruments, Non-Cash Adjustment Gain/Loss on Financial Instruments, Non-Cash Adjustment Share of Profit/Loss from Associates, Joint Ventures and other Equity Investments, Non-Cash Adjustment Other Provisions, Non-Cash Adjustment Amortization of Securities, Non-Cash Adjustment Interest and Finance Income/Expenses, Non-Cash Adjustment Changes in Operating Capital Change in Trade and Other Receivables Change in Trade/Accounts Receivable Change in Other Receivables Change in Tax Receivables Change in Other Current Assets Change in Payables and Accrued Expenses Change in Trade and Other Payables Change in Trade/Accounts Payable Change in Other Payables Change in Accrued Expenses Change in Other Operating Capital Cash Flow from Investing Activities Cash Flow from Continuing Investing Activities Capital Expenditure, Reported Purchase/Sale and Disposal of Property, Plant and Equipment, Net Sale and Disposal of Property, Plant and Equipment Purchase of Property, Plant and Equipment Purchase/Sale of Business, Net Purchase/Acquisition of Business Purchase/Sale of Investments, Net Purchase of Investments Sale of Investments Other Investing Cash Flow Dividends Received/Paid, CFI Cash Flow from Financing Activities Cash Flow from Continuing Financing Activities Issuance of/Payments for Common Stock, Net Payments for Common Stock Issuance of/Repayments for Debt, Net Issuance of/Repayments for Long Term Debt, Net Proceeds from Issuance of Long Term Debt Repayments for Long Term Debt Issue and Financing Costs Debt Issuance Costs Cash Dividends and Interest Paid Cash Dividends Paid Preferred Stock Dividends Paid Common Stock Dividends Paid Proceeds from Issuance/Exercising of Stock Options/Warrants Other Financing Cash Flow Excess Tax Benefit from Share-Based Compensation, Financing Activities Issuance of/Repayments for Lease Financing Repayments for Lease Financing Cash and Cash Equivalents, End of Period Change in Cash Effect of Exchange Rate Changes Cash and Cash Equivalents, Beginning of Period Change in Cash As Reported, Supplemental Income Tax Paid, Supplemental Interest Paid, Supplemental -3,084,000,000 735,000,000 -10,916,000,000 5,000,000 1,000,000 -3,084,000,000 735,000,000 -10,916,000,000 15,000,000 1,000,000 -718,000,000 -707,000,000 -523,000,000 4,000,000 3,000,000 14,000,000 12,000,000 00,000,000 0 14,000,000 12,000,000 00,000,000 0 - 196,000,000 -302,000,000 -9,082,000,000 13,000,000-9,000,000 -196,000,000 -302,000,000 -9,082,000,000 13,000,000-9,000,000 -2,184,000,000 1,732,000,000 -1,311,000,000 8,000,000:9,000,000 -5,822,000,000 -3,284,000,000 -28,014,000,0005,000,000:1,000,000 3,638,000,000 5,016,000,000 26,703,000,000 17,000,000 2,000,000 w -11,240,000,000 -5,924,000,000 7,477,000,000 13,000,000 8,000,000 -11,240,000,000 -5,924,000,000 7,477,000,00013,000,000 8,000,000 -7,192,000,000 -6,891,000,000 -7,157,000,000 0,000,000 8,000,000 -7,192,000,000 -6,891,000,000 -7,157,000,000 0,000,000 8,000,000 -1,750,000,000 2,488,000,000 15,971,000,000 -1,750,000,000 2,488,000,000 15,971,000,000 0 2,488,000,000 15,971,000,000 -1,750,000,000 0 -15,000,000 -98,000,000 07 -15,000,000 -98,000,000 -1,918,000,000 -1,579,000,000 -1,350,000,000 7,000,000 6,000,000 -1,918,000,000 -1,579,000,000 -1,350,000,000 7,000,000 6,000,000 -1,579,000,000 7,000,000 16,000,000 164,000,000 149,000,000 95,000,000 2,000,000 1,000,000 -544,000,000 -76,000,000 -47,000,000 8,000,000 5,000,000 0 0 63,000,000 14,000,000 10,000,000 0 0 0 0 8,162,000,000 9,874,000,000' 5,619,000,000 8,000,000 1,000,000 -1,611,000,000 4,019,000,000' 2,135,000,000 6,000,000 4,000,000 -101,000,000 236,000,000 -34,000,000 1,000,000 1,000,000 9,874,000,000 5,619,000,000 3,518,000,000 1,000,000 6,000,000 -1,712,000,000 4,255,000,000' 2,101,000,0007,000,000 5,000,000 -2,285,000,000 -3,038,000,000 -2.842,000,000 16,000,000 6,000,000 -545,000,000 -489,000,000 -244,000,000