Book · Julian R. Sterling
A Practitioner's Guide for Employers, Risk Managers and CFOs: Class Codes and Premium, the NCCI Experience Mod, Premium Audits, Claims and Reserves, Return to Work, Retrospective Rating, Large Deductibles and Self-Insurance
Most companies book workers' compensation like property tax: a line in the budget, renewed every January and paid. Yet it is one of the few insurance costs where the employer's own records, claims and choices feed mechanically into the price. Classification and payroll set the manual premium, the experience mod multiplies it by your loss history, the premium audit trues it up after the year, and the program structure decides who pays the claims and when.
The Workers' Compensation Handbook takes each of those levers apart on one fictional employer, Brannock Supply Co., a regional industrial distributor with 520 employees, a truck fleet, a fabrication shop and $30,800,000 of 2027 payroll in a single NCCI-administered case state. Its January 1, 2027 experience mod is 1.20 (raw 1.1980), its guaranteed cost premium $936,603, and the mod alone costs $154,125 a year. The book shows why the debit comes from frequency rather than from its one large claim, what one more lost-time claim costs over three ratings, what the 2026 premium audit changed, how the loss triangle produces a 2027 loss pick, and whether Brannock should stay on guaranteed cost or move to a retrospective rating plan or a large deductible in good, expected and bad years. Rules are described in principle as read in November 2026, with the reminder that states differ.
Every figure below is computed by the book's model and reproduced in the companion workbook. The company, its claims and the case state's rating values are fictional teaching assumptions, not any state's filed values.
| Item | Value |
|---|---|
| 2027 estimated payroll, five classes | $30,800,000 |
| Expected losses E, experience period 2023 to 2025 | $935,698 |
| Actual primary Ap and actual excess Ae | $508,626 and $599,900 |
| Experience mod, January 1, 2027 | 1.1980, rounded 1.20 |
| 2027 guaranteed cost premium | $936,603 |
| Same policy at a 1.00 mod | $782,478 |
| Annual cost of the 1.20 mod | $154,125 |
| Mod without the ERA, and without the rollover claim | 1.32 and 1.14 |
| 2026 premium audit, additional premium due | $35,163 |
| Expected 2027 ground-up losses (loss pick) | $642,907 |
| Expected year: retrospective rating plan | $902,842 |
| Expected year: $250,000 large deductible | $976,631 |
| Projected January 1, 2028 mod | 1.0628, rounded 1.06 |
The program decision in three scenarios: in a good year the retro costs $630,522 and the deductible $716,253; in a bad year $1,129,775 and $1,193,612, against a fixed guaranteed cost of $936,603.
The live Excel workbooks behind every table in the book. Blue inputs, black formulas, zero circular references, and a Controls tab that must read zero. No sign-up required for book readers.
Appendix A, chapters 1 to 14
Twelve tabs: README, Inputs, Expected_Losses, Claims, Experience_Mod, Mod_Scenarios, Audit_2026, Loss_Development, Premium, Program_Options, Return_to_Work and Controls.
Download Workers_Comp_Workbook.xlsx32 KBStandalone practitioner tool
One sheet: payroll by class for three policy years, expected loss rates, D-ratios, split point, state accident limitation, ERA factor, weight and ballast, up to 200 claims, and the mod points each claim adds. Prefilled with Brannock: it reads 1.1980, rounded 1.20.
Download Experience_Mod_Calculator.xlsx20 KBWant the calculator first? Open the free Experience Mod Calculator page for the worked example and the Excel download.
Related titles. Full list on the author page.