A few weeks ago, the Guesstimate beta came out. It’s pretty cool; it’s like Excel with Crystal Ball built right in. You can input a single number or a range of values and build models with it. Guesstimate’s release and theholiday season gave me the perfect chance to explore an idea on the startup industry. I had been meaning tobuilding a model to understand the formation and development of a startup to its eventual failure or exit.

This is one in of a long line of attempts to try and quantify an often-times opaque industry. Two prominent examples of data-driven approaches to venture financing are Aileen Lee’s TechCrunch article that popularizedthe term ‘unicorn’ and a recent Cambridge Associates research report on venture returns becoming lessconcentrated. While both of these reports are good attempts to understand an aspect of the startup formation and funding, it’s often hard to understand how a startup in moved along through this process if you are new to the industry.

The startup industry model in Guesstimate takes inspiration from Sam Gerstenzang’s Open Source Venture Model and Bryan Johnson’s OSF Playbook. Like any model, my startup model is an attempt to make explicit assumptions and beliefs about the world to be tested. It allows you to change values to see how each elementcan push and pull on each other. It follows one cohort of companies started in a year and follows themthrough their life cycle. It assumes a set amount of capital available at each stage that is always spent onfinancing that set of companies. You can play with the model here. Right now, you can make changes themodel on Guesstimate, but no changes are saved once you leave the page. Varying the “exit multiple” and thenumber of deals participated in by VCs have the most dramatic effect on the model.

Some key things learned and reinforced in the course of building the model:

As previously said, Guesstimate has only two distributions normal and uniform distribution and isn’t able tocapture much of the statistical reality of startups. While normal distributions may be a good way to model thelikelihood of a startup moving onto the next stage of funding, it’s not a very good way to measure the return generated at exit. Right now, the model is merely descriptive (and barely so). In the future, I’d like to move towards a prescriptive model to answer the question: “how can we change the current system to create moreimpactful innovation in the world?”. Questions such as “Do we need a more diverse group of VCs to allocate capital to different startups?” or “Is the most effective way to create innovation to pump more money towardsVCs or to lower the cost of starting startups?” may be more easily answered with this model.

With that said, here are a few directions I’d like to explore:

Thanks to Daniel Kao, Jonathan Zong, and Reed Rosenbluth for reading a draft.

Here are a list of sources.

This is a repost from my blog at: blog.dillchen.com