The IB Comps Table & Precedent Transaction Model
Trading Comps, Precedent Transactions & Implied EV Range
Full comps model covering both public trading multiples and precedent M&A transactions. Pre-loaded with 6 comparable companies and 5 precedent transactions — swap in your own data.
6 tabs included:
README — How-to guide, multiple definitions (EV/Rev, EV/EBITDA, P/E)
Assumptions — Target company: revenue, EBITDA, net income, debt, cash, shares
Trading Comps — 6 peers, LTM financials, auto-calculated multiples, 25th/Median/Mean/75th stats, target benchmarked vs. peers
Precedent Transactions — 5 M&A deals, deal multiples, statistical summary
Valuation Output — Implied EV range (low/median/high) from trading comps & precedent transactions, equity bridge to implied share price
Output Summary — One-page peer multiple summary and valuation range
Built for: IB analysts building pitch books, equity research associates, corp dev teams evaluating acquisitions.
Use it to: Benchmark a target against peers, build the comps section of a pitch book or CIM, or derive an implied valuation range for a private company.
Color-coded to Wall Street standards.
Built by an MBA candidate with PE investment analysis experience across institutional transactions.
