Free Excel Templates · US International Tax
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.
100% live Excel formulas, no macros, no protected sheets, pre-loaded with the reconciled Meridian Precision Systems, Inc. restructuring baseline.
| Tab Name | Primary Scope | Baseline Output (MPS US) |
|---|---|---|
| Controls | Global tax rate, consolidated Compliant vs. Adverse cash tax, and five dynamic integrity checks | $13.527M vs. $42.928M |
| Sec367a_Outbound_Assets | Asset-by-asset gain recognition, no-loss rule, Section 91 branch loss recapture, and basis steps | $6.195M tax |
| Sec367a_GRA_Tracker | 5-year GRA (TY 2026-2030), Year 3 trigger simulation, Section 6621 vs. 6621(c) interest, basis bump | $20.634M trigger |
| Sec367d_IP_TD9994 | 5-year deemed royalty projection, 120% CWI corridor trigger, T.D. 9994 QDP repatriation | $7.248M tax |
| Sec367b_Inversion_F926 | Inbound 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.