All Industries, General Excel Financial Models

Business Valuation, DCF Model, Excel, Financial Model, Financial Modeling, Financial modelling, Valuation Services, WACC (Weighted Average Cost of Capital)

Purpose of the tool

This Excel-based Comparable Companies (Peer Group) Database & Matching Tool – Industrials Edition is designed to dramatically accelerate one of the most time-consuming tasks in corporate finance and strategic analysis: building a high-quality, defensible peer set. Whether you need comparable companies for valuation, benchmarking, strategy, performance comparisons, market positioning, investor materials, or any other use case where a peer group is required, the model helps you move from “blank page” to a robust shortlist within minutes.

The database is built on ~15 years of hands-on professional peer group work and is organised around historical Subject Companies. A Subject Company is the original reference business that served as the basis for a peer group build in prior analyses (e.g., valuations, PPAs, transaction-related work, benchmarking exercises, or similar contexts). For each Subject Company, a dedicated peer group was created through detailed manual research and iterative refinement—mirroring how comparable company selection is actually done in professional practice rather than relying on generic one-click screens. All Subject Companies have been anonymised, as the underlying work originates from prior professional projects.

The key idea of this model is simple: you define the profile of your current company and the tool identifies the most similar Subject Companies from the library. You can then reuse and adapt the peer groups that were originally built for those reference cases—giving you a proven starting point, clear reference logic, and substantial time savings. The comparison to the Subject Company is also critical when interpreting the output: the tool does not only rank peer lists, it ranks the underlying reference cases that explain why a given peer group exists and in which context it was originally constructed.

This Industrials Edition focuses specifically on industrial businesses and includes 100+ curated peer group cases (based on 117 subject-company cases). Coverage spans a broad range of Industrials sub-industries such as Aerospace & Defense, Building Products, Construction & Engineering, Electrical Equipment, Industrial Conglomerates, Commercial & Professional Services, Transportation, and a wide set of specialised machinery categories (e.g., construction, agricultural, chemical processing, HVAC&R, filtration, pumps, packaging, printing, recycling, textile machinery), as well as selected industrial distribution segments.

With consistent classifications and a transparent scoring approach, the model helps you work faster while maintaining quality and repeatability—ideal for advisors, investors, corporates, and analysts working under time pressure.

Key outputs

Top ranked peer group matches (shortlist) based on weighted similarity scoring
Direct links to peer group case pages, including subject company profile and the identified peers
Transparent scoring logic (weights, must-match gates, bucket distance logic, and keyword matching)
Reusable classification framework (industry/sub-industry, business model type, customer type, end market, region, size and profitability buckets)
Keyword-based refinement to capture niche characteristics not fully reflected by drop-down criteria.

Key inputs & assumptions

Industry / Sub-industry (drop-down)
Business model type (drop-down)
Customer type (B2B/B2C/B2G; drop-down)
Primary end market (drop-down)
HQ region (drop-down)
Revenue bucket, EBITDA margin bucket, asset intensity bucket (drop-down)
Optional keywords (up to 5, separated by semicolons) to refine niche matching

How to use

Start in the Assumptions tab and enter your company profile (core drop-down selections + optional keywords).
Adjust weights if needed (recommended defaults provided) and optionally activate must-match criteria for hard constraints.
Review the Top Matches list and open the linked peer group case pages.
Use the output as a shortlist and starting point—validate qualitative fit (segment focus, scope, geography) and finalise your peer set for your specific application.

Sest-practice notes

The model is designed as a professional workflow tool, not a black box. You can adjust weights, must-match rules and keyword usage to fit different contexts (valuation vs. operational benchmarking vs. strategic peer analysis).
Peer selection should always include a qualitative reasonableness check; the scoring accelerates shortlisting and improves consistency, but it does not replace professional judgement.
For full transparency, the detailed calculation logic can be reviewed in the dedicated Scoring tab.

What’s included

Excel model with 100+ Industrials peer group cases (Subject Company based, anonymised)
Built-in matching and scoring framework (weights, must-match, bucket distance, keywords/strong keywords)
Structured case pages with direct links from the ranked shortlist
Ready-to-use assumptions interface for fast screening and repeatable peer selection

Support
The screenshots and video provide a good first impression of the model, but they do not fully capture all functionalities and details—if you have any questions or would like to better understand specific features, feel free to reach out anytime.

You must log in to submit a review.