Changes

Jump to navigation Jump to search
no edit summary
{{McNair ProjectsProject|Has project output=Data,Content|Has imagesponsor= McNair Center
|Has title=VC Report Houston 2017
|Has owner=Dylan Dickens
|Has deadline=201704
|Has keywords=Venture Capital
|Is billed to=|Has notes=|Has project status=Active|Is dependent on=|Depends upon it=Subsume
}}
This project is a follow on to the [[Accenture Work]]. The objective is to produce an issue brief within 2 weeks.
This project is a follow Steps on Wednesday: Match All IPO Names with Years and M&A Names with Years to Unique SEL Names and Unique True Other Names, this is the [[Accenture Work]]lookup list. The objective is to produce an issue brief within 2 weeksThen follow the filter, unique, and lookup methodology by hand.
==Data set up==
 
===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX
 
===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd
 
===Exclusions and Classifications===
 
Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage
 
Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround
 
Exclude (non-VC)
LBO
MBO
Open Market Purchase
PIPE
Secondary Buyout
 
==Artifacts==
Deals graph
*Count of SEL Deals by Year
*Count of Other Deals by Year
*Count of Still Active SEL VC Backed Startups by year (do last)
 
Rounds graph
*Count of SEL VC Investments by Year
*Amount Disclosed SEL VC Investments by Year
*Count of Other VC Investments by Year
*Amount Disclosed Other VC Investments by Year
 
Industry graph
*Amount Disclosed SEL VC Investments by Broad Industry (Minor in SDC)
*Amount Disclosed Other VC Investments by Broad Industry (Minor in SDC)
:IPO graph*Count of IPOs by Year 2011 - 2016:Count of All M&As by Year 2011 - 2016:Count of All M&As in Finance Sector by Year 2011 - 2016:Count of Early, Late, or Seed Backed M&As by Year M&As 2011 - 2016:Count of Early, Late, or Seed Backed M&As in Finance Sector by Year 2011 - 2016:Count of All VC Investments by Year 2011 - 2016:Amount Disclosed All VC Investments by Year 2011 - 2016:All VC Investments by Industry (Broad) 2011 - 2016:All VC Investments by Industry (Specific) 2011 - 2016:Count of All VC Investments by Type of Investment 2011-2016:Amount of All VC Investments by Type of Investment 2011-2016:Count of Early, Late, or Seed VC Investments by Year 2011 - 2016:Amount Disclosed Early, Late, or Seed VC Investments by Year 2011 - 2016**SEL backed:Early, Late, or Seed **Other VC Investments by Industry (Broad) 2011 - 2016:Early, Late, or Seed VC Investments by Industry (Specific) 2011 - 2016:Count of Still Active Early, Late, or Seed VC Backed Startups 2011 - 2016:Count of Early, Late, or Seed Deals by Year 2011 - 2016backed
M&A graph
*Count of All M&As by Year
**SEL backed
**Other VC backed
*Count of All M&As in Finance Sector by Year
**SEL backed
**Other VC backed
Broad and specific industries correspond to Minor Group and [[VentureXpert Industry Classification|Subgroup 3]] in the SDC terminology.

Navigation menu