Discussion PayPal
For this assignment, utilize PayPal Financials MS Excel file of your choice to create the major financial ratios. There should be 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).
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.
When calculating values, use the SUM function in MS Excel and reference the values directly from the accounting statements provided. Find an example for the expectations for calculations and the formulas in the attached file with Gross Margin calculated for 2013 – 2015.
Must be completed in Microsoft Excel
