The problem: A projected balance sheet that will not balance usually points to broken links between cash flow, working capital, debt and retained earnings — not a single formula error.
A projected balance sheet that refuses to balance is one of the most common — and frustrating — issues in financial modeling. The gap between assets and liabilities plus equity rarely comes from one obvious mistake; it usually reflects a broken linkage somewhere in the three-statement model.
Why It Matters
An unbalanced balance sheet undermines the credibility of the entire model. Reviewers, auditors and decision-makers cannot trust downstream outputs — ratios, returns, leverage — when the foundational accounting equation does not hold.
What to Check
- Cash flow linkage: the balance sheet cash figure must equal prior-period cash plus net cash flow from the cash flow statement. A hard-coded cash number or a broken link is the most frequent cause.
- Retained earnings: current retained earnings should equal prior retained earnings plus net income minus dividends. Forgetting to deduct dividends or linking the wrong net income line creates a persistent gap.
- Debt schedule: new borrowings and repayments must flow from the debt schedule to both the cash flow statement and the balance sheet. Double-counting or omitting a drawdown breaks the balance.
- Working capital: changes in receivables, inventory and payables must move consistently between the cash flow statement and the balance sheet. Sign errors are common.
- Circular references: a broken or iterative interest circuit can quietly distort cash and debt balances.
Quick Reconciliation Check
| Balance sheet line | Must reconcile to |
|---|---|
| Cash | Prior cash + net cash flow from CFS |
| Retained earnings | Prior RE + net income − dividends |
| Debt | Prior debt + drawdowns − repayments |
| Working capital | Movement matches CFS working-capital line |
Key Takeaway
Balance the model by tracing every balance sheet movement back to its cash-flow driver — cash, retained earnings, debt and working capital must all reconcile period by period.