Model Equity Calculator for Founders with Option Pool Expansion


English: Historical valuation on the secondary...

SeedCamp’s hackathon, Seedhack, took place at Google Campus, London, on the 8th to 10th of November. It brought together some of the brightest talent in the startup community from 15 countries with one of the best accelerator programs in the world and mashed it up with awesome content providers like Twitter, Facebook, BSkyB, BBC, Getty, HarperCollins, EyeEm, Nokia Music and Imagga. There were a total of 12 teams working on interesting and exciting projects.

As part of this hackathon, Ali and Will helped me aggregate resources to help founders better understand the process of raising equity and the impact it can have to their founder stakes. We aggregated resources to help entrepreneurs to understand  the numbers and implications of raising money and giving out equity. Valuing a company and calculation its impact on your equity is a very complex and confusing for entrepreneurs as well as being far from an exact science, this is the pain point that we wanted to address.

In the words of Seedhack attendee Will Martin (@willpmartin)

“Fundraising is one of the most difficult parts of the startup world, as first time founders this is an even more daunting process. Experience of raising a round and understanding the numbers and implications of that round and the related equity issued to an investor as well as employees in the form of an option pool is vital, but sadly is only fully understood by going through the process for real. Our intention was to give founders the knowledge required by being able to go through the process in a simple and easy way, thus giving the founder the confidence when it happens for real.

Ali and I are first time founders currently actively looking for investment. We know the total value we need in terms of money we want to raise as well the percentage of equity we are comfortable willing to give up to the investor. What we didn’t know and learned through the process is the implications in future rounds as a result of that initial funding round. Having an option pool for employees, advisors, board members etc. is something that complicates the issue and is often a requirement in the terms an investor is offering. This complicates the issue for the founder, so being aware of the impact of their shareholding as a result is vital for a founder as it is them that gets diluted in the first round but also any subsequent round, but it is often overlooked.

The changes to equity positions of the founders, investors, employees etc. is very important to understand as it dictates control and value of a company. Having this knowledge now gives us as founders a huge advantage over other founders we are competing with for funding and bridges the knowledge gap that exists for first time founders.”

In order to read some of the terms on this cap table model, below are some definitions which you might find useful:

Pre & Post Money Valuation

“The pre-money valuation is the valuation that a company goes into raising a round of financing with. By establishing this valuation, it helps investors understand what amount of equity they will receive in the company in exchange for their capital. Once the financing round has been completed, the post-money valuation is the sum total of the pre-money valuation plus the additional capital raised. So, if the pre-money valuation of a company is $10 million and they raise $2.5 million from investors, their post-money valuation would be $12.5 million. Investors would own 20% of the resulting company.” – Dave Morin, Source Quora

“A PRE-MONEY VALUATION is the valuation of a company or asset BEFORE investment or financing. If an investment adds cash to a company, the company will have different valuations before and after the investment. The pre-money valuation refers to the company’s valuation before the investment.

External investors, such as venture capitalists and angel investors will use a pre-money valuation to determine how much equity to demand in return for their cash injection to an entrepreneur and his or her startup company. This is calculated on a fully diluted basis.

If a company is raising $250,000 in its seed round and willing to give up 20% of their company the pre-money valuation is $1,000,000. (250,000 * 5 -250,000 = 1,000,000)

Formula: Post money valuation – new investment

Source –

A POST-MONEY VALUATION is the value of a company AFTER an investment has been made. This value is equal to the sum of the pre-money valuation and the amount of new equity.

The Post-money valuation is the sum of the pre-money valuation and the money raised in a given round. At the close of a round of financing, this is what your company is worth (well, at least on paper).

If a company is worth $1 million (pre-money) and an investor makes an investment of $250,000, the new, post-money valuation of the company will be $1.25 million. The investor will now own 20% of the company.

The only reason it’s worth spending time on this term at all is that it “sets the bar” for your future activities. If your post-money after your first round of financing is $4 million, you know that to achieve success, in the eyes of your investors, any future valuations will have to be well-in-excess of that amount.     

Formula: New Investment * total post investment shares outstanding/shares issued for new investment. “

Source –

Option Pools

“An option pool is an amount of a startup’s common stock reserved for future issuances to employees, directors, advisors, and consultants.” – from

Option pools can also be formed by Restricted Stock Units, but whichever one you use, they are generally still called ‘Option Pools’.

The OPTION POOL is the percentage of your company that you are setting aside for future employees, advisors, consultants, and the like. Employees who get into the startup early will usually receive a greater percentage of the option pool than employees who arrive later.

“The size of the Option Pool as a percentage of the POST-MONEY Valuation and where ALL of it comes from the founder’s equity. This is the least founder-friendly way to present this, but it is also the point at which most early stage investors will start the negotiations. The expectation from traditional venture firms is that this will equal 15%-25% of the company AFTER they make their investment. The Option Pool is one of the most complex and, from the entrepreneur’s perspective, confusing terms in an equity financing scenario.” – source

Round Size – 

The investment, or money is how much money is raised in a given round of financing. However, the decisions (and their implications) surrounding this number are among the most important that a founding team makes. It is not just about how much money is raised, it is about the terms that the money is raised on and, maybe most importantly, whose money it is and what they bring to the table in addition to money.  – Source

Link to the Model Cap Table:

NOTE FOR MODEL TO WORK – It needs to run on Excel (Google docs coming soon) and with circular calculations turned on. This can be done by going to (Mac Excel) Preferences -> Calculation -> Iteration -> Click on Limit Iteration

If you are considering using Convertible Notes as part of your round, check out this variant of the cap table with notes on how to convert as well:

Additional Equity Calculation Tools (Thanks to Ali Tehrani for finding these – @tehranix) –

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

Related articles

Enhanced by Zemanta
Continue Reading

What Tier is your Investor (or what to look for in an investor)?



One question that I often get from founders is what ‘tier’ a prospective investor is. As in, what differentiates their prospective investor over another as ‘better’ or ‘worse’, relatively speaking, and on what basis.

Just to clarify, although there is no formal ‘ranking system’ for the tiers of investors, generally speaking, every investor sort of knows where they ‘rank’ relative to others or at least relative to the top investors. The best funds, generally known as ‘Tier 1 investors’ are the most in demand, and then, the tiering is largely subjective from that point onwards as to whether a fund is Tier 2, or Tier x, so there isn’t a huge benefit to spending too much time trying to actively find the ‘objective’ rank of an investor.

That said, what IS worth exploring is what differentiates the better ‘tier’ investors from the rest. Below are the seven attributes that I believe differentiate ‘the best from the rest’.

As you seek out potential investors, keep an eye out for these variables, the more of these your prospective investor has, the likely better off you will be as a founder.

1) Has a great network – the biggest value-add, in my opinion, that an investor can bring to the table, is their network. The larger their network, the more doors they can open for you. Nothing beats a direct intro to someone you need to meet.

2) Has a great brand-name – this helps with the network, but having an investor with a great brand name, either as an individual or fund, can help not only open doors indirectly (as in not requiring an introduction), but also to provide your startup with instant validation to potential customers, partners, and new investors.

3) Has sufficient levels of capital to support you – Although different investors have different strategies around this (eg. an Angel rarely can follow-on as much as an institutional fund), it is generally a good thing to have an investor who can invest in your company throughout the lifecycle of your company.

4) Has sector expertise – One way that investors can differentiate themselves as a top tier investor from the usual suspects is by having focused experience in your sector. For example, an investor could be a generalist Tier 2 fund (remember that this is subjective), but as an ecommerce investor they may be a Tier 1, great if you are a ecommerce company, but just ok if you’re a fintech company. This is because they will likely have a large network (see point 1 above) in their sector of expertise.

 5) Has deal experience – You will go through a lot of unique and stressful situations during a fund raise. It really helps to have someone who has gone through the process before and can help smoothen things out between all parties involved if needed.

6) Isn’t burdensome – An excellent investor does not burden the founder during the investment process with unnecessary or unusual diligence requirements for the stage your company is in. For example, a company that is very early stage will likely not have much to be ‘diligenced’, if an investor is requiring you to have an accurate version of what will happen in your company 5 years from now and you started your company three months ago, question whether they truly think the information you will give them has any likelihood of being true (and whether you think they’d make a good investor for you).

7) (Lastly, and most importantly) Has a big vision – Good investors on your board will help you by working with you on best practices for company building, but great investors will help you by helping you set the right vision for your company. The better investors help you think big because they think big themselves. This means not only having an attitude of can-do vs can-not, but also having the experience on how to coach you through this type of thinking.

Now, keep several things in mind, however, after reviewing this list:

1) There are many new investment funds and or individual angels that come to the ecosystem and therefore may not have an established brand name, but have great networks and experience. Don’t dismiss them prematurely, however, do ask others that they’ve worked with what it’s like to work with them.

2) Although founders that have done well and gone on to join a fund can be awesome people to have on your board, however, investors don’t have to have been founders themselves to be great investors. Experience as investor, having done many deals and knowing how the best companies operate, can count for a lot, so look for  a blend of all attributes in your investor and not just look for a founder-turned-investor that can empathetically relate to what you’re going through, but provides little beyond aged anecdotes about how they did things.

3) If you’re ever stuck between two potential investors, really really consider that the person that will be working with you on the board will help you define many things about your company over the coming years. Choose wisely and ask yourself who you would rather work with long term, you wouldn’t want too chose someone on a brand name alone, but causes you hair loss, heart burn, and emotional stress on a regular basis.

I hope this helps you in your quest to find your potential investor.

Enhanced by Zemanta
Continue Reading

How does an early-stage investor value a startup?

English: Diagram of the typical financing cycl...
Image via Wikipedia

One of the most frequently asked questions at any startup event or investor panel, is “how do investors value a startup?”. The unfortunate answer to the question is: it depends.
Startup valuation, as frustrating as this may be for anyone looking for a definitive answer, is, in fact, a relative science, and not an exact one.

For those of you that want to cut to the summary of this post (which is somewhat self-evident when you read it) here it is:

The biggest determinant of your startup’s value are the market forces of the industry & sector in which it plays, which include the balance (or imbalance) between demand and supply of money, the recency and size of recent exits, the willingness for an investor to pay a premium to get into a deal, and the level of desperation of the entrepreneur looking for money.

Whilst this statement may capture the bulk of how most early stage startups are valued, I appreciate that it lacks the specificity the reader would like to hear, and thus I will try and explore the details of valuation methods in the remainder of my post with the hopes of shedding some light on how you can try and value your startup.

As any newly minted MBA will tell you, there are many valuation tools & methods out there. They range in purpose for anything from the smallest of firms, all the way to large public companies, and they vary in the amount of assumptions you need to make about a company’s future relative to its past performance in order to get a ‘meaningful’ value for the company. For example, older and public companies are ‘easier’ to value, because there is historical data about them to ‘extrapolate’ their performance into the future. So knowing which ones are the best to use and for what circumstances (and their pitfalls) is just as important as knowing how to use them in the first place.

Some of the valuation methods you may have have heard about include (links temporarily down due to Wikipedia’s position on SOPA and PIPA):

While going into the details of how these methods work is outside of the scope of my post, I’ve added some links that hopefully explain what they are. Rather, let’s start tackling the issue of valuation by investigating what an investor is looking for when valuing a company, and then see which methods provide the best proxy for current value when they make their choices.

A startup company’s value, as I mentioned earlier, is largely dictated by the market forces in the industry in which it operates. Specifically, the current value is dictated by the market forces in play TODAY and TODAY’S perception of what the future will bring.

Effectively this means, on the downside, that if your company is operating in a space where the market for your industry is depressed and the outlook for the future isn’t any good either (regardless of what you are doing), then clearly what an investor is willing to pay for the company’s equity is going to be substantially reduced in spite of whatever successes the company is currently having (or will have) UNLESS the investor is either privy to information about a potential market shift in the future, or is just willing to take the risk that the company will be able to shift the market. I will explore the latter point on what can influence you attaining a better (or worse) valuation in greater detail later. Obviously if your company is in a hot market, the inverse will be the case.

Therefore, when an early stage investor is trying to determine whether to make an investment in a company (and as a result what the appropriate valuation should be), what he basically does is gauge what the likely exit size will be for a company of your type and within the industry in which it plays, and then judges how much equity his fund should have in the company to reach his return on investment goal, relative to the amount of money he put into the company throughout the company’s lifetime.

This may sound quite hard to do, when you don’t know how long it will take the company to exit, how many rounds of cash it will need, and how much equity the founders will let you have in order to meet your goals. However, through the variety of deals that investors hear about and see in seed, series A and onwards, they have a mental picture of what constitutes and ‘average’ size round, and ‘average’ price, and the ‘average’ amount of money your company will do relative to other in the space in which it plays. Effectively, VCs, in addition to having a pulse of what is going on in the market, have financial models which, like any other financial analyst trying to predict the future within the context of a portfolio, have margins of error but also assumptions of what will likely happen to any company they are considering for investment. Based on these assumptions, investors will decide how much equity they effectively need now, knowing that they may have to invest along the way (if they can) so that when your company reaches its point of most likely going to an exit, they will hit their return on investment goal. If they can’t make the numbers work for an investment either relative to what a founder is asking for, or relative to what the markets are telling them via their assumptions, then an investor will either pass, or wait around to see what happens (if they can).

So, the next logical question is, how does an investor size the ‘likely’ maximum value (at exit) of my company in order to do their calculations?

Well, there are several methods, but mainly “instinctual” ones and quantitative ones. The instinctual ones are used more in the early-stage type of deals and as the maturity of the company grows, along with its financial information, quantitative methods are increasingly used. Instinctual ones are not entirely devoid of quantitative analysis, however, it is just that this “method” of valuation is driven mostly by an investor’s sector experience about what the average type of deal is priced at both at entry (when they invest) and at exit. The quantitative methods are not that different, but incorporate more figures (some from the valuation methods outlined) to extrapolate a series of potential exit scenarios for your company. For these types of calculations, the market and transaction comparables method is the favored approach. As I mentioned, it isn’t the intent of this post to show how to do these, but, in summary, comparables tell an investor how other companies in the market are being valued on some basis (be it as a multiple of Revenues or EBITDA, for example, but can be other things like user base, etc) which in turn can be applied to your company as a proxy for your value today. If you want to see what a professionally prepared comps table looks like (totally unrelated sector, but same idea), go here.

Going back to the valuation toolset for one moment… most of the tools on the list I’ve mentioned include a market influence factor , meaning they have a part of the calculation that is determined by how the market(s) are doing, be it the market/industry your company operates in, or the larger S&P 500 stock index (as a proxy of a large pool of companies). This makes it hard, for example to use tools (such as the DCF) that try and use the past performance of a startup (particularly when there is hardly a track record that is highly reliable as an indicator of future performance) as a means by which to extrapolate future performance. This is why comparables, particularly transaction comparables are favored for early stage startups as they are better indicators of what the market is willing to pay for the startups ‘most like’ the one an investor is considering.

But by knowing (within some degree of instinctual or calculated certainty) what the likely exit value of my company will be in the future, how does an investor then decide what my value should be now?

Again, knowing what the exit price will be, or having an idea of what it will be, means that an investor can calculate what their returns will be on any valuation relative to the amount of money they put in, or alternatively what their percentage will be in an exit (money they put in, divided by the post-money valuation of your company = their percentage).  Before we proceed, just a quick glossary:

Pre-Money = the value of your company now
Post-Money = the value of your company after the investor put the money in
Cash on Cash Multiple = the multiple of money returned to an investor on exit divided by the amount they put in throughout the lifetime of the company

So, if an investor knows how much % they own after they put their money in, and they can guess the exit value of your company, they can divide the latter from the former and get a cash-on-cash multiple of what their investment will give them (some investors use IRR values as well of course, but most investors tend to think in terms of cash-on-cash returns because of the nature of how VC funds work). Assume a 10x multiple for cash-on-cash returns is what every investor wants from an early stage venture deal, but of course reality is more complex as different levels of risk (investors are happy with lower returns on lower risk and later stage deals, for example) will have different returns on expectations, but let’s use 10x as an example however, because it is easy, and because I have ten fingers. However, this is still incomplete, because investors know that it is a rare case where they put money in and there is no requirement for a follow-on investment. As such, investors need to incorporate assumptions about how much more money your company will require, and thus how much dilution they will (as well as you) take provided they do (or don’t ) follow their money up to a point (not every investor can follow-on in every round until the very end, as many times they reach a maximum amount of money invested in one company as is allowed by the structure of their fund).

Now, armed with assumptions about the value of your company at exit, how much money it may require along the way, and what the founding team (and their current investors) may be willing to accept in terms of dilution, they will determine a ‘range’ of acceptable valuations that will allow them, to some extent, to meet their returns expectations (or not, in which case they will pass on the investment for ‘economics’ reasons). This method is what I call the ‘top-down’ approach…

Naturally, if there is a ‘top-down’, there must be a ‘bottom-up’ approach, which although is based on the ‘top-down’ assumptions, basically just takes the average entry valuation for companies of a certain type and stage an investor typically sees and values a company relative to that entry average. The reason why I say this is based on the ‘top-down’ is because that entry average used by the bottom-up approach, if you back-track the calculations, is based on a figure that will likely give investors a meaningful return on an exit for the industry in question. Additionally, you wouldn’t, for example, use the bottom-up average from one industry for another as the results would end up being different. This bottom-up approach could yield an investor saying the following to you when offering you a termsheet:

“a company of your stage will probably require x millions to grow for the next 18 months, and therefore based on your current stage, you are worth (money to be raised divided by % ownership the investor wants – money to be raised) the following pre-money”.

One topic that I’m also skipping as part of this discussion, largely because it is a post of its own, is “how much money should I raise?”. I will only say that you will likely have a discussion with your potential investor on this amount when you discuss your business plan or financial model, and if you both agree on it, it will be part of the determinant of your valuation. Clearly a business where an investor agrees that 10m is needed and is willing to put it down right now, is one that has been de-risked to some point and thus will have a valuation that reflects that.

So being that we’ve now established how much the market and industry in which you company plays in can dictate the ultimate value of your company, lets look at what other factors can contribute to an investor asking for a discount in value or an investor being willing to pay a premium over the average entry price for your company’s stage and sector. In summary:

An investor is willing to pay more for your company if:

  • It is in a hot sector:investors that come late into a sector may also be willing to pay more as one sees in public stock markets of later entrants into a hot stock.
  • If your management team is shit hot: serial entrepreneurs can command a better valuation (read my post of what an investor looks for in a management team). A good team gives investors faith that you can execute.
  • You have a functioning product (more for early stage companies)
  • You have traction: nothing shows value like customers telling the investor you have value.

An investor is less likely to pay a premium over the average for your company (or may even pass on the investment) if:

  • It is in a sector that has shown poor performance.
  • It is in a sector that is highly commoditized, with little margins to be made.
  • It is in a sector that has a large set of competitors and with little differentiation between them (picking a winner is hard in this case).
  • Your management team has no track record and/or may be missing key people for you to execute the plan (and you have no one lined up). Take a look at my post on ‘do I need a technical founder?‘.
  • Your product is not working and/or you have no customer validation.
  • You are going to shortly run out of cash

In conclusion, market forces right now greatly affect the value of your company. These market forces are both what similar deals are being priced at (bottom-up) and the amounts of recent exits (top-down) which can affect the value of a company in your specific sector. The best thing you can do to arm yourself with a feeling of what values are in the market before you speak to an investor is by speaking to other startups like yours (effectively making your own mental comparables table) that have raised money and see if they’ll share with you what they were valued and how much they raised when they were at your stage. Also, read the tech news as sometimes they’ll print information which can help you back track into the values. However, all is not lost. As I mentioned, there are factors you can influence to increase the value of your startup, and nothing increases your company’s value more than showing an investor that people out there want your product and are even willing to pay for it.

Hope this helped! Feel free to ask questions in the comments.

UPDATE: I wrote some additional notes on early-stage startup valuation because I felt I didn’t quite cover all parts in the above summary. You can ready those by clicking here.

Other Pieces on the subject

Enhanced by Zemanta
Continue Reading