financial analysis

profileImpaler_2019

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 
    • Current Ratio
    • Cash Ratio
  3. Leverage Ratios 
    • Debt to Equity
  4. Operating Returns 
    • ROE
    • ROA
  • 6 years ago
  • 25
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    MAFinancialStatementsFinalProject-MBA615.xlsx
  • attachment
    VFinancialStatementsFinalProject-MBA615.xls