SaaS: Simple Bookings vs. Churn Excel Model

Description
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!