THE BLOG FREE TOOLS

Sales Forecast Calculator

Estimate future sales with a simple sales forecast calculator using leads, conversion rate, deal size, growth, and repeat revenue.

By Patrick FrankAugust 28, 20262 min readFREE · NO EMAIL NEEDED

PATRICK FRANKNo. 095TOOLSAUG 20262 MIN READSales Forecast CalculatorFREE
TOOL
095

Sales Forecast Calculator

Estimate future revenue using leads, conversion rate, average deal size, growth assumptions, sales cycle lag, and repeat purchase inputs. Results are calculated with transparent formulas and shown directly on the page.

Optional Assumptions

Leave any of these blank and the forecast uses the base formula only.

Example numbers. Type yours.

TOTAL FORECAST REVENUE —
AVERAGE REVENUE PER PERIOD —
TOTAL EXPECTED CUSTOMERS WON —
HIGHEST FORECAST PERIOD —

Period-by-Period Forecast

Revenue is shown when recognized, including optional lag and repeat purchase assumptions.

PeriodForecast LeadsExpected Customers WonNew Sales RevenueRepeat RevenueTotal Forecast Revenue
Formula Explanation
  1. Conversion rate, growth rate, and repeat purchase rate are converted from percentages to decimals.
  2. For each period, forecast leads are calculated as: Base Leads × (1 + Growth Rate)period index (the first period’s index is 0).
  3. Expected customers won are calculated as: Forecast Leads × Conversion Rate
  4. New sales revenue is calculated as: Expected Customers Won × Average Sale Value
  5. If a sales cycle lag is entered, revenue from a source period is recognized in a later period by shifting it forward by the lag value.
  6. If repeat purchase inputs are provided, repeat revenue is calculated as: Expected Customers Won × Repeat Purchase Rate × Average Repeat Purchase Value
  7. Total forecast revenue per period is: Recognized New Sales Revenue + Recognized Repeat Revenue
  8. Summary metrics are then calculated from all displayed periods, with currency rounded to two decimals for display.

TAKE IT FURTHER · $99 FREE

Get the Free Financial Model Template

Access to 3 Powerful Financial Models Used by Successful Businesses

Free. Comes with my newsletter. Unsubscribe anytime.

Plan Revenue with a Practical Sales Forecast

A strong forecast helps you make better decisions about hiring, budgeting, pipeline goals, and growth expectations. This Sales Forecast Calculator is built for teams that want a clear view of future revenue without wrestling with a complex spreadsheet. By entering leads, conversion rate, average deal size, and forecast length, you can quickly estimate expected sales across monthly, quarterly, or yearly periods.

See the Drivers Behind the Numbers

The tool keeps the math visible, which makes it easier to trust the results. Base revenue is calculated from lead volume, win rate, and average sale value. If your business is growing, you can layer in a period-over-period growth rate to model compounding results. You can also account for a sales cycle lag, which is useful when deals close in one period but revenue is recognized later.

Build a More Realistic Revenue Projection

For businesses with returning customers, repeat purchase assumptions add another layer of insight. That means your sales forecast calculator can reflect both new business and follow-on revenue in one simple view. If you need a fast, transparent way to create a revenue projection, this tool offers a clean, practical starting point for smarter planning.

FAQs

How does this sales forecast calculator estimate revenue?

It starts with a simple formula: leads multiplied by conversion rate multiplied by average sale value. From there, the tool applies any optional assumptions you enter, such as compounded growth from one period to the next, a sales cycle delay that pushes recognized revenue into future periods, and repeat purchase revenue based on your selected rates and values. The result is a transparent forecast you can review period by period.

What if I don't know my growth rate or repeat purchase numbers yet?

That's completely fine. The calculator is designed to work with just the core inputs: forecast period, leads, conversion rate, average sale value, and the number of periods to display. If optional fields are left blank, the forecast uses only the base sales formula, which is often the best place to start when you're building a simple revenue projection.

Can I use this for monthly, quarterly, or yearly planning?

Yes. You can choose the forecast cadence that matches the way your business plans and reports. Whether you're mapping monthly pipeline performance, quarterly targets, or a yearly revenue view, the calculator organizes the forecast by period so you can compare expected customers, new sales, repeat revenue, and total revenue in a format that's easy to scan.

MORE FREE TOOLS

ALL 26 TOOLS

READ NEXT

WANT TO KNOW THE “SECRET SAUCE”?

I WON'T TELL YOU ALL OUR SECRETS BUT I WILL DEFINITELY SEND YOU A NEWSLETTER TWICE A MONTH WITH SOME STUFF I BET YOU DIDN'T KNOW.