Free Excel Templates · US Corporate Tax

Section 385 Funding Rule & Recharacterization Calculator

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.

Direct download (no macros, no locked sheets)

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

Workbook architecture (5 linked tabs)

Tab NameScope & Live Formulas
ControlsMaster 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_GroupAutomated 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_Scorecard11-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_Rule4-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_DeconsolAnnual 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%).

Go deeper with the full handbook

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

Related technical articles

Related handbooks by Julian R. Sterling