Pre-loaded with Meridian Quantitative Partners LP and Managing Partner Elena Vance (2023-2026): +$1,310,000 in 2023-2025 Section 1256 gains, a -$1,120,000 drawdown in 2026 unlocking $342,720 in Section 1212(c) refunds, an APXT straddle deferring $185,000 and capitalizing $58,000, and a 4-regime ES/SPY mixed straddle comparison. Overwrite any blue cell with your own portfolio figures.
Get the Excel calculator
One Excel workbook, 190 live formulas, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.
The book behind this calculator
The Section 1256 Contracts and Straddles Handbook walks through every statutory rule, Form 6781 line item, Schedule K-1 Box 11 Code C allocation, and IRS audit defense workpaper behind this workbook.
Inputs_Rates: Blue editable input cells for 2026 federal tax rates (post-P.L. 119-21), 4-year Section 1256 and Form 1099-B figures, prior-year taxable income ceilings, APXT straddle and Section 263(g) charges, ES/SPY mixed straddle legs, and VNCX constructive sale inputs.
S1256_60_40_MTM: Blended 60/40 effective tax rates (26.8% ex-NIIT / 30.6% incl. NIIT), benchmark $1,000,000 savings ($102,000), Form 1099-B Boxes 8-11 reconciliation, cross-year Section 1256(a)(2) roll check, and 4-year Form 6781 Part I summary.
S1212c_Carryback: Chronological Y-3 / Y-2 / Y-1 carryback waterfall enforcing both the prior net Section 1256 gain cap and the Section 1212(c)(3) no-NOL ceiling, plus an NOL-constrained sensitivity case with automatic 40/60 carryforward tracking.
S1092_263g_Straddle: Section 1092(a)(1) straddle loss deferral, Section 263(g) carrying charge netting against dividends, adjusted stock basis, 2026 disposition and deferred loss release, and exact 2-year economic P&L reconciliation.
Mixed_1259_Compare: Side-by-side 4-regime mixed straddle tax comparison (Default No Election, Box A Section 1256(d), Box B 1.1092(b)-3T, Box C 1.1092(b)-4T) plus the Section 1259 constructive sale vs. 30-day closed transaction exception engine.
Controls: 11 live dynamic statutory and accounting identity checks verifying 0 formula errors across every module as inputs change.