Unit 3: Individual Assignment - Mastercard Ratios

Unit 3: Individual Assignment - Mastercard Ratios

Introduction

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 Ratios  Download STUDENTS Mastercard Financial Ratios

 

This is an Individual Assignment

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.

· Research Project - Mastercard Ratios

Research Project - Mastercard Ratios
Criteria	Ratings	Pts
This criterion is linked to a Learning OutcomeCalculate Ratios	25 to >22.5 pts Excellent All ratios for each company are accurately calculated for three years of data. Table presents calculations and ratios using cell references to the appropriate accounting statement. 22.5 to >20.0 pts Meets Expectations Ratios are accurately calculated for each company with minor errors for three years of data. Table presents calculations and ratios in an using cell references. 20 to >18.0 pts Below Expectations Most of the ratios are accurately calculated for each company. Most calculations are shown. 18 to >0 pts Insufficient Most of the ratios are inaccurately calculated or missing for each company. Most calculations are not shown.	25 pts
Total Points: 25