These exercises will help you apply concepts to real companies’ financial statements to compare and contrast their financial performance across industries and time. Companies included in this series of exercises:
• Adobe Systems
• China Eastern Airlines
• CNH Global
• Domino's Pizza
• Nordstrom
Sources: Companies’ websites. All brands and product names are trademarks of their respective owners.
Click link for related resources:
Exercise 1: Analyzing Balance Sheets
Exercise 2: Analyzing Income Statements
Exercise 3: Financial Reporting Environment
Exercise 4: Analyzing Cash-Flow Statements
Exercise 1: Analyzing Balance Sheets
Topics:
- Level 1: Analyzing Primary Elements - Financial Leverage
- Level 2: Analyzing Major Categories - Working Capital and Current Ratios
- Level 3: Analyzing Line Items - Common Balance Sheets and Asset Risks
- Overall Financial Strength of Balance Sheets Across Companies and Industries
Exercise Materials:
Exercise 1 [pdf]
Excel template 1 [xlsx] Excel template 1[xls]
Word template 1 [docx] Word template 1 [doc]
Videos:
Searching and Locating Annual Reports 1 [10 minutes]
Locating Stock Prices Using Big Charts [3 minutes]
Using Excel 1: Basics [26 minutes]
Exercise 2: Analyzing Income Statements
Topics:
- Level 1: Analyzing Comprehensive Income- ROE-CI
- Level 2: Analyzing Major Categories- ROE
- Level 3: Analyzing Significant Subcategories- DuPont Model
- Level 4: Analyzing Line Items- Common-Size Statements and Revenue Growth
- Overall Financial Performance Across Companies and Industries
Exercise Materials:
Exercise 2 [pdf]
Excel template 2 [xlsx] Excel template 2 [xls]
Word template 2 [docx] Word template 2 [doc]
Videos:
Searching and Locating Annual Reports 1 [10 minutes]
Using Excel 1:Basics [26 minutes]
Exercise 3: Financial Reporting Environment
Topics:
- Fourth Quarter Earnings Conference Calls
- Analyst Reports
- Media Reports
- Stock Market Reaction
- Overall Financial Reporting Environment
Exercise Materials:
Exercise 3 [pdf]
Word template 3 [docx] Word template 3 [doc]
Exercise 4: Analyzing Cash-Flow Statements
Topics:
- Level 1: Big Picture Analysis of Operating, Investing, and Financing Subtotals
- Level 2: Determining and Analyzing Cash Surpluses and Shortfalls
- Level 3: Analyzing How Cash Shortfalls are Covered or Surpluses are Used
- Operating Cash-Flow Reconciliation Analysis
- Overall Cash Flow Conclusions
Exercise Materials:
Exercise 4 [pdf]
Excel template 4 [xlsx] Excel template 4 [xls]
Word template 4 [docx] Word template 4 [doc]
Exercise 5: Time to Reflect
Topics:
- What are the ten most important things you learned from the course?
- What criteria did you use to select and rank items for your top-ten list?
Exercise Materials:
Exercise 5 [pdf]
Word template 5 [docx] Word template 5 [doc]