Excel Financial Ratios

For this project your team will prepare financial ratios in MS Excel using the accounting statements provided.  Teams must provide the calculations for the following ratios for each company using the 2018 annual data.  Calculations must be performed and submitted in an MS Excel spreadsheet.

1. Profitability Ratios
   • Gross Margin
   • Operating Margin
   • Net Profit Margin