Book · Julian R. Sterling

The Workers' Compensation Handbook

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

About the book

Cover of The Workers' Compensation Handbook

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.

Who it is for

What is inside

Introduction

Part I, The System and the Price

Part II, The Experience Mod

Part III, Audit, Claims and Reserves

Part IV, Program Structure and the Cost of Risk

Conclusion and appendices

The Brannock case in figures

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.

ItemValue
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, 20271.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 claim1.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 mod1.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.

Free companion files

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.

Download all files (ZIP)42 KB

Start with 00_START_HERE.md.

Want the calculator first? Open the free Experience Mod Calculator page for the worked example and the Excel download.

Worked articles from the book

Also by Julian R. Sterling

Related titles. Full list on the author page.