Building Equity Valuation Models

When To Use

Estimating intrinsic or fair value of a public or private equity security
Building or auditing a DCF, comparable company analysis (comps), or precedent transaction analysis
Preparing valuation support for investment memos, pitch books, or fairness opinions
Running sensitivity/scenario analysis around key value drivers
Cross-checking a single-method valuation with a multi-method "football field" range

Company financials: Most recent 10-K/10-Q or annual report — revenue, EBITDA, EBIT, net income, capex, D&A, working capital line items (minimum 3 years historical)
Forward estimates: Consensus sell-side estimates or management guidance for revenue and earnings (2–3 years forward)
Capital structure: Total debt, cash & equivalents, diluted share count (including options/RSUs via treasury stock method), preferred equity, minority interests
Comparable universe: 5–10 peer companies with sector, size, growth, and margin similarity; confirm tickers and fiscal year ends
Precedent transactions: Relevant M&A deals in the sector over the trailing 3–5 years with disclosed deal multiples
Discount rate inputs: Risk-free rate [VERIFY current yield on 10-year sovereign], equity risk premium, levered/unlevered beta source, cost of debt, target capital structure for WACC
Terminal value assumptions: Long-term growth rate or exit multiple, and rationale for each

Project unlevered free cash flow (UFCF) for 5–10 years: Revenue → EBIT → NOPAT → add back D&A → subtract capex and changes in net working capital
Calculate WACC: weight cost of equity (CAPM) and after-tax cost of debt by target capital structure [VERIFY tax rate assumptions per jurisdiction]
Compute terminal value using both the perpetuity growth method (Gordon Growth) and the exit multiple method; present both
Discount projected UFCF and terminal value to present; sum to get enterprise value
Bridge to equity value: Enterprise Value − Net Debt − Minority Interests − Preferred + Associates/JV value → Equity Value ÷ Diluted Shares = Implied Price Per Share

Select peer set; document selection criteria (sector, geography, size, growth profile)
Pull trailing and forward multiples: EV/Revenue, EV/EBITDA, EV/EBIT, P/E, P/FCF
Calculate mean, median, and interquartile range; flag and discuss outliers
Apply selected multiple range to subject company's corresponding metric to derive implied valuation range
Adjust for company-specific premiums/discounts (growth differential, margin profile, risk factors)

Identify 8–15 comparable transactions; document deal date, buyer/seller, deal value, and strategic rationale
Extract transaction multiples: EV/Revenue, EV/EBITDA at announcement and at LTM pre-deal
Note control premiums paid (deal price vs. unaffected share price)
Apply relevant multiple range to subject company metrics; clearly separate "as-is" value from "with-control-premium" value
Flag stale transactions (>3 years old) and note market-environment differences [VERIFY macro conditions at deal close]

DCF sensitivities: Build two-way data tables on (a) WACC vs. terminal growth rate and (b) WACC vs. exit multiple — display implied share price ranges
Comps sensitivities: Show valuation at 25th, 50th, and 75th percentile multiples
Scenario overlay: Define base, bull, and bear cases with explicit assumption changes (revenue growth, margin expansion/compression, multiple re-rating); summarize each scenario's implied value

Present a "football field" chart or table showing the implied price range from each methodology side by side
Identify the central tendency across methods and highlight where methodologies converge or diverge
State a recommended fair value range (not a point estimate) with confidence weighting by methodology

Deliver a structured valuation model containing:

Assumptions page: Every key input listed, sourced, and dated; [VERIFY] tags on any assumed or estimated inputs
DCF tab: Full UFCF build, WACC calculation, terminal value (both methods), bridge to equity value
Comps tab: Peer summary table with multiples, statistical summary, implied valuation
Precedents tab: Transaction summary, multiple ranges, implied valuation
Sensitivity tables: Two-way tables for DCF; percentile tables for comps/precedents
Summary page: Football field visualization, fair value range, key risks to the valuation thesis
All figures clearly labeled with units, currency, and fiscal period

Verify UFCF build ties back to source financials — check that Revenue → EBIT → NOPAT → UFCF reconciles
Confirm WACC components are internally consistent (beta source matches peer set; debt cost matches credit profile)
Ensure terminal value does not exceed 70–75% of total enterprise value; if it does, extend the explicit forecast period or revisit growth assumptions
Validate that the equity bridge accounts for all claims ahead of common equity (convertibles, preferred, minority interests)
Cross-check implied valuation multiples from DCF against comps range — significant divergence requires explanation
Confirm diluted share count uses treasury stock method and reflects latest filing [VERIFY share count date]
Review all [VERIFY] tags before finalizing; no unresolved tags in the delivered output