VC Policy Report

From edegan.com
Jump to navigation Jump to search

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)