Building a Three-Statement Operating Model

A single historical income statement tells you what happened last year. It does not tell you what happens if revenue grows 8% next year, or what that growth does to the cash in the bank, or whether the company needs to borrow to fund it. To answer those questions you need the three statements moving together, on the same page, updating each other automatically. That coordinated spreadsheet is a three-statement operating model, and it is the engine behind almost every valuation a bank or a fund produces.

The three statements already talk to each other historically — net income flows into retained earnings, cash flow reconciles to the cash balance. A model just extends that conversation into the future: you type one growth assumption, and every line downstream of it recalculates.

The three links that make it work

Link 1 — the income statement drives the balance sheet. Revenue forecasts drive receivables (customers who have not paid yet), and cost of goods sold drives inventory and payables, usually as a number of days. If receivables are forecast at 45 days of revenue, then $\text{receivables} = \text{revenue} \times 45 / 365$.

Link 2 — the balance sheet drives the cash flow statement. Every period-over-period change in a balance sheet account becomes a cash flow line. Receivables rising by $10m is a $10m use of cash — you sold the goods but have not been paid — and it appears as a negative adjustment in the cash flow statement.

Link 3 — the cash flow statement closes the loop back to the balance sheet. The cash generated (or burned) each period rolls forward into next period's cash balance, and net income rolls forward into retained earnings. This is the "articulation" of the three statements: nothing is entered twice, and the balance sheet must balance in every forecast period, not just the historical ones.

A worked example

Start with a simple base year: revenue $500m, net income $40m, cash $60m, receivables $50m (36.5 days), payables $40m, and no debt. Assume revenue grows 10% and margins hold, so next year's revenue is $550m and net income is $44m. Receivables at the same 36.5 days become $550m \times 36.5 / 365 = $55m — a $5m increase.

That $5m increase in receivables is a use of cash on the cash flow statement, so cash from operations is net income $44m minus the $5m receivables build, giving $39m (ignoring depreciation and other items for simplicity). Ending cash is last year's $60m plus $39m, so $99m, and that $99m — not $60m — is what appears on next year's balance sheet. Retained earnings rises by the full $44m of net income. Every other line unchanged, assets and liabilities-plus-equity still agree at the new, larger total, because each dollar of net income and each dollar of receivables build was tracked exactly once.

Where the circularity bites

Most real models have a debt schedule wired in: if cash from operations is not enough to cover a minimum cash balance, the model draws on a revolving credit line, and that debt then accrues interest, which reduces net income, which reduces cash from operations — a genuine circular reference. Analysts either solve it with a spreadsheet iteration setting or, more commonly, use a circularity breaker switch that zeroes out the interest link so the model can be debugged without Excel spinning.

The output of this whole exercise usually feeds a DCF: free cash flow is a derived line that pulls net income from the income statement and the working-capital changes from the balance sheet, so an error anywhere upstream silently mispricess the valuation downstream.