Companion files · The Private Markets Career Guides
How Insurance-Linked Securities Funds Really Work: Cat Bond Structures, Triggers and Basis Risk, Catastrophe Models and Expected Loss, Pricing, Portfolio Construction, Losses and the Career.
These are the companion files of the book. One workbook rebuilds the Thornmere Cat Bond Fund case: the Galecrest coupon, cash flows and IRR, the expected loss of a layer, the Quillhaven payout tiers, spreads and multiples, a secondary purchase, the portfolio by peril and region, the stress scenarios with VaR and TVaR, the Orrisdale aggregate loss and the fund’s results for 2025 and 2026. A toolkit holds the fourteen 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 5 to 15
One Inputs sheet holds every case assumption: the collateral path and fees, the terms of Galecrest, Quillhaven and Orrisdale, the payout tiers, the final index value and the marks, the nine portfolio buckets and the ten stress scenarios. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook43 KBAppendix B
New issue review checklist, offering circular reading checklist, trigger and basis risk checklist, catastrophe model review checklist, pricing checklist, sponsor due diligence checklist, collateral and trust checklist, portfolio limits checklist, scenario and stress test checklist, hurricane season checklist, event response checklist, loss determination checklist, valuation and marking checklist and investor reporting checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Galecrest, a Florida hurricane bond | An attachment probability of 2.10 percent and an exhaustion probability of 1.00 percent: an expected loss of 1.48 percent, a spread of 4.75 percent at 3.20 times expected loss, and an IRR of 9.01 percent if no storm touches the layer |
| Orrisdale, an aggregate bond | An industry index of $61.0 billion in a layer from $55.0 billion to $75.0 billion: 30.0 percent of principal written down, $7.5 million for the fund, $17.5 million of face still at risk |
| The portfolio at 1 January 2026 | $1,217.5 million of bonds (Orrisdale at its post-write-down face, by convention), a multiple of 2.75x, a 99 percent VaR of $174.50 million and a 99 percent TVaR of $256.85 million on the scenario set |
The files are provided as they are, without warranty of any kind. The model is illustrative: Thornmere Risk Partners and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, legal, tax or insurance advice.
More in credit and debt, 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.