How to measure practically the performance of Venture Capital backed tech firms following an IPO?

I am currently writing a thesis about whether the fact that a tech firm backed by venture capital companies achieves higher returns following an IPO (Horizon of 3 years).

I have about 800 tech stocks on the US market that did and IPO (From Capital IQ data) and their monthly returns and other variables.

I know how to use Fama French for a single stock on Excel or R and get the alpha, but I do not know how to regress for 800 stocks and based on a new factor which is the % holding of a Venture Capital firm in each tech company. So my question is how to use these data to get a result and see if the fact that a venture capital company invests in a firm, will enable higher stock returns after the IPO ..

First problem, I have 800 stocks not one, how do I regress that on R ? Should I constitute a “fund” of all my stocks, but based on what weight if this is the case?

Second issue, how do I incorporate my new factor “% Holding of a VC in each firm”? Should I put a new column next to my Fama French factors? The problem is also that I have this data for each stock individually not on an aggregate basis which is normal.

If someone has done a similar job, that would help me a lot to realize this research, I will appreciate to give you my results!

Thanks in advance for your answers!

Gautier

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”