Comparable Company Precedent Transaction Valuation Calculator

Purpose and model boundary

This model applies a selected statistic from user-entered trading-comparable or precedent-transaction observations to a target operating metric, then bridges enterprise and equity value to implied value per diluted share. It performs relative-valuation arithmetic. It does not select comparables, retrieve market data, appraise a company, or provide an investment recommendation or fairness opinion.

Inputs and units

Every observation and target amount must use the same currency scale, period convention, and numerator and denominator definitions. The observation route is trading comparable companies or precedent transactions. The valuation metric is EV / Revenue, EV / EBITDA, or P / E. The selection statistic is mean, median, or a user-selected inclusive percentile.

The repeating grid has capacity for eight observations. A row states whether it is included, a label, enterprise value, equity value, revenue, EBITDA, and net income. At least three complete, included observations with positive selected-route multiples are required. Populated rows must remain contiguous. The active-row controls toggle the grid's declared Include? value and preserve the fixed eight-row submitted values.

The visible target metric depends on the selected multiple. Debt, cash, preferred equity, noncontrolling interest, and diluted shares complete the target bridge. The precedent adjustment is measured in percent points and is used only for the precedent route.

Governing relationships

For each included observation i, the selected multiple is:

EV / Revenue_i = enterprise value_i / revenue_i

EV / EBITDA_i = enterprise value_i / EBITDA_i

P / E_i = equity value_i / net income_i

The workbook calculates the mean, median, and inclusive 25th and 75th percentiles of the positive selected multiples. A selected percentile uses inclusive linear interpolation over the ordered observations. The chosen mean, median, or percentile is the selected multiple before adjustment.

Applied multiple = selected multiple × (1 + precedent adjustment / 100)

The adjustment factor is one for trading comparables. The selected target metric is target revenue, EBITDA, or net income according to the route.

Selected basis value = applied multiple × selected target metric

Net debt and claims = debt + preferred equity + noncontrolling interest - cash

For EV / Revenue and EV / EBITDA:

Implied enterprise value = selected basis value

Implied equity value = implied enterprise value - net debt and claims

For P / E:

Implied equity value = selected basis value

Implied enterprise value = implied equity value + net debt and claims

Implied share price = implied equity value / diluted shares

Calculation sequence

1. Validate the observation population, valuation metric, statistic, visible target input, bridge, positive diluted shares, and contiguous grid.
2. Identify complete rows marked Yes and calculate the selected-route multiple for each.
3. Require at least three included positive multiples, then calculate quartiles, mean, median, and any selected inclusive percentile.
4. Apply the precedent-only upward adjustment.
5. Multiply by the visible target metric and route through the enterprise-to-equity bridge.
6. Calculate implied share price, chart observation multiples against the applied-multiple reference, and return status.

Outputs and interpretation

The main results are the applied multiple, implied enterprise value, implied equity value, and implied share price. Supporting results disclose observation count, quartiles, the pre-adjustment multiple, the selected target metric, net debt and claims, and the complete route label. The chart uses bars for included observation multiples and a dashed reference for the applied multiple. The results reflect only the supplied population and assumptions.

Validation and status logic

The workbook evaluates status in this order:

Hidden target and statistic inputs are ignored outside their active routes.

Assumptions and limitations

• The user supplies a relevant, consistently defined observation population. The workbook does not determine comparability.
• Revenue, EBITDA, and net income are analytical inputs. Any non-GAAP measure must be defined and reconciled outside the workbook.
• The claims bridge does not estimate leases, pensions, investments, tax assets, options, or other company-specific adjustments.
• The precedent adjustment is an explicit assumption, not an estimated control premium or synergy value.
• No forecast, dilution schedule, foreign-exchange normalization, present-value adjustment, filing retrieval, market price, or transaction database is included.
• Relative valuation is sensitive to selection, timing, accounting policy, growth, margin, leverage, control, liquidity, and market conditions.

Restrictions and non-computing states

At least three complete observations must be marked Yes, and all included selected-route denominators must produce positive multiples. Populated rows must be contiguous, though a populated row may be excluded with No. The visible target metric and diluted shares must be positive. A malformed row, blank gap before later populated rows, insufficient included set, or non-finite statistic prevents a supported valuation.

Errors and warnings

Input checking can reject an unknown option, invalid grid shape, or scalar outside its allowed range before calculation. Workbook NOT VALID distinguishes input and derived-range failures. Workbook CHECK preserves a computable nonpositive equity bridge for review. A connection or calculation-service error is not an implied value.

The relative-valuation routes and enterprise-value bridge are consistent with selected-company and precedent-transaction disclosures in this SEC-filed proxy statement and the bridge and ratio conventions in this SEC-filed fairness analysis. The limitation on user-entered non-GAAP measures follows the SEC Non-GAAP Financial Measures Compliance and Disclosure Interpretations. No issuer data, advisor analysis, tables, conclusions, or source prose are embedded.