Free Excel Template · Julian R. Sterling
Six dynamic, unlocked tabs modeling Notice 2025-67 457(b) limits, 457(f) cliff vesting, FICA Section 3121(v)(2), Post-OBBBA 2026 Section 4960 liability, parachute cutbacks, and Form 4720 Schedule N.
Zero macros, zero locked sheets, 304 audited dynamic formulas. Pre-loaded with the Alderbrook Health System 5-year baseline ($526,938.82 in 2026 excise tax; drops to $358,168.22 when the graded-vesting and parachute-cutback switches on the Controls tab are enabled).
Download Excel (.xlsx) Read the handbook| Tab Name | Core Computation & Dynamic Controls |
|---|---|
| Controls | Editable blue input cells for the 21% excise rate, $1,000,000 threshold, 2025/2026 457(b) limits ($23,500 / $24,500), OASDI wage base ($184,500), 6.00% SERP rate, plus 0/1 scenario toggles for medical carve-out audit failure, graded vesting, and parachute cutbacks. |
| 457b_Limits | Tracks Elena Vance's special 3-year catch-up pool ($62,000 start, $49,000 in 2026 and 2027) alongside a Governmental vs. Non-Governmental 457(b) comparison matrix (Age 50+ $8,000 and Ages 60-63 $11,250). |
| 457f_SERP_FICA | Compounds 4-year SERP credits to 12/31/2026 cliff vesting ($695,563.94 for Elena Vance) and computes exact IRC Section 3121(v)(2) OASDI, 1.45% Medicare HI, 0.90% Additional Medicare Tax, and 37% income tax withholding. |
| 4960_Excise_5Yr | Full 2023-2027 ledger across 6 executives and 3 related entities (AHS, AMF, AHV), illustrating Pre-OBBBA Top-5 vs. Post-OBBBA 2026 all-employee scope ($692,838.82 5-year total). |
| Parachute_Cutback | Computes David Ross's 5-year Base Amount ($460,000.00), 3x cliff ($1,380,000.00), $218,400.00 parachute excise tax, and exact net cutback savings ($86,100.21) after accounting for induced Section 4960(a)(1) tax ($132,299.79). |
| Form_4720_SchN | Entity-by-entity 2026 Form 4720 Schedule N liability summary (AHS $478,518.59, AMF $24,608.62, AHV $23,811.61) and 3-lever restructuring dashboard ($168,770.60 direct savings). |