Effective revenue forecasting is fundamentally powered by timely, accurate data and robust operational reporting. Together, these reports enable companies to make more informed, proactive decisions in real-time about pursuing new products, pricing strategies, entering new markets and allocating resources.
The financial planning and analysis (FP&A) function plays an essential role in this process, serving as a vital cross-functional link between executive leadership and “boots-on-the-ground” operational teams. This link helps translate operational performance metrics to financial models into actionable insights that align with financial goals.
While larger organizations may have a standalone FP&A function to manage this flow of information, small to mid-market companies struggle to break down silos between strategy and daily operations. However, without this alignment, revenue forecasting models can become disconnected from reality and execution, leading to misaligned predictions, missed opportunities, and potentially costly mistakes.
To ensure revenue forecasting is not reduced to a guessing game or speculation, FP&A helps establish core key performance indicators (KPIs), implement robust tracking methods and tools, and employ a variety of forecasting models for continued validation.
Each model offers advantages and varying perspectives to form more accurate and comprehensive future predictions, enabling organizations to effectively respond to changing market conditions and industry trends in real time, and maximizing both accuracy and agility in their planning.
Defining KPIs for an HVAC and Plumbing Company
After a residential HVAC and plumbing company cut approximately 20% of its field technicians, it missed revenue targets for two consecutive quarters due to demand forecasts that did not account for the necessary supply. Cherry Bekaert’s FP&A practice identified gaps in the company’s approach and defined KPIs for a more accurate look at its financial health.
Foundations for Effective FP&A Forecasting
Revenue forecasting can and should be approached using several methods, including top-down and bottom-up, to develop a comprehensive and effective revenue strategy.
Top-down Forecasting: Strategic Insights From Above
The top-down approach to forecasting involves a macro-level market analysis that considers factors such as industry trends and growth rates, economic conditions and competitor performance to capture and construct a strategic view of potential revenue without getting into the operational “nitty gritty.”
For example, a consumer packaged goods (CPG) company planning to launch a new line of organic chips might leverage data from sources like IBISWorld or Packaged Facts to understand the anticipated growth of the healthy snack market.
Once this broad market intelligence is gathered, it can be applied to revenue models by scaling market estimates down according to the company’s share of the total addressable market. Leaders assess the organization’s current position, brand strength and distribution channels relative to competitors, estimating what percentage of the projected market growth their company can realistically capture.
The resulting model offers a high-level, strategic projection that helps shape annual budgets, inform investment decisions and guide resource allocation across the business. But by continuously comparing these projections to real-world performance data, executives and FP&A teams can adjust their strategies and refine their models to better align with shifting market realities and corporate goals.
Bottom-up Forecasting: Ground-level
While top-down forecasting offers strategic direction, bottom-up forecasting provides operational accuracy and ensures it’s executable. Bottom-up forecasting takes a micro-level approach by collecting data from various operational units, based on individual product lines, sales channels and customer segments. For instance, an e-commerce company might analyze last year’s SKU-level sales data from platforms like Shopify, shaping future production and marketing strategies.
A notable aspect of this method is its capacity to translate the company's growth strategy into operational forecasts, often referred to by sales teams as a "go-and-get" plan. The approach facilitates analysis of which product categories contribute most to volume and margin, identifies potential cannibalization among offerings, and highlights areas of financial loss. It also helps assess whether targeting new customer bases through the introduction of new products is feasible, explores options for cross-selling or upselling additional services to existing clients, and considers investment opportunities to support future expansion.
Organizations should employ both methods to create a balanced forecast that captures the strategic vision while remaining grounded in operational feasibility. By integrating strategic growth drivers directly into account and product-level forecasts, FP&A teams help deliver revenue forecasts that are both ambitious and realistic, aligning long-term goals with day-to-day activities.
Analytical Techniques That Drive Forecasting Models
Techniques such as the straight-line, moving averages, linear regression, and multiple regression methods are employed to analyze historical performance data and predict future trends. This rigorous data analysis helps align departmental goals with company-wide objectives, providing a comprehensive understanding of the operational habits and constraints that affect revenue generation.
While there are numerous methods, we break down the most common in the table below.
|
MethoD |
Approach |
ApplicatioN |
Data Required |
| Straight-line | Predict future revenue by taking figures from the prior year and multiplying them by the determined growth rate | Best suited for stable businesses with predictable growth patterns | Historical data |
| Moving averages | Determine underlying patterns and estimate future revenues by using a set of data averages | Ideal for businesses experiencing seasonal fluctuations or irregular trends | Historical data |
| Simple linear regression | Predict future values by analyzing the linear relationship of a dependent variable with a single independent variable | Effective for straightforward relationships where one primary variable drives revenue | Relevant sample data |
| Multiple linear regression | Predict future values by analyzing the linear relationship of two or more variables, like advertising cost and revenue | Suitable for complex environments where multiple factors influence revenue | Relevant sample data |
Combining Data and Operational Reporting To Power Revenue Forecasting
To fully harness the power of revenue forecasting, modern organizations need centralized access to both financial and operational data in real-time. That way, FP&A teams can be empowered to pull gross margin insights mid-month (omitting any accounting adjustments) without waiting for accounting to close the books and provide updates to company leadership.
But keep in mind, these tools also require clean and accurate historical data to be used most effectively. By integrating comprehensive reporting into the FP&A process, businesses can identify trends earlier and respond dynamically to changing market conditions, laying the groundwork for more reliable projections and strategic agility.
Some tools that support revenue projections, which the FP&A function can help implement, include:
- Excel (for basic models)
- Tableau and Power BI (for data visualization and regression analysis)
- NetSuite, Sage Intacct, Planful and OneStream (for more automated, scalable forecasting)
Establishing Data Analytics Tools for a Cannabis Company
A vertically integrated cannabis business sought assistance from Cherry Bekaert’s FP&A practice to implement budget consolidations and scenario reporting tools necessary to support decision-making needs for its retail locations.
Recognizing and Addressing Forecasting Challenges
While integrating financial and operational data is essential for robust revenue forecasting, it is equally important to exercise sound judgment throughout the process, as correlation doesn’t always equal causation. Sometimes, outliers such as one-time events or short-lived surges can distort projections. To help forecasts remain accurate and actionable, it’s important to:
- Distinguish between correlation and causation, validating that revenue changes reflect underlying business drivers.
- Identify and adjust for anomalies or outliers, like unexpected spikes driven by singular events.
- Align supply and demand assumptions to ensure forecasts reflect operational realities.
- Cross-verify assumptions using both financial and operational data for a holistic view.
By understanding when a revenue spike is meaningful versus an anomaly, plus leveraging timely data, organizations can separate good forecasting from great forecasting — producing more dependable forecasts that inform confident, proactive decision-making.
Leveraging Cherry Bekaert’s FP&A Practice To Guide You Forward
Cherry Bekaert empowers organizations with technology-driven insights and enhanced FP&A capabilities, enabling them to implement cost-effective and scalable solutions that equip businesses to accelerate advanced decision-making, drive growth, and optimize resource utilization for transformative outcomes.
Related Insights
