07 Nov 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
Posted at 00:50h
in Business Finance - Management
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 |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. |