VC Report Houston 2017

McNair Project

VC Report Houston 2017
Project Information
Project Title	VC Report Houston 2017
Owner	Dylan Dickens
Start Date	201702
Deadline	201704
Keywords	Venture Capital
Primary Billing
Notes
Has project status	Subsume
Copyright © 2016 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.

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.