Exact Treas. Reg. § 1.482-1 interquartile range, CPM/TNMM median vs. Q1 adjustments, Residual Profit Split (DEMPE), CSA RAB shares and PCT Buy-In DCF, AFR safe haven vs. OECD Chapter X financing, Section 6662(e)/(h) penalties, and Pillar One Amount B.
Pre-loaded with the complete Vanguard Industrial Technologies, Inc. (VIT Group) three-year baseline. Blue cells on Controls are editable; all 159 formulas update dynamically with zero macros.
| Tab Name | Scope & Key Live Calculations |
|---|---|
| Controls | Master control panel: tax rates, VIT-US gross receipts ($442.00M), Mid-Term AFR (4.20%), 5-Yr UST (4.10%), SBC toggle, PCT discount rate (12.50%), § 1.6662-6 doc toggle, Amount B target ROS (3.75%), and live executive dashboard. |
| CPM_IQR_Benchmark | VIT-Germany FY2024 to FY2026 P&L ($374.00M 3-yr sales, 1.75% OM), 8 comparables, exact Reg. § 1.482-1(e)(2)(iii)(C) IQR (3.30% / 4.30% / 5.40%) vs. Excel PERCENTILE, IRS median adjustment ($3.864M), and self-initiated Q1 true-up ($2.484M). |
| RPSM_DEMPE | GridPulse Enterprise Suite ($240.00M revenue, $92.00M system profit), Step 1 routine returns ($15.52M), and Step 2 capitalized DEMPE IP stock allocation (68.75% VIT-US / 31.25% VIT-Ireland). |
| CSA_PCT_BuyIn | RAB shares (60.00% / 40.00%), FY2026 IDCs ($60.00M) with Altera SBC toggle ($10.00M vs. $7.60M CST), and 5-year Income Method DCF PCT Buy-In ($89.17M NPV, 14.19% equivalent flat royalty). |
| Interco_Financing | $100.00M 5-year loan at 7.85% tested against 100% to 130% Mid-Term AFR (4.20% to 5.46%) and OECD Chapter X BBB- median (6.05%), annual adjustment ($1.80M), cash pool synergy ($0.36M), and guarantee fee cap ($225.00K). |
| Penalties_AmountB | IRC § 6662(e) 20% ($5.00M threshold) and § 6662(h) 40% ($20.00M threshold) penalty engine across 3 audit scenarios, Rev. Proc. 99-32 repatriation, and Pillar One Amount B Notice 2025-4 matrix ($3.105M vs. $3.864M CPM median). |