Free Excel Templates · US International Tax

Section 367 GRA, Intangible & All E&P Calculator

Unlocked five-tab Excel workbook modeling Section 367(a) outbound assets and GRAs, Section 91 branch loss recapture, Section 367(d) deemed royalties and T.D. 9994 repatriation, Section 367(b) All E&P, Section 7874, and Form 926.

Download Section_367_GRA_Intangible_Calculator.xlsx

100% live Excel formulas, no macros, no protected sheets, pre-loaded with the reconciled Meridian Precision Systems, Inc. restructuring baseline.

Download Excel Workbook (.xlsx) →

What the Five Tabs Compute

Tab NamePrimary ScopeBaseline Output (MPS US)
ControlsGlobal tax rate, consolidated Compliant vs. Adverse cash tax, and five dynamic integrity checks$13.527M vs. $42.928M
Sec367a_Outbound_AssetsAsset-by-asset gain recognition, no-loss rule, Section 91 branch loss recapture, and basis steps$6.195M tax
Sec367a_GRA_Tracker5-year GRA (TY 2026-2030), Year 3 trigger simulation, Section 6621 vs. 6621(c) interest, basis bump$20.634M trigger
Sec367d_IP_TD99945-year deemed royalty projection, 120% CWI corridor trigger, T.D. 9994 QDP repatriation$7.248M tax
Sec367b_Inversion_F926Inbound All E&P & Section 245A toggle, Section 7874 ownership fractions, Form 926 penalties$0.315M / $26.515M

Companion handbook: Every formula and regulatory citation in this workbook is explained step by step in The Section 367 Cross-Border Transfers Handbook. For domestic Subchapter C foundations, see The Section 351 Corporate Formation Handbook and The Section 381 Corporate Tax Attributes Handbook.