Unit 9 · Unit 9: Financial Statements
Where the three statements stop being separate reports and become one connected machine — and why a correctly linked model balances on its own.
The statements are three windows onto the same activity, joined by a handful of links.
Everything in the course so far has built individual schedules: revenue, costs, depreciation, working capital, debt. Unit 9 is where they snap together. The income statement, cash flow statement, and balance sheet are not three reports that happen to use similar numbers — they are three views of the same economic activity, and a small set of mechanical links holds them in lockstep. Get the links right and the model behaves like a single machine: change one assumption and every statement updates consistently.
There are really only three master links to understand. Net income ties the income statement to both of the others. Ending cash ties the cash flow statement to the balance sheet. And every schedule updates the one balance-sheet account it controls. Once you can see those three connections, the model stops being mysterious.
Links, not copies A linked model never re-types a number from one statement onto another. Each figure lives in exactly one place and is referenced everywhere else. That single source of truth is what makes the whole system internally consistent.
Net income is the hinge: it lifts equity and seeds the cash flow statement.
Net income is the single most important link in the model because it touches all three statements. It is the bottom line of the income statement; it raises retained earnings (and therefore equity) on the balance sheet; and it is the starting point of the cash flow statement, where accrual profit is converted back into actual cash. Follow net income carefully and the rest of the linking logic becomes obvious.
Ending Retained Earnings = Beginning Retained Earnings + Net Income − DividendsThis roll-forward is the bridge from the income statement to the equity section of the balance sheet. Dividends are the only thing that leaks profit out of equity.
On the cash flow statement, net income sits at the very top of the operating section. From there you add back non-cash charges (chiefly depreciation), adjust for changes in working capital, and arrive at cash from operations. Investing activities (mostly capex) and financing activities (debt and dividends) follow. The whole point is to reconcile accrual earnings with the cash that actually moved.
CFO = Net Income + Depreciation ± Changes in Working CapitalDepreciation is added back because it reduced net income without using cash. A rise in working capital consumes cash; a fall releases it.
Why two destinations, no double counting Net income increases equity on the balance sheet AND starts the cash flow statement, but it is never counted twice. The cash flow statement explains how that same profit turned into cash, and the resulting cash change is what ultimately reconciles the balance sheet.
Ending cash lands on the balance sheet, and every schedule updates its own account.
The cash flow statement sums operating, investing, and financing cash to produce the net change in cash. Add that to the opening cash balance and you get ending cash — which is precisely the cash line reported on the balance sheet. This is the second master link, and it is the one that ultimately makes the balance sheet tie out: cash absorbs everything the other statements did.
Ending Cash = Beginning Cash + CFO + CFI + CFFCFI is dominated by capex; CFF by debt draws/repayments and dividends. Ending cash is then posted directly to the balance sheet.
Every other balance-sheet account is updated by the schedule that controls it. The PP&E schedule rolls gross assets up by capex and down by depreciation. The working-capital schedule sets receivables, inventory, and payables from days assumptions tied to revenue and costs. The debt schedule rolls each tranche forward by draws and repayments. Each schedule owns exactly one account, so there is never ambiguity about where a number comes from.
| Schedule | Balance-sheet account | Roll-forward driver |
|---|---|---|
| Income statement → equity | Retained earnings | + Net income − dividends |
| PP&E schedule | Net property, plant & equipment | + Capex − depreciation |
| Working-capital schedule | Receivables / inventory / payables | Days assumptions × revenue or COGS |
| Debt schedule | Debt (and revolver) | + Draws − repayments |
| Cash flow statement | Cash | + Net change in cash |
Each account has one owner If you can name the schedule that owns a balance-sheet line, you can always answer 'why did this number change this year?' That one-owner discipline is the backbone of an auditable model.
A correctly linked model satisfies A = L + E automatically; the plug is the proof, not a patch.
Here is the part that confuses people. If every account is driven by its own schedule, why does the balance sheet balance? The answer is that the statements are not independent — they share net income and they share cash. When net income raises equity, it also flows through the cash flow statement and changes cash by exactly the offsetting amount. Every transaction has two sides, and a correctly linked model preserves both sides everywhere. So Assets = Liabilities + Equity holds automatically.
Assets = Liabilities + Shareholders' EquityIn a correctly linked model this is an output, not something you force. If it fails to hold, you have a linking error — a missing or double-counted side of a transaction.
There are two distinct things people call a 'plug,' and confusing them causes real damage. The cash-flow plug is just the cash line: cash is whatever the other statements leave behind, and posting ending cash to the balance sheet is what closes the loop. The financing plug is different and deliberate — it is the revolver (or cash sweep) that funds a shortfall or absorbs surplus so the company never shows impossible negative cash. Neither is a fudge factor; both are legitimate mechanisms.
| Plug | What it is | Legitimate? |
|---|---|---|
| Cash / balancing plug | Ending cash posted from the cash flow statement; closes A = L + E | Yes — it is how the model proves it balances |
| Financing plug (revolver) | Revolver draw/repay that funds shortfalls or sweeps surplus | Yes — a deliberate capital-allocation choice |
| A hand-typed 'plug' number | A figure entered to force the balance sheet to tie | No — that hides a real linking error |
Never type a number to make it balance If a hand-built model won't balance, the temptation is to drop in a 'plug' that forces the difference to zero. That doesn't fix the model — it buries the bug. A genuine imbalance always means a transaction is missing one of its two sides.
In this tool the balance is guaranteed The Income Statement, Cash Flow, and Balance Sheet tabs are auto-linked by the engine, and the balance-sheet plug plus the revolver mean the statements always balance. You read the linkages and interrogate the results instead of wiring cross-sheet references and chasing a broken balance.