Customer Concentration
Customer concentration is the share of a business’s revenue or receivables that comes from its largest customers, a measure of how much of the borrower’s cash flow depends on a few relationships.
How is customer concentration measured?
Revenue concentration = revenue from a customer (or the top three or five) / total revenue
Receivable concentration = a customer's receivable balance / total receivables
- Revenue concentration: tested on annual sales, usually from a customer list or sales by customer report.
- Receivable concentration: tested on each aging, and the basis for the concentration ineligible in a borrowing base.
What is customer concentration on a sample C&I deal?
Illustrative figures for Sample Fabrication, Inc. for the most recent fiscal year.
| Customer | Revenue | Share of revenue |
|---|---|---|
| Customer 1 | $3,360,000 | 28.0% |
| Customer 2 | $1,680,000 | 14.0% |
| Customer 3 | $1,200,000 | 10.0% |
| Top three | $6,240,000 | 52.0% |
Customer 1 also owes $520,000, 32.5% of receivables. The revolver's illustrative terms exclude the part above 25% of total receivables, so $120,000 is ineligible.
A simple loss test: gross margin is 30.0% ($3,600,000 / $12,000,000). If Customer 1 left and costs other than materials and direct labor did not change, the company would lose about $1,008,000 of gross profit, taking adjusted EBITDA from $1,310,000 to $302,000, below the $550,872 of pro forma debt service. The test is blunt: it assumes Customer 1 earns the average margin and that no costs are cut.
How do lenders use concentration limits?
A borrower can show strong coverage on the strength of one customer. If that customer moves its business, renegotiates prices or pays slowly, revenue, margin and collateral all fall together. Many lenders set a policy guideline on single-customer revenue concentration and require a policy exception with compensating factors above it. The sample's illustrative credit box allows no single customer above 25% of revenue, so Customer 1 at 28.0% needs an exception. Compensating factors here could include the length of the relationship, contract terms, Customer 1's own credit quality and the 1.56x global DSCR.
Where does concentration analysis go wrong?
- Looking only at receivables at one date, which can understate or overstate a customer's share of annual sales.
- Treating related customers, such as subsidiaries of one parent, as separate.
- Stopping at the percentage without testing what losing the customer would do to cash flow.
- Ignoring supplier concentration, which can stop production just as surely.
Where does concentration appear in the credit memo?
It appears in the business description and risk section with the top customer list, in the collateral section of a revolver memo as a concentration ineligible, and in the policy exception summary when a limit is exceeded.
Related terms
Accounts receivable aging, ineligible receivables, credit box, policy exception, stress testing.
Where LenderBox does this work
With credit box and policy, LenderBox reads concentration from the financials and receivables and tests it against your credit box, so a limit exceeded reaches committee as an exception with its reason.