ACV and ARR Modeling Question
I’m preparing to complete a case study for a Tech-focused PE firm and have a pretty basic question regarding SaaS metrics. Assuming all customers/users pay the same amount per contract over a 3 year period for example, would the company’s subscription ACV x the number of users in a given annual period be the same as the ARR. I ask because I’m thinking through how to best project ARR when building out the LBO. Obviously you’d utilize an ARR snowball and make assumptions for churn, upsell, down sell % if you are told mgmt expects net retention to stay consistent. I’m getting confused on if the best way to project new users for the snowball is to simply do ACV x # of new users in a year to get New ARR. It seems like a flawed approach but probably the best given limited time and information. Anyone that can provide thoughts or clarity on how to best approach this would be much appreciated
Yes. To your question about projecting, sure that works for a model test. There are more creative ways of making projections for certain business types in real diligence situations. For example a business that sells large enterprise contracts, you could project new ARR based on new rep hiring and quota ramp / attainment history. For venture like PLG companies, you could forecast as a % of TAM. Many other ways.
It’s super simple but it’s hard to internalize without the reps so that it’s second natured. Don’t beat yourself up. Keep it up and you will be a pro in no time.
Y'know the other thing is - you might be aware of this but making sure you don't fall into this trap - ARR =/= revenue for modeling purposes. Your ARR roll takes time to be recognized as revenue. Once the contract is signed it is ARR, but then you might not start servicing that contract for a month, and THEN it is revenue. You should read up on how that flows monthly into deferred and the whole cash adj. EBITDA thing.
At the end of the day, for SaaS companies, the best way to model out their projections really depends on their go-to-market strategy.
For inbound leads, using customer marketing and sales funnel as the base can be a great mechanism. Specifically, within this, you would use the Company's historical marketing funnel (Source Sessions, Leads, MQLs, etc.) and then into the historical Sales Funnel (SQLs, demos, deal shaping, etc., close) as the basis for projecting total users. As a perquisite for this methodology, one would need detailed information into a Company's conversion rates throughout the funnel, as well as knowledge on any seasonality trends and the respective funnel the Company uses.
From there, you can bifurcate the model into different schedules for the inbounds through the funnel in conjunction with a separate schedule for the the outbound reps and quota and to capture both sales segments we typically see in a SaaS business. If the Company also has affiliates and channel partnerships as their main source for new customers, this would also require a separate schedule.
As a last point, agreed with Associate 2 on the ARR to revenue -- will certainly want to construct a deferred revenue schedule in order to correctly classify the ARR into recognized revenue at the appropriate timing intervals. With this, also important to understand how their contracts work (annual versus quarterly versus monthly). I typically like to create different sections for various contract lengths as combining them in a single section can be tricky.
Where can you find a deferred revenue schedule model I can look at, etc. examples?
Echoing this question re: deferred revenue schedule modeling. Would be great to be pointed to best resources
never had to do this one. How do you set this model up? Thank you.
BIWS released one a few months ago that has a detailed deferred revenue roll up
Corrupti voluptates doloremque laudantium sit ea at. Nostrum et nemo maiores et impedit. Odit corporis ullam aut et quas. Dolorum consectetur sit molestiae aspernatur. Sit delectus sint et. Voluptas soluta rerum est cumque sequi dolorum commodi. Praesentium exercitationem quos quia quia.
Aut est possimus veniam est ab quia unde facere. Est libero temporibus cumque temporibus enim sunt nihil consequatur. Amet sit quisquam corrupti. A alias qui repellendus consequuntur. Nesciunt nesciunt iste non delectus. Nihil dignissimos magni magni consequatur nulla debitis. Qui quaerat eos laudantium iure soluta.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...