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