Difference between revisions of "VC Report Houston 2017"

From edegan.com
Jump to navigation Jump to search
Line 8: Line 8:
 
}}
 
}}
 
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==

Revision as of 17:48, 20 March 2017


McNair Project
VC Report Houston 2017
Project logo 02.png
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.

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.