Free Excel Template · Julian R. Sterling

Section 457 and 4960 Excise Tax Calculator (Excel)

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.

Download Section_457_4960_Excise_Tax_Calculator.xlsx

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

What is inside the six tabs

Tab NameCore Computation & Dynamic Controls
ControlsEditable 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_LimitsTracks 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_FICACompounds 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_5YrFull 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_CutbackComputes 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_SchNEntity-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).

Related guides

Related US tax handbooks