Reinsurance

Rating Agency Questionnaire Preparation From Treaty Data

On this page

Last reviewed: November 2026

The rating meeting is three weeks away, and the analyst wants the net PML table by Friday.

The modelling team has gross losses, but nobody can confirm which cat programme, shares and reinstatement terms the net figures used.

Rating agency questionnaire preparation is the annual work of compiling the data a rating agency requests, such as AM Best's Supplemental Rating Questionnaire (SRQ).

For reinsurance, preparation goes faster when every answer is mapped to one treaty field and built from a dated treaty record, not from last year's spreadsheet.

Key Takeaways

  • Several SRQ exhibits are really treaty questions. Net PMLs, terrorism cover and assumed business all come from treaty records.
  • The net PML needs layer terms, not just a model run. Retention, placed share and reinstatement cost decide the retained loss.
  • Dates must line up. The questionnaire asks for both the exposure data date and the cat programme expiry date.
  • Non-traditional cover sits apart. Cat bonds and ILWs are excluded from net PMLs and reported by tranche.
  • One dated treaty extract avoids rework. Every exhibit should draw on the same version of the programme.

Which Rating Agency Questions Draw on Reinsurance Treaty Data?

Rating agency questions draw on reinsurance treaty data wherever the agency asks for a figure "net of reinsurance" or about business you assume.

The mapping below uses the exhibit names in AM Best's 2025 Property/Casualty Supplemental Rating Questionnaire. Other agencies and life questionnaires differ.

SRQ exhibitWhat it asksTreaty data sourceUsual owner
Catastrophe Model OverviewDate of the exposure data, and expiry date of the cat reinsurance used in the loss estimate (MM/YYYY)Cat XL programme record: period and expiryReinsurance operations
Catastrophe Loss Analysis – PML Exhibit (a)Gross and pre-tax net PMLs, per occurrence and aggregate, at 20 to 1,000-year return periodsLayer limits, attachments, placed shares, reinstatement provisionsCat modelling with reinsurance
PML Exhibit (b)Net PML split into company retention, participation and reinstatement cost, and % of surplusRetention, co-participation and unplaced shares, reinstatement premium termsReinsurance operations and finance
Catastrophe Top 5 LossesLargest events by net loss as % of prior surplus, gross and net incurred and reservesRecoveries booked per event and layerClaims and reinsurance finance
Catastrophe Non-Traditional MitigationPer transaction and tranche: perils, regions, trigger type, lines covered, events reimbursedCat bond and ILW contract records, kept apart from treatiesCapital management
Terrorism exhibitsAccumulations prior to reinsurance and TRIPRA, and net of reinsurance; any terrorism cover bought outside TRIPRATerrorism treaty terms and exclusions on property treatiesReinsurance and exposure management
Assumed Reinsurance ProductionAssumed premium by contract type, pro-rata vs XOL, segment and business type, plus renewal retention % and contract countInward treaty register with structure and line tagsAssumed reinsurance underwriting
Assumed Reinsurance – Client DataAssumed premium, renewal retention and contracts split by direct and broker sourceInward treaty register with placing channelAssumed reinsurance underwriting

The SRQ only asks for the assumed reinsurance production exhibit when unaffiliated assumed premium exceeds 10% of the rating unit's gross premiums written.

It also asks for terrorism reinsurance term sheets or contracts to be sent to the analyst, so those documents need a findable home.

A clean reinsurance treaty register is the starting point for most rows in this table.

Where Does Rating Agency Questionnaire Preparation Go Wrong?

Rating agency questionnaire preparation goes wrong at the joins between the model, the treaty record and the finance ledger.

Each trap below can force a restated answer.

Why must the cat programme expiry date match the model run?

The cat programme expiry date must match the model run because the net PML only holds while that protection is in force.

If the programme renews mid-cycle on new terms, a net PML built on expiring layers no longer describes the rating unit. State which programme was used.

Why is renewal retention counted by treaties, not premium?

Renewal retention is counted by treaties in the SRQ because the footnote says "By Treaty Count", while the premium columns sit beside it.

A reinsurer that renews its five largest treaties but loses twenty small ones can show high premium retention and low count retention.

Why do co-participation and unplaced shares belong in the net PML?

Co-participation and unplaced shares belong in the net PML because the cedent keeps those losses, even inside a reinsurance layer.

A layer shown as "placed" at 100% in a summary may have signed at 95%. The missing 5% belongs in the "participation" column of PML Exhibit (b).

Why should cat bonds stay out of the treaty figures?

Cat bonds should stay out of the treaty figures because the SRQ asks for PMLs that exclude cat bonds, ILWs and other non-traditional mitigation.

Those transactions are collected separately, tranche by tranche, with their trigger type.

How Is a Net PML Built From a Cat XL Programme?

A net PML is built from a cat XL programme by running the gross loss through each layer, then adding back retention, retained shares and reinstatement cost.

This example is illustrative. Rates, shares and reinstatement terms vary by programme and market.

InputValue
Gross 1-in-100 per occurrence PML180m
Retention25m
Layer 175m xs 25m, 95% placed, rate on line 12%
Layer 2100m xs 100m, 100% placed, rate on line 6%
Reinstatement termsOne reinstatement each, 100% additional premium, pro rata as to amount only

What does each cat XL layer recover in the 1-in-100 event?

Each cat XL layer recovers its share of the loss that falls inside it. The calculation runs as follows.

  1. Layer 1: the loss exhausts the 75m layer. Reinsurers pay 95%, or 71.25m. The cedent keeps 5%, or 3.75m.
  2. Layer 2: the loss inside the layer is 180m minus 100m, or 80m. Reinsurers pay 100%, or 80m.
  3. Total recovery: 71.25m plus 80m equals 151.25m. Gross minus recovery leaves 28.75m.

What do the reinstatement premiums add to the net PML?

The reinstatement premiums add 13.35m to the net PML, because both layers must be restored after the event.

  1. Layer 1 premium: 12% of 75m is 9m at 100%. At the 95% placed share, the cedent pays 8.55m. The full limit was used, so the reinstatement is 8.55m.
  2. Layer 2 premium: 6% of 100m is 6m. The event used 80m of 100m, so the reinstatement is 80% of 6m, or 4.8m.
  3. Total reinstatement cost: 8.55m plus 4.8m equals 13.35m.

The PML Exhibit (b) line then reads: company retention 25m, participation 3.75m, reinstatement cost 13.35m, total 42.1m.

As a check, 28.75m retained plus 13.35m reinstatement cost also equals 42.1m. Leaving out reinstatement cost would understate the net PML by about 32%.

How Should Teams Run Rating Agency Questionnaire Preparation?

Teams should run rating agency questionnaire preparation as a dated extract-and-reconcile routine, not a scramble through renewal folders.

  • Freeze a treaty extract. Take one dated version of the programme and record which renewal it reflects.
  • Reconcile shares to signed lines. Use signed, not written, shares before any net figure is built.
  • Rebuild net PMLs from layer terms. Recalculate retention, participation and reinstatement cost for each return period.
  • Separate non-traditional cover. Keep cat bonds and ILWs out of net figures and list them by tranche.
  • Tie assumed business to the inward register. Count renewed, lapsed and new contracts by treaty, not by premium.

A one-page reinsurance programme summary gives analysts and the CFO the same view of layers and shares.

Rating answers also feed capital discussions. Our note on rating agency capital operating controls covers that link.

How Does Insurnest Support Rating Agency Questionnaire Preparation?

Insurnest Treaty Management supports the treaty data side of questionnaire preparation, not the questionnaire itself.

It keeps a digital record per treaty with structure, terms, participation shares, retention, limits and thresholds, plus amendments, versioning and an audit trail.

That gives finance and operations one structured treaty view to draw the PML inputs and assumed business counts from.

Cat modelling, the PML calculation, the SRQ return itself and the sign-off stay with your teams. Treaty configuration and results still need validating.

What Can a CFO Fix Before the Next Questionnaire Cycle?

A CFO can fix the data trail before the next questionnaire cycle by testing last year's answers against the treaty records behind them.

  • Re-perform one net PML. Pick the 1-in-100 per occurrence figure and rebuild it from layer terms.
  • Check the expiry date reported. Confirm it matched the programme the model used.
  • Count assumed contracts. Compare the reported renewal retention by treaty count with the inward register.
  • Name an owner per exhibit. Write the owner and data source next to every SRQ exhibit that uses treaty data.

The reporting burden paradox explains why the same treaty data gets rebuilt for each report.

Key Terms

  • Probable maximum loss (PML): The modelled loss at a given return period, such as 1-in-100 years.
  • Pre-tax net PML: Gross PML after traditional reinsurance, including reinstatement costs, before tax.
  • Reinstatement premium: Premium paid to restore a layer's limit after a loss uses it.
  • Co-participation: The share of a reinsurance layer the cedent keeps for its own account. See layered programme administration.
  • Renewal retention by treaty count: The percentage of assumed contracts renewed, counted by number of treaties.

Sources

Frequently Asked Questions

What is rating agency questionnaire preparation?

Rating agency questionnaire preparation is the work of compiling the data a rating agency requests each cycle, such as AM Best's Supplemental Rating Questionnaire. For reinsurance, it means answering catastrophe, terrorism and assumed business questions from treaty records that can be traced and checked.

Which AM Best questionnaire sections need reinsurance treaty data?

The AM Best 2025 Property/Casualty Supplemental Rating Questionnaire needs treaty data in the catastrophe model overview, the PML exhibit, the top five catastrophe losses, non-traditional mitigation, the terrorism exhibits, and the assumed reinsurance production and client data exhibits.

How is a net PML calculated for a rating agency questionnaire?

A net PML for a rating agency questionnaire starts with the gross modelled loss and deducts each layer's recovery at the placed share. The retention, any unplaced or co-participated share and the reinstatement premium cost are then added back to give the pre-tax net figure.

Why do reinstatement premiums matter in a net PML?

Reinstatement premiums matter in a net PML because a large event usually triggers a payment to restore the used limit. AM Best asks for pre-tax net PMLs after traditional reinsurance including reinstatement costs, so leaving them out understates the retained loss.

Do cat bonds count in the AM Best net PML?

Cat bonds do not count in the AM Best net PML. The 2025 Supplemental Rating Questionnaire asks for PMLs that exclude catastrophe bonds, industry loss warranties and other non-traditional mitigation, and collects those transactions separately by tranche.

How do you prepare a rating agency questionnaire from treaty data?

To prepare a rating agency questionnaire from treaty data, map each question to its treaty field, freeze a dated extract of the treaty register, and rebuild the net PML from layer terms. Then reconcile retention and participation to the signed shares before the CFO signs off.

What is renewal retention by treaty count in the SRQ?

Renewal retention by treaty count in the SRQ is the share of assumed reinsurance contracts renewed, measured by number of treaties rather than premium. A reinsurer writing assumed business must count renewed, lapsed and new contracts from its inward treaty register to answer it.

Who should own rating agency questionnaire answers on reinsurance?

Rating agency questionnaire answers on reinsurance should have a named owner per exhibit. Catastrophe modelling usually owns gross PMLs, reinsurance operations owns layer terms and shares, finance owns surplus ratios, and the CFO or CRO signs off the whole return.

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

Reinsurance Programme Summary: A One-Page Board View

Reinsurance programme summary template for boards: a filled one-page example, what each field means, where it comes from and how to keep it current all year.

Read more
Reinsurance

Reinsurance Treaty Register: One Record of Every Treaty

A reinsurance treaty register gives reinsurers one complete record of every active, expired and run-off treaty, with status, shares, owners and documents.

Read more
Reinsurance

The Data, Ownership, and Escalation Model for Rating-Agency Capital Surprises

Most reinsurers discover rating-agency capital surprises after the agency has reached its conclusion, because the data infrastructure, ownership model, and escalation framework to anticipate rating-agency capital expectations do not exist. Building these operating controls converts reactive capital-surprise management into proactive capital-expectation management.

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.