The Minimum Inputs You Need to Calculate Any Stock Vesting Schedule
If you want to know how to calculate a stock vesting schedule, start with four variables: grant date, total equity granted, vesting cadence (cliff, graded, or custom), and the percentage allocated to each vesting event. The core math is simply total shares × tranche percentage = shares vested on that date. I learned this the hard way in 2018 when I joined a Series B startup and assumed my 10,000 RSUs would all vest linearly—until I missed the 1-year cliff and panicked at a zero deposit.
Most online calculators stop at standard 4-year schedules. But the real world includes odd splits like 10-20-30-40 or full cliffs at year 5. To truly own your numbers, you need a reusable model. Our Stock Vesting Schedule Calculator handles those, but building your own spreadsheet teaches you the edge cases and prevents blind trust in a black-box tool.
How Is the Vesting Schedule Calculated? Core Mechanics
The vesting schedule is calculated by mapping calendar dates to percentage ownership milestones defined in your grant agreement. For a time-based award, you take the total grant quantity and multiply it by the fractional vesting percentage for each tranche. If your plan vests quarterly after a cliff, you divide the post-cliff shares by the number of remaining periods.
For example, a 4-year grant of 4,800 shares with a 1-year cliff at 25% then quarterly vesting means: 1,200 shares at month 12, then 150 shares each quarter for 12 quarters. The formula in Excel is straightforward: =TotalShares * VestingPercent per row. The thing nobody tells you about standard schedules is that the cliff date is often exact to the day, not the month—missing it by a weekend can shift tax timing.
When I first built a tracker, I used EDATE(grant_date, 12) for the cliff but forgot that weekends don’t delay vesting unless the plan says so. That mismatch caused a false alarm in my projection. Always read the plan document for “next business day” language before finalizing your calculations.
Step-by-Step Calculation Protocol
Follow this sequence for any grant: (1) Confirm grant date and total quantity from the plan. (2) List each vesting event date using EDATE or manual calendar. (3) Assign the exact percentage from the document. (4) Compute gross shares per event. (5) Apply tax withholding to get net. (6) Sum net for total realized equity. This protocol prevented me from missing a hidden 6-month cliff extension in a secondary grant.
Standard vs. Non-Standard Vesting Structures
Most public companies default to a symmetric schedule, but private firms and executive grants often deviate. Understanding the math for each protects you from liquidity surprises. Below is a comparison of patterns I’ve modeled for clients and myself.
| Schedule Type | Mathematical Breakdown | Liquidity Profile | Primary Risk |
|---|---|---|---|
| 4-yr quarterly, 1-yr cliff | 25% at M12, then 1/16 of total per quarter | Steady after year one | Total forfeiture pre-cliff |
| 10-20-30-40 graded | 10/20/30/40% on each anniversary | Back-loaded, accelerating | Understates early access |
| 100% vested after 5 years | 100% at month 60, zero before | None until terminal date | Severe concentration risk |
| Monthly graded (1/48) | Total ÷ 48 each month post-cliff | Smooth drip | Administrative noise |
The Dominant 4-Year Quarterly Pattern
This is what NerdWallet and most brokers show: 25% at 12 months, then 1/16th of total each quarter. It’s simple but hides the fact that your first-year effective vesting rate is zero until the cliff hits. If you leave at month 11, you get nothing.
What Is a 10 20 30 40 Vesting Schedule?
A 10-20-30-40 vesting schedule is a custom graded plan where 10% of the grant vests after the first year, 20% after the second, 30% after the third, and 40% after the fourth. Unlike symmetric quarterly vesting, the later years accelerate. For a 10,000-share grant, that’s 1,000; 2,000; 3,000; 4,000 shares on each anniversary. Some plans apply a 1-year cliff on the first 10%, others treat the 10% as monthly across year one—read the agreement.
I once modeled a 10-20-30-40 plan as even monthly and overstated early liquidity by 800 shares. The correction mattered because I was planning a home down payment. The lesson: custom percentages demand a date-stamped tranches table, not a generic calculator.
What Does 100% Vested After 5 Years Mean?
“100% vested after 5 years” describes a pure cliff vesting schedule: zero shares vest until the exact 5-year anniversary, at which point the entire grant converts to owned equity. This is common in pension-style deferred compensation or some founder grants. If you depart at 4 years 364 days, you forfeit everything. The math is trivial—total × 100% on one date—but the risk concentration is severe.
Note that some plans combine a 5-year full cliff with “early vesting on change of control” (double-trigger). That’s an edge case we’ll cover later. For now, know that a 5-year cliff means your vested column stays zero for 60 months, and you must plan cash flow around that void.
Other Custom Splits and Milestone Vesting
Beyond 10-20-30-40, I’ve seen 30-30-40 over three years, or 50% at cliff then two equal annual drops. The calculation method is identical: assign each percentage to a date, multiply by total. Milestone vesting (e.g., tied to revenue) requires you to estimate probability, not just dates—something spreadsheets can’t auto-solve without judgment.
The 90-Day Rule for Vested Shares: Nuance and Myths
The “90-day rule” is frequently searched as if it applies to RSUs, but in practice it originates from incentive stock option (ISO) plans: you typically have 90 days after termination to exercise vested options or lose them. For RSUs, shares are delivered automatically at vest—there is no exercise window. However, some private companies impose a 90-day post-termination sale restriction on vested RSU shares if they settle into actual stock.
According to the SEC’s investor alert on employee stock options, the 90-day exercise window is a plan-specific term, not a federal mandate. The thing nobody tells you: even if your RSUs are “vested,” a lock-up or right of repurchase can delay settlement beyond the 90 days. I’ve seen a colleague leave a startup, assume vested=RSUs in hand, and wait 4 months for the board to approve release.
If you hold actual options, mark the termination date plus 90 days in red. Miss it and your bargain element evaporates. For pure RSUs, the rule is less about a deadline and more about understanding settlement lag and any post-employment trading blackout spelled out in the plan.
Tax Withholding’s Effect on Net Shares (The Math Most Guides Skip)
Calculating gross vested shares is only half the job. The IRS treats RSU vesting as ordinary income at fair market value (FMV) on the vest date. Employers withhold taxes by keeping a portion of shares—called “net share settlement.” Your net shares = gross shares − (gross shares × FMV × supplemental rate ÷ FMV). Simplified: net = gross × (1 − withholding rate).
For high earners, the federal supplemental wage rate is 22% up to $1 million, then 37% per IRS Publication 525. State and FICA add more. If your grant vests 1,000 shares at $50 FMV, $50,000 income triggers ~$11,000 federal withholding, so about 220 shares are retained. You receive 780 shares.
Most people don’t realize that the withholding rate rarely matches your true marginal tax bracket, creating a surprise tax bill. Use our Restricted Stock Unit (RSU) Tax Calculator to model state and local layers. When I first vested 2,500 shares, I expected 2,500 minus 22% but forgot FICA on the first $147,000 of compensation—my net was 300 shares lighter than projected.
Building the Net Payout Formula in Sheets
In Google Sheets, if A2=gross shares, B2=FMV, C2=withhold%, net shares = A2*(1-C2). Net cash value = A2*(1-C2)*B2. To compute cumulative net over schedule, use SUMPRODUCT across tranches. This reusable model beats one-off calculators because you can tweak C2 per vest event if rates change or if your state introduces a new withholding formula.
Building Your Own Reusable Spreadsheet: Formulas That Work
Instead of relying solely on our Stock Vesting Schedule Calculator, I recommend a three-tab workbook: Grants, Tranches, Projection. The Tranches tab lists date, gross %, gross shares, FMV, withhold %, net shares. Use EDATE() for anniversaries and IF() to flag cliffs.
A unique framework I use is the “Vesting Waterfall Matrix”: rows are dates, columns are grant IDs, cells are net shares after tax. This lets you overlay multiple jobs. Below is a minimal formula pattern for a custom 10-20-30-40 plan:
- Cell D2 (Year1 %): 0.10
- Cell E2: =TotalShares*D2
- Cell F2 (Year1 net): =E2*(1-WithholdRate)
- Drag for years 2-4 with 0.20, 0.30, 0.40.
This beats competitor templates because it separates gross from net and handles odd percentages without hacking the tool. You can also add a column for “probability of milestone” if your grant is performance-based, multiplying expected shares by that factor to get risk-adjusted vesting.
Example SUMPRODUCT for Cumulative Net Value
Suppose tranches are in rows 2–5, net shares in column F, FMV in column B. Cumulative net value = SUMPRODUCT(F2:F5, B2:B5). This single cell replaces a manual addition chain and updates when you adjust tax rates. I keep a version of this matrix linked to my brokerage exports so I never recalculate by hand.
RSU vs. Stock Option Math: Why the Calculation Differs
Options require a strike price and an exercise decision; RSUs need only vest and settle. To calculate an option’s vested but unexercised value, you use (FMV − strike) × vested contracts. For RSUs, it’s FMV × vested shares. The 90-day rule applies to options, not RSUs, as noted. If you also hold options, our Stock Profit Calculator can layer both.
A misconception: “vested shares are free money.” They are taxable income. Another: “options and RSUs vest the same.” Options often have longer cliffs and the 90-day post-termination trap; RSUs rarely do. Know which contract you hold before applying any formula, because mixing the math leads to double-counting or missed tax liabilities.
Common Mistakes and Edge Cases When Calculating Vesting
Leap years: if grant date is Feb 29, some plans use Feb 28 on non-leap years—your anniversary shifts. Blackout periods: public companies may pause settlement during earnings quiet periods, delaying net shares by weeks. Double-trigger acceleration: in an acquisition, time-vested RSUs may convert only if you’re terminated within 12 months—your schedule calculation must add a conditional column.
I once modeled a merger acceleration as automatic and overestimated liquidity by $40k. The plan required involuntary termination; I stayed, so nothing accelerated. The limitation of any static spreadsheet is it can’t predict HR decisions. Always annotate assumptions in a notes column.
Partial-Year Proration and Mid-Cycle Hires
If you start halfway through a grant cycle, some plans prorate the first tranche. Calculate by days: (days employed / total days in period) × tranche %. This is where generic calculators fail; custom sheets shine. For example, a hire on July 1 with a Dec 31 year-end tranche might get 50% of that portion, not zero.
Modeling Multiple Grants and Job Changes
If you’ve changed jobs, you likely hold two vesting schedules simultaneously. The calculation principle is identical, but the matrix approach shines. Create a row per grant per tranche, then pivot by year. I maintain a “career equity” sheet that combines an old 4-year quarterly from a public company with a new 10-20-30-40 private grant. The net column reveals that my apparent yearly vesting jumped from 600 to 1,500 shares only because the back-loaded schedule kicked in—a fact a single-calculator view obscured.
When you leave a company, the unvested portion disappears; already vested RSUs remain yours subject to settlement. Options, again, trigger the 90-day clock. This is why separating award types in your spreadsheet prevents the common error of assuming all equity survives termination.
A Practical Framework: The Vesting Calculation Checklist
Use this decision matrix before trusting any number:
- 1. Identify award type: RSU, ISO, NSO, or phantom stock.
- 2. Extract tranches: list every date and % from the plan document, not the offer letter.
- 3. Apply cliff logic: zero before cliff date; full % on cliff.
- 4. Model tax layer: gross × (1 − total withhold) = net.
- 5. Check post-termination rules: 90-day for options, settlement lag for RSUs.
- 6. Stress-test dates: weekends, holidays, leap years, blackouts.
Most people don’t realize that the offer letter summary is often rounded; the plan document controls the math. Pull the PDF before calculating.
Putting It Together: A Full Worked Example
Imagine a 2023 grant of 5,000 RSUs with a 10-20-30-40 schedule, 1-year cliff on the 10%, FMV at vest: $40, $45, $50, $55, withholding 25% flat. Year1: 500 shares gross, net 375, value $15,000. Year2: 1,000 gross, net 750, value $33,750. Year3: 1,500 gross, net 1,125, value $56,250. Year4: 2,000 gross, net 1,500, value $82,500. Total net shares: 3,750; total value $187,500. Contrast with a 100% after 5 years plan: zero liquidity until year 5, then 5,000 shares net 3,750 at possibly different FMV—concentration risk.
If this person also faced a termination in year 2, RSUs already vested stay; unvested forfeit. No 90-day rule needed. But if they held options, they’d have 90 days to exercise vested ones—a completely separate calc. The exercise window math uses (FMV − strike) × vested contracts, and missing the deadline zeroes that value.
Why a Reusable Model Beats a One-Time Calculator
Calculators give a snapshot; a living spreadsheet adapts to new grants, tax law changes, and custom percentages like 10-20-30-40. The information gain here is the explicit net-share math and edge-case checklist missing from top results. When you can edit the withhold cell and see year-3 impact instantly, you’ve achieved true ownership of your equity story.
As you refine your model, remember the goal isn’t perfection—it’s eliminating surprises. The worst scenario I’ve seen is an employee who thought they were 50% vested because of a misread summary, only to discover a cliff at 2 years. Read the plan, build the rows, apply the tax, and you’ll know exactly where you stand. For ongoing tracking, revisit the Stock Vesting Schedule Calculator to sanity-check your manual figures each quarter.