Workspace /C4 Concentration and Exposure
C4

Concentration and Exposure

See where a portfolio's money and rate risk sit, by issuer, sector, rating, maturity bucket, country and currency, how much of its duration each group contributes, how concentrated it is, and whether it keeps to the limits of an investment policy statement.

Learning focus: diversification in credit portfolios, and reading an investment policy statement.

Positions

A sample credit portfolio with fictional issuers; prices are set from illustrative yields. Semiannual coupons, ACT/ACT. Sector “Government” is exempt from the issuer and sector limits.

NameIssuerSectorRatingCountryCcyMaturityCoupon %FacePrice
Investment policy limits
%
%
%
%
%
Exchange rates

Illustrative rates; values and DV01s are converted to US dollars. Currency hedging is not modelled.

Limit breaches
1 of 6
Largest issuer
Market value
9,083,082
USD, 12 positions
Modified duration
4.83
DV01 4,385
Average rating
A
Issuer Herfindahl
0.170
like 5.9 equal-sized issuers
Corporate issuer Herfindahl
0.156
like 6.4 equal-sized issuers
Limit checks
PolicyLimitPortfolioStatus
Largest issuer (governments exempt)≤ 10.0%16.5% Northwind UtilitiesBreach
Largest sector (government exempt)≤ 30.0%16.5% UtilitiesWithin
Below investment grade or unrated≤ 10.0%8.7%Within
Not in USD≤ 20.0%15.2%Within
Outside US≤ 25.0%20.7%Within
Modified duration4.0 to 7.04.83Within
Exposure
IssuerPositionsValueShareDV01Share of DV01Duration contribution
US Treasury23,007,38033.1%1,18927.1%1.310
Northwind Utilities21,500,82516.5%89120.3%0.981
Germany1749,4158.3%65514.9%0.722
Contoso Bank1700,9737.7%1944.4%0.214
Woodgrove Bank1632,7017.0%2295.2%0.252
Fabrikam Industrial1601,5246.6%3057.0%0.336
Litware Telecom1596,2206.6%3778.6%0.415
Adatum Energy1501,0955.5%2195.0%0.241
Tailspin Airlines1398,6124.4%1383.2%0.152
Proseware Retail1394,3364.3%1874.3%0.206
Reading the numbers

Value and risk are not the same thing: the 7–10Y bucket is 22.5% of value but 35.8% of DV01, because longer bonds move more for each basis point. The average rating of A hides the tail: 8.7% of the portfolio is below investment grade or unrated, and that is where defaults come from. An issuer Herfindahl of 0.170 is as concentrated as 5.9 equal-sized issuers; across the credit holdings alone it is 6.4. Investment policy statements cap single issuers because one default should cost the portfolio no more than it can absorb.