1. Translate the brief
First identify the strategic gap to close. Region and size act as exclusion rules here; fit, growth, profitability, revenue quality and integration then determine priority.
2. Make the data comparable
All revenues refer to fictional 2025 figures in millions of euros. Growth is revenue growth versus 2024; EBITDA margin is EBITDA divided by revenue. Recurring revenue is the share of contractually recurring revenue in total revenue.
3. Set the rules before ranking
Each criterion is converted to 0–100 points and multiplied by its relative weight. The sum is the overall score. Thresholds are deliberate demonstration assumptions, not industry benchmarks.
4. Handle missing data explicitly
A profile with a missing weighted metric receives no overall score and is set aside. If that metric has zero weight, it does not block calculation, but the data gap remains visible. Other missing values are not estimated.
5. Challenge the first answer
Growth and earnings scenarios show whether the leading profile remains first under different priorities. Risks are discussed separately, rather than hidden in an additional, opaque score deduction.
6. Prepare a verifiable handover
The output is a prioritised list for research and discussion. Financial statements, customer contracts, regulatory approvals, ownership and integration assumptions would need review before further decisions. Purchase price, financing and synergies are deliberately outside this model.
Scoring rules
Overall score = sum of criterion points × relative weight
Strategic fit
1 → 0 · 2 → 25 · 3 → 50 · 4 → 75 · 5 → 100
Qualitative demonstration assessment, with a rationale for each profile.
Revenue growth
0% → 0 · 25% → 100
Linear between these limits. Negative values = 0; values above 25% = 100.
EBITDA margin
0% → 0 · 25% → 100
Linear between these limits. Negative values = 0; values above 25% = 100.
Recurring revenue
0% → 0 · 80% → 100
Linear between these limits. Values above 80% = 100.
Integration readiness
1 → 0 · 2 → 25 · 3 → 50 · 4 → 75 · 5 → 100
5 means easier integration, not greater risk. Rationale in each profile.
Calculated using unrounded values; displayed to one decimal place. Equal scores are sorted by profile identifier.
Source: entirely synthetic portfolio dataset; no external company data.
This standalone portfolio demonstration draws on my experience in company research and developing an Excel analysis tool at Dräger. It does not reproduce that tool and contains no internal data or real transaction.