Job Offer Comparison Spreadsheet: Total Comp Wins, Not Salary
Updated October 2026
Job offer comparison spreadsheet: two offers on the table, and total comp wins, not salary. 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. And if the real question behind the offers is is going back to work worth it, our guide runs the commute, childcare, and tax math.
A job offer comparison turns every piece of each offer into yearly money: base salary, bonus at the target percent, signing bonus, equity spread over its vesting years, the 401(k) match, and a dollar value for benefits. Then it compares the totals over the years you might actually stay: because the winner depends on how long you stay.
Key numbers
- Over 4 years: Offer A $900,000 vs Offer B $750,000: A wins by $150,000
- After year 1 (then leave): Offer B pays $75,000 more ($225K vs $150K) thanks to the one-year cliff
- Stock price halved: Offer A drops to $750,000: exactly tied; a tie goes to cash
- BLS: benefits were 30.0% of employer costs in June 2026: $14.07/hr benefits on $32.82/hr wages
- PTO is never converted to dollars; signing bonus = one year's money, $300K RSUs = four years' money
How do you compare job offers with a spreadsheet?
Four steps: list, annualize, vest, compare:
- 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).
Which wins: $150K + $300K RSUs or $175K + $50K signing? A worked example
Over four years, Offer A ($150K + $300K RSUs) is worth $900,000 and Offer B ($175K + $50K signing) is worth $750,000. A wins by $150,000. But leave after one year and Offer B pays $75,000 more of money you can actually keep, because the one-year cliff wipes out A's equity. The winner depends on how long you stay.
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. Either way, once the bigger number is yours, our pay-off-debt-or-invest calculator settles what to do with the difference in 60 seconds.
Why does the winning job offer flip with tenure?
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.
What 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 negotiate a job offer 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.
Frequently asked questions
How do you compare two job offers on total compensation?
Annualize every component and compare totals for the tenure you'll stay. A signing bonus is one year's money; a $300,000 RSU grant is four years of money. Equity you cannot keep isn't pay yet: a one-year cliff means leaving at month eleven earns zero. Run the math for leaving after year one and staying two, three, and four years.
In the worked example, which job offer wins?
Over four years, Offer A totals $900,000 against Offer B's $750,000: A wins by $150,000. Leave after one year and B pays $225,000 against A's $150,000, or $75,000 more in keepable money. A wins if you stay past year one and the stock keeps at least half its value; B wins if you leave early or the equity tanks.
What does a salary-only comparison miss?
The 401(k) match, 6% on $150,000 is $9,000 a year of employer money, belongs in the totals. Benefits were 30.0% of employer compensation costs for private workers in June 2026 (Bureau of Labor Statistics), so a lower salary with rich benefits can beat a higher one. Many signing bonuses must be repaid if you leave in year one.
When are RSUs taxed?
At the vest date. The IRS treats restricted stock as income when it becomes substantially vested, the vest date, at its fair market value then, per Publication 525. Stock options follow different timing rules depending on the grant type (IRS Topic 427). All worked comparisons should be run pre-tax, with tax handled as its own layer on top.
What should go into a job offer comparison spreadsheet?
Base salary, annual bonus (target percent, not max), signing bonus, equity grant, 401(k) match, and a dollar value for benefits. 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. Compare offers side by side so year-by-year totals and vesting math stay honest.
Job offer comparison spreadsheet: best tools and methods for 2026
The best job offer comparison tools model total compensation over your expected tenure, not just year-one salary, because signing bonuses fade and RSU vesting schedules change the winner. Spreadsheet-based tools beat generic salary calculators here: you can see the crossover year where one offer overtakes the other. That tenure-based comparison is the core of the spreadsheet in this article.
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).
Comments
Post a Comment