Objectives

Section Learning Objectives

1.1

Why Three-Statement Integration Matters

πŸ“– Key Concept

A standalone income statement or balance sheet tells only part of the story. True financial modeling power comes from integrating all three statements so that a change in any assumption automatically flows through the entire model. This is the foundation for DCF valuation, M&A modeling, LBO analysis, and every advanced financial model.

🎯 Real-World Application

When you change a revenue growth assumption in a fully integrated model, it should automatically:

  • Income Statement: Increase revenue β†’ increase COGS/SGA β†’ change net income
  • Balance Sheet: Increase retained earnings, change working capital balances (AR, inventory)
  • Cash Flow: Change in operating cash flow, affect ending cash balance
  • Debt Schedule: More cash may trigger optional debt prepayment (cash sweep)
1.2

Information Flow Between Statements

πŸ”„ Three-Statement Information Flow

Income Statement

Revenue, Expenses, Net Income

↓ Net Income

Balance Sheet

Retained Earnings, Assets, Liabilities

β†’

Cash Flow Statement

Operating, Investing, Financing CF

↓ Change in Cash

Ending Cash Balance

β†’ Back to Balance Sheet

1.3

Key Linking Items

These are the specific line items that connect one statement to another. Each linking item appears on at least two statements.

πŸ“Š Net Income

IS β†’ BS: Flows to Retained Earnings on the Balance Sheet

IS β†’ CF: Starting point for Operating Cash Flow (indirect method)

Retained Earnings (BS) = Prior RE + Net Income βˆ’ Dividends
Operating CF = Net Income + Non-cash adjustments + Ξ” NWC

πŸ“Š Depreciation & Amortization

IS: Expense that reduces net income

BS: Reduces PP&E (accumulated depreciation)

CF: Added back to net income (non-cash expense)

PP&E (BS) = Beg PP&E + CapEx βˆ’ Depreciation
Op CF = Net Income + Depreciation + other adjustments

πŸ“Š Change in Working Capital

BS: Changes in current assets and current liabilities

CF: Operating cash flow adjustment

Ξ” AR = Ending AR βˆ’ Beginning AR (increase = cash outflow)
Ξ” Inventory = Ending Inv βˆ’ Beginning Inv (increase = cash outflow)
Ξ” AP = Ending AP βˆ’ Beginning AP (increase = cash inflow)

πŸ“Š Capital Expenditure

BS: Increases PP&E (gross fixed assets)

CF: Cash outflow in investing activities

PP&E (BS) = Beg PP&E + CapEx βˆ’ Depreciation
Investing CF = βˆ’CapEx + Proceeds from asset sales

πŸ“Š Debt & Interest

IS: Interest expense reduces net income

BS: Debt balance changes with borrowing/repayment

CF: Debt proceeds and repayments in financing activities

Debt (BS) = Beg Debt + Borrowings βˆ’ Repayments
Financing CF = Borrowings βˆ’ Repayments βˆ’ Dividends
1.4

Building Order: Which Statement First?

⚠️ Common Mistake

Many beginners try to build all three statements simultaneously. This leads to confusion and errors. The correct approach is to build them sequentially in a specific order that respects the flow of information.

1

Income Statement

Revenue β†’ Expenses β†’ Net Income

Start here: it generates net income and is relatively standalone

2

Balance Sheet

Working capital, PP&E, debt, equity

Build the long-term asset and liability schedules next

3

Cash Flow Statement

Derive from IS and BS changes

Built last β€” it's a reconciliation of IS + BS changes

4

Balance Check

Assets = Liabilities + Equity

Verify the model balances every period

πŸ’‘ Practitioner Tip

The debt schedule is a supporting schedule that sits alongside the three statements. It feeds interest expense to the IS, debt balances to the BS, and borrowing/repayment flows to the CF. Build it after the IS but before finalizing the BS.

1.5

Common Integration Pitfalls

🚫 Top 5 Mistakes in Three-Statement Models

1. Forgetting to link depreciation to both IS and PP&E roll-forward
Depreciation must reduce PP&E on BS AND appear as expense on IS AND be added back on CF.
2. Wrong sign for working capital changes
Increase in AR = cash outflow (subtract). Increase in AP = cash inflow (add). Getting signs wrong is the #1 cause of imbalanced models.
3. Double-counting interest expense
Interest is already in net income (IS). Don't add it again in the CF statement. Only the principal repayment goes in financing CF.
4. Mixing up beginning and ending balances
For roll-forwards, always use: Ending = Beginning + Additions βˆ’ Subtractions. Previous year's ending = current year's beginning.
5. Not building a balance sheet check row
Always include: = Total Assets βˆ’ Total Liabilities βˆ’ Total Equity. If this β‰  0, your model has an error.
Practice

Hands-on Exercise: Trace a Revenue Shock

Download the dataset and follow the condensed instructions below. The full step-by-step solution is hidden and available by clicking Show / Hide Solution Steps.

Download CSV Download Full Guide (includes solutions)

  1. Open the CSV in Excel and set up the Income Statement for Nexus Corp (2023 historic + 3 forecast years).
  2. Compute AR, Inventory and AP from DSO / DIO / DPO ratios and derive Ξ”NWC for each year.
  3. Build Operating CF = Net Income + Depreciation βˆ’ Ξ”NWC, then Investing CF = βˆ’CapEx, Financing CF = Borrowings βˆ’ Repayments βˆ’ Dividends.
  4. Calculate Ending Cash and update Retained Earnings. Introduce a revenue shock (e.g. βˆ’10% in 2024E) and observe flows across IS β†’ BS β†’ CF.
Summary

Key Takeaways

  • Three statements are linked through specific items: net income, depreciation, working capital, capex, debt
  • Build order matters: IS first β†’ supporting schedules β†’ BS β†’ CF β†’ Balance check
  • Cash is the residual: it balances automatically when all other links are correct
  • Every change in one statement flows through to the other two
  • Always include a balance sheet check row (Assets βˆ’ L&E = 0)
← Back to Lecture Next: Income Statement Links β†’