Job Offer Comparison Spreadsheet: Total Comp Wins, Not Salary
The short answer
Job offer comparison spreadsheet: annualize each offer, apply vesting, compare 4-year totals, with a worked A-vs-B example.
Updated October 2026
Two offers on the table. Offer A pays $150,000 a year and hands you $300,000 in RSUs. Offer B pays $175,000 a year and adds a $50,000 signing bonus. Which one is better?
Most people compare the salaries, $175K beats $150K, done. That is the wrong math. A job offer comparison spreadsheet does it differently: it annualizes every piece of each offer, applies the vesting schedule to the equity, and compares the totals over the years you might actually stay. Run the numbers that way, and the worse-looking offer can win.
Verdict up front: over four years, Offer A is worth $900,000 and Offer B is worth $750,000, A wins by $150,000. But if you leave after one year, Offer B pays you $75,000 more of money you can actually keep. The winner depends on how long you stay. Salary alone never settles it.
How do you compare job offers with the job offer comparison spreadsheet method?
- List every component of each offer. Base salary, annual bonus (use the target percent, not the max), signing bonus, equity grant, 401(k) match, and a dollar value for benefits like health insurance. List PTO days too, but only for reference. PTO is never converted to dollars, because a day off has no price tag you can spend.
- Annualize everything. A signing bonus is one year's money, not four. A $300,000 RSU grant is four years of money, not one. Divide each lump sum by the years it actually covers.
- Apply the vesting schedule. Equity you cannot keep is not pay yet. A one-year cliff means leaving at month eleven earns you zero of the grant. In any year you might leave, only vested equity counts.
- Compare totals for the tenure you are actually planning. Run the math for leaving after year one, and for staying two, three, and four years. The winner can flip, and the scenario where it flips is the one that decides.
The Job Offer Comparison Spreadsheet runs exactly this method for up to three offers side by side, vesting math, year-by-year totals, a WINNER verdict on the four-year numbers, and a bar chart so you can see the gap. It works in Google Sheets and Excel (both tested live).
What does the worked example show: $150K + $300K RSUs vs $175K + $50K signing?
Ground rules, so the math stays honest: all figures are pre-tax, the stock price stays flat, and Offer A's grant vests 25% per year after a one-year cliff, leave before month twelve and the whole grant disappears. Tax is its own layer on top: the IRS treats restricted stock as income when it substantially vests, that is the vest date, at its fair market value then (Publication 525). Stock options follow different timing rules depending on the grant type (IRS Topic 427).
Year by year, here is the cumulative money you would actually have in hand:
| After... | Offer A: $150K base + $300K RSUs | Offer B: $175K base + $50K signing |
|---|---|---|
| 1 year (and you leave) | $150,000 | $225,000 |
| 2 years | $450,000 | $400,000 |
| 3 years | $675,000 | $575,000 |
| 4 years | $900,000 | $750,000 |
Offer B leads for the first twelve months, $75,000 ahead in money you can keep. Then Offer A pulls in front in year two and never looks back, finishing $150,000 ahead on paper.
Now the part no salary comparison shows you: the downside scenario. Cut the stock price in half and Offer A's equity is worth $150,000, not $300,000. Its four-year total drops to $750,000, exactly tied with Offer B. A tie goes to cash, because cash cannot drop. The honest verdict: Offer A wins if you stay past year one and the stock keeps at least half its value. Offer B wins if you leave early, or if the equity tanks.
Why does the winner flip when you run the tenure scenarios?
The one-year cliff is the hinge of the whole decision. Twelve months of work with zero vested equity is a real outcome, not a footnote, and it is the scenario most people never model. That is why the comparison runs five tenure scenarios: leave in year one and forfeit the unvested grant, stay for two, three, or four years, and a downside case where the equity is worth only a fraction of its paper value. When two offers land within $1 of each other, the sheet calls it a tie, because at that point the decision is no longer about money.
Which parts does a salary comparison forget?
The 401(k) match. A 6% match on a $150,000 salary is $9,000 a year of employer money. It belongs in the totals, not in the fine print.
Benefits. The Bureau of Labor Statistics reports that benefits made up 30.0% of employer compensation costs for private industry workers in June 2026, $14.07 an hour on top of $32.82 in wages (BLS). A lower salary with rich benefits can quietly beat a higher one.
The signing bonus clawback. Many signing bonuses must be repaid if you leave within the first year. Read the offer letter before you count that money.
How do you then negotiate, with numbers, not vibes?
Once the totals are clear, the negotiation writes itself. A competing offer is leverage you can state plainly, without bluffing. A signing bonus is the easiest ask when the base salary is frozen, it is one-time money, cheaper for the company than a raise. A base-salary counter works best when your floor and target are decided before the call, not during it. This is the same annualize-everything discipline that freelancers use when setting their rates, the question is always what the number looks like per year, not per line item.
The spreadsheet's Negotiation Prep tab sets your floor, target, and walk-away for each offer with an auto status, and the companion 4-page PDF gives you word-for-word scripts for the competing-offer play, the signing-bonus ask, the equity-refresh ask, and the base counter, plus six golden rules and a twelve-item pre-negotiation checklist.
Disclaimer: This article is for educational purposes only. It is not career, financial, tax, or legal advice, talk to a qualified professional about your own situation.
About Kollaz, Kollaz makes smart financial tools for modern money. This article's companion is the Job Offer Comparison Spreadsheet spreadsheet, compare up to three offers side by side, with vesting math, tenure scenarios, and word-for-word negotiation scripts.
Sources
- IRS, Publication 525 (2025), Taxable and Nontaxable Income, substantiates that restricted stock is included in income at fair market value when it becomes substantially vested (the vest date).
- IRS, Topic No. 427, Stock Options, substantiates that income timing for stock options depends on whether the grant is a statutory (ISO/ESPP) or nonstatutory option.
- U.S. Bureau of Labor Statistics, Employer Costs for Employee Compensation, June 2026 (news release USDL-26-1494, September 9, 2026), substantiates that benefits were 30.0% of employer costs for private industry workers ($14.07/hr benefits vs $32.82/hr wages).