Understanding Your Experience Rating Worksheet

In Many States, Worksheets Are Issued by the NCCI

Thinking man with question mark

If your company subject to experience rating under your workers compensation insurance, an experience modifier should appear on your policy. The modifier is a numeric factor that is multiplied by your premium. A modifier that's less than 1.0 it will reduce your annual premium while a modifier greater than 1.0 will increase your premium.

Issued By Rating Authority

Experience modifiers are calculated by a workers compensation rating organization. If your business operates in one of the NCCI states, your modifier should be calculated by the NCCI. If your business operates in a monopolistic or independent state, your modifier is likely calculated by your state's workers compensation rating bureau. No matter what organization issues your modifier, it should provide a worksheet that shows how the number was calculated. The following discussion concerns the NCCI experience rating worksheet.

Worksheets used in non-NCCI states may differ somewhat from the NCCI's but they typically contain the same types of information.

Summary Section

The first portion of the worksheet, the account summary, includes the following:

  • Risk Name. Your company name
  • Risk Identification Number. A 9-digit number assigned to your company by the NCCI
  • Rating Effective Date. The date your modifier takes effect
  • Production Date. The date your modifier was calculated
  • State. The state in which you operate if you do business in one state only. Will show "interstate" if you operate in multiple states.

Experience Period

Your experience modifier is based on three years of payroll and loss data provided by your insurer. The main portion of the worksheet is divided vertically into three sections, one for each year included in the experience rating period. Each section summarizes the premium and loss information for the year indicated. The oldest information appears at the top. For instance, suppose your 2019 modifier was calculated based on data from January 1, 2015, to January 1, 2018. The data for the period January 1, 2015, to January 1, 2016, is shown at the top. It is followed by data for the following year (2016 to 2017). Data for the most recent year (2017 to 2018) appears at the bottom.

The worksheet lists the policy number and effective dates for each policy period. It also shows the 5-digit carrier code, a number assigned by the NCCI that identifies the insurer that issued the policy.

Class Codes, Payroll, and Expected Losses

The worksheet is arranged so that classification codes, payroll, and expected loss data appear on the left while claim information appears on the right. The following table shows the types of information included in the first six columns. The first column (Code) indicates the classification codes assigned to your business. In this example, there are two class codes, 8810 (Clerical Office Workers) and 8742 (Outside Salespersons).

The second column lists the Expected Loss Rate (ELR). The ELR is an actuarial calculation using premium and loss data for all employers in your industry group. It represents the dollar amount your insurer is likely to spend on losses for every $100 of payroll. For example, if the ELR is .20, your insurer can expect to spend twenty cents on losses for every $100 of your payroll.

Codes, Payroll, and Expected Losses
Code ELR D-Ratio Payroll Expected Losses

Expected Primary Losses

8810 .10 .38 3,750,000 3750 1425
8742 .25 .32 1,925,000 4812 1540

Your expected losses are calculated by multiplying the ELR by your payroll and dividing the result by 100. In the above example, Expected Losses for code 8810 are calculated as follows:

.10 X 3,750,000/100 = 3750

Here's the calculation for code 8742:

.25 X 1,925,000/100 = 4812

Primary Versus Excess Losses

Suppose your business is hit with a huge loss after it has been loss-free for many years. One large claim could severely impact your experience modifier. To prevent that from happening, losses are divided into two parts: primary losses and excess losses.

Most states have established a threshold (such as $17,000) that separates primary losses from excess losses. Any loss amount up to the specified threshold is the primary loss while the remaining loss is the excess loss. For many claims, all of the primary loss is included for experience rating but only a portion of the excess loss is used.

The NCCI uses an actuarial factor called the Discount Ratio (D-Ratio) to determine the primary portion of your expected losses. It calculates your primary expected losses by multiplying your expected losses times the discount rate. Your excess expected losses are determined by subtracting your primary expected losses from your total expected losses.

Here are the calculations of Expected Primary Losses for the two class codes shown above:

Code 8842: 3750 X .38 = 1425

Code 8742: 4812 X .32 = 1540

Your experience modifier is calculated by comparing your actual losses to your expected losses.

Claims and Actual Incurred Losses

The last five columns of the worksheet reflect your claims and actual incurred losses, meaning losses you have actually sustained. Here's an example:

Claims and Loss Data
Claims Data I J O F Actual Incurred Losses Actual Primary Losses
123456 05 F 20,000 17,000
654321 05 O 12,000 12,000
NO.6 06 F 13,000 13,000

Claim Data

Claims are listed under the heading Claims Data. In the above example, the first two claims are listed by their claim number but the third shows NO6. The letters NO indicate a group of small claims that have been combined while the number shows how many claims have been included. "NO6" means that six small claims have been lumped together. Small claims (typically those under $2000) are combined only if they involve the same type of injury.

Injury Code and Status

To the right of the Claims Data is a column with the heading IJ, meaning injury code. This code designates the type of claim. For instance, "5" indicates a medical-only claim while "6" means a temporary disability claim. Next is a column with the heading OF. The letters "O" and "F" designate the claim status. "O" means the claim is still open while "F" means it is final (closed).

The table shown above contains data for eight claims: a group of six medical-only claims and two temporary disability claims. For the purposes of this example, the threshold for primary losses is assumed to be $17,000.

Actual Incurred Losses

The last two columns contain data applicable to your incurred losses. These are the workers compensation benefits (medical expenses and disability payments) your insurer has paid to injured workers on your behalf. For claims that remain open, the loss amount may include a reserve (money your insurer has set aside for future payments).

Actual Incurred Losses means the amount that has been paid for the claim (or group of claims) indicated. Actual Primary Losses represents that portion of your total losses that's considered primary losses. When Actual Primary Losses are subtracted from Actual Incurred Losses, the result is Actual Excess Losses. Only a portion of excess losses is used for experience rating.

Experience Rating Adjustment

In many states, medical-only claims are subject to an Experience Rating Adjustment (ERA). When the ERA applies, only 30% of the claim amount is used for experience rating. The remaining 70% is ignored. The ERA does not apply to claims that result in disability payments.

Experience Rating Formula

The last part of the worksheet shows the experience rating formula and the values used to calculate your modifier.

Rating Factors

The formula includes two actuarial factors. The weight factor determines how much of your actual excess losses are used to calculate your modifier. The factor is small if your firm is small and increases as your company grows. The ballast has a stabilizing effect. Its intent is to keep your modifier from deviating too far (up or down) from unity (1.0).

Adjustments

Your experience modifier is calculated by dividing your Actual Losses by your Expected Losses. Before that calculation is made, your Actual Losses and your Expected Losses are adjusted.

First, your Actual Losses are determined by calculating the sum of the following three items:

  1. Your Actual Primary Losses. If the ERA applies in your state, then only 30% of your medical-only claims will be included in the formula.
  2. Stabilizing Value. This value is determined by multiplying your Expected Excess Losses by (1 minus the weight factor) and then adding the ballast.
  3. Your Ratable Excess Losses. This is the amount of Actual Excess Losses that are used for experience rating. It is calculated by multiplying the weight factor by your Actual Excess Losses.

Next, your Expected Losses are determined by calculating the sum of the following:

  1. Your Expected Primary Losses. This number is provided by the rating organization.
  2. Stabilizing Value. This value is calculated in the same manner as indicated above.
  3. Your Ratable Excess Losses. This is the amount of Expected Excess Losses used for experience rating. It is calculated by multiplying the weight factor by your Expected Excess Losses.

Finally, your Actual Losses are divided by your Expected Losses. For example, suppose your actual losses (based on the formula) were $45,000 and expected losses were $50,000. Your experience modifier would be $45,000 / $50,000 or .90.

Article Sources

  1. NCCI, The ABCs of Experience Rating, https://www.ncci.com/Articles/Documents/UW_ABC_Exp_Rating.pdf


  2. NCCI, The ABCs of Experience Rating, Page 9, Accessed Sept. 19, 2019


  3. NCCI, The ABCs of Experience Rating, Page 9, Accessed Sept. 19, 2019


  4. NCCI, The ABCs of Experience Rating, Page 4, Accessed Sept. 19, 2019


  5. NCCI, The ABCs of Experience Rating, Page 11, Accessed Sept. 19, 2019