Subscription Business MRR Calculator
Model Monthly Recurring Revenue (MRR) for your subscription business by combining plan‑level recurring revenue with churn, new subscriptions, expansion, and contraction. This tool helps you see how your subscription engine is really moving—beyond a single headline number.
Subscription MRR formulas
Monthly Recurring Revenue (MRR) is the heartbeat of a subscription business. It tells you how much predictable revenue you generate each month from active subscriptions. The formulas in this tool break MRR into components—starting, new, churned, expansion, contraction, and ending—so you can see how your subscription engine is evolving.
1. Plan‑level recurring revenue
Plan MRR =
Plan monthly price × Active subscribers
Example:
Plan price = 19
Active subscribers = 500
Plan MRR = 19 × 500 = 9,500
Plan‑level MRR is the foundation of your subscription revenue. Summing plan MRR across all plans gives you a view of how much recurring revenue your current subscriber base generates before considering changes during the period.
2. Starting MRR
Starting MRR =
Sum of plan MRR at the beginning of the period
If you enter a separate starting MRR value, the tool will show both
but treat the calculated plan MRR as the structural baseline.
Starting MRR represents the recurring revenue you begin the month with. It can come from your billing system or be calculated from plan counts. Using both perspectives helps you reconcile your numbers and spot discrepancies.
3. New and churned MRR
New MRR =
New subscribers × Average plan price (simplified)
Churned MRR =
Churned subscribers × Average plan price (simplified)
Net new MRR from subscriber count changes =
New MRR − Churned MRR
In a more detailed model, you would track new and churned subscribers per plan. This calculator uses a simplified approach: it estimates new and churned MRR using an average plan price derived from your plan mix. The goal is to keep the inputs manageable while still capturing the dynamics of growth and churn.
4. Expansion and contraction MRR
Expansion MRR =
Additional recurring revenue from upgrades, add‑ons, or seat increases
Contraction MRR =
Recurring revenue lost from downgrades, seat reductions, or discounts
Expansion and contraction MRR capture changes in revenue from existing customers who stay subscribed but change their level of service. These components are important because they can drive growth even when subscriber counts are stable.
5. Net new and ending MRR
Net new MRR =
New MRR
− Churned MRR
+ Expansion MRR
− Contraction MRR
Ending MRR =
Starting MRR + Net new MRR
Net new MRR summarizes how your subscription business changed during the period. A positive net new MRR means you grew; a negative value means you shrank. Ending MRR shows where you landed after those changes. Tracking these numbers over time helps you see whether your growth is driven by new customers, expansion, or reduced churn.
6. Implied growth rate
Implied MRR growth rate (%) =
(Net new MRR ÷ Starting MRR) × 100
This growth rate gives you a quick sense of momentum. A high positive rate suggests strong growth; a negative rate signals contraction. Because it’s based on MRR, it focuses on recurring revenue rather than one‑time transactions.
These formulas are intentionally transparent. You can export the CSV and refine the model in a spreadsheet—for example, by splitting new and churned MRR by plan or adding more detailed expansion categories. The calculator is a starting point for understanding your subscription dynamics, not a rigid reporting system.
Understanding MRR in a subscription business
Subscription businesses live and die by recurring revenue. One‑time sales can be helpful, but the real story is how much predictable revenue you generate each month and how that number changes over time. Monthly Recurring Revenue (MRR) is the metric that captures that story, and this calculator is designed to make its components visible.
When you enter plan prices and active subscribers, the tool calculates plan‑level MRR and a starting MRR baseline. Then, by modeling new subscribers, churned subscribers, expansion, and contraction, it shows how your subscription engine moved during the period. Instead of a single MRR number, you get a breakdown of what drove growth or decline.
Seeing beyond headline MRR
Headline MRR can look healthy even when underlying dynamics are fragile. For example, you might be adding new subscribers quickly but losing a large share to churn, or relying heavily on expansion from a small group of customers. By separating new, churned, expansion, and contraction MRR, the calculator helps you see whether your growth is broad‑based or concentrated.
Imagine you start the month with 25,000 in MRR. You add 80 new subscribers and lose 40, with an average plan price of 35. New MRR is 2,800, churned MRR is 1,400, and net new from subscriber changes is 1,400. If you also generate 1,500 in expansion and lose 600 in contraction, net new MRR becomes 2,300, and ending MRR is 27,300. The breakdown shows that both new customers and expansion contributed meaningfully to growth.
Tracking churn and expansion
Churn and expansion are two sides of the same coin. High churn can erode growth even when new sign‑ups are strong, while healthy expansion can offset moderate churn. The calculator’s separate fields for churned subscribers and expansion/contraction MRR encourage you to track these forces explicitly.
Over time, you might notice patterns: churn spikes after certain campaigns, expansion rises when you launch a new add‑on, or contraction increases when you run aggressive discounting. These insights can guide product decisions, pricing strategies, and customer success efforts.
Using MRR to inform strategy
MRR is not just a reporting metric; it’s a strategic lens. If net new MRR is consistently positive but growth is slowing, you might focus on improving onboarding or reducing churn. If growth is strong but concentrated in a single plan, you might diversify your offerings or adjust pricing to balance your portfolio.
Because the calculator shows implied growth rate, you can quickly see whether your current trajectory aligns with your goals. A 5% monthly MRR growth rate might be acceptable for a mature business but too low for an early‑stage startup. The key is to interpret the numbers in the context of your stage, market, and ambitions.
Practical example
Suppose you run a SaaS product with three plans: Basic at 19, Pro at 49, and Enterprise at 199. You have 500 Basic subscribers, 200 Pro, and 25 Enterprise. The calculator shows plan‑level MRR and a starting baseline. During the month, you add 60 new subscribers and lose 30, with an average price of 32. You also generate 1,200 in expansion and lose 400 in contraction.
Net new MRR is (60 × 32) − (30 × 32) + 1,200 − 400 = 1,920. If starting MRR is 24,000, ending MRR is 25,920, and implied growth rate is 8%. You can then ask: is that growth driven mostly by new customers, or by expansion? Are you comfortable with the churn level? Do you want to invest more in upsell campaigns or retention programs?
Tips for using the MRR calculator effectively
- Use plan counts and prices from your billing system to keep inputs accurate.
- Run the calculator monthly and track net new MRR and growth rate over time.
- Experiment with different churn and expansion scenarios to see how they affect ending MRR.
- Use the notes field to capture context, such as campaigns, product launches, or pricing changes.
- Export the CSV and attach it to investor updates, board decks, or internal performance reviews.
Ultimately, the subscription business MRR calculator is about clarity. It helps you see how recurring revenue moves, where growth comes from, and where risk might be hiding. Combined with deeper analytics and customer insights, it can be a powerful tool for steering your subscription business toward sustainable, predictable growth.
Frequently Asked Questions
Can I use different prices for new and churned subscribers?
This calculator uses an average plan price to estimate new and churned MRR. For more precision, you can export the CSV and build a plan‑level model in a spreadsheet, or integrate directly with your billing system.
How should I handle annual plans?
For annual plans, convert the annual price to a monthly equivalent by dividing by 12 and use that value as the plan’s monthly price. This keeps MRR focused on monthly recurring revenue while still reflecting annual commitments.
Does the calculator account for trial users?
Trials are not included directly in MRR because they are not paying subscribers. You can track trial counts separately and use the notes field to record trial‑to‑paid conversion assumptions.
Can I use this tool for non‑SaaS subscriptions?
Yes. Any business with recurring monthly revenue—such as memberships, media subscriptions, or services—can use the calculator. Just treat each plan as a tier of your offering and enter the relevant prices and counts.
How often should I calculate MRR?
Most subscription businesses track MRR monthly, but fast‑growing or high‑volatility businesses may benefit from weekly snapshots. The key is to be consistent so you can compare periods and spot trends.
Does this tool handle revenue recognition rules?
No. The calculator focuses on cash‑based recurring revenue, not formal revenue recognition under accounting standards. For compliance and financial reporting, work with your accounting team and specialized tools.
Related tools
Information on this site is for educational purposes only and is not financial, tax, or legal advice. Calculations are estimates and may not reflect actual results. See our Privacy Policy and Disclaimer.