Customer Concentration Analysis in Due Diligence: Quantifying Revenue Dependency Risk

Customer concentration is one of the most tangible risk factors in a due diligence engagement. A target company that derives 50 percent of its revenue from two customers presents a fundamentally different risk profile than one with a diversified base of 500 customers where no single customer exceeds 3 percent.

For buyers, concentration risk directly affects valuation. For advisory teams, the customer concentration analysis is a standard component of the revenue quality assessment and often one of the most scrutinized sections of the due diligence report.

Measuring Concentration

Basic Metrics

The starting point is straightforward: rank customers by revenue contribution and calculate cumulative percentages.

Common concentration metrics include:

• Top 1 customer as a percentage of total revenue
• Top 5 customers as a percentage of total revenue
• Top 10 and top 20 customers as cumulative percentages
• Herfindahl-Hirschman Index (HHI): Sum of squared market shares, providing a single concentration score

A useful rule of thumb: if the loss of any single customer would reduce revenue by more than 10 percent, concentration risk is material to the deal analysis.

Trend Analysis

Static concentration metrics tell part of the story. The trend over time adds critical context:

• Is concentration increasing (the target is becoming more dependent on fewer customers)?
• Is the customer base expanding (new customer additions exceeding customer losses)?
• Are the top customers growing faster or slower than the overall business?
• Have any major customers been lost during the analysis period, and what was the revenue replacement timeline?

Contractual Protection

Not all concentration is equal. A top customer contributing 25 percent of revenue under a five-year contract with minimum volume commitments presents less risk than the same contribution under annual purchase orders with no commitment.

The analysis should assess:

• Contract duration and renewal terms for major customers
• Minimum volume or spend commitments
• Exclusivity or preferred supplier provisions
• Termination notice periods and penalties
• Historical contract renewal rates

Data Requirements

Customer concentration analysis requires customer-level revenue data over the full analysis period. This data typically comes from:

• Accounts receivable sub-ledger: Invoice-level or customer-level revenue by period from the target's ERP system (SAP, Oracle, NetSuite, or equivalent)
• Sales reporting systems: CRM or sales management tools that track customer-level activity
• Management reports: Customer revenue schedules prepared by the target's finance team

The data extraction challenge is significant, particularly when the target uses multiple billing systems, operates across multiple entities (requiring consolidation of customer data), or has inconsistent customer coding across systems.

Common data issues include:

• Duplicate customer records: The same customer appears under different codes or names across entities or billing systems
• Group versus entity analysis: A customer group (parent company and subsidiaries) may appear as multiple separate customers in the system. The true concentration at the customer group level is higher than the entity-level data suggests.
• Currency effects: For international businesses, revenue data in local currencies must be converted consistently to enable meaningful comparison

Contextualizing the Findings

Raw concentration numbers need context to be useful for deal decisions:

Industry Benchmarks

Some industries inherently have higher customer concentration. A defense contractor with two government clients is different from a consumer goods company with the same concentration level. The analysis should reference industry norms where available.

Customer Quality

The risk associated with concentration depends on the identity and creditworthiness of the concentrated customers. Revenue concentration in a large, creditworthy multinational carries less risk than concentration in a small, leveraged customer.

Switching Costs

High switching costs (technical integration, regulatory approvals, qualification processes) reduce the practical risk of customer loss, even where contractual protection is limited.

Revenue Replacement Capability

The target's historical ability to replace lost revenue is relevant. If the target has lost a top-5 customer in the past and replaced the revenue within 12 months, the practical concentration risk is lower than the headline number suggests.

Presenting the Analysis

The deliverable should include:

1. Summary table showing top customer revenue contributions and trends over the analysis period
2. Waterfall analysis showing customer additions, losses, and net change by period
3. Contract summary for material customers (terms, duration, renewal status)
4. Risk assessment contextualizing the concentration level with industry, customer quality, and contractual factors

Each element must be traceable to the underlying data. Customer-level revenue figures should reconcile to the total revenue in the QoE analysis. Discrepancies between customer-level data and GL-level data must be investigated and explained.

The Deal Impact

Customer concentration directly affects deal structuring. High concentration may lead to:

• Price adjustments: Lower multiples to reflect the risk premium
• Earn-out provisions: Tying part of the purchase price to retention of key customers, as discussed in earnout analysis
• Warranty and indemnity provisions: Seller representations about customer relationships
• Key customer due diligence: Direct engagement with major customers (with seller permission) to assess relationship stability

The advisory team's analysis provides the factual basis for these commercial decisions. The rigor of the underlying customer data analysis directly influences the quality of those decisions.