Brad Feld's fixes for Crashdev's Super-Simplistic Seed Fund Math Toy

Still loading...

	A	B
1	Initial Fund Size	10,000,000
2
3	# Investments	40
4	Avg Initial Investment	250,000
5	Avg Initial Pre-Money Valuation	3,500,000
6	Avg Round Size	500,000
7	Avg Initial Ownership %	6.25%
8	Follow-on Reserve Ratio	0.00
9	Avg Follow-on Investment	0
10	Total $ Invested / Exit	250,000
11	Dilution Factor	25%
12	Avg Ownership % at Exit	4.69%
13
14	Target Fund Return Multiple
15	3	30,000,000
16	4	40,000,000
17	5	50,000,000
18
19	Outcome Distribution %
20	Losers	33%
21	Money Back	33%
22	Winners	33%
23
24	# of Outcomes
25	Losers	13
26	Money Back	13
27	Winners	13
28
29	Total $ Returns by Outcome
30	Losers	0
31	Money Back	3,250,000
32	Winners (backsolved from Target Fund Multiple)
33	3	26,750,000
34	4	36,750,000
35	5	46,750,000
36
37	Implied Total Winners Exit Value by Target Multiple
38	3	570,666,667
39	4	784,000,000
40	5	997,333,333
41
42	Implied Avg Exit Value per Winner by Target Multiple
43	3	43,897,436
44	4	60,307,692
45	5	76,717,949
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100