EdgeWare model tonysheng

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	I recommend making a duplicate of this model and doing whatever you want to it. Feel free to email/ DM me with questions/ suggestions.
2	Last updated 6/27/19 9:45AM PST
3
4		ROI calculator <-- input your values in columns B and C to estimate ROI
5		Type	Date range	Contributions (ETH)	Weight	Date bonus	Weighted contributions	Share	EDG	EDG price	ETH price	ROI	ROI annualized
6		Lock3	6/16 - 6/30	1	1.00	1.43	1	0.0%	1,504	$0.03	$300	14.04%	56.17%
7		Lock6	6/16 - 6/30	1	1.30	1.43	2	0.0%	1,956	$0.03	$300	18.25%	36.51%
8		Signal	7/31 - 8/14	1	0.20	1.00	0	0.0%	211	$0.03	$300	1.97%	N/A
9
10		Supply estimation
11		Type	Date range	Contributions (ETH)	Weight	Date bonus	Weighted contributions	Share	EDG	EDG price	ETH price	ROI	ROI annualized
12		Signal	6/1 - 6/26	647,169	0.20	1.00	129,434	3.0%	136,648,175	$0.03	$300	1.97%	N/A
13		Lock3	6/1 - 6/26	407,232	1.00	1.43	580,306	13.6%	612,650,644	$0.03	$300	14.04%	56.17%
14		Lock6	6/1 - 6/26	97,204	1.30	1.43	180,070	4.2%	190,107,165	$0.03	$300	18.25%	36.51%
15		Lock12	6/1 - 6/26	385,679	2.20	1.43	1,209,104	28.4%	1,276,496,623	$0.03	$300	30.89%	30.89%
16		Lock3	Frozen parity funds	513,774	1.00	1.00	513,774	12.1%	542,410,709	$0.03	$300	9.85%	39.41%
17		Signal	6/27 - 8/31	647,169	0.20	1.00	129,434	3.0%	136,648,175	$0.03	$300	1.97%	N/A
18		Lock3	6/27 - 8/31	407,232	1.00	1.10	447,955	10.5%	472,923,304	$0.03	$300	10.84%	43.36%
19		Lock6	6/27 - 8/31	97,204	1.30	1.10	139,002	3.3%	146,749,391	$0.03	$300	14.09%	28.18%
20		Lock12	6/27 - 8/31	385,679	2.20	1.10	933,343	21.9%	985,365,815	$0.03	$300	23.85%	23.85%
21
22		Inputs
23		Remaining contributions	1,537,284	<-- this assumption I am least certain about. Currently assuming 50% of total contributions remain (excludes frozen funds). Don't know how accurate that is.
24		EDG price	$0.028
25		ETH price	$300
26
27		Assumptions
28	1	Data pulled 6/27 from https://commonwealth.im/#!/stats/edgeware
29	2	Equal split between date-bonuses to-date
30	3	EDG price same as last VC round (to be verified, assumes $100M market cap)
31	4	Future contibutions equal contributions to-date
32	5	Future contributions split 50/50 between signal and lock; within lock split equally by type
33	6	Assumes 513,774 ETH from frozen funds (100%) will/ have been signalled (and will convert into 3mo locks w/ no date bonus)
34
35
36
37
38
39
40
41
42
43
44
45
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