PM Comp Calculator Spreadsheet vs Levels.fyi: Which Tool Gives More Accurate RSU Projections for L5 PMs?

The candidate who trusts Levels.fyi blindfolded leaves $180,000 in unvested equity on the table because they failed to model the refresh mechanics.

In Q4 2023, a hiring committee for a L5 Product Lead role at a top-tier ad-tech firm rejected a finalist not for lack of skill, but because their counter-offer relied entirely on public data aggregates. The candidate presented a printout from a popular compensation site showing a median total compensation of $345,000. The hiring manager, holding the actual internal band data, knew that number included sign-on bonuses that never repeat and RSU grants that were front-loaded in a way the public site could not decipher. The debate in the debrief room was not about the candidate’s product sense; it was about their financial literacy. They treated a dynamic, multi-year equity instrument as a static salary figure. This is the fundamental error. Public aggregators are marketing tools for candidates to feel good; spreadsheets are negotiation weapons for candidates to get paid. The difference is not accuracy of data entry; it is the depth of mechanical understanding regarding vesting schedules, refresh grants, and tax implications. If you walk into a final round with a screenshot instead of a modeled cash flow projection, you signal that you cannot handle the complexity of the role you are applying for.

Why Do Levels.fyi Projections Often Overestimate L5 PM Total Compensation?

Levels.fyi systematically overestimates L5 Product Manager compensation because it averages front-loaded sign-on bonuses into annual recurring revenue, creating a phantom income stream that disappears after year two.

The platform operates on a self-reported model where users submit their offer letters, often during the peak excitement of closing a deal. In these submissions, a candidate with a $340,000 first-year package might break it down as $175,000 base, $50,000 sign-on, and $115,000 in RSUs. When this data hits the aggregator, the algorithm often smooths this into a “Year 1” and “Year 2” average, or worse, displays it as a singular “Total Compensation” figure without adequately flagging the one-time nature of the signing bonus. I sat in a calibration meeting where a recruiter explicitly stated they would not match a candidate’s expectation derived from such a site because “we do not pay sign-ons in year three.” The candidate expected $340,000 recurring. The company offered $265,000 recurring. The gap was not malice; it was a misunderstanding of the data structure.

The first counter-intuitive truth is that higher reported numbers on public sites often indicate less sustainable compensation packages, not better ones. A L5 PM offer with a massive sign-on often compensates for a below-market equity grant or a lower base salary band. When you see a $400,000 total comp figure on a public site, you must immediately dissect it. Is the base $190,000 or $160,000? Is the equity $200,000 vested over four years, or $300,000 with a steep cliff? Public sites rarely normalize for the “back-weighted” vesting schedules that FAANG companies use, where year three and four payouts are significantly larger than year one and two if no refresh grants are issued. By averaging these, the site creates an illusion of stability that does not exist.

Consider the specific mechanics of RSU vesting at a company like Meta or Google. A standard grant might vest 25% annually, or follow a 35/35/15/15 schedule. Levels.fyi displays the “grant value” at the time of signing. It does not model the stock price volatility over the four-year vesting period, nor does it account for the fact that L5 PMs receive “refresh” grants annually, which are typically smaller than the initial grant but crucial for maintaining total comp. If the stock price drops 20% in year two, the public site’s historical data becomes irrelevant to your future earnings. A spreadsheet allows you to input a bear case, a base case, and a bull case for stock performance. It forces you to confront the reality that your $150,000 equity grant could be worth $90,000 or $220,000 depending on market conditions. Relying on a static median value ignores this risk entirely.

The second counter-intuitive truth is that precise, lower-looking numbers in a negotiation carry more weight than rounded, higher-looking aggregates. When a candidate says, “I am looking for $350,000 based on Levels.fyi,” the recruiter hears noise. When a candidate says, “My model shows that to match my current vesting acceleration and projected refreshes, I need a base of $178,000 and an initial grant of $210,000 to hit a year-three cash flow of $315,000,” the recruiter hears a peer. The former is a demand based on internet research; the latter is a business case based on financial modeling. In the debrief for a L5 role at a major cloud provider, the hiring manager noted that the candidate who brought a spreadsheet “understands the P&L of their own career.” That candidate got the offer at the top of the band. The candidate who quoted the website got a standard package.

How Does a Custom Spreadsheet Model RSU Vesting Schedules More Accurately Than Aggregators?

A custom spreadsheet models RSU vesting accurately by simulating specific vesting cliffs, refresh grant cadences, and tax withholding events that static aggregators simply cannot calculate.

The core failure of public data sites is their inability to handle time-series complexity. They present a snapshot, not a movie. A L5 Product Manager’s compensation is a four-year movie with plot twists. Your initial grant vests on a specific schedule. Your annual refresh grants, which usually start in year two, vest on a different schedule, often creating a “stacking” effect where you have multiple tranches vesting simultaneously. A spreadsheet allows you to build a month-by-month cash flow projection. You can input the exact grant date, the vesting start date, and the specific percentage that vests each quarter. More importantly, you can model the “refresh.” At companies like Amazon or Microsoft, L5 PMs are expected to receive annual equity top-ups. These are not guaranteed, but they are standard for high performers. A spreadsheet lets you assume a conservative refresh rate, say 60% of your initial grant prorated, and see how that impacts your year four income.

In a negotiation with a fintech unicorn preparing for IPO, the difference between a site quote and a spreadsheet model was $45,000 in perceived value. The candidate used a spreadsheet to show the recruiter that the competitor’s offer, while having a higher initial grant value, had a slower vesting schedule in the critical second and third years. The candidate’s model highlighted a cash-flow gap in month 18 where their liquidity would be tight due to tax withholdings on vesting events. They asked for a larger sign-on to bridge that specific gap, framing it as a “cash flow neutrality” request rather than a greedy demand. The recruiter, seeing the granular math, approved the increase because it solved a logical problem rather than just inflating a number. Public sites cannot generate this kind of insight because they do not know your specific start date, your specific tax bracket, or the specific vesting rules of the competing offer.

The third counter-intuitive truth is that the most valuable part of a compensation package is often the year three and four equity, which public sites undervalue due to recency bias. Users submit data when they get hired. Very few users return to update their data three years later when the stock has matured or tanked. This means the data on these sites is heavily skewed toward “offer day” valuations, which are often inflated by hype. A spreadsheet forces you to apply a discount rate. If you are joining a pre-IPO company, your spreadsheet should model the liquidity event probability. If you are joining a public company, it should model historical volatility. When you present a negotiation stance based on a conservative, modeled year-four value, you demonstrate long-term thinking. You signal that you are not a mercenary looking for a quick flip, but a leader planning a tenure. This psychological signal is powerful in hiring committees that are risk-averse.

Furthermore, spreadsheets allow for the integration of tax implications, which vary wildly by location and company structure. An L5 PM in California facing a 50% marginal tax rate on vested RSUs needs a different structure than one in Texas or Washington. Some companies offer tax gross-ups or different withholding methods. A spreadsheet can calculate the net-after-tax cash flow, which is the only number that actually matters for your lifestyle. Public sites show gross numbers. They show the $200,000 grant, not the $110,000 that hits your brokerage account after federal, state, and FICA taxes. In a debrief for a senior role, a hiring manager rejected a candidate who focused on gross equity, noting, “They don’t understand their own net worth.” The candidate who understood their net cash flow got the job. The tool you use dictates the sophistication of your argument.

What Specific Data Points Must Be Included in a L5 PM Compensation Spreadsheet?

A viable L5 PM compensation spreadsheet must include base salary escalation curves, sign-on amortization, initial and refresh RSU grant values, vesting schedules, dividend yields, and estimated tax withholdings.

Building this model requires more than just copying numbers from an offer letter. You need to construct a dynamic engine. The first tab should be your “Inputs” sheet. Here, you list the Base Salary, but you also include a column for “Merit Increase Assumption.” L5 PMs at top firms typically see 3% to 5% base increases annually, plus potential promotions to L6 which jump 15% to 20%. Ignoring this growth understates your future value. Next, the Sign-On Bonus. Do not just list the total. Break it into “Year 1 Payout” and “Year 2 Payout,” as many companies split these. Then, the RSU Grant. This needs a “Share Count” and a “Current Share Price,” not just a dollar value. This allows you to change the share price assumption later without breaking the math.

The second critical component is the “Vesting Schedule Matrix.” This is where most candidates fail. You must map out the vesting dates for the initial grant. Is it 25/25/25/25? Is it 5/15/20/20/20/20? You need to know exactly when shares hit your account. Then, you must add rows for “Refresh Grants.” Assume you get a refresh in Year 2, Year 3, and Year 4. Estimate the size of these refreshes. A conservative estimate is 20% to 30% of the initial grant per year for a high performer. A aggressive estimate is 50%. Model both. This gives you a range of outcomes. If the company asks, “What do you need to join?” you can show them the “Conservative Case” where you need a larger initial grant to compensate for smaller expected refreshes.

The third layer is “Tax and Liquidity.” Create a column for “Estimated Tax Withholding.” For RSUs, companies typically sell to cover (STC) about 40% to 50% of the vested shares immediately to pay taxes. Your spreadsheet should calculate “Net Shares Vested” and “Net Cash Received.” This prevents the shock of seeing a $50,000 vesting event turn into $25,000 in your account. Include a row for “Exercise Cost” if there are stock options involved, though L5 PM roles are increasingly RSU-heavy. Finally, include a “Total Liquid Compensation” row that sums Base + Net RSU Cash + Sign-On. This is your true number.

When building this, do not guess the inputs. Use the Preparation Checklist to ensure your data sources are solid. Work through a structured preparation system (the PM Interview Playbook covers compensation modeling with real debrief examples and specific vesting schedule templates for FAANG L5 roles) to validate your assumptions against actual offer structures. The playbook details how to derive the refresh grant percentages based on company stage, which is a variable most candidates leave blank. Leaving it blank is a luxury you cannot afford when negotiating a $300,000+ package. The difference between a generic template and a calibrated model is the difference between a standard offer and a competing bid that forces the recruiter to go back to the compensation committee.

When Should Candidates Rely on Custom Models Instead of Public Data During Negotiations?

Candidates should rely on custom models exclusively during the final negotiation phase and when comparing offers with different vesting structures or equity types, reserving public data only for initial salary range screening.

Public data has one valid use case: establishing the broad market band before you even apply. If you are targeting L5 roles, you need to know if the base salary floor is $160,000 or $190,000. Levels.fyi is excellent for this high-level sanity check. It prevents you from wasting time on companies that pay below market. However, the moment you have a live offer or are in the final loop, public data becomes a liability. Using it in a negotiation with a recruiter is like bringing a plastic sword to a gunfight. It signals that you have not done the deep work.

The transition point is the “verbal offer.” Once the recruiter calls to discuss numbers, switch entirely to your spreadsheet. When they ask, “What are your expectations?” do not give a single number. Say, “I have modeled my compensation requirements based on a four-year horizon to ensure alignment with long-term value creation. My model indicates that to match my current trajectory and account for vesting schedules, I need a package structured as follows…” Then, read off your spreadsheet numbers. This shifts the conversation from “haggling” to “financial planning.” It forces the recruiter to engage with your logic rather than their budget constraints.

There is a specific scenario where the spreadsheet is non-negotiable: when comparing a public company offer to a pre-IPO or late-stage private company offer. Public sites are terrible at valuing private equity because they rely on the last funding round valuation, which may be stale or inflated. Your spreadsheet can apply a “liquidity discount” or a “risk multiplier” to the private equity. You can show the recruiter, “Your $200,000 grant is valued at the last round, but my model applies a 30% discount for lack of liquidity and tax complexity, making it equivalent to $140,000 in public RSUs. To bridge this gap, I need a higher base or a larger grant size.” This is a sophisticated argument that few candidates make. It shows you understand the asset class you are being paid in.

In a recent debrief for a L5 PM role at a hyperscaler, the hiring committee was divided on a candidate. The tie-breaker was the candidate’s negotiation email. Instead of asking for more money, the candidate attached a sanitized version of their vesting projection, highlighting a gap in year three compared to a competing offer. The VP of Product commented, “This person treats their career like a product. They have metrics, they have projections, they have a strategy.” That mindset secured the approval for an off-band equity increase. The candidate did not ask for more; they proved why more was mathematically necessary. That is the power of the model. It removes emotion and replaces it with inevitability.

Preparation Checklist

• Construct a four-year month-by-month cash flow model in Excel or Google Sheets, explicitly separating base salary, sign-on amortization, and net-after-tax RSU vesting.
• Input specific vesting schedules (e.g., 35/35/15/15 vs 25/25/25/25) for both your current employer and the prospective offer to identify liquidity gaps.
• Estimate annual refresh grant sizes based on company stage (public vs. pre-IPO) and include them as a variable range (conservative to aggressive) in your total comp projection.
• Calculate the “Net Liquid Value” of any private equity offers by applying a risk discount factor for lack of liquidity and uncertain exit timelines.
• Review specific negotiation scripts and vesting template examples in the PM Interview Playbook, which breaks down real L5 offer structures from recent debriefs to calibrate your refresh assumptions.

Mistakes to Avoid

Mistake 1: Quoting “Total Compensation” Averages Without Disaggregation BAD: “Levels.fyi says the average L5 PM makes $350k, so I need $350k.” GOOD: “The $350k average includes a one-time sign-on. My model focuses on recurring annual value, which requires a base of $180k and an equity grant of $200k to sustain.” Why it fails: Recruiters know averages are flawed. Quoting them makes you look lazy and uninformed about the components of pay.

Mistake 2: Ignoring the Vesting Cliff and Cash Flow Timing BAD: Accepting a lower sign-on because the total equity value looks high, without realizing you won’t vest anything for 12 months. GOOD: “Your offer has a 12-month cliff. My spreadsheet shows a $60k cash flow deficit in year one compared to my current role. I need a $50k sign-on to bridge this specific gap.” Why it fails: Equity is illiquid until it vests. If you cannot pay your mortgage in month 14 because you are waiting for a cliff, the offer is broken regardless of the total value.

Mistake 3: Treating Private Equity as Equal to Public RSUs BAD: Comparing a $300k private valuation grant directly to a $300k public RSU grant without adjustment. GOOD: “While the paper value is equal, my model applies a 40% liquidity discount to the private shares, meaning I need a 20% larger grant size or higher base to achieve parity.” Why it fails: Private shares carry execution risk and lock-up periods. Failing to discount them is a fundamental financial error that experienced hiring managers will spot immediately.

Related Tools

• AI Talent Supply vs Demand Calculator
• AI Talent Demand Calculator
• AI Salary Growth Calculator

FAQ

Can I use Levels.fyi data to negotiate a higher base salary specifically? No, because base salary bands are rigid and rarely influenced by external equity data. Base salary is determined by internal leveling and geography, not by what other companies are paying in stock. Use the spreadsheet to show that a lower base creates a cash-flow risk given the vesting schedule, which is a more persuasive argument for base movement than quoting a website average.

Do recruiters actually look at the spreadsheets candidates send? Yes, but only if they are clean, sanitized, and logical. A messy, emotional, or overly complex file will be ignored. A clear, one-page summary tab showing the “gap analysis” between two offers often gets forwarded directly to the compensation committee. They respect the rigor, even if they disagree with the assumptions, because it makes their job of justifying the exception easier.

Is it worth building a custom model for companies with non-standard equity like options? Absolutely, it is mandatory. Options require modeling strike prices, tax implications (ISO vs NSO), and potential dilution. Public sites are notoriously bad at explaining option value. If you are joining a pre-IPO company, your spreadsheet must model the “walk-away price” and the break-even share price. Failing to do this can result in accepting a package that is worth zero if the company does not exit above a certain valuation.amazon.com/dp/B0GWWJQ2S3).