• Choose one of the 3 companies listed in your Instructors Module 1:
• 1. McDonald's
• 2. Amazon
• 3. Apple
• Go to the Securities and Exchange Commissions EDGAR database and access your chosen companys most recent Form 10-K (annual report). (For help with this process, see the Module 1: Week 1 presentation, Downloading Financial Statements from the SEC EDGAR Database.)
• Create an Excel workbook, including data for your chosen company as follows:
  • The 1^st tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included:
    • Company Name and ticker symbol
    • Industry
    • Products or services offered
    • Major competitors
    • An example of this tab is provided in Exhibit A.
  • The 2^nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements.
    • Include the latest three years 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 3^rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets.
    • Include the latest three years 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.)
    • A partial balance sheet example is provided in Exhibit B.
  • The 4^th tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flows.
    • Include the latest three years based on SEC (10-K) filings.
    • Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows:
      • Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows.
      • Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet.
    • Ensure that the worksheet includes a header with:
      • Company Name
      • Financial Statement Name
      • Financial Statement Dates
      • Denomination level ($s in millions or thousands, etc.)