Revenue forecast range simulator

Turn three guesses for monthly growth into a range for your future MRR. See the low, median and high for every month. Formulas and sources shown.

$
%
%
%
How growth varies
Advanced: random seed
10,000 runs—
Median MRR
—
MonthLowMedianHighAverage
Low is the 10th percentile and High is the 90th percentile: 10% of the 10,000 simulated runs ended below Low and 10% ended above High. (Some industries write P10 and P90 for the opposite ends, so we do not use those labels.) Each run draws monthly growth from a triangular distribution built from your three guesses; the triangular shape is our choice for turning three guesses into a range, not a finding about real growth. The range comes only from your three guesses: it has no churn model, seasonality or chance of a result outside your low and high. With “Different each month” good and bad months cancel out, so the range is narrower; with “Same for the whole period” it is wider.

How to use it

  1. Enter your starting MRR and how many months to forecast (1 to 36).
  2. Enter your low, most likely and high monthly growth. They must be in that order.
  3. Choose how growth varies: a new rate every month, or one rate kept for the whole period. Read the median first, then the low and high.

“Advanced: random seed” is only for repeating or changing the run. The numbers in the boxes when the page loads are examples, not a forecast.

The math, shown

The simulator plays out your next months 10,000 times, with growth drawn each time from between your low and high guesses, and reports where MRR ends up.

MRR next month = MRR this month × (1 + that month’s growth)

Growth. Drawn from a triangular distribution: it cannot go below your low or above your high, and your most likely figure is the most probable. In “different each month” mode a new draw is made every month; in “same for the whole period” mode one draw is kept for all months.

Runs. 10,000, fixed. Each run starts at your starting MRR.

Low and high. The 10th and 90th percentiles of the 10,000 results: 10% of runs ended below low, and 10% ended above high. Between them lie 80% of the runs.

Median. Half of the runs ended below it and half above.

Average. The mean of the 10,000 results.

Seed. A number that fixes the random draws. The same inputs and seed always give the same table.

The triangular distribution and its sampling method are published (see Sources). Using it to turn three guesses into a range, and the two growth modes, are our own choices, not findings about real growth.

Worked example

The simplest case, so you can check it by hand: start 1,000, 3 months, and low, most likely and high all 3%. Every run grows 3% a month: 1,000 → 1,030 → 1,060.90 → 1,092.73. Low, median and high are all 1,092.73.

With the starting values on the page (start 5,000, 12 months, 0%, 5% and 12%, seed 12345):

  • Different each month: low 8,720.66, median 9,650.75, high 10,725.05 after 12 months.
  • Same for the whole period: low 6,695.89, median 9,579.26, high 14,225.37.

How to read your result

The medians are close, about 9,600, but the width of the range is very different. When growth changes from month to month, good and bad months partly cancel out, so the results cluster: 80% of the runs end between about 8,700 and 10,700. When one rate holds all year, a high rate stays high and a low rate stays low, so 80% of the runs end between about 6,700 and 14,200.

Which one fits depends on what drives your growth: month-to-month luck points to the first; something that holds all year, such as your market or how well your product fits it, points to the second. Many real businesses sit in between, so look at both.

The range describes the simulation built from your three guesses. It is not a promise that your real revenue will land there 80% of the time.

What this tool leaves out

  • Anything outside your three guesses: it cannot show a month worse than your low or better than your high, so a lost large customer, a price change or a new competitor are not in it.
  • Churn and expansion separately (growth is one net rate), and seasonality.
  • The shape of the draw: the triangular shape is our choice for turning three guesses into a range.

Frequently asked questions

Why do the two growth modes give such different ranges?

With a new rate every month, high and low months partly cancel over a year. With one rate for the whole period, a run that draws a high rate keeps it for every month, so the runs spread much more widely. The medians stay close; the widths do not.

Does “80% of runs between low and high” mean my revenue has an 80% chance of landing there?

No. It describes the 10,000 simulated runs, which come only from your three guesses. If your guesses are off, or something outside them happens, real revenue can land outside the range.

Why do the numbers change when I change the seed?

10,000 runs is a sample, not every possible outcome, so a different seed gives slightly different figures. With the same seed and inputs, the table is identical every time. The low and high are labelled “10th percentile” and “90th percentile”, not P10 and P90, because in some industries P10 means the value that 10% of outcomes exceed, which is the opposite end.

Sources

  1. Uranie (CEA): triangular law (opens in a new tab) (the triangular distribution)
  2. uqtestfuns: triangular distribution (opens in a new tab) (sampling method)
  3. DNV: P10, P50 and P90 (opens in a new tab) (why those labels can be read in opposite ways)
  4. Webtilly’s own: the choice of a triangular shape and the two growth modes.

W

Written by the Webtilly team

Formula and sources last checked: 24th Oct 2026 · How we check our work

Note: This tool shows the result of the numbers you enter. It is an estimate, not a forecast, and it is not tax, legal, or financial advice.