Identifying firms with the highest and lowest transition risk

[AnneSchoenauer]

Dear @kalashsinghal

could you please provide a bar chart for the transition risk indicator:

• only for GER firms
• for benchmark NZ 2030 tilt subsector unit
• for equal weight, best case and worst case

could you please provide a table that shows the average transition risk for all tilt subsectors, please use

• only GER firms
• for benchmark NZ 2030 tilt subsector unit
• for equal weight, best case and worst case

Can you then choose the tilt subsector for each equal weight, best case and worst case scenario that has the highest transition risk average. Can you then for this tilt subsector identify

• 20 firms in the 10% highest transition risk percentile
• 20 firms in the 10% lowest transition risk percentile

Please provide a csv with these firms. Please provide for each firm their

• products and
• the transition risk for the products.
• Please also provide the COV on firm level.
  As we have three scenarios: equal weight, best case and worst case we will have three csv with 40 firms each.

Thanks!
All the best
Anne

[kalashsinghal]

could you please provide a bar chart for the transition risk indicator:
only for GER firms
for benchmark NZ 2030 tilt subsector unit
for equal weight, best case and worst case

Hi @AnneSchoenauer,
It's a bit unclear how you want these bar charts. Do you want 3 bar charts of best case, worst case, and equal weight which all are from Germany and also are for benchmark NZ 2030 tilt subsector unit. Or do you want bar charts for all the cases for Germany, and all the bar charts of all coiuntries for benchmark NZ 2030 tilt subsector unit ?

Does these bar charts look fine to you?

Or would you like something else for the above case?

[AnneSchoenauer]

This looks great! :)

[AnneSchoenauer]

Can you then continue with the bullet points thereafter?

[kalashsinghal]

could you please provide a table that shows the average transition risk for all tilt subsectors, please use
only GER firms
for benchmark NZ 2030 tilt subsector unit
for equal weight, best case and worst case

Hi @AnneSchoenauer,

Does this table looks fine to you?

[AnneSchoenauer]

Hi @kalashsinghal this table looks perfect!

Could you please choose from this table the following tilt_subsector and follow up with this here:

• other industry
• other metals
• chemicals
• iron & steel

Can you then for this tilt subsector identify

20 firms in the 10% highest transition risk percentile
20 firms in the 10% lowest transition risk percentile
Please provide a csv with these firms. Please provide for each firm their

products and
the transition risk for the products.
Please also provide the COV on firm level.
As we have three scenarios: equal weight, best case and worst case we will have three csv with 40 firms each.

When you are done with this above could you repeat this exercise with the benchmark:

• IPR, 1.5, tilt subsector unit?

And then after creating the averages for each tilt subsector choose the subsectors:

• agriculture and landuse
• machinery and equipment

[kalashsinghal]

Hi @AnneSchoenauer,

As per your request, PFA the csv files of product and company level results for benchmarks NZ 2050_2030_unit_tilt_subsector and benchmark 1.5C RPS_2030_unit_tilt_subsector!

transition_risk_company_15C_RPS_2030_unit_tilt_subsector.xlsx
transition_risk_company_NZ_2050_2030_unit_tilt_subsector.xlsx
transition_risk_product_15C_RPS_2030_unit_tilt_subsector.xlsx
transition_risk_product_NZ_2050_2030_unit_tilt_subsector.xlsx

[AnneSchoenauer]

Great! From the tables this looks perfect.

Can you also create for the benchmark 15C_RPS_2030_unit_tilt_subsector and 15C_RPS_2050_unit_tilt_subsector this one here:

could you please provide a bar chart for the transition risk indicator:

• only for GER firms
• for benchmark NZ 2030 tilt subsector unit
• for equal weight, best case and worst case

could you please provide a table that shows the average transition risk for all tilt subsectors, please use

• only GER firms
• for benchmark NZ 2030 tilt subsector unit
• for equal weight, best case and worst case

After this the ticket can be closed.

[kalashsinghal]

Can you also create for the benchmark 15C_RPS_2030_unit_tilt_subsector and 15C_RPS_2050_unit_tilt_subsector this one here:

Hi @AnneSchoenauer,

The bar charts present in this comment includes the benchmarks 1.5C RPS_2030_unit_tilt_subsector and 1.5C RPS_2050_unit_tilt_subsector. The tiltsubsector tables for these benchmarks are:

1. 1.5C RPS_2030_unit_tilt_subsector

2. 1.5C RPS_2050_unit_tilt_subsector

Are these results fine?

[AnneSchoenauer]

Yes perfect! I close the ticket now!

[AnneSchoenauer]

@kalashsinghal could you please update this table here: #819 (comment) based on what we discussed for the emission rank here: #820