Excel: Build income statements to identify profit issues

Contents

• Introduction Introduction

  • Comparing financial statements across time

    1m 2s
  • Use key tools to analyze financial statements

    3m 18s
• 1. A Review of the Financial Statements 1. A Review of the Financial Statements

  • Link the accounting equation to all three statements

    3m 7s
  • Analyze balance sheets for assets and liabilities

    5m 18s
  • (Locked)
    Break down the income statement by revenues and costs

    3m 37s
  • (Locked)
    Evaluate cash flows for operations, investing, and finance

    4m 56s
  • (Locked)
    Use AI to generate insights from financial statements

    3m 47s
  • (Locked)
    Excel: Connect the three statements

    10m 2s
• 2. The DuPont Framework 2. The DuPont Framework

  • (Locked)
    Calculate return on equity and assess performance

    3m 20s
  • (Locked)
    Apply DuPont analysis to ROE components

    4m 45s
  • (Locked)
    Compare Ford vs. GM using the DuPont framework

    4m 42s
  • (Locked)
    Automate DuPont analysis using AI tools

    4m 8s
  • (Locked)
    Excel: Use the DuPont Framework to compare companies

    13m 9s
• 3. Common-Size Financial Statements 3. Common-Size Financial Statements

  • (Locked)
    Scale statements with common-size analysis tools

    3m 38s
  • (Locked)
    Convert and analyze a common-size income statement

    3m 24s
  • (Locked)
    Break down a common-size balance sheet for insights

    3m 34s
  • (Locked)
    Compare Walmart and Target’s common-size statements

    4m 55s
  • (Locked)
    Use AI to common-size financial statements

    3m 10s
  • (Locked)
    Excel: Construct and use common-size financial statements

    13m 6s
• 4. Profitability Ratios 4. Profitability Ratios

  • (Locked)
    Discern the many ways to define income and profit

    4m 6s
  • (Locked)
    Compare profitability across industries

    4m 2s
  • (Locked)
    Use AI to compute key profitability ratios

    5m 6s
  • (Locked)
    Excel: Build income statements to identify profit issues

    19m 46s
• 5. Efficiency Ratios 5. Efficiency Ratios

  • (Locked)
    Analyze a company's full operating cycle

    3m 30s
  • (Locked)
    Compute a company's days sales of inventory (DSI)

    4m 31s
  • (Locked)
    Compute and interpret average collection period (ACP)

    4m 18s
  • (Locked)
    Compare Harley and McDonald’s efficiency metrics

    4m 5s
  • (Locked)
    Use AI analysis to detect ratio trends over time

    4m 33s
  • (Locked)
    Excel: Improve cash flow via receivables and inventory

    17m 53s
• 6. Leverage Ratios 6. Leverage Ratios

  • (Locked)
    Rethink the current ratio in today’s context

    4m 22s
  • (Locked)
    Differentiate key debt ratios in financial analysis

    4m 20s
  • (Locked)
    Compare debt ratios across companies

    4m 2s
  • (Locked)
    Use AI to assess financial risk from leverage

    3m 48s
  • (Locked)
    Excel: Analyze ratios for successful companies

    9m 39s
• 7. Limitations of Financial Statement Analysis 7. Limitations of Financial Statement Analysis

  • (Locked)
    Recognize limits of past performance analysis

    2m 44s
  • (Locked)
    Avoid common pitfalls of financial statement analysis

    4m 12s
  • (Locked)
    Resist oversimplifying financial performance issues

    4m 40s
  • (Locked)
    Use AI to spot limits in financial comparisons

    4m 10s
  • (Locked)
    Excel: Spot comparability pitfalls in global financials

    12m 58s
• Conclusion Conclusion

  • (Locked)
    Plan your next steps in financial statement analysis

    4m 11s