Loan portfolio concentration risk calculator
Enter exposure by sector, region, broker or top borrowers to see the HHI, largest buckets’ share and buckets over their limits.
Herfindahl-Hirschman index
Moderate concentration
An HHI of 1,858 reads as moderate concentration. The 3 largest buckets hold 62.5% of the exposure, as concentrated as 5.4 equal buckets.
One bucket is over its limit: Commercial real estate.
Where exposure sits
Each rectangle is a bucket sized by exposure. Red rectangles are over their limit.
Buckets against limits
| Bucket | Exposure | Share | HHI points | Limit | Headroom | More exposure allowed | Status |
|---|---|---|---|---|---|---|---|
| Commercial real estate | €42,000,000 | 35.0% | 1,225 | 25.0% | −10.0 pp | −€12,000,000 | Over limit |
| Construction | €18,000,000 | 15.0% | 225 | 20.0% | 5.0 pp | €6,000,000 | Within limit |
| Retail | €15,000,000 | 12.5% | 156 | – | – | – | No limit |
| Manufacturing | €12,000,000 | 10.0% | 100 | – | – | – | No limit |
| Hotels and restaurants | €9,000,000 | 7.5% | 56 | 10.0% | 2.5 pp | €3,000,000 | Within limit |
| Transport and logistics | €8,000,000 | 6.7% | 44 | – | – | – | No limit |
| Agriculture | €6,000,000 | 5.0% | 25 | – | – | – | No limit |
| Health care | €5,000,000 | 4.2% | 17 | – | – | – | No limit |
| Information technology | €3,000,000 | 2.5% | 6 | – | – | – | No limit |
| Other | €2,000,000 | 1.7% | 3 | – | – | – | No limit |
| Total | €120,000,000 | 100.0% | 1,858 |
For early defaults by sales agent, store or region, use this tool: Find sales agents with high early defaults
Email your result
Set concentration limits in the credit decision flow, so a loan that takes a bucket past its limit is referred before booking. Start your trial
How the HHI is calculated
Each bucket’s share of exposure is squared in percent, then the squares are added. One bucket holding everything gives 10,000, and many small buckets give a number near 0.
Share = Exposure ÷ Total Herfindahl-Hirschman index = Σ (Share × 100)² HHI points = (Share × 100)² Top N buckets’ share = Σ Share (N) Equal-sized buckets = 10,000 ÷ Herfindahl-Hirschman index Headroom = Limit − Share More exposure allowed = Limit × Total − Exposure
The HHI for the buckets above is:
35.0² + 15.0² + 12.5² + 10.0² + 7.5² + 6.7² + … = 1,858
The HHI depends on how the portfolio is split into buckets, so the same book split by sector and by region gives two different numbers. The thresholds and limits are your own.
Loan portfolio concentration and HHI
The Herfindahl-Hirschman index, or HHI, measures concentration across buckets in a loan portfolio. It is calculated from each bucket’s share of the exposure, squared and added together.
A bucket limit shows the share of the portfolio assigned to that bucket, while the HHI gives a single measure of overall concentration. Use both when monitoring the portfolio and reporting concentration to the risk committee.
HHI questions
What is HHI for a loan portfolio?
HHI measures how concentrated a portfolio is across its buckets. It adds together the square of each bucket’s share of the exposure, expressed as a percentage.
How do I calculate HHI for a loan portfolio?
Work out each bucket’s share of the total exposure, square each share in percent, then add the squares. This calculator works it out from the exposure entered for each bucket.
Does splitting a loan book by sector or region change HHI?
Yes. HHI depends on how the portfolio is split into buckets, so the same book split by sector and by region gives two different numbers.
What does the equal-sized buckets figure mean?
It is the number of equal-sized buckets that would give the same HHI. The calculator shows this figure beside the HHI result.
What do HHI thresholds 1,500 and 2,500 mean?
They are the calculator’s starting threshold values, and you can change them. They divide the dial into low, moderate and high concentration based on the thresholds you set.