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.