For General Electric Co

• The 11^th tab in your Financial Statement Analysis Template must be labeled Historical and Competitor Ratios
  • The list of ratios to be included are as follows. They should be grouped under the headings, as shown:
    • Liquidity Ratios
      • Current Ratio
      • Quick Ratio
    • Leverage Ratios
      • Debt to Total Assets Ratio
      • Debt Equity Ratio
      • Long-Term Debt to Equity
      • Times Interest Earned Ratio
    • Activity Ratios
      • Inventory Turnover
      • Fixed Assets Turnover
      • Total Assets Turnover
      • Accounts Receivable Turnover
      • Average Collection Period
    • Profitability Ratios
      • Gross Profit Margin
      • Operating Profit Margin
      • Net Profit Margin
      • Return on Total Assets (ROA)
      • Return on Stockholders Equity (ROE)
      • Earnings Per Share (EPS)
      • Price Earnings Ratio
  • Calculate the ratios for your chosen company for the last three years, linking the ratio calculations back to the historical financial statement tabs (Tabs 2-4) using formulas.
  • Calculate the ratios for each of your companys competitors (most recent year only), linking the ratio calculations to the competitor financial statements shown in Tabs 5-10 using formulas.
  • Using the internet, locate the industry averages for the ratios listed above, and include them in the final column of the ratio tab. Include a footnote on the tab to identify the source of the industry averages.
• Other instructions:
  • The Excel workbook should be professionally formatted. Professional formatting includes:
    • All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.
    • Dollar signs are included in the first and last numbers of each column.
    • Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.
    • Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.
  • All totals and subtotals in the competitor financial statements as well as the ratio calculations should be calculated using formulas.