Home · Guides · Three-statement model that ties out

Guide · ~7 min read

How a 3-statement model ties out

"Does it tie?" is the first thing an experienced investor checks — because a model whose balance sheet doesn't balance is a model you can't trust for anything else. Here's what "tie out" actually means, and the exact plumbing that makes it happen.

The one equation that has to hold

An integrated three-statement model is the income statement, the balance sheet, and the cash-flow statement wired together so a change in one flows to the other two. It "ties out" when this identity holds in every period — not just year one:

If assets come to $2,563,056 and liabilities-plus-equity come to $2,563,056, the balance-check row — assets minus (liabilities + equity) — reads 0.00. If it reads anything else, there is a bug: a number is being counted on one side and not the other, or a plug has been typed in to force it. Investors have seen both, and they know the difference.

The three statements, in order

The order matters, because each statement feeds the next. You cannot build the balance sheet until the income statement and the working-capital drivers are done.

1. Income statement — revenue down to net income. Net income is the single number that flows into two places: it accumulates in retained earnings on the balance sheet, and it's the starting line of the cash-flow statement.
2. Cash-flow statement (indirect method) — start from net income, add back non-cash depreciation, adjust for changes in working capital, subtract capex, add financing. The bottom line is the change in cash, which sets the cash line on the balance sheet.
3. Balance sheet — cash comes from the cash-flow statement; AR, AP and deferred revenue come from working-capital drivers; retained earnings comes from accumulated net income; paid-in capital comes from equity raised. If steps 1 and 2 were done correctly, the two sides are already equal. You do not "make" it balance — it balances because the same dollar is never created or destroyed.

A worked year, on real numbers

Here is year one of the fictional sample company in the worked report (a seed-stage vertical-SaaS business). Every figure below is a computed output of the ModelKit engine — nothing is typed in to force the result.

Step 1 — net income lands in retained earnings

The income statement produces a net loss of −$1,399,764 for the year (revenue of $992,126, minus cost of revenue, minus S&M, R&D and G&A, minus depreciation). Because the company had already burned cash before year one, it opens with a retained-earnings deficit. The roll-forward is simple:

Retained earnings, roll-forward	Amount
Opening retained earnings (prior burn)	−$600,000
+ Net income, year 1	−$1,399,764
Ending retained earnings	−$1,999,764

Opening retained earnings = opening cash ($3,200,000) − capital raised to date ($3,800,000) = −$600,000. That gap is prior-period burn; putting it in opening retained earnings is what makes the very first column balance, exactly as a real workbook must.

Step 2 — the cash-flow statement sets the cash line

Net income is a loss, but the company didn't burn the full loss in cash, because deferred revenue (annual prepayments) and payables were a source of cash:

Cash flow (indirect), year 1	Amount
Net income	−$1,399,764
+ Depreciation (non-cash add-back)	+$7,937
− Increase in accounts receivable	−$141,344
+ Increase in accounts payable	+$222,067
+ Increase in deferred revenue	+$540,752
= Cash from operations	−$770,351
− Capital expenditure	−$39,685
+ Equity raised	$0
Net change in cash	−$810,036

Beginning cash of $3,200,000 plus a net change of −$810,036 gives an ending cash of $2,389,964. That number, and only that number, is what appears on the balance sheet's cash line. There is no separate "cash" assumption to fat-finger.

Step 3 — the balance sheet balances by construction

Balance sheet, end of year 1	Amount
Cash (from the cash-flow statement)	$2,389,964
Accounts receivable	$141,344
Net PP&E (capex − depreciation)	$31,748
Total assets	$2,563,056
Accounts payable	$222,067
Deferred revenue	$540,752
Paid-in capital	$3,800,000
Retained earnings	−$1,999,764
Total liabilities + equity	$2,563,056
Balance check (assets − L − E)	0.00

Both sides come to $2,563,056. The check reads 0.00 — not because anyone plugged it, but because every dollar of net income, every dollar of working capital, and every dollar of cash was tracked on both sides of the ledger.

Why the working-capital lines are where models break

Notice that three of the balance-sheet lines above — AR, AP, deferred revenue — also appeared in the cash-flow statement as "changes." That is the wiring that catches people out. If your balance sheet shows accounts receivable growing but your cash-flow statement doesn't subtract that growth, cash is overstated and the model will not tie. The rule:

• An increase in an asset (AR, inventory) uses cash — subtract it in the cash-flow statement.
• An increase in a liability (AP, deferred revenue) is a source of cash — add it.
• Every working-capital balance on the balance sheet must have a matching "change" line in the cash-flow statement, driven by the same assumption (days sales outstanding, days payable, deferred-revenue percentage). Drive them from two different places and they drift.

Educational material only — not investment, legal, financial, accounting, or tax advice, and not a valuation opinion. Figures are illustrative outputs of a deterministic model.

← All guides · Next: SaaS metrics investors check →