Expansion Rate Calculator
Expansion Rate: Expansion rate = expansion recurring revenue ÷ starting recurring revenue × 100. Methodology stated, your own inputs only.
In short
Expansion Rate: Expansion rate = expansion recurring revenue ÷ starting recurring revenue × 100. Methodology stated, your own inputs only.
Formula: Expansion rate = expansion recurring revenue ÷ starting recurring revenue × 100.
What this calculator does
Expansion Rate: Expansion rate = expansion recurring revenue ÷ starting recurring revenue × 100. Methodology stated, your own inputs only. Worked example, questions and limitations included.
Use it to turn Currency (symbol only, never converted), Recurring revenue at start of period (existing customers), Expansion revenue from those customers into a checked result you can compare, copy, or rerun with different assumptions.
The page shows the formula, a numeric worked example, and the assumptions that affect this customer economics calculation.
Inputs and what they mean
- Currency (symbol only, never converted)
- — choice value.
- Recurring revenue at start of period (existing customers)
- — number value.
- Expansion revenue from those customers
- — number value.
How to use it
- Enter each value in the unit shown next to the box (use the unit converter first if your numbers are in other units).
- Check the breakdown to see every intermediate step.
- Read the limitations before relying on the result.
Formula
Methodology: gross expansion from the starting cohort — upsells, cross-sells, seat growth and price increases; contraction is not netted (see NRR).
New-customer revenue is excluded.
Common SaaS practice.
Expansion rate = expansion recurring revenue ÷ starting recurring revenue × 100.
Inputs used: Currency (symbol only, never converted), Recurring revenue at start of period (existing customers), Expansion revenue from those customers.
Worked example
A year
- 180,000 ÷ 1,000,000 = 18%.
Reading the result
The headline figure is the main answer. Any breakdown underneath shows the parts that make it up, so you can check the working and see what changes when you adjust an input.
Limitations and assumptions
- Gross expansion only.
- Cohort of starting customers.
- Results are educational estimates built only from the figures you enter. They are not personalised investment, tax, legal or accounting advice. Rates, growth and discount assumptions are always yours to choose.
- The result depends on the values you enter for this expansion rate calculator; it does not supply missing rates, rules, prices, dates, or assumptions for you.
Reference: OpenStax
Last reviewed:
Common questions
Net or gross?
Gross. For net of downgrades and churn, use the NRR calculator.
Do price increases count?
Usually yes; say so if you report it. Check the formula, example, and limitations on this page before using the result for a real customer economics decision.
What is a good value?
We don't assume an industry-standard figure. Compare against your own history and plan, not a rule of thumb.
How do I use the Expansion Rate Calculator?
Enter the required values for Currency (symbol only, never converted), Recurring revenue at start of period (existing customers), Expansion revenue from those customers. The calculator applies the formula on this page and shows the main result with any supporting breakdown so you can check the arithmetic.
What formula does the Expansion Rate Calculator use?
Expansion rate = expansion recurring revenue ÷ starting recurring revenue × 100. The visible formula section above lists the calculation path and the edge cases the page handles, so the result can be checked without relying on the form alone.
Can the Expansion Rate Calculator be used for exact decisions?
Use it as a calculation aid, not as a substitute for checking the underlying rule, contract, policy, or professional advice that applies to your situation. When a result depends on local rules, personal details, prices, or dates, enter those values yourself and confirm them before acting.
Sources
Method based on OpenStax.
Cite this page
Free Calculator. (2026, October 15). Expansion Rate Calculator. https://freecalculator.tech/tools/expansion-rate-calculator
"Expansion Rate Calculator." Free Calculator, 15 Oct. 2026, https://freecalculator.tech/tools/expansion-rate-calculator.
Expansion Rate Calculator — Free Calculator, https://freecalculator.tech/tools/expansion-rate-calculator
Related tools
CAC: CAC = acquisition spend ÷ new customers acquired, for the same period. Methodology stated, your own inputs only.
LTV: LTV = ARPU × gross margin ÷ churn rate (margin-adjusted). Methodology stated, your own inputs only.
LTV:CAC Ratio: LTV:CAC = LTV ÷ CAC. Methodology stated, your own inputs only.
CAC Payback: Payback months = CAC ÷ (monthly revenue per customer × gross margin). Methodology stated, your own inputs only.
Gross Revenue Retention: GRR = (starting recurring revenue − contraction − churn) ÷ starting recurring revenue × 100. Methodology stated, your own inputs only.
Net Revenue Retention: NRR = (starting recurring revenue + expansion − contraction − churn) ÷ starting recurring revenue × 100. Methodology stated, your own inputs only.