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.
Sample risk premium
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
Premiums across every combination
138 of the 320 combinations of levels pay less than your sample risk.
Rating table as decision table
| Rating factor | Level | Multiplier |
|---|---|---|
| Base rate | – | €500 |
| Age band | 18–24 | 1.60 |
| Age band | 25–34 | 1.15 |
| Age band | 35–49 | 1.00 |
| Age band | 50–64 | 0.95 |
| Age band | 65+ | 1.10 |
| Territory | Zone 1 | 0.85 |
| Territory | Zone 2 | 1.00 |
| Territory | Zone 3 | 1.20 |
| Territory | Zone 4 | 1.45 |
| Deductible | €0 | 1.15 |
| Deductible | €250 | 1.00 |
| Deductible | €500 | 0.90 |
| Deductible | €1,000 | 0.80 |
| Claims history | No claims | 0.90 |
| Claims history | 1 claim | 1.10 |
| Claims history | 2 claims | 1.35 |
| Claims history | 3 or more claims | 1.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.