Week 5: Physical climate risk

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

Week 5 data requests to Northwood (v2, 2026-10-16: v1 as frozen at G1, plus DR-10 and DR-11 (D-5-56), DR-12 (D-5-58), DR-13 (D-5-71), DR-7 narrowed (D-5-49) and DR-8 partly answered (D-5-50))

The gaps the physical-risk analysis names, in priority order. Each one is covered for now by a synthesised or assumed input (data-plan id in brackets). Iterate this list as the build proceeds: add rows, re-rank, and record when a request is answered. Nothing here has been sent to Northwood; any send needs Daniel's explicit permission.

idRequestWho likely holds itWhy it mattersCovered for now byStatus
DR-1Insurance schedule per company: property and BI limits, deductibles (incl. named-storm percentage deductibles), BI waiting periods, contingent BI cover, exclusions, renewal datesCompany CFOs or Northwood's brokerDecides the insured vs retained split for every scenario; the core of the insurance themeSynthesised typical programme (DP-F4)open
DR-2Sterling: superalloy (Inconel 718) safety stock, and time and cost to qualify an alternate supplierSterling operations and procurementSizes the headline dependency scenario; likely the weakest assumptionLiterature range (DP-V5)open
DR-3Revenue by site, and property and contents values by siteCompany financeDrives BI and damage losses at site levelAllocation by headcount and type (DP-E5); benchmark cost per sq ft (DP-E6)open
DR-4Lease terms for leased sites: who rebuilds, who pays deductibles, rent abatementCompany finance or legalDecides who bears damage at leased service sitesProposed assumption, not yet agreed: tenant bears contents, landlord bears structureopen
DR-5Supplier lists for the eight companies without one (spend, share, location, alternates)Company procurementReplaces the synthetic supplier layersSynthesised layers (DP-E3)open
DR-6Backup power and water storage inventory by siteCompany operationsAdaptive capacity; decides downtime under grid or water failureQuestionnaire statements only (DP-V4)open
DR-7Covenant terms (maintenance tests and thresholds) for the seven companies without them in the data room (all but Sterling, Trident and NovaCare)Northwood deal teamsConverts losses into covenant headroom and deal riskTypical maintenance covenant (A-32); seeded for three companies (D-5-49)open, narrowed
DR-8Ridgeline: claims history for the managed properties, and street addresses (see DR-10)RidgelineRidgeline's main exposure runs through its clients' assetsProperty register found in the data room: 20 properties with value, fee, premium, deductible structure (D-5-50)partly answered by the data room
DR-9Ridgeline: the Las Vegas office (opened January 2025), to be added to the facility fileRidgelineMissing site in the seeded dataAdded from the questionnaire descriptionopen
DR-10Street addresses for the 62 points the data room places only by city: 35 suppliers (Sterling, Harvest Ridge), 20 Ridgeline managed properties, Ridgeline's Las Vegas office, 6 pipeline sitesSterling and Harvest Ridge procurement; Ridgeline; Northwood deal teams for the pipelineFlood zone and site hazards cannot be set from a city aloneFlood status unknown, carried as a range from not in zone to in zone (D-5-56)open
DR-11Flood zone determinations and flood cover for the 13 sites where the FEMA map and the company's statement disagree: NovaCare (8 clinics the map puts in AE or VE), Clearview Cincinnati (AE), Patriot Memphis and Jackson (stated AE, map none), Pinnacle Beaumont and PasadenaCompany CFOs and their brokersA site believed to be outside a flood zone may carry no flood cover; decides retained flood lossRange from not in zone to in zone; client finding (D-5-56; my-work/week-5/methodology/site-location-investigation-v2.md)open
DR-12Patriot: is the Louisville branch (PSS-006) open? The submitted carbon template says it closed in August 2025; the questionnaire and org chart list itPatriot finance or operationsDecides whether about $10.8M of allocated revenue is exposed at the siteKept open; low case $0 (D-5-58)open
DR-13Keystone: revenue lost per clinic closure day (or billed hours per clinic-day), and how the January 2025 figure of about 120 cancelled sessions was countedKeystone finance or clinical operationsThe session count implies about a third of the revenue per clinic-day that Keystone's reported revenue implies; decides how much a closure day costs Keystone and NovaCare-type clinic businessesClinic revenue at risk from the spine revenue; the event is excluded from the calibration pass test (D-5-71)open