📊 Building a three-statement financial model connects your income statement, balance sheet, and cash flow into one dynamic engine. This guide walks you through assumptions, linkages, and best practices so you can forecast with confidence — and make better strategic decisions. Perfect for business owners preparing to raise capital, sell, or simply optimize cash flow.
🧠 Why build a three‑statement model?
A three‑statement financial model combines the income statement (P&L), balance sheet, and cash flow statement into one integrated forecast. Instead of viewing them in silos, you see how revenue growth affects working capital, debt, and equity — and ultimately your cash balance. Banks, investors, and savvy management teams demand this level of rigor.
For multi‑location businesses or those preparing to sell, a dynamic model reveals cash flow bottlenecks and valuation drivers. It’s the difference between guessing and knowing your runway. At CFO for my business, we help owners build models that actually reflect their operations.
Below we break down each component, illustrate with sample tables, and show the wiring. Whether you’re a startup or established firm, these principles apply. And if you get stuck, we’re just a call away.
📞 speak with Ron — get hands‑on help with your model
🏗️ 1. Core structure & key assumptions
Every model starts with a set of drivers. Typical assumptions: revenue growth %, gross margin %, OPEX as % of sales, DSO (days sales outstanding), DPO, inventory days, capex, and tax rate. Below is a simplified assumption table:
| Assumption | FY 2025 | FY 2026 | FY 2027 |
|---|---|---|---|
| Revenue growth % | 12% | 10% | 8% |
| Gross margin % | 45% | 46% | 47% |
| SG&A % of revenue | 28% | 27% | 26% |
| DSO (days) | 42 | 40 | 38 |
| DPO (days) | 30 | 32 | 32 |
| Inventory days | 55 | 52 | 50 |
📈 Income statement (P&L)
The P&L shows profitability. It starts with revenue, subtracts COGS and operating expenses to arrive at EBIT, then interest and taxes. Our model links revenue to working capital and retained earnings on the balance sheet.
⚖️ Balance sheet
Assets = Liabilities + Equity. We project A/R, inventory, AP, debt, and equity based on driver assumptions. The balancing item is usually cash (or revolver). Every P&L item flows through retained earnings.
💵 Cash flow statement
Operating cash flow starts with net income, adjusts for non-cash (depreciation) and changes in working capital. Investing includes capex, financing includes debt draws/repayments. The net change in cash links to the cash balance on the balance sheet – the ultimate check.
| Line item (FY 2025) | P&L | Balance Sheet | Cash Flow |
|---|---|---|---|
| Revenue | ✅ $10,000 | → A/R (asset) | ↗️ operating CF |
| COGS | ✅ $5,500 | → Inventory, A/P | ↘️ working capital |
| Depreciation | ✅ $400 | ↘️ PP&E | ➕ add-back (op CF) |
| Net income | ✅ $2,100 | ➕ retained earnings | ➡️ starting point op CF |
| Dividends / draws | ❌ | ➖ retained earnings | ➖ financing CF |
🔌 Critical linkages & circularities
The magic happens when interest income/expense depends on cash/debt, which depends on interest — a circular reference. Most modelers enable iterative calculations or break the circle with a “cash sweep”. For professional service firms, see our professional services cash flow guide. For multi-location, we recommend this deep dive.
📂 essential resources from our library
🛠️ Tools to build your model
Excel remains king, but specialized tools like Quantrix or Jirav speed up the process. We’ve reviewed top solutions in our financial modeling tools article. The key is flexibility — you need to tweak drivers without breaking formulas.
- Excel / Google Sheets: full control, but prone to errors. Use named ranges and checks.
- dedicated FP&A software: great for recurring forecasting and scenario analysis.
- Hybrid: build a template in Excel, then import to cloud tools.
📌 let’s build yours – personalized model in 2 weeks