The spreadsheet is not record-keeping; it is leverage. A PM who can map RSU vesting by month usually understands the offer better than the recruiter presenting it.
PM RSU Vesting Schedule Spreadsheet Template: Track Your Total Comp Over Time
TL;DR
The spreadsheet is not record-keeping; it is leverage. A PM who can map RSU vesting by month usually understands the offer better than the recruiter presenting it.
The problem is not the grant size, but the payout path. A large headline number can still be weak if the first meaningful vest is late and the refresh story is vague.
Track total comp over 48 months, not year-one theater. That is the only view that survives an offer comparison, a promotion cycle, and the moment you decide whether to stay.
Most candidates leave $20K+ on the table because they skip the negotiation. The exact scripts are in The 0→1 PM Interview Playbook (2026 Edition).
Who This Is For
This is for PMs comparing offers from public tech companies, late-stage startups, and internal moves where equity is part of the pitch. It is also for anyone who hears “competitive package” and wants the number translated into actual cash over time.
In offer debriefs I have sat through, the people who sounded strongest were not the ones who recited RSU jargon. They were the ones who could explain what month 12, month 24, and month 36 looked like in dollars, not just in shares.
Not every reader needs this template, but anyone moving companies, moving levels, or moving from salary-only to salary-plus-equity does. Not headline compensation, but vest timing, is what determines how the offer behaves in real life.
What should a PM RSU vesting spreadsheet actually track?
A useful template tracks vest dates, vest amounts, share price, tax treatment, and the cash position at each quarter. Anything less is a summary, not a decision tool.
In a comp review I once watched, the hiring manager kept repeating that the package was “strong.” The candidate pulled up a month-by-month view and the room changed immediately, because the first year was thin and the second year was carrying the weight. That is the real function of the spreadsheet: it turns vague confidence into visible timing.
The template should have one row per vest event and one summary line per year. Include grant date, grant size, vest schedule, current price, estimated vest-date value, withholding, and post-tax cash you can actually spend.
Not grant letter, but vest schedule, is the primary object. Not RSU count, but vest date, determines when the money matters.
A simple example makes the point. If a PM gets 400 RSUs at a $180 reference price, the paper value is $72,000 at grant. That is not $72,000 in your account. If the first quarter of the grant only becomes available after 12 months, the timing is doing as much work as the number itself.
The spreadsheet should also separate paper value from realized value. Public-company RSUs can look clean on the offer page and still behave badly if the stock moves, the tax withholding is higher than expected, or you leave before the next vest date.
The best templates have a separate assumption tab. That is where you note whether the company vests monthly or quarterly, whether refreshers are annual or ad hoc, and whether the offer includes a sign-on payment intended to offset the cliff.
> 📖 Related: Spotify PM return offer rate and intern conversion 2026
How do I compare PM offers with different vesting schedules?
Compare offers on month-by-month cash and 48-month value, not on grant size. A larger grant with slower vesting is often weaker than a smaller grant that starts paying earlier.
In one offer debrief, a candidate was fixated on 600 RSUs at a high share price. Another offer had fewer shares, but the vesting started earlier and the sign-on cash covered the first-year gap. The better offer was not the larger headline number. It was the one that gave the candidate more usable value before the next review cycle.
The right comparison has three views. First, the value at sign date. Second, the value at month 12, when a cliff usually changes the picture. Third, the value by month 48, when the full grant has had time to mature.
Not total grant value, but vest cadence, is what makes one offer better than another.
If one offer is $220,000 base with $25,000 sign-on and 300 RSUs, and another is $200,000 base with no sign-on but 450 RSUs, the spreadsheet should not stop at the share count. It should show what lands by month 12, what lands by month 24, and whether the second offer only wins if you stay long enough to earn the back end.
That is the counterintuitive part. The stronger-looking package often belongs to the company with the weaker retention mechanics. The spreadsheet exposes that.
I have seen hiring managers push back when a candidate asked for more RSUs without discussing the vest shape. The committee room usually settles on one question: does this person understand cash flow, or are they just reading the offer like a press release? The spreadsheet answers that question fast.
What does a good PM RSU spreadsheet template look like?
A good template is ugly in the right way. It is built to be legible under pressure, not impressive in a demo.
The core layout should be one tab for assumptions, one tab for each offer, and one comparison tab. That is enough to keep the decision clean. Everything else is decoration unless you are managing multiple grants across multiple years.
Each offer tab should include the same fields: company name, role, level, base salary, annual bonus, sign-on cash, RSU grant size, grant price, vesting cadence, first vest date, subsequent vest dates, estimated tax withholding, and total after-tax value at each vest event.
The comparison tab should show month 12, month 24, month 36, and month 48. Those four checkpoints are more useful than a long stream of dates because they line up with real decision moments: first performance review, first possible refresh, second-year retention, and full vest completion.
Not pretty formatting, but comparable assumptions, is the difference between a tool and a distraction.
If the company is public, use the current share price for decision-making and the grant price for historical accuracy. If the company is private, use the latest tax-relevant reference point for modeling, but do not confuse it with liquidity. A number is not value until you can convert it into cash.
I have seen PMs lose hours arguing about whether the right screenshot was the grant letter or the onboarding portal. That is amateur behavior. The spreadsheet should answer one question only: what is the compensation worth, by date, under the assumptions I am willing to defend?
The best template also records refresh assumptions separately. If a recruiter says refreshers are standard, put that in a note, not in the value column. A promise is not a cash flow.
> 📖 Related: Scale AI Program Manager Salary in 2026: Total Compensation Breakdown
When does RSU math change the decision?
RSU math changes the decision when the offers are close enough that timing matters more than headline size. It also changes the decision when you expect to leave or renegotiate before the full grant has vested.
In a Q3 compensation conversation, a hiring manager leaned on prestige and scope. The candidate ignored the brand language and looked at the first-year vest. That was the right move. If you are likely to hit a new decision point in 12 to 18 months, year-one value matters more than theoretical four-year value.
Not prestige, but payout timing, is what makes one offer safer than another.
This is where most people get the lens wrong. They treat equity as upside. In practice, it is often retention. The company is not just paying you; it is shaping the odds that you stay through the next cycle.
That is why back-loaded offers deserve skepticism. A package that looks rich on paper can be weak if most of the value sits beyond the period you are realistically planning to stay. The spreadsheet is supposed to reveal that, not hide it.
One PM I saw in a debrief almost took a lower-base offer because the recruiter kept repeating the total equity number. The spreadsheet showed that the “larger” offer had a thinner first year, a slower vest path, and no meaningful refresh discussion. The candidate chose the smaller headline package because it behaved better in the actual months that mattered.
That was not conservatism. That was judgment.
How should I use the template before I negotiate?
Use it before the negotiation, because the shape of the offer is easier to change than the final number in some cases. Once the offer is signed, the leverage drops and the spreadsheet becomes forensic instead of strategic.
The first move is to identify where the offer is brittle. If year-one value is weak, ask for a sign-on payment or a stronger first vest, not just more shares. If the vest schedule is slow, ask whether the company will adjust the cash mix. If the refresh story is vague, treat it as zero until someone puts a policy in writing.
In one hiring manager conversation, the candidate came in with a month-by-month comp table and asked for a sign-on top-up to cover the vest gap. The request was specific, calm, and hard to dismiss. The recruiter’s response changed from “we are at band” to “we can revisit structure.” That is what a good spreadsheet does: it turns a generic request into a precise one.
Not more RSUs, but better structure, is often the stronger negotiation ask.
Use the template to decide whether the problem is the grant size, the sign-on, or the vest timing. If the package is only acceptable because you assume an annual refresh, that assumption belongs in a separate cell and a separate sentence.
The point is not to become a compensation hobbyist. The point is to stop confusing a paper offer with a usable one. That distinction matters when you are making a move that will shape the next two years of your career.
Preparation Checklist
The spreadsheet works only if the assumptions are disciplined. Sloppy inputs produce confident nonsense.
- Create one tab per offer and one shared assumption tab so you do not cross-contaminate numbers.
- Enter base salary, bonus, sign-on cash, RSU grant size, vest cadence, and first vest date before you compare anything.
- Add month 12, month 24, month 36, and month 48 checkpoints so you can compare offers on the same horizon.
- Separate paper value from realized after-tax cash so you do not mistake vested shares for spendable money.
- Note refresh assumptions in a text field and leave the value column at zero unless the company has a concrete pattern.
- Work through a structured preparation system (the PM Interview Playbook covers compensation tradeoffs and real debrief examples, which is the part people usually hand-wave).
- Revisit the file after each vest, each refresh grant, and each promotion conversation so the template stays tied to reality.
Mistakes to Avoid
The failures are predictable, and they are expensive.
- Mistake: treating grant size as the answer.
BAD: “This offer has 500 RSUs, so it is better.”
GOOD: “This offer vests later, so year-one cash is weaker even if the grant is larger.”
- Mistake: ignoring taxes and vest timing.
BAD: “Vested shares equal spendable income.”
GOOD: “Vested shares are taxable income, and cash flow depends on withholding and whether I sell when they vest.”
- Mistake: assuming refreshers are guaranteed.
BAD: “They said refreshers happen, so I will count them as part of the offer.”
GOOD: “Refreshers are an assumption, not a term, unless they are written or clearly historical.”
FAQ
Should I use grant-date value or current market value? Current market value is the right number for decision-making, while grant-date value is only useful for historical context. The recruiter’s story starts at grant date. Your decision starts at the price you can actually compare today.
Do I need separate sheets for each offer? Yes. One sheet per offer keeps assumptions clean and prevents false comparisons. If two packages live in the same tab, the stronger branding will start to distort the numbers.
What if my company is private? Treat the numbers as conditional, not liquid. Use the latest tax-relevant reference point for modeling, but do not pretend the equity is cash until the company creates a path to liquidity.
Ready to build a real interview prep system?
Get the full PM Interview Prep System →
The book is also available on Amazon Kindle.