Test How Much Your Forecast Depends on One Large Deal
Prepared with AI assistance by Alactic Editorial. Examples identified as hypothetical are illustrative, not customer results.
A forecast of $900,000 against a $1 million target can look like a manageable gap. But if $400,000 of that weighted total comes from one opportunity, the real discussion is not simply how to find another $100,000. It is what happens if that opportunity closes smaller, moves into the next period, or does not close.
To test large deal concentration risk in sales forecasting, calculate the largest opportunity’s share of both open pipeline and weighted pipeline, remove its contribution from the period total, and model its amount and timing separately. Give it a separate forecast view when those alternatives materially change the operating decision—even if its current probability looks reasonable.
A weighted total is a calculation, not necessarily the most likely realized result. The worksheet below keeps that distinction visible while giving a sales leader a practical way to review dependence on one deal.
1. Start with a consistent period and amount basis
Before measuring concentration, decide exactly what the forecast counts. Use one period, one currency, and one definition of value throughout the worksheet. Do not mix total contract value for the largest opportunity with annual value for the rest of the pipeline.
Also distinguish closed results from open opportunities. Closed results belong in the period total but not in the denominator for open-pipeline concentration. Combining them can make the open pipeline look less dependent on one deal than it actually is.
For the fictional worked example in this article, all dollar amounts are hypothetical. The team forecasts quarterly bookings in one currency. Closed-won bookings count at their recorded value; open opportunities use their current amount multiplied by an assigned probability. Those probabilities are illustrative inputs, not validated predictions.
- Period target: $1,000,000.
- Closed-won bookings: $200,000.
- Eligible open opportunities: five deals currently assigned to the quarter.
- Largest deal: Orion, with a $500,000 amount and an 80% assigned probability.
The worksheet is a snapshot. Record its date so a later change in concentration can be traced to an amount change, a timing change, or a different set of opportunities—not merely a changed percentage.
2. Fill the concentration worksheet before discussing confidence
Fictional worked example: all opportunities, amounts, probabilities, and outcomes below are hypothetical. This filled worksheet can be copied into a spreadsheet or forecast review document. It is an operating design, not a claim about an existing product feature.
QUARTERLY CONCENTRATION WORKSHEET Basis: bookings; dollars; current-quarter opportunities Period target: $1,000,000 Closed-won bookings: $200,000 Open opportunity Amount Probability Weighted amount Orion $500,000 80% $400,000 Birch $200,000 60% $120,000 Cedar $150,000 60% $90,000 Delta $150,000 40% $60,000 Elm $100,000 30% $30,000 Total open amount: $1,100,000 Total weighted open amount: $700,000 Closed + weighted open: $900,000 Gap to target using weighted total: $100,000 Largest-deal share of open amount: $500,000 / $1,100,000 = 45.5% Largest-deal share of weighted open amount: $400,000 / $700,000 = 57.1% Largest-deal contribution to closed + weighted total: $400,000 / $900,000 = 44.4% EXCLUDING ORION Remaining open amount: $600,000 Remaining weighted open amount: $300,000 Closed + remaining weighted open: $500,000 Gap to target excluding Orion's contribution: $500,000
Each share answers a different question. The 45.5% figure describes the size concentration in open pipeline. The 57.1% figure shows how much of the weighted open calculation depends on Orion. The 44.4% figure describes its contribution to the full weighted period total, including closed bookings.
Keep the denominator in the label. A statement such as “the large deal represents 44% of the forecast” is ambiguous unless the reader knows whether the comparison includes closed results, raw pipeline, or weighted pipeline.
The most revealing line may be the simplest: without Orion’s weighted contribution, the period calculation falls from $900,000 to $500,000. That does not establish the eventual result. It exposes how much the current aggregate depends on one open outcome.
3. Read the weighted total without turning it into a predicted finish
Orion contributes $400,000 to the calculation because $500,000 multiplied by 80% equals $400,000. That does not mean the team expects to book a $400,000 version of Orion. The deal might book at its full amount, close at a revised amount, move to a later period, or fail to close.
Likewise, the remaining opportunities’ $300,000 weighted total is not a guaranteed base. Those opportunities have their own discrete outcomes. Removing Orion isolates one dependency; it does not make the rest certain.
Even if the assigned probabilities were well calibrated, a weighted sum would still not necessarily identify the most likely realized total. Here, no calibration evidence is assumed. Use the calculation as a consistent summary of current inputs, then use scenarios to understand the consequences of specific outcomes.
This distinction matters in the review meeting. “We are forecasting $900,000” compresses several kinds of uncertainty into one number. A more useful statement is: “Our closed-plus-weighted calculation is $900,000, including $400,000 from Orion. Excluding Orion, it is $500,000. We need to review Orion’s full, smaller, and out-of-period outcomes separately.”
4. Test amount and timing as separate variables
Changing a probability alone does not show the business consequence of a smaller or later deal. Build an outcome view that makes the assumed amount booked inside the period explicit.
For the following hypothetical scenarios, hold closed bookings at $200,000 and assume that the other open opportunities produce $320,000 of actual bookings this quarter. The $320,000 is a scenario assumption, not the $300,000 weighted remainder and not a predicted finish. Holding it fixed isolates the effect of Orion.
HYPOTHETICAL OUTCOME VIEW Closed bookings: $200,000 Assumed bookings from other open opportunities: $320,000 Scenario subtotal excluding Orion: $520,000 Target: $1,000,000 Orion outcome This-quarter Period total Vs target Full amount, this quarter $500,000 $1,020,000 +$20,000 Reduced amount, this quarter $350,000 $870,000 -$130,000 Full amount, next quarter $0 $520,000 -$480,000 No booking this quarter $0 $520,000 -$480,000 Partial booking this quarter $200,000 $720,000 -$280,000
The partial-booking row is valid only if the booking definition and the actual deal structure allow a separately bookable portion. Do not create an artificial split simply to soften the downside.
A timing slip and a lost deal have the same current-quarter contribution in this example: zero. They are not the same business outcome, so retain separate labels. A slip also needs to appear in the later-period view, without remaining in the current period at the same time.
The difference between the full in-period and out-of-period scenarios is $500,000. That is the realized-outcome sensitivity under these assumptions. It differs from the $400,000 reduction in the weighted calculation when Orion is removed. Both measures are useful, but they answer different questions.
5. Decide whether the deal deserves its own forecast view
There is no universal concentration percentage that makes a forecast safe or unsafe. A percentage flag can help teams screen a pipeline, but the decision should turn on consequences.
Use three questions to decide whether to separate an opportunity from the aggregate:
- Does its absence change the period narrative? In the example, the weighted calculation moves from near plan to half of target when Orion’s contribution is removed.
- Do plausible amount or timing changes alter an operating decision? If the alternatives lead to different spending, staffing, or internal commitments, leadership needs to see the dependency explicitly.
- Can a blended figure conceal a materially different outcome? A full close and a next-quarter close should not disappear inside the same confidence label.
For Orion, the separate view is warranted because one opportunity separates a hypothetical $1.02 million finish from a $520,000 finish, holding the rest of the scenario constant.
A separate view does not mean removing the deal from every summary. Keep it in the aggregate where appropriate, but display three lines alongside that aggregate: the remainder excluding the deal, the deal’s current contribution, and the amount-and-timing alternatives. This preserves a usable summary without hiding its main dependency.
6. Attach evidence and ownership to the separate view
A large-deal view becomes useful when it tracks what would change the scenario, rather than repeatedly asking the owner whether they still feel confident.
For each material uncertainty, record the current assumption, the evidence supporting it, the person responsible for checking it, and the next review point. Relevant evidence could include a buyer-confirmed decision date, an unresolved approval step, or a documented change in scope. These are recommended review inputs, not proof that a close will occur.
For the hypothetical Orion review, the working note might read:
- Amount assumption: $500,000 remains the active scope; the $350,000 scenario represents a possible reduced scope, not a second opportunity.
- Timing assumption: the current quarter remains the working date, with a next-quarter alternative shown explicitly.
- Owner action: verify the outstanding buyer decision and update the evidence record before the next forecast review.
- Update rule: if the evidence no longer supports the period assignment, revise the current-period view and update the later-period view together.
Do not count Orion once in the weighted total and then add its scenario value on top. The outcome view replaces Orion’s weighted contribution with an explicit scenario amount; it does not supplement it.
7. Recover when the first worksheet gives false comfort
The first pass often reveals problems in the inputs rather than a clean answer. Correct those before interpreting the percentages.
- A large deal is split into several records. If those records depend on the same buyer decision, group them for a second concentration test. Record-level shares can understate dependence on one event.
- The remainder is treated as secure. If the conclusion relies heavily on the other opportunities, test a lower remainder outcome too. Keep the Orion-only test, then add the combined downside rather than quietly changing both variables.
- The next-largest deal becomes dominant. After excluding Orion, recalculate concentration within the remainder. Removing one dependency does not prove the remaining pipeline is balanced.
- The probability is changed to make the total look comfortable. Preserve the prior snapshot and explain the evidence behind any revision. A lower or higher percentage is not a substitute for an amount-and-timing discussion.
- A slipped deal remains in both periods. Reconcile period assignments and scenario labels so the same potential booking is not counted twice.
There is a trade-off in how much detail to maintain. Separate views for every opportunity can overwhelm the review. Start with the deal whose removal most changes the period assessment, then add another only when its uncertainty would change a decision. The goal is visible dependence, not a scenario catalogue.
8. Run a measurable test at the next forecast review
Before the next review, take one dated snapshot and complete the worksheet for the largest opportunity. Bring the three concentration shares, the closed-plus-weighted total excluding that deal, and at least one amount alternative and one timing alternative.
Measure completion by whether the review can answer four questions without reconstructing the spreadsheet:
- How much of the weighted open pipeline comes from this opportunity?
- What remains in the period calculation without it?
- What happens to the period total if it closes smaller or later?
- Which evidence change will trigger an update, and who owns that check?
In the hypothetical example, the useful takeaway is not merely that Orion has a 57.1% share of weighted open pipeline. It is that a $900,000 summary depends on one opportunity whose amount and timing can change the period assessment substantially. Showing that dependency separately gives the team a forecast it can discuss honestly, without pretending the weighted total is the outcome that will occur.
Put the next conversation to work.
Explore Alactic Communications for WhatsApp conversations, campaigns and AI-assisted workflows. Choose the product and plan that fit your team.
Explore Communications