• 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 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.

MCGROSSMARGINPROFITABILITYRATIOS MC OPERATION MARGIN MC NETPROFIT MARGIN MCCURRENTRATIOLIQUIDITYRATIO MC CASH RATIO MCDEBTTOEQUITYLEVERAGERATIOS MCROEOPERATIONRETURNS MC ROA Cash Flow from Financing Activities Cash Flow from Continuing Financing Activities 4,764,000,0004,764,000,0003,762,000,0003,762,000,00064,000,00064,000,00064,000,0004,966,000,0004,966,000,0004,933,000,0004,933,000,000991,000,000991,000,000991,000,00005,867,000,0005,867,000,0006,497,000,0006,497,000,0002,224,000,0002,224,000,0002,724,000,000500,000,000 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 942,000,000942,000,000942,000,00057,000,00053,000,0001,044,000,0001,044,000,0001,044,000,000104,000,00084,000,0001,345,000,0001,345,000,0001,345,000,000126,000,000375,000,000 Fiscal year ends in Dec 31 | USD MCGROSSMARGINPROFITABILITYRATIOS MC OPERATION MARGIN MC NETPROFIT MARGIN MCCURRENTRATIOLIQUIDITYRATIO MC CASH RATIO MCDEBTTOEQUITYLEVERAGERATIOS MCROEOPERATIONRETURNS MC ROA Cash Flow from Financing Activities Cash Flow from Continuing Financing Activities 4,764,000,0004,764,000,0003,762,000,0003,762,000,00064,000,00064,000,00064,000,0004,966,000,0004,966,000,0004,933,000,0004,933,000,000991,000,000991,000,000991,000,00005,867,000,0005,867,000,0006,497,000,0006,497,000,0002,224,000,0002,224,000,0002,724,000,000500,000,000 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 942,000,000942,000,000942,000,00057,000,00053,000,0001,044,000,0001,044,000,0001,044,000,000104,000,00084,000,0001,345,000,0001,345,000,0001,345,000,000126,000,000375,000,000 Fiscal year ends in Dec 31 | USD