Three-Statement Model: How to Build an Integrated Financial Model
Why the Three-Statement Model Matters
Every financial model — whether it’s a discounted cash flow, an LBO, or a merger model — starts with a three-statement model. The three statements are mathematically linked: net income flows from the income statement to the balance sheet and cash flow statement. Changes in balance sheet items drive cash flow. Cash flow determines ending cash, which feeds back into the balance sheet.
If the three statements don’t balance, nothing built on top of them will be reliable.
How the Three Statements Connect
| Statement | Key Output | Flows Into |
|---|---|---|
| Income Statement | Net Income | Retained earnings (BS) and starting point of CFO (CFS) |
| Balance Sheet | Total Assets = Liabilities + Equity | Changes in working capital drive operating cash flow |
| Cash Flow Statement | Ending Cash Balance | Cash line on the balance sheet |
Step-by-Step: Building a Three-Statement Model
Step 1 — Gather Historical Data
Pull 3–5 years of historical financials from the company’s 10-K filings. Enter the income statement, balance sheet, and cash flow statement in separate tabs. Calculate key metrics: revenue growth, margins, DSO, DIO, DPO, capex as a % of revenue, and depreciation as a % of PP&E.
Step 2 — Build the Revenue Forecast
Start with revenue forecasting. Use segment-level drivers when possible: units × price, subscriber count × ARPU, or same-store sales growth + new store openings. A top-down % growth approach works for simpler models.
Step 3 — Forecast the Income Statement
Project COGS, SG&A, and other operating expenses using margin assumptions or as a % of revenue. Model depreciation from a separate schedule. Calculate EBIT and EBITDA. Interest expense links to the debt schedule. Apply the effective tax rate to get net income.
Step 4 — Build Supporting Schedules
Create separate schedules for working capital, depreciation and amortization, and the debt schedule. These feed into both the balance sheet and cash flow statement.
Step 5 — Forecast the Balance Sheet
Working capital items (AR, inventory, AP) are driven by DSO, DIO, and DPO assumptions. PP&E = prior PP&E + capex − depreciation. Debt balances come from the debt schedule. Retained earnings = prior retained earnings + net income − dividends. The balance sheet must balance: Assets = Liabilities + Equity.
Step 6 — Build the Cash Flow Statement
Start with net income. Add back non-cash charges (depreciation, amortization, stock-based compensation). Subtract/add changes in working capital. That gives you cash from operations. Subtract capex for cash from investing. Debt issuance/repayment, dividends, and share repurchases go in cash from financing. The ending cash balance must tie to the balance sheet.
Step 7 — Balance and Audit
Add a balance check row: Assets − Liabilities − Equity = 0. If it doesn’t balance, the most common culprits are: missing working capital changes, retained earnings not linking to net income, or the cash balance not tying to the cash flow statement.
Model Architecture Best Practices
| Practice | Why It Matters |
|---|---|
| Use separate tabs for each statement | Keeps the model organized and audit-friendly |
| Color-code inputs vs. formulas | Blue for hard-coded inputs, black for formulas — industry standard |
| One row per line item, one column per period | Makes the model easy to read and extend |
| Build supporting schedules separately | Working capital, D&A, and debt schedules keep the main statements clean |
| Add balance checks | Catches errors immediately — the BS must always balance |
| Avoid hard-coding in formulas | Every assumption should sit in a clearly labeled input cell |
Common Mistakes in Three-Statement Models
Retained earnings don’t link to net income. This is the #1 balancing error. Retained earnings must equal: prior period + net income − dividends declared.
Working capital changes have the wrong sign. An increase in accounts receivable is a use of cash (negative on the CFS), not a source. Many new modelers get this backward.
Circular references from interest. Interest expense depends on average debt, but debt repayment depends on cash flow, which depends on interest. Use iterative calculations or a toggle switch.
Depreciation doesn’t tie to the PP&E schedule. Depreciation on the income statement must exactly match what flows through the PP&E rollforward on the balance sheet.
Key Takeaways
- A three-statement model integrates the income statement, balance sheet, and cash flow statement into a single, self-consistent framework.
- It’s the foundation for every DCF, LBO, and merger model.
- The key linkages are: net income → retained earnings, changes in BS items → cash flow statement, ending cash → balance sheet.
- Build supporting schedules for working capital, depreciation, and debt.
- Always include balance checks — if Assets ≠ Liabilities + Equity, something is broken.
Frequently Asked Questions
How long does it take to build a three-statement model?
For an experienced analyst, a basic three-statement model takes 4–8 hours. A detailed model with segment-level revenue, full working capital schedules, and a debt waterfall can take 2–3 days. Speed comes with practice — most banking analysts build dozens during their first year.
What’s the hardest part of building a three-statement model?
Getting the balance sheet to balance. The most common errors are in working capital sign conventions, retained earnings linkages, and cash balance tie-outs. Build balance check rows early so you catch errors as they happen rather than debugging at the end.
Should I build the cash flow statement using the direct or indirect method?
Use the indirect method. It starts with net income and adjusts for non-cash items and working capital changes. This is what 99% of financial models use because it clearly shows how accrual accounting maps to actual cash generation.
How do I handle circular references in a three-statement model?
The main circular reference comes from interest expense. Interest depends on debt balances, which depend on free cash flow, which depends on interest. Enable iterative calculations in Excel or add a manual circuit breaker. See our circular references guide.
What’s the difference between a three-statement model and a DCF?
A three-statement model projects the financial statements. A DCF is built on top of a three-statement model — it takes the projected free cash flows and discounts them back to present value using the WACC. You can’t build a proper DCF without a three-statement model underneath it.