Comparable Company Analysis Example
Capital Markets Financial Model (Free Excel Download)
Value a company against selected public peers using revenue and EBITDA multiples, operating metrics, percentile benchmarks, and implied enterprise value ranges.
professionals from Deloitte
Used by professionals from
About this model
This comparable company analysis example follows a sample peer group from company data to an implied valuation range. Use the workbook preview to trace how market capitalisation, debt, cash, revenue, and EBITDA feed into a trading-multiples comparison. The figures are illustrative and are provided to demonstrate the analysis.
Start with Company_Data to review the peer inputs, then move to Trading_Comps to compare the companies on a consistent basis. In Implied_Valuation, follow how the selected multiples translate the target company’s financial metrics into valuation estimates. The Dashboard brings the results together for review.
Read the range alongside the underlying peer data. Differences in growth, margins, and leverage help explain why companies trade at different multiples. This example gives you a starting point for reviewing those differences before choosing peers and assumptions for your own valuation.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Comparable Company Analysis Example
- Peer company input set and screening framework
- Trading multiples including EV and equity metrics
- Outlier handling and summary statistics
- Implied valuation range outputs
- Equity bridge to implied share price
- Peer company list with market cap and trading multiples
- EV/EBITDA, P/E, EV/Revenue, and custom multiples
- Trading vs. transaction multiple comparison
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a comparable company analysis?+
It is a valuation method that uses trading multiples from similar public companies to estimate a valuation range for a business.
What multiples are usually included?+
Typical multiples include EV to revenue, EV to EBITDA, EV to EBIT, and price to earnings, depending on the business.
What should a comps model include?+
It should include peer company inputs, trading multiples, summary statistics, and an implied valuation range.
Why is peer selection important?+
Because the quality of the output depends heavily on whether the peer set is actually relevant to the company being analysed.
Is this used on its own?+
Often it is used alongside DCF and transaction analysis rather than as the only valuation method.
Have more financial modelling questions? Contact us
Related templates
DCF Model
Discounted cash flow valuation model with explicit forecast, terminal value, and WACC.
Leveraged Buyout Model
Complete LBO analysis with debt financing structures, sponsor returns, and sensitivity to exit scenarios.
Sum of Parts Valuation
Value a diversified company by valuing each business segment independently and summing the parts.
Mortgage Portfolio Model
Mortgage loan portfolio analysis with prepayment speeds, default rates, and cash flow projections.
