Creating LBO/Operating Models with Limited Info - How to Improve

To tackle your questions effectively, here's a breakdown based on the most helpful WSO content:

1. Typical Examples of 'Limited Information' in LBO/Operating Models:

   • Missing detailed revenue breakdowns (e.g., SKU-level data or customer segmentation).
   • Lack of historical financials beyond a few years or incomplete statements (e.g., no cash flow statement).
   • Sparse operational metrics like churn rates, customer acquisition costs, or unit economics.
   • Limited guidance on future growth, capex plans, or margin expansion.
   • Inconsistent or unavailable QoE (Quality of Earnings) reports.

   In such cases, you'll often rely on industry benchmarks, management interviews, and public filings of comparable companies to fill gaps.

2. Using Industry Comparables and Other Resources:

   • Comparable Companies: Spread comps to benchmark leverage, margins, growth rates, and capex intensity. Use public filings, equity research, or industry reports.
   • Historical Trends: Extrapolate missing data using historical averages or trends (e.g., revenue CAGR, margin stability).
   • Market Data: Tie revenue assumptions to publicly available industry stats or macroeconomic indicators.
   • Assumption Validation: Cross-check assumptions with management or advisors to ensure credibility.
   • Scenario Analysis: Build multiple cases (base, upside, downside) to account for uncertainty in assumptions.

3. Statements You’re Expected to Build:

   • Often, you'll start with an income statement and balance sheet and be expected to derive the cash flow statement (CFS). This involves:
     • Estimating working capital changes.
     • Using depreciation and capex assumptions to reconcile cash flows.
   • In extreme cases, you might only have a balance sheet or income statement. For example:
     • If given only a balance sheet, you might need to infer profitability metrics or revenue growth based on industry norms.
     • If given only an income statement, you’d estimate balance sheet items like working capital or debt levels using ratios from comps.

4. Building a Three-Statement Model with an Investor Mindset:

   • Focus on Cash Flow: Investors prioritize cash generation. Pay close attention to working capital efficiency, capex requirements, and free cash flow conversion.
   • Stress Test Key Drivers: Beyond basic stress tests, focus on:
     • Sensitivity to macro factors (e.g., interest rate hikes, commodity price swings).
     • Operational risks (e.g., customer concentration, supply chain disruptions).
   • Identify Value Creation Levers:
     • Margin expansion opportunities (e.g., cost-cutting, pricing power).
     • Growth drivers (e.g., market share gains, new product launches).
     • Capital structure optimization (e.g., refinancing opportunities).
   • Sector-Specific Nuances: Tailor your approach to the industry. For example:
     • In software, focus on ARR growth, churn, and LTV/CAC ratios.
     • In manufacturing, analyze fixed vs. variable cost structures and operating leverage.

Tips to Practice: - Use case studies or past deals to simulate scenarios with limited data. - Build models from scratch using only partial information, then validate your assumptions with actuals or industry data. - Leverage resources like WSO’s financial modeling templates and guides to refine your approach.

For further practice, consider exploring WSO’s financial modeling courses or templates, which provide structured frameworks for LBOs and operating models.

Sources: What're some examples of proprietary information you guys keep locked away at your firm? Competitive Intel etc., Sources and Uses statement - private LBO model, https://www.wallstreetoasis.com/forum/investment-banking/modelling-has-to-be-the-biggest-misnomer-in-this-industry?customgpt=1, How to analyse business models?, Creating own LBO assumptions