Financial Ratio Analysis

profileMSTINA

  

Select a Fortune 500 company from one of the following industries:

· Pharmaceutical

· Energy

· Retail

· Automotive

· Computer Hardware

Review the balance sheet and income statement in the company's 2015 Annual Report. 

Calculate the following ratios using Microsoft Excel:

· Current Ratio

· Quick Ratio

· Debt Equity Ratio

· Inventory Turnover Ratio

· Receivables Turnover Ratio

· Total Assets Turnover Ratio

· Profit Margin (Net Margin) Ratio

· Return on Assets Ratio

Analyze in 1,050 words why each ratio is important for financial decision making. 

  • 7 years ago
  • 15
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    FinancialRatios..docx
  • attachment
    FinancialRatiosExcel.docx
  • attachment
    FinancialRatios1.pdf
  • attachment
    1565258308129_1565258307914_GeneralMotorsFinancialRatios.Basedon2015financialreports..xlsx