Three-Statement Model Interview Prep: Build It From a Blank Workbook
Can a company show profit and still run out of cash? A three-statement model answers that uncomfortable question by forcing the income statement, balance sheet and cash flow statement to tell one consistent story.
- A three-statement model links the income statement, balance sheet and cash flow statement into one forecast engine.
- Start with historical statements, standardize line items, calculate drivers, forecast operations, then let cash and debt close the model.
- The income statement explains profitability, the balance sheet explains financial position, and the cash flow statement explains cash movement.
- The model balances when: Assets = Liabilities + Equity and ending cash in the cash flow statement equals cash on the balance sheet.
- Never “plug” cash or retained earnings blindly. Use net income, dividends, working capital, capex, debt and equity flows to connect the statements.
- Forecast drivers should be business-led: volume, price, margin, working capital days, capex intensity and financing assumptions.
- In interviews, explain the build sequence, the linkages, the checks, and what the model is used for - valuation, credit analysis, budgeting or deal assessment.
Big Picture: The Three Statements Are One Machine
A three-statement model is not three separate tabs. It is one operating machine: profits create retained earnings, operations consume or release working capital, investments create assets, and financing decides whether cash is enough or debt is needed.
Core Explanation: How to Build It From a Blank Workbook
Start with the end in mind: the model must forecast future financial statements and answer a decision question. That question could be “Can this company service debt?”, “What is it worth?”, “How much cash will expansion consume?” or “What happens if margins fall?”
The cleanest blank-workbook build uses seven blocks.
The Three Statements: What Each One Does
The Forecast Driver Matrix: Use Business Logic, Not Guesswork
The best models do not forecast every line item as “last year plus 10%.” They separate what matters from what can be simplified, and what is visible from what must be estimated.
The Essential Linking Formulas
If you remember only one thing, remember the bridges. A model balances because these bridges are correct.
Key Model Metrics to Track
There is no universal “good” number across industries, so always benchmark against comparable companies. For interviews, use these as practical ranges for a reasonably mature non-financial company, then qualify your answer by industry.
Worked Example: Build One Forecast Year End to End
Use this as a miniature model in your head. The numbers are hypothetical and deliberately simple.
Now connect it to cash and the balance sheet:
The balance sheet must now show cash of ₹132.5 crore. PP&E increases by capex and falls by depreciation. Retained earnings increase by net income if there is no dividend. If assets do not equal liabilities plus equity, the issue is in a link - not in accounting theory.
Definitions: Say These Cleanly
- Three-statement model: A linked financial forecast connecting income statement, balance sheet and cash flow statement through operating, investing and financing assumptions.
- Income statement: A period statement showing revenue, expenses and profit generated by the business.
- Balance sheet: A point-in-time statement of assets, liabilities and owners’ equity.
- Cash flow statement: A period statement explaining cash movement from operating, investing and financing activities.
- Working capital: Operating current assets minus operating current liabilities.
Case Study: Trent - Modeling Growth Beyond the P&L
Trent, the Tata Group retail company behind Westside and Zudio, shows why a three-statement model is essential when rapid store expansion meets inventory, leases, capex and cash discipline.
Trent is a strong Indian example because its growth story is not only a revenue story. A simple P&L forecast may say: more stores plus higher sales equals higher profit. A three-statement model asks the harder questions: How much inventory must be carried? How much capex or lease commitment supports new stores? Does supplier credit fund part of the expansion? Does operating cash flow keep pace with growth?
The primary driver of Trent’s modeling story is format-led store expansion, especially through scalable value-fashion retail. Supporting drivers include merchandise discipline, supply chain execution, store productivity, brand positioning across formats and working capital management. A one-cause answer like “Trent grew because Zudio is popular” is incomplete; the financial model must show how popularity converts into cash and return on capital.
The lesson: a good model does not celebrate growth until it has checked cash conversion and reinvestment needs. For Trent or any fast-growing retailer, the winning answer is not just “sales are rising”; it is “sales are rising, margins are holding, inventory is controlled, capex is productive, and operating cash flow supports the expansion path.”
How AI Changes The Three-Statement Model
AI does not replace the analyst’s judgment; it reduces the mechanical work and makes assumption testing faster. In 2026, three changes matter most.
- Faster historical spreading: AI tools can read annual reports and extract financial line items into structured tables. The analyst still checks classification, signs and accounting consistency.
- Assumption research at speed: LLMs can summarize management commentary, earnings-call themes, segment trends and risk factors, helping you defend revenue growth, margin and capex assumptions.
- Scenario generation: AI can create downside cases such as margin compression, delayed receivables, higher interest cost or slower store rollout - but you must choose scenarios that are economically meaningful.
Load the company’s annual report, investor presentation and your draft model assumptions into NotebookLM. Ask: “Create 10 interview questions on whether my revenue, margin, working capital and capex assumptions are defensible.” Then use ChatGPT or Claude to stress-test your model logic, not to invent numbers.
Interview Relevance
“Walk me through how you would build a three-statement model from a blank Excel workbook. Also tell me how you would know whether the model is correct.”
Use one sentence that signals maturity: “I would avoid using cash as an unexplained plug; if the balance sheet does not balance, I would audit retained earnings, working capital, PP&E, debt and cash flow links.”
Common Mistake
The single biggest mistake is treating the model as an accounting formatting exercise and using a balance sheet plug to force it to balance. It costs candidates because it shows they do not understand economic linkages. Fix: build the cash flow statement properly and let ending cash, debt, retained earnings, PP&E and working capital explain the balance sheet.
What to Revise Next
Once the base three-statement model makes sense, move to the two skills that make it interview-grade: financing logic and valuation output.