Free Excel Templates · US Derivatives Tax
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.
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.
| Tab Name | Scope & Live Formulas | Baseline Output |
|---|---|---|
| Controls | Editable tax rates (37% ST, 20% LT, 30% / 15% withholding), AFR, NPC notional, SOFR curve, and consolidated 3-year tax summary | $847,680.43 |
| Sec1234_Options | Trades O1-O7 (holder & writer, exercise, lapse, closing buyback, mandatory STCG under 1234(b)(1)) | $1,144,000.00 |
| Sec1233_ShortSales | Rules 1, 2, 3, tainted put holding-period restart vs. Section 1233(c) married-put savings | $22,100.00 saved |
| NPC_1446_3_1234A | Swap N1 level-payment amortization (8.00%), Swap N2 embedded loan (50.00%), Swap N3 & Case T1 1234A LTCG | $1,361,624.01 loan |
| Sec1260_Constructive | Net underlying LTCG cap, excess ordinary recharacterization ($800,000.00), and Section 1260(b) interest charge | $11,579.46 int. |
| Sec871m_Withholding | Delta >= 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 |
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.