How to read an experience rating worksheet
The worksheet is the page your rating bureau uses to work out your mod. It looks dense, but it only has a few kinds of numbers. Here's what each one means and what to check.
Where to get it
Ask your insurance agent for your current experience rating worksheet. In NCCI states, agents and carriers can download it. You're entitled to see the data your mod is based on, and you should check it every year.
The top: policy periods and payroll
The worksheet lists three policy periods, oldest first. For each one it shows your class codes and the payroll reported in each class. Check these against your audited payroll. A payroll error here changes your expected losses.
Expected losses
- ELR (expected loss rate): for each class code, the expected losses per $100 of payroll.
- Expected losses: payroll ÷ 100 × ELR. This is what a business of your size and trades would be expected to have in claims.
- D-ratio: the share of expected losses that's expected to be primary (below the split point).
- Expected primary losses: expected losses × D-ratio.
Actual losses: one line per claim
- Claim number and an injury code that shows the type of claim. Medical-only claims are usually marked so you can tell them apart.
- O/F: whether the claim was open or final when the data was reported.
- Actual incurred losses: paid plus reserved. For medical-only claims in most NCCI states, this is already cut by 70%.
- Actual primary losses: the part of each claim up to the split point.
Small claims are sometimes added together on one line. That's normal.
The box at the bottom
- W (weighting value): how much of your excess losses count. Bigger companies get a higher W, because their own experience is more reliable.
- B (ballast value): a stabilizing amount added to both sides of the formula, so small companies don't swing too far.
- Experience modification: your mod.
The formula, in one line
Mod = (actual primary + W × actual excess + (1 − W) × expected excess + B) ÷ (expected losses + B)
Actual excess is actual incurred minus actual primary. Expected excess is expected losses minus expected primary. The mod calculator takes these numbers off your worksheet, checks the mod, and shows how much each claim adds.
What to check every year
- Payroll and class codes match your audits.
- Every claim is yours and appears only once.
- Claims that closed for less than their reserve show the lower amount, if they closed before the valuation date.
- Medical-only claims are marked as medical-only.
- The mod on the worksheet matches what your policy uses.
Some bureaus label the columns a little differently, and California's worksheet follows a different rating plan. See experience mods by state.