Portfolio simulation

Rapidly test and iterate on your rates.

Put rating structures head to head on the same risks, and see how your pricing strategy shapes your premium, business mix, margin, and adverse selection.

Simulation challenges

A rate change needs more than a model check.

A single model view cannot show the whole rate set A detailed model chart sits apart from a muted grid representing the full portfolio, with a question mark between them. Single model ? Whole rate set

One model misses the full rate set

A model can perform well on its own while the combined rates change premium, loss ratio and risk mix across the book.

Analysis spread across sheets and code A spreadsheet and a code window are connected by manual file handoffs in both directions. Sheet Code

Full-book tests need workarounds

Excel’s size limits and custom Python pipelines can turn each comparison into extracts, joins and reruns.

An average conceals different pricing impacts A small average rate change hides larger increases and decreases across three portfolio segments, while a what-if question remains unanswered. Average rate change What if? Rate change by segment − + Segment A Segment B Segment C

Averages hide pricing impact

Without segment views and what-if tests, it is hard to see where a change helps, where it hurts and what needs review before deployment.

Full portfolio testing

See the whole portfolio decision in one view

See how proposed rates compare with current rates across your full book before anything goes live. Bring in any model, from GLMs and rating tables to GAMs and GBMs, and combine them for a better view of risk.

Portfolio metricsMotor · 588,772 risks

See what changes across the whole book.

Compare current and proposed premium, loss ratio and auction outcomes on the same set of risks.

Average£ 591.26
Current £613.96−3.70%
Total£ 714.99 m
Current £742.44m−3.70%
Loss ratio51.46%
Current 49.55%+1.90 pts
Gini0.2234
Current 0.1901+17.53%
Illustrative portfolio metrics comparing actual, current, and proposed results
MetricActualCurrentProposedRelative changeAbsolute change
Portfolio result
Average£304.24£613.96£591.26−3.70%−£22.70
Total£367,905,192.68£742,436,896.57£714,986,582.75−3.70%−£27,450,313.82
Loss ratio—49.554%51.456%+3.84%+1.90 pts
Gini0.994490.190120.22344+17.53%+0.03
Competitive auction
Auction average—£575.69£507.63−11.82%−£68.07
Auction total assigned—£281,398,294.66£365,627,977.41+29.93%+£84,229,682.75
Auction loss ratio—64.42%51.05%−20.73%−13.37 pts
Auction profit—£100,181,957.32£178,963,433.55+78.64%+£78,781,476.24
Auction exposure share—40.42%59.56%+47.35%+19.14 pts

Illustrative monetary value

Portfolio explorer

Explore how a pricing change affects the entire portfolio.

Start with dislocation analysis to see the size and spread of price changes. Then use double lift to compare structures against observed outcomes, one way and two way views to inspect patterns, and geography to see where changes fall. Filter by segment, peril, model or rating structure.

Open portfolio views

What-if analysis

Test what happens when costs change.

Use a custom expressions to test a change in cost for a specific group of risks. If electric vehicle repairs become 10% more expensive, apply that assumption only to electric vehicles, then compare expected claims, loss ratio and margin with the base case. Test any proposed rate adjustment against the same portfolio.

Illustrative scenarioEV repairs +10%
Custom expression
IfVehicle type is electric
ThenRepair cost assumption × 1.10
ElseKeep the base assumption
Compare with base case

See the portfolio effect.

  • Expected claims
  • Loss ratio
  • Margin

Cross-package importance

See what drives each rating package.

Understand what variables drive the estimates for each underlying model in your rates.

Variable importanceIllustrative MTPL rating structure
8 variables · 2 packages
Illustrative variable importance scores for the motor third party liability frequency and severity rating packages
RankVariableMTPL_FreqMTPL_Sev
1bm0.21180.0216
2coverage0.02490.0705
3ageph0.09150.0373
4postcode—0.0423
5fuel0.0649—
6power0.0637—
7agec0.04130.0198
8fleet0.0078—

Competitive rate auction

Test anti-selection risk.

Price the same portfolio with two rate sets. For each eligible risk, we assign the business to the lower price and carry the selected loss measure into the winning portfolio.

Find segments where a lower price attracts a worse expected business mix, then adjust the rating structure and run the auction again.

A lowest price auction isolates selection risk. It does not replace a demand model that accounts for customer behaviour, brand, channel, and product differences. But it can be used with competitor rates to see where you are losing business.

Saved and shareable views

Give reviewers the same versions, filters, and measures.

Share a link to the exact simulation view rather than rebuilding the analysis in slides. Authorised users open the same rating versions, portfolio filters, and selected measures. Access and data permissions apply to the shared view. Making it easy to review before setting it live.

  • CompareNew rates, current rates, alternative models, and competitor rates when comparable data is available.
  • FilterFocus on the segment, peril, geography, or version behind a result.
  • InspectCheck how a rate change varies across exposure, age, mileage and geography.
Every portfolio decision stays tied to the rates that produced it.

When the selected strategy moves forward, the simulation evidence moves with it.

Next: Optimisation

Turn the portfolio evidence into a pricing decision.

Explore optimisation