Pre-loaded with Meridian Industrial Holdings plc (Ireland FY2026: EUR 62,000,000 Net GloBE Income, EUR 7,750,000 Adjusted Covered Taxes, 12.50% ETR, EUR 10,150,000 SBIE, EUR 51,850,000 Excess Profit, EUR 1,296,250 QDMTT) and Apex Precision Corp. UTPR allocation. Overwrite the blue input cells with your own jurisdictional numbers.
Get the Excel calculator
One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
Pillar_Two_ETR_Top_Up_Tax_Calculator.xlsx (15 KB)
You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.
The book behind this calculator
The Pillar Two Handbook works through Meridian Industrial Holdings plc across six jurisdictions (EUR 5,289,900 total FY2026 Top-Up Tax), Apex Precision Corp. (UTPR 50/50 allocation and the 2026 Side-by-Side Safe Harbour), and Vanguard Sensors GmbH (Article 6 M&A PPA exclusion).
GloBE_ETR_Calculator: FANIL to Net GloBE Income bridge (Excluded Dividends, Policy Disallowed, SBC election, QRTC), Adjusted Covered Taxes, GloBE ETR, auto-lookup SBIE (2023 to 2033+), Excess Profit, Gross Top-Up Tax, and QDMTT offset.
CbCR_Safe_Harbour: Multi-jurisdiction tester for all three Transitional CbCR Safe Harbour tests (De Minimis, Simplified ETR at 15%/16%/17%, and Routine Profits) with automatic PASS / FULL GLOBE REQUIRED verdicts.
UTPR_and_SbS_2026: 50% employees / 50% tangible assets UTPR allocation pool with a 2026 Side-by-Side Safe Harbour switch showing foreign UTPR dropping to EUR 0 while foreign QDMTT remains payable.
SBIE_Schedule: Complete Article 9.2 transition table from FY2023 (10.0% / 8.0%) through FY2033+ (5.0% / 5.0%).