Companion files · The Private Markets Career Guides

The Reinsurance Professional

How Reinsurance Really Works: Treaties and Facultative, Pricing and Catastrophe Models, Renewals, Retrocession and Third-Party Capital, Solvency and the Career.

These are the companion files of the book. One workbook rebuilds the Lowmere Re case: Corbelle’s quota share and its sliding scale commission, the surplus and stop loss illustrations, the facultative certificate, Veldhaven’s catastrophe program, the windstorm that went through two layers and its reinstatement premiums, burning cost, the catastrophe model’s layer losses, the 2026 technical price, the Brisant Re sidecar and its trust, the retro excess of loss, solvency, and the underwriting year gross and net. A toolkit holds the sixteen checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive90 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

Corbelle’s quota shareA loss ratio of 63.5 percent cuts the commission from 32.0 to 30.25 percent, so Corbelle owes Lowmere €2,100,000; Lowmere earns €6,300,000 on the treaty
Veldhaven’s programA windstorm of €118,000,000 exhausts Layer 1 and takes €48,000,000 of Layer 2; Lowmere pays €9,832,000 net and ends the program at minus €7,493,800
The Brisant Re sidecarIt pays Lowmere €4,480,000 on the windstorm and still returns €18,615,000, 12.41 percent, to its investors; the net combined ratio is 91.2 percent against 88.7 percent gross (both rounded)

The files are provided as they are, without warranty of any kind. The model is illustrative: Lowmere Re, Corbelle, Veldhaven, Brisant Re and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the rates and figures are the book’s assumptions, not market data or benchmarks. Nothing here is investment, legal, actuarial, accounting or tax advice.

Also by Julian R. Sterling

More in corporate finance, markets and banking, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.

Also available as a standalone free template: reinsurance model: quota share to cat XL.