The Analyst's Path

Three statement model

A spreadsheet in which the income statement, balance sheet and cash flow statement are linked so that a change in any assumption flows through all three and the balance sheet still balances. Checking that it balances is the model's own test. A sheet that doesn't balance has an error, and finding it's where most of the learning happens. If the model balances only because a plug was inserted, it doesn't balance.

5 min readPart of The Three-Statement LinkageOpen in course mode

Advertisement

Start from what you proved to yourself when you first learned double-entry: every transaction touches at least two places, and at all times Assets = Liabilities + Equity. A company's year is just thousands of such transactions posted to one ledger. The three statements are three different summaries of that single ledger:

  • The balance sheet (BS) is a photograph: the level of every stock (cash, receivables, machines, debt, equity) at one instant. You get one at the start of the year and one at the end.
  • The income statement (IS) is a video of one slice of the ledger: it explains how operations changed owners' wealth during the year. Mechanically, it explains the change in retained earnings, before distributions to owners.
  • The cash flow statement (CFS) is a video of another slice: it explains the change in just one balance-sheet line, cash.

Why do the three statements always tie?

So you have two photographs, and two videos that each explain how one account moved between them. Everything else on the balance sheet moved too: receivables, inventory, PP&E, debt, the equity reserves. Those movements have to show up in the videos as well, because cash and profit are tied to them. A sale you haven't collected raises receivables instead of cash. A machine you bought used up cash without touching profit. So the statements can't help but interlock.

Advertisement

Articulation, the accountant's word for the statements tying to each other, is simply the arithmetic consequence of double entry. If your three statements don't tie, you've made an error somewhere. That's why the balance check at the bottom of every model you'll ever build (Assets − Liabilities − Equity = 0) is a real proof of internal consistency. It's also why analysts trust a model that balances and instantly distrust one that doesn't.

One more consequence is worth taking in now. If you have two of the three statements, plus the opening balance sheet, you can reconstruct the third. Given the IS and both balance sheets, you can derive the entire indirect cash flow statement. You did that when you built the cash flow statement, and the Kaveri Textiles worked example does it again with a twist. Given the IS and CFS and the opening BS, you can roll forward to the closing BS. The statements contain redundant information by design, and that redundancy is your error-checking system for the rest of your career.

The ten ties: the complete map

Here's the full set of seams. Learn them as a numbered list. In the Sundar Snacks Ltd section we'll mark every one of them, by number, on a real two-year company.

#FromToThe rule
T1IS: net incomeCFS: first line of CFO (indirect)Net income is the accrual anchor the CFS un-accrues. (Indian convention anchors at profit before tax — see same cash, different buckets.)
T2IS: net incomeBS: retained earningsClosing RE = Opening RE + Net income − Dividends (− buyback charges when shares are retired). Visible line-by-line in the statement of changes in equity.
T3CFS: net change in cashBS: cashClosing cash = Opening cash + CFO + CFI + CFF (± an FX-effect line for multinationals).
T4IS: D&A expenseCFS: add-back in CFO and BS: net PP&E reductionThe triple path — one number, three appearances (see the D&A triple path).
T5BS: operating working-capital deltasCFS: adjustments inside CFOOperating asset up → cash down; operating liability up → cash up (see the two-question sign method).
T6CFS: capex (in CFI)BS: PP&EClosing net PP&E = Opening + Capex − D&A − disposals at book value — and today's capex is tomorrow's D&A.
T7CFS: debt issued/repaid (in CFF)BS: debt and next year's IS: interest expenseClosing debt = Opening + Issuance − Repayment; Interest ≈ rate × opening (or average) debt. The forward tie — and the source of the revolver circularity (see the revolver circularity).
T8IS: stock-based compensationCFS: add-back in CFO and BS: equity (APIC / SBC reserve)The triple entry: expense, add-back, equity credit (see the triple entry).
T9BS: retained earnings ↓CFS: dividends paid (in CFF)Dividends never touch the income statement (see dividends and buybacks).
T10BS: treasury stock / equity ↓CFS: buybacks (in CFF)Buybacks never touch the income statement either (see dividends and buybacks).

Four of these ties are really roll-forward schedules, little engines of the form Closing = Opening + additions − subtractions:

Cash:  Closing cash = Opening cash + CFO + CFI + CFF                    (T3)
RE:    Closing RE   = Opening RE + Net income − Dividends − Retirements  (T2, T9)
PP&E:  Closing PP&E = Opening PP&E + Capex − D&A − Disposals (book)      (T4, T6)
Debt:  Closing debt = Opening debt + Issuance − Repayment                (T7)

Every linked model, including the ones you'll build by hand this week, is nothing more than an income statement, these four schedules, a working-capital block, and a cash flow statement that assembles the pieces. Memorize the four roll-forwards now. Everything else hangs off them.

Advertisement

Part of the course

This page is part of The Three-Statement Linkage (M1.05), in Phase 1: Accounting: the language of business. The module's flashcards and its quiz are in the app.