Interview Questions229

    Projecting Revenue and Operating Assumptions in a DCF

    How to build revenue projections, margin assumptions, and operating forecasts for the DCF model.

    |
    8 min read
    |
    2 interview questions
    |

    Introduction

    The projections are the engine of the DCF model. Every downstream calculation (free cash flow, terminal value, implied enterprise value) flows directly from the revenue and operating assumptions that the analyst builds in the first few columns of the model. A perfectly constructed discount rate and an elegant terminal value calculation are meaningless if the revenue projection is unrealistic.

    Revenue Projections: The Foundation

    Revenue is the single most impactful assumption in the DCF. Every other line item (COGS, operating expenses, capex, working capital) is typically modeled as a function of revenue, meaning errors in the revenue forecast compound throughout the entire model.

    Top-Down Revenue Forecasting

    A top-down approach starts with the total addressable market (TAM) and works down to the company's expected share:

    Revenue=TAM×Market Share×Average Selling PriceRevenue = TAM \times Market\ Share \times Average\ Selling\ Price
    Total Addressable Market (TAM)

    The total revenue opportunity available for a product or service if the company captured 100% of its target market. TAM is used in top-down revenue forecasting as the starting point before applying market share assumptions. TAM estimates come from industry research firms (Gartner, IDC, Frost & Sullivan), management presentations, and the analyst's own analysis. A critical nuance: TAM is only useful if the definition is realistic. A startup claiming a $500 billion TAM by defining its market as "all global enterprise software spending" is not providing useful information. The relevant TAM should be scoped to the specific segments and geographies where the company actually competes.

    This approach is useful for companies in large, well-defined markets where industry-level data is readily available. However, top-down projections tend to be less precise because the connection between the broad market and the specific company's revenue is indirect.

    Bottom-Up Revenue Forecasting

    A bottom-up approach builds revenue from the company's own operational drivers:

    • Units x Price: For product companies. Project unit volumes based on capacity, demand trends, and competitive positioning, then multiply by the expected selling price per unit.
    • Customers x ARPU: For subscription and recurring-revenue businesses. Project customer count (new adds minus churn) and average revenue per user (ARPU) separately.
    • Segment-by-segment: For diversified companies. Project each business segment or product line independently, reflecting different growth rates and competitive dynamics.

    Bottom-up projections are generally preferred by practitioners because they are more granular and more directly tied to the company's operational reality. An analyst who projects revenue as "8% growth" has made one opaque assumption. An analyst who projects revenue as "5% volume growth + 3% price increase" has made two transparent, independently defensible assumptions.

    ApproachBest ForStrengthsWeaknesses
    Top-down (TAM x share)Large, well-defined markets; early-stage companiesEasy to frame the opportunity; good for high-level sizingIndirect connection to company operations; assumes TAM data is accurate
    Bottom-up (units x price, customers x ARPU)Established companies with operational dataGranular, defensible, tied to real business driversRequires detailed operational data that may not be available

    In practice, many DCF models use both approaches as a cross-check. If the bottom-up projection implies 15% revenue growth but the top-down analysis suggests the overall market grows at only 5%, the company would need to gain significant market share, and the analyst should assess whether that is realistic given the competitive landscape.

    Sources for Revenue Assumptions

    • Historical performance: The most objective starting point. A company that has grown 8-12% annually for the past five years is unlikely to suddenly grow 25% without a specific catalyst.
    • Management guidance: Public companies provide revenue guidance in quarterly earnings calls and investor presentations. This is valuable but should be stress-tested (management tends to guide conservatively on revenue but optimistically on margins).
    • Consensus estimates: Sell-side analyst estimates for the next 2-3 years aggregate the views of analysts who follow the company closely. Beyond the consensus period, the analyst must build their own projections.
    • Industry data: Sector growth rates, competitive dynamics, regulatory tailwinds or headwinds, and macroeconomic assumptions provide context for the company-specific forecast.

    Operating Margin Assumptions

    Once revenue is projected, the analyst builds the cost structure to derive EBITDA (and eventually EBIT and unlevered free cash flow). The key margin assumptions:

    Gross Margin

    Projected based on the company's historical gross margin trajectory, adjusted for expected changes in product mix, input costs, pricing power, and scale effects. A company expanding into a higher-margin product category may see gross margins improve. One facing rising raw material costs may see compression.

    Operating Expenses (SG&A and R&D)

    Typically modeled as a percentage of revenue, with adjustments for:

    • Operating leverage: As revenue scales, fixed costs are spread over a larger base, improving margins. This is particularly pronounced in software and technology businesses with high fixed costs and low marginal costs.
    • Investment phase dynamics: A company investing heavily in sales and marketing to capture market share may have temporarily depressed margins that are expected to improve as the investment matures.
    • Management guidance on cost structure: Companies often provide forward guidance on headcount, facility costs, and R&D spending that can be used to project operating expenses.
    Operating Leverage

    The degree to which a company's operating income increases relative to revenue growth, driven by the proportion of fixed versus variable costs in the cost structure. A company with high operating leverage (high fixed costs, low variable costs) will see margins expand rapidly as revenue grows because incremental revenue drops disproportionately to the bottom line. SaaS companies are a classic example: the cost of serving one additional customer is minimal, so revenue growth translates almost directly into profit growth. Operating leverage is a key driver of margin expansion assumptions in DCF models.

    EBITDA Margin Trajectory

    The EBITDA margin trajectory over the projection period is one of the most scrutinized assumptions. Common patterns:

    • Stable margins: For mature businesses where the cost structure is well-established and competitive dynamics are stable
    • Expanding margins: For companies with operating leverage, growing into their cost base, or implementing efficiency programs
    • Compressing margins: For companies facing increased competition, rising input costs, or investing heavily in growth

    The terminal year margin should reflect the company's normalized, steady-state profitability, not a cyclical peak or trough. This is the margin that pairs with the terminal value calculation and drives a disproportionate share of the total DCF output.

    Capital Expenditure and Working Capital Assumptions

    Capital Expenditures (CapEx)

    CapEx is typically split into:

    • Maintenance CapEx: The investment required to sustain the current asset base. Often estimated as a percentage of revenue or as a function of D&A (maintenance CapEx roughly equals depreciation for a company maintaining its asset base).
    • Growth CapEx: Incremental investment to expand capacity, enter new markets, or build new capabilities. Growth CapEx is typically higher in the early years of the projection and declines as the company matures.

    Changes in Net Working Capital

    Net working capital (current operating assets minus current operating liabilities) consumes cash as the business grows. Projecting working capital changes requires assumptions about:

    • Days sales outstanding (DSO): How quickly customers pay. Higher DSO means more cash tied up in receivables.
    • Days inventory outstanding (DIO): How long inventory sits before being sold.
    • Days payable outstanding (DPO): How long the company takes to pay suppliers.

    For most companies, working capital as a percentage of revenue is relatively stable, so projecting it as a consistent percentage of incremental revenue is a reasonable approach. Companies with changing business models or seasonal patterns may require more detailed working capital modeling.

    Interview Questions

    2
    Interview Question #1Medium

    What is the difference between top-down and bottom-up revenue projections in a DCF, and when would you use each?

    Top-down approach: Start with the Total Addressable Market (TAM), then estimate the company's market share and average selling price.

    Revenue=TAM×Market Share×Average Selling PriceRevenue = TAM \times Market\ Share \times Average\ Selling\ Price

    Best for: large, well-defined markets and early-stage companies where company-specific data is limited. Weakness: the indirect connection between broad market size and the specific company's revenue makes it less precise.

    Bottom-up approach: Build revenue from company-specific operational drivers.

    - Units x Price: Project volumes (capacity, demand, competitive position) and price per unit - Customers x ARPU: Project customer count (new adds minus churn) times average revenue per user; preferred for subscription/recurring revenue businesses - Segment-by-segment: Project each division independently

    Best for: established companies with observable operational metrics. More credible because each assumption is independently defensible.

    Best practice: use both as a cross-check. If bottom-up implies 15% growth but top-down shows the total market growing only 5%, the company would need significant market share gains, which the analyst must assess for feasibility.

    Deal context affects methodology: Sell-side uses management projections (most optimistic defensible scenario). Buy-side uses independent acquirer projections (more conservative). Pitchbooks use consensus analyst estimates before the mandate is won.

    Interview Question #2Medium

    Why is it dangerous to extrapolate historical revenue growth rates in a DCF without understanding the underlying drivers?

    Historical extrapolation assumes the future will look like the past, which fails when the underlying drivers are changing.

    Specific dangers:

    1. Mean reversion. A company growing at 25% annually will eventually slow as the market saturates, competitive advantages erode, or the law of large numbers takes effect. Projecting 25% growth for 10 years produces absurd results.

    2. One-time drivers. Past growth may include non-repeatable factors: a major contract win, a pricing increase that cannot be repeated, a competitor's exit, or a regulatory tailwind that has now passed.

    3. Margin expansion trap. Projecting aggressive margin expansion (e.g., EBITDA margins from 20% to 30%) without identifying specific drivers (operating leverage, cost programs, pricing power, mix shifts) inflates the DCF and fails scrutiny.

    4. Terminal year distortion. Since the terminal year drives 60-80% of DCF value, even small errors in growth rate assumptions compound into large valuation errors.

    What interviewers want to hear: "I would not simply extrapolate historical growth. I would decompose revenue into its drivers (volume x price, or customers x ARPU), research each driver independently, and build assumptions that can be explained and defended."

    Explore More

    Understanding Accretion/Dilution Analysis: Step-by-Step Guide

    Master accretion/dilution analysis for M&A transactions. Learn how to calculate EPS impact, evaluate deal structures, and determine whether acquisitions create or destroy shareholder value.

    October 21, 2025

    Investment Banking Salary & Bonus: Analyst to MD Compensation

    Full compensation breakdown from analyst to managing director. Base salaries, bonus structures, performance buckets, and how pay differs across bulge brackets, boutiques, and middle market.

    February 12, 2026

    Investment Banking from a Military Background: Transition Guide

    Navigate the transition from military service to investment banking. Learn how to leverage your military experience, explore veteran-specific programs at Goldman Sachs and JP Morgan, understand recruiting pathways, and position yourself for success in finance.

    November 24, 2025

    Ready to Transform Your Interview Prep?

    Join 3,000+ students preparing smarter

    Join 3,000+ students who have downloaded this resource