A three-statement financial model links the income statement, balance sheet and cash flow statement so that one set of assumptions flows through all three. To build one: (1) enter historical data, (2) set assumptions, (3) forecast the income statement, (4) build supporting schedules (capex and depreciation, working capital, debt), (5) forecast the balance sheet, (6) derive the cash flow statement, and (7) link cash back to the balance sheet and check it balances.

Key takeaways

• Net income connects the income statement to both the cash flow and the balance sheet.
• The cash flow statement explains every change in the balance sheet.
• Supporting schedules keep the main statements clean.
• A balance check row is mandatory. If it isn’t zero, something is broken.

How the three statements link

From	To	Link
Income statement: net income	Cash flow statement	Starting line of cash from operations
Income statement: net income (less dividends)	Balance sheet	Increases retained earnings
Income statement: depreciation	Cash flow statement	Added back (non-cash)
Balance sheet: working capital changes	Cash flow statement	Increase in assets uses cash; increase in liabilities provides cash
Balance sheet: PP&E	Cash flow statement	Capex appears in investing cash flow
Balance sheet: debt	Cash flow statement	Borrowing and repayment appear in financing cash flow
Cash flow statement: ending cash	Balance sheet	Becomes the cash line

Step-by-step build

Step 1: historical statements

Enter three years of historical income statement, balance sheet and cash flow data. Check the historical balance sheet balances before you go further.

Step 2: assumptions

In one clearly marked area, set revenue growth, gross margin, operating expenses as a % of revenue, tax rate, capex, depreciation rate, receivable/payable/inventory days, interest rate and dividend policy. Base every assumption on history or a stated reason.

Step 3: forecast the income statement

Revenue → cost of sales → gross profit → operating expenses → EBITDA → depreciation → EBIT → interest → tax → net income.

Step 4: supporting schedules

• PP&E schedule: opening PP&E + capex − depreciation = closing PP&E.
• Working capital schedule: receivables, inventory and payables driven by days assumptions.
• Debt schedule: opening debt + new borrowing − repayments = closing debt; interest calculated from it.

Step 5: forecast the balance sheet

Pull closing balances from the schedules. Retained earnings = opening + net income − dividends. Leave cash for last.

Step 6: build the cash flow statement

• Operating: net income + depreciation − increase in working capital
• Investing: − capex
• Financing: + borrowing − repayments − dividends

Ending cash = opening cash + net change in cash.

Step 7: link and check

Link ending cash to the balance sheet. Add a row: total assets − (liabilities + equity). It must be zero in every period.

Best practices that interviewers notice

• Inputs in blue, formulas in black, links to other sheets in green (a common convention)
• No hard-coded numbers inside formulas
• One consistent timeline across all sheets
• Clear labels and units (thousands, millions)
• A separate checks section

Common errors

• Sign errors in working capital (an increase in receivables uses cash)
• Forgetting to link dividends to retained earnings
• Interest causing an unintended circular reference
• Hard-coded “plugs” to force the balance sheet to balance (never do this)

Once the three-statement model works, the next step is valuation: DCF valuation explained. For the bigger picture, see what is financial modelling? and the Excel functions that make this faster in Excel skills for finance jobs.

Build one with a mentor

Tutopiya is planning a live Financial Modelling & Valuation cohort in which you build a full three-statement model and DCF, reviewed by a practising finance professional. It isn’t running yet. Register interest in the financial modelling course. Nothing is charged.

Sources

• IFRS Foundation: IAS 7 Statement of Cash Flows
• Corporate Finance Institute: three statement model

Frequently asked questions

How do the three financial statements link? +

Net income from the income statement starts the cash flow statement and adds to retained earnings on the balance sheet. Non-cash items such as depreciation and changes in working capital adjust net income to cash. The ending cash on the cash flow statement becomes the cash line on the balance sheet.

Why doesn't my balance sheet balance? +

Usually because a balance sheet movement isn't reflected in the cash flow statement, or a sign is reversed. Check that every change in a balance sheet item appears once in the cash flow statement with the correct sign, and that ending cash links to the balance sheet.

How many years should a three-statement model forecast? +

Typically three to five years for most corporate and valuation work, with monthly or quarterly detail in the first year for budgeting models.

What is a circular reference in a financial model? +

It occurs when interest depends on debt or cash balances that themselves depend on interest. Modellers handle it with a circuit-breaker switch or by calculating interest on opening balances to avoid circularity.

Founding cohorts · nothing charged

Want to learn this live, with a mentor?

Tutopiya is planning small, mentor-led online cohorts in English test prep, data & AI, business & finance and digital careers. Tell us which one you want. The programmes with the most interest open first, and the people on the waitlist hear about them first.

See the planned programmes