VC Report Houston 2017

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

Project

VC Report Houston 2017
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.

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.