Risk Profile Extraction From Reinsurance Submissions: Bands
On this page
- Key Takeaways
- What Does Risk Profile Extraction From Reinsurance Submissions Involve?
- How Do You Calculate Per-Risk XoL Exposure From a Cedent's Band Table?
- What Happens When a Risk Profile Band Table Is Read the Wrong Way?
- Which Band-Table Errors Move the Per-Risk Price Most?
- What Should the Reinsurer Ask the Cedent For After Reading the Band Table?
- How Does Insurnest Help With Risk Profile Extraction at Intake?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
The risk profile came as page 14 of a renewal PDF. Six bands, no units in the header, and a top band that just said "25,000+".
The pricing actuary assumed thousands and the cedent's share. Two days later the broker confirmed thousands, but the values were at 100%.
Risk profile extraction from reinsurance submissions is reading the cedent's sum-insured band table and confirming the basis behind every number.
It matters because the same table, read two ways, can price a per-risk layer very differently.
This guide gives you a band-table header check, a worked per-risk XoL exposure calculation and five wrong readings, each priced.
Key Takeaways
- Confirm the basis first. TSI or PML, units, 100% or share, per location.
- Use band averages. Total sum insured divided by risk count beats midpoints.
- Watch the open top band. Its floor can hide full-limit risks.
- Rank errors by impact. Basis and units errors dwarf rounding choices.
What Does Risk Profile Extraction From Reinsurance Submissions Involve?
Risk profile extraction from reinsurance submissions involves lifting the cedent's band table into rows and confirming what each column means.
A typical table shows sum-insured bands, number of risks, total sum insured and premium per band.
Your own output is a separate report; see the treaty risk profile report for that side.
What should a reinsurer check before reading a sum-insured band table?
A reinsurer should check eight header facts before reading a sum-insured band table, because each one can move the answer.
| Header check | What to look for | Why it matters |
|---|---|---|
| Value basis | TSI, PML, EML or MPL | PML bands shift risks into lower bands |
| Units | Units, thousands or millions | A thousands error moves every band |
| Currency | One currency or mixed | Mixed bands need converting first |
| 100% or share | "100% values" vs "our share" | 100% overstates the cedent's own exposure |
| Gross or net | Before or after surplus and fac | Per-risk cover protects the retention |
| Risk unit | Per location or per policy | Multi-location totals inflate bands |
| Date | Inception, in-force date | Old profiles miss growth |
| Top band | Closed or open ("25,000+") | Open bands need an average |
Swiss Re's reinsurance guide notes fire liability may be stated as total sum insured or as an estimated maximum loss.
The same guide shows a per-risk excess of loss protecting the retention left after proportional cover. That is why gross or net matters.
How Do You Calculate Per-Risk XoL Exposure From a Cedent's Band Table?
Per-risk XoL exposure from a cedent's band table is calculated band by band, using the average risk at the cedent's share.
PER-RISK EXPOSED LIMIT (band-average method)
Band average = total sum insured / number of risks
Cedent value = band average x cedent share
Exposed per risk = MIN( MAX(cedent value - retention, 0), limit )
Band exposed limit = exposed per risk x number of risks
Layer exposed limit = sum of all bands
Illustrative case: a property per-risk layer of EUR 8m xs EUR 2m. The cedent's table is in EUR 000s, TSI basis, at 100% values.
| Band (EUR 000s) | Risks | Total TSI | Band average | Cedent share | Cedent value | Exposed per risk | Exposed limit |
|---|---|---|---|---|---|---|---|
| 0 – 1,000 | 8,200 | 2,870,000 | 350 | 100% | 350 | 0 | 0 |
| 1,000 – 2,500 | 640 | 1,088,000 | 1,700 | 100% | 1,700 | 0 (straddles) | 0 |
| 2,500 – 5,000 | 210 | 777,000 | 3,700 | 100% | 3,700 | 1,700 | 357,000 |
| 5,000 – 10,000 | 58 | 412,000 | 7,103 | 100% | 7,103 | 5,103 | 295,974 |
| 10,000 – 25,000 | 31 | 527,000 | 17,000 | 40% | 6,800 | 4,800 | 148,800 |
| 25,000+ (open) | 9 | 405,000 | 45,000 | 25% | 11,250 | 8,000 | 72,000 |
| Total | 9,148 | 873,774 |
The layer's exposed limit is about EUR 874m across 308 risks, of which only the 9 in the open band can take a full EUR 8m loss.
The 1,000–2,500 band straddles the EUR 2m retention. Its average sits below it, yet some risks in it do pierce the layer.
Exposed limit is not expected loss. For pricing, the CAS study note by Clark applies an exposure curve to subject premium per band.
His illustrative curve gives a 44% factor for a $400,000 xs $100,000 layer on a $500,000 risk (93% minus 49%).
Wrong band values flow straight into that curve, so the reading errors below carry through to price.
What Happens When a Risk Profile Band Table Is Read the Wrong Way?
When a risk profile band table is read the wrong way, the exposed limit moves, sometimes beyond recognition.
Same table, same layer, five readings.
| Reading | What changed | Exposed limit (EUR m) | vs right |
|---|---|---|---|
| Right | Band averages, cedent share, TSI | 874 | – |
| 100% read as share | Top two bands not cut to 40% and 25% | 973 | +11% |
| Midpoints | 3,750 / 7,500 / 17,500 instead of averages | 914 | +5% |
| Open band at floor | 25,000 x 25% = 6,250 per risk | 840 | –4% |
| PML bands (PML at 45% of TSI) | Every value x 0.45 | 130 | –85% |
| Thousands read as units | All risks below EUR 2m | 0 | –100% |
The 100% error also inflates the full-limit count from 9 risks to 40. That shifts the layer from occasional to frequent full losses.
Clark also warns that limits profiles built from multi-location policy totals, not per location, distort the result.
Why does an open top band understate exposure to a per-risk layer?
An open top band understates exposure to a per-risk layer when the reader takes its floor as the value of every risk in it.
Here the floor gave 6,250 per risk at share; the true average gave 11,250. The difference is EUR 34m of exposed limit.
Always derive the average from total sum insured and risk count. If the band has under 20 risks, ask for the list.
Why do PML bands make a per-risk layer look safer than it is?
PML bands make a per-risk layer look safer because every risk is valued lower, so fewer pierce the retention.
At PML of 45% of TSI, the 2,500–5,000 band drops out entirely and exposed limit falls to about EUR 130m.
Know which basis your exposure curve expects. Never apply a TSI curve to PML bands, or the reverse.
Which Band-Table Errors Move the Per-Risk Price Most?
The band-table errors that move the per-risk price most are units and value basis, then 100% versus cedent share.
- Units. A thousands slip can zero the layer or multiply it.
- Value basis. PML instead of TSI cut exposure by 85% here.
- 100% vs share. Added 11% and four times the full-limit risks.
- Midpoints. Added 5%; tolerable for screening, not for the final rate.
- Open band floor. Cut 4%, but hid which risks take full losses.
Spend checking time in that order. A perfect midpoint choice cannot rescue a wrong basis.
What Should the Reinsurer Ask the Cedent For After Reading the Band Table?
After reading the band table, the reinsurer should ask the cedent for the facts that close each open question.
- A band break at the retention. Here, split 1,000–2,500 at EUR 2m.
- A share column. Cedent share per band, or bands already at share.
- The top-band list. Each large risk, its value, share and location.
- Basis confirmation. TSI or PML, per location, gross or net of surplus.
- Subject premium per band. Needed for the exposure curve.
Put these in your renewal information requests to cedents, so they arrive before pricing starts.
For spreadsheet profiles, the column checks in Excel submission data extraction also apply.
Where a surplus treaty sits underneath, check the lines with the surplus treaty line calculation guide.
How Does Insurnest Help With Risk Profile Extraction at Intake?
Reinsurance Email Intelligence reads the submission email and its PDFs, spreadsheets and other supporting files.
It extracts cedent, broker, treaty structure, limits, premium, risk details and dates into one submission view, and flags missing information.
Test it on your own band tables, including scanned pages. It does not compute exposed limit, apply exposure curves or price the layer.
Your actuaries still decide the basis and the rate.
Key Terms
- Sum-insured band table: The cedent's risk profile, grouping risks by size with counts, values and premium.
- Exposed limit: The most a layer could pay across all risks if each suffered a total loss.
- Exposure curve: A curve giving the share of expected loss below a given percentage of insured value.
Sources
Frequently Asked Questions
What does risk profile extraction from reinsurance submissions involve?
Risk profile extraction from reinsurance submissions means lifting the cedent's sum-insured band table into usable rows and confirming its basis: TSI or PML, units, 100% or share, per location.
What should a reinsurer check before reading a sum-insured band table?
Before reading a sum-insured band table, a reinsurer should confirm eight header facts: value basis, units, currency, 100% or share, gross or net, per location, date and top band.
How do you calculate per-risk XoL exposure from a cedent's band table?
To calculate per-risk XoL exposure from a band table, take each band's average sum insured at the cedent's share, subtract the retention, cap at the limit and multiply by the risk count.
What happens when a risk profile band table is read the wrong way?
When a risk profile band table is read the wrong way, exposed limit can swing widely. In the illustrative case, errors moved it from minus 85% to plus 11%.
Why does an open top band understate exposure to a per-risk layer?
An open top band understates exposure to a per-risk layer when the reader uses its floor. The band's average, total sum insured divided by risk count, is the safer figure.
Why do PML bands make a per-risk layer look safer than it is?
PML bands make a per-risk layer look safer because each risk sits lower. In the illustrative case, PML at 45% of TSI cut exposed limit by 85%.
Which band-table errors move the per-risk price most?
The band-table errors that move the per-risk price most are units and value basis, then 100% versus cedent share. Midpoints and open-band floors usually move it by under 5%.
What should the reinsurer ask the cedent for after reading the band table?
After reading the band table, the reinsurer should ask for a band break at the retention, a share column, the top-band list of risks and confirmation that values are per location.

Hitul Mistry
CEO, Insurnest
An InsurTech leader with more than a decade of experience across insurance and technology, focused on solving business problems with the help of technology. Has worked with brokers, insurance carriers, and reinsurance firms across the India, UAE, and US markets.
View LinkedIn profile →