Skip to content
Acttuary

Inside General Insurance / Pricing: what a risk should cost

Frequency, severity and the risk premium

Every premium a general insurer charges starts from an estimate of what the risk will cost in claims. That number is the . Expenses, commission and profit are loaded on top of it to reach the price the customer pays, and this lesson works through both steps on a single fleet of vehicles.

Exposure comes first

A claims count means nothing without a denominator. Forty claims from a corner shop's delivery vans is a catastrophe; forty from a national logistics fleet is a quiet Tuesday. The denominator is : how much risk the insurer actually carried, and for how long.

For motor, the measure is vehicle-years, not vehicles. A van on cover for the full year contributes 1.0 vehicle-years; a van added in January and cancelled at the end of June contributes 0.5. The distinction matters because fleets churn constantly. Suppose 100 vehicles in your data were each insured for only six months. Count them as 100 full vehicles and your denominator is 50 vehicle-years too big, so the claim rate you measure is too low, so the premium you charge is too low. The underpricing is silent and only surfaces in next year's . Other classes use other measures (sum insured for property, turnover or payroll for liability), but the job of is the same everywhere: to measure how much risk was actually on cover.

Frequency × severity

The fleet : 500 vehicle-years of this year, 40 claims, average claim £3,750.

  • Frequency, claims per unit of : 40 ÷ 500 = 8%. Each vehicle-year is expected to produce 0.08 claims.
  • Severity, average cost per claim: £3,750.
  • , frequency × severity: 0.08 × £3,750 = £300 per vehicle-year.

£300 is the expected claims cost of insuring one vehicle for one year, with no expenses, commission or profit in it. It is also called the expected loss cost, which says exactly what it is.

Pricing an account this way, one selected frequency and one selected severity for the whole risk, is how pricing works. prices each policyholder individually, with and , which is the next lesson.

Loading up to the office premium

The premium the customer actually pays, the , has to fund the rest of the company. Say expenses and commission run at 25% of the office premium, and the target profit margin is 5%. Thirty pence of every premium pound is spoken for before a single claim is paid.

The instinctive calculation is £300 × 1.30 = £390, and it is wrong in a way that turns up in real spreadsheets. The loadings are percentages of the premium you charge, not of the . Charge £390 and 30% of it (£117) disappears into expenses, commission and profit, leaving £273 to pay £300 of expected claims. You have built a £27-per-vehicle loss into your own rate.

If loadings claim 30% of the , the must be the surviving 70%:

= ÷ (1 - total loading)

Divide by one minus the loading; never multiply by one plus it.

Frequency and severity move differently

Why estimate the two components separately rather than just tracking cost per vehicle-year? Because they move for different reasons, often in different directions. Suppose next year the fleet's frequency improves to 7% (safer vehicles, a telematics programme recording how each van is driven) while repair inflation pushes severity up 8%, to £3,750 × 1.08 = £4,050. The new is 0.07 × £4,050 = £283.50: a 12.5% frequency improvement more than absorbs the severity inflation, and the falls about 5.5%. One aggregate cost number would tell you that it fell; the split tells you why, and whether to believe it will continue.

UK motor has behaved exactly like this. Long-run claim frequency has improved (vehicle safety) while severity inflation stays stubborn: the ABI's Q1 2026 Motor Premium Tracker put the average accidental damage claim at £3,699 (up 8% in a single quarter, on repair complexity and parts costs) even as the average comprehensive premium actually paid drifted down to £560. Premiums fell while claim costs rose, and the frequency-severity split is what lets you explain both at once.

One year of data is the teaching version. In practice you would take several prior years of experience, trend each one to next year's cost level (claims inflation on severity, any drift in frequency), and then select the frequency and severity to price with. The selection is a judgement, not an average: the actuary decides which years to believe and how much weight the trend deserves.

Back to the fleet:

Work it out

The fleet expands next year: you expect 600 vehicle-years, 45 claims and an average claim of £3,400. The loadings are renegotiated too: expenses and commission now take 22% of the office premium and the profit target is 6% of premium. What office premium per vehicle-year should you charge?

£

Build the rate

In practice the rate lives in a spreadsheet, with every assumption in its own cell, so that moving one assumption moves the whole answer and the loading stays visible rather than buried inside a formula. Build it with the fleet's own numbers, then price next year.

Spreadsheet: build it, don’t type it

Fleet motor: risk premium to office premium

The fleet's data sits in A2:B6 and next year's two assumptions in B8 and B9. Everything you build goes in column E. 1. This year. E2 frequency, E3 risk premium, E4 total loading, E5 office premium to the nearest penny. 2. Next year. E8 the average claim after inflation, E9 the new risk premium, E10 the new office premium, E11 the change in the risk premium, written as a decimal like the assumptions in column B rather than multiplied out into percent. E5 and E10 want ROUND to two decimal places. Reference the input cells rather than retyping their values: a rate model earns its keep only if changing an assumption changes the answer. E4 and E8 are not marked, but nothing after them comes out right without them.

Cells to fill: E2, E3, E5, E9, E10, E11

100%
  • Given data, locked
  • Yours to fill
RowABCDEFG
1InputValueThis yearValue
2Exposure (vehicle-years)500Frequency
3Claims40Risk premium (£)
4Average claim (£)3750Total loading
5Expenses and commission0.25Office premium (£)
6Profit margin0.05
7Next yearValue
8Next year: frequency0.07Average claim (£)
9Next year: severity inflation0.08Risk premium (£)
10Office premium (£)
11Change in risk premium
12
13
14
How this grid works: typing, filling, references, layout

Moving and selecting

Move a cell at a time
: arrow keys
Run to the end of a block
: Ctrl+arrow
Back to A1, or out to the last cell used
: Ctrl+Home / Ctrl+End
Select a range
: Shift+arrow, or shift-click the far corner
Select to the end of a block
: Ctrl+Shift+arrow
Take a whole row, or a whole column
: Shift+Space / Ctrl+Space, or click its header
Take several rows or columns
: drag along the headers, or shift-click
Take the lot
: Ctrl+A

Entering and editing

Start an entry
: just type, or use the formula bar
Commit it and move down, or up
: Enter / Shift+Enter
Commit it and move right
: Tab
Change your mind mid-entry
: Escape
Open what is already in the cell
: F2, or double-click it
Empty the selected cells
: Delete
Find a function, then its arguments
: start typing the name; the open bracket lists the arguments in order, with the one you are writing picked out

Filling and copying

Fill a formula down the column
: Ctrl+D, or drag the small square at the corner of the selection
Fill it right along the row
: Ctrl+R
Copy, or cut
: Ctrl+C / Ctrl+X
Paste it, references moving as they go
: Ctrl+V
Paste the numbers instead of the formulas
: Ctrl+Shift+V
Fill a whole block from one cell
: copy it, select the block, paste
The same four with a mouse
: right-click a cell: the shortcuts are printed beside them

References

Put a cell into a formula without typing its address
: click it, or press an arrow after =, a bracket or an operator
Grow that reference into a range
: Shift+arrow, or drag across the cells
Stop a reference shifting when the formula copies
: F4, which adds the dollar signs
Give the arrow keys back to the text
: F2 swaps them between picking cells and moving the cursor
See the range you picked before you commit it
: each reference takes a colour and outlines the cells it points at; the same one twice keeps its colour
See what a finished formula reads
: select its cell: the cells it reads are outlined

Rows and columns

Make a column wider, or a row taller
: drag the line between two headers, or Alt+Shift+arrow
Fit it back to what is in it
: double-click that line, or Alt+Shift+0
More room to work in
: the blank rows and columns past the data, and the Add rows and Add columns buttons

Columns start as wide as what is in them, and nothing you do out in the blank space is marked.

The view

Zoom in or out
: Ctrl++ / Ctrl+-, the buttons above the grid, or Ctrl with the wheel
Back to how it was drawn
: Ctrl+0, or Reset view
Find out what a shade means
: the key above the grid, which lists only the shades this exercise uses

Zoom, widths and heights are how you are looking at the grid, not what is in it. None of it is marked.

Have a go and press Check. The worked solution opens up after your first real attempt.