Every serious financial model — from a corner restaurant to a $50bn LBO — is built on the same backbone: an integrated 3-statement model. The Income Statement, Balance Sheet, and Cash Flow Statement aren't three separate reports. They're three views of the same business, mechanically linked, so that every dollar of revenue, every dollar of CAPEX, and every dollar of debt repayment shows up in the right place automatically.
Get the linkages right and you have a model an investor can audit. Get them wrong and you have three lies that don't agree with each other. This guide walks through exactly how the three statements connect, in what order to build them, and the single trick — "the plug" — that keeps the Balance Sheet balanced. A free downloadable Excel template is at the bottom.
What 'Integrated' Actually Means
An integrated 3-statement model has exactly one set of input assumptions feeding all three statements simultaneously. Change the revenue growth rate on the assumptions tab and: the P&L recalculates, the Balance Sheet's Accounts Receivable scales accordingly, the Cash Flow Statement reflects the working capital drag, retained earnings updates, and the Balance Sheet still balances.
If any of those linkages is missing, the model isn't integrated — it's three spreadsheets in a trench coat. Investors notice.
How the Three Statements Link
There are exactly three master linkages every modeler must hardwire. Once these are in, the rest is plumbing.
Net Income flows to Retained Earnings
Bottom of the Income Statement → Net Income. That number flows directly into the Balance Sheet as an addition to Retained Earnings. The formula is dead simple:
Retained Earnings (end) = Retained Earnings (begin) + Net Income − Dividends Paid
If your retained earnings doesn't roll forward this way, the Balance Sheet won't balance, period.
Depreciation flows to Cash Flow
Depreciation is a non-cash expense — it reduces P&L profit but doesn't actually leave the bank account. The Cash Flow Statement therefore adds it back on the first line under operating activities. Same goes for amortisation, stock-based compensation, and any other non-cash charge. Forget this and your cash forecast will be wrong by the entire depreciation amount, every year.
Cash flows back to Balance Sheet
The last line of the Cash Flow Statement is Change in Cash. This becomes the ending cash balance on the Balance Sheet. Specifically:
Cash (end of period) = Cash (begin of period) + Change in Cash (from CFS)
Three linkages. Memorise them. Every other connection in the model is a special case of one of these.
Build Order: Why You Always Start With the Income Statement
There is one — and only one — correct order to build a 3-statement model:
1. Build the assumptions tab (revenue drivers, cost ratios, CAPEX, financing, tax)
2. Build the full Income Statement, top to bottom, down to Net Income
3. Build the Balance Sheet, leaving cash blank for now
4. Build the Cash Flow Statement, which calculates the missing cash balance
5. Feed cash back into the Balance Sheet — and watch it balance
Why this order? Because the Cash Flow Statement is mathematically derived from the change in Balance Sheet items plus Net Income. You can't build it until both other statements exist. Founders who try to build the Cash Flow Statement first invariably end up with a circular reference and a corrupt file.
The Plug: Balancing Your Balance Sheet
The single phrase that separates amateur modelers from professionals is "the plug". Here's the trick.
After you build the P&L and the Balance Sheet (with cash blank), every item on the Balance Sheet is determined by an operating or financing assumption — except cash. Cash is the residual. It's whatever's left after every other source and use is accounted for.
So instead of trying to forecast cash directly, you build the Cash Flow Statement, which calculates the change in cash. You apply that change to last year's cash balance. The new cash balance plugs into the Balance Sheet — and if every linkage upstream is correct, the Balance Sheet now balances automatically.
The Balance Sheet balancing isn't a coincidence. It's a consequence of getting the linkages right. If it doesn't balance, you have a bug — and the bug is almost always one of:
• Net Income from P&L not flowing correctly to Retained Earnings
• Depreciation included twice (once in P&L, once again in CFS — but not added back)
• CAPEX missing from the Cash Flow Statement
• Debt issuance / repayment in the wrong sign
Worked Example: A 3-Year Forecast
Let's walk through a tiny example. A B2B SaaS company starts Year 1 with $1M in cash, $400k in receivables, $200k in PP&E, $300k in debt, and $1.3M in equity. We'll forecast three years.
Revenue assumptions
• Year 1 revenue: $2.0M (existing base)
• Annual growth: 60% → 50% → 40%
• Gross margin: 78% (stable, SaaS-typical)
Operating costs
• S&M: 35% of revenue (scales with growth)
• R&D: 22% of revenue
• G&A: $400k flat in Y1, grows 15%/year
• Depreciation: $80k flat (linked to CAPEX schedule)
Working capital
Receivables: 45 days of revenue. Payables: 30 days of COGS + Opex. These two drive the operating working capital line on the Balance Sheet, and the change in working capital flows through the Cash Flow Statement.
CAPEX & depreciation
CAPEX of $150k/year (laptops, infrastructure). Straight-line depreciation over 5 years → $30k/year incremental depreciation, layered onto the $80k from prior assets.
Debt & equity
• Existing $300k venture debt amortises at $60k/year
• No new debt, no new equity raises in the base case
Plug those assumptions into the integrated model and you get three statements that balance year by year, with cash falling in Year 1 (heavy S&M investment), turning positive in Year 2, and compounding in Year 3 as gross profit scales faster than fixed opex. That's the shape of a healthy SaaS business in one chart.
Common Errors That Break the Model
Six errors account for ~80% of broken 3-statement models in the wild. Check yours against this list before sending to anyone.
• 1. Hardcoded numbers in formulas. If a formula contains *0.78 instead of =GrossMargin%, you've hidden an assumption. Investors won't trust the model.
• 2. Iterative calculation on. If your model only balances when you toggle on iterative calculations, you have a circular reference — find and remove it.
• 3. Interest expense calculated on ending debt. Should be average debt (or beginning debt, by convention). Using ending debt creates a circularity with the Cash Flow Statement.
• 4. Working capital signs flipped. An increase in Accounts Receivable is a USE of cash (subtract). An increase in Accounts Payable is a SOURCE of cash (add). Get these wrong and your cash forecast is mirror-imaged.
• 5. Dividends or distributions missing. If owners are taking distributions, they must flow out of Retained Earnings and out of cash on the CFS. Most first-time models forget the second leg.
• 6. Tax expense on book vs cash basis confusion. P&L tax is on accrual income. Cash taxes paid may differ (deferred tax assets/liabilities). For early-stage modeling, you can simplify by assuming book = cash.
Download: Free 3-Statement Template
We've built a professional 3-statement template that already encodes every linkage in this article — Net Income → Retained Earnings, depreciation add-back, cash plug, working capital schedule, debt amortisation schedule, and integrated tax calculation. It's the same architecture used by analysts at top consulting and private equity firms.
You bring the assumptions. The model handles the plumbing.
|
Download the 3-Statement Financial Model Template Fully integrated Income Statement, Balance Sheet, and Cash Flow Statement. 5-year monthly + annual forecast. Scenario engine (Base / Upside / Downside). Comes with a populated example. Excel and Google Sheets compatible. → Get the Template → |
FAQ
How long should my 3-statement model project forward?
Five years is standard for fundraising; ten years is standard for DCF valuation work. For SMB management use, three years monthly + two years annual is the sweet spot.
Should I model monthly, quarterly, or annually?
Monthly for the first 12–24 months (the period investors stress-test most), then quarterly or annual thereafter. Monthly granularity past Year 2 adds cells but no insight.
Can I build a 3-statement model in Google Sheets?
Yes. Every formula in this article works identically in Sheets. The main trade-off is performance — Sheets slows down past ~50,000 active cells. For a 5-year monthly model, you'll be fine.
Why is my Balance Sheet off by exactly the amount of depreciation?
You're depreciating PP&E on the Balance Sheet but forgetting to add depreciation back on the Cash Flow Statement (or vice versa). It's the single most common 3-statement bug.