Top-Line Forecasting in Modelling

Based on the most helpful WSO content, here are some detailed steps and considerations for top-line forecasting in a DCF model, especially when dealing with a private company like CRU Group:

1. Understand the Business Model and Operations:

   • Key Performance Indicators (KPIs): Identify the KPIs that drive growth, such as new customer contracts, market share gains, or increases in unit pricing.
   • Revenue Drivers: Look at granular revenue builds, such as the number of store locations, sales per store, or units sold.

2. Growth Assumptions:

   • Organic Factors: Focus on organic growth factors like winning new customer contracts or market share gains.
   • Historical Data: If available, use historical growth rates as a baseline.
   • Industry Trends: Consider industry growth rates and trends to inform your assumptions.

3. Projection Period:

   • Short-Term Projections: Typically, project financial performance for 3-5 years. Beyond this, projections become highly assumption-driven and less reliable.

4. Distributional Assumptions:

   • Probability Distributions: Instead of single-point estimates, consider using probability distributions to capture uncertainty in your growth assumptions. This can include expected values and ranges that reflect potential variability.

5. Consistency with Other Assumptions:

   • CapEx and Working Capital: Ensure that your sales projections are consistent with other related assumptions in your DCF model, such as capital expenditures (CapEx) and working capital. High revenue growth should be matched with appropriate reinvestment levels.

6. Terminal Value:

   • Long-Term Growth Rate: Use a long-term growth rate that aligns with GDP growth, inflation, or population growth. This rate should be sustainable and not allow the company to outgrow the economy it operates in.

7. Sensitivity Analysis:

   • Tweaking Assumptions: Small changes in key assumptions like the perpetuity growth rate or the weighted average cost of capital (WACC) can significantly impact the valuation. Perform sensitivity analysis to understand the range of possible outcomes.

By following these steps, you can develop a thoughtful and detailed top-line forecast for your DCF model, even in the absence of broker reports.

Sources: DCF Myth 3.2: If you don't look, its not there!, DCF Modeling Course ~ Pre-training text.pdf, Help with Writing ER Reports for Beginners (Value Investing)