Bottom-up Forecasting in B2B Sales Companies: A Comprehensive Guide
Here, companies will still consider sales channels but look at variables like the number of active subscriptions, churn rate, and pipeline coverage to forecast revenue. Next, we estimate how much will be charged for those sales and what the business nets from those sales. Yet, for all companies, a detailed forecast is imperative for properly establishing goals, budgeting and setting revenue targets for all companies.
What is bottom-up sales forecasting?
This approach is rooted in the knowledge and insights of employees involved in business operations. The most important mitigation technique is to ensure that there is a strong common understanding of data-driven decision-making. Deal signals and sales KPIs need to be available and reps need to be educated on them. In theory, all forecasting could be done with Excel or Google Spreadsheets. There’d be a lot of exporting and importing various CSV files, dealing with outdated files and data, keeping track of submission timestamps, and chasing stakeholders.
- For example, if you’re an e-commerce business, you might look at data like average order value, customer lifetime value, and conversion rates.
- It doesn’t look at the organizational operations from a comprehensive overview and assign quotas to fulfill but works with goals grounded in reality.
- Automating some of these processes with software can help streamline your efforts.
- The top-down approach involves starting with an estimate of the total market size and then working backward to determine the business’s potential share of that market.
- You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.
What is Top-Down Sales Forecasting?
Bottom-up forecasting, in particular, offers a granular approach by building forecasts from the ground up, starting with individual units or segments within an organization. Business leaders rely on forecasting to make decisions on the direction of their organization. Yet, with so many sales forecast methods, it’s hard to know the right approach. Bottom-up forecasting allows you to get a clear picture of projected revenue by breaking down the underlying components that ultimately drive revenue generation, profits, and growth. It is important to choose the right sales forecasting method depending on the company’s needs and resources. Both methods have their advantages and disadvantages and should be evaluated carefully before making a decision.
Effective Bottom-Up Forecasting: Techniques and Implementation
For more on the pros and cons, take a look at this Revenue Grid blog post. At HubiFi, we specialize in helping businesses implement robust data strategies, including accurate and efficient forecasting. Schedule a demo to see how we can help you leverage data for better decision-making. Bottom-up analysis in market sizing builds from specific, granular data points to create an aggregate market estimate.
Different departments hold valuable insights into market trends, customer behavior, and operational realities. As highlighted in this practical guide, integrating these diverse perspectives creates a more comprehensive and accurate forecast. Regular meetings or collaborative platforms can facilitate information sharing and ensure everyone is on the same page. Bottom-up forecasting can be data-intensive, so explore software solutions that automate data collection, analysis, and reporting.
Optimistic view
By beginning with the total addressable market (TAM), they calculate expected sales based on the percentage of market share they aim to capture. Bottom-up forecasting projects revenue with micro-level inputs, such as individual sales rep performance, unit sales, and channel-specific data. Sales teams rely on this method to estimate future business performance by building sales projections from the ground up. When teams use different forecasting methods, it’s hard to combine their individual forecasts into a cohesive whole. Implement a standard forecasting platform and methodology across the company.
By leveraging the expertise of those closest to the action, bottom-up forecasting can yield more accurate and detailed financial projections. Historical company performance, industry growth rates, and economic indicators heavily influence top-down forecasting. The top-down approach to forecasting has earned a fan base among large organizations and those juggling multiple divisions as it grants a holistic perspective of the entire business.
These features can help you identify trends, spot anomalies, and gain deeper insights from the bottom up method for forecasting sales your data. Consider providing training to your team on data analysis techniques to ensure everyone can interpret the data effectively. Team members often believe their department runs efficiently and may overestimate or underestimate needs. Address this bias by implementing clear guidelines for data collection and justification. Regularly review assumptions with a critical eye, questioning even seemingly reasonable requests. For example, consider implementing a system where budget requests are tied to specific, measurable goals.
How to perform bottom-up forecasting with Revenue Grid – 4 simple steps
Put another way, bottom-up forecasting is like looking at the health of a complex system, like a vehicle, by looking first at its most basic parts, like its engine components. Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts. With the refund forecast filled out, we can move on to calculating net revenue, which accounts for the refunds and avoids double-counting. Now, we have all the calculations set for the first projection year, which we can now extrapolate forward for the rest of the forecast.
Now, we can create assumptions for these drivers with three different scenarios (i.e., Base Case, Upside Case, and Downside Case). The ASP of an individual product comes out to about $100 in 2018, which grows to around $105 in 2020. The inclusion of the refund amount in our formula by using net revenue would cause us to make the mistake of double-counting. For instance, the AOV in 2018 was $160 and this figure grows to approximately $211 by 2020.
Schedule regular reviews to discuss these nuances and adjust your forecast as needed. A dynamic forecasting process allows you to adapt to changing market conditions and make more informed business decisions. For tailored solutions and expert guidance, consider scheduling a data consultation with HubiFi. Bottom-up forecasting is a way to predict future revenue by starting with the smallest parts of your business and working upward. Instead of looking at the company as a whole, it focuses on individual product sales, team performance, or even individual transactions.
This article will help you to consider a few key points in the process of building your forecast.
- These models focus on the key drivers that influence financial performance, such as sales volume, pricing strategies, and cost structures.
- Modern software tools like Anaplan and Adaptive Insights offer sophisticated capabilities for data integration, analysis, and visualization.
- These features can help you identify trends, spot anomalies, and gain deeper insights from your data.
Set it too low, and you leave money on the table, missing growth opportunities. In this guide, we’ll cut through the complexity and show you exactly when and how to use each approach to build sales forecasts you can actually trust. This section provides a practical, step-by-step guide to creating a bottom-up forecast. By following these steps, you can build a robust and accurate financial model.