Equity Ops Workbench

Retirement Vesting Impact Forecaster

Which awards fully vest, which pro-rate, which forfeit.

Your stock administration platform (Fidelity, Shareworks, Computershare, E*TRADE, Carta) gives you the grants outstanding report. This tool turns it into a retirement-date impact analysis: per-award status, shares vesting due to retirement, shares forfeited, and a memo for equity, legal, and payroll review.

Deterministic rules engine. No AI in the calculation path. Client-side only. Your CSV is read in your browser, lives in this tab’s memory, and is gone the moment the tab closes.

Showing the sample retirement scenario. Edit any field to start working with your own data, or clear to a blank slate.
What this tool is, and what it isn’t

Deterministic, not AI

Award treatment is computed by a rules engine in src/lib/retirementVesting.ts, unit-tested. AI is not used to decide which shares vest, forfeit, or pro-rate. Plain-English memo language is generated by deterministic templates filled with your inputs.

Client-side only

Your CSV is parsed in your browser. The data lives in this tab’s memory for the session and is gone the moment the tab closes. Nothing is uploaded.

Conservative on missing data

When inputs are insufficient or inconsistent (missing vest end date, retirement before grant, share counts mismatched), the tool flags NEEDS_REVIEW with a specific exception. It does not guess.

Not legal advice

Real award treatment is governed by your company’s plan document and individual award agreements. This is a starting point for the conversation with legal and payroll, not a substitute.

Employee context

Retirement policy

Reflects the company plan's retirement provisions. Adjust to match your plan document.

Treatment if eligible (per award type)

Awards

Manual entry or paste/upload a grants outstanding CSV from your stock administration platform.

Where to find thisFidelity / Shareworks / Computershare / E*TRADE / Carta: 'Grants Outstanding' or 'Award Status' export. Required columns: Award ID, Award Type, Grant Date, Shares Granted, AND a vesting source — either Shares Vested OR an explicit Unvested / Unreleased column (Outstanding alone is ambiguous and is not accepted). Optional: Vest Start, Vest End, Price, Strike, Employee. Strike is required to value ISO / NSO awards (intrinsic value).

Or paste CSV inline
IDTypeGrantVest startVest endGrantedVestedPriceStrike

Eligibility

Eligible at evaluation

Yes

Evaluated at

2026-12-31

Age at check

58 yrs

Service at check

18 yrs

Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met.

Per-award outcomes

IDStatusVestingForfeitedContinuingValue
RSU-2023-001Full vesting2,00000$200,000
Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Policy treats RSU as full vesting at retirement; 2,000 unvested shares vest on 2026-12-31.
RSU-2024-014Full vesting2,40000$160,000
Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Policy treats RSU as full vesting at retirement; 2,400 unvested shares vest on 2026-12-31.
NSO-2022-007Pro-rata1,25000$140,000
Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Pro-rata vesting (100.0% by months served / total vest months): 1,250 additional shares vest, 0 forfeit. Method honors at-least-already-vested, so a higher already-vested figure is preserved.
PSU-2025-003Pro-rata1,1007000$55,000
Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Pro-rata vesting (61.1% by months served / total vest months): 1,100 additional shares vest, 700 forfeit. Method honors at-least-already-vested, so a higher already-vested figure is preserved.
RSU-2019-099Already vested000$120,000
Award is fully vested as of the data snapshot (2,400 shares). Retirement does not change its status.
ISO-2024-022Forfeiture01,1250$5,625
Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Policy forfeits unvested ISO at retirement; 1,125 shares forfeited.
PSU-2025-014Needs review000$0
Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Pro-rata calculation could not be completed: Pro-rata by months requires a vest end date. The data does not include one for this award. · Exceptions: Pro-rata by months requires a vest end date. The data does not include one for this award.

Summary

Already vested

9,325

Vesting at retirement

6,750

Forfeited

1,825

Continuing to vest

0

Est. value at retirement

$680,625

Exception flags

1

Memo for equity / legal / payroll

Plain markdown. Drop into your internal review thread.

# Retirement vesting impact — the employee

Educational diagnostic prepared from typed inputs. Not legal, tax, or financial advice. The company's plan document, the award agreements, and legal counsel control. Bring this memo to equity, legal, and payroll for review before relying on it.

## Inputs
- Birth date: 1968-04-15
- Hire date: 2008-09-01
- Proposed retirement date: 2026-12-31
- Eligibility rule: age + service ≥ 65 (min age 55) (checked at retirement date)
- Pro-rata method: months served / total vest months

## Eligibility
- Evaluated at: 2026-12-31
- Age at evaluation: 58 yrs
- Service at evaluation: 18 yrs
- Outcome: Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met.

## Per-award outcomes
- **RSU-2023-001** (RSU) — Full vesting
  - Already vested: 2,000
  - Additional vesting at retirement: 2,000
  - Estimated value at retirement: $200,000
  - Reason: Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Policy treats RSU as full vesting at retirement; 2,000 unvested shares vest on 2026-12-31.
- **RSU-2024-014** (RSU) — Full vesting
  - Already vested: 800
  - Additional vesting at retirement: 2,400
  - Estimated value at retirement: $160,000
  - Reason: Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Policy treats RSU as full vesting at retirement; 2,400 unvested shares vest on 2026-12-31.
- **NSO-2022-007** (NSO) — Pro-rata vesting
  - Already vested: 3,750
  - Additional vesting at retirement: 1,250
  - Estimated value at retirement: $140,000
  - Reason: Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Pro-rata vesting (100.0% by months served / total vest months): 1,250 additional shares vest, 0 forfeit. Method honors at-least-already-vested, so a higher already-vested figure is preserved.
- **PSU-2025-003** (PSU) — Pro-rata vesting
  - Already vested: 0
  - Additional vesting at retirement: 1,100
  - Forfeited: 700
  - Estimated value at retirement: $55,000
  - Reason: Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Pro-rata vesting (61.1% by months served / total vest months): 1,100 additional shares vest, 700 forfeit. Method honors at-least-already-vested, so a higher already-vested figure is preserved.
- **RSU-2019-099** (RSU) — Already fully vested
  - Already vested: 2,400
  - Estimated value at retirement: $120,000
  - Reason: Award is fully vested as of the data snapshot (2,400 shares). Retirement does not change its status.
- **ISO-2024-022** (ISO) — Forfeiture
  - Already vested: 375
  - Forfeited: 1,125
  - Estimated value at retirement: $5,625
  - Reason: Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Policy forfeits unvested ISO at retirement; 1,125 shares forfeited.
- **PSU-2025-014** (PSU) — Needs manual review
  - Already vested: 0
  - Estimated value at retirement: $0
  - Reason: Eligible: age 58 + service 18 = 76 ≥ 65, min age 55 met. Pro-rata calculation could not be completed: Pro-rata by months requires a vest end date. The data does not include one for this award.
  - **Exceptions**: Pro-rata by months requires a vest end date. The data does not include one for this award.

## Totals
- Shares already vested: 9,325
- Additional vesting due to retirement: 6,750
- Forfeited: 1,825
- Continuing to vest after retirement: 0
- Estimated total value (vested at retirement): $680,625
- **Awards needing manual review**: 1 (1 total exception flags)

## Cross-functional handoff
1. **Equity admin / TR.** Confirm the award status table against the source-of-truth grants outstanding report from the stock administration platform (Fidelity / Shareworks / Computershare / E*TRADE / Carta). Reconcile any NEEDS_REVIEW row before sharing.
2. **Legal.** Confirm the eligibility rule and treatment table against the plan document and any individual-grant agreement nuances (qualifying termination definitions, change-in-control overlays, exception clauses).
3. **Payroll.** Confirm the income-recognition and tax-withholding implications for the shares vesting at retirement; coordinate the timing against the company's normal vest-cycle payroll calendar.
4. **Finance.** Reconcile any accelerated vesting against the in-flight ASC 718 expense forecast and the FY budget.

## Recommended next steps
1. Walk the per-award outcomes with the employee and document the rationale for any exception.
2. Resolve every NEEDS_REVIEW row before the retirement date; if data cannot be reconciled, escalate to legal.
3. If the retirement date moves, re-run the model with the new date so the eligibility check uses the correct age and service.
4. Save the assumption sheet alongside the memo so the legal / payroll review thread has the same inputs the model used.

## Disclaimer
Outputs reflect the policy and inputs typed above. Real-world award treatment is governed by the company's plan document and individual award agreements. Plans frequently include nuances not modeled here (qualifying termination definitions, change-in-control overlays, exception clauses, holding-period requirements). Bring this memo and your award agreements to legal and payroll before any action.

Educational diagnostic. Not legal, tax, or financial advice. The company plan document, the individual award agreements, and legal review control. Bring this memo to equity, legal, and payroll before any action.