The relative-valuation tab of every banker's model: enter up to six peers' EV/Revenue, EV/EBITDA, and P/E multiples plus the target's financials — get the implied enterprise value, equity value, and per-share range off the peer min / median / max, drawn as a football field. Cross-check the intrinsic answer from the DCF, and pull private-round context from Private Market Comps. Pure client-side math.
| Peer | EV/Rev × | EV/EBITDA × | P/E × |
|---|
Leave a cell blank to exclude that peer from that multiple. Trailing or forward — just keep the basis consistent with the target financials below.
Peer statistics — for each multiple, blank cells are dropped and min / median / max are computed over the remaining peers. Median (not mean) is the anchor, so one outlier peer doesn't drag the range.
EV multiples — implied enterprise value = multiple × target metric (revenue or EBITDA). Equity value = EV − net debt; per share = equity value / diluted shares.
P/E — implied equity value = P/E × net income directly (already an equity multiple; no net-debt bridge).
Blended view — the hero number is the median of the three per-multiple medians that are computable. The football field draws each multiple's min→max band with the median ticked, on a shared per-share axis.
What's intentionally omitted — calendarization, multiple regression vs growth/margin, size and liquidity discounts, control premia, and SOTP. Keep the basis (LTM vs NTM) consistent between peer multiples and target financials — mixing them is the classic comps error.
Educational financial-modeling tool — not investment advice. Comps inherit every distortion of the peer set you choose; a valuation is only as comparable as its comparables. All math runs in your browser; no inputs are sent to a server.