For many sustainability, finance, and risk teams, scenario analysis is one of the tougher new pieces of climate disclosure. It asks you to model how different climate futures could impact your business, both financially and operationally - and for most teams, that’s easier said than done.
To make the process simpler, we’ve created a free, structured Excel tool to guide you: the Climate Scenario Analysis Template. It's designed to help you meet new reporting requirements like AASB S2 and RG 280 while actually adding value to your internal decision-making.
The Climate Scenario Analysis Template is a practical workbook built for companies navigating scenario analysis for the first time. It gives you a way to think through the key drivers that will shape your future risk and resilience: emissions, carbon pricing, capital expenditure needs, and EBITDA, all modelled against three internationally recognised climate pathways.
The template covers:
It’s designed to reflect the expectations of AASB S2 and ASIC’s RG 280 guidance, particularly the requirements around using multiple, plausible scenarios and quantifying financial impacts where possible. The goal? To make sure you’re not just ticking a compliance box, but actually generating insights that your business can use.
We’ve structured the workbook around four core steps that mirror a robust scenario analysis process:
First, the Company Setup tab lets you enter your organisation’s starting point: emissions, EBITDA, and capital expenditure inputs. These baseline figures flow through the rest of the workbook.
Next, the Scope Definition step helps you define the boundaries of your analysis — which regions, emissions scopes, and operational units you’re including. Clear scoping is critical for transparency and repeatability.
In the Scenario Selection step, you’ll choose from pre-populated climate pathways based on public models. Each scenario is already calibrated to a known global framework, saving you time and reducing guesswork.
Finally, the Impact Analysis section calculates and visualises how your carbon costs, capital investment needs, and EBITDA could shift under each scenario. You can edit assumptions directly within each scenario tab, tailoring the model to reflect your industry realities and strategic priorities.
Every piece of the template is built to be editable and transparent — so you can document assumptions, justify choices, and build a shared understanding across your team.
Scenario analysis under AASB S2 isn’t just another reporting exercise. It’s a crucial part of preparing your business for an uncertain future.
By using structured scenarios to stress-test your financials, you help decision-makers understand where climate-related risks and opportunities could arise — and how they could affect strategy, investments, and operations.
Done well, scenario analysis helps teams to:
Especially in your first year of scenario analysis, the priority is to be complete and coherent, not perfect. Regulators and investors understand that precision will improve over time. What matters most is building a defensible, transparent foundation now.
Our Climate Scenario Analysis Template is designed to help you do exactly that — and to give you a practical head start without getting bogged down in unnecessary complexity.
You can download the free Climate Scenario Analysis Template at the link below: