In investment banking and corporate development, the comparable company analysis (Comps) is one of the most used valuation methods. Yet many analysts still spend hours manually setting up spreadsheets for each new deal.
I built a M&A Comparable Analysis Template in Google Sheets that comes with all the formulas pre-loaded — EV, EBITDA multiples, median calculations, and an implied valuation range. Here's what you get in a 4-tab structure:
- Peer Summary — enter company names, market cap, net debt, EBITDA, revenue
- Comps Analysis — automatically calculates median, mean, 25th/75th percentile of EV/EBITDA, EV/EBIT, P/E, and PEG
- Target Valuation — input the target company's EBITDA and see the implied enterprise value range based on peer multiples
- Deal Metrics — track premium, synergy assumptions, and financing mix
The formulas are straightforward:
- Enterprise Value = Market Cap + Net Debt
- EV/EBITDA = Enterprise Value / EBITDA
- Median multiple = MEDIAN(range)
- Implied EV = Target EBITDA × Median Multiple
I've pre-filled sample data for 5 software companies so you can test the model immediately.
Why Google Sheets? Because you can collaborate in real-time, access from any device, and avoid broken macros. Perfect for teams working on live deals.
If you want to skip the setup entirely, I've published the full template on Gumroad ($30) — pre-filled with formulas, conditional formatting, and clear instructions. It's a one-time purchase, no subscriptions.
Grab the M&A Comparable Analysis Template here
Tags: googlesheets, financialmodeling, valuation, investmentbanking
Top comments (0)