PM Offer Evaluation Spreadsheet Template: Compare TC Across Companies

PM Offer Evaluation Spreadsheet Template: Compare TC Across Companies

The right template is a four-year decision sheet with separate lines for base, bonus, sign-on, equity, vesting, refresh policy, location, and qualitative risk. In a debrief, the offers that looked “best” on paper usually lost once the room priced in manager quality, cliff risk, and whether the equity was real or just decoration.

This is not a budgeting exercise. It is a judgment exercise, and the sheet should make that judgment visible in one glance.

I have seen this exact situation in offer debriefs: a candidate with a clean senior PM loop at a late-stage company, a growth-stage startup, and one internal transfer option, all with different mixes of base, bonus, equity, and sign-on. The weak decision is not choosing wrong on math. The weak decision is pretending the math is the whole story.

How do I compare PM offers that look impossible to line up?

In one Q3 debrief, the hiring manager pushed hard for a candidate because Company A showed a $238,000 headline TC. The committee killed that argument in five minutes. Half the package depended on an equity grant with no believable liquidity path, while Company B paid $194,000 base, a $32,500 sign-on, and more first-year cash than the “higher TC” package would actually deliver. The candidate was not choosing between $238,000 and $194,000. They were choosing between certainty and a story.

The first counter-intuitive truth is that headline TC is often the weakest signal in the packet. It is not the number you live on. It is the number used to end the conversation early. Not headline TC, but guaranteed value is what you should compare first.

I use a simple rule: compare the cash you can touch in year one, then compare the value you plausibly realize over four years, then decide whether the remaining gap is worth the risk. That sequence matters. Not all dollars are equal, and not all equity is compensation. A recruiter can say “same total comp” while one offer is mostly RSUs at a stable public company and the other is mostly options at a company with no secondary market. Those are different instruments, not different versions of the same thing.

The script I use when I need a recruiter to send the full details is blunt and clean: “I’m comparing the offers on a normalized four-year basis. Please include base, target bonus, sign-on, equity grant size, vesting schedule, refresh policy, and location.” That line works because it removes the emotional framing. It tells them you are not bargaining by vibe.

What should go into the spreadsheet?

A practical template looks like this:

`text

Company

Level

Location

Base salary

Target bonus

Sign-on year 1

Sign-on year 2

Equity type

Equity grant value

Vesting schedule

Refresh policy

Start date

First-year guaranteed cash

Four-year cash

Four-year equity value

Risk notes

Qualitative veto

Final ranking

`

That structure does one thing well. It forces the same offer to answer the same questions every time. Not a list of comp components, but a map of decision power.

The second counter-intuitive truth is that the spreadsheet is not mainly for arithmetic. It is for exposing hidden assumptions. In a compensation review I sat through, the candidate’s sheet treated startup options like RSUs because both rows had a dollar sign in the headline. The room stopped talking about compensation and started talking about whether anyone had actually read the strike price. That is the point. Once the assumptions are visible, people stop bluffing.

I keep a separate assumptions tab because the numbers lie if you let them travel alone. If a company says refreshers are “policy dependent,” that is not a stable input. If a private company says there is “strong upside,” that is not a valuation model. If a base salary is high but the start date slips by six weeks, that is not a small detail. It is missed cash, and the sheet should show it.

The recruiter-facing version of the sheet should be clean. The internal version should be merciless. Put private notes in a risk column, not in the public summary. If the manager was vague, write it down. If the scope looked thin, write it down. If the company needed you to believe the equity story more than explain it, write that down too.

How do I normalize equity, sign-on, bonus, and vesting?

A public-company offer and a startup offer can both say “equity,” but the resemblance ends there. I have watched a PM compare 8,000 RSUs at a late-stage company with 120,000 options at a Series D startup as if the spreadsheet could divide by share count and settle the matter. It cannot. The public package pays on a known vesting schedule with a market price you can inspect. The startup package depends on exit timing, dilution, strike price, and whether the company ever creates liquidity. Not the same asset, not the same risk, not the same decision.

The third counter-intuitive truth is that sign-on is often more valuable than equity when the decision window is short. A $40,000 sign-on is real. A large option grant with no liquidity path is theoretical until proven otherwise. Not more equity, but more certainty is what fixes a first-year cash gap.

I normalize equity by keeping the math honest and the assumptions explicit. For RSUs, I treat the grant as real compensation spread across the vesting schedule. For options, I treat the upside as a separate line with a risk note, not as cash. If a company gives a refresh policy in writing, I include it. If it says “we usually refresh strong performers,” I do not give that sentence the weight of a contract.

The cleanest script for a negotiation call is this: “I’m comparing your package against an offer with stronger guaranteed cash and lower risk. If you can improve base or sign-on, I can move faster.” That is a judgment statement, not a threat. It tells the recruiter exactly what gap matters.

Here is the comparison logic I actually use when the packages are close. If one offer wins on guaranteed cash, that offer gets the first pass. If another offer wins on upside but loses on manager quality or scope, I mark it as a speculative bet. If a third offer wins on both money and role quality, there is no spreadsheet problem to solve. The answer is obvious.

How do I use the spreadsheet in negotiation calls?

In one offer call, the recruiter tried to compress everything into a single question: “What will it take to get a yes?” The candidate made the mistake of reading off the spreadsheet line by line. That is what people do when they want to sound rigorous. It usually sounds evasive. The stronger response was simpler: “The issue is not headline TC. It is the amount that is guaranteed in the first 12 months.” Once they said that, the recruiter knew whether they could move base, sign-on, or both.

Not a bargaining chip, but a truth serum is what the spreadsheet should be. It tells you whether the offer team can actually solve the problem you have. If the only move they can make is to polish the number, the offer is weak. If they can fix the cash gap, clarify the role, or improve the manager match, the offer is live.

I use two scripts depending on the gap. If the numbers are close and the role is clearly better, I say: “I’m not optimizing for the highest headline number. I’m optimizing for the package that gives me the best first-year certainty and the right scope.” If the package is materially behind, I say: “I want to move forward, but I need you to close the difference in guaranteed cash or I can’t justify choosing this over the other offer.”

That is how strong candidates negotiate. Not by arguing every line, but by naming the one or two lines that matter. In hiring debriefs, the candidate who can do that reads as coherent. The one who keeps circling the spreadsheet reads as uncertain.

When should I ignore the highest total compensation?

I watched a strong PM turn down the highest package because the equity was mostly paper, the manager was vague on scope, and the role had a two-quarter runway before the candidate would touch anything meaningful. The hiring manager was irritated because the TC number looked competitive. The debrief ended differently. The team agreed the candidate made the right call. The offer was numerically strong and structurally weak.

The fourth counter-intuitive truth is that the best offer can be the one with lower TC if it buys you stronger learning, cleaner scope, and a better manager. Not the most money, but the best decision is what the spreadsheet should reveal. If you are likely to leave in nine months because the role is dead on arrival, the extra comp is a bad trade.

I keep a qualitative veto column for exactly this reason. If the manager is a problem, the team is unstable, or the job is smaller than advertised, no amount of extra equity should erase that note. A spreadsheet that only ranks compensation is incomplete. A spreadsheet that also records whether you trust the operating environment is closer to reality.

The script I use when the highest TC is not my choice is direct: “I appreciate the offer, but I’m choosing based on the package and the role together. The higher headline number does not outweigh the scope and manager differences.” That is a judgment, not an apology. People respect it because it is coherent.

How to Get Interview-Ready

• Create one row per offer with base, bonus, sign-on, equity, vesting, refresh policy, location, and deadline.
• Add a separate assumptions tab for equity treatment, liquidity risk, and anything the recruiter said verbally but did not put in writing.
• Put first-year guaranteed cash in its own column and keep it visually separate from four-year expected value.
• Add a qualitative veto column for manager quality, scope, team stability, and whether the role is actually the level you want.
• Work through a structured preparation system (the PM Interview Playbook covers offer evaluation tradeoffs with real debrief examples) so your ranking logic is consistent under pressure.
• Draft two negotiation lines before the offer call, one for a modest gap and one for a material gap.
• Send the cleaned version of the sheet to a trusted peer before you answer, so someone else can spot where you are rationalizing.

Common Pitfalls in This Process

1. Comparing headline TC only

BAD: “Offer A is $250,000 and Offer B is $225,000, so A wins.”

GOOD: “Offer A is $250,000 headline, but a large share is uncertain equity. Offer B pays more guaranteed first-year cash, so I need to compare risk, not just totals.”

1. Mixing equity types

BAD: “120,000 options equals 120,000 RSUs.”

GOOD: “I separate RSUs, options, strike price, cliff, vesting, and refresh policy. If the instrument is different, the value is different.”

1. Using the sheet to fake leverage

BAD: “Company C is only $12,000 behind, so you should match exactly.”

GOOD: “Company C changes the decision because it improves guaranteed cash and role quality. If you want a yes, close the certainty gap rather than polish the headline.”

FAQ

Q: Should I always take the highest TC?

A: No. The highest TC is only the best offer if the money is real, the role is strong, and the manager is credible. If the extra dollars are mostly illiquid equity or come with a weak scope, the number is a trap, not a verdict.

Q: How much should I discount startup equity?

A: Discount it enough that you stop treating options like cash. If the company is private and there is no clear liquidity path, keep the equity as upside in the sheet, not as guaranteed compensation. The point is not to guess the exit. The point is to avoid pretending.

Q: Can I send my spreadsheet to the recruiter?

A: Yes, but send the clean version. Give them the columns that explain your decision, not the private notes about manager quality or internal politics. The sheet should help them close the gap, not force them to argue with your ranking.

---

Ready to build a real interview prep system?

Get the full PM Interview Prep System →

The book is also available on Amazon Kindle.