Book · Julian R. Sterling
A Practitioner's Guide for Risk Managers, CISOs and CFOs: FAIR Analysis, Calibrated Estimates, Monte Carlo Simulation, Loss Exceedance Curves, Control ROI, Cyber Insurance Limits and SEC Materiality
Most boards still see cyber risk as a red square on a heat map. A CFO cannot budget a red square, an insurer does not price one, and a disclosure committee cannot decide whether an incident is material from one. Cyber risk quantification replaces the colors with what every other risk already uses: how often a loss is likely to happen, how large it could be, and the probability of a year worse than the company can tolerate.
The Cyber Risk Quantification Handbook builds that method end to end on one fictional company, Halden Marsh Industries, Inc., a US-listed manufacturer with 11 plants and $1,850,000,000 of budgeted revenue. Five loss scenarios, from ransomware stopping the plants to an engineer copying design files, are estimated with calibrated ranges, decomposed with the FAIR model and simulated over 1,000 years. The result: an annual loss expectancy of $5,016,300, a 1-in-20 year of $20,906,669 and a 1-in-100 year of $45,214,845, which breaches the board's tolerance before insurance. The book then uses the curve for the decisions that matter: which of three controls pays for itself, which retention and limit to buy at the January renewal, and how fast a materiality call can be made when ransomware stops seven plants. Rules are described in principle as read in November 2026.
Every figure below is computed by the book's model and reproduced in the companion workbook. The company, its scenarios, premiums and incident are fictional teaching assumptions.
| Item | Value |
|---|---|
| Portfolio annual loss expectancy (five scenarios) | $5,016,300 |
| Median year | $1,505,535 |
| 95th percentile (1 year in 20) | $20,906,669 |
| 99th percentile (1 year in 100) | $45,214,845 |
| Ransomware scenario ALE (simulated) | $1,639,809 |
| Analytic ALE of the five scenarios | $4,808,939 |
| Probability of a year above $40 million, gross / net of insurance | 1.2 percent / 0.4 percent |
| Expected insurance recovery against the premium | $2,238,423 against $2,550,000 |
| Net 95th percentile after insurance | $12,767,404 |
| Three controls together: annual cost and ALE after | $2,180,000 and $3,147,774 |
| Ransomware incident, day-3 midpoint gross loss | $13,944,603 |
| 5 percent of pre-tax income (starting point only) | $8,600,000 |
The live Excel workbooks behind every table in the book. Blue inputs, black formulas, stored random numbers so every trial is reproducible, and a Checks tab that must read zero. No sign-up required for book readers.
Appendix A, chapters 2 to 14
Ten tabs: README, Inputs, Parameters, Uniforms, Simulation, Results, Control_ROI, Incident, Heat_Map and Checks. The Simulation tab recomputes all 1,000 trials of the five scenarios.
Download Cyber_Risk_Workbook.xlsx1064 KBStandalone practitioner tool
One scenario, 1,000 simulated years: threat event frequency and vulnerability as minimum, most likely and maximum, primary and secondary loss as 90 percent ranges, a retention and a limit. Prefilled with the ransomware scenario: ALE $1,639,809, 95th percentile $14,546,698.
Download Cyber_Risk_Monte_Carlo_Model.xlsx231 KBWant the model first? Open the free Cyber Risk Monte Carlo Model page for the worked example and the Excel download.
Related titles. Full list on the author page.