Available$12
Job Fit Scorecard
Score a job against your experience before you spend an evening applying: a capability score, a realistic hiring probability and a clear Apply / Stretch / Skip call.
Available
Salary and Job Offer Comparison Calculator: Total Compensation, 401(k) Match, Commute and Benefits
Put up to four job offers next to your current job and see what each is really worth after bonus, equity, 401(k) match, health premiums and commute.
Buy for $12
Secure checkout. You get the download right after purchase.
Requirements
- Microsoft Excel 2019 or later / Microsoft 365, or a free Google account for Google Sheets
- No add-ons, macros or scripts
Comparing offers on base salary alone is how people leave money on the table, or take a raise that a long commute and a pricier health plan quietly eat.
This calculator works out first-year and ongoing total compensation for each offer: base, expected bonus, sign-on spread over the right years, RSU vesting, your own option estimate, the 401(k) match capped correctly, employer HSA money and stipends. Then it subtracts health premiums and commute costs to show a net figure, the difference vs your current job, and a rank.
A separate fit score from your own weighted ratings (growth, manager, stability, work-life) keeps money and non-money factors apart. A Breakdown tab shows how every number was calculated.
Features
Real total comp
First-year and ongoing, side by side with your current job.
401(k) match done right
Matched up to the cap and limited by what you actually contribute.
True commute cost
Miles, parking or transit, and optionally your time. Fully remote offers count no commute.
Net of costs and rank
Comp minus health premiums and commute, vs your current job in $ and %.
Fit kept separate
A weighted 0–100 fit score from your own 1–5 ratings.
Every number explained
A Breakdown tab with the logic behind each line, plus a comparison chart.
What's included
salary-offer-comparison.xlsx (blank: current job + four offers)salary-offer-comparison-example.xlsx (four fictional offers)salary-offer-comparison-quick-start.pdfREADME.txt and LICENSE.txt (personal licence)
Tested, and known limits
- All 223 calculated cells are checked against an independent calculation, including a sparse-input scenario
- Six deliberately broken rules were each caught
- Blank workbook shows dashes, never made-up numbers
Limits
- No tax calculation: an optional flat-rate estimate is clearly labelled
- Not tax or financial advice
Licence, updates and support
Licence
Personal licence: use it for yourself or your own business's internal work. No resale or sharing of the files. Using it with clients, or redistributing it, needs a commercial licence. Ask. Full terms.
Updates
Includes bug-fix updates to this version (1.x). Current version: 1.0.0. Changelog.
Support
Documentation included. Bug reports answered by email within 2 business days. One-to-one setup help isn't included. Report a problem.
Questions
Does it work in Google Sheets?
It's built to: it only uses functions Excel 2019+ and Google Sheets both support. Upload the .xlsx to Google Drive and choose File → Save as Google Sheets.
How are stock options valued?
You enter your own estimate, and it's labelled as one.
Is my data private?
Yes. It's a file you keep. Nothing is sent anywhere.
