Free Excel templates

A free Section 1256 60/40 & Straddle Calculator in Excel

60/40 blended tax rate engine, Form 1099-B Boxes 8-11 tie-out, Section 1212(c) 3-year carryback waterfall, Section 1092 deferral, Section 263(g) carrying charges, 4-regime mixed straddle comparison, and Section 1259 constructive sales.

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.

Section_1256_60_40_Straddle_Calculator.xlsx (23 KB)

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.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is inside the 6 tabs

Related reading