Expansion Revenue Calculator
Expansion MRR (also called Expansion Revenue) tracks additional revenue generated from existing customers through upsells, cross-sells, add-ons, and usage increases. Expansion revenue is typically higher margin than new customer revenue since there is no acquisition cost.
How to Calculate
``
Expansion MRR = Sum of all revenue increases from existing customers
Sources of Expansion:
Plan upgrades- Seat/user additions
- Feature add-ons
- Usage overages
- Cross-sell products
Industry Benchmarks
| Expansion Rate | Health | Notes |
|---|---|---|
| <5% monthly | Low | Limited upsell opportunity |
| 5-10% monthly | Good | Healthy expansion motion |
| 10-15% monthly | Strong | Effective land-and-expand |
| >15% monthly | Excellent | Usage-based or viral growth |
Interpreting Your Results
Strong expansion MRR is the key to achieving NRR above 100%. Build products with natural expansion triggers: more users, more usage, more features. Enterprise customers typically have the highest expansion potential.
Why This Metric Matters
Understanding Expansion Revenue helps you:
- Make data-driven business decisions with confidence
- Benchmark against industry standards and competitors
- Identify areas for improvement in your business model
- Communicate performance clearly to stakeholders and investors
- Set realistic goals and track progress over time
Best Practices for Accurate Measurement
1. Use consistent time periods: Compare month-over-month or quarter-over-quarter consistently 2. Include all relevant data: Ensure you capture all revenue sources and costs 3. Track cohorts separately: Analyze metrics by customer segment and acquisition date 4. Monitor trends: Single snapshots are less valuable than trends over time 5. Automate tracking: Use analytics tools to ensure consistent, accurate measurement
Every Metric From These Inputs
100 customers at $49 with 3% monthly churn and $200 CAC:
| Metric | Value | Formula |
|---|---|---|
| MRR | $4,900 | customers × ARPU |
| ARR | $58,800 | MRR × 12 |
| Annual churn | 30.6% | 1 − (1 − monthly)¹² |
| Average lifetime | 33.3 months | 1 ÷ monthly churn |
| LTV | $1,633 | ARPU ÷ monthly churn |
| LTV : CAC | 8.2:1 | LTV ÷ CAC |
| CAC payback | 4.1 months | CAC ÷ ARPU |
What Good Looks Like
| Metric | Healthy | Concerning |
|---|---|---|
| Monthly churn (SMB) | Under 3% | Above 5% |
| Monthly churn (enterprise) | Under 1% | Above 2% |
| LTV : CAC | 3:1 or better | Below 1:1 |
| CAC payback | Under 12 months | Above 18 |
| Net revenue retention | Above 100% | Below 90% |
The Metric This Set Omits
Net revenue retention — expansion revenue minus churn and contraction, from existing customers only. Above 100% means the business grows without acquiring anyone, which is the single strongest signal in SaaS and the one that most affects valuation. It cannot be derived from the inputs above because it needs upgrade and downgrade data.