As you work towards your final team project, there are sections of the project that will require individual work. Using the feedback from the PayPal ratios assignment in Unit 2, individually (not as a team) you will use the attached MS Excel file to create your ratios for your final project. Using this file gather and report your ratio and financial performance data for Mastercard for 2017 - 2019. Within the Mastercard Financial Ratios MS Excel file you will find four sheets; ratios, income statement, balance sheet, cash flow. Using the accounting statements, you will use MS Excel to calculate the ratios and enter into the ratios sheet.STUDENTS Mastercard Financial RatiosDownload STUDENTS Mastercard Financial Ratios This is an Individual AssignmentDirectionsPlace 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 calculating the Gross 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 accounting statements provided. Attached you will find an example for PayPal and the calculations for Gross Margin and Operating Margin using MS Excel SUM function. 2017 2018 2019 FormulasPROFITABILITY RATIOS MC GROSS MARGIN MC OPERATION MARGIN MC NETPROFIT MA

MA_CashFlow_Annual_As_Originally_Reported 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 Net Investment Income/Loss, Non-Cash Adjustment Gain/Loss on Financial Instruments, Non-Cash Adjustment Other Non-Cash Items Excess Tax Benefit from Stock-Based Compensation, Non-Cash Adjustment Changes in Operating Capital Change in Trade and Other Receivables Change in Trade/Accounts Receivable Change in Tax Receivables Change in Prepayments and Deposits Change in Cash Restricted or Pledged Change in Payables and Accrued Expenses Change in Trade and Other Payables Change in Trade/Accounts Payable Change in Other Payables Change in Taxes Payable Change in Accrued Expenses Change in Other Operating Capital Change in Other Current Liabilities Cash Flow from Investing Activities Cash Flow from Continuing Investing Activities Capital Expenditure, Reported Purchase/Sale and Disposal of Property, Plant and Equipment, Net 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 Purchase/Sale of Equity Investments Purchase of Joint Venture/Associate Change in Restricted Cash and Cash Equivalents Purchase/Sale of Intangibles, Net Purchase of Intangibles 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 Net Movement in Non-Controlling/Minority Interest Cash Dividends and Interest Paid Cash 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 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 Fiscal year ends in Dec 31 | USD XY X U X T Y% N Y Y WY N U N T Y 2017 5,555,000,000 5,555,000,000 5,555,000,000 3,915,000,000 1,926,000,000 437,000,000 437,000,000 176,000,000 86,000,000 1,227,000,000 -286,000,000 -726,000,000 -726,000,000 -1,402,000,000 1,258,000,000 684,000,000 290,000,000 394,000,000 0 574,000,000 584,000,000 -1,779,000,000 -1,779,000,000 -123,000,000 -300,000,000 -300,000,000 -1,175,000,000 -1,175,000,000 -182,000,000 -2,006,000,000 1,824,000,000 1,000,000 0 0 -4,764,000,000 -4,764,000,000 -3,762,000,000 -3,762,000,000 -64,000,000 -64,000,000 -64,000,000 -942,000,000 -942,000,000 -942,000,000 57,000,000 -53,000,000 5,933,000,000 -988,000,000 200,000,000 6,721,000,000 -788,000,000 r v v v v v r v v v v v r r v v r v v 2018 6,223,000,000 6,223,000,000 6,223,000,000 5,859,000,000 1,677,000,000 459,000,000 459,000,000 196,000,000 -244,000,000 1,266,000,000 -1,313,000,000 -1,515,000,000 -1,395,000,000 -120,000,000 -1,769,000,000 -6,000,000 2,258,000,000 950,000,000 101,000,000 849,000,000 0 1,308,000,000 -281,000,000 -506,000,000 -506,000,000 -174,000,000 -330,000,000 -330,000,000 0 0 12,000,000 -1,900,000,000 1,912,000,000 -14,000,000 0 0 -4,966,000,000" -4,966,000,000" -4,933,000,000" -4,933,000,000" 991,000,000" 991,000,000" 991,000,000 0 v -1,044,000,000 -1,044,000,000 -1,044,000,000 104,000,000 -84,000,000 0 8,337,000,000 751,000,000 -6,000,000 7,592,000,000 745,000,000 v v r r v v v v v r 2019 8,183,000,000 8,183,000,000 8,183,000,000 8,118,000,000 1,763,000,000 522,000,000 522,000,000 250,000,000 -7,000,000 -167,000,000 -167,000,000 1,165,000,000 -1,698,000,000 -892,000,000 -690,000,000 -202,000,000 -1,661,000,000 290,000,000 430,000,000 435,000,000 -42,000,000 477,000,000 0 -5,000,000 135,000,000 -1,640,000,000 -1,640,000,000 -306,000,000 -422,000,000 -422,000,000 -1,440,000,000 -1,440,000,000 532,000,000 -1,325,000,000 1,857,000,000 -4,000,000 0 0 -5,867,000,000 -5,867,000,000 -6,497,000,000 -6,497,000,000 2,224,000,000 2,224,000,000 2,724,000,000 -500,000,000 -1,345,000,000 -1,345,000,000 -1,345,000,000 126,000,000 -375,000,000 8,969,000,000 676,000,000 -44,000,000 8,337,000,000 632,000,000