Week 5: Physical climate risk

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

Re-running the physical-risk analysis next quarter (v1)

This note is for an analyst at Northwood with no Kith access. It covers what to update, the order to run the scripts in, and how to check the result. The method is in my-work/week-5/fund-level/leave-behind/method-note-v1.md.

What you need

What to update each quarter

InputWhereWhy it matters
Revenue, EBITDA, debt, exit multipledata/northwood-capital/_data/spine/csv/portfolio_companies.csv and portco_financials.csvEvery dollar figure, the covenant headroom and the exit-value lines
Exit timingmy-work/week-4/fund-level/exposure-lines-v6.csv (n_years)Hold years, lever timing
Report dateManifest setting report_date (set with kit_tools.py bump-manifest)Hold periods. While it is unset, outputs are marked provisional
Premiums and insurance schedulesData request DR-1; then the premium history in my-work/week-4/methodology/d2-inputs-v4.csv and the programme rules A-17 to A-21 in my-work/week-5/methodology/engine-parameters-v1.csvInsured, retained and renewal split; recurring premium cost
New weather events the companies reportAdd a row to my-work/week-5/methodology/calibration-events-v1.csv with its file, line and verbatim quoteKeeps the calibration current
Answers to data requestsmy-work/week-5/fund-level/leave-behind/data/data-requests-v2.md here; the live list is my-work/week-5/fund-level/data-requests-v2.mdNarrows the ranges
Assumptionsmy-work/week-5/methodology/engine-parameters-v1.csv (numbers) and assumptions-register-v2.csv (basis)Change a number only with a recorded decision, and keep low ≤ central ≤ high by loss

Public hazard data only needs re-fetching when its source publishes a new release. The vintages are in my-work/week-5/fund-level/inputs/fetched/fetch-log-v1.csv, climate-fetch-log-v1.csv and downloads-log-v1.csv; the last of these lists each download's link and sha256.

Order of the scripts

All scripts are in my-work/week-5/pipeline/.

StepScriptWrites
1fetch-public-sources-v2.py, fetch-climate-cmra-v1.py (only for a new data release)my-work/week-5/fund-level/inputs/fetched/
2extract-downloads-v1.py, extract-hazus-valuation-v1.py (only after new downloads; pass the download folders as arguments, and run with python3 -I)NOAA, Hazus and FAST extracts
3build-join-key-map-v1.py, build-site-flood-status-v2.pyJoin keys, flood status by site
4build-synthesis-v1.pySite exposure, supplier layers, logic notes
5build-register-v1.pyVulnerability register, regions, plausibility
6engine-v1.pyGrid, presets, stack, expected loss, register v2 (ranked)
7replay-calibration-v1.pyCalibration replay and groups
8levers-v1.pyLever results, captive flag, Target B screen
9sensitivity-v1.pymy-work/week-5/fund-level/leave-behind/sensitivity-v1.csv
10build-dashboard-v1.pymy-work/week-5/fund-level/physical-risk-dashboard-v1.html and its data file
11build-leave-behind-v1.pyAssumption ledger, reference-data index, data/ copies, lineage

If only financials, the report date or assumptions changed, start at step 6.

How to check the result

  1. Run the checks for the Results gate: `` python3 my-work/framework/kernel-v2/kit_tools.py --week-dir my-work/week-5 check --gate G2 --dry `` These checks matter most:
  2. calibration-band: every tested event within 0.5 to 2 times;
  3. page-matches-grid: the page shows exactly what the engine wrote;
  4. page-script-syntax;
  5. checks-independent;
  6. lint.
  7. Run the seeded tests: `` python3 my-work/week-5/pipeline/test-calibration-band-v1.py python3 my-work/week-5/pipeline/test-page-checks-v1.py `` Each must end "ALL SEEDS CAUGHT". They show the checks still catch a corrupted input or output.
  8. Open the page in a browser. Check that the draft banner is gone once the report date is set.
  9. Record what changed in the week's record:
  10. each run cited in a journal entry;
  11. each decision in the decision log, in the decider's words;
  12. each in-place edit in my-work/week-5/record/changelog-v1.csv.

When a check fails