Sample report

Made-up household

See exactly what your clients receive.

A real VestMath Pro report for a fictional Brooklyn couple in an IPO year, branded for a sample firm. Download the PDF to see the print version.

The report your equity clients will actually read

  • Low / base / high share price in one table, so you advise on a range instead of a guess
  • Every rule cited to the IRC section or IRS publication, plus the exact tax-table version used
  • Form-by-form figures for the preparer, ready for 3921, 6251, 8949 and 8960
  • Shared as a branded web link or a PDF with your firm's logo, color and disclaimer

A spreadsheet gives one number and no audit trail. This shows the range, the sources and the assumptions behind every figure.

Harbor & Pine Wealth

Equity tax report · Prepared by Jordan Ellis, CPA, Harbor & Pine Wealth

Sample: Dana & Lee Park, IPO year

Tax year 2026 · Prepared Nov 19, 2026

New York

Prepared for Dana & Lee Park

Base case at the share price entered. The range below shows how the answer moves with price.

Cash income

$730,000

Salary, equity and sales

Total tax

$255,669

35.0% of cash income

Cash after tax

$474,331

After every tax

Still to set aside

$33,766

Plus $3,177 refund due

Low / base / high share price

Same scenario, run three times through the engine. Only the share price changes.

Share priceLow$30.00Base$50.00High$70.00
Total tax$206,833$255,669$304,940
Take-home after tax$375,167$426,331$477,060
Still to set aside$22,053$33,766$47,961
AMT owed$0$0$0

Federal (IRS)

Tax for the year$183,578

Withheld from pay$149,812

Still owed$33,766

New York

Tax for the year$71,205

Withheld from pay$74,382

Refund expected$3,177

Quarterly estimated payments

Q1 · due Apr 15, 2026$0

Q2 · due Jun 15, 2026$0

Q3 · due Sep 15, 2026$68

Q4 · due Jan 15, 2027$18,356

Penalty if paid in April instead$320

For the tax preparer

W-2, Box 1Equity pay included in your wages (RSUs, NSOs, ESPP)$250,000

Form 8949 / Sch. DNet short-term gain$20,000

Form 8949 / Sch. DNet long-term gain$60,000

Form 8960Net investment income tax$3,040

Form 8959Additional Medicare tax$3,600

Form 2210Estimated underpayment penalty$320

Advisor analysis

We start with salary alone, then add each equity event one at a time and record how much more tax it adds. The rows add up to the year's full tax. Example: with a $200,000 salary, $100,000 of RSUs vesting adds about $31,400 of federal income tax and $2,350 of Medicare, because those dollars land in the 32% to 35% brackets. Events further down the list pay the higher rates that earlier ones pushed income into, so order matters.

EventIncome addedFed. income taxPayrollNIITState & localTotal tax
Salary and other regular income$352,000$55,068$27,889—$34,507$118,351
RSU vesting$250,000$73,901$5,875—$28,117$107,892
Share sale 1 (short-term, 1000 shares)$20,000$7,000—$760$2,145$9,905
Share sale 2 (long-term, 2000 shares)$60,000$10,805—$2,280$6,436$19,521
Total$682,000$146,774$33,764$3,040$71,205$255,669
  • Projection share price: $50.00. Every future vest, exercise and sale uses this one price; no growth rate is assumed.
  • Years after 2026 keep salary and other regular income unchanged and use the 2026 tax brackets, AMT exemption and thresholds. Real future brackets will be adjusted for inflation.
  • Unvested RSUs vesting in 2026 are assumed to be in the scenario's RSU entry already; only vests in later years are added.
  • Starting AMT credit: $8,000.00, from the client's prior-year Form 8801. Unused credit and capital losses carry forward year to year.
  • Event attribution adds each event on top of salary in this order: RSUs, NSOs, ISOs, early exercise, ESPP, common stock, each sale, then other brokerage sales. Later events pay the higher rates earlier ones pushed income into.

Income

Everything that counts as income this year. "Taxed like salary" means it is added to pay and taxed at the same rates. Example: a $200,000 salary plus $50,000 of RSUs vesting means $250,000 of income before deductions.

Tax rules behind this: IRC Section 61; Section 83(a); Section 62; Section 1222

Salary, bonus and other income$400,000
Pre-tax savingsNo income tax now; still pays Social Security and Medicare-$48,000
RSU settlementTaxed like salary$250,000
NSO spreadTaxed like salary$0
Short-term gains$20,000
Long-term gains$60,000
Adjusted gross income$682,000

Where the tax comes from

Income is added one piece at a time (salary, then RSUs, NSOs, ISOs, then stock sales) and we record how much the tax goes up at each step. Later pieces land in higher brackets, so they show a higher rate. Example: a $150,000 salary averages about 20%, while $100,000 of RSUs added on top lands in the 32% and 35% brackets.

Tax rules behind this: IRC Section 1

Salary and other income$400,000 of income · $82,957 federal + $34,507 state · 29.4% effective$117,464
RSUs$250,000 of income · $79,776 federal + $28,117 state · 43.2% effective$107,892
Stock sales$80,000 of income · $20,845 federal + $8,581 state · 36.8% effective$29,426
Total tax$255,669

Federal tax

A deduction comes off first, then the rest is taxed in brackets. The marginal rate is the rate on the last dollar, not on all income. Example: with a 24% marginal rate, $1,000 more of RSUs adds about $240 of federal income tax.

Tax rules behind this: IRC Section 63; Section 1; Section 55; Section 1411; Section 3101; Form 8960

Standard deduction-$32,200
Tax on ordinary income35% marginal; includes short-term gains$143,969
…of which on short-term capital gainsEstimated at the top bracket$7,000
Tax on long-term gainsMarried filing jointly: 15% on $23,900, 20% on $36,100$10,805
Alternative minimum taxDoes not apply$0
AMT credit from prior yearsCan only bring tax down to the AMT amount-$8,000
Net investment income taxExtra 3.8% on investment gains for higher earners; already included in Total federal$3,040
Social Security$20,739
Medicare$13,025
Total federalIncludes income tax, payroll tax, and NIIT$183,578
Effective federal rateFederal tax ÷ total income25.1%

Capital gains effective rate

Gains are taxed on their own schedule, separate from salary, so their rate is different. This is tax on gains ÷ gains, including the 3.8% NIIT. Example: $100,000 of long-term gains taxed $23,800 federally is a 23.8% federal rate.

Tax rules behind this: IRC Section 1(h); Section 1411; Form 8960

Federal26.1%
State6.9%
Combined32.9%

State tax — New York

The state works out its own tax on the same income, with its own brackets and deductions, separately from the IRS. Example: California taxes long-term gains at the same rates as salary, while Washington taxes only large long-term gains.

Tax rules behind this: New York tax agency; N.Y. Tax Law Section 601 (rates); N.Y. Tax Law Section 614 (standard deduction); NY Department of Taxation and Finance (administers NYC tax); N.Y. Tax Law Section 1304 (NYC rates)

Pre-tax savings-$48,000
Standard deduction-$16,050
Taxable income$665,950
Tax on ordinary income$45,618
…of which high-income recaptureAbove a set income, New York takes back the savings from its lower brackets. Example: in New York, income over about $108,000 gradually loses the lower rates until all of it is taxed at your top rate.$4,211
Capital gains in taxable incomeTaxed at the same rates as salary$80,000
Local income taxGraduated rates, averaging 3.84% of taxable income$25,588
Total state$71,205
Effective state rateState tax ÷ cash income9.8%

Total tax, line by line

Every tax counted in your total, each on its own line, so you can see they add up. Payroll lines (Social Security, Medicare and any state disability or paid-leave contribution) are taken from each paycheck. Example: $100,000 federal income tax + $20,000 federal payroll + $30,000 state income tax + $4,000 state disability insurance = $154,000 total tax.

Federal income tax$146,774
Federal payroll (Social Security + Medicare)$33,764
Net investment income tax (3.8%)$3,040
New York income tax$45,618
Local income tax$25,588
New York PFLEmployee contribution, taken from each paycheck$824
New York DBLEmployee contribution, taken from each paycheck$62
Total tax$255,669

Withholding already taken

Everything already sent to the IRS and the state before filing: tax from paychecks, tax held back from RSUs and options, Social Security and Medicare, and any payments made directly. The balance is the tax minus all of that. Example: $60,000 of federal tax with $45,000 withheld leaves a $15,000 balance still owed.

Tax rules behind this: IRC Section 3402; Treas. Reg. Section 31.3402(g)-1; Section 31; Form W-4

Federal from paychecksEstimated: tax on salary alone$61,948
Federal withheld on equity22% of equity income$55,000
State from paychecksEstimated: tax on salary alone$21,711
Local income tax from paychecksEstimated: city tax on salary alone$12,797
State withheld on equity$29,250
Local withheld on equityWithheld by the employer$10,625
Federal payroll withheld (Social Security + Medicare)$32,864
New York PFL withheldTaken in full from each paycheck$824
New York DBL withheldTaken in full from each paycheck$62
Total withheld$225,081
Federal balance+ owed, − refund$33,766
State balance+ owed, − refund-$3,177
Combined balance$30,588

Effective total rate

All tax for the year divided by the cash income that actually reached you. Paper gains on shares you still hold are left out, because no money arrived to pay from. Example: $90,000 of total tax on $300,000 of cash income is a 30% rate.

Effective total rateTotal tax ÷ cash income (paper gains on shares you still hold are left out)35.0%

Where the IRS balance comes from

Each agency's tax is split into salary, stock compensation and share sales. For each, the tax it adds is compared with what was withheld or paid for it. Example: RSUs added $40,000 of federal tax but only $22,000 was withheld, so that piece is short $18,000.

Tax rules behind this: IRC Section 6654; Form 2210

Salary and other income$82,957 tax − $88,937 withheld or paid for itOver $5,980
Stock compensation (RSUs and options)$79,776 tax − $60,875 withheld or paid for itShort $18,901
Selling shares$20,845 tax − $0 withheld or paid for itShort $20,845
BalanceOwes $33,766

Why there's a shortfall

  • Your employer withheld about 22% federal tax on $250,000 of equity pay. Employers are allowed to use that flat rate, but this income is taxed in your 35% bracket, so every dollar came up short by the difference.
  • Nothing is withheld when you sell stock. Your sales added $29,426 of tax, and none of it has been paid yet.

Why there's an overpayment

  • The tax taken from your paychecks was more than the tax on your salary. Paycheck withholding assumes you earn the same amount all year and take no extra deductions, so it often takes a little too much.

Where the New York balance comes from

Each agency's tax is split into salary, stock compensation and share sales. For each, the tax it adds is compared with what was withheld or paid for it. Example: RSUs added $40,000 of federal tax but only $22,000 was withheld, so that piece is short $18,000.

Tax rules behind this: New York tax agency

Salary and other income$34,507 tax − $34,507 withheld or paid for itCovered
Stock compensation (RSUs and options)$28,117 tax − $39,875 withheld or paid for itOver $11,758
Selling shares$8,581 tax − $0 withheld or paid for itShort $8,581
BalanceRefund $3,177

Tax tables used

  • Federal 2026 · published · updated Oct 28, 2026 · Verified Sept 2026 against IRS Rev. Proc. 2025-32 (brackets, standard deduction, AMT, LTCG thresholds), SSA 2026 wage base ($184,500), IRS Q4 2026 underpayment rate (7%), and OBBBA (SALT, QSBS, AMT phaseout).
  • New York 2026 · published · updated Oct 28, 2026 · Verified Sept 2026 against NYS DTF 2026 schedules (FY2026 budget lowered the first five rates by 0.1 point). Tax-benefit recapture for high incomes is modeled per Tax Law 601(d) and IT-201 tax computation worksheets.

Assumptions

  • Tax year 2026, filing status Married filing jointly.
  • Resident of New York for the full year unless a former state is entered.
  • Employer withholding on equity pay uses the federal supplemental rates (22%, then 37% above $1M) unless a different rate was entered.
  • Only the income, deductions and payments entered are counted. Tax credits and state itemized deductions are not modeled.
  • Share price range: low $30.00, base $50.00, high $70.00. Every grant and sale price in the scenario moves by the same percentage; share counts and dates stay fixed.

Rules applied

Prepared by Harbor & Pine Wealth for planning discussion only. Not tax advice or a tax return. Powered by VestMath.

Build this for your own clients.

Same engine, your branding, numbers from their real grants.