Total compensation modeling: comparing offers like an analyst

The most expensive comparison in a career is 'Offer A pays $145k and Offer B pays $155k, so B wins.' Base salary is one row of a package that can have seven, and the other six rows routinely swing the answer by $30,000 a year or more. Equity vests unevenly, bonuses pay at different rates and reliabilities, 401(k) matches differ by thousands, and a sign-on bonus inflates year one while telling you nothing about year three. The fix is not intuition — it's a small spreadsheet that converts every component to dollars per year, for each of the next four years, for each offer. An hour of modeling regularly changes the decision.

Why base salary comparisons lie

Compensation components differ on three axes: size, timing, and certainty. A $40,000 sign-on bonus is large, immediate, and certain — but only in year one. An RSU grant of $120,000 over four years is meaningful but arrives on a schedule, at a value that floats with the stock price. A '15% target bonus' might pay 18% at a company that consistently funds it and 6% at one that doesn't. Comparing two packages by any single component is like comparing houses by kitchen size. The spreadsheet exists to put every component on the same axis: expected dollars, per calendar year.

The seven rows every comp model needs

• Base salary — the only guaranteed row, and the base for most of the others.
• Target bonus — base × target %, then multiplied by an honesty factor (ask in the interview: 'what did this team's actual bonus payout percentage look like the last two years?').
• Equity vesting this year — grant value divided across the vesting schedule, respecting cliffs. A 4-year grant with a 1-year cliff pays $0 in months 1–12.
• Sign-on bonus — year one only, and note any clawback if you leave within 12–24 months.
• 401(k) match — match formula × your realistic contribution. A 6% match on $150k is $9,000/year; a 3% match is $4,500. That $4,500 gap is invisible in every offer letter summary.
• Benefits delta — differences in health premiums, HSA seeding, ESPP discount value, and PTO days (each PTO day ≈ base ÷ 260).
• Cost adjustments — commuting, relocation, or a required move to a higher-cost metro. A package that's $10k richer but requires $15k more in housing is a pay cut.

Modeling vesting year by year

Vesting schedules are where naive comparisons break. A $160,000 RSU grant vesting 25/25/25/25 delivers $40,000 a year. The same headline number on a 5/15/40/40 backloaded schedule delivers $8,000 in year one and $64,000 in year four — a completely different asset if you might leave in two years. Cliffs matter too: leave at month 11 of a one-year cliff and your equity compensation was zero. Model each year separately, and weight later years by the honest probability you'll still be there. If you historically change jobs every 2.5 years, year-four equity should be heavily discounted in your decision.

Discounting what isn't guaranteed

A dollar of base is not a dollar of target bonus is not a dollar of unvested startup equity. Apply haircuts by certainty: base at 100%; bonus at the company's actual recent payout rate (often 70–110% of target); public-company RSUs at 85–100% depending on the stock's volatility; private-company options at 25–50% of the paper value, because most private equity never converts to cash at its stated valuation. This feels pessimistic and is merely realistic — recruiters quote every component at 100% because that's their job. Yours is to model what you'll probably receive.

Building the spreadsheet in 30 minutes

1. 1
   One column per offer, one section per year

   Years one through four as row groups, the seven components as rows within each. Label your assumptions (bonus honesty factor, equity haircut, raise %) in cells you can change.

2. 2
   Fill in the contractual numbers first

   Base, match formula, sign-on, and the vesting schedule come straight from offer letters. Ask recruiters for anything missing — 'can you send the vesting schedule and match formula in writing' is a normal request.

3. 3
   Apply certainty haircuts

   Multiply bonus by actual payout history, equity by the haircut for its type. Keep the un-haircut version in a neighboring column so you can see both realities.

4. 4
   Sum each year, then read the shape

   Look at year-one totals, steady-state totals, and the four-year sum. A package that only wins in year four requires you to actually plan on staying four years.

5. 5
   Use it to negotiate, not just decide

   The model shows exactly which lever is cheapest for each company to move. If B wins on equity but loses on match, ask A for equity or a signing bonus sized to the modeled gap — a specific ask backed by math outperforms 'can you do better?'

The bottom line

Total compensation is a multi-year cash-flow forecast wearing a one-page offer letter as a disguise. Model all seven components, year by year, haircut by certainty, and compare steady-state years rather than sweetened first ones. The spreadsheet takes half an hour, routinely reveals a $20,000–60,000 four-year gap invisible in the base salary comparison, and doubles as a negotiation map showing exactly what to ask each company for. Nobody involved in the transaction will do this math for you — the recruiter is paid to present the sunniest version, and your future self is the only stakeholder in the accurate one.