Portfolio Climate Heatmap Calculator

Build a heatmap from holdings, weights, and intensity. Spot transition and physical risks instantly here. Make smarter allocation choices with transparent climate scoring now.

Calculator

Add holdings, set options, then calculate a portfolio heatmap.
Download CSV template

Controls what appears in the sector × region grid.
A stylized multiplier for strategy/policy alignment.
Longer horizons slightly increase forward-looking stress.
Use weights or investable amounts per holding.
Recommended for consistent portfolio metrics.
Imports columns: Asset, Weight, Sector, Region, EmissionsIntensity_tCO2e_per_$M

Holdings
Add rows as needed. Empty asset names are ignored.
Use decimals; auto-normalize is recommended.
Tip
Use sector-appropriate intensity values for comparability.
Use decimals; auto-normalize is recommended.
Tip
Use sector-appropriate intensity values for comparability.
Use decimals; auto-normalize is recommended.
Tip
Use sector-appropriate intensity values for comparability.
Use decimals; auto-normalize is recommended.
Tip
Use sector-appropriate intensity values for comparability.
Use decimals; auto-normalize is recommended.
Tip
Use sector-appropriate intensity values for comparability.

Advanced settings: sector benchmarks
Values are tCO2e per $M revenue. Defaults are illustrative.
Advanced settings: region multipliers
Multipliers affect physical-risk and temperature adjustment.

Example holdings data

These sample rows match the CSV template and the default form seed.

Asset Weight Sector Region Emissions intensity (tCO2e/$M)
Alpha Energy Co 0.20 Energy North America 1100
Beta Utilities 0.15 Utilities Europe 520
Gamma Industrials 0.25 Industrials Asia Pacific 210
Delta Tech 0.25 Information Technology North America 35
Epsilon Consumer 0.15 Consumer Staples Latin America 140

Formula used

This tool uses a transparent, simplified scoring approach for education and screening.

1) Intensity ratio

Each holding is compared to its sector benchmark.

ratio = intensity / sectorBenchmark

2) Temperature score (stylized)

Temperature increases with emissions intensity, adjusted for alignment, horizon, and region.

tempBase = 1.5 + 0.85 × ln(1 + ratio)
temp = clamp(tempBase × alignment × horizon × physicalAdj, 1.0, 5.0)
Where physicalAdj = 1 + 0.06 × (regionFactor − 1).

3) Risk scores (0–100)

Transition risk grows with ratio; physical risk uses a region multiplier.

transition = clamp(18 + 55 × ratio^0.55, 0, 100)
physical = clamp(10 + 75 × ((regionFactor − 0.75) / 0.60), 0, 100)
combined = 0.62 × transition + 0.38 × physical

4) Portfolio rollups

Portfolio temperature is a weight-average of holding scores.

portfolioTemp = Σ (wᵢ × tempᵢ)
Important: Benchmarks and multipliers are illustrative defaults. Replace them with your preferred datasets for decision-grade analysis.

How to use this calculator

  1. Choose a heatmap metric (temperature, intensity, or risk).
  2. Set alignment and horizon to match your reporting view.
  3. Enter holdings with weights or amounts and emissions intensity.
  4. Optionally adjust sector benchmarks and region multipliers.
  5. Press Calculate heatmap to view results above the form.
  6. Use Download CSV or Download PDF for exports.

Portfolio heatmap value for investment teams

This calculator converts holding‑level climate indicators into a sector × region view that highlights concentration risk. It estimates an implied temperature score (1.0–5.0°C) and risk indices (0–100) so analysts can compare exposures across portfolios, mandates, or sleeves. Use it to identify where rebalancing, engagement, or data improvement efforts can deliver the biggest reduction in portfolio temperature and combined climate risk. It is best for screening and prioritization, not final valuation decisions.

Inputs that drive climate hotspots

Each holding needs a name, weight (or amount), sector, region, and emissions intensity (tCO2e per $M revenue). The tool compares intensity to a sector benchmark to create an intensity ratio. Higher ratios increase transition risk and temperature scores. Region multipliers influence physical risk and slightly adjust temperature, reflecting differing exposure to heat, flooding, drought, and storms. Alignment and horizon settings provide a simple forward‑looking stress view.

Benchmarks, normalization, and sensitivity controls

Default sector benchmarks include Energy 900 and Utilities 650 tCO2e/$M, with lower levels such as Information Technology 55. You can replace any benchmark with your preferred dataset to match industry classifications. Auto‑normalize converts raw weights or amounts into a consistent 100% basis, ensuring portfolio rollups and heatmap cell weights remain comparable across submissions, and peer comparisons later.

Interpreting cells, bands, and contributors

The heatmap shows a weighted average metric inside each sector‑region cell, plus the cell’s portfolio weight share. For temperature, Low is ≤2.0°C, Medium is ≤3.0°C, and High is >3.0°C; for risk metrics, bands shift to 35 and 65. The Top Contributors list ranks holdings by weight × temperature to surface outsized drivers even when their intensity is moderate. Empty cells display a dash, indicating no mapped exposure.

Reporting outputs and governance workflow

Exported CSV files capture the full asset table, portfolio summary, and heatmap cells for audit trails and model review. The PDF provides a compact summary for committee packs, client reporting, or internal controls. Combine outputs with a data log describing source intensity values, benchmark choices, and any overrides so repeat runs remain traceable and consistent with ESG policy.

FAQs

Quick answers for common implementation and interpretation questions.
Q1. What does the temperature score represent?

It is a simplified implied temperature alignment indicator derived from emissions intensity versus a sector benchmark, adjusted by alignment, horizon, and region multipliers. It helps compare holdings consistently, but it is not a forecast of global temperature outcomes.

Q2. How should I choose emissions intensity values?

Use a consistent source across holdings, ideally the same scope boundary and revenue definition. If intensity is unavailable, use a sector proxy and document it. Update values periodically so trends reflect improvements, divestments, or corporate actions.

Q3. Why do my weights not sum to 100%?

If auto-normalize is enabled, the calculator scales all entered weights or amounts to a 100% basis internally. If it is disabled, results use your raw totals and will still compute averages by converting to proportional weights for rollups.

Q4. Can I replace the default sector benchmarks?

Yes. Open Advanced settings and tick custom sector benchmarks. Enter values that match your taxonomy and data provider, then recalculate. Benchmarks strongly influence ratios and transition risk, so align them with your reporting standard and version them.

Q5. How is the heatmap cell value computed?

For each sector and region, the tool computes a weighted average of the selected metric using the holdings mapped to that cell. The displayed weight is the cell’s share of the portfolio after normalization, enabling quick concentration checks.

Q6. What do CSV and PDF exports include?

CSV exports include the portfolio summary, full holding table, and all heatmap cells so you can audit calculations and build charts. The PDF is a one‑page snapshot with key portfolio metrics and top contributors for quick review.

Related Calculators

Climate Risk HeatmapTransition Risk HeatmapESG Risk HeatmapClimate Exposure MapClimate Hazard HeatmapEnterprise Climate HeatmapSupply Chain HeatmapHeat Stress HeatmapDrought Risk HeatmapStorm Risk Heatmap

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.