This spreadsheet is not administration; it is a verdict tool. It separates guaranteed cash, contingent cash, and uncertain equity, then records every negotiation commitment with a date, source, and status. If you rank offers by headline TC alone, you will miss the offer with weaker vesting, softer level, or a worse path to promotion.
PM Offer Comparison Spreadsheet Template: TC Breakdown and Negotiation Log
TL;DR
This spreadsheet is not administration; it is a verdict tool. It separates guaranteed cash, contingent cash, and uncertain equity, then records every negotiation commitment with a date, source, and status. If you rank offers by headline TC alone, you will miss the offer with weaker vesting, softer level, or a worse path to promotion.
Thousands of candidates have used this exact approach to land offers. The complete framework — with scripts and rubrics — is in The 0→1 PM Interview Playbook (2026 Edition).
Who This Is For
This is for PM candidates who have 2 to 5 live processes, at least one verbal offer, and at least one recruiter who keeps saying “we may be able to move.” It is for people comparing a public-company RSU package against a private-company option grant, or a strong team pitch against a safer cash stack. It is also for candidates who already know that enthusiasm is not leverage and memory is not documentation.
What should a PM offer comparison spreadsheet actually track?
A useful spreadsheet tracks facts that survive a phone call. The problem is not the format; the problem is whether the sheet separates signal from sales language.
In a real offer review, the bad version is a single row that says “TC: $400k.” That row is theater. The useful version has columns for company, role level, team, location, base salary, target bonus, sign-on, equity grant, vesting schedule, refresh policy, start date, deadline, recruiter name, and whether the number is written or verbal. Add a notes field for the exact language used, because “we can probably do better” is not the same as “approved pending comp review.”
The spreadsheet should also carry status. Use labels like pipeline, verbal offer, written offer, negotiation in progress, and final. That forces honesty. Not “promised,” but “unconfirmed.” Not “likely,” but “documented.” Not “nice conversation,” but “decision-relevant commitment.”
In one candidate debrief I sat through, the sheet was technically complete and practically useless. Every number was there, but the candidate had not written down which terms were fixed and which were still floating. The hiring manager’s compensation note had already been translated into a level band, and the candidate was still arguing from the recruiter’s tone. That is how people confuse warmth with approval.
A clean sheet also records decision triggers. For example: “If Company A is within $20k of Company B in year-1 guaranteed cash, manager quality wins. If the gap is more than $50k, cash dominates unless scope is materially stronger.” That is not a spreadsheet feature. That is judgment made visible.
> 📖 Related: Datadog vs. New Relic: PM Salary Negotiation Strategies & Equity Analysis
How do you break down total compensation without fooling yourself?
You break it into guaranteed cash, conditional cash, and uncertain upside. The headline number is not the answer; the timing and certainty of the money are the answer.
Start with base salary. Base is the cleanest number because it lands every pay cycle and does not depend on quarter-end discretion. Then add target bonus, but record it as target, not guaranteed. A 15% target bonus is not a guarantee. A bonus that depends on company performance, manager calibration, or level sign-off belongs in a different bucket from base.
Then add sign-on cash, relocation, and any one-time make-whole payments. These matter more than candidates admit. A $30k sign-on paid in two installments is not the same thing as $30k on day one. A relocation stipend with receipts and caps is not free money; it is a reimbursement policy.
Equity needs the harshest treatment. Public-company RSUs with a four-year vesting schedule and a one-year cliff are not equal to private-company options with no liquidity path. A $250k RSU grant is a current compensation instrument. A $250k paper option value is a scenario, not a payout. If the company is private, note the strike price, the grant date, the vesting schedule, and whether secondary liquidity exists. Without that, the sheet is a mirror for hope.
Not paper TC, but realized TC. Not the biggest grant, but the cleanest conversion into cash. Not the founder’s story, but the probability the value survives until you can use it.
A practical way to normalize offers is to build three rows for each company: year 1 cash, year 2 cash, and four-year estimated value. Year 1 cash should include base, bonus target adjusted down if needed, sign-on, and any guaranteed cash. Four-year value should separate public RSUs from private options and should assume refreshers only if the company has a visible pattern and the manager has named it.
If two offers are within $20k to $30k in year-1 guaranteed cash, the real comparison starts to matter. If the gap is $50k or more, the weaker cash offer needs a much better story on scope, manager quality, or promotion path to justify itself. Otherwise, people talk themselves into a worse package because the upside looked prettier in the last column.
How do you log negotiation conversations so you do not lose leverage?
You log negotiation conversations to prevent memory from rewriting the record. The negotiation log is not a diary; it is an evidence trail.
Use one row per interaction. Record the date, channel, person, exact ask, exact response, next promised action, owner, and deadline. Add a status field with unverified, confirmed, and dead. That sounds rigid because the underlying process is rigid. Recruiters change tone. Commitments do not survive tone.
In one offer call, the recruiter said, “I think we can move on equity.” The candidate heard movement. Finance heard a conditional sentence. Two days later, the answer came back as a soft no dressed up as process. The candidate had no dated log, so they had no way to show that the conversation had evolved. That is not bad luck. That is a missing record.
The log also stops self-deception. Candidates routinely turn ambiguous language into leverage. “I’ll see what I can do” becomes “they want me.” “Let me talk to comp” becomes “they are fighting for me.” That is not judgment. That is projection.
Not recruiter enthusiasm, but recruiter commitment. Not a pleasant conversation, but a written change in terms. Not the last message, but the last approved number.
A serious log distinguishes three states. First, stated interest, which is cheap. Second, internal review, which is real but not final. Third, written revision, which is the only thing that changes your bargaining position. If the offer has not changed in writing, your leverage has not changed.
The log matters most when you have competing deadlines. If Company A gives you 48 hours and Company B says it needs “a few more days,” write that down exactly. Deadlines create pressure. Pressure creates sloppy memory. Sloppy memory creates bad comparisons.
> 📖 Related: uber-pm-vs-swe-salary
How do you compare public, private, and startup offers?
You compare certainty, liquidity, and trajectory, not company mythology. The logo is not the package.
A public-company offer usually wins on clarity. The base is real, the bonus target is legible, and RSUs have a visible vesting path. A private-company offer can win on scope or upside, but only if the equity is understandable and the company has a believable path to liquidity. A startup offer can win only when the role change is meaningful enough to justify the risk, not because the founder speaks with confidence.
In a compensation review I watched after a strong onsite, the hiring manager pushed for a higher level, but finance held the package one band lower because one panel note said “solid, not standout” on product sense. The candidate later compared only headline TC and thought the company was lowballing them. The real issue was level. Once level is wrong, every compensation number is distorted. The spreadsheet should reveal that immediately.
That is the organizational psychology trap. Candidates overread the most flattering number and underread the structural one. The number gets attention because it is concrete. The level gets ignored because it is institutional. But level determines future raises, promo timing, peer calibration, and sometimes even equity refresh behavior.
A good comparison sheet therefore has a separate column for role quality. Write down whether the role is senior enough, whether the manager has budget authority, whether the team is known for shipping, and whether the job appears to be a true step up or just a brand-name lateral move. Not “exciting team,” but “scope with budget.” Not “fast-growing company,” but “promotion path with evidence.” Not “strong mission,” but “strong enough package to absorb the risk.”
If the private offer depends on a secondary market, a future financing, or a hypothetical acquisition, mark that as speculative. If the public offer pays less in equity but has a stable refresh pattern and a cleaner path to promotion, that may be the smarter decision even when the startup pitch sounds sharper in the room. People remember the story they were told. They forget the mechanics that pay them.
What numbers matter most in year 1 versus year 4?
Year 1 cash is the anchor; year 4 is optional unless the company has already proven retention and liquidity. That is the part people dislike because it removes romance from the decision.
Year 1 should capture base, target bonus, sign-on, relocation, and any guaranteed first-year cash. That is what you can actually bank if the team changes, the manager leaves, or the market turns. Year 4 should capture vesting completion, expected refreshers, and the likely value of staying long enough to matter. If the model assumes a refresh in month 18, write that down as an assumption, not a fact.
A lot of candidates make the same mistake: they use the farthest-out value to justify the closest-out decision. That is backwards. A four-year grant does not help if you leave in 14 months. A refresh policy that exists only in recruiter language does not belong in the core math. A promotion that “usually happens” after 18 months is not a schedule.
Not the full grant, but the portion you will probably vest before your life changes. Not the promotion story, but the actual review cycle. Not the upside curve, but the point where cash becomes real.
A sheet that is honest about time should show year 1, year 2, and year 4 separately. That makes the tradeoff visible. Some offers are front-loaded. Some are back-loaded. Some are balanced but slow. If you are moving from a stable job into a risky one, year 1 matters more. If you are already committed to a 3-year run, year 4 matters more. The sheet should not pretend those are the same decision.
When candidates ask whether a spreadsheet can compare offers fairly, the answer is yes, but only if they stop treating all years as equal. The first year is about survival and fit. The fourth year is about retention and comp compounding. Confusing those two is how people pick the wrong job for the wrong reason.
When does the spreadsheet change the decision and when does it not?
The spreadsheet changes the decision when the offers are close enough that judgment, not arithmetic, should decide. It does not change the decision when one offer is clearly better on guaranteed value and the other is only better in storytelling.
If one package leads by more than $50k in year-1 guaranteed cash, the burden is on the weaker package to prove that the role quality is materially better. If the offers are within $20k, then manager quality, role scope, and team trajectory can reasonably decide it. That is a rough rule, not a law, but it is better than pretending all differences are equal.
The spreadsheet also tells you when to stop negotiating. If the final delta is small and the company has already shown its ceiling, more calls will not produce a different answer. If the log shows repeated “needs approval” language with no written movement, you are not in a negotiation. You are in a waiting pattern.
The problem is not your spreadsheet format. The problem is your decision rule. Candidates often build a perfect sheet and then ignore it when the most charming recruiter calls. That is the real test. The point of the template is to protect you from your own optimism.
Not the prettiest offer, but the best downside. Not the largest number, but the cleanest path. Not the most flattering conversation, but the package that survives scrutiny.
A good spreadsheet does one thing that most candidates fail to do: it makes the hidden assumption explicit. If you are assuming a promotion in 12 months, write it. If you are assuming a refresh, write it. If you are assuming liquidity, write it. Once the assumption is visible, it can be judged. That is the whole game.
Preparation Checklist
The spreadsheet only works if the inputs are disciplined. Sloppy inputs produce confident mistakes.
- Create one row per company and one column per fact: level, base, bonus target, sign-on, equity grant, vesting schedule, refresh policy, deadline, and status.
- Separate guaranteed cash from contingent cash. Base and signed cash belong in one bucket. Bonus targets and hoped-for refreshers belong in another.
- Add a negotiation log tab. Record date, channel, person, exact ask, exact response, and next committed action.
- Normalize every offer into year-1 cash and four-year realized value. If the model cannot survive that split, the offer is not understood yet.
- Write one decision rule before you compare anything. For example: “If year-1 guaranteed cash is within $20k, choose scope and manager; if it is over $50k apart, cash wins.”
- Work through a structured preparation system (the PM Interview Playbook covers offer debrief examples and negotiation logs for base, equity, and refreshers in real hiring-loop cases).
- Put one final column in the sheet called “what would change my mind.” If nothing belongs there, you are pretending to deliberate.
Mistakes to Avoid
The common failure is not a bad spreadsheet. It is a dishonest comparison.
- BAD: “Offer A is $420k TC, so it wins.” GOOD: “Offer A is $180k base, $30k sign-on, and $210k RSUs, but Offer B has more guaranteed cash and a cleaner vesting path.”
- BAD: “Recruiter said they can probably make it work.” GOOD: “Recruiter wrote that comp will be reviewed after leveling approval, and the log marks it as unconfirmed until the email arrives.”
- BAD: “I compared the first year only.” GOOD: “I compared year-1 cash, year-2 retention risk, and four-year realized value before I decided.”
FAQ
- Should I rank offers by total comp?
No. Rank them by guaranteed value first, then by role quality. Headline TC hides the differences that matter most, especially when one offer is cash-heavy and the other depends on equity or future refreshers.
- Do I include verbal promises in the spreadsheet?
Yes, but label them as unverified until they are written. A verbal promise is useful as a negotiation signal, not as compensation. If it is not in writing, it does not belong in the final math.
- Is a spreadsheet enough to decide?
No, but it prevents bad decisions from looking organized. The spreadsheet exposes the tradeoff. The final call still depends on whether the role has the manager, scope, and comp structure to justify the risk.
Ready to build a real interview prep system?
Get the full PM Interview Prep System →
The book is also available on Amazon Kindle.