Week 4 of 6, Climate Work Residency

Materiality and initiatives

Which climate exposures at Northwood's ten companies actually move what a buyer pays, and what should Northwood do about them first?

$13.5MExpected (chance-weighted) loss a year across the ten companies, taking customer carbon-data requests at full loss of the exposed revenue ($9.0M if half is lost, a Kith illustration); $7.9M sits on earnings in hand and $5.6M on revenue not yet won
5 of 46Exposures large enough to act on (the 10 carbon-price scenarios are left out)
$117KAbout the total cost of answering all sized customer carbon-data requests; it reduces expected loss by $4.4M a year if half the exposed revenue would otherwise be lost, and by up to $8.7M if all of it would (chance-weighted, a Kith illustration)

Highlights

Client deck

The answer on page 1, then where the exposure sits, what to do first and how far to trust each figure.

Open (opens in a new tab)

Explorer

A reader can move the exit year and the thresholds and watch the ranked backlog and the matrix change.

Open (opens in a new tab)

Materiality matrix and initiatives

Every exposure placed against Northwood's own cut-offs, with the ranked initiatives, their cost and payback.

Open (opens in a new tab)

The case

Northwood needed to know which climate exposures matter to EBITDA (operating earnings) and exit price, in dollars. I connected each company's Week 3 footprint to its financials, sized six exposures per company, placed them on a materiality matrix and ranked 18 initiatives.

The ten companies carry $13.5M a year of expected loss, and three of them hold about 75% of it. Only 5 of 46 exposures are large enough to act on. The cheapest fix is answering customers' carbon-data requests, which costs about $117K against $4.4M to $8.7M a year of expected loss reduced, depending on how much exposed revenue would otherwise be lost.

All deliverables

Each opens in a new tab, in the Kith Climate style it was delivered in.

Data and method

The method notes, data and re-run steps that let the client reproduce the work without us.

Show all 14

How it was built

My part

  • I set the scope and order of work: do the five brief deliverables first, treat the brief's numbers as illustrative and take financials from the data room.
  • I fixed the report date, the financial basis and which outside datasets could be downloaded.
  • I approved recording conflicting monthly figures as they stand rather than resolving them.

The AI's part

  • Claude built the connected dataset, the exposure model, the matrix, the ranking and the explorer, using 24 scripts run in a fixed order.
  • Claude wrote the check scripts and the tests that try to break them.
  • Claude ran the independent reviewers, applied their fixes, and found that two tests named superseded files and so could not fail.
  • Reviewers caught that Ridgeline's $120,000 hail loss belonged to the building owner, and that one saving used an unnamed fuel price instead of the signed one. Both were corrected.

Across the engagement

From Week 3. Week 3's carbon inventory supplied each company's Scope 1 and 2 footprint (direct emissions plus purchased energy), carried over unchanged, and its financial basis. Week 4 put dollars next to it.

Into Week 5. The exit timing and hold years here fed Week 5's physical-risk model. Note the two expected-loss headlines differ in scope: $13.5M a year here covers all exposure lines including customer what-ifs, while Week 5's $6.04M a year is physical hazards only. Week 6 later found the 'carbon' column in the data files is mostly the customer line, which the data guide now says.

Week 3: Carbon inventory and ESG scorecardWeek 5: Physical climate risk