Financial Modeling

Building a three-statement model

By SuperdayReps · Wharton MBA · ex-Greenhill · investment banking interview coaching

6 min read · updated July 2, 2026

Knowing the three statements link is one thing. Wiring them together in a live model, so a single input change flows everywhere and the balance sheet still ties, is the actual job. This is where beginners freeze. If you haven't got the concept down yet, read Walk me through the three statements first, then come back. This article is about the plumbing.

Here's the mindset that fixes most of it: a three-statement model is a closed loop, not three tabs. Cash flows out of the income statement, through the cash flow statement, and lands back on the balance sheet. If you can name the wires, you can build one, and you can fix one when it breaks.

Follow the arrows: net income feeds the cash flow statement and retained earnings, and ending cash lands back on the balance sheet. That loop is the whole model.

The three wires that close the loop

Every three-statement model runs on the same three connections. Memorize these and the structure stops being mysterious.

  1. Net income feeds two places. It's the starting line of the cash flow statement (top of cash from operations), and it flows into retained earnings on the balance sheet. Same number, two destinations.
  2. Ending cash lands on the balance sheet. Add the three cash flow sections to get the net change in cash, add that to last period's cash, and drop the result onto the balance sheet's cash line.
  3. Non-cash and working-capital items reverse on the cash flow statement. Non-cash charges like D&A reduced net income but no cash left, so you add them back. Changes in net working capital and capex are cash moves that never touched the income statement, so they show up here.

Build in that order. Income statement drives net income. Cash flow statement translates net income into cash. Balance sheet receives the ending cash and the updated retained earnings. Then check that assets equal liabilities plus equity.

Key insight

There is no separate "cash" plug you type in. Cash on the balance sheet is an output, computed by the cash flow statement. Beginners who hardcode a cash number break the loop and can never get the model to balance. The balance sheet balances because every other line is already accounted for. If it doesn't, one of your links is wrong, not the balance sheet itself.

Keep reading

The rest of this lesson is free with an account

There's about 3 more minutes of Building a three-statement model below this, plus every other lesson in Financial Modeling. Free account, no card.

Any partner school .edu

Frequently asked

How do the three financial statements link together in a model?
The three statements form a closed loop. Net income flows from the income statement into both retained earnings and the top of the cash flow statement, the cash flow statement computes ending cash, and that cash lands on the balance sheet. The debt schedule then sets interest back on the income statement.
Why won't my balance sheet balance and how do I fix it?
It won't balance because one link is broken, not because the balance sheet itself is wrong. Check the wires one statement at a time, in order: does ending cash match the balance sheet cash line, did net income hit retained earnings, and does the debt schedule tie to the financing section?
Should you hardcode the cash figure on the balance sheet?
No. Cash on the balance sheet is an output computed by the cash flow statement, never a number you type in. Hardcoding cash breaks the closed loop and the model can never balance. The balance sheet ties precisely because every other line is already accounted for correctly.
LearnAI