| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Co | Initial Investment | At valuation | Ownership | Follow-on investment | Total investment | Exit type | Exit value | Ownership at exit | Value to investor | Return ratio | ||
2 | Co 1 | $1,000,000 | $10,000,000 | 10.00% | $1,000,000 | $2,000,000 | Aqui-hire | $22,000,000 | 10.00% | $2,200,000 | 1.1x | ||
3 | Co 2 | $1,000,000 | $11,000,000 | 9.09% | $1,000,000 | $2,000,000 | Insolvency | $0 | $0 | ||||
4 | Co 3 | $1,000,000 | $9,000,000 | 11.11% | $0 | $1,000,000 | Insolvency | $0 | $0 | ||||
5 | Co 4 | $1,000,000 | $12,000,000 | 8.33% | $1,000,000 | $2,000,000 | Insolvency | $0 | $0 | ||||
6 | Co 5 | $1,000,000 | $15,500,000 | 6.45% | $0 | $1,000,000 | Insolvency | $0 | $0 | ||||
7 | Co 6 | $1,000,000 | $7,500,000 | 13.33% | $1,000,000 | $2,000,000 | Aqui-hire | $11,000,000 | 9.00% | $990,000 | .5x | ||
8 | Co 7 | $1,000,000 | $9,000,000 | 11.11% | $1,000,000 | $2,000,000 | Aqui-hire | $4,000,000 | 11.00% | $440,000 | .2x | ||
9 | Co 8 | $1,000,000 | $10,000,000 | 10.00% | $1,000,000 | $2,000,000 | Aquisition | $50,000,000 | 7.00% | $3,500,000 | 1.8x | ||
10 | Co 9 | $1,000,000 | $11,000,000 | 9.09% | $0 | $1,000,000 | Insolvency | $0 | $0 | ||||
11 | Co 10 | $1,000,000 | $9,000,000 | 11.11% | $3,000,000 | $4,000,000 | IPO | $1,200,000,000 | 7.00% | $84,000,000 | 21.x | ||
12 | Co 11 | $1,000,000 | $7,500,000 | 13.33% | $760,000 | $1,760,000 | Aquisition | $40,000,000 | 9.00% | $3,600,000 | 2.x | ||
13 | Co 12 | $1,000,000 | $9,000,000 | 11.11% | $1,000,000 | $2,000,000 | Aqui-hire | $12,000,000 | 10.00% | $1,200,000 | .6x | ||
14 | Co 13 | $1,000,000 | $10,000,000 | 10.00% | $1,000,000 | $2,000,000 | Insolvency | $0 | $0 | ||||
15 | Co 14 | $1,000,000 | $11,000,000 | 9.09% | $1,000,000 | $2,000,000 | Insolvency | $0 | $0 | ||||
16 | Co 15 | $1,000,000 | $7,500,000 | 13.33% | $1,000,000 | $2,000,000 | Aquisition | $35,000,000 | 10.00% | $3,500,000 | 1.8x | ||
17 | |||||||||||||
18 | Totals | $28,760,000 | $99,430,000 | 3.5x | |||||||||
19 | |||||||||||||
20 |