| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||||||||||
2 | Year | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | cumulative rise | ||||||
3 | Treasury Details | Feb 7, 2022 | |||||||||||||||||||||
4 | Current treasury in wETH | 1,679 | Average price of ETH 2021: | ||||||||||||||||||||
5 | Current price of ETH | $ 3,012 | 2775 | ||||||||||||||||||||
6 | Current treasury value | $ 5,057,148 | |||||||||||||||||||||
7 | Spent this year to date* | 208 | |||||||||||||||||||||
8 | *does not account for ragequits not due to grants | ||||||||||||||||||||||
9 | *does not account for grants from prior years ragequitting in 2021 | ||||||||||||||||||||||
10 | |||||||||||||||||||||||
17 | |||||||||||||||||||||||
18 | SCENARIOS: Increase in Avg ETH price per year | ||||||||||||||||||||||
19 | 0% | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | $2,775 | 0% | ||||||
20 | 5% | $2,775 | $2,914 | $3,060 | $3,213 | $3,373 | $3,542 | $3,719 | $3,905 | $4,100 | $4,305 | $4,520 | $4,746 | $4,984 | $5,233 | $5,495 | 98% | ||||||
21 | 10% | $2,775 | $3,053 | $3,358 | $3,694 | $4,063 | $4,469 | $4,916 | $5,408 | $5,949 | $6,544 | $7,198 | $7,918 | $8,710 | $9,581 | $10,539 | 280% | ||||||
22 | 20% | $2,775 | $3,330 | $3,996 | $4,795 | $5,755 | $6,905 | $8,286 | $9,944 | $11,933 | $14,319 | $17,183 | $20,619 | $24,743 | $29,692 | $35,630 | 1184% | ||||||
23 | 25% | $2,775 | $3,469 | $4,336 | $5,420 | $6,775 | $8,469 | $10,586 | $13,233 | $16,541 | $20,676 | $25,845 | $32,307 | $40,383 | $50,479 | $63,099 | 2174% | ||||||
24 | 30% | $2,775 | $3,608 | $4,690 | $6,097 | $7,926 | $10,304 | $13,395 | $17,414 | $22,638 | $29,429 | $38,258 | $49,735 | $64,655 | $84,052 | $109,267 | 3837% | ||||||
31 | |||||||||||||||||||||||
32 | Coin Price Forecast | (Year-end estimate) | $3,000 | $2,635 | $4,031 | $4,844 | $6,062 | $5,863 | $5,986 | $6,811 | $7,626 | $8,342 | $8,592 | $8,850 | $9,116 | $9,298 | $9,484 | 216% | |||||
33 | -12% | 53% | 20% | 25% | -3% | 2% | 14% | 12% | 9% | 3% | 3% | 3% | 2% | 2% | |||||||||
34 | |||||||||||||||||||||||
35 | LiteFinance Forecast | $ 2,775 | $ 3,076 | $ 4,447 | $ 5,940 | $ 6,594 | $ 7,664 | $ 8,583 | $ 9,485 | $ 10,265 | $ 11,248 | $ 11,585 | 11,933 | 12,291 | 12,537 | 12,788 | 361% | ||||||
36 | 11% | 45% | 34% | 11% | 16% | 12% | 11% | 8% | 10% | 3% | 3% | 3% | 2% | 2% | |||||||||
43 | SCENARIOS: Annual grant spending (conservative rise) | ||||||||||||||||||||||
44 | 1 | NO RISE IN ETH - FLAT GRANTS GIVEN ANNUALLY | treasury | 1,679 | 1,479 | 1,279 | 1,079 | 879 | 679 | 479 | 279 | 79 | |||||||||||
45 | ETH Price is flat AND | eth price | $ 2,775 | $ 2,775 | $ 2,775 | $ 2,775 | $ 2,775 | $ 2,775 | $ 2,775 | $ 2,775 | $ 2,775 | ||||||||||||
46 | ETH spent annually on grants is also flat | 0% | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 79 | ||||||||||||
47 | $ 555,026 | $ 555,026 | $ 555,026 | $ 555,026 | $ 555,026 | $ 555,026 | $ 555,026 | $ 555,026 | $ 219,235 | ||||||||||||||
48 | Grant admin as a % of total eth given for year | 10% | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 7.9 | ||||||||||||
49 | RBG operational budget in $ (based on est price of ETH) | $ 55,503 | $ 55,503 | $ 55,503 | $ 55,503 | $ 55,503 | $ 55,503 | $ 55,503 | $ 55,503 | $ 21,924 | |||||||||||||
50 | Conclusion: | ||||||||||||||||||||||
51 | This is a baseline | ||||||||||||||||||||||
52 | Fund runs out in 2029 | ||||||||||||||||||||||
53 | |||||||||||||||||||||||
54 | 2 | ETH RISES 10% PER YEAR - FLAT GRANTS | treasury | $ 1,679 | 1,479 | 1,279 | 1,079 | 879 | 679 | 479 | 279 | 79 | |||||||||||
55 | ETH Price rises 10% on average | 10% | $ 2,775 | $ 3,053 | $ 3,358 | $ 3,694 | $ 4,063 | $ 4,469 | $ 4,916 | $ 5,408 | $ 5,949 | ||||||||||||
56 | ETH spent annually on grants is flat | 0% | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 79 | ||||||||||||
57 | Value of grants per year | $ 555,026 | $ 610,529 | $ 671,582 | $ 738,740 | $ 812,614 | $ 893,875 | $ 983,263 | $ 1,081,589 | $ 469,951 | |||||||||||||
58 | Grant admin as a % of total eth given for year | 10% | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 7.9 | ||||||||||||
59 | RBG operational budget in $ (based on est price of ETH) | $ 55,503 | $ 61,053 | $ 67,158 | $ 73,874 | $ 81,261 | $ 89,388 | $ 98,326 | $ 108,159 | $ 46,995 | |||||||||||||
60 | Conclusion: | ||||||||||||||||||||||
61 | Impact in $ rises steadily and peaks in 2028, ends in 2029 | ||||||||||||||||||||||
62 | If ETH price rises, it is easier to fund raise now | ||||||||||||||||||||||
63 | |||||||||||||||||||||||
64 | 3 | ETH RISES NON-LINEAR 1 - FLAT GRANTS | treasury | $ 1,679 | 1,479 | 1,279 | 1,079 | 879 | 679 | 479 | 279 | 79 | |||||||||||
65 | ETH Price rises according to CoinPrice predictions | Variable | $ 3,000 | $ 2,635 | $ 4,031 | $ 4,844 | $ 6,062 | $ 5,863 | $ 5,986 | $ 6,811 | $ 7,626 | ||||||||||||
66 | ETH spent annually on grants is flat | 0% | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 79 | ||||||||||||
67 | Value of grants per year | $ 600,000 | $ 527,000 | $ 806,200 | $ 968,800 | $ 1,212,400 | $ 1,172,600 | $ 1,197,200 | $ 1,362,200 | $ 602,454 | |||||||||||||
68 | Grant admin as a % of total eth given for year | 10% | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 7.9 | ||||||||||||
69 | RBG operational budget in $ (based on est price of ETH) | $ 60,000 | $ 52,700 | $ 80,620 | $ 96,880 | $ 121,240 | $ 117,260 | $ 119,720 | $ 136,220 | $ 60,245 | |||||||||||||
70 | Conclusion: | ||||||||||||||||||||||
71 | Impact in $ rises steadily and peaks in 2028 | ||||||||||||||||||||||
72 | If ETH price rises, it is easier to fund raise now | ||||||||||||||||||||||
73 | Grant ops budget rises in $ for managing the same amount of grants | ||||||||||||||||||||||
74 | |||||||||||||||||||||||
75 | 4 | ETH RISES NON-LINEAR 2 - FLAT GRANTS | treasury | $ 1,679 | 1,479 | 1,279 | 1,079 | 879 | 679 | 479 | 279 | 79 | |||||||||||
76 | ETH Price rises according to LiteFinance predictions | Variable | $ 2,775 | $ 3,076 | $ 4,447 | $ 5,940 | $ 6,594 | $ 7,664 | $ 8,583 | $ 9,485 | $ 10,265 | ||||||||||||
77 | ETH spent annually on grants is flat | 0% | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 79 | ||||||||||||
78 | Value of grants per year | $ 555,026 | $ 615,204 | $ 889,303 | $ 1,187,938 | $ 1,318,872 | $ 1,532,719 | $ 1,716,552 | $ 1,897,009 | $ 810,966 | |||||||||||||
79 | Grant admin as a % of total eth given for year | 10% | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 7.9 | ||||||||||||
80 | RBG operational budget in $ (based on est price of ETH) | $ 55,503 | $ 61,520 | $ 88,930 | $ 118,794 | $ 131,887 | $ 153,272 | $ 171,655 | $ 189,701 | $ 81,097 | |||||||||||||
81 | Conclusion: | ||||||||||||||||||||||
82 | Impact in $ rises steadily and peaks in 2028 | ||||||||||||||||||||||
83 | If ETH price rises, it is easier to fund raise now | ||||||||||||||||||||||
84 | |||||||||||||||||||||||
85 | 5 | Extend the fund - distribute less ETH to offset rise in price | treasury | $ 1,679 | 1,479 | 1,289 | 1,109 | 937 | 774 | 619 | 472 | 333 | 200 | 74 | |||||||||
86 | ETH price rise | 10% | $ 2,775 | $ 3,053 | $ 3,358 | $ 3,694 | $ 4,063 | $ 4,469 | $ 4,916 | $ 5,408 | $ 5,949 | $ 6,544 | $ 7,198 | ||||||||||
87 | Reduction in ETH given per year to offset rise in price | -0.05 | 200 | 190 | 180.5 | 171.5 | 162.9 | 154.8 | 147.0 | 139.7 | 132.7 | 126.0 | 73.9 | ||||||||||
88 | Value of grants per year | $ 555,026 | $ 580,003 | $ 606,103 | $ 633,377 | $ 661,879 | $ 691,664 | $ 722,789 | $ 755,314 | $ 789,303 | $ 824,822 | $ 532,274 | |||||||||||
89 | Grant admin as a % of total eth given for year | 10% | 20 | 19 | 18.1 | 17.1 | 16.3 | 15.5 | 14.7 | 14.0 | 13.3 | 12.6 | 7.4 | ||||||||||
90 | RBG operational budget in $ | $ 55,503 | $ 58,000 | $ 60,610 | $ 63,338 | $ 66,188 | $ 69,166 | $ 72,279 | $ 75,531 | $ 78,930 | $ 82,482 | $ 53,227 | |||||||||||
91 | Conclusion: | ||||||||||||||||||||||
92 | Fund runs out in 2031 | ||||||||||||||||||||||
93 | |||||||||||||||||||||||
94 | 6 | Extend the fund - distribute less ETH to offset rise in price | treasury | $ 1,679 | 1,479 | 1,295 | 1,126 | 970 | 827 | 695 | 574 | 462 | 359 | 265 | 178 | 98 | 25 | ||||||
95 | ETH price rise | 10% | $ 2,775 | $ 3,053 | $ 3,358 | $ 3,694 | $ 4,063 | $ 4,469 | $ 4,916 | $ 5,408 | $ 5,949 | $ 6,544 | $ 7,198 | 7,918 | 8,710 | 9,581 | |||||||
96 | Reduction in grants given | -0.08 | 200.0 | 184.0 | 169.3 | 155.7 | 143.3 | 131.8 | 121.3 | 111.6 | 102.6 | 94.4 | 86.9 | 80 | 74 | 25 | |||||||
97 | Value of grants per year | $ 555,026 | $ 561,687 | $ 568,427 | $ 575,248 | $ 582,151 | $ 589,137 | $ 596,206 | $ 603,361 | $ 610,601 | $ 617,928 | $ 625,344 | 632,848 | 640,442 | 235,994 | ||||||||
98 | Grant admin as a % of total eth given for year | 10% | 20 | 18.4 | 16.9 | 15.6 | 14.3 | 13.2 | 12.1 | 11.2 | 10.3 | 9.4 | 8.7 | 8.0 | 7.4 | 2.5 | |||||||
99 | RBG operational budget in $ | $ 55,503 | $ 56,169 | $ 56,843 | $ 57,525 | $ 58,215 | $ 58,914 | $ 59,621 | $ 60,336 | $ 61,060 | $ 61,793 | $ 62,534 | 63,285 | 64,044 | 23,599 | ||||||||
100 | Conclusion: | ||||||||||||||||||||||
101 | Fund runs out in 2034 | ||||||||||||||||||||||
102 | |||||||||||||||||||||||
103 | 7 | Extend the fund - distribute less ETH to offset rise in price | treasury | $ 1,679 | 1,479 | 1,297 | 1,131 | 981 | 844 | 719 | 605 | 502 | 408 | 322 | 244 | 173 | 109 | 50 | |||||
104 | ETH price rise | 10% | $ 2,775 | $ 3,053 | $ 3,358 | $ 3,694 | $ 4,063 | $ 4,469 | $ 4,916 | $ 5,408 | $ 5,949 | $ 6,544 | $ 7,198 | 7,918 | 8,710 | 9,581 | 10,539 | ||||||
105 | Reduction in grants | -0.09 | 200.0 | 182 | 166 | 151 | 137 | 125 | 114 | 103 | 94 | 86 | 78 | 71 | 64 | 59 | 50 | ||||||
106 | Value of grants per year | $ 555,026 | $ 555,581 | $ 556,137 | $ 556,693 | $ 557,250 | $ 557,807 | $ 558,365 | $ 558,923 | $ 559,482 | $ 560,042 | $ 560,602 | 561,162 | 561,723 | 562,285 | 529,081 | |||||||
107 | Grant admin as a % of total eth given for year | 10% | 20 | 18.2 | 16.6 | 15.1 | 13.7 | 12.5 | 11.4 | 10.3 | 9.4 | 8.6 | 7.8 | 7 | 6 | 6 | 5 | ||||||
108 | RBG operational budget in $ | $ 55,503 | $ 55,558 | $ 55,614 | $ 55,669 | $ 55,725 | $ 55,781 | $ 55,836 | $ 55,892 | $ 55,948 | $ 56,004 | $ 56,060 | 56,116 | 56,172 | 56,229 | 52,908 | |||||||
109 | Conclusion: | ||||||||||||||||||||||
110 | Fund runs out in 2035 | ||||||||||||||||||||||
111 | |||||||||||||||||||||||
112 | SCENARIOS: Annual grant spending (optimistic rise) | ||||||||||||||||||||||
113 | 8 | Extend the fund - distribute less ETH to offset rise in price | treasury | $ 1,679 | 1,479 | 1,289 | 1,109 | 937 | 774 | 619 | 472 | 333 | 200 | 74 | |||||||||
114 | ETH price rise | 20% | $ 2,775 | $ 3,330 | $ 3,996 | $ 4,795 | $ 5,755 | $ 6,905 | $ 8,286 | $ 9,944 | $ 11,933 | $ 14,319 | $ 17,183 | ||||||||||
115 | Reduction in grants | -0.05 | 200 | 190 | 181 | 171 | 163 | 155 | 147 | 140 | 133 | 126 | 74 | ||||||||||
116 | $ 555,026 | $ 632,730 | $ 721,312 | $ 822,296 | $ 937,417 | $ 1,068,656 | $ 1,218,268 | $ 1,388,825 | $ 1,583,261 | $ 1,804,917 | $ 1,270,636 | ||||||||||||
117 | Grant admin as a % of total eth given for year | 10% | 20 | 19 | 18.1 | 17.1 | 16.3 | 15.5 | 14.7 | 14.0 | 13.3 | 12.6 | 7.4 | ||||||||||
118 | RBG operational budget in $ | $ 55,503 | $ 63,273 | $ 72,131 | $ 82,230 | $ 93,742 | $ 106,866 | $ 121,827 | $ 138,883 | $ 158,326 | $ 180,492 | $ 127,064 |