Expansion Revenue Calculator
The formula
What the expansion revenue tells you
Every dollar of new ARR found inside existing customers — tier upgrades, additional products and usage growth combined into the numerator of net retention.
Calculation: Expansion = upsells + cross-sells + usage growth; rate = expansion ÷ starting ARR. Enter your inputs and every substitution is shown below the result.
Reading the result
Composition matters as much as size: usage-driven expansion is sticky and automatic, while one-off annual upsells can mask flat underlying adoption.
Rules of thumb: 12–20% of starting base per year is a strong expansion motion in mid-market SaaS
Limitations and best practice
Do not count sales-team re-negotiations at list-price increases as expansion in CS-scored cohorts; double-counting inflates the account team’s credit and hides true churn.
This calculator gives an estimate based on standard formulas; it is not professional financial, medical, legal or engineering advice. Verify anything you plan to act on with a qualified professional and your own records.
Frequently asked questions
Expansion or new logos — where is marginal budget best spent?
Is price-increase revenue expansion?
Source & methodology
SaaS cohort-metric convention (OpenView definitions).
Expansion Revenue: the number, the method and the caveats
This page was written for one job: turning your own inputs into a defensible figure, with the working shown. There are plenty of pages about Expansion Revenue; almost none of them show the working. This one does: the formula, every input, a fully computed example, and a sensitivity analysis calculated live from this engine’s own defaults.
There is a habit that separates people who get useful answers from Sales & Revenue numbers: they decide what question the figure answers before they compute it. Expansion Revenue answers “Expansion revenue?” — and nothing else, which is precisely why the result is trustworthy.
A calculation like this one is worth roughly as much as a careful sentence: it forces several vague considerations into one comparable quantity. Once Expansion Revenue is on the table, the argument can stop being about impressions.
Nothing below is stock text pasted around a number: the worked example computes expansion revenue = $1,964,066 from this tool’s own defaults, and the sensitivity section ranks the inputs that move the result — Tier upsells first, at ≈4.3 % of the headline for a ten-percent error either way in that input — which is the thread the rest of this guide pulls on.
Inside the Expansion Revenue calculation: formula and every input
The engine implements a single stated model: Expansion = upsells + cross-sells + usage growth; rate = expansion ÷ starting ARR. There is no hidden coefficient and no login-gated precision — the formula printed is the formula executed, which is also what makes the result citable.
Starting ARR ($) (example value 8,000,000) is a numeric input whose unit is fixed by the label; a wrong unit is a wrong answer wearing a plausible disguise. Replace the example with the figure from your own records — the tool recomputes instantly and the printed steps follow your numbers.
Tier upsells ($) (example value 846,810) is a quantity rather than a category — precision here is cheap and worth having. Replace the example with the figure from your own records — the tool recomputes instantly and the printed steps follow your numbers.
Cross-sells ($) (example value 504,756) is a numeric input whose unit is fixed by the label; a wrong unit is a wrong answer wearing a plausible disguise. This input feeds the formula directly; a defensible figure here is worth more than false precision anywhere else.
Seat/usage growth ($) (example value 612,500) is a plain measured quantity — the unit shown in the label is the unit the formula expects. Replace the example with the figure from your own records — the tool recomputes instantly and the printed steps follow your numbers.
The default Expansion Revenue calculation, written out in full
Abstract formulas are hard to trust, so here is the complete substitution using the default inputs, written the way an examiner would want it. Starting figures: Starting ARR ($), Tier upsells ($), Cross-sells ($), Seat/usage growth ($). The endpoint of that chain is $1,964,066 of expansion revenue, sitting in the “Worth 24.6% of the starting base” band.
- Expansion = $846,810 + $504,756 + $612,500 = $1,964,066
- Rate = $1,964,066 ÷ $8,000,000 = 24.6% of starting ARR
Upsell share of expansion — 43.1 %. This is the number experienced users quote when the headline alone would mislead.
Cross-sell share — 25.7 %. Read next to the headline, this is the figure that shows the shape of the trade-off.
Usage/seat share — 31.2 %. Compare it against the main result of $1,964,066 before drawing conclusions.
Re-running with your own figures is instant; re-running by hand once is the best way to know the tool is telling you the truth.
How far Expansion Revenue can reasonably move
The honest version of any estimate is a corridor, and this one is cheap to produce: Expansion Revenue was recomputed at 5 points along the dominant input, with every other field left untouched.
| Tier upsells setting | Expansion revenue |
|---|---|
| 80 % of the example value | $1,794,704 |
| 90 % of the example value | $1,879,385 |
| example inputs | $1,964,066 |
| 110 % of the example value | $2,048,747 |
| 120 % of the example value | $2,133,428 |
That spread — $1,794,704 at the low end, $2,133,428 at the high — is what a careful read of Expansion Revenue looks like: a band you can state out loud, with the reason for each edge. Reproduce it in the form above by editing Tier upsells alone; the substitution steps will follow your figures exactly.
Sensitivity: which inputs change Expansion Revenue the most
Nobody should have to guess which input matters. The engine was re-run once per field below — ten percent up, ten percent down, everything else frozen — and the results ranked by how far they moved the expansion revenue. Read it as a map of where Expansion Revenue is fragile — drawn for the example inputs, which is the map you want when deciding what to measure carefully.
- Tier upsells: ten percent up gives $2,048,747, ten percent down gives $1,879,385 — ≈4.3 % of the expansion revenue either way
- Seat/usage growth +10 % → Expansion Revenue = $2,025,316 · −10 % → $1,902,816 (the expansion revenue shifts ≈3.1 %)
- Nudge Cross-sells by ±10 % and Expansion Revenue lands between $1,913,590 and $2,014,542 (sensitivity ≈2.6 %)
Tier upsells is the dominant lever here: ten percent either way moves the result by about 4.3 %, from $1,879,385 to $2,048,747. Spend your verification effort there first, and treat Seat/usage growth as the second priority (≈3.1 % per ten percent). Everything below that can stay approximate, which is a licence to stop chasing data that would not change the decision.
Interpreting the Expansion Revenue verdict
A number on its own is trivia; a number against a range is intelligence. The default case lands in the “Worth 24.6% of the starting base” band, and bands are deliberately wide because real situations overlap. Before treating the band as fact, note its width: ten percent either way on Tier upsells already spans $1,879,385 to $2,048,747. The practical reading rules: read the band as a starting hypothesis, then test it: change the two dominant inputs by ten percent and see whether the verdict survives. Verdicts that survive stress are the ones worth acting on.
Set Expansion Revenue beside its neighbours and it usually plays a specific role: this figure establishes the size of something, and the neighbouring tools establish whether that size is acceptable. Skipping the first step makes the second one arbitrary.
Why Expansion Revenue results go wrong — and how to prevent it
Do not count sales-team re-negotiations at list-price increases as expansion in CS-scored cohorts; double-counting inflates the account team’s credit and hides true churn. This calculator gives an estimate based on standard formulas; it is not professional financial, medical, legal or engineering advice. Verify anything you plan to act on with a qualified professional and your own records.
Reporting the headline and quietly discarding Upsell share of expansion. The companions are where the shape of the trade-off survives the rounding.
Attention is also misallocated between fields. Having measured this engine, we can say where it belongs: Tier upsells first, everything else second.
The subtlest error is answering the wrong question precisely. Confirm that expansion revenue is actually the quantity your decision needs — the arithmetic is flawless either way, which is what makes the mistake invisible.
Expansion Revenue verification checklist
- Recompute once with the dominant input deliberately set low, and see whether the decision changes.
- Note the date and the inputs beside the number so the figure can be audited later.
- Check Tier upsells before anything else: it is the measured dominant input, ≈4.3 % of Expansion Revenue per ten percent.
- Confirm the example values are plausible for your own situation before replacing them.
- Re-run the calculation with a ±10 % stress on the two most sensitive inputs.
- Run the ±10 % stress on the top two levers and check that your conclusion survives both.
How to use the Expansion Revenue tool properly
The tool does the arithmetic; the routine below is what makes the arithmetic trustworthy. Five steps, a minute total — and afterwards you will know not just what the number is, but which assumption produced it.
Step 1 — collect, then type. Everything this tool asks for is listed above (starting arr ($), tier upsells ($), cross-sells ($), seat/usage growth ($)). Pull each figure from something you can point at — paperwork, a dashboard, a label — before touching a field. Guesswork at the input stage cannot be repaired at the interpretation stage. Say the answer out loud before you save it; if it sounds wrong, the model did not change, your understanding did.
Step 2 — baseline before exploration. Get one defensible Expansion revenue on screen before you start nudging numbers. Without a baseline, every variation looks interesting and none of them means anything. If the answer changes your behaviour, it deserves a second run with different assumptions.
Step 3 — measure what deserves measuring. The ranked levers above tell you where a careful figure pays off. Everything else can stay approximate, which is a licence to stop hunting for data you do not need. Numbers are cheap to produce and expensive to retract; the extra minute is the cheapest insurance available.
Step 4 — run the scenario trio. Expected, pessimistic, optimistic. The gap between pessimistic and expected is the number to plan against; the optimistic result is useful only as a ceiling. A calculation you cannot explain to somebody else is a calculation you cannot defend.
Step 5 — save the story with the figure. A number without its inputs and its date is unusable within a quarter. Record $1,964,066, the assumptions behind it, and today’s date; your future self will be auditing a stranger’s arithmetic. One decimal place more than your data supports is one decimal place of fiction.
The real-world conversations Expansion Revenue settles
In Sales & Revenue the figure computed here is usually the first one somebody asks to see. Having it — with the formula behind it — changes your position in the conversation from participant to reference. Note the assumption you are least sure about; that is where the real risk lives.
The audience for this page is people who need one trustworthy number before their next decision. In professional Sales & Revenue practice the pattern is always the same — screen with Expansion Revenue, then invest slow analysis only in whatever survives the screen. Estimates improve most when the worst case is written down in ink.
Treat Expansion Revenue like a smoke alarm rather than a painting — its value is in being tested periodically, not in being admired once. A figure with a date beside it becomes evidence; without one it stays an anecdote.
People also ask about Expansion Revenue
What affects Expansion Revenue the most?
Measured on this engine, Tier upsells is the dominant lever: moving it ±10 % shifts the expansion revenue across $1,879,385 to $2,048,747 — about 4.3 % of the headline, with Seat/usage growth next at ≈3.1 %. The ranked list in the sensitivity section is computed live, not asserted from a template.
Which matters more: seat/usage growth or tier upsells?
Tier upsells, by a factor of about 1.4. Concretely: ten percent on Tier upsells is worth ≈4.3 % of Expansion Revenue, the same nudge on Seat/usage growth only ≈3.1 %. That ranking is re-computed for each page from that page’s own defaults.
What is a typical Expansion Revenue?
There is no honest universal average for Expansion Revenue, but there is a reference point: the defaults on this page produce $1,964,066 (Worth 24.6% of the starting base). Replace the inputs with your own and compare — that comparison is the useful meaning of “typical”.
How do I calculate Expansion Revenue by hand?
Use the stated model — Expansion = upsells + cross-sells + usage growth; rate = expansion ÷ starting ARR — and substitute in the order the tool prints (it starts from Expansion = $846,810 + $504,756 + $612,500 = $1,964,066). On the example inputs the hand route lands on $1,964,066, exactly what the calculator shows. A spreadsheet reproduces it in two or three cells; doing it once by hand is what makes the automated answer trustworthy.
What happens to Expansion Revenue if tier upsells changes by 10 %?
The engine was re-run with that field moved by ten percent while everything else stayed fixed: the expansion revenue goes across $1,879,385 to $2,048,747, a swing of roughly 4.3 % around the $1,964,066 baseline. That ratio is the practical definition of how much this input matters.
Is the Expansion Revenue result of $1,964,066 good or bad?
Good and bad are comparisons, so the honest test is three questions: where does your own Expansion Revenue sit against the $1,964,066 reference above, how far would a plausible input error move it (≈4.3 % per ten percent on Tier upsells), and what does the alternative option compute to?
Is Expansion Revenue accurate?
The arithmetic is exact: Expansion = upsells + cross-sells + usage growth; rate = expansion ÷ starting ARR is evaluated with full floating-point precision and every substitution is printed in the worked example. What limits accuracy is input quality and the model’s assumptions, so treat the $1,964,066 result as the correct answer to the question you typed — and check the assumptions section before acting on it.
How do I calculate Expansion Revenue manually?
Write down the inputs, then follow the printed steps in order — Expansion = upsells + cross-sells + usage growth; rate = expansion ÷ starting ARR. A spreadsheet replicates it with two or three cells. The manual route is worth doing once to build intuition; after that the calculator saves time and eliminates transcription slips.
Expansion or new logos — where is marginal budget best spent?
Compare marginal CAC: expansion usually converts 3–5× cheaper, which is why NRR-led companies scale profit better — until the base saturates and expansion plateaus.
Is price-increase revenue expansion?
Yes if customers stayed and pay more for the same thing — but track it separately, because pricing-led expansion stops compounding once the price book catches up.
Is my data private on this page?
Yes — computation happens locally in your browser, with no account, no tracking of your inputs and nothing sent to a server. The printed formula is the whole story of what happens to your figures.
Glossary for Expansion Revenue
- Upsell share of expansion
- 43.1 % on the example inputs — a companion figure printed beside the headline of Expansion Revenue so that no result is read in isolation.
- Cross-sell share
- 25.7 % in the default Expansion Revenue calculation — one of the secondary figures an experienced reader checks before trusting the primary number.
- Usage/seat share
- 31.2 % on the example inputs — a companion figure printed beside the headline of Expansion Revenue so that no result is read in isolation.
- Expansion revenue
- The primary output of this tool: $1,964,066 for the default inputs, computed exactly from Expansion = upsells + cross-sells + usage growth; rate = expansion ÷ starting ARR.
- Worked example
- Every substitution in order, from the example inputs to $1,964,066 — the audit trail for the headline figure.
- Verdict band
- A named zone on the range of plausible results; the example inputs land in “Worth 24.6% of the starting base”, and your inputs may not.
- Sensitivity (±10 %)
- How far the Expansion Revenue moves when a single input is nudged ten percent either way; the ranked list on this page is computed live from this engine.
Methodology, sources and limits
The model is published arithmetic implemented exactly as written: Expansion = upsells + cross-sells + usage growth; rate = expansion ÷ starting ARR. Source of record: SaaS cohort-metric convention (OpenView definitions). Specialist software layers extra coefficients on top of the same algebra; none are hidden here, and that transparency is what makes a disagreement traceable to a specific input instead of a black box.
Treat the output as a precise answer to the question you typed: exact arithmetic, transparent formula, published source, no hidden rounding. Nothing is smoothed, weighted or adjusted behind the scenes; where judgement enters, this page says so and names the input responsible.
After the number: what to do with it
Save the number together with its inputs and today’s date; an Expansion Revenue figure without context is unusable the moment an input changes.
Whoever you are (people who need one trustworthy number before their next decision), the next step is the same: replace the example inputs with your own, note the date, and re-run whenever a figure moves. In Business & Entrepreneurship, a dated figure is a trend, and an undated one is a rumour.