# The Cyber Risk Quantification Handbook: companion files

Julian R. Sterling. Companion page: julianrsterling.com/cyber-risk-quantification

1. **Cyber_Risk_Workbook.xlsx**: the ten-tab model behind every Halden Marsh Industries, Inc. figure in the book (fiscal 2027 plan, January 1, 2027 cyber insurance renewal, USD): README, Inputs, Parameters, Uniforms, Simulation, Results, Control_ROI, Incident, Heat_Map and Checks. The Simulation tab recomputes 1,000 simulated years for each of the five scenarios from stored random numbers; the portfolio ALE reads $5,016,300 and the 95th percentile $20,906,669. The Checks tab must read 0.
2. **Cyber_Risk_Monte_Carlo_Model.xlsx**: a standalone one-scenario Monte Carlo model (sheets README, Inputs, Uniforms, Simulation, Results): 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 scenario S1 (ransomware): it reads an ALE of $1,639,809 and a 95th percentile of $14,546,698. Replace the blue cells with your own scenario.

Blue cells are inputs, black cells are formulas, no circular references; the Uniforms sheets hold stored random numbers so that every result is reproducible. Open the files in Excel and let them calculate (about 38,000 formulas in the workbook: allow a few seconds). The company, its scenarios and every figure are fictional teaching assumptions. Rules described in principle as read in November 2026. Education only, not legal, securities, insurance or security advice.
