Financial analysis | MBA615 | Park University

For this project, you will prepare financial ratios in MS Excel using the accounting statements provided. You must provide the calculations for the ratios over a three year period (2016, 2017, 2018) for each company using the annual data. Calculations must be performed and submitted in an MS Excel spreadsheet for each.

1. Profitability Ratios 
   • Gross Margin
   • Operating Margin
   • Net Profit Margin
2. Liquidity Ratios 
3. Leverage Ratios 
4. Operating Returns