Book · Julian R. Sterling

The Cyber Risk Quantification Handbook

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

About the book

Cover of The Cyber Risk Quantification Handbook

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.

Who it is for

What is inside

Introduction

Part I, From Heat Maps to Dollars

Part II, Estimating the Inputs

Part III, Running the Analysis

Part IV, Decisions

Conclusion and appendices

The Halden Marsh case in figures

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.

ItemValue
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 insurance1.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

Free companion files

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.

Download all files (ZIP)695 KB

Start with 00_START_HERE.md.

Want the model first? Open the free Cyber Risk Monte Carlo Model page for the worked example and the Excel download.

Worked articles from the book

Also by Julian R. Sterling

Related titles. Full list on the author page.