Pipeline Forecast & Coverage Calculator

See whether your pipeline can hit the number: a weighted sales forecast, commit, your coverage ratio against what your win rate requires, the gap to target, how much new qualified pipeline you'd need, and which lever to pull. Enter stage totals or paste your deals as CSV. It runs the same rules as AAJ's pipeline-and-forecast engine, and refuses a number it cannot read instead of changing it. Runs in your browser; no signup.

Use the tool at aajconsult.com/tools/pipeline-forecast-calculator.

What is pipeline coverage?

Coverage is your open pipeline divided by your target. The pipeline you need scales with your win rate: at a 25% win rate you need roughly 4× coverage, because only about one in four qualified deals closes.

How the lever is chosen

The weighted forecast is Σ amount × probability; commit is the deals at 75% or more; best case assumes every open deal closes. The engine then checks five cases in order: on track (commit and the weighted forecast both clear the target); on track on average but not committed; advance deals (half or more of the pipeline sits below 25% probability); build pipeline (coverage below 1 ÷ win rate); otherwise improve conversion. A pipeline that already covers the target is never told to build more.

Frequently asked questions

How much pipeline coverage do I need?

Roughly 1 ÷ your win rate. A 25% win rate needs about 4×, a 33% win rate about 3×. That is arithmetic, not a benchmark: if only one in four qualified deals closes, you need four times the target in pipeline.

What stage probabilities should I use?

Your own historical conversion from each stage to closed-won. The example's probabilities (10 / 25 / 50 / 75 / 90%) are placeholders, not a benchmark: treat the output as directional until you replace them with your own.

What's "new pipeline needed"?

The gap to target divided by your win rate — how much additional qualified pipeline you'd have to create now to cover the shortfall at your current close rate.

Can I paste my deals instead of stage totals?

Yes. Paste a CSV or a spreadsheet copy with a header row: an amount column and either a stage column (matched to the stage names in the table) or a probability column in percent. Up to 500 deals. A line the calculator cannot read is named, and nothing is loaded until it is fixed.

What does the recommended lever mean?

It is the pipeline-and-forecast engine's rule, checked in this order: on track (commit and the weighted forecast both clear the target); on track on average but not committed; advance deals (half or more of the pipeline sits below 25% probability); build pipeline (coverage below 1 ÷ win rate); otherwise improve conversion.

Is this stored or shared?

No. Everything runs in your browser, nothing is saved or sent, and there's no signup. Refreshing the page clears it.

Related resources

Unit Economics Calculator — Marketing Budget Calculator — All free tools — Marketing consulting services

Building with AI agents? This is the web version of AAJ's open-source pipeline-and-forecast skill — explore the catalog at skills.aajconsult.com.

A forecast tells you where you stand. A plan tells you what to do.

If your coverage is thin or your conversion is leaking, AAJ's Growth Audit turns this snapshot into a prioritized pipeline plan in 7 days. Book a Growth Audit.

More in Sales & Pipeline

Part of the Sales & Pipeline hub - see all 38 resources on this topic.

• Playbook: Account-Based Marketing (ABM) Playbook
• Article: Battlecards for a Three-Rep Team
• Article: Cold Email for Founders: How to Write a Sequence That Gets Replies
• AI agent skill: Cold Email Sequence

Also useful in Analytics, Experiments & Budget.