Place your ratio calculations in the MS Excel table template for Mastercard for 2017-2019. Provide the formula used to calculate each ratio in the column to the right of your calculatio
Place your ratio calculations in the MS Excel table template for Mastercard for 2017-2019. Provide the formula used to calculate each ratio in the column to the right of your calculations. For example, for calcu Margin for a company, you would enter Gross Profit/Sales (gross profit divided by sales). When calculating values, you should use the SUM function in MS Excel and reference the values directly from the acco providedAttached you will find an example for PayPal and the calculations for Gross Margin and Operating Margin function
Ratios
| 2017 | 2018 | 2019 | Formulas | |
| PROFITABILITY RATIOS | ||||
| MC GROSS MARGIN | ||||
| MC OPERATION MARGIN | ||||
| MC NETPROFIT MARGIN | ||||
| LIQUIDITY RATIO | ||||
| MC CURRENT RATIO | ||||
| MC CASH RATIO | ||||
| LEVERAGE RATIOS | ||||
| MC DEBT TO EQUITY | ||||
| OPERATION RETURNS | ||||
| MC ROE | ||||
| MC ROA | ||||
MA Income Statement
| MA_IncomeStatement_Annual_As_Originally_Reported | 2017 | 2018 | 2019 |
| Gross Profit | 9,810,000,000 | 11,736,000,000 | 13,346,000,000 |
| Total Revenue | 12,497,000,000 | 14,950,000,000 | 16,883,000,000 |
| Business Revenue | 15,492,000,000 | 18,483,000,000 | 20,856,000,000 |
| Sales Return and Allowances/Discounts | -5,848,000,000 | -6,881,000,000 | -8,097,000,000 |
| Other Revenue | 2,853,000,000 | 3,348,000,000 | 4,124,000,000 |
| Cost of Revenue | -2,687,000,000 | -3,214,000,000 | -3,537,000,000 |
| Staff Cost, Cost of Revenue | -2,687,000,000 | -3,214,000,000 | -3,537,000,000 |
| Operating Income/Expenses | -3,067,000,000 | -3,362,000,000 | -3,650,000,000 |
| Selling, General and Administrative Expenses | -2,631,000,000 | -2,903,000,000 | -3,128,000,000 |
| General and Administrative Expenses | -1,378,000,000 | -1,619,000,000 | -1,747,000,000 |
| Legal, Accounting, Auditing and Consulting Fees | -355,000,000 | -377,000,000 | -447,000,000 |
| Selling and Marketing Expenses | -898,000,000 | -907,000,000 | -934,000,000 |
| Staff Costs | 0 | 0 | 0 |
| Depreciation, Amortization and Depletion | -436,000,000 | -459,000,000 | -522,000,000 |
| Depreciation and Amortization | -436,000,000 | -459,000,000 | -522,000,000 |
| Provision Expense/Write-Back | |||
| Provision for Doubtful Accounts | |||
| Total Operating Profit/Loss | 6,743,000,000 | 8,374,000,000 | 9,696,000,000 |
| Non-Operating Income/Expenses, Total | -221,000,000 | -1,170,000,000 | 35,000,000 |
| Total Net Finance Income/Expense | -154,000,000 | -186,000,000 | -224,000,000 |
| Net Interest Income/Expense | -154,000,000 | -186,000,000 | -224,000,000 |
| Interest Expense Net of Capitalized Interest | -154,000,000 | -186,000,000 | -224,000,000 |
| Interest Income | |||
| Net Investment Income | -50,000,000 | 158,000,000 | 232,000,000 |
| Gain/Loss on Investments and Other Financial Instruments | 167,000,000 | ||
| Gain/Loss on Foreign Exchange | -106,000,000 | 36,000,000 | -32,000,000 |
| Other Investment Income | 56,000,000 | 122,000,000 | 97,000,000 |
| Irregular Income/Expenses | -15,000,000 | -1,128,000,000 | 0 |
| Litigation Income/Expense | -15,000,000 | -1,128,000,000 | 0 |
| Other Income/Expense, Non-Operating | -2,000,000 | -14,000,000 | 27,000,000 |
| Pretax Income | 6,522,000,000 | 7,204,000,000 | 9,731,000,000 |
| Provision for Income Tax | -2,607,000,000 | -1,345,000,000 | -1,613,000,000 |
| Net Income from Continuing Operations | 3,915,000,000 | 5,859,000,000 | 8,118,000,000 |
| Net Income after Extraordinary Items and Discontinued Operations | 3,915,000,000 | 5,859,000,000 | 8,118,000,000 |
| Net Income after Non-Controlling/Minority Interests | 3,915,000,000 | 5,859,000,000 | 8,118,000,000 |
| Net Income Available to Common Stockholders | 3,915,000,000 | 5,859,000,000 | 8,118,000,000 |
| Diluted Net Income Available to Common Stockholders | 3,915,000,000 | 5,859,000,000 | 8,118,000,000 |
| Non-Controlling/Minority Interests | |||
| Reported Total Revenue | 12,497,000,000 | 14,950,000,000 | 16,883,000,000 |
| Reported Operating Expense | -5,875,000,000 | -7,668,000,000 | -7,219,000,000 |
| Reported Total Operating Profit/Loss | 6,622,000,000 | 7,282,000,000 | 9,664,000,000 |
| Reported Normalized Income | 4,906,000,000 | 6,792,000,000 | 7,937,000,000 |
| Reported Effective Tax Rate | 0 | 0 | 0 |
| Reported Normalized Operating Profit | |||
| Basic EPS | 3.67 | 5.63 | 7.98 |
| Diluted EPS | 3.65 | 5.60 | 7.94 |
| Basic WASO | 1,067,000,016 | 1,041,000,015 | 1,017,000,015 |
| Diluted WASO | 1,072,000,016 | 1,047,000,015 | 1,022,000,015 |
| Fiscal year ends in Dec 31 | USD |
MA Balance Sheet
| MA_BalanceSheet_Annual_As_Originally_Reported | 2017 | 2018 | 2019 |
| Total Assets | 21,329,000,000 | 24,860,000,000 | 29,236,000,000 |
| Total Current Assets | 13,797,000,000 | 16,171,000,000 | 16,902,000,000 |
| Cash, Cash Equivalents and Short Term Investments | 7,782,000,000 | 8,378,000,000 | 7,676,000,000 |
| Cash and Cash Equivalents | 5,933,000,000 | 6,682,000,000 | 6,988,000,000 |
| Short Term Investments | 1,849,000,000 | 1,696,000,000 | 688,000,000 |
| Available-for-Sale Securities, Current | 1,849,000,000 | 1,696,000,000 | 688,000,000 |
| Held-to-Maturity Securities, Current | |||
| Cash Restricted or Pledged, Current | 1,631,000,000 | 1,633,000,000 | 1,954,000,000 |
| Trade and Other Receivables, Current | 3,344,000,000 | 4,728,000,000 | 5,509,000,000 |
| Trade/Accounts Receivable, Current | 3,344,000,000 | 4,728,000,000 | 5,509,000,000 |
| Taxes Receivable, Current | |||
| Other Receivables, Current | |||
| Prepayments and Deposits, Current | 77,000,000 | 51,000,000 | 105,000,000 |
| Other Current Assets | 963,000,000 | 1,381,000,000 | 1,658,000,000 |
| Deferred Tax Assets, Current | |||
| Deferred Costs/Assets, Current | |||
| Total Non-Current Assets | 7,532,000,000 | 8,689,000,000 | 12,334,000,000 |
| Net Property, Plant and Equipment | 829,000,000 | 921,000,000 | 1,828,000,000 |
| Gross Property, Plant and Equipment | 1,543,000,000 | 1,768,000,000 | 2,928,000,000 |
| Properties | 621,000,000 | 696,000,000 | 808,000,000 |
| Buildings and Improvements | 455,000,000 | 481,000,000 | 505,000,000 |
| Leasehold and Improvements | 166,000,000 | 215,000,000 | 303,000,000 |
| Machinery, Furniture and Equipment | 81,000,000 | 85,000,000 | 92,000,000 |
| Furniture, Fixtures and Office Equipment | 81,000,000 | 85,000,000 | 92,000,000 |
| Other Equipment | 0 | 0 | 0 |
| Leased Property, Plant and Equipment | 810,000,000 | ||
| Other Property, Plant and Equipment | 841,000,000 | 987,000,000 | 1,218,000,000 |
| Accumulated Depreciation and Impairment | -714,000,000 | -847,000,000 | -1,100,000,000 |
| Accumulated Depreciation | -714,000,000 | -847,000,000 | -1,100,000,000 |
| Net Intangible Assets | 4,155,000,000 | 3,895,000,000 | 5,438,000,000 |
| Gross Goodwill and Other Intangible Assets | 5,312,000,000 | 5,070,000,000 | 6,734,000,000 |
| Goodwill | 3,035,000,000 | 2,904,000,000 | 4,021,000,000 |
| Intangibles other than Goodwill | 2,277,000,000 | 2,166,000,000 | 2,713,000,000 |
| Software and Technology | 1,572,000,000 | 1,514,000,000 | 1,884,000,000 |
| Customer Relationships | 648,000,000 | 606,000,000 | 785,000,000 |
| Other Intangible Assets | 27,000,000 | 46,000,000 | 44,000,000 |
| Trademarks and Patents | 30,000,000 | ||
| Accumulated Amortization and Impairment | -1,157,000,000 | -1,175,000,000 | -1,296,000,000 |
| Accumulated Amortization of Intangible Assets | -1,157,000,000 | -1,175,000,000 | -1,296,000,000 |
| Accumulated Amortization of Intangibles other than Goodwill | -1,157,000,000 | -1,175,000,000 | -1,296,000,000 |
| Accumulated Amortization of Software and Technology | -888,000,000 | -898,000,000 | -988,000,000 |
| Accumulated Amortization of Customer Relationships | -214,000,000 | -232,000,000 | -264,000,000 |
| Accumulated Amortization of Other Intangible Assets | -26,000,000 | -45,000,000 | -44,000,000 |
| Accumulated Amortization of Trademarks and Patents | -29,000,000 | ||
| Total Long Term Investments | 249,000,000 | 337,000,000 | 914,000,000 |
| Investment in Financial Assets, Non-Current | 249,000,000 | 337,000,000 | 914,000,000 |
| Equity Securities/Shares, Non-Current | 249,000,000 | 337,000,000 | 914,000,000 |
| 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 | 178,000,000 | 298,000,000 | 460,000,000 |
| Taxes Receivable, Non-Current | 178,000,000 | 298,000,000 | 460,000,000 |
| Deferred Tax Assets, Non-Current | 250,000,000 | 570,000,000 | 543,000,000 |
| Other Non-Current Assets | 1,519,000,000 | 2,668,000,000 | 3,151,000,000 |
| Prepayments and Deposits, Non-Current | 352,000,000 | 0 | |
| Prepayments, Non-Current | 352,000,000 | 0 | |
| Deferred Costs/Assets, Non-Current | |||
| Total Liabilities | 15,832,000,000 | 19,442,000,000 | 23,319,000,000 |
| Total Current Liabilities | 8,793,000,000 | 11,593,000,000 | 11,904,000,000 |
| Payables and Accrued Expenses, Current | 6,916,000,000 | 9,064,000,000 | 9,606,000,000 |
| Trade and Other Payables, Current | 2,470,000,000 | 2,884,000,000 | 3,535,000,000 |
| Trade/Accounts Payable, Current | 933,000,000 | 537,000,000 | 489,000,000 |
| Taxes Payable, Current | 194,000,000 | 158,000,000 | 332,000,000 |
| Other Payable, Current | 1,343,000,000 | 2,189,000,000 | 2,714,000,000 |
| Amount Due to Related Parties/Shareholders, Current | |||
| Accrued Expenses, Current | 4,446,000,000 | 6,180,000,000 | 6,071,000,000 |
| Financial Liabilities, Current |
Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions.  All Rights Reserved Terms and Conditions |