Three-Statement Financial Model: How the Statements Link
A three-statement model links the income statement, balance sheet and cash flow statement. See the six links that make it balance and how to build it.
Key takeaways
- A three-statement model links income statement, balance sheet and cash flow so each drives the others.
- Closing cash flowing back to the balance sheet is what makes the model balance, and the check must be zero every period.
- It reveals cash shortfalls that a profit forecast alone would hide.
A three-statement financial model projects a company's income statement, balance sheet and cash flow statement together, with each one driven by the others. Its value is that it is self-checking: if the balance sheet balances in every period, the three statements are consistent with each other. If it does not, something is wrong.
What each statement contributes
- The income statement shows revenue, costs and profit over a period.
- The balance sheet shows what the company owns and owes at a point in time.
- The cash flow statement explains how cash moved between two balance sheets.
The six links that make it work
- Net income flows from the income statement into retained earnings on the balance sheet and is the first line of the cash flow statement.
- Depreciation reduces fixed assets on the balance sheet and is added back in the cash flow statement because it is not a cash cost.
- Capital expenditure increases fixed assets and appears as a cash outflow from investing.
- Working capital - receivables, inventory and payables - changes on the balance sheet, and those changes adjust operating cash flow.
- Debt and equity raised or repaid change the balance sheet and appear in financing cash flow, while interest on the debt runs through the income statement.
- Closing cash on the cash flow statement becomes the cash balance on the balance sheet, which is what makes it balance.
How to build one
Start with the revenue and cost drivers and build the income statement down to operating profit. Add supporting schedules for fixed assets, working capital and debt. Build the balance sheet from those schedules, leaving cash until last. Derive the cash flow statement from the income statement and the changes in the balance sheet. Then link closing cash back to the balance sheet and add a check row that must equal zero in every period.
The circular reference
Interest depends on the debt balance, the debt balance depends on cash, and cash depends on interest. Calculating interest on the average balance creates a circular reference. The common solutions are to calculate interest on the opening balance, or to allow iteration with a switch that breaks the circle when the model needs resetting. Whichever you choose, document it.
Why investors and lenders ask for it
A revenue forecast alone can show profit while the business runs out of cash. A three-statement model exposes that gap, because growth that ties up working capital or needs capital expenditure shows up as a cash requirement. It is the base layer for valuation, debt capacity and fundraising analysis, and the foundation of the startup and company financial models we build.
Frequently asked questions
Why does my balance sheet not balance?
The usual causes are an item changed on the balance sheet without a matching cash flow line, a sign error in working capital, or a schedule that does not roll forward correctly. Check the first period in which the difference appears and trace what changed.
Should a startup build a three-statement model?
An early-stage company can start with revenue, costs and cash runway. Once it holds inventory, extends credit, borrows or raises institutional capital, a full three-statement model becomes worth the effort.
How many years should a three-statement model cover?
Three to five years is typical, with the first one or two years monthly so that cash timing is visible. Longer horizons are used for infrastructure and other long-life assets.