Live data from Hacker News

You Can Never Size a Market in Excel

medium.com

21–25 of 25 posts

Re: You Can Never Size a Market in Excel

#21
Investors should and do make their own estimates of market opportunity.

Investors should and do demand help in making those estimates.

A common way to help is to provide a full estimate plus the inputs you used to make that estimate.

Now, I think a BETTER way to help is to provide ranges and discussions of the inputs, rather than point estimates. And it's rare that I've encountered an investor who didn't find that acceptable. But some version or other of the exercise is worthwhile.

Re: You Can Never Size a Market in Excel

#22
post #16
post #9

> Woz: Don had come to the garage and I ran the Apple II through its paces and he said, “What is the market?” I said, “A million units.” He asked me why that was and I sad, “There’s a million ham radio operators and computers are bigger than ham radio.” http://www.realdanlyons.com/blog/2011/10/11/a-conversation-w...

He's not saying you can't figure out a market size. He said if the market size is not immediately obvious then you can't figure out market size. It's not the same thing.

No, in the highlighted section he is explicitly saying you can't figure out how big the market is by reasoning and the best you can do is guess.

In fact, it is a bit stronger than that: he states that the only knowledge that can be used is instinctual knowledge, but since instincts concerns things like what smells indicate spoiled food and legless that animals are dangerous, you don't have any relevant knowledge at all! The best you can do is baseless guessing, though after having gotten funding and done a bit of work you might have some basis for your estimate (there is a caveat that instincts dominate estimates early in the start up process).

The summary ars provides does seem to be what he strove to say, but since two people can easily disagree on what is to be considered "obvious" even that statement allows for less predictive power that seems reasonable.

Re: You Can Never Size a Market in Excel

#23

To paraphrase from "Jurassic Park": this is Heidegger. I know this. Although it doesn't ruin his short essay, "instinct" is unfortunate. Executive knowledge about the kind of nascent industry the article (and HN typically) discusses isn't "natural", or a mere knack like playing music by ear. It's tacit knowledge: it can't be codified. In Heidegger-speak: market potential can't be reduced to a stockpile of "presence",…

Instinct is indeed unfortunate, and I think it is misleading to the point of hilarity too! The notion that sizing a market (as others have mentioned: a Fermi problem) is the same kind of knowledge as that which makes babies close their mouths and wave their arms when immersed in water? Venture investing truly is child's play :D

Let "sizing a marked" mean "estimating the number of products that can be sold to a given population of persons". An very precise estimate of this number is currently very hard to provide, but giving an order of magnitude estimate is clearly a Fermi problem. Note that the difficulty is providing an accurate and tight bound, not an accurate but imprecise one and that the latter might be valuable too.

Solving a Fermi problem requires estimating a series of numbers from everyday experience. One then multiplies these number together in a mechanical fashion, which could be done in a "ready-at-hand" way by use of a tool. Evidently the process invariably requires contemplating one's every-day experience, and since ordinarily that experience is simply lived this meta-action is an act filled with "presence".

By the way, the problem of capitalism is solved, and the solution shows that it will allocate capital optimally; this is one of the main arguments in favour of capitalist systems.

The problem that the social reality in which we live only partially approximates capitalism (see: non-profit organizations) is the big problem economists, and anyone else using classical economic theory in the real world, struggle with.

Re: You Can Never Size a Market in Excel

#24

Earlier quoted context omitted.

No, nene, no. "No plans" means exactly "by chance". Bad plans can do considerably worse than chance. What organizations need to learn how to do (and unfortunately to this day Excel isn't particularly enabling) is sensitivity analysis. One of my corporate parlor tricks is to render valuation spreadsheets (which are typically cashflows dependent on scenario parameters) into Matlab and giving each unknown parameter a di…

crystal ball for excel can do monte carlo simulations for what you describe but with a real probability distribution for each input. it's expensive though (as is matlab, which is what i did my master's thesis in =)

Yeah. There was a long yadda yadda yadda I didn't feel like detailing on why/how we calibrate beta distributions for three-point estimates.

What's more: Octave (free as in Stallman) is slow but runs Matlab code transparently.

Re: You Can Never Size a Market in Excel

#25
post #20

Agree and disagree. Agree: Early-stage investing is rarely about accurately sizing a market. And nothing can be boiled satisfactorily down to an Excel model. Disagree: But you still have to do it. For yourselves , if not for VCs. Presumably, VCs want to see that you've thought long and hard about the market opportunity, about the competition, and about your marketing plan and business model. And you should have. Your…

The result of a model is no better than a gut estimate. But the process of developing the model, working out what the factors are that will impact market size (and your share of it), working out what things you need to monitor more closely or focus on for biggest impact is where the value is.

Exactly. I'm not sure if there is any investor consensus on this, but I'd be willing to stake a claim that a well-reasoned market analysis is superior to a putatively "accurate" market analysis. And by well-reasoned, I mean an estimate that accounts for and emphasizes the critical and necessary variables in the sizing and in the approach. Perhaps with some sensitivity analysis thrown in for good measure.

If your model is logical and flexible, you can work with investors to adjust it and play around with different scenarios. If your model depends on an inflexible degree of supposed precision, you're at high risk of deluding yourself. Savvy investors can probably sniff that out.

All things being equal, it's probably best to present a model that is simple enough to be easily grokked; flexible enough to be adjusted on the proverbial back of an envelope; and dependent on a set of factors that you've thoroughly researched and confidently believe are the factors to focus on. So you steer the conversation to the factors, and less to the outcome of the model under your presented scenario. If you've got the right factors, you can model out any number of scenarios. (And you should probably have done this already prior to the pitch, so that you're prepared to speak to a given range of hypothetical outcomes).

Post reply on HN