Silicon Valley Bank Data Project - Revision history

imported>Ed at 01:49, 2 March 2011

2011-03-02T01:49:56Z

imported>Ed at 01:40, 2 March 2011

2011-03-02T01:40:13Z

imported>Ed: /* The Valuations Data */

2011-03-01T23:45:30Z

The Valuations Data

imported>Ed: /* The Valuations Data */

2011-03-01T23:20:13Z

The Valuations Data

imported>Ed: /* The Valuations Data */

2011-03-01T23:04:21Z

The Valuations Data

imported>Ed at 23:04, 1 March 2011

2011-03-01T23:04:01Z

imported>Ed: /* The CapMx Data */

2011-03-01T21:08:16Z

The CapMx Data

imported>Ed at 21:06, 1 March 2011

2011-03-01T21:06:41Z

imported>Ed at 20:29, 1 March 2011

2011-03-01T20:29:47Z

imported>Ed: /* The CapMx Data */

2011-03-01T20:20:00Z

The CapMx Data

@@ Line 6: / Line 6: @@
 '''From Haas''':
-*Jerry Engel (engel@haas.berkeley.edu), Faculty Director, Lester Center for Enterpreneurship and Innovation
+*Jerry Engel (engel@haas.berkeley.edu), Faculty Director, Lester Center for Entrepreneurship and Innovation
 *Toby Stuart (tstuart@haas.berkeley.edu), Visiting Faculty from Harvard Business School
 *Javed Ahmed (jahmed@haas.berkeley.edu), PhD Candidate in finance
@@ Line 47: / Line 47: @@
 =====The Valuations Data=====
-Michael estimated that that SVB has 'valuations' data on 2600 early stage firms, with many firms having multiple valuations conducted over time. [http://en.wikipedia.org/wiki/Internal_Revenue_Code_section_409A Internal Revenue Code 409A] requires that there be no discrepency between an options value and the value of common stock, in part to prevent issue with backdating of options, and that valuations be conducted by a third-party at an arm's length from either the 'service recipient' (i.e. employee/executive/etc) and the 'service provider' (i.e. the firm). Thus firms may have approached SVB to provide them with valuations on the firms common stock potentially every time that there is an event, such as a stock option issue, which would require compliance. SVB has been collecting this data for approximately 4 years.
+Michael estimated that that SVB has 'valuations' data on 2600 early stage firms, with many firms having multiple valuations conducted over time. [http://en.wikipedia.org/wiki/Internal_Revenue_Code_section_409A Internal Revenue Code 409A] requires that there be no discrepancy between an options value and the value of common stock, in part to prevent issue with backdating of options, and that valuations be conducted by a third-party at an arm's length from either the 'service recipient' (i.e. employee/executive/etc) and the 'service provider' (i.e. the firm). Thus firms may have approached SVB to provide them with valuations on the firms common stock potentially every time that there is an event, such as a stock option issue, which would require compliance. SVB has been collecting this data for approximately 4 years.
 SVB is interested in (co-)authoring an article on valuation for publication in a (trade) journal. Michael has noticed that option pricing models (i.e. Black-Scholes models) lead to over-valuation of the stock, especially for non-participating preferred stock, and that the use of 'mulitple models' (i.e. those that use simple 1x-2x, 2x-3x, 4+ x valuations) are far more accurate valuations, and would like assistance in exploring this.
@@ Line 61: / Line 61: @@
 =====The CapMx Data=====
-One core service that the bank offers to its clients is the management of their firm's capital tables. The CapMx database was estimated to have approximately 2000 users, and contains details on the capital structure of the firm including common stock outstanding, preferred stock outstanding, warrants and stock options, employee share option plans, and liquidation preferrences. The users of this data are both the firms themselves, and accounting/law firms that work for these firms. The tables are 'initialized by agents' and then accessed by the firms.
+One core service that the bank offers to its clients is the management of their firm's capital tables. The CapMx database was estimated to have approximately 2000 users, and contains details on the capital structure of the firm including common stock outstanding, preferred stock outstanding, warrants and stock options, employee share option plans, and liquidation preferences. The users of this data are both the firms themselves, and accounting/law firms that work for these firms. The tables are 'initialized by agents' and then accessed by the firms.
 ==The February 4th Meeting (at SVB)==
@@ Line 100: / Line 100: @@
 The data exists in two databases: an operational database, and a development database which is populated by quarterly draws from the the operational database. Both databases run on an Oracle platform and the SVB Analysis group uses the [http://www.toadworld.com/Freeware/ToadforOracleFreeware/tabid/558/Default.aspx Toad] client to run SQL statements on it. The development data is validated and cleaned manually by SVB staff, and we could expect draws from this source. The data lives in a series of (flat) tables, with the main table containing the financials keyed as CompanyName-DateOfFinancials, and other tables, such as for the year of founding, keyed by CompanyName.
-SVB takes data from the validated and cleaned development database and uploads this onto their online [http://www.birst.com/ Birst] based web-platform, to provide their benchmarking service.  Companies accessing this data through the Birst interface are restricted the selecting aggregate benchmarking portfolios to compare their firm against. The interface allows them to construct portfolios on the basis of geography, industry, comparability in terms of financial ratios, and so forth, and reports the size of the comparing portfolio as either 5-30 firms, 31-100 firms, and so forth. Firms are restricted to seeing comparison portfolios composed of at least 5 firms. SVB is trying to advance this service into a CEO desktop tool, which will report things like [http://willprice.blogspot.com/2008/03/magic-number-for-saas-companies.html Josh James' Magic Number] - this requires fine grained data as well as uninterupted sequential financial statements, which is surely good news for researchers going forward.
+SVB takes data from the validated and cleaned development database and uploads this onto their online [http://www.birst.com/ Birst] based web-platform, to provide their benchmarking service.  Companies accessing this data through the Birst interface are restricted the selecting aggregate benchmarking portfolios to compare their firm against. The interface allows them to construct portfolios on the basis of geography, industry, comparability in terms of financial ratios, and so forth, and reports the size of the comparing portfolio as either 5-30 firms, 31-100 firms, and so forth. Firms are restricted to seeing comparison portfolios composed of at least 5 firms. SVB is trying to advance this service into a CEO desktop tool, which will report things like [http://willprice.blogspot.com/2008/03/magic-number-for-saas-companies.html Josh James' Magic Number] - this requires fine grained data as well as uninterrupted sequential financial statements, which is surely good news for researchers going forward.
 The process of uploading the data to Birst is as follows:
@@ Line 129: / Line 129: @@
 You can fill out a [http://www.svb.com/Products-and-Services/SVB-Analytics/capmx-demo-equity-tracking/ form to view a demo] of the [http://www.eprosper.com/ online interface] into the CapMX data. This online interface provides users with access to their data, and allows the users to conduct a limited number (and range) of transactions on it.
-The database can accomodate data on the the authorized capital of the firm, all transactions performed on this capital, individuals/entities associated with this capital and/or these transactions, and details on the firm itself. However, there is little to no incentive for the firms or representatives of the firms to fill out any data beyond that which is required to record and use the capital structure at a particular moment in time.
+The database can accommodate data on the authorized capital of the firm, all transactions performed on this capital, individuals/entities associated with this capital and/or these transactions, and details on the firm itself. However, there is little to no incentive for the firms or representatives of the firms to fill out any data beyond that which is required to record and use the capital structure at a particular moment in time.
 The original capital structure of the firm is inputted by staff at SVB. There is an 'upload template' to guide the staff in this process, and data is sourced from the certificate of incorporation (or certificate of authorization for later issues). However, the input suffers from a number of issues:
@@ Line 143: / Line 143: @@
 Records are updated in two ways:
 *At every financing round the bank updates the underlying capital structure
-*By conducting transactions on the underlying structure through the online interface the structure can be automatically updated. (Note that in order to conduct a transaction on the capital structure, the components of the capital structure relevent to the transation must be up to date. Thus transactions can act to validate the underlying structure data.) '''A full history of every transaction ever conducted is maintained throughout the firm's lifetime.'''
+*By conducting transactions on the underlying structure through the online interface the structure can be automatically updated. (Note that in order to conduct a transaction on the capital structure, the components of the capital structure relevant to the transaction must be up to date. Thus transactions can act to validate the underlying structure data.) '''A full history of every transaction ever conducted is maintained throughout the firm's lifetime.'''
 Firms may conduct transactions related to:
@@ Line 149: / Line 149: @@
 *Options
 *Warrants
-*Convertible Promisory Notes (CPN)
+*Convertible Promissory Notes (CPN)
 *SPN
 *Rollbacks
@@ Line 160: / Line 160: @@
 *Repricings
-Firms may also examine issues for [http://taft.law.uc.edu/CCL/33ActRls/rule701.html Rule 701 Compliance], conduct (one-stage) anti-dillution analysis, conduct (one-stage) liquidation preference analysis, compute the firm's fair market value, and build a wide variety of reports on the capital structure or transactions conducted upon the capital structure. (Note that by "one-stage" I mean that the data can be taken from the system and a single hypothetical analysis can be performed, and that it is not possible to temporarily store the changed capital structure that would result from the hypothetical analysis in order to conduct further hypothetical analysis. This does limit the usefullness of the tool with regard to simulation of the capital structure over time, such as for an exit analysis. SVB have recognised this limitation and are considering potential improvements [EJE]). No permanent record is kept of the one-stage analyses, or the reports produced.
+Firms may also examine issues for [http://taft.law.uc.edu/CCL/33ActRls/rule701.html Rule 701 Compliance], conduct (one-stage) anti-dilution analysis, conduct (one-stage) liquidation preference analysis, compute the firm's fair market value, and build a wide variety of reports on the capital structure or transactions conducted upon the capital structure. (Note that by "one-stage" I mean that the data can be taken from the system and a single hypothetical analysis can be performed, and that it is not possible to temporarily store the changed capital structure that would result from the hypothetical analysis in order to conduct further hypothetical analysis. This does limit the usefulness of the tool with regard to simulation of the capital structure over time, such as for an exit analysis. SVB have recognized this limitation and are considering potential improvements [EJE]). No permanent record is kept of the one-stage analyses, or the reports produced.
-The database contains 4032 firms records, of which 924 are 'blanks' which are created when people test or demo the system. There are additional firms named "X - In Conversion", "X - Expensing Only", and "X - Dissolved", (where X is string) that should be discarded. Thus there are a little under 3000 active firms on the system. Of these only 339 have completed some information on the firm beyond that which is required to maintain and use a record of the firm's capital structure. The database uses its own IDs (seperate from the CIF IDs mentioned above), but the firm name's are recorded directly from the Articles of Incorporation and should be sufficient to fully identify the firms.
+The database contains 4032 firms records, of which 924 are 'blanks' which are created when people test or demo the system. There are additional firms named "X - In Conversion", "X - Expensing Only", and "X - Dissolved", (where X is string) that should be discarded. Thus there are a little under 3000 active firms on the system. Of these only 339 have completed some information on the firm beyond that which is required to maintain and use a record of the firm's capital structure. The database uses its own IDs (separate from the CIF IDs mentioned above), but the firm name's are recorded directly from the Articles of Incorporation and should be sufficient to fully identify the firms.
-The database runs on an Oracle platform, but the actual structure of the data in the database was not discernable. The R&D group of SVB is responsible for the operation and maintainance of the underlying data. However, it seems very likely that a SQL script could pull all relevant data into a single flat file for analysis.
+The database runs on an Oracle platform, but the actual structure of the data in the database was not discernable. The R&D group of SVB is responsible for the operation and maintenance of the underlying data. However, it seems very likely that a SQL script could pull all relevant data into a single flat file for analysis.
 ===The Valuations Data===
@@ Line 192: / Line 192: @@
 SVB accumulated this data for three reasons:
 #Helping their clients make better decisions (though they are careful not to breach confidentiality requirements with the data) is a service business to them
-#To enhance internal decision making, particularly with regard to business risk lending, but also to establish best practises within the bank
+#To enhance internal decision making, particularly with regard to business risk lending, but also to establish best practices within the bank
 #To use it as a component of a brand building strategy
-SVB believe [EJE] that Haas could contribute the brand building strategy by producing (practitioner relevant) research that would be published in (trade) journals and/or presented at (trade) conferences. It seems possible that we could also contribute to the first two reasons directly. Specifically, PhD students, in the course of accessing and processing data for research, could provide recommendations for commercial applications of the the data that are current unrecognized or unexploited.
+SVB believe [EJE] that Haas could contribute the brand building strategy by producing (practitioner relevant) research that would be published in (trade) journals and/or presented at (trade) conferences. It seems possible that we could also contribute to the first two reasons directly. Specifically, PhD students, in the course of accessing and processing data for research, could provide recommendations for commercial applications of the data that are current unrecognized or unexploited.
 A request was made for examples of journals and conferences that SVB would find useful/relevant. It seems likely [EJE] that suitable journals/publications include:

← Older revision		Revision as of 01:40, 2 March 2011
Line 187:		Line 187:

	At present there are approximately 450 'valuations' in the database, where each valuation was converted from a spreadsheet into a series of entries in database tables. There are approximately another 1500 valuations in the pipeline waiting to be extracted from spreadsheets into the database. It is anticipated that this set will be complete in about 3 months [EJE]. The current valuations are mainly from late 2009 and early 2010. The pipeline contains all valuations performed since 2008. Again, the data input/conversion process relies on outsourcing to India. It is unclear what format the final database will be in, but a SQL compliance DB seems almost a certainty.		At present there are approximately 450 'valuations' in the database, where each valuation was converted from a spreadsheet into a series of entries in database tables. There are approximately another 1500 valuations in the pipeline waiting to be extracted from spreadsheets into the database. It is anticipated that this set will be complete in about 3 months [EJE]. The current valuations are mainly from late 2009 and early 2010. The pipeline contains all valuations performed since 2008. Again, the data input/conversion process relies on outsourcing to India. It is unclear what format the final database will be in, but a SQL compliance DB seems almost a certainty.
		+
		+	===A Relationship with SVB===
		+
		+	SVB accumulated this data for three reasons:
		+	#Helping their clients make better decisions (though they are careful not to breach confidentiality requirements with the data) is a service business to them
		+	#To enhance internal decision making, particularly with regard to business risk lending, but also to establish best practises within the bank
		+	#To use it as a component of a brand building strategy
		+
		+	SVB believe [EJE] that Haas could contribute the brand building strategy by producing (practitioner relevant) research that would be published in (trade) journals and/or presented at (trade) conferences. It seems possible that we could also contribute to the first two reasons directly. Specifically, PhD students, in the course of accessing and processing data for research, could provide recommendations for commercial applications of the the data that are current unrecognized or unexploited.
		+
		+	A request was made for examples of journals and conferences that SVB would find useful/relevant. It seems likely [EJE] that suitable journals/publications include:
		+	*Business Valuation Review
		+	*The Journal of Business Valuation
		+	*The Valuation Law Review
		+	*The Journal of Private Equity
		+	*Inc Magazine
		+	*The Wall Street Journal
		+
		+	SVB currently envisage the following access protocol:
		+	#Haas researchers pitch research projects to SVB personnel
		+	#Projects are examined on a case by case basis
		+	#Researchers are given on-site data access under an employee style contract to conduct approved research.
		+
		+	Going forward, we should contact Dan with questions regarding data points (I am happy to do this if further information is needed), and probably Michael for faculty-to-bank relationship questions.

← Older revision		Revision as of 23:45, 1 March 2011
Line 185:		Line 185:
	**PWERM (Probability Weighted Expected Return Method)		**PWERM (Probability Weighted Expected Return Method)
	**OPM (Option Price Method)		**OPM (Option Price Method)
		+
		+	At present there are approximately 450 'valuations' in the database, where each valuation was converted from a spreadsheet into a series of entries in database tables. There are approximately another 1500 valuations in the pipeline waiting to be extracted from spreadsheets into the database. It is anticipated that this set will be complete in about 3 months [EJE]. The current valuations are mainly from late 2009 and early 2010. The pipeline contains all valuations performed since 2008. Again, the data input/conversion process relies on outsourcing to India. It is unclear what format the final database will be in, but a SQL compliance DB seems almost a certainty.

← Older revision		Revision as of 23:20, 1 March 2011
Line 168:		Line 168:
	===The Valuations Data===		===The Valuations Data===

−	Providing valuations to clients is a major business task for SVB Analytics. Valuations of portfolio companies by funds are required to be done at an arm's length and to use 'fair market values', to comply with [http://www.fasb.org/summary/stsum157.shtml FAS 157], annually. Likewise valuations for the firms themselves to comply with [http://en.wikipedia.org/wiki/Internal_Revenue_Code_section_409A Internal Revenue Code 409A] , ~~but~~ clearly not all clients of the bank (or all firms in the industry) use SVB ~~for this purpose~~. Valuations are ~~also required whenever there is 'trigger event~~', ~~such~~ as the ~~issuance~~ of ~~stock options~~.	+	Providing valuations to clients is a major business task for SVB Analytics. Valuations of portfolio companies by funds are required to be done at an arm's length and to use 'fair market values', to comply with [http://www.fasb.org/summary/stsum157.shtml FAS 157], annually. Likewise, annual valuations are required for the firms themselves to comply with [http://en.wikipedia.org/wiki/Internal_Revenue_Code_section_409A Internal Revenue Code 409A]. Valuations are also required whenever there is 'trigger event', such as the issuance of stock options. However, clearly not all clients of the bank (or all firms in the industry) use SVB's valuation services.
		+
		+	Valuations are done using templated Excel spreadsheets. The sheets have the following elements:
		+	*The header: States the firm's name, industry and other information
		+	*Financial Info:
		+	**Actual - Taken from past annual statements
		+	**Calculated - Ratios and other calculated variables
		+	**Forecast - Annual forecasts for the next 1-3 years (typically). These forecasts are certified as accurate by the CEO.
		+	*Capital Structure of the Firm (may be drawn from CapMx)
		+	*Public Comparables: Lists comparable publicly held firms. The CEO acknowledges the comparability.
		+	*Summary of Valuation: Details the methods tried and (in which blend) used. Gives the equity value and hence the price per share.
		+	*Valuation Methods: Details the calculations of the various valuation methods. Methods include:
		+	**CVM (Current Value Method), a.k.a. Multiples Analysis (uses M&A Comparables)
		+	**Net Present Value (NPV) of future discounted cash flows
		+	**Weighted Average Cost of Capital (WACC)
		+	**PWERM (Probability Weighted Expected Return Method)
		+	**OPM (Option Price Method)

← Older revision		Revision as of 23:04, 1 March 2011
Line 168:		Line 168:
	===The Valuations Data===		===The Valuations Data===

−	Providing valuations to clients is a major business task for SVB Analytics. Valuations of portfolio companies by funds are required to be done at an arm's length and to use 'fair market values', to comply with [http://www.fasb.org/summary/stsum157.shtml FAS 157, annually. Likewise valuations for the firms themselves to comply with [http://en.wikipedia.org/wiki/Internal_Revenue_Code_section_409A Internal Revenue Code 409A] , but clearly not all clients of the bank (or all firms in the industry) use SVB for this purpose. Valuations are also required whenever there is 'trigger event', such as the issuance of stock options.	+	Providing valuations to clients is a major business task for SVB Analytics. Valuations of portfolio companies by funds are required to be done at an arm's length and to use 'fair market values', to comply with [http://www.fasb.org/summary/stsum157.shtml FAS 157], annually. Likewise valuations for the firms themselves to comply with [http://en.wikipedia.org/wiki/Internal_Revenue_Code_section_409A Internal Revenue Code 409A] , but clearly not all clients of the bank (or all firms in the industry) use SVB for this purpose. Valuations are also required whenever there is 'trigger event', such as the issuance of stock options.

@@ Line 145: / Line 145: @@
 *By conducting transactions on the underlying structure through the online interface the structure can be automatically updated. (Note that in order to conduct a transaction on the capital structure, the components of the capital structure relevent to the transation must be up to date. Thus transactions can act to validate the underlying structure data.) '''A full history of every transaction ever conducted is maintained throughout the firm's lifetime.'''
-*Firms may conduct transactions related to:
+Firms may conduct transactions related to:
-**Stock
+*Stock
-**Options
+*Options
-**Warrants
+*Warrants
-**Convertible Promisory Notes (CPN)
+*Convertible Promisory Notes (CPN)
-**SPN
+*SPN
-**Rollbacks
+*Rollbacks
 Transactions might include:

@@ Line 127: / Line 127: @@
 The CapMx data is a electronic collection of firms' capital tables. In theory it contains the fully detailed capital structure for each firm in the database. The bank works with various law firms, including [http://www.orrick.com/ Orrick] and [http://www.gunder.com/ Gunderson], who 'stored' this data in Excel sheets, as well as venture capital funds and the companies themselves (who 'stored' this data on paper). The bank responded to this situation by creating and maintaining the CapMx database, to store the data on behalf of their various clients, and to facilitate various transactions on this data.
-You can fill out a [http://www.svb.com/Products-and-Services/SVB-Analytics/capmx-demo-equity-tracking/ form to view a demo] of the [http://www.eprosper.com/ online interface] into the CapMX data (though I had problems playing with it [EJE]). This online interface provides users with access to their data, and allows the users to conduct a limited number (and range) of transactions on it.
+You can fill out a [http://www.svb.com/Products-and-Services/SVB-Analytics/capmx-demo-equity-tracking/ form to view a demo] of the [http://www.eprosper.com/ online interface] into the CapMX data. This online interface provides users with access to their data, and allows the users to conduct a limited number (and range) of transactions on it.
-The database can accomodate data on the the authorized capital of the firm, individuals/entities associated with this capital, and details on the firm itself. However, there is little to no incentive for the firms or representatives of the firms to fill out any data beyond that which is required to record the capital structure at a particular moment in time.
+The database can accomodate data on the the authorized capital of the firm, all transactions performed on this capital, individuals/entities associated with this capital and/or these transactions, and details on the firm itself. However, there is little to no incentive for the firms or representatives of the firms to fill out any data beyond that which is required to record and use the capital structure at a particular moment in time.
 The original capital structure of the firm is inputted by staff at SVB. There is an 'upload template' to guide the staff in this process, and data is sourced from the certificate of incorporation (or certificate of authorization for later issues). However, the input suffers from a number of issues:
@@ Line 137: / Line 137: @@
 *Preferences may not reflect the most recent series
 *Preferences are often recorded as a static value (taken from the certificate)
-*Likewise, the conversion ratio is often recorded as a number, rather than an formula (1:1 conversions are less problematic)
+*Likewise, the conversion ratio is recorded as a number, rather than an formula (1:1 conversions are less problematic)
 *There may be issues with the recording of preference priorities, participation, and payment-in-kind clauses
 *It would be highly problematic to record capital structures for firms organized as LLCs or LPs (or anything other than a C-CORP or S-CORP).
@@ Line 143: / Line 143: @@
 Records are updated in two ways:
 *At every financing round the bank updates the underlying capital structure
-*In order to conduct a transaction on this data, the data must be up to date. Firms may conduct transactions related to:
+*By conducting transactions on the underlying structure through the online interface the structure can be automatically updated. (Note that in order to conduct a transaction on the capital structure, the components of the capital structure relevent to the transation must be up to date. Thus transactions can act to validate the underlying structure data.) '''A full history of every transaction ever conducted is maintained throughout the firm's lifetime.'''
 **Stock
 **Options
 **Warrants

← Older revision		Revision as of 20:29, 1 March 2011
Line 140:		Line 140:
	*There may be issues with the recording of preference priorities, participation, and payment-in-kind clauses		*There may be issues with the recording of preference priorities, participation, and payment-in-kind clauses
	*It would be highly problematic to record capital structures for firms organized as LLCs or LPs (or anything other than a C-CORP or S-CORP).		*It would be highly problematic to record capital structures for firms organized as LLCs or LPs (or anything other than a C-CORP or S-CORP).
		+
		+	Records are updated in two ways:
		+	*At every financing round the bank updates the underlying capital structure
		+	*In order to conduct a transaction on this data, the data must be up to date. Firms may conduct transactions related to:
		+	**Stock
		+	**Options
		+	**Convertible Notes
		+	**Warrants

← Older revision		Revision as of 20:20, 1 March 2011
Line 127:		Line 127:
	The CapMx data is a electronic collection of firms' capital tables. In theory it contains the fully detailed capital structure for each firm in the database. The bank works with various law firms, including [http://www.orrick.com/ Orrick] and [http://www.gunder.com/ Gunderson], who 'stored' this data in Excel sheets, as well as venture capital funds and the companies themselves (who 'stored' this data on paper). The bank responded to this situation by creating and maintaining the CapMx database, to store the data on behalf of their various clients, and to facilitate various transactions on this data.		The CapMx data is a electronic collection of firms' capital tables. In theory it contains the fully detailed capital structure for each firm in the database. The bank works with various law firms, including [http://www.orrick.com/ Orrick] and [http://www.gunder.com/ Gunderson], who 'stored' this data in Excel sheets, as well as venture capital funds and the companies themselves (who 'stored' this data on paper). The bank responded to this situation by creating and maintaining the CapMx database, to store the data on behalf of their various clients, and to facilitate various transactions on this data.

−	You can fill out a [http://www.svb.com/Products-and-Services/SVB-Analytics/capmx-demo-equity-tracking/ form to view a demo] of the [http://www.eprosper.com/ online interface] into the CapMX data (though I had problems playing with it [EJE]).	+	You can fill out a [http://www.svb.com/Products-and-Services/SVB-Analytics/capmx-demo-equity-tracking/ form to view a demo] of the [http://www.eprosper.com/ online interface] into the CapMX data (though I had problems playing with it [EJE]). This online interface provides users with access to their data, and allows the users to conduct a limited number (and range) of transactions on it.
		+
		+	The database can accomodate data on the the authorized capital of the firm, individuals/entities associated with this capital, and details on the firm itself. However, there is little to no incentive for the firms or representatives of the firms to fill out any data beyond that which is required to record the capital structure at a particular moment in time.
		+
		+	The original capital structure of the firm is inputted by staff at SVB. There is an 'upload template' to guide the staff in this process, and data is sourced from the certificate of incorporation (or certificate of authorization for later issues). However, the input suffers from a number of issues:
		+	*There is free text input for the class of stock, so that COMMON, Common, COM, Common1, etc, are all possible ways of recording a Common Stock entry.
		+	*It is not possible to close out a series of stock
		+	*There is no standardization on the naming of series (SERIES A, etc), and in the case of recapitalizations or reorganizations it is possible to have two series named say SERIES A and SERIES 1.
		+	*Preferences may not reflect the most recent series
		+	*Preferences are often recorded as a static value (taken from the certificate)
		+	*Likewise, the conversion ratio is often recorded as a number, rather than an formula (1:1 conversions are less problematic)
		+	*There may be issues with the recording of preference priorities, participation, and payment-in-kind clauses
		+	*It would be highly problematic to record capital structures for firms organized as LLCs or LPs (or anything other than a C-CORP or S-CORP).