How to Build a Three-Statement Financial Model
Build the income statement, balance sheet and cash flow statement as one integrated system rather than three separate spreadsheets. Start with operational assumptions, build the income statement, link net income and the relevant operating balances into the balance sheet, then derive cash flow from profit, non-cash items, working-capital movements, investing and financing. Finally, reconcile ending cash and confirm the balance sheet balances automatically. If one assumption changes, all three statements should update without manual fixes.
The Hard Part Is Not Building Three Statements
Most finance professionals know what an income statement, balance sheet and cash flow statement are.
That is not the difficult part.
The real modelling skill is making sure the three statements behave as one system.
If revenue changes, that may affect profit, receivables, tax and cash.
If you buy an asset, cash falls, fixed assets increase and depreciation affects future profit.
If you draw debt, cash increases and debt increases. Future interest then affects profit and cash.
Every material assumption has consequences across the model.
Mohamed Chaudry’s Three-Statement Model Framework
I would build and test an integrated model through six stages.
Build the Assumptions
Start with the commercial drivers behind revenue, costs, working capital, capex and financing.
Build Operating Performance
Translate the operating assumptions into revenue, gross profit, operating costs, depreciation, interest, tax and net income.
Model the Financial Position
Link receivables, inventory, payables, fixed assets, debt, equity, retained earnings and cash to the assumptions and other statements.
Derive the Movement in Cash
Start from profit and adjust for non-cash items, working capital, investing and financing activities.
Make the Model Balance
Ending cash must reconcile to the balance sheet and assets must equal liabilities plus equity without an unexplained manual plug.
Change an Assumption
Move a revenue driver, payment term, headcount assumption, capex number or financing assumption and check that the effect flows through automatically.
1. Start With the Drivers
Do not start by typing percentages directly into the financial statements.
Start with the economics of the business.
Revenue might depend on:
- Customers
- Units
- Transactions
- Average selling price
- New customer acquisition
- Churn
- Sales capacity
- Utilisation
Costs might depend on:
- Headcount
- Salary levels
- Customer volume
- Transaction volume
- Production units
- Locations
- Marketing activity
- Infrastructure requirements
Working capital then has its own drivers:
- Customer payment terms
- Supplier payment terms
- Inventory holding
- Revenue timing
- Purchasing timing
The closer the model gets to the operating reality, the easier it becomes to explain why the financial outcome changes.
2. Build the Income Statement
The income statement is usually the logical starting point because it establishes operating performance and produces net income, which connects into the other statements.
A basic structure might include:
- Revenue
- Cost of sales
- Gross profit
- Operating expenditure
- EBITDA
- Depreciation and amortisation
- Operating profit
- Interest
- Tax
- Net income
The important point is that the major lines should come from assumptions rather than arbitrary outputs.
is more useful than:
unless there is a defensible reason why 20% growth is the appropriate underlying assumption.
3. Link Net Income Into Retained Earnings
This is one of the fundamental links between the income statement and balance sheet.
In a simplified model:
If net income changes but retained earnings does not, the statements are disconnected.
That sounds obvious, but broken retained-earnings links are a common reason balance sheets stop reconciling when a model rolls forward.
4. Build Working Capital From Operating Assumptions
Accounts receivable, inventory and accounts payable should not simply grow at arbitrary percentages.
Tie them to the activity that creates them.
| Balance | Typical driver | Why it matters |
|---|---|---|
| Accounts receivable | Revenue and customer payment timing | Slower collections consume cash |
| Inventory | Cost of sales, purchasing and inventory holding | Higher inventory ties up cash |
| Accounts payable | Purchasing and supplier payment terms | Longer payment terms preserve cash temporarily |
| Accruals | Expenses incurred but not yet paid | Creates timing differences between expense and cash |
This is where the model starts connecting operating performance to liquidity.
A business can report strong revenue growth and still consume cash if customers pay slowly or inventory rises faster than sales.
5. Link Capital Expenditure and Depreciation Properly
Depreciation is a good test of whether someone genuinely understands three-statement modelling because it touches all three statements.
Income statement: depreciation reduces profit.
Balance sheet: depreciation reduces the carrying value of fixed assets.
Cash flow statement: depreciation is added back because it is a non-cash expense.
Capital expenditure has a different path.
Income statement: the full capex amount does not normally hit operating profit immediately.
Balance sheet: the asset is capitalised into fixed assets where appropriate.
Cash flow statement: the cash payment appears within investing activities.
Then depreciation moves through future periods.
6. Model Debt Across All Three Statements
Debt creates another important set of links.
Suppose the business draws $1 million of new debt.
Balance sheet: debt increases by $1 million.
Cash flow statement: financing cash inflow increases by $1 million.
Income statement: future interest expense increases according to the debt terms.
When debt is repaid:
Balance sheet: the liability falls.
Cash flow statement: the repayment appears as a financing cash outflow.
If you model the debt drawdown on the cash flow statement without changing the balance sheet liability, the model breaks.
7. Build the Cash Flow Statement From the Other Statements
Do not build cash flow as an independent estimate that happens to sit beside the income statement and balance sheet.
It should explain the movement in cash generated by the model.
Using the indirect method, operating cash flow typically starts with net income and then adjusts for:
- Depreciation and other non-cash items
- Accounts receivable movements
- Inventory movements
- Accounts payable movements
- Other working-capital movements
Then add:
- Investing activities such as capex
- Financing activities such as debt and equity
The result is the net movement in cash.
That closing cash must equal the cash balance shown on the balance sheet.
How the Three Statements Link Together
| Item | Income statement | Balance sheet | Cash flow |
|---|---|---|---|
| Net income | Final profit result | Flows into retained earnings | Starting point for operating cash flow under the indirect method |
| Depreciation | Expense | Reduces fixed asset carrying value | Added back as non-cash expense |
| Accounts receivable | Revenue may already be recognised | Creates an asset | Increase generally reduces operating cash |
| Inventory | Flows into cost as inventory is sold | Unsold inventory remains an asset | Increase generally consumes cash |
| Accounts payable | Expense or cost may already be recognised | Creates a liability | Increase generally preserves operating cash temporarily |
| Capex | Depreciation affects future profit | Increases fixed assets | Investing cash outflow |
| Debt drawdown | Future interest affects profit | Increases debt liability | Financing cash inflow |
| Debt repayment | Interest remains separate from principal | Reduces debt liability | Financing cash outflow |
Why the Balance Sheet Must Balance by Construction
The accounting equation is:
Your model should satisfy that equation because the underlying links are correct.
It should not satisfy it because you typed an unexplained plug into another line.
A balance-sheet check is useful:
If that number is not zero, something is wrong.
Find the broken link.
Do not hide it.
A Simple Worked Example
Suppose a company makes a $100,000 credit sale with $60,000 of associated cost.
At the point of sale
The income statement records:
- $100,000 revenue
- $60,000 cost
- $40,000 contribution before other expenses and tax
If the customer has not yet paid, the balance sheet records an increase in accounts receivable.
The business has recorded revenue but has not received the cash.
Cash-flow consequence
Under the indirect cash-flow method, the increase in accounts receivable reduces operating cash flow relative to accounting profit.
When the customer eventually pays:
- Cash increases
- Accounts receivable decreases
- There is no second sale recorded on the income statement
That is one of the fundamental concepts an integrated model needs to capture.
Another Worked Example: Buying Equipment
Suppose the company buys equipment for $120,000 in cash.
Assume, purely for illustration, straight-line depreciation over four years with no residual value.
When the equipment is purchased
- Cash falls by $120,000
- Fixed assets increase by $120,000
- The $120,000 appears as an investing cash outflow
Over the following periods
Annual depreciation under this simplified assumption would be $30,000.
- Income statement records depreciation expense
- Fixed asset carrying value falls
- Cash flow adds depreciation back as a non-cash expense
One commercial event has now moved through all three statements.
The Model Should Have Checks Built In
Do not wait until the end to discover whether the model works.
Build checks into it.
| Check | What it tests |
|---|---|
| Balance-sheet check | Assets equal liabilities plus equity |
| Cash reconciliation | Cash-flow closing cash equals balance-sheet cash |
| Retained-earnings check | Net income and distributions flow correctly into equity |
| Debt roll-forward | Opening debt plus drawdowns less repayments equals closing debt |
| Fixed-asset roll-forward | Opening assets plus capex less disposals and depreciation reconcile to closing assets |
| Working-capital logic | Operating assumptions flow consistently into receivables, inventory and payables |
Checks should tell you when something is wrong.
They should not correct the model for you.
Mohamed’s One-Assumption Stress Test
The quickest practical test of an integrated model is to change one important assumption.
For example:
- Reduce revenue growth
- Extend customer payment terms
- Add five employees
- Increase capex
- Draw new debt
- Delay a funding round
Then follow the consequences.
If customer payment terms move from 30 days to 60 days, I would expect:
- Revenue recognition may remain unchanged
- Accounts receivable to increase
- Operating cash flow to weaken
- Closing cash to fall
- The balance sheet still to balance
You should not need to repair several unrelated cells manually.
Common Three-Statement Modelling Mistakes
1. Building Three Separate Statements
If the statements do not share formulas and assumptions, you have three spreadsheets rather than an integrated model.
2. Using a Balance-Sheet Plug
An unexplained plug often hides a broken retained-earnings, working-capital, fixed-asset or financing link.
3. Treating Depreciation as Only a P and L Item
Depreciation also affects fixed assets and is added back in the cash-flow statement as a non-cash expense.
4. Modelling Debt Only in Cash Flow
A drawdown or repayment must also change the debt liability on the balance sheet.
5. Building Cash Flow Independently
Cash flow should explain the cash consequence of the income statement and balance-sheet movements, not become a separate forecast with different assumptions.
6. Hardcoding Outputs
Hardcoded forecast outputs break the relationship between assumptions and results and make scenario analysis unreliable.
7. Making the Model More Complex Before It Works
Adding dashboards, valuation tabs and sophisticated scenarios to a model with broken core links only makes the error harder to find.
Three-Statement Model vs Investor-Grade Model
These are related, but they are not the same thing.
| Three-statement model | Investor-grade model |
|---|---|
| Focuses on integrated mechanics | Adds scrutiny and decision-usefulness |
| Links P and L, balance sheet and cash flow | Builds on correctly linked statements |
| Tests whether assumptions flow correctly | Tests whether assumptions can be defended |
| Requires reconciliation | Requires reconciliation plus auditability |
| Technical foundation | Investor-facing application |
| Can be built for internal finance | Designed to survive external scrutiny |
Get the three-statement mechanics right first.
Then add the auditability, variance analysis, scenarios, investor outputs and narrative structure required for external scrutiny.
Why This Skill Matters Beyond Modelling
Three-statement modelling is not valuable because employers enjoy complicated spreadsheets.
It teaches you how the business connects.
You begin to see:
- Why revenue growth can consume cash
- Why working capital matters
- Why capex and depreciation are different
- How debt affects liquidity and profit differently
- How hiring changes profit and cash timing
- Why accounting profit does not equal cash generation
- How operational assumptions become financial outcomes
That understanding transfers directly into forecasting, investment analysis, board reporting, fundraising and CFO-level decision-making.
How Long Does It Take to Learn Three-Statement Modelling?
The mechanics can be learned relatively quickly with focused practice.
Fluency takes longer.
There is a difference between understanding a worked example and being able to build a model from a blank workbook, under time pressure, for an unfamiliar business.
The best way to develop the skill is repeated practice across different business models.
Build one.
Break it.
Find the error.
Build another.
Then start adding scenarios and more complex assumptions.
Mohamed’s Three-Statement Model Pressure Test
Drivers
- Are revenue assumptions tied to real business drivers?
- Are major costs linked to operating assumptions?
- Are working-capital assumptions explicit?
- Can somebody understand where the numbers come from?
Income Statement
- Does revenue flow from assumptions?
- Do costs scale logically?
- Are depreciation, interest and tax treated consistently?
- Does net income link into the rest of the model?
Balance Sheet
- Does retained earnings roll forward correctly?
- Are receivables, inventory and payables linked to operating activity?
- Do fixed assets roll forward?
- Does debt roll forward?
- Does the balance sheet balance without an unexplained plug?
Cash Flow
- Does cash flow start from the model rather than a separate estimate?
- Are non-cash items handled correctly?
- Do working-capital movements flow through?
- Are capex and financing captured?
- Does closing cash reconcile to the balance sheet?
Stress Test
- Can I change one revenue assumption without repairing the model?
- Can I change payment terms and see the cash consequence?
- Can I add debt and see the balance-sheet and interest effects?
- Can I change capex and see the fixed-asset and cash effects?
- Do all checks still pass?
Build an Integrated Model in CFO Academy
Three-statement modelling is part of the technical foundation behind commercial finance.
Inside CFO Academy, the Financial Modelling and Projections course takes you through building an integrated P and L, balance sheet and cash-flow forecast from the ground up.
The objective is not simply to populate a spreadsheet.
It is to understand how revenue, costs, working capital and funding flow through the model, then stress-test those assumptions and interpret what they mean for cash and decisions.
Explore CFO AcademyFrequently Asked Questions
What is a three-statement financial model?
A three-statement financial model is an integrated model linking the income statement, balance sheet and cash flow statement. A change in an operating or financing assumption should flow through every relevant statement automatically rather than requiring manual changes to separate spreadsheets.
How do the three financial statements link together?
Net income from the income statement flows into retained earnings and is also the starting point for operating cash flow under the indirect method. Balance-sheet movements such as receivables, inventory and payables affect cash flow, while investing and financing activities change both cash and the relevant balance-sheet accounts.
Which financial statement should I build first?
The income statement is normally the logical starting point after the operating assumptions because it establishes revenue, costs and net income. The balance sheet can then be linked to those operating drivers and net income, with the cash flow statement derived from the resulting movements.
Why does my balance sheet not balance?
A balance sheet that does not balance usually has a broken or missing link. Common causes include retained earnings, working capital, fixed assets, debt, equity or cash-flow movements. Avoid hiding the problem with an unexplained plug. Find and repair the underlying link.
Should the cash flow statement be built independently?
No. In an integrated model, the cash flow statement should explain the movement in cash created by the income statement, balance-sheet movements, investing activity and financing activity. Building an independent cash forecast with separate assumptions can create contradictions.
How does depreciation flow through a three-statement model?
Depreciation reduces profit on the income statement, reduces the carrying value of fixed assets on the balance sheet and is added back in operating cash flow under the indirect method because it is a non-cash expense.
How do I test whether a three-statement model works?
Change one material assumption and follow its effect through the model. For example, extending customer payment terms should increase receivables and reduce cash without requiring manual repairs elsewhere. The balance sheet should continue to balance and closing cash should reconcile.
What is the difference between a three-statement model and an investor-grade financial model?
A three-statement model establishes the correctly linked financial mechanics. An investor-grade model builds on that foundation with stronger auditability, defensible assumptions, scenario analysis, variance analysis and outputs designed to survive external investor scrutiny.