Resource

Stop Forecasting from the Target. Start Forecasting from the Business.

Written by Johnnie Walker
Business PlanningFinancial Planning & Analysis

There’s a particular kind of investor meeting where a founder presents a revenue forecast and the room goes quiet in the wrong way.

The numbers are ambitious but not unreasonable. The growth curve looks compelling. And then someone asks a question, “walk me through how you got to that Q3 number,” and the answer reveals that the model was built backward from a desired outcome rather than forward from the actual mechanics of the business.

That moment is not a math problem. The numbers might be correct. It is a credibility problem, and credibility problems in fundraises are expensive.

The most common misconception about investor scrutiny of revenue forecasts is that investors are skeptical of optimism. They are not. Early-stage investors have funded businesses where the base case turned out to be a fraction of what the company actually achieved. They are comfortable with uncertainty and with ambition. What they are not comfortable with is a forecast that cannot be explained — one where the assumptions are buried in formulas, the drivers are unspecified, and the only real answer to “what makes this number” is “that’s what we need to raise at this valuation.”

Investors distrust undocumented assumptions. The fix is not a more conservative forecast. It is a more rigorous one.

Why Most Startup Forecasts Fail the Credibility Test

The failure mode that shows up most often is top-down construction: take a large market, apply a small percentage capture assumption, and derive a revenue figure that looks plausible because the math works. “The TAM is $12 billion. We need to capture less than one percent of it.” That framing is not a forecast. It is a market sizing exercise that has been relabeled. It says nothing about how the revenue gets acquired, at what cost, over what timeline, or on what assumptions about conversion and retention.

Investors who have reviewed hundreds of decks recognize this pattern immediately, and when they see it, the credibility of everything else in the model drops. Not because the market size is wrong or the percentage is implausible, but because a forecast built that way reveals that the team has not done the harder work of modeling their actual go-to-market motion. It suggests the number was chosen because it supports the narrative rather than because it follows from the business.

The second failure mode is missing variance analysis. Most startup forecasts present a single scenario — implicitly the base case — with no documentation of what happens if key assumptions prove wrong. When an investor asks what the model looks like if the sales team achieves 70% of plan, or if the average sales cycle extends by six weeks, or if net revenue retention comes in 15 points below the assumption, the answer should come from a model that has already been built. When it requires real-time recalculation, or produces visible discomfort, the signal is clear: the team has not stress-tested their own assumptions. Which raises the question of whether they believe them.

The third is the disconnect between the forecast and the actual sales motion. A model that projects revenue linearly when the business has a lumpy, enterprise-dominated pipeline is not reflecting how the business actually works. A forecast built on assumed conversion rates that do not match the pipeline data is aspirational by definition. Investors who ask to see the pipeline alongside the forecast — which the good ones do — will find the disconnects quickly, and finding them creates more doubt than the original optimism was worth.

Bottoms-Up vs. Top-Down: The Only Approach That Works

A bottoms-up revenue forecast is built from the actual inputs that drive revenue in the business, not from a target number worked backward to its implied assumptions. The starting point is understanding what kind of revenue model the company is actually operating.

For an ARR or SaaS business, the primary drivers are new logo acquisition — broken out by segment or channel with explicit pipeline and conversion assumptions — expansion revenue from the existing customer base, and gross and net retention. Each of those components has its own set of assumptions, each of which can be grounded in historical data and stress-tested independently. The output is a revenue forecast that is the sum of defensible parts, not a curve drawn to hit a number.

For a transactional or marketplace business, the drivers are different: volume, transaction frequency, average order value or take rate, and customer acquisition and retention dynamics that may look quite different from a subscription model. The bottoms-up approach is the same — identify the actual inputs, build from them, and separate the assumptions from the outputs — but the specific structure of the model reflects the specific structure of the business.

Usage-based models require particular care because the revenue drivers are often less predictable than in pure subscription models. Seat expansion, usage growth within existing accounts, and the rate at which new product features drive incremental consumption are real inputs that need to be modeled explicitly, with historical data as the reference point and explicit assumptions about how those drivers evolve.

In every case, the discipline is the same: identify the two or three primary inputs that drive the majority of revenue, build the forecast from those inputs, and make every assumption visible. The bottoms-up forecast is not inherently more conservative than a top-down one. It is more defensible, because every number has a source and every assumption has a name.

Structuring the Assumptions Layer

The assumptions layer is the part of the model that separates a forecast investors trust from one they do not. It is also the part that is most consistently absent or buried.

The principle is structural separation: assumptions live in a dedicated tab or clearly demarcated section, and the output calculations reference them rather than embedding the logic inline. This is not primarily an aesthetic choice. It is functional. When assumptions are separated, an investor can review them independently, understand what is historical fact, what is a calibrated estimate, and what is aspirational, and engage with the forecast as an argument rather than a black box. When assumptions are embedded in formulas, the model cannot be read or challenged except by someone willing to reverse-engineer it cell by cell.

Every assumption in a well-built model carries a label indicating its basis. Historical assumptions are grounded in actuals — the conversion rate from qualified opportunity to close over the last four quarters, the average contract value in a specific segment over the last twelve months, the gross retention rate across the cohorts that have had enough time to mature. These are not estimates. They are measurements and presenting them as such is important. Estimated assumptions are calibrated judgments: the expected improvement in sales cycle length as the team develops better qualification processes, the projected expansion rate in an enterprise segment that is newer and has less historical data. Aspirational assumptions are the forward-looking bets the business is making — the new channel that has not ramped yet, the pricing adjustment that has not been tested, the product expansion that is expected to open a new buyer persona. These belong in the model, clearly labeled. What they cannot be is invisible or misrepresented as historical.

The way investors read a well-structured assumptions tab is diagnostic. They look first at whether the historical inputs are consistent with the actuals they can verify in the data room. If the model assumes 40% conversion from SQL to close and the actual pipeline data shows 28%, the discrepancy needs to be explained before any other conversation can proceed. They look next at how aspirational assumptions are labeled and supported. An assumption that is optimistic but explicitly labeled as aspirational, with a specific rationale attached to it, reads very differently from an optimistic assumption presented as historical. The first demonstrates rigor. The second erodes it.

Scenario Ranges: The Trust Builder

A single-scenario forecast is a statement of belief. A three-scenario forecast is a demonstration of analysis. The difference, in investor perception, is significant.

The bear case is the one that matters most, and the most common mistake in building it is not being genuinely conservative. A bear case that is five to ten percent below the base case is not a stress test. It is the base case with a rounding error. A credible bear case asks what the business looks like if the top two or three assumptions that drive revenue prove materially wrong — if the new channel ramps more slowly than projected, if the enterprise sales motion extends, if the retention rate that was improving reverses — and it translates those assumption changes into a coherent financial picture, including the runway implications.

The bear case should make the leadership team somewhat uncomfortable. If it does not, it has not been built conservatively enough. Investors who review a bear case and find it plausible respect the modeling. Investors who review a bear case and find it implausibly optimistic draw conclusions about the rigor applied to the whole model.

The upside case serves a different purpose. It shows investors what the business looks like if the best-case assumptions materialize, which is useful context for understanding the return profile of the investment. But it also, when paired with a genuinely conservative bear case, shows the range of outcomes management has considered — that the business is being run with an understanding of what could go wrong as well as what could go right.

The presentation framing that works best in board meetings and investor conversations is explicit: “Our base case requires these specific inputs to hold. Here is what drives each of them. Here is the downside scenario if the two most sensitive inputs come in 20 to 25 percent below expectation — the runway impact is X, and the adjustment we would make is Y.” That framing communicates control. It says the team has thought through what they would do if things go sideways, which is exactly what investors want to know. A management team that has rehearsed the downside is a management team that will not be surprised by it.

The Board-Ready Revenue Narrative

The model is the evidence. The narrative is the argument. Both have to be present, and they have to be consistent with each other, because investors read across them.

The revenue narrative connects the forecast to the go-to-market motion in specific terms. Not “we will grow enterprise sales significantly next year” but “we are entering the year with eight enterprise opportunities in late-stage diligence, average deal size of $180,000, a historical close rate of 35% in that segment, and a sales cycle that has compressed from nine months to seven over the last three quarters — this is the pipeline that drives Q1 and Q2 in the base case.” That specificity is what makes a narrative credible. It tells the investor that the number in the model is attached to something real.

The cadence of forecast reviews shapes the quality of the narrative over time. A management team that reviews the forecast monthly — comparing actuals to the plan, identifying where assumptions proved wrong, updating the forward projections to reflect what was learned — arrives at each board meeting with a narrative that is consistent and current. The variance analysis is ready. The explanation for the miss or the beat is already in the board package because it was built when the information was fresh. The forecast has been updated before the meeting, not after.

Quarterly cadence tends to produce the opposite dynamic: a management team that looks at the forecast four times a year is often reconciling a significant gap between where the model said the business would be and where it actually is, under time pressure, before a board meeting. The variance analysis is constructed rather than maintained. The narrative has gaps because no one looked at the assumptions when they started to drift. Monthly review is not about creating more work. It is about distributing the work across the period rather than compressing it into the week before the board meeting, and it produces a narrative that reflects genuine engagement with the model rather than pre-meeting preparation.

The forecast that survives investor scrutiny is not the most optimistic one. It is the one that can be read as a complete argument — where the assumptions are documented, the bottoms-up logic is traceable, the scenarios have been built with intellectual honesty, and the narrative connects the numbers to the actual mechanics of the business. Building that kind of forecast takes more time than building a top-down curve. It also converts at a higher rate when the term sheets come in.

About the Author

Johnnie Walker

Co-Founder of Rooled, Johnnie is also an Adjunct Associate Professor in impact investing at Columbia Business School. Educated in business and engineering, he's held senior roles in the defense electronics, venture capital, and nonprofit sectors.