How much revenue will your current pipeline actually bring in? Most leads never close, so counting every opportunity at full value overstates the quarter. The Sales Forecast Calculator turns your lead count, deal size, and win rate into a realistic revenue estimate.
Sales managers, founders, and freelancers can use it to set targets and plan hiring or spending around expected income.
Table of Contents
- What the Calculator Does
- How to Use It, Step by Step
- The Sales Forecast Formulas
- Worked Example
- How to Read the Results
- Getting Better Inputs
- Limitations and Assumptions
- FAQs About the Sales Forecast Calculator
What the Calculator Does
The tool uses a simple pipeline method. It updates as you type.
- Forecasted Period Sales Revenue: expected deals times average deal value.
- Expected Closed Deals: leads times win rate, shown to one decimal.
- Expected Yield per Lead: revenue divided by leads.
- Monthly Run-Rate Revenue: period revenue divided by the months in your time frame.
- Run Rate x 12 (Assumes Pipeline Refills): the monthly run rate times 12, shown per year.
- Copy Sales Forecast Summary and Reset buttons.
How to Use It, Step by Step
- Enter the count of open opportunities in Pipeline Leads / Opportunities, as a whole number of 1 or more.
- Enter your typical sale size in Average Deal Value ($). It must be at least $1.
- Enter the share of leads that close in Expected Win Rate (%). Type 15 for 15%, from 0 to 100.
- Enter how long the pipeline takes to close in Cycle Time Frame (Months), from 0.25 to 120.
- Read the revenue first, then the run rate and annual figure. Press Copy Sales Forecast Summary to copy the inputs and results. Press Reset to restore the sample figures.
The Sales Forecast Formulas
Each result builds on the one before it.
Leads×Win Rate×Deal Value=Period Revenue
- Closed deals = leads × win rate ÷ 100.
- Period revenue = closed deals × average deal value.
- Yield per lead = period revenue ÷ leads.
- Monthly run rate = period revenue ÷ months in the time frame.
- Run rate x 12 = monthly run rate × 12.
Worked Example
Jamal runs a small web design agency. He has 120 open leads. His average project is $2,800, and he wins about 18% of leads over a 3 month sales cycle.
| Result | Calculation | Output |
|---|
| Expected Closed Deals | 120 × 0.18 | 21.6 Deals |
| Period Revenue | 21.6 × $2,800 | $60,480.00 |
| Yield per Lead | $60,480 ÷ 120 | $504.00 / Lead |
| Monthly Run Rate | $60,480 ÷ 3 | $20,160.00 / Mo |
| Run Rate x 12 | $20,160 × 12 | $241,920.00 / Year |
Jamal can plan around about $20,000 a month. He should treat the annual number as a pace, not a promise.
How to Read the Results
Forecasted revenue is an expected value. Real results will land above or below it.
Expected closed deals can be a fraction, such as 21.6. Treat it as an average across many cycles.
Yield per lead shows what one lead is worth on average. It hints at how much you can spend to find a lead before other costs.
The run rate and annual figure assume the same pace repeats. They make sense only if you keep refilling the pipeline.
Getting Better Inputs
Use your own history for win rate. Divide deals won by leads worked over the last year. A guess here moves the whole forecast.
Keep deal value to realistic closed sizes, not quotes. The conversion rate calculator can help you find a true win rate. The cost per lead calculator shows what each lead costs, which you can compare with yield per lead.
Next, compare the forecast with a goal using the sales target calculator. Check growth with the revenue growth calculator. To test if sales cover your costs, use the break-even point calculator.
See more planning tools in the finance and business calculator hub.
Limitations and Assumptions
- The tool uses one win rate and one deal value for all leads. It does not weight by pipeline stage.
- It does not add seasonality, churn, or new leads arriving later.
- The time frame must be from 0.25 to 120 months. A blank, 0, or smaller entry shows a message instead of a silent default.
- Win rate must be from 0 to 100. Leads must be a whole number from 1 up, and deal value must be at least $1.
- Any invalid entry shows a red message, and all five results show N/A.
- The "Run Rate x 12" card is the monthly run rate times 12, not a full year of pipeline. It assumes the pipeline refills.
- Monthly Run-Rate Revenue spreads the period revenue evenly over your cycle months.
FAQs About the Sales Forecast Calculator
How do you calculate a sales forecast?
Multiply leads by win rate to get expected deals. Then multiply by average deal value. This tool does both steps for you.
What win rate should I enter?
Use your past closed deals divided by past leads. If you are new, start with a cautious guess and update it as data comes in.
What does the cycle time frame mean?
It is the number of months your leads take to close. A 3 month cycle spreads the revenue over 3 months in the run rate.
Why is expected deals a decimal?
It is an average. A result of 21.6 means you may close 21 or 22 deals in a real period.
Is the annualized number a guarantee?
No. It repeats the monthly pace for 12 months. Real sales change with seasons, pricing, and lead flow.
Can I use it for recurring revenue?
Only roughly. Enter the first period value per deal, since the tool does not model renewals or churn.
This calculator gives planning estimates only and is not financial advice. Reviewed for general accuracy by Prof. Dr. Khalil Mudassar, PhD.