Capital Gains & State Tax Planner
Advisor workspace for importing client portfolios by CSV, maintaining multiple client analyses, estimating federal and 50-state capital-gains tax, and solving for the maximum gain that fits each client’s tax budget.
Advisor client dashboard
Create a client manually or import one or many clients from CSV. This single-file prototype saves data only in this browser on this device.
| Client / Household | State | Filing status | Holdings | Portfolio value | Sell gain | Tax budget | Last updated |
|---|
Client inputs
Gain & tax budget
Estimated tax
How the estimate is calculated
Federal long-term gains are stacked on top of existing taxable income using 2026 0%, 15%, and 20% thresholds. NIIT is estimated at 3.8% of the lesser of the proposed investment gain or MAGI above the statutory threshold after the gain. State tax is generally estimated as the incremental state income tax caused by the gain, based on 2026 state brackets. Missouri capital gains are treated as exempt for this planner. Washington uses its separate capital-gains structure. Local income taxes, credits, deductions, AMT, special asset categories, loss carryforwards, depreciation recapture, collectibles, QSBS, and other special rules are not modeled.
50-state comparison
Uses the client inputs from the Tax Planner tab. The comparison shows estimated tax on the same proposed long-term gain in each state. It is a planning comparison, not a tax return calculation.
| State | State tax | Total fed + state | Effective tax on gain | State note |
|---|
Holdings analysis
Mirrors the workbook’s core columns: recommendation, shares, current price/value, cost basis, and unrealized gain/loss. Changes are saved to the selected client in this browser.
| Ticker / Name | Recommendation | Shares | Current price | Cost basis / share | Current value | Total basis | Unrealized G/L |
|---|
CSV import
Upload a portfolio CSV for the selected client, or include a Client Name column to import multiple clients in one file. The importer accepts common column-name variations.
Client Name, Filing Status, State, Federal Taxable Income, MAGI, State Taxable Income, Max Tax Budget, Ticker/Name, Recommendation, Shares, Current Price, Cost Basis / Share, or Total Cost Basis.
Smith Household,Married filing jointly,CA,250000,275000,250000,25000,AAPL,Sell,100,225,125