# The Catastrophe Bond Investor: companion files

Julian R. Sterling

## What is here

- **Catastrophe_Bond_Investor_Model.xlsx**: the workbook that rebuilds the Thornmere Cat Bond Fund case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Coupon and IRR, Layer Expected Loss, Parametric Tiers, Pricing and Multiples, Secondary Spread, Portfolio Buckets, Scenarios, VaR and TVaR, Aggregate Loss, Fund Returns, Checks.
- **Catastrophe_Bond_Investor_Toolkit.docx**: the fourteen checklists of Appendix 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, investor reporting checklist), in editable form.

## Which sheet answers which chapter

- Chapter 5: Coupon and IRR (Galecrest: a spread of 4.75 percent plus a collateral yield of 4.10 percent, a first-year coupon of 8.85 percent, $3.54 million a year on the fund's $40.0 million, an IRR of 9.01 percent with no loss)
- Chapter 8: Layer Expected Loss (an attachment probability of 2.10 percent and an exhaustion probability of 1.00 percent give an expected loss of 1.48 percent; Orrisdale 2.62 percent)
- Chapters 6 and 8: Parametric Tiers (the four Quillhaven tiers: attachment probability 2.00 percent, exhaustion probability 0.70 percent, expected loss 1.35 percent)
- Chapter 9: Pricing and Multiples (multiples of 3.20x, 2.78x and 2.86x)
- Chapter 10: Secondary Spread ($5.0 million of Quillhaven at 100.75, 3.12 years before maturity: an approximate spread of 3.51 percent)
- Chapter 11: Portfolio Buckets ($1,217.5 million of bonds at 1 January 2026, US named storm 45.4 percent of net asset value against a limit of 55.0 percent, expected return net of losses and fees 5.70 percent)
- Chapter 12: Scenarios, VaR and TVaR (99 percent VaR $174.50 million, 99.5 percent VaR $311.75 million, 99 percent TVaR $256.85 million)
- Chapter 14: Aggregate Loss (Orrisdale: an index of $61.0 billion in a $55.0 billion to $75.0 billion layer, a loss of 30.0 percent, $7.5 million for the fund)
- Chapter 15: Fund Returns (7.50 percent in 2025 and 5.38 percent in the first nine months of 2026; net asset value per share 107.50 and 113.29)

## Two inputs to change first

1. On Inputs, change the final Orrisdale index value: watch the loss fraction, the fund's write-down and the face still at risk move on Aggregate Loss, then the 2026 spread income on Fund Returns.
2. On Inputs, double the probability of the two-Florida-hurricane scenario: watch which tail measure moves on Scenarios, VaR and TVaR. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Thornmere Risk Partners, Thornmere Cat Bond Fund, Galecrest Re, Quillhaven Re, Orrisdale Re and their sponsors are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not investment, legal, tax or insurance advice.
