EdgeWare model tonysheng
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
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
TypeDate range
Contributions (ETH)
WeightDate bonus
Weighted contributions
ShareEDGEDG priceETH priceROI
ROI annualized
6
Lock36/16 - 6/3011.001.4310.0%1,504$0.03$30014.04%56.17%
7
Lock66/16 - 6/3011.301.4320.0%1,956$0.03$30018.25%36.51%
8
Signal7/31 - 8/1410.201.0000.0%211$0.03$3001.97%N/A
9
10
Supply estimation
11
TypeDate range
Contributions (ETH)
WeightDate bonus
Weighted contributions
ShareEDGEDG priceETH priceROI
ROI annualized
12
Signal6/1 - 6/26647,1690.201.00129,4343.0%136,648,175$0.03$3001.97%N/A
13
Lock36/1 - 6/26407,2321.001.43580,30613.6%612,650,644$0.03$30014.04%56.17%
14
Lock66/1 - 6/2697,2041.301.43180,0704.2%190,107,165$0.03$30018.25%36.51%
15
Lock126/1 - 6/26385,6792.201.431,209,10428.4%1,276,496,623$0.03$30030.89%30.89%
16
Lock3Frozen parity funds513,7741.001.00513,77412.1%542,410,709$0.03$3009.85%39.41%
17
Signal6/27 - 8/31647,1690.201.00129,4343.0%136,648,175$0.03$3001.97%N/A
18
Lock36/27 - 8/31407,2321.001.10447,95510.5%472,923,304$0.03$30010.84%43.36%
19
Lock66/27 - 8/3197,2041.301.10139,0023.3%146,749,391$0.03$30014.09%28.18%
20
Lock126/27 - 8/31385,6792.201.10933,34321.9%985,365,815$0.03$30023.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
Loading...