Reinsurance

Risk Profile Extraction From Reinsurance Submissions: Bands

On this page

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 checkWhat to look forWhy it matters
Value basisTSI, PML, EML or MPLPML bands shift risks into lower bands
UnitsUnits, thousands or millionsA thousands error moves every band
CurrencyOne currency or mixedMixed bands need converting first
100% or share"100% values" vs "our share"100% overstates the cedent's own exposure
Gross or netBefore or after surplus and facPer-risk cover protects the retention
Risk unitPer location or per policyMulti-location totals inflate bands
DateInception, in-force dateOld profiles miss growth
Top bandClosed 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)RisksTotal TSIBand averageCedent shareCedent valueExposed per riskExposed limit
0 – 1,0008,2002,870,000350100%35000
1,000 – 2,5006401,088,0001,700100%1,7000 (straddles)0
2,500 – 5,000210777,0003,700100%3,7001,700357,000
5,000 – 10,00058412,0007,103100%7,1035,103295,974
10,000 – 25,00031527,00017,00040%6,8004,800148,800
25,000+ (open)9405,00045,00025%11,2508,00072,000
Total9,148873,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.

ReadingWhat changedExposed limit (EUR m)vs right
RightBand averages, cedent share, TSI874–
100% read as shareTop two bands not cut to 40% and 25%973+11%
Midpoints3,750 / 7,500 / 17,500 instead of averages914+5%
Open band at floor25,000 x 25% = 6,250 per risk840–4%
PML bands (PML at 45% of TSI)Every value x 0.45130–85%
Thousands read as unitsAll risks below EUR 2m0–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.

  1. Units. A thousands slip can zero the layer or multiply it.
  2. Value basis. PML instead of TSI cut exposure by 85% here.
  3. 100% vs share. Added 11% and four times the full-limit risks.
  4. Midpoints. Added 5%; tolerable for screening, not for the final rate.
  5. 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

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 →
ShareLinkedInX

Read our latest blogs and research

Featured Resources

Reinsurance

Treaty Risk Profile Report: Build Accurate Sum-Insured Bands

Treaty risk profile report guide with a band template, a filled sum-insured example, construction rules and the errors that distort per-risk pricing.

Read more
Reinsurance

Excel Submission Data Extraction: Clean Cedent Spreadsheets

Excel submission data extraction turns messy cedent spreadsheets into clean underwriting data. See the common traps, key checks and a 6-step fix for reinsurers.

Read more
Reinsurance

Renewal Information Requests to Cedents: Wording & Timing

Renewal information requests to cedents: a precise wording table, a copy-ready request email and a chase calendar that get treaty data in before you quote.

Read more

Meet Our Innovators:

We aim to revolutionize how businesses operate through digital technology driving industry growth and positioning ourselves as global leaders.

circle basecircle base
Pioneering Digital Solutions in Insurance

Insurnest

Empowering insurers, re-insurers, and brokers to excel with innovative technology.

Insurnest specializes in digital solutions for the insurance sector, helping insurers, re-insurers, and brokers enhance operations and customer experiences with cutting-edge technology. Our deep industry expertise enables us to address unique challenges and drive competitiveness in a dynamic market.

Get in Touch with us

Ready to transform your business? Contact us now!

We respond within one business day.