Custom Financial Model & Spreadsheet Calculator

What a good one includes

• Dynamic input variables for base salary, sign-on bonuses, and annual performance incentives so you can compare different job offers side-by-side.
• An interactive stock option or RSU valuation tab that projects your potential equity payout based on different company growth and exit scenarios.
• Tax estimation logic that factors in local, state, and federal brackets, alongside self-employment or FICA taxes where applicable.
• A multi-year vesting schedule tracker that maps out when your equity or deferred bonuses actually convert to liquid cash.
• Cost-of-living adjustment factors to accurately compare the purchasing power of offers across different geographic locations.
• An instruction tab with clear explanations of how the formulas work so you can confidently update parameters as negotiations progress.

Common mistakes to avoid

• Overlooking the impact of vesting cliffs and multi-year payout schedules, which can lead to overestimating your actual first-year cash flow.
• Failing to account for local and state tax differences when comparing remote offers or relocating to a new city.
• Treating pre-IPO equity or stock options as guaranteed cash without factoring in realistic dilution and liquidity timelines.
• Hardcoding values directly into calculation formulas instead of using input cells, which breaks the model's functionality during negotiation updates.

Frequently asked questions