Stock Option Exercise Withdrawal Schedule Planner

Plan how long a pool of shares or cash created by exercising stock options may support regular withdrawals. The planner converts an estimated post-exercise starting value into a month-by-month drawdown using your withdrawal amount and an assumed annual return on the remaining balance.

It is useful when you are deciding whether to sell exercised shares gradually, fund a temporary income gap, or compare a planned withdrawal pace with the size of the position. The result is a planning estimate rather than a prediction of market performance, and it does not determine the tax treatment of an option exercise.

Inputs

USD
USD
%
months
Result
Estimated support period
Ending balance
Total withdrawn
Months supported
Initial annual withdrawal rate

1. Enter the starting value
Use the estimated amount available for the withdrawal plan after any exercise costs, taxes, or sale decisions you want reflected.

2. Set the monthly withdrawal
Enter the cash amount you expect to take from the position each month.

3. Choose a return assumption
Use an annual growth or decline assumption for the balance that remains invested.

4. Set the planning horizon
Choose how many months you want the model to test, up to 1,200 months.

5. Review sustainability
Compare months supported, total withdrawals, and the ending balance to judge whether the planned pace is workable under your assumption.

Monthly return = (1 + annual return)^(1/12) - 1
Balance after growth = prior balance × (1 + monthly return)
Ending balance = max(0, balance after growth - monthly withdrawal)

Where:

  • annual return = your assumed yearly return, entered as a percentage
  • monthly withdrawal = cash removed each month, in dollars
  • starting balance = value available at the beginning of the plan, in dollars

Assumptions: Growth is applied before each monthly withdrawal. Returns are constant in the model and actual investment returns can vary.

What the result means

Use this as a scenario estimate. Market returns, sale timing, taxes, fees, and employer plan restrictions can materially change the actual withdrawal path.

Change one assumption at a time to compare scenarios and understand which input has the largest effect on the result.

Given:

  • Starting available value: $150,000
  • Monthly withdrawal: $3,000
  • Annual return: 4%
  • Planning horizon: 120 months

Calculation:
The monthly equivalent return is about 0.327%. Each month the remaining balance grows by that rate and then $3,000 is withdrawn until the horizon ends or the balance reaches zero.

Result:
The model supports a little over 4 years of withdrawals under these assumptions.

Interpretation: A higher withdrawal or lower return shortens the schedule; a lower withdrawal or higher return extends it.

Should I enter the option grant value or cash actually available?

Use the value that is genuinely available to fund withdrawals. If exercise cost, withholding, or planned taxes reduce what you can spend, subtract those amounts before entering the starting value.

Why can a positive return still end with a zero balance?

The withdrawal can exceed the investment growth. When outflows are large enough relative to the starting balance, the account can still be depleted even with a positive assumed return.

Does the planner model changing stock prices each month?

No. It applies one constant annual return converted to a monthly rate. That makes the schedule easy to compare, but it does not reproduce market volatility or sequence-of-returns risk.

What happens if the monthly withdrawal is zero?

The balance compounds for the full planning horizon and the tool reports the horizon as supported. Total withdrawals remain zero.

Does this planner calculate stock-option taxes?

No. It is a cash-flow schedule. Tax treatment depends on the option type, transaction details, jurisdiction, and timing, so tax effects should be estimated separately before choosing the starting balance.