Book · Julian R. Sterling

The Self-Funded Health Plan Handbook

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

About the book

Cover of The Self-Funded Health Plan Handbook

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 companion files

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.

Download all files (ZIP)67 KB

The 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.

What is inside

Also by Julian R. Sterling

Related titles. The full list is on the author page.