Venture Capital Operating System, or VCOS is a simple, easy-to-use, but comprehensive database for small-size venture capital firms to keep track of deal flows and investments. There are four main tables;
Deals databaseStep 1 Add a company to the table.
Step 2 Add key people to the table. You can associate a person to a company or multiple companies (for example, Steve Jobs is associated with Apple and Pixar)
Step 3 Add a deal to the table. Note that Deal Name is NOT a company name - Make the deal name more descriptive by reflecting the character of the deal. For example, Apple Seed (1977) or Tesla Series A, because there can be multiple deals or investments to a single company.
Set Deal Status to Deal lead, Under review, Invested, or Rejected, accordingly.
Step 4 When investment is complete, go to database and add an entry of the investment. Note that this table does NOT reference to table - You manually create an investment record because the deal entry may not accurately describe investment amount, etc.
Investment tracker is a database to record and view your investments and fund performance. When creating an investment record, fill out these fields;
| Field name | Data type | Meaning or what to enter |
|---|---|---|
Tracker ID |
Number (Integer) | Auto-generated unique ID of the investment entry |
Deal Record |
Relation to Deals table |
Select the deal record from the Deals table |
Company |
Rollup to the Company field in the Deals table | Auto-generated Company name from looking up Deals entry from the Deal record field |
Investment Date |
Date | The date of investment. Defaults to the created date, but you can modify the value to the correct investment date |
Fund |
List | Select the fund of the investment. If you made investment from multiple fund sources, create multiple investment records by each fund. |
| You can create new fund by entering the name of the fund. | ||
# of shares purchased |
Number (Integer) | The number of shares you purchased. If it’s non-equity investment such as SAFE or Convertible Note, enter 1 or number of each certificates of bonds. |
PPS |
Number (2-digit float) | Purchase price per share. If it’s non-equity investment such as SAFE or Convertible Note, enter the value of total investment. |
Investment Amount |
Number (Integer) | Calculated (Auto-generated) field by multiplying # of shares and PPS |
Investment Type |
List | Select type of investment such as Common, RCPS, CN, SAFE, etc. |
| You can also create new type by entering name of the type. | ||
% ownership |
Number (2-digit float %) | % of ownership from the investment made |
Realized Return |
Number (2-digit float) | The dollar amount you earned by exiting (selling) your investment. |
Current # of shares |
Number (Integer) | The current number of shares you own, as if converted with considerations of anti-dilution clause, any refixings, etc. |
Current price per share |
Number (2-digit float) | Current price per share |
Current Value |
Number (Integer) | Calculated (Auto-generated) field by multiplying Current # of shares and Current price per share |
Current % ownership |
Number (2-digit float %) | Current % of ownership |
MOIC |
Number (%) | Multiple on Invested Capital. This is the % number on how much your investment returns based on the (Current Value + Realized Return) divided by the initial Investment Amount. |
In Charge |
Person | Select team member of the investment. Default value is set to the person who created this record, but you can change to other person who is responsible of the investment. |
After creating investment records, you can view list of the investments from different views of the database.
| View name | Description |
|---|---|
| Investment | List of all investments |
| Performance | Easily monitor returns and residual values of investments |
| By Portfolio | Filter by each portfolio, details of each investments of the portfolio company |
| By Fund | Select funds of interest in the filter option to view investments of the fund or funds. |