VC Policy Report
General
The purpose of this report is to demonstrate the increased market share of VC-backed, publicly-traded companies.
Contents
1. VC into US portfolio companies (round amount) big year (in Hubs database. psql vc policy) + Match List (Ben has this)
2. Acquisitions (100%, complete) of US firms by US firms - transaction value -> match to VC
3. IPOs (completed) - enterprise value and gross proceeds of US firms on Nasdaq, Amex, NYSE -> match to VC
4. (from compstat) Sales and market value of publicly traded (nasdaq, nyse, amex) US firms (shrout*price) -> match to VC
company name, exchange, ticket, sales, mkt value, naics, cusip, state, year
VC Policy Report Database
DataBase in the Z: Drive under
vcpolicy
Database documentation in
Z:\bulk\VCPolicy
Including all code in
Z:\bulk\VCPolicy\VCPolicyReport.sql
Tables in Database
allacquis
All Acquisitions based on SDC Data documented in
E:\McNair\Projects\MoneyIN_MoneyOUT
allipo
All Acquisitions based on SDC Data documented in
E:\McNair\Projects\MoneyIN_MoneyOUT
allvc
All Acquisitions based on SDC Data documented in
E:\McNair\Projects\MoneyIN_MoneyOUT
roundinfo
From roundinfoclean table from Hubs database
salesmktval
From Compustat data in table "vc4.txt" in the database documentation folder (detailed earlier)
