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.
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
| ID | Type | Grant | Vest start | Vest end | Granted | Vested | Price | Strike | |
|---|---|---|---|---|---|---|---|---|---|
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
| ID | Status | Vesting | Forfeited | Continuing | Value |
|---|---|---|---|---|---|
| RSU-2023-001 | Full vesting | 2,000 | 0 | 0 | $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-014 | Full vesting | 2,400 | 0 | 0 | $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-007 | Pro-rata | 1,250 | 0 | 0 | $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-003 | Pro-rata | 1,100 | 700 | 0 | $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-099 | Already vested | 0 | 0 | 0 | $120,000 |
| Award is fully vested as of the data snapshot (2,400 shares). Retirement does not change its status. | |||||
| ISO-2024-022 | Forfeiture | 0 | 1,125 | 0 | $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-014 | Needs review | 0 | 0 | 0 | $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.