How To Analyse Recurring Revenue: The Complete Guide to ARR and MRR

Recurring revenue is not just a metric. It is the foundation of business valuation, investor confidence and strategic planning. While many businesses track Annual Recurring Revenue (ARR) and Monthly Recurring Revenue (MRR), few truly analyse them to extract actionable insights. Most finance teams stop at the top-line number.

To drive growth, you must look deeper than the summary on a spreadsheet. You need to understand how trends shift, what drives retention and where revenue leaks occur. By the end of this guide, you will understand how to calculate these metrics and analyse trends to identify growth drivers. We will also explore how AI can automate this entire process for you.

What Is Recurring Revenue? (Definition and Importance)

Recurring revenue is the portion of a company’s revenue that is predictable, stable and likely to continue in the future. It stands in stark contrast to one-time sales. In traditional models, every month starts at zero and the sales team must rebuild revenue from scratch. In a subscription model, you start the month with a baseline of revenue already secured.

This stability is why investors value recurring revenue businesses at higher multiples. Predictability allows SaaS companies to forecast growth with confidence. It enables long-term strategic planning regarding hiring, product development and expansion. Recurring revenue is the engine of the subscription economy, powering businesses from streaming services to enterprise software.

ARR vs MRR: Understanding the Key Metrics

To manage a subscription business effectively, you must master two primary acronyms. These are Annual Recurring Revenue (ARR) and Monthly Recurring Revenue (MRR).

What Is ARR (Annual Recurring Revenue)?

ARR is the annualized value of all active subscriptions. It is calculated by taking the total value of recurring contracts and normalizing them to a one-year period. This is the preferred metric for businesses with annual contracts or high-value enterprise customers. It provides a macro view of the business size and health.

What Is MRR (Monthly Recurring Revenue)?

MRR is the total predictable revenue generated from subscriptions each month. It is the sum of all recurring revenue normalized to a monthly amount. MRR is ideal for businesses with monthly billing cycles or those needing granular month-over-month tracking. It offers a closer look at short-term operational performance.

When to Use ARR vs MRR

The choice between these metrics depends on your business model and audience. Use ARR for strategic planning, investor reporting and analysing annual contracts. Use MRR for operational tracking, short-term growth analysis and monthly billing models. In a simplified view, ARR is essentially MRR multiplied by 12.

How To Calculate ARR and MRR (Formulas and Examples)

Accurate analysis begins with accurate calculation. You must ensure your formulas are consistent to avoid data discrepancies.

The Basic ARR Formula

The simplest way to calculate ARR is to sum the annual value of all active subscriptions.

Formula: ARR = Total Annual Contract Value of All Active Subscriptions.

Example: If you have 100 customers paying €1,000 per year, your ARR is €100,000.

The Comprehensive ARR Formula

For a more detailed view, you should account for revenue movements.

Formula: ARR = (Total Subscription Revenue) + (Expansion Revenue) – (Churned Revenue).

This considers new subscriptions, upsells or cross-sells and lost customers.

The MRR Formula

This calculation focuses on the monthly intake.

Formula: MRR = Sum of All Monthly Recurring Charges.

Example: If you have 50 customers paying €100 per month, your MRR is €5,000.

What NOT to Include

It is critical to exclude non-recurring items to maintain data integrity. One-time fees such as setup costs, consulting or professional services must not be part of ARR or MRR. Usage-based charges that fluctuate wildly should also be excluded unless they have a predictable minimum. Only predictable, recurring revenue counts.

Types of MRR: Breaking Down the Components

Top-line MRR tells you how much you are making, but not how you got there. To understand growth, you must break MRR down into its component parts.

  • New MRR. This is revenue from new customers acquired in the period.
  • Expansion MRR. This tracks additional revenue from existing customers through upgrades and add-ons.
  • Contraction MRR. This represents lost revenue from customers who downgrade their plans.
  • Churned MRR. This is revenue lost from cancelled subscriptions.
  • Net New MRR. Calculated as (New MRR + Expansion MRR) – (Contraction MRR + Churned MRR).

Net New MRR is your key growth metric. It tells you if your customer base is growing in value after accounting for losses.

How To Analyse Recurring Revenue: Key Techniques

Calculating the numbers is only the first step. The real value comes from analysing the data to make better decisions.

Trend Analysis

You should track ARR and MRR month-over-month and year-over-year. Look for growth patterns, seasonality and inflection points. A healthy SaaS business should show consistent MRR growth. Mature companies typically aim for 10-20% annual growth, while early-stage startups often see much higher rates.

Cohort Analysis

Segment your customers by their acquisition date and track their revenue contribution over time. This analysis reveals customer lifetime value and retention patterns. You might find that customers acquired during a specific marketing campaign retain better than others. This helps you allocate marketing budget more effectively.

Churn Analysis

Calculate your churn rate by dividing Churned MRR by Beginning MRR. You must identify why customers leave and which segments have the highest churn. A churn rate above 5-7% annually is often a red flag for SaaS businesses. High churn negates the hard work of your sales team.

Expansion Revenue Analysis

Measure your Net Revenue Retention (NRR). The formula is (Beginning MRR + Expansion MRR – Churned MRR) / Beginning MRR. If your NRR is above 100%, you are growing revenue from existing customers faster than you are losing it. This is a strong sign of product-market fit.

Customer Segmentation

Break down your recurring revenue by customer size, industry, plan type or geography. Aggregate numbers often hide important trends. You might discover that while overall growth is flat, your enterprise segment is growing rapidly while small businesses are churning. This insight allows you to focus your efforts where they matter most.

Key Metrics to Track Alongside ARR/MRR

Recurring revenue does not exist in a vacuum. You need complementary metrics to provide context to your financial health.

Customer Acquisition Cost (CAC)

This is the cost to acquire a single new customer. It is calculated by dividing your Total Sales & Marketing Spend by the Number of New Customers. If your CAC is too high, your growth may be unsustainable.

Customer Lifetime Value (LTV)

LTV estimates the total revenue you expect from a customer over their lifetime. The formula is ARPU (Average Revenue Per User) divided by your Churn Rate. A higher LTV means your customers stay longer and spend more.

LTV:CAC Ratio

This is the gold standard metric for efficiency. A healthy ratio is 3:1 or higher. This means you earn €3 in lifetime value for every €1 you spend on acquisition. If the ratio is lower, you are spending too much to grow.

Months to Recover CAC

This measures how long it takes to recoup the cost of acquiring a customer. Faster is always better. Ideally, you should recover your acquisition costs in under 12 months to maintain healthy cash flow.

Common Mistakes When Analysing Recurring Revenue

Even experienced finance teams can fall into traps that distort their analysis. Avoiding these mistakes is crucial for accurate reporting.

Including One-Time Revenue

Setup fees, professional services and usage spikes can inflate your ARR artificially. If you include these, you create a false sense of security. When that revenue does not repeat next month, your growth metrics will look volatile.

Ignoring Churn

Focusing only on new revenue while ignoring customer losses creates a “leaky bucket” scenario. You might be adding sales, but if customers are leaving just as fast, your business is stalling. Always weigh new growth against churn.

Not Normalizing Multi-Year Contracts

A 3-year contract worth €30,000 should not be recorded as €30,000 in ARR. It must be normalized to €10,000 ARR. Recording the full value upfront distorts your annual performance and valuation.

Forgetting to Segment

Looking at a single global number hides the truth. You must analyse by cohort, plan and segment to see what is really happening. General averages can mask specific problems in a product line or region.

The Future: AI-Powered Recurring Revenue Analysis

Manual spreadsheets are becoming obsolete. The future of revenue analysis lies in automation and artificial intelligence.

Automating Data Collection

Modern AI tools connect directly to billing systems like Stripe or Chargebee and CRMs like Salesforce. They pull real-time data automatically. This eliminates the risk of human error in manual data entry.

Real-Time Dashboards

AI-powered tools generate live ARR and MRR dashboards that update continuously. You no longer have to wait for the end-of-month report to know where you stand. Insights are available instantly.

Predictive Analytics

AI can forecast future ARR and MRR based on historical trends, seasonality and pipeline data. It can tell you, for example, that your ARR is on track to hit €1M in Q3 based on current trajectories. This allows for proactive rather than reactive management.

Anomaly Detection

AI identifies unusual patterns that a human might miss. It can alert you to sudden churn spikes, unexpected expansion revenue or stalled growth. Proactive alerts allow you to address issues before they become crises.

Moterra: Your AI-Powered Revenue Analyst

Moterra is the solution that embodies these best practices. It acts as your dedicated AI Data Analyst, transforming how you handle financial data.

Automated Revenue Tracking

Moterra connects seamlessly to your billing and CRM systems. It calculates ARR, MRR and all related metrics automatically. You can stop building revenue reports in spreadsheets and trust the data is accurate.

Intelligent Insights

The AI Data Analyst does not just show you numbers. It explains them. It might tell you that your Net Revenue Retention dropped to 95% this month due to increased churn in the Enterprise segment. This context is invaluable for quick decision-making.

Scenario Planning

You can ask “What if?” questions instantly. For instance, “What happens to ARR if we reduce churn by 2%?” Moterra provides immediate answers to complex strategic questions.

Security & Trust

Automation does not mean compromising on data security. Moterra ensures your financial data is handled with the highest standards of privacy and protection.

Stop wasting time on manual reporting. Let the AI Data Analyst do it for you in seconds. Book a demo today to see the future of revenue analysis.

FAQ

  • What is the difference between ARR and total revenue?
    ARR excludes one-time fees and non-recurring revenue. Total revenue includes everything earned in a period.
  • How do I calculate ARR for monthly contracts?
    You multiply MRR by 12, but only if those contracts are expected to renew continuously.
  • What is a good ARR growth rate?
    Aim for 20-30% for early-stage SaaS, 10-20% for mature companies and 40% or more for hyper-growth startups.
  • Should I include discounts in ARR?
    Yes, you should use the actual recurring revenue after discounts are applied to reflect true income.
  • What tools are best for tracking ARR and MRR?
    Billing platforms like Stripe are good for raw data, but AI-powered solutions like Moterra offer superior analytics and forecasting.

Latest writings