Building a three-statement model
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.
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.
- 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.
- 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.
- 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.
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.
The debt schedule feeds interest
The piece that trips people up is debt, because it creates a small loop of its own. You build a separate debt schedule, usually a block below the statements, that tracks each tranche: a revolver, then term loans and senior notes.
Each line runs the same way: beginning balance, plus draws, minus mandatory and optional repayments, equals ending balance. The revolver is the swing piece. If the business runs short on cash, the revolver gets drawn to cover it. If there's excess cash, a cash sweep pays debt down. That's why the revolver is called the plug: it absorbs the shortfall or the surplus so cash never goes negative.
Then the wire back: the debt balances drive interest expense on the income statement. Multiply the balance by the rate, and that interest reduces pre-tax income, which reduces net income, which changes cash, which changes how much debt you pay down.
Read that last sentence again. Interest depends on the debt balance, and the debt balance depends on cash, and cash depends on net income, which depends on interest. That's a loop feeding itself, a circular reference. It's intentional here, not a bug, and it's a favorite follow-up question. Two clean ways to handle it: turn on iterative calculation in Excel, or compute interest on the beginning balance instead of the average. Beginning-balance interest breaks the circle and most interviewers accept it as a fair simplification. Know that the tradeoff exists.
When the balance sheet doesn't balance
It will happen. Assets come out $14 higher than liabilities plus equity and your stomach drops. Stay calm. There is a method.
The rookie move is to panic and start changing formulas everywhere at once, hoping something sticks. That just adds new errors on top of the old one. Check the wires one statement at a time, in order. First: does the cash flow statement's ending cash exactly match the cash line on the balance sheet? Second: did net income flow into retained earnings, and did dividends come out? Third: does the debt schedule's ending balance match the debt on the balance sheet, and is every draw and repayment also hitting the financing section of the cash flow statement? Nine times out of ten the break is one missing link, and going in order finds it in two minutes instead of twenty.
One extra trick: the amount you're off by is a clue. If you're off by exactly the size of one line item, like a capex number or a dividend, that's almost certainly the culprit. A working-capital item that hit the balance sheet but not the cash flow statement is the classic offender, because the sign convention bites: an increase in a current asset is a use of cash.
Sanity-check before you present
Once it balances, don't just exhale. Look at the outputs. Are margins drifting to something absurd? Is the debt paying off in a reasonable number of years? A model that ties but shows a 90% net margin is still wrong. This same discipline carries straight into a DCF and an LBO, which are both built on top of a working three-statement engine.
You probably won't build a full model live, but you will get asked to narrate one. Practice saying the loop in one breath: "Net income flows to the cash flow statement and retained earnings, cash flow gives me ending cash which goes to the balance sheet, and the debt schedule sets interest back on the income statement." Then, if pushed on why the balance sheet won't balance, walk the three checks in order out loud. That calm, sequenced debugging is exactly the composure that separates you in a Superday.
Glossary
New to the lingo? Every term used above, in plain English.
- Income statement
- The report that shows whether a company made a profit over a period, running from revenue at the top down to net income at the bottom.
- Balance sheet
- A snapshot at a single point in time of what a company owns (assets) and what it owes (liabilities), plus the equity left for owners. Assets always equal liabilities plus equity.
- Cash flow statement
- The report that tracks the actual cash moving in and out of a company, bridging accrual profit to real cash. It explains why a profitable company can still run low on cash.
- Net income
- A company profit after all expenses, interest, and taxes are taken out. It is the bottom line of the income statement, also called earnings.
- Retained earnings
- The running total of profits a company has kept over time instead of paying out to shareholders. Each period net income adds to it.
- Non-cash charge
- An expense that lowers reported profit but involves no cash leaving the company, such as depreciation or amortization. It gets added back on the cash flow statement.
- D&A (Depreciation and Amortization)
- Spreading the cost of long-lived assets over the years they are used. Depreciation is for physical assets, amortization for intangible ones. Both are non-cash expenses.
- CapEx (Capital Expenditures)
- Cash a company spends to buy or upgrade long-lived assets like equipment, factories, or technology. It is an investment in the business, not a day-to-day expense.
- Net working capital (NWC)
- The short-term money tied up in running the business, roughly current assets like inventory and receivables minus current liabilities like payables. Growth in it uses up cash.
- Revolver (revolving credit facility)
- A flexible line of credit a company can draw on and repay as needed, like a corporate credit card. In a model it plugs any short-term cash shortfall.
- Cash sweep
- Using a company extra cash to pay down debt automatically each year. It is the engine of deleveraging in a leveraged buyout.
- Senior debt
- The safest, cheapest layer of borrowing, first in line to be repaid and usually secured by assets. It sits at the top of the capital structure.
- Circular reference
- In a model, when two calculations depend on each other, like interest depending on debt while debt depends on cash that depends on interest. Solved by enabling iterative calculation.
Make it stick
Drill what you just learned