Financial modelling7 min read
Three Financial Statements: Link Income, Cash and Balance
The income statement, the cash flow statement and the balance sheet form one system: every line of one reappears in another. Here are the links to build, a worked example that balances to the cent and the checks that prove your model holds.

Why link the three financial statements
A serious financial model does not project three tables side by side: it projects the three financial statements linked together. The income statement says whether the company makes money, the cash flow statement says whether it collects cash, and the balance sheet says what it owns and what it owes at a given date. All three describe the same year seen from three angles, so they must tell the same story.
The link is not a textbook exercise. A DCF, an LBO model or a financing plan all rest on the same chain: EBITDA (operating profit before depreciation and amortisation) becomes net income, net income becomes cash flow, and that cash flow changes the debt and the cash on the balance sheet. If one link breaks, the model shows a wrong value without warning. A balance sheet that balances every year is the simplest proof that nothing is leaking.
What each statement says
| Statement | What it measures | Period | Question it answers |
|---|---|---|---|
| Income statement | Revenue and expenses | Over the year | Is the company profitable? |
| Cash flow statement | Cash received and cash paid out | Over the year | Where did the cash come from and where did it go? |
| Balance sheet | Assets, liabilities and equity | At year end | What does it own and how is it financed? |
The income statement follows accrual accounting: a sale counts on the day of the invoice, not the day of payment. An investment does not go through it in one go: it is spread out as depreciation (the annual charge that records the wear of a machine or a building). The cash flow statement corrects both differences to get back to the cash actually received.
The five links to build
The whole mechanism rests on five links. In an Excel file, each one is a formula pointing to another sheet, never an amount typed by hand.
- Net income from the income statement is the first line of the cash flow statement, and it is added to the equity on the balance sheet (less dividends paid).
- Depreciation and amortisation are a charge with no cash outflow: they are added back in the cash flow statement, and they reduce net fixed assets on the balance sheet.
- The change in working capital (stock + trade receivables − trade payables) comes from the balance sheet. An increase in working capital consumes cash and is deducted in the cash flow statement. The article on normalised working capital explains how to project it in days of receivables, inventory and payables.
- Capital expenditure (capex) goes out in the cash flow statement and increases the fixed assets on the balance sheet.
- Financing flows (borrowings, repayments, dividends, share issues) pass through the cash flow statement and change the debt or the equity. The year-end cash calculated this way becomes the cash on the asset side of the balance sheet.
The last link closes the loop. If the first four are right, assets equal liabilities and equity without any balancing line.
Worked example: one projection year
Take Lefort Emballages, a fictional industrial SME. Opening balance sheet (year 0): €8.0m of net fixed assets, €3.0m of trade receivables, €2.0m of stock and €1.5m of cash, that is €14.5m of assets. On the other side: €1.8m of trade payables, a €6.0m bank loan and €6.7m of equity.
Year 1 assumptions: revenue from €20.0m to €21.0m (+5%), an EBITDA margin of 15%, depreciation and amortisation of €0.85m, interest of 5% on the opening debt, tax at 25%, capex of €1.0m, loan repayment of €1.0m and dividends of €0.5m.
Step 1: the income statement
| Line | Year 1 |
|---|---|
| Revenue | €21.0m |
| EBITDA (15%) | €3.15m |
| − Depreciation and amortisation | − €0.85m |
| Operating profit | €2.30m |
| − Interest (5% × €6.0m) | − €0.30m |
| Profit before tax | €2.00m |
| − Tax (25%) | − €0.50m |
| Net income | €1.50m |
Step 2: the cash flow statement
Working capital rises from €3.2m (3.0 + 2.0 − 1.8) to €3.4m (receivables 3.2, stock 2.1, payables 1.9): it increases by €0.2m.
| Line | Year 1 |
|---|---|
| Net income | €1.50m |
| + Depreciation and amortisation | + €0.85m |
| − Increase in working capital | − €0.20m |
| Operating cash flow | €2.15m |
| − Capex | − €1.00m |
| − Loan repayment | − €1.00m |
| − Dividends | − €0.50m |
| Change in cash | − €0.35m |
The company earns €1.50m and its cash falls by €0.35m. There is no contradiction: it repays its bank, invests and pays its shareholders faster than it collects cash.
Step 3: the closing balance sheet
| Assets | Year 1 | Liabilities and equity | Year 1 |
|---|---|---|---|
| Fixed assets (8.0 + 1.0 − 0.85) | €8.15m | Equity (6.7 + 1.50 − 0.5) | €7.70m |
| Trade receivables | €3.20m | Loan (6.0 − 1.0) | €5.00m |
| Stock | €2.10m | Trade payables | €1.90m |
| Cash (1.5 − 0.35) | €1.15m | ||
| Total | €14.60m | Total | €14.60m |
The balance sheet balances with no forcing. That is the sign the five links are in place.
The test that shows why the links matter
Suppose Lefort's customers pay two weeks later: receivables end at €3.7m instead of €3.2m. The income statement does not move, and net income stays at €1.50m. But the increase in working capital rises to €0.7m, operating cash flow falls to €1.65m and year-end cash to €0.65m. The balance sheet still balances (8.15 + 3.7 + 2.1 + 0.65 = €14.60m).
A model that projects only the income statement misses that €0.5m. It is exactly what a buyer looks at closely, as the article on working capital and valuation explains.
From the three-statement model to the DCF and the LBO
Once the three statements are linked, the free cash flow of a DCF can be read directly: operating profit after tax (2.30 × 75% = €1.725m) + depreciation and amortisation (0.85) − capex (1.0) − increase in working capital (0.2) = €1.375m. You start from operating profit, not net income, because this flow goes back to all the providers of funds, lenders included. The DCF model discounts this flow.
In an LBO the logic is the same, but the flow is first used to repay debt: the cash flow statement feeds the tranche repayment schedule, described in the article on the LBO model.
The checks of a three-statement model
- The balance sheet balance. An "assets − liabilities and equity" line must show zero every year. If it shows a constant gap, look for an input error in the opening balance sheet; if the gap grows, a link is missing in the cash flow statement.
- The cash. The closing cash of the cash flow statement must equal that of the balance sheet. Never copy one into the other: calculate it once and refer to it.
- The signs. An increase in an asset consumes cash, an increase in a liability brings it in. Most gaps come from a reversed sign on working capital.
- The impossible values. Negative debt, negative fixed assets, negative cash with no credit line: each one must trigger a visible alert.
Four common mistakes
- A balancing line. A "gap" cell added to cash to force the equality hides the error instead of fixing it.
- Circular interest. Calculated on the average debt of the year, interest depends on cash, which depends on interest. Calculate it on the opening balance, as here, or solve the loop with a formula rather than with Excel's iterative calculation.
- Forgetting dividends. Net income goes into equity, but dividends come out of it. Leaving them out inflates cash and equity by the same amount: the balance sheet balances, and the error goes unnoticed.
- Working capital days applied to the wrong base. Receivables are calculated on revenue, stock and payables on purchases. Applying the same number of days to revenue for everything distorts the change in working capital.
Start from a model that is already linked. Bridgesheet's three financial statements Excel model projects the income statement, the balance sheet and the cash flow statement over 3 to 10 years from your operating, working capital, capex and debt assumptions, with four integrity checks and interest free of circular references, for €49 and with no subscription. It is an estimate, neither a certified valuation nor investment advice.


