Free Excel Templates · US Derivatives Tax

Section 1233, 1234 Options & NPC Tax Calculator (Excel)

Six live-formula tabs covering equity options, short sale holding rules, Reg. 1.446-3 swap amortization and embedded loans, Section 1260, and Section 871(m) withholding.

Download Section_1234_Options_NPC_Calculator.xlsx

Pre-loaded with the complete 2024-2026 portfolio of Meridian Equity Derivatives Fund, LP and Meridian Offshore Feeder Ltd. Change any blue input cell on the Controls tab to recalculate all six modules automatically.

Download Excel Workbook (21 KB) →

What the six tabs calculate

Tab NameScope & Live FormulasBaseline Output
ControlsEditable tax rates (37% ST, 20% LT, 30% / 15% withholding), AFR, NPC notional, SOFR curve, and consolidated 3-year tax summary$847,680.43
Sec1234_OptionsTrades O1-O7 (holder & writer, exercise, lapse, closing buyback, mandatory STCG under 1234(b)(1))$1,144,000.00
Sec1233_ShortSalesRules 1, 2, 3, tainted put holding-period restart vs. Section 1233(c) married-put savings$22,100.00 saved
NPC_1446_3_1234ASwap N1 level-payment amortization (8.00%), Swap N2 embedded loan (50.00%), Swap N3 & Case T1 1234A LTCG$1,361,624.01 loan
Sec1260_ConstructiveNet underlying LTCG cap, excess ordinary recharacterization ($800,000.00), and Section 1260(b) interest charge$11,579.46 int.
Sec871m_WithholdingDelta >= 0.80 test, Qualified Index exemption, 30% vs. 15% treaty tax, Notice 2024-44 and Notice 2026-61 transition, and SET ratio$67,680.00 tax

Full statutory walkthrough in the handbook

Every formula, statutory citation, and Schedule M-3 / Form 1099-B control is explained chapter by chapter in The Section 1233 and 1234 Options and Derivatives Tax Handbook.

View the handbook →