SaaS: Simple Bookings vs. Churn Excel Model
Originally published: 14/09/2018 15:24
Publication number: ELQ-68339-1
View all versions & Certificate

SaaS: Simple Bookings vs. Churn Excel Model

This is a simple ready-to-use Excel model which helps to run bookings and churn rates, also showing impact on growth.

This excel download provides a model in which to run bookings and churn rates. It also allows the user to observe Month over Month (MoM) growth, alongside Year over Year (YoY) growth.

This model incorporates the Monthly Recurring Revenue (MRR), which is perhaps the most important aspect in a subscription-based company. It allows the business to track, measure and anticipate recurring revenue streams.

The download also incorporates churn rates, i.e. the amount, or the percentage, of those who subscribe to your service, but end this subscription in a certain period of time. Churn is an inevitable part of any subscription service for a variety of reasons, including a lack of funds on the client end, losing out to other competitors, or the client no longer needs the particular service that was once needed.

This tool calculates the MRR starting, with Bookings Rate, MRR Booked and Churn Rate to then produce the Monthly Recurring Revenue - Ending.

The other aspect to this Simple Bookings vs. Churn Model is the growth impact calculations. Showing the MoM and YoY growth is extremely important to a business, and particularly to a start-up as it acts as a measure of its current and potential future success for itself and investors.

If you have any questions on the model or my business, don't hesitate to reach out to me directly or start a discussion!

This Best Practice includes
1 Excel Document

Brian Parks offers you this Best Practice for free!

download for free

Add to bookmarks


3.8 / 5 (4 votes)

please wait...