Corporate Valuation Model Walkthrough: Build a 3-Statement Model in 2026

Key Takeaways

• Standard structure: 3-statement integrated model + DCF + trading comps + precedent transactions + sensitivity analysis + football field
• Build the 3-statement model first; valuation overlays depend on accurate operating model
• DCF requires explicit projection period (typically 5-10 years) plus terminal value (Gordon growth or exit multiple)
• WACC calculation: cost of equity via CAPM plus cost of debt times tax-adjusted weights
• Trading comps and precedent transactions require careful peer group selection and multiple selection (EV/EBITDA, EV/revenue, P/E)
• Football field chart presents the valuation range visually with each methodology contributing one or two bars

What a corporate valuation model is and what it produces

A corporate valuation model is a structured Excel (or Google Sheets, increasingly Python) model that produces a defensible enterprise value range using multiple valuation methodologies. The model integrates operating projections with valuation calculations.

The output is not a single price but a range. The range comes from combining different methodologies, each of which produces its own value estimate. The triangulation across methodologies produces a more defensible value than any single methodology alone.

Standard model structure:

1. Historical financial inputs (5 years of audited or reviewed financials) 2. Operating projections (5 to 10 years of forward income statement, balance sheet, cash flow) 3. DCF valuation (free cash flow projection, WACC, terminal value, enterprise value) 4. Trading comparables (peer multiples applied to target metrics) 5. Precedent transactions (M&A multiples applied to target metrics) 6. Sensitivity analysis (WACC sensitivity, terminal multiple sensitivity, key driver sensitivity) 7. Football field chart (visual presentation of value range from each methodology)

Who builds these models:

Investment banks build them for sell-side processes and fairness opinions. Private equity firms build them for acquisition underwriting. Corporate development teams build them for buy-side analysis. Independent valuation firms build them for 409A and ESOP valuations. M&A advisors build them for middle-market clients.

Time to build:

A clean first-time model takes 40 to 100 hours depending on business complexity. Subsequent updates take 5 to 20 hours. The first build is dominated by historical data entry, accounting tie-out, and structural design. Updates focus on projection assumptions and the valuation overlays.

For the broader treatment of valuation methodology, see business valuation methods 2026.

Excel versus Python valuation models

Excel remains the dominant valuation modeling platform because of formula transparency and review-ability. Python-based models (using pandas, numpy, and visualization libraries like Plotly) are growing in PE and corporate development for repeatable analyses across portfolios. The methodology is identical; the platform choice is operational preference.

When the model is unnecessary

For deals below 5 million enterprise value, full integrated models often add cost without producing better decisions. A spreadsheet with normalized EBITDA, applied multiple range, and working capital adjustment produces a defensible value range in 4 to 8 hours. Full integrated models earn their cost on deals above 10 million where capital structure, growth modeling, and multiple methodologies materially affect the range.

Step 1: Building the 3-statement integrated model

The 3-statement model is the foundation. Every valuation methodology depends on accurate operating projections.

The three statements:

Income statement: revenue, COGS, gross profit, operating expenses, EBITDA, D&A, EBIT, interest, taxes, net income. Built monthly for the projection period (5 to 10 years), then aggregated to annual.

Balance sheet: current assets (cash, AR, inventory, prepaids), non-current assets (PP&E, intangibles, goodwill), current liabilities (AP, accrued expenses, short-term debt), non-current liabilities (long-term debt, deferred tax), equity (common stock, retained earnings). Built quarterly or annually for the projection period.

Cash flow statement: operating cash flow (net income + D&A + working capital changes), investing cash flow (capex + acquisitions), financing cash flow (debt issuance/repayment, equity issuance/buyback, dividends). Built monthly for the projection period.

The statements must tie together through accounting identities:

• Net income from income statement → flows to retained earnings on balance sheet → flows to financing activities (dividends) on cash flow statement
• D&A from income statement → adds back on cash flow statement → reduces PP&E on balance sheet
• Working capital changes from balance sheet → flow through operating cash flow
• Capex from cash flow statement → adds to PP&E on balance sheet
• Cash from cash flow statement → flows to cash balance on balance sheet

Structural design principles:

Separate inputs from calculations. Use a dedicated inputs tab with all assumptions; calculations reference inputs but never contain hardcoded numbers.

Use consistent color coding. Industry standard: blue for inputs, black for formulas, green for cross-sheet references. Makes review faster and reduces errors.

Build from the bottom up for revenue: by customer, by product line, by geography. Avoid top-line growth rate assumptions that have no underlying driver.

Build from the top down for expenses: by category (compensation, facilities, marketing, etc.) with headcount or revenue-driven scaling.

The 3-statement build typically takes 20 to 40 hours of the total model build. The historical input and tie-out is the most time-consuming.

Common 3-statement model errors

Five common errors: (1) balance sheet does not balance (often a sign of double-counting in cash flow), (2) interest expense calculation does not iterate with debt balance (circular reference issue requiring iterative calculation enabled), (3) working capital changes use ending balance instead of average (overstates cash flow), (4) depreciation calculation does not align with the capex schedule, and (5) tax calculation does not differentiate book vs cash taxes.

Projection period length

DCF requires explicit projection period long enough for the business to reach steady state. Mature businesses: 5 to 7 years explicit + terminal value. High-growth businesses: 8 to 10 years explicit + terminal value. The terminal value typically represents 50 to 75 percent of total enterprise value, so the explicit period is critical for credible DCF.

Step 2: DCF valuation

Discounted cash flow valuation discounts projected free cash flows to present value at the weighted average cost of capital. The DCF produces an intrinsic value estimate independent of comparable company or transaction multiples.

Free cash flow to firm (FCFF) calculation:

Start with EBIT (operating income) – Less: cash taxes on EBIT (EBIT * effective tax rate) – Plus: D&A (non-cash expense added back) – Less: capex (cash investment in PP&E) – Less: increase in net working capital = Free cash flow to firm

FCFF represents cash available to all capital providers (debt and equity) before financing decisions. This is the standard cash flow measure for enterprise value DCF.

WACC calculation:

WACC = (E/V * Re) + (D/V * Rd * (1 – T))

Where:

• E = market value of equity
• D = market value of debt
• V = E + D
• Re = cost of equity (typically via CAPM)
• Rd = cost of debt (typically pre-tax yield on company debt)
• T = effective tax rate

Cost of equity via CAPM:

Re = Rf + Beta * (Rm – Rf)

Where:

• Rf = risk-free rate (typically 10-year Treasury yield, around 4.2 percent in 2026)
• Beta = systematic risk (from comparable company average levered beta, then unlevered and re-levered to target capital structure)
• (Rm – Rf) = equity risk premium (typically 5 to 7 percent)

For middle-market private companies, add a small company premium (1 to 5 percent) to account for size and liquidity differences from large public companies. On valuation specifically, our deeper look at Trailing Twelve Months: The Metric That Matters Most covers the methodology buyers actually use.

Terminal value calculation:

Gordon growth method: TV = FCFF(t+1) / (WACC – g)

Where g is the perpetual growth rate (typically 2 to 3 percent for mature businesses).

Exit multiple method: TV = EBITDA(t) * Exit Multiple

Use comparable transaction multiples to anchor the exit multiple. Both methods should produce similar terminal values; large divergence suggests assumption issues.

Enterprise value calculation:

EV = Sum of PV(FCFF) + PV(Terminal Value)

Discount each year’s FCFF and the terminal value at the WACC. Sum produces enterprise value.

Equity value calculation:

Equity value = EV – net debt = EV – debt + cash

For a deeper treatment of the DCF methodology, see DCF valuation business sale 2026 and discounted cash flow business valuation.

Mid-year discounting convention

Standard DCF assumes cash flows are received continuously throughout the year. Mid-year convention discounts by year + 0.5 instead of year + 1, which more accurately reflects the timing of cash receipt. The convention reduces enterprise value by roughly 2 to 5 percent versus end-of-year discounting. Most professional models use mid-year convention.

Common WACC errors

Common errors: using book values instead of market values for E and D weights; failing to unlever and re-lever beta; using effective tax rate for D&A tax shield instead of marginal; not adjusting for small company premium on private targets; using outdated risk-free rate. Each error can move WACC by 50 to 200 basis points and enterprise value by 5 to 25 percent.

Step 3: Trading comparables

Trading comparables apply multiples from publicly traded peer companies to the target’s metrics. The methodology produces a market-based value estimate that reflects current investor sentiment for similar businesses.

Process:

1. Identify peer group. 5 to 12 public companies in the same industry, with similar business model, size range, and geographic focus. Sources: SIC code searches, Bloomberg industry filters, S&P Capital IQ, FactSet, Mergermarket.

2. Pull peer financials. Trailing 12 months (LTM) and forward 12 months (FY+1) for revenue, gross profit, EBITDA, EBIT, net income. From most recent 10-K and 10-Q filings.

3. Calculate peer multiples. Enterprise value (market cap + debt – cash) divided by LTM and forward EBITDA, revenue, and other relevant metrics. Calculate the multiple for each peer.

4. Calculate summary statistics. Median, mean, 25th percentile, 75th percentile, high, low. Exclude outliers (peers whose multiples are 2x or 0.5x the median).

5. Apply multiples to target. Multiply the peer median or mean multiple by the target’s metric. Produces an enterprise value estimate from each multiple type.

Which multiples to use:

EV/EBITDA: standard for asset-heavy businesses and most middle-market deals. Eliminates capital structure and D&A differences across peers.

EV/Revenue: useful for high-growth businesses with negative or near-zero EBITDA. Less reliable for mature businesses with widely varying margin structures.

P/E: useful for mature businesses with similar capital structures. Sensitive to differences in tax rates and interest expense.

EV/EBIT: alternative to EV/EBITDA for capital-intensive businesses where D&A is meaningful.

For middle-market deals, EV/EBITDA on trailing 12 months and forward 12 months is the standard pair. Use both LTM and forward to account for projected growth.

Peer group selection is the most subjective part of trading comps. Honest peer selection (including some that produce lower multiples than the target prefers) increases credibility of the comp analysis.

Public vs private multiple adjustments

Publicly traded peers trade with liquidity that private targets do not have. Public multiples should typically be discounted by 20 to 35 percent to derive private company values (lack of marketability discount). This adjustment is standard in 409A valuations and ESOP valuations. M&A transactions often produce smaller adjustments because the buyer can monetize through subsequent sale or recap.

When trading comps fail

Trading comps fail when there are no truly comparable public companies. Highly specialized businesses, regional service businesses with no public equivalents, or businesses with unique business models often lack comps. In these cases, lean more heavily on DCF and precedent transactions for the valuation triangulation.

Step 4: Precedent transactions

Precedent transactions apply multiples paid in historical M&A deals to the target’s metrics. The methodology produces a transaction-market value estimate that reflects what acquirers have actually paid for similar businesses.

Process:

1. Identify transactions. 10 to 25 completed M&A transactions in the past 3 to 5 years involving comparable target businesses. Sources: SDC Platinum, S&P Capital IQ, FactSet Mergermarket, Pitchbook, Capital IQ.

2. Filter for relevance. Same industry segment, similar size range, similar buyer type (strategic vs financial), and recent enough to reflect current market conditions. Older transactions may need to be discounted or excluded.

3. Pull transaction multiples. Enterprise value divided by target’s trailing EBITDA, revenue, and other relevant metrics at the time of transaction.

4. Calculate summary statistics. Median, mean, 25th percentile, 75th percentile. Note any outliers and understand why (synergistic deals often pay higher multiples than financial deals).

5. Apply multiples to target. Multiply the precedent median or mean by the target’s metric.

Key adjustments:

Strategic vs financial buyer: strategic buyers often pay 20 to 35 percent premium over financial buyers due to synergy capture. Separate analysis by buyer type if the sample supports it.

Market conditions adjustment: M&A multiples vary with overall market conditions. Adjust historical multiples to current market conditions using a market multiple index or roll-forward analysis.

Deal structure adjustment: cash deals price differently from stock deals. Earnout-heavy deals have different headline multiples than upfront cash deals.

For more granular treatment of comparables methodology, see relative valuation comparable companies business 2026.

Sample size considerations

Statistical robustness requires at least 10 to 15 truly comparable transactions. Below 10 transactions, individual transaction characteristics dominate; above 25, peer relevance often declines. For specialty industries with few transactions, expand the time window (5 to 7 years instead of 3) or broaden geographic scope before relaxing comparability criteria.

Transparency on outliers

Show every transaction in the analysis with the multiple paid. Identify outliers explicitly and explain why they are excluded from summary statistics. Hidden cherry-picking destroys credibility; transparent outlier treatment increases it.

Step 5: Sensitivity analysis

Sensitivity analysis tests how the valuation responds to changes in key assumptions. The output is typically a 2-dimensional sensitivity table showing enterprise value at different combinations of two key variables.

Standard sensitivity tables:

WACC sensitivity: vary WACC from -200 bps to +200 bps in 50 bp increments. Vary terminal growth rate from 0 percent to 4 percent in 50 bp increments. Output: enterprise value matrix.

Exit multiple sensitivity: vary terminal exit multiple from -2 turns to +2 turns. Vary projection period revenue growth from -3 to +3 percentage points. Output: enterprise value matrix.

Operating sensitivity: vary terminal EBITDA margin from -300 bps to +300 bps. Vary terminal revenue from -10 percent to +10 percent of base case. Output: enterprise value matrix.

Capital structure sensitivity: vary leverage ratio from 0 to 60 percent debt. Vary cost of debt from -100 bps to +200 bps. Output: equity value matrix.

Monte Carlo simulation:

For more sophisticated analysis, Monte Carlo simulation runs the model 10,000+ times with key inputs varying randomly within defined distributions. Output: probability distribution of enterprise value. Useful for understanding tail risk and presenting valuation as a range with associated probabilities.

Most sell-side and buy-side models stop at 2-dimensional sensitivity tables. Monte Carlo is more common in fairness opinions and complex deal structures.

Choosing which variables to test

Test the variables that matter most to the valuation: WACC, terminal growth, terminal multiple, revenue growth rate, and EBITDA margin. Skip variables that move valuation by less than 5 percent across plausible ranges. The goal is to inform decision-making, not produce exhaustive analysis.

Communicating sensitivity

Present sensitivity as a 2×2 grid (base case, optimistic, pessimistic, downside) with the key sensitivities flagged. A single page that captures 80 percent of the sensitivity analysis is more useful than 20 pages of full sensitivity tables. Decision-makers want to understand the range, not study every variable.

Step 6: Football field chart

The football field chart presents the valuation range visually with one or two bars per methodology. The output is a single chart that captures the full triangulation analysis.

Standard football field structure:

X-axis: enterprise value (or equity value). Y-axis: methodology (DCF base case, DCF sensitivity range, trading comps low to high quartile, precedent transactions low to high quartile, etc.).

Each methodology produces a bar showing the valuation range. The chart visually communicates whether the methodologies converge on a similar range or diverge.

Typical methodology bars:

1. DCF (WACC sensitivity): bar from low WACC to high WACC range 2. DCF (terminal growth sensitivity): bar from low growth to high growth range 3. Trading comps (EV/EBITDA): bar from 25th to 75th percentile multiple range applied to target EBITDA 4. Trading comps (EV/Revenue): bar from 25th to 75th percentile multiple range applied to target revenue 5. Precedent transactions (EV/EBITDA): bar from 25th to 75th percentile multiple range from comparable M&A deals 6. LBO analysis (returns sensitivity): bar from 20 percent IRR to 30 percent IRR target

Overall valuation range: the convergence of the methodologies. Often presented as a shaded box showing the consensus range across the methodologies.

Football field interpretation:

If the methodologies converge tightly: the valuation is well-supported across approaches. Confidence in the range is high.

If the methodologies diverge widely: the valuation is more uncertain. Understand what is driving the divergence (different growth assumptions in DCF vs comps, peer group selection, terminal value sensitivity) and present the divergence explicitly.

The football field is typically the first chart in a board presentation or fairness opinion. It captures the valuation analysis on one slide.

Excluding LBO analysis

LBO analysis is included in football fields when the universe of likely buyers includes private equity. For strategic-only auctions, LBO analysis is sometimes excluded because financial buyer pricing is not relevant. Include LBO analysis if PE buyers are likely; exclude if not.

Premium analysis for control transactions

For control transactions (acquisitions of 100 percent of equity), add a control premium of 20 to 35 percent over standalone trading comp value. The premium reflects synergies, governance changes, and other control-related value not reflected in minority-stake trading multiples.

Common model errors and how to catch them

Models contain errors. Professional modelers build review steps to catch errors before the model is presented externally.

Common error categories:

Balance sheet does not balance. Most common error indicator. Run a balance check (total assets minus total liabilities and equity) on every iteration. Should equal zero exactly.

Double counting in cash flow. Working capital changes calculated incorrectly (using ending balance instead of period change), or D&A added back twice. Reconcile operating cash flow components to balance sheet movements.

Circular reference errors. Interest expense depends on debt, which depends on cash flow, which depends on interest. Enable iterative calculations or restructure to break the circularity.

Formula extension errors. A formula that copied incorrectly across rows or columns. Spot-check formulas in the middle of long ranges, not just the first and last cells.

Hard-coded numbers in calculation cells. Numbers should live in inputs, not in formulas. Audit calculation cells for hardcoded values.

Unit consistency errors. Mixing thousands and millions, or percentages and decimals. Establish unit conventions at the start and label cells consistently.

Wrong sign on cash flows. Capex should reduce cash, depreciation should reduce earnings but not cash, dividends should reduce equity. Verify direction of every cash flow item.

Review process:

1. Self-review: walk through model 24 hours after building. Errors are easier to see after time away.

2. Independent review: another modeler walks through the model with the original modeler explaining structure. Forces the original to articulate assumptions.

3. Numerical reasonableness check: do the outputs make sense relative to public comps, observed transactions, and prior management presentations? Anomalies signal errors.

4. Sensitivity testing: run extreme cases. Setting growth to zero, doubling WACC, removing terminal value. Outputs should behave intuitively.

The best models go through 3 to 5 review iterations before external presentation.

Model audit firms

For high-stakes models (fairness opinions, public company deals, regulatory filings), independent model audit firms (KPMG model assurance, EY model review, Operis, F1F9) review the model for structural integrity, formula accuracy, and computational consistency. Audit cost typically 25,000 to 150,000 depending on model complexity. Worth the investment when model errors carry material financial or legal consequence.

Documentation standards

Document key assumptions, methodology choices, and data sources directly in the model. A reviewer should be able to understand any cell by tracing inputs and reading documentation comments. Models without documentation are harder to review, harder to update, and more likely to contain undetected errors.

Frequently Asked Questions

What is a corporate valuation model?

A corporate valuation model is an integrated financial model that produces a defensible enterprise value range using multiple methodologies: 3-statement projections, discounted cash flow (DCF), trading comparables, and precedent transactions. The output is a valuation range presented as a football field chart, not a single price.

How long does it take to build a corporate valuation model?

A clean first-time integrated model takes 40 to 100 hours depending on business complexity. Subsequent updates take 5 to 20 hours. The first build is dominated by historical data entry and tie-out; updates focus on projection assumptions and valuation overlays.

What is the standard structure of a corporate valuation model?

Six layers: 3-statement integrated model (income statement, balance sheet, cash flow), DCF valuation, trading comparables, precedent transactions, sensitivity analysis, and football field chart. Optional: LBO analysis if PE buyers are likely.

What is WACC and how is it calculated?

WACC (Weighted Average Cost of Capital) is the discount rate used in DCF. Formula: WACC = (E/V * Re) + (D/V * Rd * (1 – T)). Cost of equity Re via CAPM: Rf + Beta * (Rm – Rf). For middle-market private companies, add a small company premium of 1 to 5 percent.

Should I use the Gordon growth or exit multiple method for terminal value?

Both. They should produce similar terminal values when properly calibrated. Large divergence between methods signals assumption issues that need investigation. Most professional models present both methods and use the average or weighted blend.

How many trading comparables should I use?

5 to 12 truly comparable public companies. Fewer than 5 produces unreliable summary statistics; more than 12 typically dilutes comparability. Calculate median, mean, 25th and 75th percentiles, then apply the range to target metrics.

How many precedent transactions should I use?

10 to 25 completed M&A transactions in the past 3 to 5 years. Filter for industry, size range, and buyer type. For specialty industries with few transactions, expand the time window to 5 to 7 years before relaxing comparability criteria.

What is a football field chart?

A football field chart presents the valuation range visually with one or two bars per methodology. X-axis is enterprise value; Y-axis is methodology (DCF, trading comps, precedent transactions, LBO). The chart shows where methodologies converge or diverge.

What are common errors in corporate valuation models?

Balance sheet does not balance, double counting in cash flow, circular reference handling errors, formula extension errors, hardcoded numbers in calculation cells, unit consistency errors (thousands vs millions), and wrong signs on cash flows. Build review steps to catch errors before external presentation.

Should I use Excel or Python for a valuation model?

Excel remains dominant because of formula transparency and review-ability. Python-based models (using pandas, numpy, Plotly) are growing in PE and corporate development for repeatable portfolio analyses. Methodology is identical; platform choice is operational preference.