Book · Julian R. Sterling
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
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.
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
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.
Appendix A, chapters 1 to 15
Eleven tabs: Registry (claims summed by accident year and evaluation date, with the large claim on its own rows); Triangles (paid, reported and case triangles, reported and closed counts, paid ALAE and earned premium); Diagnostics (paid to reported ratios, closure rates, average case reserves and severities, read before any method); Factors (age-to-age factors, six averages, the declared exclusions and the selected factor of each age); Tail and age-to-ultimate (the paid and incurred tails and the products of the later factors); Methods (chain ladder, expected loss ratio, Bornhuetter-Ferguson and Cape Cod, paid and incurred); Selection and range (the method declared for each accident year, the range and the IBNR); ALAE and ULAE (the two expense ratios and the unpaid expense they give); Summary (the four lines of the unpaid claim estimate); Scenarios (case strengthening, faster settlement, the next evaluation, the captive and five one-input sensitivities, kept apart from the case); Controls (every check of the workbook, each returning a difference that must read zero).
Download Loss_Reserving_Workbook.xlsx181 KBStart 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.
Related titles. The full list is on the author page.