Excel Financial Ratios
For this project your team will prepare financial ratios in MS Excel using the accounting statements provided. Teams must provide the calculations for the following ratios for each company using the 2018 annual data. Calculations must be performed and submitted in an MS Excel spreadsheet.
Profitability Ratios
Gross Margin
Operating Margin
Net Profit Margin
V Income Statement
Name 2018 2017 2016 2015 2014
Gross Profit 16,753,000,000 15,110,000,000 12,318,000,000 11,327,000,000 10,320,000,000
Total Revenue 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000
Business Revenue 25,156,000,000 22,082,000,000 17,668,000,000 15,918,000,000 14,524,000,000
Sales Return and Allowances/Discounts -5,491,000,000 -4,565,000,000 -3,409,000,000 -2,861,000,000 -2,592,000,000
Other Revenue 944,000,000 841,000,000 823,000,000 823,000,000 770,000,000
Cost of Revenue -3,856,000,000 -3,248,000,000 -2,764,000,000 -2,553,000,000 -2,382,000,000
Staff Cost, Cost of Revenue -3,170,000,000 -2,628,000,000 -2,226,000,000 -2,079,000,000 -1,875,000,000
Other Cost of Revenue -686,000,000 -620,000,000 -538,000,000 -474,000,000 -507,000,000
Operating Income/Expenses -3,192,000,000 -2,947,000,000 -2,556,000,000 -2,249,000,000 -2,170,000,000
Selling, General and Administrative Expenses -2,579,000,000 -2,391,000,000 -2,054,000,000 -1,755,000,000 -1,735,000,000
General and Administrative Expenses -1,145,000,000 -1,060,000,000 -796,000,000 -547,000,000 -507,000,000
Legal, Accounting, Auditing and Consulting Fees -446,000,000 -409,000,000 -389,000,000 -336,000,000 -328,000,000
Other Professional Accounting and Consulting Fees -446,000,000 -409,000,000 -389,000,000 -336,000,000 -328,000,000
Selling and Marketing Expenses -988,000,000 -922,000,000 -869,000,000 -872,000,000 -900,000,000
Depreciation, Amortization and Depletion -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000
Depreciation and Amortization -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000
Total Operating Profit/Loss 13,561,000,000 12,163,000,000 9,762,000,000 9,078,000,000 8,150,000,000
Non-Operating Income/Expenses, Total -755,000,000 -469,000,000 -1,750,000,000 -83,000,000 -426,000,000
Total Net Finance Income/Expense -612,000,000 -563,000,000 -427,000,000
Net Interest Income/Expense -612,000,000 -563,000,000 -427,000,000
Interest Expense Net of Capitalized Interest -612,000,000 -563,000,000 -427,000,000
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 -607,000,000 -19,000,000 -1,879,000,000 -14,000,000 -453,000,000
Litigation Income/Expense -607,000,000 -19,000,000 -2,000,000 -14,000,000 -453,000,000
Other Irregular Income/Expenses 0 0 -1,877,000,000
Impairment/Write Off/Write Down of Other Assets
Other Income/Expense, Non-Operating 464,000,000 113,000,000 556,000,000 -69,000,000 27,000,000
Pretax Income 12,806,000,000 11,694,000,000 8,012,000,000 8,995,000,000 7,724,000,000
Provision for Income Tax -2,505,000,000 -4,995,000,000 -2,021,000,000 -2,667,000,000 -2,286,000,000
Net Income from Continuing Operations 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000
Net Income after Extraordinary Items and Discontinued Operations 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000
Net Income after Non-Controlling/Minority Interests 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000
Net Income Available to Common Stockholders 9,942,000,000 6,467,000,000 5,929,000,000 6,313,000,000 5,421,000,000
Diluted Net Income Available to Common Stockholders 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000
Other Adjustments to Net Income Available to Common Stockholders -359,000,000 -232,000,000 -62,000,000 -15,000,000 -17,000,000
Dilution to Earnings 359,000,000 232,000,000 62,000,000 15,000,000 17,000,000
Non-Controlling/Minority Interests 0
Reported Total Revenue 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000
Reported Operating Expense 7,655,000,000 -6,214,000,000 -7,199,000,000 -4,816,000,000 -5,005,000,000
Reported Total Operating Profit/Loss 12,954,000,000 12,144,000,000 7,883,000,000 9,064,000,000 7,697,000,000
Reported Normalized Income 10,729,000,000 8,335,000,000 6,862,000,000 6,438,000,000 5,721,000,000
Reported Effective Tax Rate 0 0 0 0 0
Reported Normalized Operating Profit 13,749,000,000
Fiscal year ends in Sep 30 | USD
V Balance Sheet
Name 2018 2017 2016 2015 2014
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 8,162,000,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
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 Pledged, Current 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 803,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 Intangible Assets 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 351,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 0
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 3,015,000,000
Financial Investment Securities, Available-for-Sale & Held-to-Maturity, Non-Current 4,082,000,000 1,926,000,000 3,931,000,000 3,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, Non-Current 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 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
Total Liabilities 35,219,000,000 35,217,000,000 31,123,000,000 10,394,000,000 11,156,000,000
Total Current Liabilities 11,305,000,000 9,994,000,000 8,046,000,000 5,374,000,000 6,006,000,000
Payables and Accrued Expenses, Current 4,945,000,000 3,990,000,000 3,913,000,000 2,263,000,000 3,218,000,000
Trade and Other Payables, Current 2,351,000,000 2,574,000,000 2,585,000,000 982,000,000 1,552,000,000
Trade/Accounts Payable, Current 183,000,000 179,000,000 203,000,000 127,000,000 147,000,000
Other Payable, Current 2,168,000,000 2,003,000,000 2,084,000,000 780,000,000 1,332,000,000
Interest Payable, Current 149,000,000 145,000,000
Taxes Payable, Current 243,000,000 153,000,000 75,000,000 73,000,000
Accrued Expenses, Current 2,594,000,000 1,416,000,000 1,328,000,000 1,281,000,000 1,666,000,000
Provisions, Current 901,000,000 757,000,000 673,000,000 503,000,000 450,000,000
Provision for Employee Entitlements, Current 901,000,000 757,000,000 673,000,000 503,000,000 450,000,000
Deferred Liabilities, Current 1,300,000,000 81,000,000 82,000,000
Other Deferred Liabilities, Current 1,300,000,000
Deferred Income/Customer Advances/Billings in Excess of Cost, Current 81,000,000 82,000,000
Other Current Liabilities 4,159,000,000 3,498,000,000 3,460,000,000 2,272,000,000 2,111,000,000
Financial Liabilities, Current 0 1,749,000,000 0 255,000,000 145,000,000
Current Debt and Capital Lease Obligation 0 1,749,000,000
Current Portion of Long Term Debt and Capital Lease 1,749,000,000
Current Portion of Long Term Debt 1,749,000,000
Other Current Portion of LT Debt 1,749,000,000
Derivative and Hedging Liabilities, Current 0 255,000,000 145,000,000
Total Non-Current Liabilities 23,914,000,000 25,223,000,000 23,077,000,000 5,020,000,000 5,150,000,000
Financial Liabilities, Non-Current 16,630,000,000 16,618,000,000 15,882,000,000
Long Term Debt and Capital Lease Obligation 16,630,000,000 16,618,000,000 15,882,000,000
Long Term Debt 16,630,000,000 16,618,000,000 15,882,000,000
Notes Payables, Non-Current 16,630,000,000 16,618,000,000 15,882,000,000
Tax Liabilities, Non-Current 4,618,000,000 5,980,000,000 4,808,000,000 4,123,000,000 4,145,000,000
Deferred Tax Liabilities, Non-Current 4,618,000,000 5,980,000,000 4,808,000,000 4,123,000,000 4,145,000,000
Other Non-Current Liabilities 2,666,000,000 167,000,000 114,000,000 68,000,000 58,000,000
Deferred Liabilities, Non-Current 0 1,304,000,000 1,225,000,000
Other Deferred Liabilities, Non-Current 0 1,304,000,000 1,225,000,000
Provisions, Non-Current 62,000,000 137,000,000 77,000,000 92,000,000
Provision for Employee Entitlements, Non-Current 62,000,000 137,000,000 77,000,000 92,000,000
Pension and Other Post-Retirement Benefit Plans, Non-Current
Payables and Accrued Expenses, Non-Current 1,092,000,000 911,000,000 752,000,000 855,000,000
Trade and Other Payables, Non-Current 1,092,000,000 911,000,000 752,000,000 855,000,000
Taxes Payable, Non-Current 1,092,000,000 911,000,000 752,000,000 855,000,000
Accrued Expenses, Non-Current
Total Equity 34,006,000,000 32,760,000,000 32,912,000,000 29,842,000,000 27,413,000,000
Equity Attributable to Parent Stockholders 34,006,000,000 32,760,000,000 32,912,000,000 29,842,000,000 27,413,000,000
Paid in Capital 22,148,000,000 22,426,000,000 22,942,000,000 18,073,000,000 18,299,000,000
Capital Stock 22,148,000,000 22,426,000,000 23,112,000,000 18,073,000,000 18,299,000,000
Common Stock 0 0 0 0 0
Common Stock, with Par Value 0 0 0 0 0
Preferred Stock 5,470,000,000 5,526,000,000 5,717,000,000 0 0
Additional Paid in Capital/Share Premium 16,678,000,000 16,900,000,000 17,395,000,000 18,073,000,000 18,299,000,000
Treasury Stock 0 -170,000,000
Retained Earnings/Accumulated Deficit 11,318,000,000 9,508,000,000 10,462,000,000 11,843,000,000 9,131,000,000
Reserves/Accumulated Comprehensive Income/Losses 547,000,000 878,000,000 -458,000,000 -74,000,000 -17,000,000
Cumulative Foreign Exchange Translation Reserves/Accum. Comp. Inc 565,000,000 917,000,000 -219,000,000 -1,000,000 -2,000,000
Available for Sale Financial Investments Reserves/Accum. Comp. Inc -17,000,000 73,000,000 36,000,000 5,000,000 31,000,000
Gain/Loss from Cash Flow Hedges Reserves/Accum. Comp. Inc 60,000,000 -36,000,000 -50,000,000 83,000,000 38,000,000
Pension and Other Post-Retirement Benefit Plans Reserves/Accum. Comp. Inc -61,000,000 -76,000,000 -225,000,000 -161,000,000 -84,000,000
Other Equity Interest -7,000,000 -52,000,000 -34,000,000
Non-Controlling/Minority Interests
Common Shares Issued 2,213,586,000 2,335,160,000 2,404,160,000 2,427,586,000 2,465,586,000
Common Shares Outstanding 2,213,586,000 2,335,160,000 2,404,160,000 2,427,586,000 2,465,586,000
Common Shares Treasury 0 0 0 0 0
Fiscal year ends in Sep 30 | USD
V Cash Flow
Name 2018 2017 2016 2015 2014
Cash Flow from Operating Activities, Indirect 12,713,000,000 9,208,000,000 5,574,000,000 6,584,000,000 7,205,000,000
Net Cash Flow from Continuing Operating Activities, Indirect 12,713,000,000 9,208,000,000 5,574,000,000 6,584,000,000 7,205,000,000
Cash Generated from Operating Activities 12,713,000,000 9,208,000,000 5,574,000,000 6,584,000,000 7,205,000,000
Income/Loss before Non-Cash Adjustment 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000
Total Adjustments for Non-Cash Items 5,069,000,000 7,089,000,000 3,109,000,000 3,801,000,000 3,019,000,000
Depreciation, Amortization and Depletion, Non-Cash Adjustment 613,000,000 556,000,000 502,000,000 494,000,000 435,000,000
Depreciation and Amortization, Non-Cash Adjustment 613,000,000 556,000,000 502,000,000 494,000,000 435,000,000
Stock-Based Compensation, Non-Cash Adjustment 327,000,000 235,000,000 221,000,000 187,000,000 172,000,000
Taxes, Non-Cash Adjustment -1,277,000,000 1,700,000,000 -764,000,000 195,000,000 -580,000,000
Irregular Income/Loss, Non-Cash Adjustment 0 192,000,000
Other Irregular Income/Loss, Non-Cash Adjustment 0 192,000,000
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 5,491,000,000 4,565,000,000 3,409,000,000 2,861,000,000 2,592,000,000
Other Non-Cash Items -85,000,000 -159,000,000 55,000,000 24,000,000 37,000,000
Excess Tax Benefit from Stock-Based Compensation, Non-Cash Adjustment 0 0 -63,000,000 -84,000,000 -90,000,000
Net Investment Income/Loss, Non-Cash Adjustment 0 0 -255,000,000 110,000,000
Unrealized Gain/Loss on Financial Instruments, Non-Cash Adjustment 0 0 -255,000,000 110,000,000
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 4,000,000 14,000,000 453,000,000
Amortization of Securities, Non-Cash Adjustment
Interest and Finance Income/Expenses, Non-Cash Adjustment
Changes in Operating Capital -2,657,000,000 -4,580,000,000 -3,526,000,000 -3,545,000,000 -1,252,000,000
Change in Trade and Other Receivables -293,000,000 40,000,000 326,000,000 359,000,000 11,000,000
Change in Trade/Accounts Receivable -70,000,000 -54,000,000 -65,000,000 -19,000,000 -53,000,000
Change in Other Receivables -223,000,000 94,000,000 391,000,000 378,000,000 13,000,000
Change in Tax Receivables 51,000,000
Change in Other Current Assets -4,842,000,000 -4,880,000,000 -3,823,000,000 -3,011,000,000 -2,825,000,000
Change in Payables and Accrued Expenses 2,478,000,000 260,000,000 -29,000,000 -893,000,000 1,562,000,000
Change in Trade and Other Payables 265,000,000 -206,000,000 -259,000,000 -565,000,000 51,000,000
Change in Trade/Accounts Payable 3,000,000 -30,000,000 43,000,000 -13,000,000 -56,000,000
Change in Other Payables 262,000,000 -176,000,000 -302,000,000 -552,000,000 107,000,000
Change in Accrued Expenses 2,213,000,000 466,000,000 230,000,000 -328,000,000 1,511,000,000
Change in Other Operating Capital
Cash Flow from Investing Activities -3,084,000,000 735,000,000 -10,916,000,000 -1,435,000,000 -941,000,000
Cash Flow from Continuing Investing Activities -3,084,000,000 735,000,000 -10,916,000,000 -1,435,000,000 -941,000,000
Capital Expenditure, Reported -718,000,000 -707,000,000 -523,000,000 -414,000,000 -553,000,000
Purchase/Sale and Disposal of Property, Plant and Equipment, Net 14,000,000 12,000,000 0 10,000,000 0
Sale and Disposal of Property, Plant and Equipment 14,000,000 12,000,000 0 10,000,000 0
Purchase of Property, Plant and Equipment
Purchase/Sale of Business, Net -196,000,000 -302,000,000 -9,082,000,000 -93,000,000 -149,000,000
Purchase/Acquisition of Business -196,000,000 -302,000,000 -9,082,000,000 -93,000,000 -149,000,000
Purchase/Sale of Investments, Net -2,184,000,000 1,732,000,000 -1,311,000,000 -938,000,000 -239,000,000
Purchase of Investments -5,822,000,000 -3,284,000,000 -28,014,000,000 -2,875,000,000 -2,581,000,000
Sale of Investments 3,638,000,000 5,016,000,000 26,703,000,000 1,937,000,000 2,342,000,000
Other Investing Cash Flow
Dividends Received/Paid, CFI
Cash Flow from Financing Activities -11,240,000,000 -5,924,000,000 7,477,000,000 -3,603,000,000 -6,478,000,000
Cash Flow from Continuing Financing Activities -11,240,000,000 -5,924,000,000 7,477,000,000 -3,603,000,000 -6,478,000,000
Issuance of/Payments for Common Stock, Net -7,192,000,000 -6,891,000,000 -7,157,000,000 -2,910,000,000 -4,118,000,000
Payments for Common Stock -7,192,000,000 -6,891,000,000 -7,157,000,000 -2,910,000,000 -4,118,000,000
Issuance of/Repayments for Debt, Net -1,750,000,000 2,488,000,000 15,971,000,000
Issuance of/Repayments for Long Term Debt, Net -1,750,000,000 2,488,000,000 15,971,000,000
Proceeds from Issuance of Long Term Debt 0 2,488,000,000 15,971,000,000
Repayments for Long Term Debt -1,750,000,000
Issue and Financing Costs 0 -15,000,000 -98,000,000
Debt Issuance Costs 0 -15,000,000 -98,000,000
Cash Dividends and Interest Paid -1,918,000,000 -1,579,000,000 -1,350,000,000 -1,177,000,000 -1,006,000,000
Cash Dividends Paid -1,918,000,000 -1,579,000,000 -1,350,000,000 -1,177,000,000 -1,006,000,000
Preferred Stock Dividends Paid -1,579,000,000
Common Stock Dividends Paid -1,177,000,000 -1,006,000,000
Proceeds from Issuance/Exercising of Stock Options/Warrants 164,000,000 149,000,000 95,000,000 82,000,000 91,000,000
Other Financing Cash Flow -544,000,000 -76,000,000 -47,000,000 318,000,000 -1,535,000,000
Excess Tax Benefit from Share-Based Compensation, Financing Activities 0 0 63,000,000 84,000,000 90,000,000
Issuance of/Repayments for Lease Financing 0 0
Repayments for Lease Financing 0 0
Cash and Cash Equivalents, End of Period 8,162,000,000 9,874,000,000 5,619,000,000 3,518,000,000 1,971,000,000
Change in Cash -1,611,000,000 4,019,000,000 2,135,000,000 1,546,000,000 -214,000,000
Effect of Exchange Rate Changes -101,000,000 236,000,000 -34,000,000 1,000,000 -1,000,000
Cash and Cash Equivalents, Beginning of Period 9,874,000,000 5,619,000,000 3,518,000,000 1,971,000,000 2,186,000,000
Change in Cash As Reported, Supplemental -1,712,000,000 4,255,000,000 2,101,000,000 1,547,000,000 -215,000,000
Income Tax Paid, Supplemental -2,285,000,000 -3,038,000,000 -2,842,000,000 -2,486,000,000 -2,656,000,000
Interest Paid, Supplemental -545,000,000 -489,000,000 -244,000,000 MA Income Statement
Name 2018 2017 2016 2015 2014
Total Revenue 14,950,000,000 12,497,000,000 10,776,000,000 9,667,000,000 9,473,000,000
Business Revenue 18,483,000,000 15,492,000,000 10,776,000,000 9,667,000,000 11,056,000,000
Sales Return and Allowances/Discounts -6,881,000,000 -5,848,000,000 -3,271,000,000
Other Revenue 3,348,000,000 2,853,000,000 1,688,000,000
Operating Income/Expenses -6,576,000,000 -5,754,000,000 -4,864,000,000 -4,610,000,000 -4,397,000,000
Selling, General and Administrative Expenses -6,117,000,000 -5,318,000,000 -4,491,000,000 -4,244,000,000 -4,076,000,000
Staff Costs -3,214,000,000 -2,687,000,000 -2,225,000,000 -2,105,000,000 -2,064,000,000
General and Administrative Expenses -1,019,000,000 -874,000,000 -698,000,000 -646,000,000 -570,000,000
Legal, Accounting, Auditing and Consulting Fees -377,000,000 -355,000,000 -337,000,000 -310,000,000 -307,000,000
Telecommunication Expense -600,000,000 -504,000,000 -420,000,000 -362,000,000 -273,000,000
Selling and Marketing Expenses -907,000,000 -898,000,000 -811,000,000 -821,000,000 -862,000,000
Depreciation, Amortization and Depletion -459,000,000 -436,000,000 -373,000,000 -366,000,000 -321,000,000
Depreciation and Amortization -459,000,000 -436,000,000 -373,000,000 -366,000,000 -321,000,000
Provision Expense/Write-Back
Provision for Doubtful Accounts
Total Operating Profit/Loss 8,374,000,000 6,743,000,000 5,912,000,000 5,057,000,000 5,076,000,000
Non-Operating Income/Expenses, Total -1,170,000,000 -221,000,000 -266,000,000 -99,000,000 3,000,000
Total Net Finance Income/Expense -186,000,000 -154,000,000 -95,000,000 -61,000,000 -22,000,000
Net Interest Income/Expense -186,000,000 -154,000,000 -95,000,000 -61,000,000 -22,000,000
Interest Expense Net of Capitalized Interest -186,000,000 -154,000,000 -95,000,000 -61,000,000 -48,000,000
Interest Income 26,000,000
Net Investment Income 158,000,000 -50,000,000 9,000,000 107,000,000 32,000,000
Gain/Loss on Foreign Exchange 36,000,000 -106,000,000 -34,000,000 82,000,000 30,000,000
Other Investment Income 122,000,000 56,000,000 43,000,000 25,000,000
Gain/Loss on Investments and Other Financial Instruments 2,000,000
Irregular Income/Expenses -1,128,000,000 -15,000,000 -117,000,000 -61,000,000 0
Litigation Income/Expense -1,128,000,000 -15,000,000 -117,000,000 -61,000,000 0
Other Income/Expense, Non-Operating -14,000,000 -2,000,000 -63,000,000 -84,000,000 -7,000,000
Pretax Income 7,204,000,000 6,522,000,000 5,646,000,000 4,958,000,000 5,079,000,000
Provision for Income Tax -1,345,000,000 -2,607,000,000 -1,587,000,000 -1,150,000,000 -1,462,000,000
Net Income from Continuing Operations 5,859,000,000 3,915,000,000 4,059,000,000 3,808,000,000 3,617,000,000
Net Income after Extraordinary Items and Discontinued Operations 5,859,000,000 3,915,000,000 4,059,000,000 3,808,000,000 3,617,000,000
Net Income after Non-Controlling/Minority Interests 5,859,000,000 3,915,000,000 4,059,000,000 3,808,000,000 3,617,000,000
Net Income Available to Common Stockholders 5,859,000,000 3,915,000,000 4,059,000,000 3,808,000,000 3,617,000,000
Diluted Net Income Available to Common Stockholders 5,859,000,000 3,915,000,000 4,059,000,000 3,808,000,000 3,617,000,000
Non-Controlling/Minority Interests
Reported Total Revenue 14,950,000,000 12,497,000,000 10,776,000,000 9,667,000,000 9,473,000,000
Reported Operating Expense -7,668,000,000 -5,875,000,000 -5,015,000,000 -4,589,000,000 -4,367,000,000
Reported Total Operating Profit/Loss 7,282,000,000 6,622,000,000 5,761,000,000 5,078,000,000 5,106,000,000
Reported Normalized Income 6,792,000,000 4,906,000,000 4,144,000,000 3,903,000,000
Reported Effective Tax Rate 0 0 0 0 0
Reported Normalized Operating Profit 5,878,000,000 5,218,000,000
Gross Profit
Cost of Revenue
Fiscal year ends in Dec 31 | USD
MA Balance Sheet
Name 2018 2017 2016 2015 2014
Total Assets 24,860,000,000 21,329,000,000 18,675,000,000 16,269,000,000 15,329,000,000
Total Current Assets 16,171,000,000 13,797,000,000 13,228,000,000 10,985,000,000 10,997,000,000
Cash, Cash Equivalents and Short Term Investments 8,378,000,000 7,782,000,000 8,335,000,000 6,738,000,000 6,305,000,000
Cash and Cash Equivalents 6,682,000,000 5,933,000,000 6,721,000,000 5,747,000,000 5,137,000,000
Short Term Investments 1,696,000,000 1,849,000,000 1,614,000,000 991,000,000 1,168,000,000
Available-for-Sale Securities, Current 1,696,000,000 1,849,000,000 1,614,000,000 991,000,000 1,168,000,000
Held-to-Maturity Securities, Current
Cash Restricted or Pledged, Current 1,633,000,000 1,631,000,000 1,534,000,000 1,436,000,000 1,490,000,000
Trade and Other Receivables, Current 4,728,000,000 3,344,000,000 2,509,000,000 2,147,000,000 2,161,000,000
Trade/Accounts Receivable, Current 4,728,000,000 3,344,000,000 2,509,000,000 2,147,000,000 2,161,000,000
Taxes Receivable, Current
Other Receivables, Current
Prepayments and Deposits, Current 829,000,000 541,000,000 850,000,000 664,000,000 497,000,000
Other Current Assets 603,000,000 499,000,000 244,000,000
Deferred Tax Assets, Current 0 300,000,000
Deferred Costs/Assets, Current
Total Non-Current Assets 8,689,000,000 7,532,000,000 5,447,000,000 5,284,000,000 4,332,000,000
Net Property, Plant and Equipment 921,000,000 829,000,000 733,000,000 675,000,000 615,000,000
Gross Property, Plant and Equipment 1,768,000,000 1,543,000,000 1,336,000,000 1,166,000,000 1,052,000,000
Properties 696,000,000 621,000,000 667,000,000 615,000,000 601,000,000
Buildings and Improvements 481,000,000 455,000,000 534,000,000 503,000,000 510,000,000
Leasehold and Improvements 215,000,000 166,000,000 133,000,000 112,000,000 91,000,000
Machinery, Furniture and Equipment 1,072,000,000 922,000,000 669,000,000 551,000,000 451,000,000
Furniture, Fixtures and Office Equipment 85,000,000 81,000,000 63,000,000 54,000,000 53,000,000
Other Equipment 987,000,000 841,000,000 606,000,000 497,000,000 398,000,000
Accumulated Depreciation and Impairment -847,000,000 -714,000,000 -603,000,000 -491,000,000 -437,000,000
Accumulated Depreciation -847,000,000 -714,000,000 -603,000,000 -491,000,000 -437,000,000
Net Intangible Assets 3,895,000,000 4,155,000,000 2,478,000,000 2,694,000,000 2,236,000,000
Gross Goodwill and Other Intangible Assets 5,070,000,000 5,312,000,000 3,452,000,000 3,510,000,000 2,899,000,000
Goodwill 2,904,000,000 3,035,000,000 1,756,000,000 1,891,000,000 1,522,000,000
Intangibles other than Goodwill 2,166,000,000 2,277,000,000 1,696,000,000 1,619,000,000 1,377,000,000
Software and Technology 1,514,000,000 1,572,000,000 1,210,000,000 1,086,000,000 839,000,000
Customer Relationships 606,000,000 648,000,000 437,000,000 478,000,000 470,000,000
Other Intangible Assets 46,000,000 27,000,000 23,000,000 25,000,000 20,000,000
Trademarks and Patents 30,000,000 26,000,000 30,000,000 48,000,000
Accumulated Amortization and Impairment -1,175,000,000 -1,157,000,000 -974,000,000 -816,000,000 -663,000,000
Accumulated Amortization of Intangible Assets -1,175,000,000 -1,157,000,000 -974,000,000 -816,000,000 -663,000,000
Accumulated Amortization of Intangibles other than Goodwill -1,175,000,000 -1,157,000,000 -974,000,000 -816,000,000 -663,000,000
Accumulated Amortization of Software and Technology -898,000,000 -888,000,000 -768,000,000 -625,000,000 -496,000,000
Accumulated Amortization of Customer Relationships -232,000,000 -214,000,000 -162,000,000 -149,000,000 -115,000,000
Accumulated Amortization of Other Intangible Assets -45,000,000 -26,000,000 -22,000,000 -19,000,000 -14,000,000
Accumulated Amortization of Trademarks and Patents -29,000,000 -22,000,000 -23,000,000 -38,000,000
Total Long Term Investments 337,000,000 249,000,000 132,000,000 166,000,000 245,000,000
Long Term Equity Investments 337,000,000 249,000,000 132,000,000 166,000,000 245,000,000
Investment in Financial Assets, Non-Current
Financial Investment Securities, Available-for-Sale & Held-to-Maturity, Non-Current
Available-for-Sale Securities, Non-Current
Held-to-Maturity Securities, Non-Current
Trade and Other Receivables, Non-Current 298,000,000 178,000,000 175,000,000 160,000,000 89,000,000
Taxes Receivable, Non-Current 298,000,000 178,000,000 175,000,000 160,000,000 89,000,000
Prepayments and Deposits, Non-Current 0 352,000,000 325,000,000 352,000,000 407,000,000
Prepayments, Non-Current 0 352,000,000 325,000,000 352,000,000 407,000,000
Deferred Tax Assets, Non-Current 570,000,000 250,000,000 307,000,000 317,000,000 96,000,000
Other Non-Current Assets 2,668,000,000 1,519,000,000 1,297,000,000 920,000,000 644,000,000
Deferred Costs/Assets, Non-Current
Total Liabilities 19,442,000,000 15,832,000,000 12,991,000,000 10,207,000,000 8,505,000,000
Total Current Liabilities 11,593,000,000 8,793,000,000 7,206,000,000 6,269,000,000 6,222,000,000
Payables and Accrued Expenses, Current 9,064,000,000 6,916,000,000 5,595,000,000 4,810,000,000 4,771,000,000
Trade and Other Payables, Current 2,884,000,000 2,470,000,000 1,716,000,000 1,481,000,000 1,666,000,000
Trade/Accounts Payable, Current 2,726,000,000 2,276,000,000 1,555,000,000 1,338,000,000 1,561,000,000
Taxes Payable, Current 158,000,000 194,000,000 161,000,000 143,000,000 105,000,000
Amount Due to Related Parties/Shareholders, Current
Accrued Expenses, Current 6,180,000,000 4,446,000,000 3,879,000,000 3,329,000,000 3,105,000,000
Financial Liabilities, Current 500,000,000
Current Debt and Capital Lease Obligation 500,000,000
Current Portion of Long Term Debt and Capital Lease 500,000,000
Current Portion of Long Term Debt 500,000,000
Other Current Portion of LT Debt 500,000,000
Other Current Liabilities 2,029,000,000 1,877,000,000 1,611,000,000 1,459,000,000 1,451,000,000
Provisions, Current
Provision for Employee Entitlements, Current
Total Non-Current Liabilities 7,849,000,000 7,039,000,000 5,785,000,000 3,938,000,000 2,283,000,000
Financial Liabilities, Non-Current 5,834,000,000 5,424,000,000 5,180,000,000 3,287,000,000 1,494,000,000
Long Term Debt and Capital Lease Obligation 5,834,000,000 5,424,000,000 5,180,000,000 3,287,000,000 1,494,000,000
Long Term Debt 5,834,000,000 5,424,000,000 5,180,000,000 3,287,000,000 1,494,000,000
Notes Payables, Non-Current 5,834,000,000
Tax Liabilities, Non-Current 67,000,000 106,000,000 81,000,000 79,000,000 115,000,000
Deferred Tax Liabilities, Non-Current 67,000,000 106,000,000 81,000,000 79,000,000 115,000,000
Other Non-Current Liabilities 1,877,000,000 1,438,000,000 524,000,000 572,000,000 674,000,000
Preferred Securities Outside Stock Equity 71,000,000 71,000,000
Total Equity 5,418,000,000 5,497,000,000 5,684,000,000 6,062,000,000 6,824,000,000
Equity Attributable to Parent Stockholders 5,395,000,000 5,468,000,000 5,656,000,000 6,028,000,000 6,790,000,000
Paid in Capital -21,170,000,000 -16,399,000,000 -12,838,000,000 -9,518,000,000 -6,119,000,000
Capital Stock 4,580,000,000 4,365,000,000 4,183,000,000 4,004,000,000 3,876,000,000
Common Stock 0 0 0 0
Common Stock, with Par Value 0 0 0 0
Additional Paid in Capital/Share Premium 4,580,000,000 4,365
