SFDR PAI Statement Workbook: 14 Mandatory Indicators (Annex I Table 1)
Originally published: 28/09/2026 08:33
Publication number: ELQ-73805-1
View all versions & Certificate
certified

SFDR PAI Statement Workbook: 14 Mandatory Indicators (Annex I Table 1)

Compute all 14 mandatory SFDR principal adverse impact indicators for investee companies, in the Annex I Table 1 format.

Description

Financial market participants that consider principal adverse impacts must publish a PAI statement every year by 30 June, in the Table 1 format of Annex I to Delegated Regulation (EU) 2022/1288. This workbook computes the 14 mandatory indicators for investee companies from a holdings register.

- Holdings register for up to 100 investees: current value of investment, enterprise value (Annex I definition), Scope 1, 2 and 3, revenue, and the flags and metrics behind indicators 4 to 14.
- PAI Statement sheet in the Table 1 layout: indicator, metric, Impact [year n] computed, Impact [year n-1] for your prior figure, Explanation and Actions columns for the narrative the regulation expects.
- Formulae verified against the regulation itself: GHG emissions attributed by current value over enterprise value; carbon footprint per EUR million invested; GHG intensity weighted by portfolio share over revenue. Every share-of-investments and weighted-average indicator built the same way and documented.
- Definitions sheet states the method for every indicator so an assurance provider can follow the working.

Pairs with the Bindler PCAF calculator, which uses the same enterprise value definition. Covers investee company indicators; sovereign and real estate tables are not included. Live formulas, no macros, no locked cells. Excel and Google Sheets.

This Best Practice includes
1 Excel workbook (.xlsx), sheets: Guide, PAI Statement, Holdings, Definitions and sources

Acquire business license for $149.00

Add to cart

Add to bookmarks

Discuss

Further information

Compute all 14 mandatory SFDR principal adverse impact indicators for investee companies from a holdings register.

You are a financial market participant publishing the annual PAI statement by 30 June.

You need the sovereign or real estate indicator tables; this covers investee companies.


0.0 / 5 (0 votes)

please wait...