SaaS Expansion MRR & Tier Upgrade Calculator
Simulate revenue expansion from existing customers upgrading plans, adding seats, or purchasing add-on modules.
Parameters & Config
Active MRR at the start of the billing month
Monthly revenue from newly acquired signups
Additional revenue from existing customer tier upgrades and add-ons
Lost revenue from cancellations and downgrades during the month
Total MRR achieved at period end after additions and churn
Ending MRR projected over 12 months
Key Metrics & Sub-Totals
3 itemsCalculation Summary & Unit Breakdown
| Metric | Calculated Value | Notes / Logic |
|---|---|---|
| Beginning Monthly Recurring Revenue | $60000.00 | - |
| New Sign-up MRR Added | $6000.00 | New customer bookings |
| Expansion & Upsell MRR | $5000.00 | Tier upgrades |
| Churned & Lost MRR | $1500.00 | Cancellations + contractions |
| Net New Added MRR | $9500.00 | Net expansion |
| Ending Monthly Recurring Revenue | $69500.00 | Current month close |
| Annualized Run Rate (ARR) | $834000.00 | Ending MRR × 12 |
| Net Monthly Growth Rate | 15.83% | Month-over-month |
| SaaS Quick Ratio | 7.33x | Growth vs Churn efficiency |
Overview & Methodology
Acquiring an existing customer to upgrade or purchase additional seats is 4x to 5x cheaper than acquiring a new customer from scratch. Modeling Expansion MRR demonstrates the power of value-metric pricing.
Mathematical Formulation
Ending MRR = Starting MRR + New Bookings + Expansion Upgrades - Churn. Net Growth % = (Net Additions / Starting MRR) × 100.Optimization Best Practices
Create natural upgrade friction: gate advanced features like SSO, audit logs, and priority SLAs behind enterprise tiers.
Send automated notification emails when accounts reach 80% of their plan’s quota capacity.
Incentivize customer success representatives on net expansion quota targets.
Frequently Asked Questions
Q.How much cheaper is Expansion MRR than New Customer MRR?
Research by ProfitWell shows generating expansion revenue costs approximately $0.27 per dollar of CAC, compared to $1.13 for new customer acquisition.
Q.What are the most common expansion triggers in SaaS?
Additional user seats, API volume tiers, data storage limits, and advanced security/compliance add-ons (SSO, SOC2).
Q.What percentage of total new MRR should come from expansion?
Best-in-class SaaS companies generate 30% to 50% of their total monthly added MRR from existing customer expansion.