Book · Julian R. Sterling
Leaving Fully Insured by the Numbers: Claims Projection, Specific and Aggregate Stop-Loss, Lasers, Funding Rates, IBNR and Run-Out, Level Funding and the Compliance Calendar
Autumn 2026. A manufacturer with 400 employees on its health plan opens a renewal letter: plus 13.5 percent, $7,174,689 for 2027. Self-funding is expected to cost $6,579,567. It can also cost as much as $7,996,096. This book shows where each of those three numbers comes from, and what a board should know before it chooses.
The Self-Funded Health Plan Handbook is a practitioner's guide to moving a US employer's medical and drug plan from fully insured to self-funded: reading the carrier's claims experience, capping large claims and projecting expected claims with trend and credibility, pricing the third-party administrator, the network, the pharmacy benefit manager and the adviser, choosing the specific stop-loss deductible, handling a laser, setting the aggregate attachment point, the maximum cost and the break-even, funding rates, employee contributions, affordability and COBRA, the claims lag, IBNR and the reserve, contract bases such as 12/12 and 12/15, run-in and run-out, the level-funded alternative and the compliance calendar under ERISA, the ACA, HIPAA and the transparency rules. One fictional employer, every number from one model.
Some of what the arithmetic shows: why the raw claims of a bad year must be capped before they are trended; why the cheapest specific deductible on expected values is not always the one to buy; why a first year's bank balance overstates the saving by the $743,678 of claims still unpaid; why a December hospital stay can fall outside a 12/12 stop-loss contract; and how a level-funded quote trades $657,696 of upside in a good year for protection in a bad one.
The model is not described, it is supplied. Three companion workbooks hold the expected claims projection, the stop-loss and maximum cost with four scenarios and the level-funded quote, and the claims lag, IBNR and reserve, by live formula, each with a Checks tab, and the check-lists come as an editable document. The closing pages say where to find them.
What you will be able to do:
Twelve chapters in four parts and four appendices: a guide to the workbooks with three exercises, six check-lists, forty questions for the carrier, the administrator, the pharmacy benefit manager, the stop-loss carrier, the adviser and counsel, and a glossary of forty terms.
Written for CFOs, controllers and HR and benefits directors of employers with roughly 100 to 1,000 employees, and for the analysts who advise them. The case, its company, its town and their figures are fictional teaching assumptions, not market norms; federal rules are dated as of November 2026, and state law is flagged, never stated. This book is for education only. It is not legal, tax, actuarial or benefits advice.
How this book was made: written with the help of artificial intelligence tools, under the author's direction; every figure was computed by a model and every rule was checked against its source.
Read next: Self-funded or fully insured: how do you compare the cost?
Read next: Specific vs aggregate stop-loss: what does each one cover?
Read next: What is IBNR in a self-funded health plan?
Also available as a standalone free template: self-funding cost calculator.
The book prints this address for its readers. The three workbooks reproduce every figure of the case, Kelderby Precision Castings, with live formulas and a Checks tab; type the figures of your own plan over the blue cells. No sign-up, no email address.
Chapters 3 and 4
Large claimants capped at the pooling point, medical and drug trend, the blend of years, credibility with the manual rate and the lasered member: expected retained claims.
Download11 KBChapters 5 to 7 and 11
Fixed costs, specific and aggregate stop-loss, the expected cost, the maximum cost and the break-even, four scenarios and the level-funded quote.
Download11 KBChapters 8 to 10
The claims lag, the first year's paid claims, IBNR, the reserve target and the share of claims inside each stop-loss contract basis.
Download11 KBAppendix B
The six check-lists of the book, editable.
Download38 KBThe three workbooks, the check-lists and a short guide, 00_START_HERE.md.
The case and its figures are fictional teaching assumptions, not market norms or rules of law. Rules are paraphrased as read in November 2026 and indexed amounts change every year; questions of state law and plan assets are for counsel. Not legal, tax, actuarial or benefits advice.
Related titles. The full list is on the author page.