Many businesses arrive at an investor meeting with a spreadsheet that projects revenue five years out, subtracts a percentage for costs, and arrives at a profit figure. It looks like a forecast. To an investor, it is a list of hopes. The first detailed question, usually about cash, exposes it.
A financial model is something different. It is a connected structure in which every number has a source, every assumption is visible, and changing one input moves everything that depends on it. That structure is what allows an investor to test the plan rather than simply read it.
Why a revenue forecast alone is not a model
Revenue tells an investor how big the business might become. It says nothing about whether the business can fund that growth, how much capital it will absorb along the way, or when the investor might see a return. Those answers sit in the balance sheet and the cash flow statement.
A business can report rising profits while running out of cash. Customers pay late, inventory builds up ahead of sales, equipment must be bought before new capacity produces revenue. A model that shows only profit hides exactly the risks an investor most wants to understand.
Profit is an opinion shaped by accounting choices. Cash is a fact. Investors read the model to find the cash.
How the three statements connect
A three-statement model links the profit and loss, the balance sheet, and the cash flow statement so that they always agree.
- Profit and loss. Revenue, costs, and profit for each period. Net profit flows into retained earnings on the balance sheet.
- Balance sheet. What the business owns and owes at the end of each period. Changes in receivables, inventory, payables, and debt drive the cash flow.
- Cash flow statement. Starts from profit, adjusts for non-cash items and working capital movements, adds investment and financing flows, and ends with the closing cash balance, which must match the cash on the balance sheet.
When the balance sheet balances in every period and the cash agrees across statements, the model is internally consistent. Investors and their analysts check these links first. A model that does not balance is set aside, regardless of how attractive the forecast looks.
Building from the historical base
Credible projections start from actual results. Three years of historical financial statements establish the base: revenue mix, gross margin, overhead, working capital patterns, and capital expenditure. The forecast then extends those patterns, adjusted for specific, explained changes.
The base year often needs adjustment before it is used. One-off costs, owner-specific expenses, and unusual income distort the starting point. Removing them, and showing that you have, gives the investor a clean foundation and avoids a debate about the starting numbers later.
Where the business has completed months of the current year, current-year management accounts should be included. Investors want to see whether the current year is tracking ahead of or behind the plan.
Assumptions that hold up
Every forecast is a set of assumptions. The model is only as credible as the weakest of them. Strong assumptions share three qualities: they are specific, they are sourced, and they are visible on a single assumptions sheet rather than buried in formulas.
| Driver | Weak assumption | Strong assumption |
|---|---|---|
| Revenue | Revenue grows 30% a year | Two new locations in year two, each reaching the average revenue of existing sites by year three |
| Gross margin | Margin improves to 45% | Supplier contract renegotiated from year two, reducing input cost by a stated percentage |
| Overhead | Costs held at 20% of revenue | Headcount plan by role and start date, with salaries at current market rates |
| Working capital | Not modeled | Customer payment days, supplier payment days, and inventory days based on the last two years |
| Capital expenditure | A lump sum in year one | Equipment list with cost and timing, linked to the capacity it adds |
Revenue should be built from its drivers wherever possible: number of customers multiplied by average spend, locations multiplied by revenue per location, contracts multiplied by contract value. A driver-based forecast lets an investor challenge a specific assumption, rather than rejecting the whole number.
Base, upside, and downside
A single forecast invites a single question: what if it does not happen? Three scenarios answer that question before it is asked.
- Base case. The plan management expects to deliver, using the assumptions above.
- Upside case. What happens if key drivers outperform, for example faster customer growth or earlier margin improvement.
- Downside case. What happens if growth is slower or costs higher, and whether the business still has enough cash.
The downside case is often the most valuable. It shows the investor that management has considered what could go wrong and that the business can survive it. A downside that runs out of cash is not a reason to hide the scenario; it is a reason to size the raise correctly.
A model that only works in the base case is not a plan. It is a bet.
Common errors that undermine trust
- Circular growth. Revenue growth assumed to be funded by profits that only exist because of that growth.
- Missing working capital. Fast-growing businesses consume cash in receivables and inventory. Ignoring it overstates cash, sometimes dramatically.
- Cash that does not reconcile. Closing cash on the cash flow statement that differs from cash on the balance sheet.
- Hard-coded numbers. Figures typed into formulas instead of linked to the assumptions sheet, which makes the model impossible to test.
- No tax or financing costs. Interest on new debt and corporate tax are real outflows and belong in the model.
- Inconsistency with the deck. Revenue or EBITDA in the pitch deck that differs from the model. Investors check.
Presenting the model to an investor
Investors and their analysts open a model looking for three things: where the inputs are, how the statements connect, and what the outputs show. A model that makes those easy to find is read with goodwill.
- A cover and contents sheet that states the company, the currency and units, the version date, and the sheets in the file.
- One assumptions sheet holding every input, clearly marked, so the reader can change a growth rate or a margin and see the effect immediately.
- Statements in a consistent layout, with historical years and forecast years clearly separated, and the same row order across the profit and loss, balance sheet, and cash flow.
- A one-page summary of revenue, EBITDA, cash, and funding needs under each scenario, which is often the page an investor prints.
- Checks, such as a balance sheet that balances and cash that reconciles, shown on the summary so the reader can see the model is sound.
Formatting conventions help as well: inputs in one color, formulas in another, and no hidden sheets or unexplained adjustments. None of this is decoration. It reduces the time an investor needs to trust the numbers, which shortens the path to a decision.
The model behind the conversation
In the first meeting, the deck carries the story. In the second, the model carries the conversation. Investors will ask how sensitive the plan is to pricing, what happens if a key contract is delayed, and how much cash the business needs before it reaches break-even. Founders who can open the model and answer those questions directly earn a level of confidence that no slide can create.
The standard is not complexity. A clear, well-structured model that an investor can follow in thirty minutes is more persuasive than an elaborate one that only its author understands.