Unit 2: Individual Assignment - Financial Ratios

Unit 2: Individual Assignment - Financial Ratios

Start Assignment

Introduction

In 2015, PayPal was spun off from eBay and provides electronic payment solutions for both consumers and merchants and maintains a focus on online transactions.  For this assignment, you will utilize the attached PayPal Financials MS Excel file to create the major financial ratios. There are four sheets in the PayPal Financials MS Excel file;  ratios, income statement, balance sheet, and cash flow.  Using this file you will calculate and report the ratio data for PayPal for 2013 – 2015 and input the data on the first sheet (Ratios).

· PayPal Ratios    Download PayPal Ratios (.xls file)

This is an individual assignment

Directions

· Place your ratio calculations in the PayPal Financial MS Excel on the Ratios sheet for 2013 -2015. 

· 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.  You will find an example for the expectations for calculations and the formulas in the attached file with Gross Margin calculated for 2013 - 2015.

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