Counterparty Concentration Index

Goal of the analysis:

The Counterparty Concentration Index quantifies how much exposure is concentrated in a small number of counterparties (customers, suppliers, lenders, or credit obligors). Executives use it to understand single-name and correlated concentration risk, set risk appetite and limits, inform capital allocation, and guide diversification or hedging strategies. A clear view of concentration protects liquidity and earnings from idiosyncratic shocks (e.g., a top customer default) and systemic stresses (e.g., a sector downturn impacting multiple linked counterparties). This analysis is foundational for Risk Management & Internal Audit to challenge business growth, monitor limit breaches, and validate the effectiveness of risk mitigants (collateral, guarantees, netting, insurance).

Data required:

• Exposure and transaction data:
  • Current exposure and expected exposure (e.g., EAD, EPE, PFE) by counterparty and product.
  • Gross vs. net exposure post-netting and collateral; collateral types, haircuts, and valuations.
  • Open balances (A/R, A/P), purchase spend by supplier, sales revenue by customer; contract tenors and renewal dates.
  • Limits, utilizations, covenants, and margining arrangements.
  • Currency of exposure; FX rates for normalization.
• Counterparty reference data:
  • Counterparty master, legal entity hierarchy, and ultimate parent mapping.
  • Related/affiliated parties, guarantors, cross-default provisions, and netting sets (e.g., ISDA/CSA).
  • Industry/sector classification (e.g., NAICS), geography/country, and risk country.
  • Credit ratings, probability of default (PD), loss given default (LGD).
• Financial and risk capacity data:
  • Eligible capital/equity, risk appetite thresholds, and large exposure limits.
  • Insurance limits, credit insurance coverage by counterparty (if applicable).
• Historical and benchmark data:
  • Monthly/quarterly historical exposures to build time series and internal benchmarks.
  • External benchmark ranges (industry concentration norms, regulatory large exposure limits).
• Systems/sources:
  • ERP (A/R, A/P, vendor/customer masters), CRM (revenue by account), Treasury/Trading systems, Credit risk engine, Data warehouse/MDM.
  • Legal documentation repository for netting/collateral agreements.

Detailed step-by-step instruction on how to conduct the analysis:

1. Define scope and exposure measure. Determine whether the analysis covers credit exposures (EAD/PFE), revenue dependence (customer concentration), procurement (supplier spend), or funding (lender concentration). Align with risk appetite metrics (gross vs. net exposure, inclusion of collateral, guarantees).
2. Extract data from systems. Pull counterparty-level exposures from ERP (A/R, A/P), CRM (revenue), Treasury/Risk systems (loans, derivatives), and credit engines. Include limits, collateral balances, and utilization. Normalize date as of period-end; standardize currency using spot FX rates.
3. Cleanse and map counterparties. Deduplicate legal entities; link to ultimate parent using MDM and external identifiers. Assign sector and geography. Tag related parties, guarantors, and netting sets. Validate with Legal/Compliance.
4. Calculate net exposures. For each counterparty group, compute:
   • Gross exposure.
   • Net exposure after legally enforceable netting sets.
   • Further net of collateral and guarantees (apply haircuts per policy).
   • For sales/procurement, use trailing 12-month revenue/spend as exposure proxy.
5. Aggregate at appropriate level. Roll up exposures to ultimate parent and, where relevant, to guarantor or sponsor. Maintain both legal-entity and group views to see concentration masked by affiliates.
6. Compute weights. For N counterparties i with exposure E_i and total exposure E_total, compute weight w_i = E_i / E_total using the chosen netting level (gross, net, or net of collateral) consistent with your risk appetite.
7. Calculate concentration measures.
   • HHI (Herfindahl-Hirschman Index): HHI = sum over i of (w_i)^2. Ranges from 1/N (fully diversified) to 1 (single counterparty).
   • Concentration ratios: CR3, CR5, CR10 = sum of top 3/5/10 counterparties’ w_i.
   • Largest single-name exposure: max(w_i) and as a percent of eligible capital (Largest exposure / capital).
   • Gini coefficient (optional): based on the Lorenz curve of cumulative exposure share to quantify inequality.
   • Tail metrics: P90/P50 or share of top decile.
8. Segment the analysis. Recompute metrics by product, business unit, sector, and geography. Identify correlated concentrations (e.g., multiple counterparties in the same sector or country).
9. Stress and scenario analysis. Evaluate impact of default or rating migration of top counterparties, sector-wide shocks, or FX moves. Estimate loss = exposure × LGD; compare to earnings/capital buffers.
10. Time-series trends. Compute HHI, CR10, and largest single-name monthly/quarterly for at least 12–24 months. Track pre- and post-mitigation (gross vs. net vs. net of collateral).
11. Compare to limits and appetite. Test single-name exposure against large exposure limits; evaluate CRn/HHI against policy thresholds. Flag breaches and near-breaches.
12. Validate and reconcile. Reconcile totals to GL and official risk reports; perform sampling on mappings (ultimate parent) and collateral eligibility. Document assumptions.
13. Synthesize insights and actions. Highlight top drivers, concentrations by segment, emerging trends, and recommended risk mitigations or diversification moves.

Format of the output of analysis:

• Executive summary slide with HHI, CR10, largest exposure to capital, and key movements vs. prior period.
• Ranked table of top 20 counterparties: gross/net exposures, share of total, limit utilization, collateral, sector/geo.
• Trend charts: line charts of HHI, CR10, and largest single-name over time; pre/post mitigation overlays.
• Heatmaps: exposure by sector vs. geography; concentration by business unit.
• Lorenz curve (optional) to visualize inequality and report Gini coefficient.
• Stress test results: bar/waterfall charts showing loss impact of top-5 default and sector shock vs. capital/EBITDA.
• Dashboard filters to slice by product, tenor bucket, rating band, and netting/collateral state.

How to interpret results:

• High HHI/CRn: Indicates reliance on few counterparties; raises tail risk and bargaining power imbalance. Acceptable in niche industries but requires tight limits, strong covenants, or hedges.
• Low HHI/CRn: Diversified portfolio; idiosyncratic risk is diluted. Still assess correlated exposures (sector/country clustering).
• Large single-name to capital: If a single exposure approaches defined thresholds (e.g., 15–25% of eligible capital in financial institutions), risk of outsized loss is elevated; prioritize mitigation or syndication.
• Segment differences: Concentration by sector/geo can signal wrong-way risk (e.g., commodity prices, sanctions). Multiple small names in one stressed sector can behave like a single large exposure.
• Benchmark comparisons: Use general HHI ranges as orientation; contextualize by industry norms. Track improvement/deterioration over time; sudden spikes often reflect large contracts, M&A, or loss of smaller counterparties.
• Mitigation effectiveness: If gross concentration is high but net (post-collateral/guarantees) is moderate, legal enforceability and collateral quality are critical—test under stress and haircuts.

Steps a company can take to improve on this measure:

• Policy and limits:
  • Set graduated single-name and top-N limits tied to capital/earnings capacity; include early warning thresholds.
  • Embed sector and country concentration limits; require risk review for exceptions.
• Portfolio actions:
  • Diversify by onboarding new counterparties; rebalance sales/procurement plans to broaden share.
  • Syndicate or participate out large credit exposures; use trade credit insurance or guarantees.
  • Negotiate collateral/margining and covenants; shorten tenors; require parent guarantees.
• Data, systems, and tooling:
  • Implement robust counterparty hierarchy and ultimate parent mapping in MDM.
  • Automate HHI/CRn dashboards with gross/net views and scenario toggles; integrate with limit monitoring.
  • Strengthen collateral management (eligibility, valuation, haircuts) and legal opinion tracking.
• Capability and governance:
  • Establish a concentration risk committee to review breaches and approve remediation plans.
  • Train commercial/procurement teams on pricing and contractual levers to mitigate concentration (volume tiers, termination rights).
  • Run quarterly stress tests and escalate results to the executive risk committee.
• Scenario-specific guidance:
  • If HHI is high and largest single-name to capital is high: reduce exposure via syndication, add collateral, or cap volumes; accelerate diversification.
  • If HHI is high but net exposure is low due to collateral: validate enforceability and haircut assumptions; test liquidity of collateral under stress.
  • If sector concentration is high: set sector quotas; seek cross-sector growth; consider macro hedges.

Benchmark comparisons:

General benchmarks:

• HHI orientation (adapted from competition analysis): below 0.10 typically considered unconcentrated; 0.10–0.18 moderately concentrated; above 0.18 highly concentrated. Treat as directional; calibrate to your portfolio.
• Top-10 concentration: diversified portfolios often have CR10 of 30–50%; above 60–70% signals material concentration.
• Largest single-name to capital: financial institutions are commonly constrained near 25% of eligible capital (regulatory large exposure); corporates often target under 10% of revenue or COGS with any one counterparty.

Segment- or industry-specific benchmarks:

• Manufacturing/procurement: Strategic components may drive higher supplier concentration (CR5 50–70%); mitigate via dual-sourcing and inventory buffers.
• Enterprise B2B sales: Customer concentration often higher for early-stage or niche firms (CR10 60%+); mature portfolios trend lower (CR10 30–50%).
• Banking/credit portfolios: Wholesale books aim for low single-name to Tier 1 capital; sector/country caps vary by institution (e.g., 10–20% of total exposure).

Constructing internal benchmarks where externals are weak:

• Track 24–36 months of HHI/CRn and set targets based on the best quartile internal periods or units.
• Compare across business units or geographies; adopt the most diversified unit’s metrics as a stretch target.
• Run pro forma benchmarks post-planned actions (e.g., after onboarding new suppliers) to validate improvement trajectory.