# Possible Insight

## Angel Investing Returns

In my work for RSCM, one of the key questions is, “What is the return of angel investing?”  There’s some general survey data and a couple of angel groups publish their returns, but the only fine-grained public dataset I’ve seen comes from Rob Wiltbank of Willamette University and the Kauffman Foundation’s Angel Investor Performance Project (AIPP).

In this paper, Wiltbank and Boeker calculate the internal rate of return (IRR) of AIPP investments as 27%, using the average payoff of 2.6x and the average hold time of 3.5 years.  Now, the arithmetic is clearly wrong: 1.27^3.5 = 2.3.  The correctly calculated IRR using this methodology is 31%. DeGenarro et al report (page 10) that this discrepancy is due to the fact that Wiltbank and Boeker did not weight investments appropriately.

In any case, the entire methodology of using average payoffs and hold times is somewhat iffy.  When I read the paper, I immediately had flashbacks to my first engineering-economics class at Stanford.  There was a mind-numbing problem set that beat into our skulls the fact that IRR calculations are extremely sensitive to the timing of cash outflows and inflows.  I eventually got a Master’s degree in that department, so loyally adopted IRR sensitivity as a pet peeve.

To calculate the IRR for the AIPP dataset, what we really want is to account for the year of every outflow and inflow.   The first step is to get a clean dataset.  I started by downloading the public AIPP data.  I then followed a three step cleansing process:

1. Select only those records that correspond to an exited investment.
2. Delete all records that do not have both dates and amounts for the investment and the exit.
3. Delete all records where time runs backwards (e.g., payout before investment).

The result was 452 records.  A good-sized sample.  The next step was to normalize all investments so they started in the year 2000.  While not strictly necessary, it greatly simplified the mechanics of collating outflows and inflows by year.  Finally, I had to interpolate dates in two types of cases:

1. While the dataset includes the years of the first and second follow on investment, it does not include the year for the “followxinvest”. For the affected 12 records, I interpolated by calculating the halfway point between the previous investment and the exit, rounding down.  Note that this is a conservative assumption.  Rounding down pushes the outflow associated with the investment earlier, which lowers the IRR.
2. For 78 records, there are “midcash” entries where investors received some payout before the final exit.  Unfortunately, there is no year associated with this payout.  A conservative assumption pushes inflows later, so I assumed that the intermediate payout occurred either 0, 1, or 2 years before the final exit.  I calculated the midpoint between the last investment and the final exit and rounded down.  If it was more than 2 years before the final exit, I used 2 years.

With these steps completed, I simply added up outflows and inflows for every year and used the Excel IRR calculation.

The result was an IRR of 30% and a payoff multiple of 2.4x with an average hold time of 3.6 years.

Please note that this multiple is slightly lower than the 2.6x and the hold time is slightly higher than the 3.5 years Wiltbank and Boeker calculated for the entire dataset.  Thus, my results do not depend on accidentally cherry-picking high-returning, quick-payout investments.  If you want to double-check my work, you can download the Excel file here.

All in all, a satisfying result.  Not too different from what’s other people have published, but I feel much more confident in the number.  For anyone analyzing subsets of the AIPP data, I’ve found that my Excel file makes it pretty easy to calculate those returns.  Just zero out all records you don’t care about by selecting the row and hitting the “Delete” key.  The return results will update correctly.  But don’t do a “Delete Row”.  Then a bunch of the cell references will be broken.  [Update 1/27/11: I’ve done a follow up post on using this method to test various hypotheses.]

Written by Kevin

January 17, 2011 at 4:53 pm

### 11 Responses

1. Looking at the dataset, I see about a 2/3 probability of a non-zero exit, and a 48% probability of a positive undiscounted return. Don’t those numbers seem high?

Todd White

January 20, 2011 at 11:03 pm

• Not really. Remember, these investments are across all stages. They’re not just ideas on paper. A lot of them were probably pretty established ongoing businesses.

Kevin

January 21, 2011 at 2:45 am

2. […] Search Recent CommentsKevin on Angel Investing ReturnsTodd White on Angel Investing ReturnsRafe Furst on Startups, Small Businesses, and Large […]

3. Is EndFund an April Fool’s Day joke?…

Ironically, the EndFund joke sounds like a snide summary of what I’m actually doing. We want to invest in 100s of pre-revenue, even pre-product companies per year. We will in fact ignore the idea, except to make sure it’s in the technology space. But…

Quora

April 3, 2011 at 11:38 am

4. How many startups do entrepreneurs launch and fail before finding a hit?…

Unfortunately, there isn’t any data that I know of for your particular definition of entrepreneur, but we can look at the general data to at least get a feel. If you look at the Kauffman angel data (which I have done at http://emergentfool.com/2011/01

Quora

May 6, 2011 at 10:03 am

5. […] Before making the decision to join the firm, I did some research on early-stage tech investing as an asset class. What was striking was what an attractive asset class it was. Although any given early-stage company is quite risky, when aggregated across a large portfolio, returns are very attractive. There is also low correlation to risks that investors inherently have in most of their other investments, e.g., interest rate volatility, exchange rates, macro factors such as unrest in the Middle East, commodity fluctuations, unfunded pensions, etc. In addition, angel investments historically have a low correlation level with other asset classes, given the nimbleness with which small companies can adjust to changes in the economy, and the great diversity of companies in the typical early-stage portfolio. As a result, various analyses have shown annualized returns of 18-37%, 27%, and 30%. […]

6. […] to our Web statistics, my post on Angel Investing Returns was pretty popular, so I thought I’d dive a little deeper into the process of extracting […]

7. […] Moneyball-type analysis using the available evidence for technology startups (see here, here, here, here, here, and here).  But I thought I’d take this opportunity to make the analogy […]

8. […] on how your selection criteria, returns are at least 30 and possibly over 40%.  Calculations here and […]

9. This is better methodology, but it’s wasted on suspect data. The data set comes from self-reporting, and only 13% of the surveyed angels responded. That’s two huge biasing factors. I suspect, based on the number of startups I see with seed rounds that never raise professional money, that the actual return is an order of magnitude lower.

Matt

February 2, 2014 at 11:23 pm