Workers' Comp Experience Mod Calculator
Enter the values from an experience-rating worksheet to estimate the mod, the premium effect, and how sensitive the result is to another primary or excess loss.
Calculated experience modification0.965
- Credit or debit mod
- Credit mod
- Premium after experience mod
- $96,521.74
- Estimated premium impact
- -$3,478.26
- Expected excess stabilizing amount
- $56,000.00
- Mod increase per $10,000 primary loss
- 0.09
- Mod increase per $10,000 excess loss
- 0.02
Uses an NCCI-style primary/excess loss formula with the weighting and ballast values you enter.
Actual losses should already reflect the split point, claim limits, and worksheet rules for the applicable rating plan.
How to use this calculator
- Enter the actual primary and actual excess losses from the worksheet.
- Enter expected primary losses, expected excess losses, the weighting value, and ballast.
- Enter the manual premium before the experience modification is applied.
- Use the result as a worksheet check, not as the official bureau-issued mod.
How the experience mod is calculated
A workers compensation experience modification compares the losses charged to an employer with the losses expected for employers of similar size and classification. The NCCI-style method does not treat every dollar of loss the same. Primary losses are counted dollar for dollar because they are treated as a stronger signal of frequency, while excess losses are counted only by the weighting value.
This calculator uses the worksheet values you enter:
M = [Ap + (w x Ae) + ((1 - w) x Ee) + B] / (Ep + Ee + B)
- Ap is actual primary losses.
- Ae is actual excess losses.
- Ep is expected primary losses.
- Ee is expected excess losses.
- w is the weighting value entered as a percent and converted to a decimal.
- B is the ballast value.
The numerator adds actual primary losses, the weighted share of actual excess losses, the unweighted share of expected excess losses, and ballast. The denominator is expected primary losses plus expected excess losses plus ballast. A result below 1.000 is a credit mod, 1.000 is a unity mod, and a result above 1.000 is a debit mod.
What moves the mod most
Primary losses usually move the mod more than excess losses. With the default worksheet values, another $10,000 of primary loss raises the mod by about 0.087, while another $10,000 of excess loss raises it by about 0.017 because only 20% of excess loss is weighted in. That is why a small claim that falls within the primary layer can matter more to the mod than the same dollar amount above the split point.
The ballast value stabilizes the calculation. A larger ballast makes the denominator larger, so the same loss change moves the mod less. The expected excess stabilizing amount, (1 - w) x Ee, also keeps zero-loss accounts from dropping to zero because the formula still includes part of expected excess losses.
What this calculator leaves out
The result is an educational reconstruction of the common NCCI-style formula. It does not choose the split point, apply state-specific loss limitations, select expected loss rates, calculate expected losses from payroll, or reproduce worksheet-level rounding. The premium estimate is also limited: it multiplies manual premium by the mod and excludes schedule rating, taxes, assessments, expense constants, minimum premiums, deductibles, and carrier-specific adjustments.
Use the values from the applicable rating-bureau worksheet when you have them. California and some other independent-bureau states use different experience-rating plans, so the same inputs may not reproduce the official mod in those jurisdictions.
Worked example
Suppose a worksheet shows $25,000 of actual primary losses, $75,000 of actual excess losses, $30,000 of expected primary losses, $70,000 of expected excess losses, a 20% weighting value, and $15,000 of ballast. The manual premium before the mod is $100,000.
The numerator is $25,000 + (0.20 x $75,000) + (0.80 x $70,000) + $15,000, or $111,000. The denominator is $30,000 + $70,000 + $15,000, or $115,000. The calculated experience modification is 0.965, a credit mod. The modified premium is about $96,522, so the estimated credit is about $3,478 before other premium adjustments.
Common questions
What is a workers compensation experience modification rate?
A workers compensation experience modification rate, often called an experience mod or EMR, adjusts manual premium based on an employer loss history compared with expected losses. A mod below 1.000 usually lowers premium, while a mod above 1.000 usually increases it.
Why is EMR not simply actual losses divided by expected losses?
Experience rating separates primary and excess losses because claim frequency and claim severity are treated differently. Primary losses are counted fully, while excess losses are weighted so one unusually large claim does not dominate the mod as much as repeated smaller claims.
Where do I find the weighting and ballast values?
The weighting value and ballast value come from the applicable rating-bureau experience-rating worksheet. They are based on the rating plan and employer size, so they should not be guessed from another employer worksheet.
What is a credit mod versus a debit mod?
A credit mod is below 1.000 and generally reduces manual premium. A debit mod is above 1.000 and generally increases manual premium. A unity mod is exactly 1.000, meaning the mod itself does not change the manual premium.
Why might this differ from the official worksheet?
Official worksheets can include claim limitations, split-point rules, state-specific factors, and rounding at intermediate steps. This calculator assumes the loss values, expected losses, weighting, and ballast have already been prepared under the applicable rating plan.
Does this formula apply in California and independent-bureau states?
Not necessarily. California and some other independent-bureau jurisdictions use their own experience-rating plans. Use this calculator as an NCCI-style worksheet check unless the state bureau instructions confirm the same method.