Exisitng Customers To analyze how much additional business your sales team can bring in from existing accounts, you can calculate an MRR known as the Expansion MRR. This is an excellent way to measure your sales team's upselling and cross-selling abilities. In the above example, if the customer increases the order value to $2400, keeping the delivery schedule the same, then the Expansion MRR will be (2400-1800)/6 = $100.
New Customers To keep growing your business, you need to keep acquiring new accounts. This MRR calculation will help you understand how capable your team is of generating business from new accounts. It will also give you an insight into how effectively prospective leads are getting converted into business. If we consider it a new customer in the above example, then the New MRR will be $300.
Lost Customers Even though you will never want this to happen, there will be instances of customers reducing their business with you. It may not necessarily be because of a failure of your sales strategy or lack of performance of the sales team, but there may be many other factors resulting in the decline of revenue from an account. In the above example, if the customer reduces the order value to $1200, keeping the delivery schedule the same, then the Churn MRR will be (1800-1200)/6 = $100. To find out the overall MRR of your business, you need to consider all of the above MRR types. The New MRR and Expansion MRR indicate increased monthly revenue, whereas the Churn MRR suggests a monthly revenue decrease. To calculate the Net MRR, you need to add the New MRR figure with the Expansion MRR figure and subtract the Churn MRR value. If the Net MRR value is positive, then it will mean that your business is in the growth phase, and if it is negative, it will mean that your business is facing degrowth.