Private equity: comps, valuation & targets
For pE associates, corporate development, M&A advisers
Public comps, median multiples and take-private screens across the listed market in seconds. Enterprise-value multiples, leverage and price drawdown sit in the same row.
- Financial markets
- 6 steps
- Runs on live data
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
Software comps table
EV/EBITDA, EV/sales, FCF yield and leverage for every listed software company with positive EBITDA.
GET top500 SELECT symbol, name, industry, ev_ebitda, ev_sales, fcf_yield, netdebt_ebitda WHERE industry LIKE '%software%' AND ev_ebitda > 0 SORT ev_ebitda
Median multiples for a sector
Medical names with their multiples, plus the median EV/EBITDA and EV/sales for a valuation benchmark.
GET top500 WHERE industry LIKE '%medical%' SELECT symbol, name, ev_ebitda, ev_sales, ebitda_margin TOTAL median(ev_ebitda), median(ev_sales), count(symbol)
Take-private candidates
Cheap, cash-generative, modestly levered and more than 30% off the high: the classic LBO screen.
GET top500 SELECT symbol, name, mcap, ev_ebitda, fcf_yield, netdebt_ebitda, dist_high(252) WHERE fcf_yield > 8 AND ev_ebitda BETWEEN 0 AND 10 AND netdebt_ebitda BETWEEN 0 AND 3 AND dist_high(252) < -30 SORT fcf_yield DESC
Cheapest in sector, still high-return
Bottom-quintile EV/EBITDA within each sector, under $50B, with ROIC above 10%: M&A targets rather than value traps.
GET top500 SELECT symbol, sector, mcap, ev_ebitda, roic WHERE ev_ebitda < pctl(20) OVER sector AND mcap < 50e9 AND roic > 10 SORT ev_ebitda
Mid-cap healthcare, worst first
Healthcare companies between $5B and $30B ranked by one-year return, with multiples alongside.
GET top500 WHERE sector = 'Healthcare' AND mcap BETWEEN 5e9 AND 30e9 SELECT symbol, name, industry, mcap, ev_sales, ev_ebitda, roc(252) AS ret_1y SORT ret_1y
Exit benchmarking
1-day to 5-year returns and percentiles for a listed peer set, to benchmark an exit multiple or IPO window.
ANALYZE returns (CRWD, DDOG, SNOW, NET, ZS, PANW)
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.