Treaty Risk Profile Report: Build Accurate Sum-Insured Bands
On this page
- Key Takeaways
- What Is a Treaty Risk Profile Report Used For?
- What Should a Treaty Risk Profile Report Template Contain?
- How Does a Filled Treaty Risk Profile Report Look?
- Which Construction Rules Keep Sum-Insured Bands Accurate?
- Which Errors Distort a Treaty Risk Profile Report?
- How Does Insurnest Support Treaty Risk Profile Preparation?
- How Can Cedent Reinsurance Managers Prepare the Next Risk Profile?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
The renewal submission goes out with a risk profile, and the lead reinsurer asks why the top band has doubled.
Nobody can say whether the portfolio changed, or the way locations were added together.
A treaty risk profile report is a table that groups a cedent's in-force risks into bands by sum insured, PML or EML, with risk count, exposure and premium per band.
Producing an accurate one means a fixed template, construction rules written down before extraction, and totals tied back to the premium register.
Key Takeaways
- The risk definition drives the bands. Adding locations differently can move risks across several bands.
- State the basis. A profile at 100% and one net of quota share describe different exposures.
- Bands must not overlap. A risk exactly on a boundary belongs to one band only.
- Totals must tie. Risk count and premium should reconcile to the register at the same as-at date.
- A profile prices layers. Per risk XL pricing relies on how much exposure sits above the retention.
What Is a Treaty Risk Profile Report Used For?
A treaty risk profile report is used to exposure-rate per risk layers and to size treaty capacity, especially where loss history is thin.
A Czech Society of Actuaries presentation on exposure models describes the method.
Risks of the same size by sum insured, PML or EML are grouped into risk bands. Exposure curves are then applied band by band.
It also stresses homogeneous risk types. A profile mixing homes and factories can price neither well.
A risk profile is not a cat return. Cat exposure returns group values by peril zone; a profile groups risks by size.
What Should a Treaty Risk Profile Report Template Contain?
A treaty risk profile report template should contain five sections, each with fixed fields, so every renewal is built the same way.
| Section | Fields | Construction rule |
|---|---|---|
| Header | Cedent, treaty, class or segment, currency, as-at date | One as-at date for all rows |
| Basis statement | Exposure measure (SI, PML or EML), share basis, facultative treatment, risk definition | Must match the treaty being priced |
| Band table | Lower limit, upper limit, number of risks, total exposure, total premium, average exposure, rate ‰ | Lower limit exclusive, upper inclusive, no gaps |
| Totals and tie-out | Totals per column, premium register total, difference | Difference explained in a note |
| Large risk list | Top 10 to 20 risks with exposure, PML, occupancy and location | Same basis as the band table |
The basis statement is the easiest section to skip. Without it, a reinsurer cannot tell what the bands mean.
Sum insured should follow one definition. Lloyd's Coverholder Reporting Standards v5.2 cite EIOPA's definition.
That definition is the highest amount the insurer can be obliged to pay before any policyholder deductible.
How Does a Filled Treaty Risk Profile Report Look?
A filled treaty risk profile report shows the whole portfolio in one band table. This commercial property example is illustrative, at 100%, as at 30 September 2026.
| Sum insured band | Risks | Total sum insured | Total premium | Average SI | Rate ‰ |
|---|---|---|---|---|---|
| 0 – 250,000 | 6,200 | 620,000,000 | 1,240,000 | 100,000 | 2.00 |
| 250,000 – 500,000 | 2,100 | 756,000,000 | 1,285,200 | 360,000 | 1.70 |
| 500,000 – 1,000,000 | 1,050 | 735,000,000 | 1,102,500 | 700,000 | 1.50 |
| 1,000,000 – 2,500,000 | 420 | 672,000,000 | 873,600 | 1,600,000 | 1.30 |
| 2,500,000 – 5,000,000 | 130 | 455,000,000 | 546,000 | 3,500,000 | 1.20 |
| 5,000,000 – 10,000,000 | 45 | 315,000,000 | 346,500 | 7,000,000 | 1.10 |
| 10,000,000 – 25,000,000 | 12 | 180,000,000 | 180,000 | 15,000,000 | 1.00 |
| Total | 9,957 | 3,733,000,000 | 5,573,800 | 374,912 | 1.49 |
Each row checks: risks × average SI = total SI, and total SI × rate ÷ 1,000 = premium.
What does the band table tell a per risk underwriter?
The band table tells a per risk underwriter how much exposure sits above the retention of each layer.
For a layer of 4,000,000 xs 1,000,000, the 607 risks above 1,000,000 matter. They are 6.1% of risks but carry 1,946,100 of premium, or 34.9%.
Their total sum insured is 1,622,000,000. That is the exposure the exposure curves work on.
How does one risk definition error change the table?
One risk definition error changes the table by moving exposure between bands, which changes what the layer can lose.
Suppose a client has four buildings of 3,000,000 each in one fire division. Profiled by building, they are four risks in the 2,500,000 – 5,000,000 band.
Each can lose at most 2,000,000 to the 4,000,000 xs 1,000,000 layer.
If the treaty's risk definition makes them one 12,000,000 risk, it sits in the top band. One loss can then take the full 4,000,000 limit.
Which Construction Rules Keep Sum-Insured Bands Accurate?
Construction rules keep sum-insured bands accurate by fixing every choice before the data is extracted, not after.
- Use the treaty's risk definition. Aggregate locations, buildings or policies exactly as the wording defines a risk.
- Apply the protected share. Show the retention after quota share or facultative if that is what the layer protects.
- Pick one exposure measure. Do not mix sum insured and PML in one table; build two tables if both are needed.
- Convert at one rate. Use one exchange rate date for all currencies and state it.
- Set band limits once. Keep limits fixed across renewals, so year-on-year movement is real.
- Add bands near the retention. Finer bands around each layer's attachment give the curve better inputs.
- Annualise premium. Use the annual premium of in-force risks, not written premium for the period.
- Disclose exclusions. Rows with missing sums insured or excluded classes go in a note with counts.
Which Errors Distort a Treaty Risk Profile Report?
Errors that distort a treaty risk profile report usually come from basis choices, not arithmetic. Each one has a visible symptom.
| Error | Symptom in the profile | Effect on pricing | Check |
|---|---|---|---|
| Wrong risk definition | Top band count jumps or falls with no portfolio change | Layer exposure misstated | Compare risk count with policy count per band |
| 100% shown where retention is protected | Bands sit higher than the retention suggests | Per risk layer overpriced | Read the basis statement against the treaty |
| Facultative risks included | Risks above treaty capacity appear | Exposure the treaty does not carry | Match the large risk list to fac placements |
| SI and PML mixed | Rates swing between adjacent bands | Curve applied to inconsistent values | One measure per table |
| Overlapping band limits | Totals exceed the risk count | Risks double counted | Lower limit exclusive, upper inclusive |
| Rows dropped silently | Premium total below register | Exposure understated | Tie-out section with explained difference |
| Stale as-at date | Profile predates large new risks | Capacity need understated | As-at date close to renewal |
Expiring and renewal terms should be read together with the profile. See expiring vs renewal treaty terms.
Experience and exposure methods complement each other. Our guide to burning cost reinsurance pricing covers the experience side.
Who should sign off a treaty risk profile report?
A treaty risk profile report should be signed off by the cedent's reinsurance manager, after the underwriting and finance teams confirm the basis and the tie-out.
The reinsurance manager owns the basis statement; finance owns the premium tie-out.
How Does Insurnest Support Treaty Risk Profile Preparation?
Insurnest supports one input to treaty risk profile preparation: a reconciled premium base. It does not build profiles or band tables.
Bordereaux Calculation & Reconciliation maintains participation percentages and allocates premium and claims by reinsurer share.
It compares calculated values against bordereaux, master data, premium and claim registers and settlement records.
Mismatches appear in one view, with a reinsurer-wise status of reconciled or variance to investigate.
Band construction, risk aggregation and the large risk list stay with your underwriting and reinsurance teams.
Incomplete bordereaux undermine renewal data; see renewal decisions based on incomplete bordereaux.
How Can Cedent Reinsurance Managers Prepare the Next Risk Profile?
Cedent reinsurance managers can prepare the next risk profile by fixing the basis statement three months before renewal and rebuilding last year's profile on it.
- Write the risk definition into the extract. Quote the treaty clause in the basis statement.
- Rebuild last year on the same basis. Year-on-year movement then reflects the portfolio, not the method.
- Tie premium and risk count to the register. Explain every difference in a note.
- Agree band limits with the lead reinsurer. Ask which attachments they will price.
- Add the large risk list. Show the top risks with PML and occupancy on the same basis.
Key Terms
- Risk band: A range of sums insured or PML into which risks of similar size are grouped.
- Exposure rating: Pricing a layer from the size of insured risks and exposure curves, not loss history alone.
- Risk definition: The treaty wording that decides which locations or policies count as one risk.
- As-at date: The single date at which in-force risks are extracted for the profile.
- Per risk excess of loss: A treaty paying the part of each risk's loss above a retention.
Sources
- Czech Society of Actuaries: Exposure Models in Reinsurance (18 November 2016)
- Lloyd's: Coverholder Reporting Standards User Guide Version 5.2 (20 August 2019)
- Insurnest: Bordereaux Calculation & Reconciliation
Frequently Asked Questions
What is a treaty risk profile report?
A treaty risk profile report is a table that groups a cedent's in-force risks into bands by sum insured, PML or EML, with the number of risks, total exposure and premium in each band. Reinsurers use it to exposure-rate per risk layers and to judge how much capacity a treaty needs.
What columns should a sum-insured band table contain?
A sum-insured band table should contain the lower and upper band limits, the number of risks, total sum insured, total premium, average sum insured and the implied rate per band. A totals row should tie the premium to the premium register for the same as-at date.
Why does the risk definition matter in a treaty risk profile?
The risk definition matters in a treaty risk profile because it decides how locations are added together. Four buildings of 3 million in one fire division can be one 12 million risk under the treaty, which moves exposure from a mid band into the top band and changes per risk layer pricing.
Should a risk profile be shown at 100% or net of quota share?
A risk profile should be shown on the basis the treaty protects, and the basis must be stated. A per risk excess of loss protecting the retention after a 30% quota share needs sums insured at 70%, so a 7 million risk sits in the band for 4.9 million.
How do you build a treaty risk profile report?
To build a treaty risk profile report, extract in-force risks at one as-at date, aggregate them by the treaty's risk definition, apply the protected share, convert currencies at one rate, assign non-overlapping bands, and tie total premium and risk count back to the premium register.
What is the difference between a risk profile and a cat exposure return?
A risk profile groups risks by size bands of sum insured or PML for per risk pricing, while a cat exposure return groups values by peril zone for catastrophe modelling. Both come from the same in-force data, so their totals should be explainable against each other.
Which errors most distort a treaty risk profile?
The errors that most distort a treaty risk profile are using the wrong risk definition, mixing 100% and net shares, including facultative risks the treaty does not cover, mixing sum insured with PML, overlapping band limits and dropping rows with missing sums insured without disclosure.
Does Insurnest produce treaty risk profile reports?
Insurnest does not produce treaty risk profile reports. Its Bordereaux Calculation & Reconciliation allocates premium and claims by reinsurer share and compares them against bordereaux, the premium register and settlement records, which gives cedents a reconciled premium base to tie profile totals to.

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 →