background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for February 2025 for September 2024
:
Private EquityReal Estate InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Top Down Forecasting

Step-by-Step Guide to Understanding Top Down Forecasting

Join 750k+ learners today. Learn online from Wall Street Prep — the training firm that prepares new hires at the world's top financial institutions.

Enroll Today

Top Down Forecasting

  Table of Contents

How to Perform Top Down Forecasting

The top-down forecasting method takes on a “bird’s eye” view of the total market that is reasonably attainable to project the revenue of a company.

The top-down forecasting approach provides a projection of revenue by multiplying the total addressable market (TAM) of a given company by an assumed market share percentage.

Compared to the bottom-up approach, the top-down approach tends to be more convenient and less time-consuming to perform.

However, a bottom-up approach is generally the preferred method by practitioners, because it focuses on the specific unit economics of the business, rather than taking a broad market-based view, making the associated assumptions arguably more defensible.

Top Down Forecasting Formula

The formula to forecast revenue using the top down method multiplies the market size (TAM) by the market share assumption.

Forecasted Revenue = Market Size × Market Share Assumption (%)

Where:

  • Market Size → The total revenue opportunity present in the specific market.
  • Market Share Assumption → The implied percentage of the market obtained by the company.

The Wharton Online
& Wall Street Prep
Buy-Side Investing Certificate Program

Fast track your career as a hedge fund or equity research professional. Enrollment is open for the Feb. 10 - Apr. 6 cohort.

Enroll Today

Top Down vs. Bottom Up Forecasting: What is the Difference?

The top-down approach is often used by established, mature companies that have decades of financial results, an international presence and several different lines of business segments (e.g., Amazon, Microsoft).

For companies of such large magnitude and diverse revenue sources, breaking the business model into a granular product-level forecast could become too complicated, and more importantly, the benefit of doing a detailed bottom-up forecast would only be marginal.

Often, the top-down approach is also used for early-stage companies that lack any historical financial data in order to create a fundamentals-based forecast.

The primary use-case of top down forecasting is a “back-of-the-envelope” estimate in order to decide if an investment opportunity is worth diving into, rather than being meant to be a precise projection.

Because of the absence of data to work with, a top-down approach is the only option in those scenarios, as a bottoms-up forecast for a seed-stage company would include too many discretionary assumptions that cannot be backed up by historical results.

While top-down forecasts are less credible than bottom-up forecasts, it is still useful for quickly validating the revenue potential of an early-stage company operating in markets not yet well-defined.

For companies that fall between the seed and mature stages, such as late-stage companies in the growth stage, the top-down method tends to be viewed as a “quick and dirty” approach to projecting revenue, and is therefore rarely taken at face value. Instead, the top-down revenue forecast serves as an initial starting point before delving deeper into the company.

Top Down Forecasting Calculator — Excel Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Excel Template | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

1. Market Sizing (TAM vs. SAM vs. SOM)

SOM SAM TAM Market Segmentation

In our simple example scenario, we are assuming that this is a top-down revenue build of a B2B software company based in the U.S. with SMBs (small-to-medium businesses) as the target customer type.

The total addressable market (TAM) is representative of the entire revenue opportunity available within a market for a particular product/service offering.

As implied by the name, the top-down approach begins with a macro view of various factors – beginning with sizing up the total addressable market (“TAM”).

The TAM is an all-encompassing view of the market and the broadest in terms of having the most relaxed standards in measuring the potential customer count.

  • TAM ➝ The TAM is the total (global) market demand for a product and the maximum amount of revenue that can be made in a specific market (i.e., the company and its competitors are all competing for their share of this market).
  • SAM ➝ Next, the TAM can be broken down into the serviceable addressable market (“SAM”), which is the proportion of the TAM that actually needs the company’s solutions. In effect, we are starting with the largest potential value for the TAM, and then reducing it using company-specific information and assumptions regarding the market. The SAM depicts the percentage of the total market that could realistically become customers based on the fit with the product offerings and business model (e.g. geographic reach, technical capabilities, pricing). To reasonably approximate the TAM and SAM with relative accuracy, the customer profiles in the market and their specific needs must be understood to assess whether these types of customers can actually become potential customers.
  • SOM ➝ The final subset is called the serviceable obtainable market (“SOM”). The SOM takes into account the current market share of the company and accounts for the portion of the SAM that can realistically be captured as the market grows (i.e., retain its current market share into the future). Here, the revenue from the prior year is divided by the industry’s SAM of last year, which represents the market share held in the previous year. And then, this market share percentage is multiplied by the industry’s serviceable addressable market for the current year to arrive at SOM.

The diagram below lists the formulas used to calculate the TAM, SAM, and SOM:

TAM SAM SOM Formulas

2. Customer Type Breakdown

To begin our walk-through of the hypothetical scenario used in our model, we first determine the total number of companies that the company could potentially sell its products to.

Customer Types

Based on our assumptions, we can see that in 2020, in the global market there are a total of:

  • 2,000 Large Enterprises
  • 8,000 SMEs
  • 40,000 SMBs

In our made-up scenario, the size of the market has been determined to consist of 50,000 total potential customers.

The next step is to project the growth rates of the market. But as opposed to attaching a growth rate assumption to the entire market, the forecast will be far more accurate and reliable if the market is segmented.

These growth rates must take into account the trends that pertain directly to each specific sub-market, which requires referencing market data and industry reports to understand which areas of the market present the highest growth opportunities (and vice versa).

From our example, SMBs are the highest growth segment in terms of customer growth while larger enterprises appear to lag behind.

3. Product Pricing Analysis

Next, we must approximate the pricing of the product for each customer type. The product value and pricing attributable to each customer type must be taken into account since pricing will differ based on the spending power and requirements of the customer.

In our example, we have used the average contract value (“ACV”), which is common to see for software companies.

Alternatively, other frequently used pricing metrics used are:

  • Average Revenue Per User (“ARPU”)
  • Average Order Value (“AOV”)

Notice that while this is a top down forecast, there are aspects of the process that are bottoms-up (such as this piece), as the two approaches are not mutually exclusive.

The assumptions related to the market growth, customer growth and ACV growth are typically pulled from 3rd party industry reports published by research & advisory firms that specialize in market sizing, compiling industry data sets (e.g., pricing), and identifying ongoing trends.

ACV Calculation

As expected, in 2020, the ACV is the greatest for large enterprises at $100, and then $50 for SMEs and $25 for SMBs. Thus, acquiring one large enterprise customer is roughly equivalent to acquiring four SMBs.

Based on our ACV assumptions, SMBs will exhibit the most upside in customer pricing (i.e., ACV) during the coming five years. Currently, the ACV in 2020 is $25, but this is anticipated to roughly double to $51 by the end of 2025.

The pricing rates for large enterprises are likely near the ceiling, whereas SMEs and SMBs have more room to grow. This suggests the type of software being sold was initially geared towards larger enterprises but had not been customized to serve smaller businesses.

4. Market Sizing Analysis (TAM, SAM, SOM)

SMBs are the customer segment with the highest expected CAGR of 34.9% in the forecast period, as seen by the 5-year CAGR of the segment’s TAM.

Putting the observations so far together, such as the TAM growth and pricing upside, SMBs seem to be the most compelling growth opportunity among the three customer categories.

Now in the subsequent steps, we will:

  1. Estimate the TAM
  2. Approximate the SAM
  3. Project Revenue Based on the SOM

After multiplying the customer count under each classification by the corresponding ACV, we can compute the TAM of each individual segment for each year and then sum all three segments for the entire market.

For example, the TAM of SMBs in 2020 is calculated by multiplying the $25 ACV by the 40,000 SMBs globally that fall under the customer profile. Once the same is done for SMEs and large enterprises, the total market size comes out to $1.6bn.

Moving onto the SAM, since the B2B software company sells a target primarily intended for usage by SMBs, our assumptions are skewed towards that specific customer type. In addition, we can narrow our market down further based on those located in the U.S.

TAM and SAM Sizing Calculation

Therefore, of all the potential companies to sell to that were included in the TAM, the product can realistically be sold to:

  • 20% of the total number of large enterprises
  • 40% of the total number of SMEs
  • 80% of the total number of SMBs

Those excluded customers are not necessarily impossible to acquire, but given the current circumstances of the company and various factors (e.g., geographic reach, targeted growth plans, product features, scalability capacity), the SAM serves as a more realistic assessment of the market that can be obtained.

Then, using the SAM figures, revenue is projected by:

Revenue = SOM % Take Rate Assumption × SAM Market Size

For simplicity, we are assuming that revenue is equivalent to the SOM; hence, the usage of conservative numbers when estimating the SOM (i.e., % of SAM and YoY growth rates).

SOM Sizing Calculation

 

In our model, we have included three different scenarios:

  • Base Case ➝ The most conservative case with the assumption that the segment-level market shares (i.e., % of SAM) in 2020 remains constant throughout the next five years
  • Upside Case ➝ Likely the management case assumptions, the assumptions are more optimistic as seen by the 1%, 2.5%, and 5% YoY growth rates for large enterprises, SMEs and SMBs respectively
  • Downside Case ➝ The third case contains a slight haircut from the base case figures in that that YoY growth rates are -1%, -2.5%, and -5% for large enterprises, SMEs and SMBs

5. Top Down Forecast Revenue Model

The revenue projections under the upside case have been shown below.

In the upside case, the total revenue grows at a CAGR of 37.9%, with revenue from SMBs growing at 41.6% and comprising the majority of total revenue. The market share as a percentage of SAM also expands from 2.5% in 2020 to 3.1% by the end of 2025.

Revenue Projections Calculation

Upside Case

And by dividing the projected revenue per customer type by the coinciding ACV amount, we can back out the implied customer count.

From 2020 to 2025, we can see that:

  • Large Enterprises: 20 → 26
  • SMEs: 60 → 102
  • SMBs: 800 → 2,238

For the base case, the market share assumption is that for each segment, the share percentage will remain unchanged throughout the entire forecast period.

Revenue Projections - Base Case

Base Case

But revenue still grows at a CAGR of 31.7% because of the growth of the market.

More specifically, the revenue of the B2B software company is concentrated on SMBs, and recall, SMBs market growth is expected to grow at 34.9%.

The takeaway is that even if the company fails to capture market share (i.e., around 1.6% of TAM and 2.5% of SAM), its total revenue can still grow at a 31.7% CAGR over the next five years.

Finally, our revenue projection model under the downside case is complete.

In closing, the CAGR of total revenue is still relatively strong at 25.6% in the downside case. But in later years, it is clear that the number of customers is beginning to wane.

Revenue Projections - Downside Case

Downside Case


The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.