Mastering M&A Valuation: How Wall Street Builds DCF, LBO, and Comps Models

In North America’s competitive investment banking, private equity, and corporate development landscape, valuation is both an art and a science. When executing a Mergers & Acquisitions (M&A) transaction, dealmakers rely on three core valuation methodologies to establish a target company’s intrinsic and relative worth: Comparable Company Analysis (Comps), Discounted Cash Flow (DCF) Analysis, and Leveraged Buyout (LBO) Analysis.

Understanding how to construct these models is essential for financial analysts looking to pitch deals, negotiate purchase prices, and deliver strategic advisory.

1. Comparable Company Analysis (Comps)

The Relative Valuation Benchmark

Comparable Company Analysis operates on the principle that similar companies should trade at similar valuation multiples. It provides a quick market-based sanity check on what public investors are willing to pay for peer businesses.

How to Build a Comps Model:

1. Select the Peer Group: Identify publicly traded companies in the same industry, geography, size bracket, and growth profile. For example, if valuing a mid-cap SaaS firm, select peers with similar recurring revenue models and growth rates.

2. Gather Financial Data: Extract latest-twelve-months (LTM) and estimated next-twelve-months (NTM) financial figures from SEC filings (10-K, 10-Q) and equity research reports.

3. Calculate Enterprise Value (EV) & Equity Value:

   

   
   

4. Determine Valuation Multiples: Compute standard valuation ratios such as EV/Revenue, EV/EBITDA, and P/E (Price-to-Earnings).

5. Apply Multiples to the Target: Multiply the target company's operational metric (e.g., EBITDA) by the median or mean multiple of the peer group to derive an implied valuation range.

2. Discounted Cash Flow (DCF) Model

The Intrinsic Valuation Approach

The DCF model determines a company's present value based on its projected future free cash flows (FCF), discounted back to today's dollars using the company's Weighted Average Cost of Capital (WACC). It is considered the most theoretically sound valuation method in M&A.

Step-by-Step Construction in Excel:

1. Forecast Free Cash Flows (5 to 10 Years): Project the target's operating income (EBIT), adjust for taxes, add back Depreciation & Amortization (D&A), subtract Capital Expenditures (CapEx), and adjust for changes in Net Working Capital to arrive at Unlevered Free Cash Flow (UFCF).

2. Calculate WACC (Discount Rate): Determine the cost of equity (using the Capital Asset Pricing Model - CAPM) and the after-tax cost of debt, weighted by their respective capital structure proportions:

   

   
   

3. Determine the Terminal Value (TV): Because cash flows cannot be projected infinitely, estimate the value of the business beyond the forecast period using two primary methods:

   • Gordon Growth Method: 

     (assuming a perpetual growth rate $g$, typically matching long-term GDP growth around 2%–3%).

   • Exit Multiple Method:

     (based on current Comps data).

4. Discount to Present Value: Discount all projected cash flows and the terminal value back to Year 0 using WACC. Sum them up to arrive at the Implied Enterprise Value.

3. Leveraged Buyout (LBO) Model

The Private Equity Floor Valuation

An LBO model evaluates an acquisition financed largely through debt (typically 60%–80% leverage), with the remainder funded by private equity sponsor equity. The core objective is to calculate the Internal Rate of Return (IRR) and Return on Investment (MoIC - Multiple on Invested Capital) over a 3-to-5-year holding period.

Key Components of an LBO Model:

1. Sources & Uses of Funds:

   • Uses: Purchase price of equity, refinancing existing debt, and transaction fees.

   • Sources: Sponsor equity contribution, new term loans, subordinated notes, and rollover equity from management.

2. Operating & Debt Schedule: Build an integrated 3-statement model where excess operating cash flows are strictly swept toward paying down debt principal each year (Debt Paydown / Cash Sweep).

3. Exit Assumptions: Project the exit valuation at Year 5, typically assuming an exit multiple equal to or slightly lower than the entry multiple, minus remaining net debt to arrive at the ending equity value.

4. Return Metrics Analysis: Calculate IRR and MoIC. Private equity firms in North America typically target a minimum IRR of 20% to 25% for platform buyouts. In M&A negotiations, the LBO model establishes the "floor valuation" (the maximum price a financial buyer can pay while still meeting hurdle rates).

Summary Comparison for M&A Professionals

By combining these three methodologies into a comprehensive pitchbook or valuation model, financial analysts and corporate development teams in North America can successfully navigate complex M&A negotiations and ensure sound capital allocation.