Week 5: Physical climate risk

Reading view of a Markdown deliverable, shown as delivered. Download the Markdown file.

Physical climate risk for Northwood: method note (v1)

This note explains how the Week 5 physical-risk figures are built, so that Northwood can check, update or re-run them without Kith. It goes with the dashboard (my-work/week-5/fund-level/physical-risk-dashboard-v1.html), the assumption ledger (my-work/week-5/fund-level/leave-behind/assumption-ledger-v1.csv), the reference-data index (my-work/week-5/fund-level/leave-behind/reference-data-index-v1.csv), the result files in data/, and the re-run note (my-work/week-5/fund-level/leave-behind/re-run-note-v1.md). Every number on the dashboard is a row in one of those files; this note does not restate them.

1. What question each figure answers

The work answers Sarah Mitchell's three investment-committee questions for all ten portfolio companies:

  1. What could one bad event cost before exit? Gross loss in a named event, who pays it (insured, retained, next renewal), and what it does to covenant headroom.
  2. What does physical risk cost on average each year, and is that rising? Expected loss over each company's hold, and the recurring cost at exit on today's climate and on the buyer's horizon.
  3. Will the companies stay insurable at an acceptable price? The premium path above a 3% non-climate trend, in the current and a hardened market, and the retained loss a captive could pool.

For each material risk the lever library gives a dollar value protected, a cost, the timing against the exit date, and a named Northwood owner.

2. Dating convention

3. The chain: hazard, exposure, vulnerability, cost

The analysis starts from what each company depends on, not from hazard scores.

Vulnerability register. One row per dependency: each own site, each supplier, each client base, the workforce where heat matters, and shared infrastructure (Bowling Green's water). Each row carries:

The data room's 1 to 5 hazard scores are the "before" picture only.

Hazards and regions. There are seven hazards: hurricane, flood, winter and ice, extreme heat, wildfire and smoke, drought, and severe convective storms. There are six regions: Gulf coast, Southeast Atlantic, Central Valley, Southwest, Mountain West, and Ohio Valley and Mid-Atlantic.

Exposure rules.

Vulnerability.

Cost. Loss is contribution never recovered, plus the cost of recovery.

4. Who pays

No insurance schedules are in the data room (data request DR-1), so each company has a programme synthesised by rule (A-17 to A-21):

A hardened-market toggle doubles deductibles, sets the named-storm deductible to 5%, halves flood sublimits and removes contingent cover. After a claim, the next renewal steps up by 10 to 25% (A-23).

Insured and retained each report their own range, because cover only triggers in the worse cases. Gross = insured + retained holds within each case.

Covenants.

5. Recurring cost and exit value

Recurring cost a year at exit is the sum of four parts:

It is shown on two horizons: the hold, to each exit, and the buyer's horizon (about 2035 to 2040). It is also multiplied by each company's exit multiple, as value a buyer may normalise away. One-off event cash and recurring cost times the multiple are always shown apart.

6. Presets, the do-nothing figures and the builder

Presets. Seven presets are fixed settings of the same engine:

  1. Gulf landfall
  2. Southeast Atlantic landfall
  3. Sterling superalloy supplier outage, 26 weeks (D-5-67)
  4. Central Valley drought, two seasons
  5. Ohio Valley and Mid-Atlantic winter storm
  6. Southwest heat summer
  7. Hold-period "do nothing"

The do-nothing preset shows two figures that are never added together:

The builder reads a precomputed grid. Hazard-led settings cover hazard × region × severity × length × market (768 plausible settings). Dependency-led settings cover each site and supplier × 2 to 26 weeks × market (2,020 settings). The page looks results up and does no arithmetic of its own (D-5-12).

7. Calibration

Nine events the companies reported for 2023 to 2026 were replayed through the engine with their actual sites, hazard, storm length and a severity fixed before the replay (1-in-10). Modelled lost-plus-delayed revenue was compared with the reported figure. A pass is 0.5 to 2 times (A-33). The results are in my-work/week-5/fund-level/leave-behind/data/calibration-groups-v1.csv.

An independent check (my-work/week-5/checks/chk_calibration_band.py) re-derives every replayed figure without using the engine.

8. Levers

Each lever in my-work/week-5/fund-level/leave-behind/data/levers-v1.csv names the input it changes and a cost range (A-35 to A-39, A-50; Akron's HVAC cost is seeded). The engine is re-run with each lever applied, for the lever's companies only (my-work/week-5/fund-level/leave-behind/data/lever-results-v1.csv).

For each lever:

Two portfolio overlays sit beside the levers:

9. How far to trust it

10. Limitations