For General Electric Co

Overview

Competitor #1 Income Statement (Tab 5), Competitor #1 Balance Sheet (Tab 6), Competitor #1 Cash Flows (Tab 7), Competitor #2 Income Statement (Tab 8), Competitor #2 Balance Sheet (Tab 9), Competitor #2 Cash Flows (Tab 10), Historical and Competitor Ratios (Tab 11)

Instructions

• Continue in the same Excel workbook prepared in Module 2: Week 2, adding the following tabs:
  • The 5^th tab and 8^th tabs in your Financial Statement Analysis Template must be labeled (Competitor Company Name) Income Statements. (Replace Competitor Company Name with the name of the competitor.)
    • Include the latest three years of income statements for your competitor based on SEC filings.
    • Ensure that the worksheet includes a header with:
      • Company Name
      • Financial Statement Name (Income Statements)
      • Financial Statement Dates
      • Denomination level ($s in millions or thousands, etc.)
  • The 6^th and 9^th tabs in your Financial Statement Analysis Template must be labeled (Competitor Company Name) Balance Sheets. (Replace Competitor Company Name with the name of the competitor.)
    • Include the latest three years of balance sheets for your first competitor based on SEC (10-K) filings. (Note: Some 10-Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.)
    • Ensure that the worksheet includes a header with:
      • Company Name
      • Financial Statement Name
      • Financial Statement Dates
      • Denomination level ($s in millions or thousands, etc.)