Monte Carlo Simulation: SEIS and EIS Investor Return
? WikiCommons

Monte Carlo Simulation: SEIS and EIS Investor Return


?

I had a few spare hours this week to build a Monte Carlo model to predict SEIS and EIS returns for investors. As input, I used data from Beauhurst plus common “investor wisdom”.

Exit Data

Beauhurst “Exits in the UK. Acquisitions and IPO 2011-2020”. I used the data from the report to create a table making sure that the distribution (and positive skewness) is similar to the Beahurst Data. To adjust for inflation, I increased the exit values by 25%. I fully expect people to question this percentage. ?Some say we are in a bull market that will continue others expect mean reversion.

SEIS input

An often-quoted statistic is that 70% of the investments in start-ups will fail to create a return, 20% will be good investments and 10% are the star performers. For a SEIS investment I translated this into the following input:

Complete failure (Mean 50%, SD 5%). Complete failure means a SEIS adjusted return of -27.5%

Negative IRR (Mean 20%, SD 5%). Normally distributed between 0 and – 27.5%

Good investment versus Star performer (Mean 65%, SD 8%)

For a good investment, I use a multiple on valuation (Mean 6, SD 2).

For a star performer, I used the Beahurst exit Data

Time to exit (Mean 5 years, SD 1.25 years). This is probably a bit lower than expected but I wanted to consider other liquidity events like dividends. Not all SEIS investments are large Tech exits.

Average Investment (Mean £75.000, SD £12.500)

Ownership % (Mean 23%, SD 3.8%)

I struggled with dilution. Dilution is very likely but how much is difficult to estimate. I can’t recall ever seeing historic data. I used the following input.

Average Dilution (Mean 38%, SD 6%)

I used XIRR to calculate IRR. For valuation purposes, I adjusted the valuation upon investment by 50%.

Model run: 10.0000

EIS input

I assume that EIS investments are less risky and quicker to Exit than SEIS investments but have a higher valuation.

?

Complete failure (Mean 35%, SD 5%). Complete failure means a SEIS adjusted return of -38.5%

Negative IRR (Mean 15%, SD 5%). Normally distributed between 0 and – 38.5%

Good investment versus Star performer (Mean 45%, SD 3%)

For a good investment, I use a multiple on valuation (Mean 3.5, SD 0.75).

For a star performer, I used the Beahurst exit Data

Time to exit (Mean 4 years, SD 1 year)

Average Investment (Mean £450.000, SD £150.000)

Ownership % (Mean 25%, SD 2.5%)

Average Dilution (Mean 25%, SD 8%)

I used XIRR to calculate IRR. For valuation purposes, I adjusted the valuation upon investment by 30%.

Model run: 10.0000

Results SEIS

Expected IRR +/- 15%

Average valuation: +/-£350K

No alt text provided for this image

Results EIS

Expected IRR +/- 12%

Average valuation

+/-£ 1.7 mln

No alt text provided for this image

?

I expected the returns to be a bit higher (15%-20%). Besides that, the results are not that surprising. SEIS returns are riskier but higher. EIS is less risky but with a slightly lower return. Compared to other asset classes the return/risk profile is (very) high.

Notes

-?????????This is not an in-depth project. Just a bit of fun pairing existing Exit Data with "Investor Wisdom" in a Monte Carlo model.

-?????????I don’t believe Angel investment is an efficient market. An investor can find/create Alpha. Having said that: Beta and randomness are key IRR drivers. A portfolio approach is recommended.

-?????????If as an investor your valuation paid is significantly higher than the average you expect to create/find more Alpha, have faster exit times, and/or expect a significant increase in Exit prices versus historic 2011-2020 prices.

-?????????“Compound interest is the most powerful force in the universe”. The difference between a 12% IRR and a 15% IRR is a lot bigger than you think it is. Time to liquidity is very important

-?????????Changes in the input have a big impact on the outcome. The dilution factor is a bit of a stab in the dark. If your assumptions are different from my assumptions the outcome will be very different.?Just make sure your assumptions are grounded and possibly based on historic data.

-?????????If I find better data and/or other Monte Carlo models I might recalculate/change the model but otherwise this is a one-time fun project.

-?????????A low-value, non-sexy investment with a dividend stream can easily create an IRR that is higher than the big, heavily diluted, highly-priced tech exit.

-?????????Excuses for the jargon. I did not want to spend ages writing the article.

?

?

James Pringle

Principal @ Redbus Ventures & Co-Host @ Riding Unicorns

3 年
回复

To clarify. The maximum loss on a SEIS/EIS investment is based on paying 45% income tax ( but I did not include Capital Gains tax relief ). A nice calculator can be found at https://seiscalculator.co.uk/ although personally, I would have used IRR instead of multiples for the return calculation.

回复

要查看或添加评论,请登录

社区洞察

其他会员也浏览了