Open Source Venture Model (OSVM) V1

Sam Gerstenzang
Dec 13, 2015 · 1 min read

Here’s a really simple spreadsheet modeling what a venture capital fund looks like. I made it because I couldn’t find something like it already on the web and thought it might be useful to others as a starting point.

Some huge caveats:

  1. This is not meant to predict returns. It’s best used by someone actively tweaking the model to understand how different variables interact with each other.
  2. This isn’t the right way to think about returns. Exits in this model are based on averages, but returns in venture are not based on averages.
  3. The model also doesn’t take into account that all else being equal, the more investments you make the more likely you are to invest in a big winner.
  4. It also makes other simplifying assumptions like assuming your fee stays constant over the length of the fund, assuming the maximum number of rounds before an exit is three, etc.

And yet, despite these caveats, I’ve still found it useful to think about how much of a fund to reserve for pro rata, the effect of dilution, size of a fund required to make meaningful carry, etc.

To use the model, make a copy and make your changes. See a mistakes or improvements you’d like to make? “Fork it” and share your spreadsheet back with me.

Thanks to Jeff Weinstein for significant contributions to an earlier iteration of this model. All mistakes are mine.

To receive future posts from me via email, sign up here.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

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