Build an insurance rating table

Enter a base rate and rating factor multipliers to see a sample premium and range, then copy your rating table as decision table rows.

Base rate

Each factor multiplies the premium. A multiplier of 1.00 leaves it unchanged, above raises it, and below lowers it.

The demo’s base rate and multipliers are made up.

Use factor

LevelMultiplierSample risk

Use factor

LevelMultiplierSample risk

Use factor

LevelMultiplierSample risk

Use factor

LevelMultiplierSample risk

This counts claims from the last three years.

Sample risk premium

€683
Total multiplier1.37×
Lowest premium€291
Highest premium€2,268

Your sample risk pays €683, 1.37× the base rate, and premiums across the 320 combinations of levels range from €291 to €2,268.

How your sample premium is built

Raises premiumLowers premium

Premiums across every combination

138 of the 320 combinations of levels pay less than your sample risk.

Rating table as decision table

Rating factorLevelMultiplier
Base rate–€500
Age band18–241.60
Age band25–341.15
Age band35–491.00
Age band50–640.95
Age band65+1.10
TerritoryZone 10.85
TerritoryZone 21.00
TerritoryZone 31.20
TerritoryZone 41.45
Deductible€01.15
Deductible€2501.00
Deductible€5000.90
Deductible€1,0000.80
Claims historyNo claims0.90
Claims history1 claim1.10
Claims history2 claims1.35
Claims history3 or more claims1.70

Get the result by email

Your rating table runs as a decision table in a decision flow, and you can test a multiplier change on your past policies before it prices a new one. Start your trial

How the premium is calculated

Your premium is the base rate multiplied by the multiplier of each rating factor’s level. Each chart step is the premium so far times the multiplier minus one.

Sample risk premium = Base rate × Multiplier (Age band) × Multiplier (Territory) × Multiplier (Deductible) × Multiplier (Claims history)
Change at factor = Premium so far × (Multiplier − 1)

The figures below work through your sample risk premium.

Base rate = €500
Age band (25–34): €500 × 1.15 = €575   +€75
Territory (Zone 3): €575 × 1.20 = €690   +€115
Deductible (€500): €690 × 0.90 = €621   −€69
Claims history (1 claim): €621 × 1.10 = €683   +€62
Premium = €683

Factors apply in the order shown, which changes each chart step but not the premium. Taxes, fees, discounts and a minimum premium are not included.

What an insurance rating table calculates

An insurance rating table combines a base rate with a multiplier for each level of each rating factor. The premium for a risk is the base rate multiplied by the selected levels’ multipliers.

You can see how the multipliers build a sample premium and compare premiums across every combination of levels. Copy the rating table rows to use in a spreadsheet or a decision table.

Common questions

What is an insurance rating table?

A rating table combines a base rate with a multiplier for each level of each rating factor. This tool shows the premium for a sample risk and the range across combinations.

How is an insurance premium calculated from a base rate?

Multiply the base rate by the multiplier for each rating factor level. The order changes the size of each chart step but not the premium.

What are insurance rating factors?

Rating factors are the characteristics used in this table to calculate a premium. The example includes age band, territory, deductible and claims history.

How do rating factors and multipliers change a premium?

Each factor’s multiplier changes the premium so far. A multiplier above 1.00 raises it, one below 1.00 lowers it, and 1.00 leaves it unchanged.

Can I copy an insurance rating table into a decision table?

Yes. Copy the rows, with the base rate first and one row for each level, then paste them into a spreadsheet or a decision table.