# The Reinsurance Professional: companion files

Julian R. Sterling

## What is here

- **Reinsurance_Professional_Model.xlsx**: the workbook that rebuilds the Lowmere Re case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Corbelle Quota Share, Sliding Scale Commission, Surplus and Stop Loss, Facultative Certificate, Veldhaven Program 2025, Event and Reinstatements, Burning Cost, Cat Model and Layer Loss, Technical Price 2026, Brisant Sidecar, Sidecar Trust, Retro Excess of Loss, Underwriting Year Results, Solvency and Capital, Checks.
- **Reinsurance_Professional_Toolkit.docx**: the sixteen checklists of Appendix 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, results and ratios checklist), in editable form.

## Which sheet answers which chapter

- Chapter 4: Facultative Certificate (a 2.8 percent rate on line on a layer of €150,000,000 in excess of €100,000,000; Lowmere's premium €420,000 for a line of €15,000,000)
- Chapter 5: Corbelle Quota Share, and the surplus illustration on Surplus and Stop Loss (ceded premium €120,000,000; Lowmere's result €6,300,000, a treaty combined ratio of 94.75 percent; risk C leaves €4,000,000 for facultative)
- Chapter 6: Sliding Scale Commission (a loss ratio of 63.5 percent cuts the commission from 32.0 to 30.25 percent; Corbelle owes Lowmere €2,100,000)
- Chapter 7: Veldhaven Program 2025, and the stop loss illustration on Surplus and Stop Loss (€300,000,000 in four layers above €30,000,000; Lowmere's premium €2,750,000; Lowmere's line of €41,000,000 above the €25,000,000 authority)
- Chapter 8: Event and Reinstatements (Layer 1 exhausted and €48,000,000 of Layer 2; €11,520,000 of reinstatement premiums; Lowmere pays €9,832,000 net and ends the program at minus €7,493,800)
- Chapter 9: Burning Cost (Layer 1: €7,600,000 a year, 19.0 percent of the limit)
- Chapter 10: Cat Model and Layer Loss (Layer 1: modeled expected loss €3,253,098, rounded; the windstorm at about 1 in 56 years, rounded)
- Chapter 11: Technical Price 2026 (Layer 1: technical rate on line 23.27 percent, rounded, against a firm order at 20.0 percent; Lowmere's 2026 premium €2,561,250)
- Chapter 13: Brisant Sidecar, Sidecar Trust and Retro Excess of Loss (investors' profit €18,615,000, 12.41 percent; €163,415,000 released on 30 June 2026; net 1-in-200 loss €100,000,000)
- Chapter 14: Solvency and Capital (solvency ratio 180.0 percent; 165.7 percent without the sidecar, rounded)
- Chapter 15: Underwriting Year Results (combined ratio 88.7 percent gross and 91.2 percent net, both rounded; cost of the retrocession €26,715,000; return on allocated capital 16.6 percent, rounded)

## Two inputs to change first

1. On Inputs, set Veldhaven's loss from the windstorm at €75,000,000, then at €160,000,000: watch the layers hit, the reinstatement premiums, Lowmere's net payment and the sidecar's recovery move together on Event and Reinstatements and Brisant Sidecar.
2. On Inputs, change Corbelle's loss ratio estimated at 30 September 2026: watch the commission on the scale, the adjustment and who pays whom on Sliding Scale Commission, then the proportional segment on Underwriting Year Results. 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.

Lowmere Re, Corbelle, Veldhaven, Brisant Re, Quenby Re Partners and every other name in the case are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case rates and figures are illustrative assumptions, not market data or benchmarks. Provided as is, without warranty. Not investment, legal, actuarial, accounting or tax advice.
