Formula
Total book = sum of all balances. Share of each exposure, industry or state = its balance ÷ Total book.
Herfindahl index (borrowers) = 10,000 × Σ (exposure share)² across all exposures; a book of N equal exposures scores 10,000 ÷ N.
Largest single exposure = largest balance ÷ Total book; Top 5 exposures = sum of the five largest ÷ Total book.
Breach flags: largest exposure above Policy max single exposure; any industry above Policy max per industry; any state above Policy max per state.
Worked examples
Example 1: the default ten-exposure book
Inputs: ten lines totalling $2,180,000: Restaurants NY $250,000; Trucking TX $180,000; Construction FL $420,000; Retail CA $95,000; Trucking GA $310,000; Medical NY $140,000; Salons NJ $60,000; Construction TX $275,000; Restaurants FL $120,000; Manufacturing OH $330,000. Policy limits: 10% single, 25% industry, 30% state. Largest single exposure = 420,000 ÷ 2,180,000 = 19.3%. Top 5 = 420,000 + 330,000 + 310,000 + 275,000 + 250,000 = 1,585,000 ÷ 2,180,000 = 72.7%. Industry: Construction 695,000 = 31.9%; Trucking 490,000 = 22.5%; Restaurants 370,000 = 17.0%; Manufacturing 330,000 = 15.1%; Medical 140,000 = 6.4%; Retail 95,000 = 4.4%; Salons 60,000 = 2.8%. State: FL 540,000 = 24.8%; TX 455,000 = 20.9%; NY 390,000 = 17.9%; OH 15.1%; GA 14.2%; CA 4.4%; NJ 2.8%. Herfindahl: square each borrower share and sum: 0.1147² + 0.0826² + 0.1927² + 0.0436² + 0.1422² + 0.0642² + 0.0275² + 0.1261² + 0.0550² + 0.1514² = 0.1259, times 10,000 = 1,259. Two breaches: the largest exposure at 19.3 percent exceeds the 10 percent limit, and Construction at 31.9 percent exceeds the 25 percent industry limit. No state exceeds 30 percent, though Florida is close.
Example 2: five equal exposures
Inputs: five lines of $200,000 each, in Retail NY, Medical CA, Trucking TX, Restaurants FL and Manufacturing OH; default limits. Total book $1,000,000. Each exposure is 200,000 ÷ 1,000,000 = 20.0%, so the largest single exposure is 20.0% and the top five are 100.0%. Each industry and each state is also 20.0%. Herfindahl = 10,000 × 5 × 0.20² = 10,000 × 5 × 0.04 = 2,000, which matches the rule that N equal exposures score 10,000 ÷ N. One breach: the 20 percent single exposure exceeds the 10 percent limit. This book is perfectly spread across industries and states and still concentrated, because it has only five borrowers; the Herfindahl index of 2,000 is above the 1,500 level the tool flags. The lesson is that diversification is about count and size as much as category. To bring the HHI below 1,000 with equal exposures, the book needs more than ten borrowers; to bring the largest exposure under 10 percent, it needs at least ten.
Example 3: one dominant exposure
Inputs: Construction FL $900,000; Retail FL $100,000; Medical GA $100,000; Salons NY $100,000; default limits. Total $1,200,000. Largest single = 900,000 ÷ 1,200,000 = 75.0%. Top five = 100.0%. Industry: Construction 75.0%, the other three 8.3% each. State: FL 1,000,000 = 83.3%; GA 8.3%; NY 8.3%. Herfindahl = 10,000 × (0.75² + 3 × 0.0833²) = 10,000 × (0.5625 + 0.0208) = 5,833. Three breaches: the largest exposure at 75 percent against a 10 percent limit, Construction at 75 percent against 25 percent, and Florida at 83.3 percent against 30 percent. This is what a book looks like when a funder makes one large deal to a relationship borrower: the book's loss experience is no longer a portfolio statistic but a single credit decision, and a Florida construction downturn would impair 83 percent of it in one event. The remedy is not more small deals around the edges but a participation or sale of part of the large exposure.