How to Review a Three-Statement Model
A three-statement model lives or dies on its links. The income statement feeds retained earnings, the cash flow statement reconciles net income to cash, and the balance sheet must balance in every period. Reviewing one means confirming those connections hold.
Confirm the balance sheet balances every period
Find or build a check row that subtracts total liabilities and equity from total assets. It should read zero across all periods.
If a check is non-zero, the error is almost always in the cash flow statement or in retained earnings. Note the first period that breaks and work from there, because errors compound forward.
Trace the income-statement-to-equity link
Net income should flow into retained earnings on the balance sheet, less dividends. Select the retained earnings cell and trace its precedents.
Confirm it references the prior-period retained earnings plus current net income, and that the net income reference points at the income statement and not a hardcoded copy.
- Select current-period retained earnings on the balance sheet.
- Trace precedents and confirm prior retained earnings plus net income minus dividends.
- Follow the net income reference back to the income statement bottom line.
- Repeat for the first and last forecast periods to catch broken drag-fills.
Check the cash flow reconciliation
The cash flow statement should start at net income, add back non-cash items, adjust for working capital changes, and end at the change in cash. The ending cash balance must equal the cash line on the balance sheet.
Tie the ending cash cell to the balance sheet cash cell directly. If they differ, a working capital sign is flipped or a non-cash add-back is missing or double-counted.
Walk the circular references in interest
Many models carry a circular reference because interest expense depends on the debt balance, which depends on cash, which depends on interest. Confirm iterative calculation is enabled under File > Options > Formulas if the model relies on it.
ModelMint's Formula Trace helps you follow the loop deliberately: step from interest expense to the average debt balance and back, one layer at a time, so you can confirm the circularity is intentional and not an accidental self-reference.
Spot-check the links across all three tabs
Pick three or four driver cells and trace their dependents to confirm a change ripples through all three statements. Bump revenue and watch net income, retained earnings, and cash all move.
A model where a driver change touches only the income statement has a broken link somewhere downstream. Tracing dependents finds the gap faster than reading every formula.
Formula Trace
Follow links across the income statement, balance sheet, and cash flow one layer at a time.
Get ModelMint See how it worksFAQ
Where do balance sheet errors usually come from?
Almost always the cash flow statement or retained earnings. A flipped working capital sign, a missing non-cash add-back, or a net income link pointing at a stale copy will throw the balance off in the period where it starts.
How do I know if a circular reference is intentional?
Interest-on-debt loops are the common intentional case. Trace interest expense back to the debt and cash balances; if the loop closes on itself by design and iterative calculation is on, it is intentional. An accidental self-reference traces back to its own cell.
What is the fastest single check for model integrity?
Change one revenue driver and watch all three statements move while the balance check stays at zero. If anything fails to update or the check breaks, you have a broken link to chase down.