Deterministic Unissued Options Pool Calculations

  1. The pro forma cap table is now somewhat unstable and attempting to edit the wrong number at the wrong time can cause the error #REF to pop up in cells that reference around upon themselves. Hitting CTRL+Z in this state will not successfully undo the last calculation and you will have to close the doc and open a prior saved version to recover from this error. I’ve lost hours of work to this issue.
  2. Anyone that opens this spreadsheet who does not have “Iterative Calculations” enabled will see a broken spreadsheet, see a circular reference error upon loading, and will not be able to edit the sheet in any functional way until they change their preferences. It’s not a good experience for a viewer expecting to see a model that is supposed to accurately define a multi-million dollar equity financing.




“Seeing ourselves clearly is the project of a lifetime.” -The Nix

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Please help me pay my debt and fix my credit score!!?

3 Useful Saving Thinking to Have A Good Financial Planning

4 Money Breakthroughs That Made Me Richer And Happier

Sample Deal Sheet for NYC real estate transactions

Am I too young to file for bankruptcy?

Invest to Beat Inflation

What is the reason that debt consolidation is a good choice?

Healthcare Costs in Retirement — Avoid These Big Mistakes

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Andrew Parker

Andrew Parker

“Seeing ourselves clearly is the project of a lifetime.” -The Nix

More from Medium

Global FinTech Hub Rankings

Investing in Lightning Network Startups. Part 2

How to Find Web3 Deal-Flow

Pitching Shariah compliant projects to VCs