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*Restrict on 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 NationClassifications===  Seed/Early/Later (Real VC) Seed Early Stage Later Stage  Other VC*Restrict 1980-present for pull Acq. Will likely do 2007-2016 for outputs.Expansion Acquisition Bridge Loan Expansion Pending Acq Recap or Turnaround *Pull company stage at level 3 at each round date Exclude (non- exclude and break as per table belowVC) 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