Changes

Jump to navigation Jump to search
no edit summary
|Has paper status=In development
}}
 
==Counterfactual Variables==
 
Version 2-2 of the dataset includes the following sets of variables:
# firmappmoomirank,firmexitsrank,firmappexitmrank,firmappinvmrank,firmportcosrank,
# firmappmoomiwrank,firmappmoomitruncwrank,firmappexitmwrank,
# firmappmoomirankqtile,firmexitsrankqtile,firmappexitmrankrankqtile,firmappinvmrankqtile,firmportcosrankrankqtile,
# firmappmoomiwrankrankqtile,firmappmoomitruncwrankqtile,firmappexitmwrankrankqtile
 
The first set ranks the performance measures already in the dataset using only the 3542 VC firms in the dataset: apportioned MOOMI (firmapportionedmoomi), exits (firmexits), apportioned exit value (firmapportionedexitvaluem), apportioned investment (firmtotalapportionedinvm) and the total number of portcos invested in (firmnumportcos).
 
The second set calculates weighted ranks or truncated weighted ranks (where 1 is the best and 3542 is the worst):
* firmappmoomiwrank ranks firmappmoomi*(firmportcos/sumfirmportcos
* firmappmoomitruncwrank ranks firmappmoomi*((CASE WHEN firmportcos <= 75 THEN firmportcos ELSE 75 END)/sumfirmportcostrunc)
* firmappexitmwrank ranks firmappexitm*(firmportcos/sumfirmportcos)
 
The third and fourth sets are the ranks above as quartiles (i.e., 1 is best, 4 is worst).
 
By all means, play with the variables! My guess as to the "best" (i.e., closest approximation to true quality as measured by long-run returns) is (in order):
* '''firmappmoomiwrank''': This puts all the most famous VCs in the top quartile and the bottom quartile truly sucks.
* firmappmoomitruncwrank (harder to justify the truncation, so second place but gives higher rankings to successful small firms who face a pretty stiff size penalty in firmappmoomiwrank)
* firmappexitmwrank: Doesn't take into account investment but still delivers a good result
 
I also took a look at which types of firms to remove. It turns out that '''firmcat''' was already pretty well put together (i.e., I'd gone down that rabbit hole and excavated it). So, I suggest that we try the following components separately and then, depending on the results, consider the following groupings:
* Corporate
* PE
* Ecosystem + Angel
* Gov + SBIC
==Notes==

Navigation menu