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.

Exposure by bucket
BucketExposure, €Limit, %

Made-up loan book of €120,000,000 across ten industry sectors, with limits on three.

Enter one bucket per line with its name, exposure and optional limit in percent, separated by a tab, semicolon or comma.

HHI thresholds

The HHI runs from 0 to 10,000. Set the two thresholds to suit your risk appetite.

Herfindahl-Hirschman index

1,858

Moderate concentration

Top {n} buckets’ share62.5%
Over limit1
Equal-sized buckets5.4

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

BucketExposureShareHHI pointsLimitHeadroomMore exposure allowedStatus
Commercial real estate€42,000,00035.0%1,22525.0%−10.0 pp−€12,000,000Over limit
Construction€18,000,00015.0%22520.0%5.0 pp€6,000,000Within limit
Retail€15,000,00012.5%156–––No limit
Manufacturing€12,000,00010.0%100–––No limit
Hotels and restaurants€9,000,0007.5%5610.0%2.5 pp€3,000,000Within limit
Transport and logistics€8,000,0006.7%44–––No limit
Agriculture€6,000,0005.0%25–––No limit
Health care€5,000,0004.2%17–––No limit
Information technology€3,000,0002.5%6–––No limit
Other€2,000,0001.7%3–––No limit
Total€120,000,000100.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.