RevOps Co-op Weekly #70 - The Sales Forecasting Spreadsheet
The best sales leaders are looking into the future. In this article, we will be covering a deep dive into setting sales goals based on revenue growth.
RevOps Co-op provides resources, content and community for those who ❤️ revenue operations. This weekly newsletter features collected tweets, posts and thoughts on a variety of RevOps topics. We also have a private Slack community with > 3,800 RevOps pro’s from companies like Slack, Lyft, Clari, Miro and more 👉🏻 click here to join.
The Sales Forecasting Spreadsheet
Sales Forecasting is a topic that every RevOps Leader will eventually have to tackle. Nothing is 100% predictable, but using methods like the ones below can at least make things more predictable. That extra level of predictability could be the difference between success and failure over the short-term, and help bring stability to your entire revenue organization.
That’s why we’re so excited to feature this Sales Forecasting Spreadsheet offered by Jon Martin, The Founder & CEO of RevenueOps.co. We’ll let him take it from here!
The best sales leaders are looking into the future by setting goals, forecasting, finding new salespeople, and coaching their current team.
Goal setting for your sales team focuses on four metrics:
1. Revenue Growth
2. Sales Acceleration
3. Close Ratios
4. Quote/Revenue per rep.
In this article, we will be covering a deep dive into forecasting for revenue growth.
Revenue Growth
When building a sales forecast based on Revenue Growth, there are a few different structures to consider:
(MRR) Monthly Recurring Revenue - The predictable total revenue generated by your business from all the active subscriptions in a particular month
(ARR) Annual Recurring Revenue - The predictable total revenue generated by your business from all the active subscriptions in a particular year
Un-Scoped Time & Material Engagements - Future deals that have yet to be scoped out by your team. Early stage Opportunities.
Scoped Projects - Future deals that have already been scoped by your team. Later stage Opportunities.
Many businesses have more than one of these structures that they leverage. The variety and unpredictability of these different options can make it very difficult to look 5, 3, or even 1 year into the future.
Building your quarterly revenue goals and the required pipeline growth to reach those goals can be frustrating. To do so, you need to define and be able to measure the ever-changing variables of:
Close Rate (dictates how much deal value we need to create)
Deal Velocity (dictates how early those deals need to be created)
Total Deal Quantity (dictates how many deals we need to get there)
In my consulting practice, I’ve dealt with several sales leaders struggling to wrap their heads around this challenge. As I was building out a spreadsheet for them, I mentioned this on LinkedIn and asked if there was interest from other people. I quickly had 30 people raise their hands saying that they'd like a spreadsheet like this.
That level of interest prompted me to turn it into a tool that other companies could use and leverage on their own.
The spreadsheet & instructions below will do the following things for you:
Give you black and white clarity on your numbers and the growth behind those numbers.
Display the impact of changing pipeline velocity and/or close rate on your required pipeline.
Completing the Sales Forecasting Spreadsheet
Building your Pipeline Goals & Forecasting Spreadsheet
Tab 1
Fill out your annual goals for the first year by pipeline or service. The spreadsheet will show you revenue % per pipeline, as well as total revenue.
Name your goal years.
Enter the names of your pipelines or services.
Tab 2
Add the percentage of growth you want to experience after the first year and then for the next 4 years.
Tab 3
Tab 3 pulls in the data from tabs 1 & 2 and sets up a nice table of growth by pipeline for the next 5 years.
Use the columns with percentages to adjust the revenue coming from each pipeline over the next 5 years.
Tab 4-7
These Tabs are specific to each pipeline. For each tab you are using:
Add your days-to-close (pipeline velocity)
Add your close rate (conversion percentage)
Adjust the revenue percentage per quarter
This will show you the total pipeline to create and give you a date (based on days-to-close) that starts the 90-day period. This is the period that correlates with your quarterly revenue, where you need to create the required pipeline amount to enable you to hit your revenue goals.
Next Steps
After you complete those 7 tabs, you will have a clear understanding of the required pipeline growth for the next 5 years. You will also see the impact of the days-to-close and conversion rate metrics.
Play with changing the close rate and days-to-close to see how it impacts the workload of your sales team.
Currently, this tool is focused on scoped projects & T&M sales projects. A version is coming that will also facilitate MRR & ARR as well.
Get access to the spreadsheet template by completing the form at the link below:
https://salesforecastspreadsheet.com/
Have Other Questions?
Feel free to reach out! I am happy to answer your questions or continue the conversation in the RevOps Co-op community or on LinkedIn.
…There’s more! Read full blog here 👉 The Sales Forecasting Spreadsheet!
🗣 From the Community
#04_revops-questions - Top of Funnel Metric Benchmarks
2/1/22: Hi Folks! We're working on some new models for pipeline projection and taking a peek at our TOFU conversion rates; does anyone have solid standard benchmarks for top of funnel that they would be willing to share? Read 7 Replies
#04_revops-questions - AM Existing Business Order Form Process
2/2/22: Hi all - I'm working on overhauling our Order Form process for Extension/Existing Business deals, and running into some resistance from Sales Leadership.
Here's the scenario: AMs now, create new Opportunities when they have sold expansions on an Account, but they include ALL subscriptions to it, not just the net new subscriptions. Meaning, they are renegotiating terms with our Customers before the original term period is over (sometimes this could be 60 days after the original Opportunity came through). This is crazy to me, but wanted confirmation that this is not normal.
What makes sense to me: AMs create an opportunity and only include the net new subscriptions, but make sure the renewal date matches the renewal date of the Original Opportunity. So once the renewal date comes closer, they can renegotiate ALL the subscriptions. Would love your $0.02 Read 8 Replies
#08_tools-and-software - Best MAP for B2B
1/31/22: Curious the community's opinion on Marketing Automation - best overall platform for B2B Marketing today? HubSpot, Marketo, Pardot, Other (please share).
I've always used Marketo or HubSpot but found the former to be a beast to manage and the latter to be very limiting. What's the best platform and why? Read 18 Replies.
#08_tools-and-software - Partner Program Software Recs
2/1/22: Does any one have any recommendations for partner program software? Our sales team is taking over the partner program and I’m not sure where to start. Read 13 Replies
💬 Access the RevOps Co-op Slack group here to contribute to the conversation!
🐦 This week in #RevOps Social
📞📞🤔 Should We Really? 🤔📞📞
🎵🎶 We Love This Song 😭😭
RevOps Leaders Can Relate! 😅
📅 Upcoming Events
RevOps Hangout with the ROC! Virtual Networking - Thursday, February 17th at 2pm CT (5pm ET)
Topic: How What's in your RevOps Tool Stack?
Room 1: Startup Stack (For those pre-hypergrowth teams)
Room 2: Mid to Enterprise Tool Library (For those teams with more tools and more complexity)
The Modern Leader’s QBR Playbook | BoostUp - February 17th at 11am PT (8am ET)
Join revenue leaders at Degreed, Seismic, BigPanda, and BoostUp.ai as they discuss best practices for planning, implementing, and running effective and strategic QBR meetings.
The World’s First Customer Onboarding Conference | Rocketlane - March 15-16, 2022.
Propel is the world’s only conference for Customer Onboarding and Implementation professionals. Learn and engage with leaders and practitioners who’ve been in your shoes, faced the same challenges, and have overcome the same obstacles. Gear up for expert talks, real-world case studies, exhaustive workshops, and a whole lot of fun! If you want to level up your customer onboarding, Propel is for you.
📚 Your curated #RevOps reading list
Show me the money! How to get budget approval for a new tool | Ops Ops
In What does Ops do? I described how ops teams wrestle with the complexity that exists even at small startups. Ops teams ensure that all teams have the data and tools they need when they need them. How difficult it is varies. The data feeds between teams are hairier than the internal feeds of each team. There are two options to enable data feeds between teams: Build it yourself, or buy an existing solution. The decision is as old as the software business itself, and it's rarely easy.
Revenue Operations and Finance: The Deal Desk Dream Team | RevOps.io
Over the last year, it's become increasingly clear that establishing a Deal Desk is a critical task for companies of all stages. While many earlier-stage businesses might think that it is unnecessary, there's no question that the sooner you implement a Deal Desk, the easier it will be for you to scale.
What You Thought You Knew About MEDDIC Is Wrong | Clari
Poor sales qualification is one of the biggest reasons for poor sales performance for B2B sales reps. The MEDDIC framework can help sales pros properly qualify prospects, so they’re selling to the right people in the right way, and closing more sales. But misunderstandings abound around this powerful framework. Reps often resist implementing it, making it difficult to create a consistent sales process for your org. Here are the top seven reasons your reps may have for not using MEDDIC and ways to counter their concerns.
🎧 RevOps Podcasts
How CEOs Should Improve the Buying Process to Scale Revenue | Predictable Revenue
Mary Grothe is a former #1 MidMarket B2B Sales Rep and CEO of House of Revenue, a Denver-based firm of fractional Revenue Leaders. Her team currently leads the marketing, sales, customer success, and RevOps departments for 15 companies nationwide. Mary joined the Predictable Revenue podcast to discuss how CEOs can remove friction from the outbound sales process and scale their company’s revenue holistically.
AJ Alonzo: Testing And Creating New Marketing Demand Solutions | PinchForth
If at first, you don’t succeed, then try try again. As cliche as that expression sounds, it has a ring to it that really works within the field of marketing and the experimentation it employs. What makes marketing unique from a business perspective is that it is never shy of the type of creativity that drives teams into realms of experimentation prior instances wouldn’t have presented them with. In the case of a black swan event like the Covid-19 pandemic, many businesses were forced to integrate themselves into the digital space. AJ Alonzo recognized the importance of this transition, and he credits the immediacy it provided for him and his marketing team's new approach to marketing and creative experimentation.
Creating a Roadmap towards RevOps Success with Saul Garcia, VP of Revenue Operations at Health Recovery Solutions | RevOps Demystified
In this episode of RevOps Demystified Podcast, Tom Hunt and Alex Freeman are joined by Saul Garcia, VP of Revenue Operations at Health Recovery Solutions (HRS). They discuss the core difference between sales and RevOps, creating a roadmap for success and revenue target planning.
🔥 A few HOT #RevOps Jobs
Director of Sales Operations | Qualia
Business Systems Sr. Manager / Director | Qualia
Sales Operations Senior Analyst / Manager | Qualia
Sr Product Manager | Sophos
Sales Operations Manager | Polly
Sales Operations Manager | Aloware
The Senior CFT Revenue Operations Manager | Vendr
Revenue Operations Analyst | HealthJoy
Salesforce Developer | Lively
🚒 Weekly RevOps Meme
Thanks RevOps.io!
Funnel IQ is your revenue command center, continuously monitoring the health of your revenue engine across marketing, sales and customer success, alerting you to anomalies and relevant signals in your GTM data. Check out our latest Funnel IQ Product Update #5 - Alerts, Actions and Digests and subscribe to stay up to date. Let us know if you want to try out Funnel IQ Signals with your team by joining the Beta.