Forecasting SaaS Business Model

Introduction

The following analysis presents a comprehensive forecast for a theoretical single-product SaaS business covering revenue components and operating expenses. The provided data includes three months of actual performance and nine months of forecasted data. The primary objective is to develop accurate and realistic forecasts for New Logo Sales, Expansion / Contraction, and Churn and categorize expenses into Cost of Revenue and Operating Expenses. To achieve this, we will leverage the available data, establish assumptions, and employ appropriate formulas and functions in Excel to calculate the forecasts. We aim to provide a thorough rationale for each forecast, considering the SaaS business’s growth trajectory and financial outlook for the next nine months.

Forecast summary

We will use the provided ending total bookings ARR targets for each month to forecast the components of monthly net new ARR (new logo sales, cross-sell, net expansion, and churn). The idea is to back-calculate the values for each component to match the target values for Ending ARR.

New Logo Sales

New Logo Sales = Ending ARR – Beginning ARR + Churn + Expansion / Contraction

Expansion / Contraction

Expansion / Contraction = (Ending ARR – Beginning ARR + Churn) * Growth Rate

Churn

Churn = (Ending ARR – Beginning ARR) * (1 – Growth Rate)

Growth Rate is the monthly growth rate calculated as (Ending ARR / Beginning ARR)^(1 / Number of Months) – 1. To calculate the Growth Rate for the forecast period, we first need to find the number of months in the forecast period as follows;

1. Number of Months = 10 (May to Jan, excluding Feb to Apr)
2. Growth Rate = (Ending ARR at Jan-2023 / Beginning ARR at May-2022) ^ (1 / Number of Months) – 1

• Growth Rate = (112,453,661 / 64,842,695) ^ (1 / 10) – 1

1. Growth Rate = 0.0566 or 5.66%

How to improve ARR forecasting

To improve ARR forecasting, particularly for the components (new logo sales, cross-sell, net expansion, and churn), it is essential to consider the following factors:

Data Collection and Analysis

Improve data collection processes to capture accurate and timely information on customer acquisition, churn rates, and upsell opportunities. Analyze historical data trends to identify patterns and seasonality influencing ARR changes (Sukow & Grant, 2013).

Customer Segmentation

Segment customers based on various characteristics (e.g., industry, size, location) to better understand their behavior and needs. This will help tailor marketing efforts and product offerings, leading to improved new logo sales and expansion opportunities.

Customer Success and Retention

Strengthen customer success and retention strategies to reduce churn. Proactive engagement, personalized support, and addressing customer pain points can positively impact customer retention.

Upsell Opportunities

Analyze customer usage and behavior to identify potential upsell opportunities. Offer relevant add-ons or higher-tier plans to customers likely to benefit from them.

Competitor Analysis

Keep a close eye on competitors’ activities and pricing strategies. Understanding the competitive landscape can help in positioning the product effectively and staying competitive in the market.

Sales Team Training

Train the sales team to effectively communicate the value proposition of the product and address customer objections. Well-trained sales reps can have a significant impact on new logo sales and cross-selling.

Market Trends and Economic Factors

Consider external factors such as market trends, economic conditions, and regulatory changes that can influence customer buying behavior and overall market demand.

 Categories of the expenses

Cost of Revenue

COR Component X (given): The cost of revenue appears to be absent for all months, which indicates a fully SaaS-based model where the revenue is generated without significant direct costs.

Operating Expenses

1. S&M Payroll Costs: Include Sales and Marketing payroll expenses. Forecast these expenses based on the new account sales forecast and consider additional non-quota carrying sales roles needed to support growth.
2. Sales Commissions- Forecast sales commissions based on the new logo sales forecast and consider commission rates and sales team structure.

• Customer Support Costs- Forecast customer support costs based on expected customer growth and the level of support required for the customer base.

1. Product Operations Costs- Forecast product operations costs based on product development plans and the scale of operations.
2. R&D Payroll Costs- Forecast Research and Development payroll expenses based on the product roadmap and planned development efforts.
3. G&A Payroll Costs- Forecast General and Administrative payroll expenses based on the company’s growth plans and administrative needs.

• Implementation Costs- Forecast implementation costs based on customer onboarding plans and implementation requirements.
• Hosting and Platform Costs- Forecast hosting and platform costs based on anticipated growth in customer count and usage of resources.

1. Other Costs- These costs seem to include non-payroll-related expenses. Assuming they stay flat as a percentage of revenue, monitor them closely to ensure they are in line with business growth.

By carefully analyzing and forecasting each expense category, the SaaS business can develop a more comprehensive financial outlook for the upcoming months. Additionally, it’s essential to regularly review and adjust the forecasts based on actual performance and changing market conditions to minimize risks and ensure the business is on track to achieve its financial objectives (Ma, 2007).

 Forecasts for S&M Payroll Costs, Sales Commissions, and Other Costs

Assumptions for Forecasting

1. S&M Payroll Costs: Tie this expense to the New Logo Sales forecast and consider hiring additional non-quota-carrying sales roles to support growth. Assume a certain percentage of S&M payroll costs is variable and tied to sales performance.
2. Sales Commissions: Tie this expense to the New Logo Sales forecast and consider the commission rate for sales representatives. Assume a certain percentage of sales commissions is variable and tied to individual sales performance.

• Customer Support Costs: Forecast this expense based on expected customer growth and the level of support required for the increasing customer base.

1. Product Operations Costs: Forecast this expense based on the product development roadmap and planned operational activities.
2. R&D Payroll Costs: Forecast this expense based on the product development roadmap and the scale of R&D efforts.
3. G&A Payroll Costs: Forecast this expense based on the company’s growth plans and administrative needs.

• Implementation Costs: Forecast this expense based on customer onboarding plans and implementation requirements.
• Hosting and Platform Costs: Forecast this expense based on anticipated growth in customer count and usage of resources.

1. Other Costs: Assume that “Other Costs” are non-payroll related and will stay flat as a percentage of revenue for the remainder of the year. These costs may include marketing expenses, office supplies, utilities, and other general operating expenses.

To calculate the forecasts for S&M Payroll Costs, Sales Commissions, and Other Costs based on the above assumptions, each is outlined below:

S&M Payroll Costs

Assuming a certain percentage of S&M Payroll Costs is variable and tied to sales performance (say 50%), we can calculate the variable portion based on New Logo Sales forecast. The fixed portion can be assumed to remain constant.

1. Variable S&M Payroll Costs = New Logo Sales * Commission Rate * Variable S&M Percentage
2. Fixed S&M Payroll Costs = S&M Payroll Costs – Variable S&M Payroll Costs

Sales Commissions

Sales Commissions are directly tied to New Logo Sales, so the forecast can be based on the New Logo Sales forecast.

Other Costs

Since we assume “Other Costs” are non-payroll related and will stay flat as a percentage of revenue, we can calculate them as follows;

Other Costs = Revenue * Other Costs as a Percentage of Revenue

Conclusion

The forecasts developed for the single-product SaaS business provide valuable insights into its revenue components and operating expenses. By analyzing historical data and making relevant assumptions, we successfully projected New Logo Sales, Expansion / Contraction, and Churn for the forecast period. These forecasts can serve as a crucial foundation for decision-making and resource allocation in the upcoming months. Last but not least, this analysis provides a robust foundation for financial planning and decision-making, helping the SaaS business pave the way towards achieving its long-term objectives and positioning itself favorably in the market. By employing prudent forecasting methods and considering potential risks, the business can steer confidently towards its IPO, ensuring a strong gross margin and operating income perspective.

References

Sukow, A. E., & Grant, R. (2013). Forecasting and the role of churn in software-as-a-service business models.

Daim, T., Bukhari, E., Bakry, D., Vanhuis, J., Yalcin, H., & Wang, X. (2021). Forecasting Technology Trends through the Gap Between Science and Technology: The Сase of Software as an E-Commerce Service. Форсайт, 15(2 (eng)), 12-24.

Churakova, I., Mikhramova, R., & Gielen, I. F. (2010). Software as a service: Study and analysis of saas business model and innovation ecosystems. Universiteit Gent, 103.

Nordlund, C. (2010). A software platform for automating revenue forecasting and billing execution of Software Delivered as a Service (SaaS) (Master’s thesis).

Ma, D. (2007, July). The business model of” software-as-a-service.” In Ieee international conference on services computing (SCC 2007) (pp. 701-702). IEEE.

Liao, H. (2010, April). SaaS business model for software enterprise. In 2010 2nd IEEE International Conference on Information Management and Engineering (pp. 604-607). IEEE.