Startup Comp Cost-Benefit Analysis

One thing that I tend to do is go back and calculate the cost-benefit analysis of taking a startup offer vs a publicly traded company. Obviously financial upside is one of the most important reasons why people join startups1 and people tend to poorly calculate how much they are actually making.

I have a spreadsheet I have kept locally over the years that I fill out with various information about my stock grants. It contains calculations of my yearly compensation over the years given stock grants, bonuses and what not. I haven't been able to find a good online calculator that does this for me so I've taken the spreadsheet and made a simplified version to calculate comp over the years and benchmark against a public company with liquid stock.

As part of the calculations, I have made the assumption that you would have received the same compensation plan at the public company as the startup. Surely, IRL, there's probably some difference. But a high performing individual will have high performance anywhere.

1The usual corporate bullshit answer you get is "I work here because I love the [impact|culture|ownership|scope|etc]" but while that may be true, given a crap salary and poor financial upside, would the people who "love it" still be here? Be serious.

1

ISO Grants

Add all your grants. Each can have a different vesting schedule and strategy (sell at vest vs. hold).

Year Shares Strike ($) Vesting Exercise Yr Sell Yr % Vested
2

Yearly Comp

Set your salary and company share price per year. Vesting and equity are auto-calculated from grants above.

$
Year Salary ($) Share Price ($) YoY Shares Vesting Equity Value ($) Total Comp ($)
Total
Salary Equity Cumulative total
3

Public Company Benchmark

What if you had the same total comp at a public company? Uses real split-adjusted historical prices per year.

Free key from alphavantage.co (25 req/day). Prices are split-adjusted.

Heads up: The benchmark applies the public stock's cumulative growth from year 1 to each year's startup equity value. It's a rough directional comparison, not a buy-shares-every-year DCA model.