-
Excel workbook preview
Climate Targets, Risk and Transition (SBTi, TCFD)
Climate Scenario Analysis Workbook
3 downloads per free account, no card needed.
Who this is for
The person asked by the board, auditor or lender to show how resilient the strategy is under a 1.5°C, a disorderly and a hot house scenario.
What is inside
- Three contrasting scenarios (orderly 1.5°C, disorderly, hot house) with 10 assumptions each for 2030 and 2040
- Horizon switch: pick 2030 or 2040 and every effect recalculates
- 10 worked drivers: carbon cost, energy prices, demand shifts, flood loss, heat days, insurance, supplier carbon cost
- Effect = exposure x factor, live formulas, costs shown negative, worst case per driver
- Materiality threshold flags the drivers that matter for disclosure
- Summary with net effect per scenario, count of material drivers, largest negative driver and a bar chart
How to use it: Replace every yellow assumption on the Scenarios sheet with your own and record its source, then enter each driver's exposure on the Impacts sheet. Switch the horizon to see 2040.
Files & formats
- XLSXclimate-scenario-analysis-workbook-template.xlsx16 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the regulator or publisher.


