Companion files · The Private Markets Career Guides
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 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.
Chapters 4 to 15
One Inputs sheet holds every case assumption: Corbelle’s terms and loss ratio estimates, Veldhaven’s four layers, the event loss, the exceedance curve and the as-if history, the pricing loads and credibility weights, the sidecar, the retro cover, the segments and the capital figures. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook54 KBAppendix B
Submission review checklist, treaty wording checklist, facultative certificate checklist, quota share terms checklist, sliding scale and profit commission checklist, excess of loss structure checklist, reinstatement and event checklist, as-if loss data checklist, catastrophe model output checklist, technical price sign-off checklist, firm order and signed lines checklist, claims payment and netting checklist, retrocession and sidecar checklist, collateral release checklist, solvency and risk appetite checklist and results and ratios checklist.
Download the toolkit39 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| Corbelle’s quota share | A 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 program | A 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 sidecar | It 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.
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.