Difference between revisions of "VC Report Houston 2017"

From edegan.com
Jump to navigation Jump to search
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{McNair Projects
+
{{Project
|Has image=  
+
|Has project output=Data,Content
 +
|Has sponsor=McNair Center
 
|Has title=VC Report Houston 2017
 
|Has title=VC Report Houston 2017
 
|Has owner=Dylan Dickens
 
|Has owner=Dylan Dickens
Line 6: Line 7:
 
|Has deadline=201704
 
|Has deadline=201704
 
|Has keywords=Venture Capital
 
|Has keywords=Venture Capital
|Is billed to=
+
|Has project status=Subsume
|Has notes=
 
|Has project status=Active
 
|Is dependent on=
 
|Depends upon it=
 
 
}}
 
}}
 +
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 on to the [[Accenture Work]]. The objective is to produce an issue brief within 2 weeks.
+
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 lookup list. Then follow the filter, unique, and lookup methodology by hand.  
  
 
==Data set up==
 
==Data set up==
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston
+
 
*Restrict on State and Nation
+
===Restrictions===
*Restrict 1980-present for pull. Will likely do 2007-2016 for outputs.
+
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Pull company stage at level 3 at each round date - exclude and break as per table below
+
*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==
 
==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)
  
:Count of IPOs by Year 2011 - 2016
+
IPO graph
:Count of All M&As by Year 2011 - 2016
+
*Count of IPOs by Year
:Count of All M&As in Finance Sector by Year 2011 - 2016
+
**SEL backed
:Count of Early, Late, or Seed Backed M&As by Year M&As 2011 - 2016
+
**Other VC backed
: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
 
:Early, Late, or Seed 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 - 2016
 
  
 +
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.
 
Broad and specific industries correspond to Minor Group and [[VentureXpert Industry Classification|Subgroup 3]] in the SDC terminology.

Latest revision as of 12:42, 21 September 2020


Project
VC Report Houston 2017
Project logo 02.png
Project Information
Has title VC Report Houston 2017
Has owner Dylan Dickens
Has start date 201702
Has deadline date
Has keywords Venture Capital
Has project status Subsume
Subsumed by: Houston Entrepreneurship
Has sponsor McNair Center
Has project output Data, Content
Copyright © 2019 edegan.com. All Rights Reserved.

This project is a follow on to the Accenture Work. The objective is to produce an issue brief within 2 weeks.

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 lookup list. Then 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
    • SEL backed
    • Other VC backed

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 Subgroup 3 in the SDC terminology.