Wall Street Prep

Committed Monthly Recurring Revenue (CMRR)

Guide to Understanding Committed Monthly Recurring Revenue (CMRR)

Learn Online Now

Committed Monthly Recurring Revenue (CMRR)

How to Calculate CMRR

The committed monthly recurring revenue metric is a derivation of the monthly recurring revenue (MRR) metric and the two metrics are closely tied to each other.

CMRR provides an insightful, forward-looking view into the future state of a SaaS subscription-oriented company where revenue is contractual.

The MRR serves as the base of the calculation, as one would reasonably expect given the relationship between the measures. But one problem with the MRR metric is that new booking and churn – i.e. the revenue lost from customer cancellations – are not considered.

CMRR fixes that issue by accounting for the impact of new customer bookings, expansion revenue, and customer (and MRR) churn.

CMRR Formula

The formula for calculating the CMRR starts with the existing MRR at the beginning of the month.

From the beginning MRR, adjustments are made pertaining to the new MRR from new bookings, expansion MRR, and churned MRR.

Ending CMRR = Beginning CMRR + New Bookings CMRR + Expansion CMRR – Churned CMRR

The details surrounding each formula input are provided below.

  • Beginning CMRR → The CMRR of a company at the start of the opening period.
  • New Bookings CMRR → The new CMRR from recent conversions of leads into paid customers on a contractual basis.
  • Expansion CMRR → The new CMRR a company can expect with near certainty from upselling or cross-selling to existing customers.
  • Churned CMRR → The anticipated CMRR lost from customer churn (i.e. non-renewal or cancellations) in the month, as well as the lost MRR from downgrades by existing accounts.

The point that each adjustment must be near guaranteed is a critical aspect of the metric’s credibility.

  • New Bookings → For instance, the MRR from new bookings should be comprised of closed deals with customers, rather than “pending” deals with potential customers in a company’s pipeline.
  • Expansion MRR → If we apply the same rule to expansion MRR, that means expansion MRR must consist of upselling or cross-selling where there is a strong basis for assuming the new MRR.
  • Churned MRR → As for the churned MRR, existing customers – especially on the B2B side – will provide notice of their decision to discontinue their relationship (or desire to downgrade to a lower-priced account tier) with the company’s products/services ahead of time.

Note: The fees received for services such as one-time installations or consultations are excluded.

CMRR vs. MRR

In comparison to monthly recurring revenue (MRR), the committed monthly recurring revenue metric is perceived as the more informative metric because of the inclusion of all factors that affect MRR.

The MRR neglects churn, upgrades, and downgrades, which is the reason MRR is not practical for forecasting purposes.

CMRR is a forward-looking measure useful for setting future goals and tracking progress, whereas MRR is more of a trailing measure of past performance.

In particular, one of the key determinants of the long-term viability of a SaaS company (and thus valuation) is upholding the renewal rate and managing customer churn.

CMRR Calculator – Excel Model Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

Submitting ...

Committed Monthly Recurring Revenue Calculation Example

Suppose a SaaS startup’s business model is oriented around selling two-year long contracts priced at a total contract value (TCV) of $1.2 million.

Given the TCV, the implied annual contract value (ACV) is $50k.

If we divide the ACV by the duration of the customer contract expressed on a monthly basis, the average CMRR per customer is $4k.

  • Total Contract Value (TCV) = $1.2 million
  • Contract Term = 24 Months
  • Annual Contract Value (ACV) = $1.2 million ÷ 24 Months = $50k
  • Average CMRR Per Customer = $50k ÷ 12 Months = $4k

At the start of the next month, July 2022, the total number of customers is 48.

Per company records and customer reports from the sales and marketing team, the projected number of new bookings is 4 while the number of non-renewals is only 1.

By the end of July, the total number of customers is 51, a net increase of 3 customers.

  • Beginning Customers = 48
  • New Bookings = 4
  • Non-Renewals = –1
  • Ending Customers = 48 + 4 – 1 = 51

From the customer roll-forward for the month of July, we can see the number of customers that decided to renew was 47.

  • Renewals = 48 – 1 = 47

We now have the necessary inputs to build the schedule, starting with the beginning CMRR of $200k, which we calculated by multiplying the average CMRR per customer by the beginning customer count.

Of course, in reality, this calculation would be far more complex because each customer contract varies in price and is customized to meet the specific needs of the customers (and factors such as discounts by team size can further complicate these matters) – but this simplification is acceptable for illustrative purposes.

The next line item is that the new CMRR is equal to the number of new bookings multiplied by the average CMRR per customer, which comes out to roughly $17k.

As for the expansion CMRR, we need to make an assumption regarding the upsell rate, which we’ll set at 4%. Using the 4% upsell rate, we’ll multiply that rate by the number of renewals and 47 customers, resulting in an expansion CMRR of $8k.

  • Upsell Rate = 4%

The churned CMRR requires no assumption, as it is a function of our non-renewal assumption from earlier (i.e. one lost customer) and the average CMRR.

Since only one customer churned, the churned CMRR equals $4k (and the churn rate is thus 2.1%)

The following values are the inputs used to calculate our hypothetical company’s ending CMRR.

  • Beginning CMRR = $200k
  • New CMRR = $17k
  • Expansion CMRR = $8k
  • Churned CMRR = –$4 million

In the final step of our modeling exercise, we’ll adjust the beginning CMRR for each input and arrive at an ending CMRR of $220k – which reflects a month-over-month increase of $20k for the month of July.

  • Ending CMRR = $200k + $17k + $8k – $4k = $220k

CMRR Calculator

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
guest
0 Comments
Inline Feedbacks
View all comments
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.