Excel Financial Ratios For this project your team will prepare financial ratios in MS Excel using the accounting statements provided. Teams must prov

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

Don't use plagiarized sources. Get Your Custom Assignment on
Excel Financial Ratios For this project your team will prepare financial ratios in MS Excel using the accounting statements provided. Teams must prov
From as Little as $13/Page

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

Leave a Comment

Your email address will not be published. Required fields are marked *