Book · Julian R. Sterling

The Loss Reserving Handbook

A Practitioner's Guide to Estimating Unpaid Claims for Property-Casualty Insurers, Captives and Self-Insured Programs: Loss Development Triangles, Chain Ladder, Expected Loss Ratio, Bornhuetter-Ferguson and Cape Cod, Case Reserves and IBNR, ALAE and ULAE, Tail Factors, Diagnostics, Schedule P, the Actuarial Opinion and the Reserve Model

About the book

Cover of The Loss Reserving Handbook

A regional mutual insurer closes its year on commercial auto liability. Ten accident years sit on the latest diagonal: $110,539,000 of reported losses, of which $86,866,000 is paid and $23,673,000 is held as case reserves. How much more will those years cost before the last claim closes? Seven method totals answer between $126,230,802 (incurred Cape Cod) and $130,739,000 (the expected loss ratio method). The paid chain ladder reads $2,622,003 above the incurred chain ladder. The selected ultimate is $126,719,505, inside a range of $126,192,772 to $127,006,632, and it leaves $16,180,505 of IBNR, of which the youngest accident year alone carries $7,835,394. With $3,779,057 of unpaid ALAE and $1,445,677 of unpaid ULAE, the unpaid claim estimate is $45,078,239, to the dollar. Which factor, which tail and which method for which year would a reviewer ask you to defend?

The Loss Reserving Handbook is a working guide to estimating unpaid claims as reserving analysts, finance teams, captive managers and reviewers do it: what an unpaid claim estimate is and who reads it; building paid, reported and claim count triangles from a claims file; the diagnostics to read before any method; age-to-age factors, averages, exclusions and selections; tail factors and age-to-ultimate factors; the paid and incurred chain ladder, the expected loss ratio method, Bornhuetter-Ferguson and Cape Cod; what case strengthening, faster settlement and a large claim do to them; claim counts, frequency and severity; ALAE and ULAE; choosing the estimate and the range; actual versus expected at the next evaluation; Schedule P and the actuarial opinion in principle; captives and self-insured programs; and the reserve file and model.

What is inside:

Written for reserving and actuarial analysts at regional property-casualty insurers; CFOs and controllers of small insurers, captives and risk retention groups; captive managers; risk managers of self-insured programs; MGAs and program administrators who follow their results; insurance auditors and junior examiners; and credit and M&A analysts who read an insurer's reserves. The insurer, the captive and its parent are fictional, and every figure of the case is a teaching assumption, not a market or industry figure. Actuarial standards, statutory accounting and the NAIC guidance are described in principle, as read on stated dates. This book is for education only. It is not actuarial, accounting, legal or investment advice, and it is not a statement of actuarial opinion.

What is inside

Part I: Data and Reading

Part II: The Basic Methods

Part III: When the Methods Mislead, and the Rest of the Reserve

Part IV: Follow-Up, Reporting and Proof

Appendices

Free companion files

The workbook behind every figure of the book. Inputs in blue, formulas in black, and a Controls tab that counts the failures. No sign-up.

Download all files (ZIP)151 KB

Start with 00_START_HERE.md, which explains the tabs and the order to read them in.

Want to run your own triangles first? The free loss reserving calculator takes cumulative paid and reported triangles of up to ten accident years, earned premium, an expected loss ratio, a choice of average and a tail, and returns the age-to-age and age-to-ultimate factors, the ultimates and IBNR of the chain ladder, the expected loss ratio method, Bornhuetter-Ferguson and Cape Cod, year by year, with every check at zero.

Worked questions from the book

Also by Julian R. Sterling

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