Personal
Job offer equity calculator
This template compares startup offers using salary, bonus, options or RSUs, strike price, share count and future-round dilution.
Exit scenarios translate each grant into a value after dilution and exercise cost, then combine it with four years of cash compensation.
Reads from
- Your offer letter
Sheets
- Offers
- Holds the salary, bonus, grant and company terms for each offer.
- Equity
- Calculates current ownership, exercise cost and paper value.
- Dilution
- Applies future financing-round dilution to each grant.
- Exit Scenarios
- Calculates grant value across the workbook's range of exit values.
- Comparison
- Combines cash compensation and equity value for a side-by-side comparison.
Formulas
Equity!B4
=Offers!B12/Offers!B16Calculates the grant's ownership from shares granted and fully diluted shares.
Dilution!D4
=Equity!$B$4*C4Applies the retained fraction after a financing round.
Comparison!B8
=B6+B7Adds four-year cash compensation and equity value.
Questions
What do I need from an offer letter?
The Offers sheet uses the cash compensation, grant type, share count, strike price, vesting terms and company share information supplied with each offer.
Does it account for future dilution?
Yes. The Dilution sheet applies the financing-round assumptions in the workbook before the grant is valued at each exit.
How are offers compared?
The Comparison sheet adds four years of salary and bonus to the grant value at the selected exit for each offer.