# The Loss Reserving Handbook: companion files

Julian R. Sterling, julianrsterling.com/loss-reserving

## What is here

- **Loss_Reserving_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Ashmerrow Mutual Insurance Company, a regional mutual writing commercial auto liability, reviewed at December 31, 2026 over accident years 2017 to 2026, gross of reinsurance, with ALAE outside the loss triangles. Case strengthening, faster settlement, the next evaluation, a captive and five sensitivities sit apart from the case. Every amount, premium, factor and ratio is a teaching assumption, never a market or industry figure.

## The eleven tabs, in the order the calculation runs

1. **Registry**: claims summed by accident year and evaluation date, with the large claim on its own rows.
2. **Triangles**: paid, reported and case triangles, reported and closed counts, paid ALAE and earned premium.
3. **Diagnostics**: paid to reported ratios, closure rates, average case reserves and severities, read before any method.
4. **Factors**: age-to-age factors, six averages, the declared exclusions and the selected factor of each age.
5. **Tail and age-to-ultimate**: the paid and incurred tails and the products of the later factors.
6. **Methods**: chain ladder, expected loss ratio, Bornhuetter-Ferguson and Cape Cod, paid and incurred.
7. **Selection and range**: the method declared for each accident year, the range and the IBNR.
8. **ALAE and ULAE**: the two expense ratios and the unpaid expense they give.
9. **Summary**: the four lines of the unpaid claim estimate.
10. **Scenarios**: case strengthening, faster settlement, the next evaluation, the captive and five one-input sensitivities, kept apart from the case.
11. **Controls**: every check of the workbook, each returning a difference that must read zero.

## How to use it

Change one input at a time, read the ultimates, the IBNR and the total unpaid claim estimate again, and look at Controls before reading any figure. Send nothing on while the Controls count is above zero.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Standards are described as read in November 2026. This is education, not actuarial advice and not a statement of actuarial opinion: the company's own data govern, and its actuary decides what applies.
