Free Excel Templates · US Corporate Tax
Dynamic 5-tab workbook modeling Expanded Group perimeters, common law factor scores, the 36-month per se Funding Rule, EGEA and $50M threshold ordering, cash pool QSTDI tests, withholding tax leakage, and Section 1504(a)(2) deconsolidation risk.
Pre-loaded with the Meridian Industrial Holdings Group (MIH) 4-year worked case study. Change any blue input cell on the Controls tab (US CIT rate, treaty/statutory WHT rates, $50M cap, or the Cash Pool Stress Toggle) and watch every downstream schedule recalculate automatically.
Download Section_385_Funding_Rule_Calculator.xlsx| Tab Name | Scope & Live Formulas |
|---|---|
| Controls | Master tax rate inputs (21.00% US CIT, 0.00%/5.00%/30.00% WHT), $50.00M cap, 80.00% EG threshold, 270-day QSTDI ceiling, Cash Pool Stress Toggle (0/1), and a 10-row live Executive Dashboard. |
| Expanded_Group | Automated 80.00% vote-or-value test under Treas. Reg. 1.385-1(c)(4) and domestic Covered Member flag across all 9 MIH entities. |
| Common_Law_Scorecard | 11-factor weighted scorecard synthesizing Mixon, Fin Hay Realty, and Roth Steel Tube across T1-T4 and a $30.00M subordinated hybrid benchmark (24.75). |
| Sec385_Funding_Rule | 4-year EGEA ledger, chronological General Rule and 36-month Funding Rule ordering, excess-only $50.00M allocation ($100.00M recharacterized), and QSTDI 270-day / Specified Current Assets safe harbor test. |
| Tax_Impact_Deconsol | Annual and 4-year cumulative tax leakage across Scenario A ($1,540,125), Scenario B ($1,725,750), and Scenario C ($3,385,125), principal redemption WHT, and the US OpCo 2 deconsolidation test (85.00% to 68.00%). |
Every formula, regulatory citation, and audit-defense protocol behind this workbook is documented step by step in The Section 385 Debt vs Equity Handbook.
View the handbook