ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Current Price of Divi
0
Copper = 20 tickets
BlocksHoursTimes per day
# of coins participating in lottery
325,000.00Chance to winPrize in coinsUSDAnnual chance
Launch was on: Thu, Sep 27, 2018. 100th block at 2:18pm EST.
2
Circulating supply
48,000,000978,758,000.88
Silver = 63 tickets
Frequency of winning for Copper
#DIV/0!#DIV/0!#DIV/0!
Chance to Win 1st Prize Lottery Reward
1.16%252,000.00$25,200.0060.52%
3
Total supply48,000,00048,000,000.00
Gold = 220 tickets
Frequency of winning for Silver
#DIV/0!#DIV/0!#DIV/0!
Assumed Chance to Win 1st Prize Lottery Reward
cannot calculate252,000.00$25,200.00#VALUE!
Coins Reserved for Lottery Blocks
#DIV/0!
4
Future/Assumed Price of Divi
$0.1000
Platinum = 690 tickets
Frequency of winning for Gold
#DIV/0!#DIV/0!#DIV/0!
*Theoretical assumption; Does not take into account coin age, number of stakes won or UTXO size.
Reward distribution
CurrentAssumed
5
Copper chance to win each block
#DIV/0!
Diamond = 2400 tickets
Frequency of winning for Platinum
#DIV/0!#DIV/0!#DIV/0!
Chance to Win 2nd Prize Lottery Reward
11.61%25,200.00$2,520.00605.23%
Development & Marketing
9.00%9.00%
6
Silver chance to win each block
#DIV/0!Block number291,372
Frequency of winning for Diamond
#DIV/0!#DIV/0!#DIV/0!
Assumed Chance to Win 2nd Prize Lottery Reward
cannot calculate25,200.00$2,520.00#VALUE!
Exchanges & Platform Rewards
7.00%7.00%
7
Gold chance to win each block
#DIV/0!
Masternode eligible for rewards
0.00
hours after deployment.
Masternode45.00%45.00%
8
Platinum chance to win each block
#DIV/0!
Feel free to play around and change the assumed figures(red font) and only them! If others are using the sheet at the same time create your own copy or contact me on Telegram @oriz123 to obtain your own free copy.
Staking38.00%38.00%
9
Diamond chance to win each block
#DIV/0!Charity1.00%1.00%
10
Total tickets between all masternodes
0.00Full Year52.143Yearly/Maximum Rewards#DIV/0!Weekly Rewards#DIV/0!
Total Masternode Value
Percent Of total coin supply EOY
100.00%
11
Block number291,372
Weeks Invested out of the year
52% Return#DIV/0!#DIV/0!Reward in coinsReward in USDReward in coinsReward in USDReward in coinsReward in USDValue in CoinsValue in USDPer TierPer Masternode
12
Current number of Copper Masternodes
Current Rewards per Copper Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
Time since 100th block:
13
Assumed number of Copper Masternodes
300
Assumed Rewards per Copper Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Years0
14
Weeks17171360
15
Current number of Silver Masternodes
Current Rewards per Silver Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Days57200
16
Assumed nunber of Silver Masternodes
162
Assumed Rewards per Silver Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Hours11660
17
Minutes4343
18
Current number of Gold Masternodes
Current Rewards per Gold Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
*Will be updated a couple of times per day
179263
19
Assumed number of Gold Masternodes
97
Assumed Rewards per Gold Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
20
Enter # of coins you own:
232,000
21
Current number of Platinum Masternodes
Current Rewards per Platinum Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
% of Total Supply
0.48%
22
Assumed number of Platinum Masternodes
22
Assumed Rewards per Platinum Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
% of Circulating Supply
0.48%
23
24
Current number of Diamond Masternodes
Current Rewards per Diamond Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
25
Assumed number of Diamond Masternodes
15
Assumed Rewards per Diamond Masternode
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
26
1
27
Total number of Masternodes
0
Current Total Collateral held by Masternodes in coins
0
Enter # of coins you are staking
127,000127,000% of Total MN
28
Assumed Total number of Masternodes
596
Assumed Total Collateral held by Masternodes in coins
391,600,000CurrentAssumed
Current Total number of coins held in Diamond Tier
0#DIV/0!
29
Number of coins to be rewarded
-638,961.10#VALUE!Assumed 150,000,00038.30%
30
Development & Marketing
CurrentEnd of Year
Total coins held by stakers
28,000,000
Coins rewarded per 10k coins held
85,597.7185,597.71
31
$3,146,817.60#DIV/0!
Assumed coins held by stakers
error: mn coins higher than supply
Average % Reward per year
-503.12%#VALUE!
Current Total number of coins held in Platinum Tier
0#DIV/0!
32
Assumed$3,146,817.60#DIV/0!
New total balance at end of year
-511,961.10#VALUE!Assumed 66,000,00016.85%
33
Exchanges, Liquidity
CurrentEnd of YearCurrentAssumedReward in USD-$63,896.11#VALUE!
34
& Platform Rewards
$2,447,524.80#DIV/0!
Ratio of masternode coins to staking coins
0#VALUE!Balance in USD-$51,196.11#VALUE!
Current Total number of coins held in Gold Tier
0#DIV/0!
35
Assumed$2,447,524.80#DIV/0!
Ratio of masternode coins to total supply
0.00%815.83%
*Does not consider coin age or coins that are offline
Assumed 97,000,00024.77%
36
Assumed
Ratio of staking coins to total supply
58.33%#VALUE!
Number of times lottery blocks have been rewarded
16
37
Total Coins minted year 1
5,207,153
All Lottery coins awarded thus far
8,064,000
Current Total number of coins held in Silver Tier
0#DIV/0!
38
Assumed coins minted year 1
657,000,000Assumed 48,600,00012.41%
39
0.9907063923Enter price
EOY Total Divi Supply & Market Cap, Current & Assumed conditions
40
Average Block Time in seconds
36.91425394% Inflation$0.0036
Enter Assumed coins minted per year
341,640,000.00EOY Market Cap
Current Total number of coins held in Copper Tier
0#DIV/0!
41
# of blocks till next lottery reward
CurrentAssumedSupplyCurrentAssumed
Or below per each year
Current Conditions
Assumed Assumed 30,000,0007.66%
42
Estimated time till next reward - minutes
00.84%106.46%Year 1622,367,8271,274,160,674657,000,000.00$2,240,524$4,586,978TRUE
43
Estimated time till next reward - hours
0105.85%51.70%Year 21,281,167,8271,932,960,674658,800,000.00$4,612,204$6,958,658TRUE
Combined Masternodes/Staking Profit Calculator
Reward MonthlyUSD
44
Estimeted time till next reward - days
043.08%28.55%Year 31,833,047,8272,484,840,674551,880,000.00$6,598,972$8,945,426TRUE
Enter # of Copper Masternodes
0#DIV/0!#DIV/0!
45
30.11%22.21%Year 42,384,927,8273,036,720,674551,880,000.00$8,585,740$10,932,194TRUE
Enter # of Silver Masternodes
1Reward WeeklyUSD
46
18.73%14.71%Year 52,831,687,8273,483,480,674446,760,000.00$10,194,076$12,540,530TRUE
Enter # of Gold Masternodes
0#DIV/0!#DIV/0!
47
Charity FundCurrentEnd of Year15.82%12.86%Year 63,279,671,8273,931,464,674447,984,000.00$11,806,819$14,153,273TRUE
Enter # of Platinum Masternodes
0Reward DailyUSD
48
$349,646.40#DIV/0!10.42%8.69%Year 73,621,311,8274,273,104,674341,640,000.00$13,036,723$15,383,177TRUE
Enter # of Diamond Masternodes
0#DIV/0!#DIV/0!
49
Assumed$349,646.40#DIV/0!9.43%8.00%Year 83,962,951,8274,614,744,674341,640,000.00$14,266,627$16,613,081TRUEStaking? Yes/No500,000Total RewardsUSD
50
5.97%5.13%Year 94,199,471,8274,851,264,674236,520,000.00$15,118,099$17,464,553TRUE% Coin Supply#DIV/0!Enter # of coins#DIV/0!#DIV/0!
51
Current Dominance
0.00%100.00%5.65%4.89%Year 104,436,639,8275,088,432,674237,168,000.00$15,971,903$18,318,358TRUECurrentstaked aboveTotal ValueUSD
52
Assumed Dominance
#VALUE!#VALUE!2.96%2.58%Year 114,568,039,8275,219,832,674131,400,000.00$16,444,943$18,791,398TRUE
Includes Staking
Showing Assumed
#DIV/0!#DIV/0!
53
MasternodesStakers2.88%2.52%Year 124,699,439,8275,351,232,674131,400,000.00$16,917,983$19,264,438TRUE#DIV/0!
54
2.80%2.46%Year 134,830,839,8275,482,632,674131,400,000.00$17,391,023$19,737,478TRUE#DIV/0!
55
Divi on exchanges
20,000,000.002.73%2.40%Year 144,962,599,8275,614,392,674131,760,000.00$17,865,359$20,211,814TRUE#DIV/0!#DIV/0!
56
As % of total supply
41.67%2.65%2.34%Year 155,093,999,8275,745,792,674131,400,000.00$18,338,399$20,684,854TRUE#DIV/0!#DIV/0!
57
2.58%2.29%Year 165,225,399,8275,877,192,674131,400,000.00$18,811,439$21,157,894TRUE#DIV/0!#DIV/0!
58
Current Market Cap based on price entered in D4
$4,800,0002.51%2.24%Year 175,356,799,8276,008,592,674131,400,000.00$19,284,479$21,630,934TRUE#DIV/0!#DIV/0!
59
2.46%2.19%Year 185,488,559,8276,140,352,674131,760,000.00$19,758,815$22,105,270TRUE#DIV/0!#DIV/0!
60
2.39%2.14%Year 195,619,959,8276,271,752,674131,400,000.00$20,231,855$22,578,310TRUE#DIV/0!
61
2.34%2.10%Year 205,751,359,8276,403,152,674131,400,000.00$20,704,895$23,051,350TRUE#DIV/0!
62
2.28%2.06%Year 215,882,759,8276,534,912,674131,760,000.00$21,177,935$23,525,686TRUE#DIV/0!
63
2.24%2.01%Year 226,014,519,8276,666,312,674131,400,000.00$21,652,271$23,998,726TRUE
64
2.18%1.97%Year 236,145,919,8276,797,712,674131,400,000.00$22,125,311$24,471,766TRUE
65
5402.14%1.93%Year 246,277,319,8276,929,112,674131,400,000.00$22,598,351$24,944,806TRUE
66
4562.09%1.90%Year 256,408,719,8277,060,512,674131,400,000.00$23,071,391$25,417,846TRUE
67
5402.06%1.87%Year 266,540,479,8277,192,272,674131,760,000.00$23,545,727$25,892,182TRUE
68
4562.01%1.83%Year 276,671,879,8277,323,672,674131,400,000.00$24,018,767$26,365,222TRUE
69
201601.97%1.79%Year 286,803,279,8277,455,072,674131,400,000.00$24,491,807$26,838,262TRUE
70
302401.93%1.76%Year 296,934,679,8277,586,472,674131,400,000.00$24,964,847$27,311,302TRUE
71
403201.90%1.74%Year 307,066,439,8277,718,232,674131,760,000.00$25,439,183$27,785,638TRUE
72
504001.86%1.70%Year 317,197,839,8277,849,632,674131,400,000.00$25,912,223$28,258,678TRUE
73
604801.83%1.67%Year 327,329,239,8277,981,032,674131,400,000.00$26,385,263$28,731,718TRUE
74
705601.79%1.65%Year 337,460,639,8278,112,432,674131,400,000.00$26,858,303$29,204,758TRUE
75
806401.77%1.62%Year 347,592,399,8278,244,192,674131,760,000.00$27,332,639$29,679,094TRUE
76
907201.73%1.59%Year 357,723,799,8278,375,592,674131,400,000.00$27,805,679$30,152,134TRUE
77
1008001.70%1.57%Year 367,855,199,8278,506,992,674131,400,000.00$28,278,719$30,625,174TRUE
78
1108801.67%1.54%Year 377,986,599,8278,638,392,674131,400,000.00$28,751,759$31,098,214TRUE
79
1209601.65%1.53%Year 388,118,359,8278,770,152,674131,760,000.00$29,226,095$31,572,550TRUE
80
1310401.62%1.50%Year 398,249,759,8278,901,552,674131,400,000.00$29,699,135$32,045,590TRUE
81
1411201.59%1.48%Year 408,381,159,8279,032,952,674131,400,000.00$30,172,175$32,518,630TRUE
82
1512001.57%1.45%Year 418,512,559,8279,164,352,674131,400,000.00$30,645,215$32,991,670TRUE
83
1612801.55%1.44%Year 428,644,319,8279,296,112,674131,760,000.00$31,119,551$33,466,006TRUE
84
1713601.52%1.41%Year 438,775,719,8279,427,512,674131,400,000.00$31,592,591$33,939,046TRUE
85
1814401.50%1.39%Year 448,907,119,8279,558,912,674131,400,000.00$32,065,631$34,412,086TRUE
86
1915201.48%1.37%Year 459,038,519,8279,690,312,674131,400,000.00$32,538,671$34,885,126TRUE
87
2016001.46%1.36%Year 469,170,279,8279,822,072,674131,760,000.00$33,013,007$35,359,462TRUE
88
2116801.43%1.34%Year 479,301,679,8279,953,472,674131,400,000.00$33,486,047$35,832,502TRUE
89
2217601.41%1.32%Year 489,433,079,82710,084,872,674131,400,000.00$33,959,087$36,305,542TRUE
90
2318401.39%1.30%Year 499,564,479,82710,216,272,674131,400,000.00$34,432,127$36,778,582TRUE
91
2419201.38%1.29%Year 509,696,239,82710,348,032,674131,760,000.00$34,906,463$37,252,918TRUE
92
2520001.36%1.27%Year 519,827,639,82710,479,432,674131,400,000.00$35,379,503$37,725,958TRUE
93
2620801.34%1.25%Year 529,959,039,82710,610,832,674131,400,000.00$35,852,543$38,198,998TRUE
94
2721601.32%1.24%Year 5310,090,439,82710,742,232,674131,400,000.00$36,325,583$38,672,038TRUE
95
2822401.31%1.23%Year 5410,222,199,82710,873,992,674131,760,000.00$36,799,919$39,146,374TRUE
96
2923201.29%1.21%Year 5510,353,599,82711,005,392,674131,400,000.00$37,272,959$39,619,414TRUE
97
3024001.27%1.19%Year 5610,484,999,82711,136,792,674131,400,000.00$37,745,999$40,092,454TRUE
98
3124801.25%1.18%Year 5710,616,399,82711,268,192,674131,400,000.00$38,219,039$40,565,494TRUE
99
3225601.24%1.17%Year 5810,748,159,82711,399,952,674131,760,000.00$38,693,375$41,039,830TRUE
100
3326401.22%1.15%Year 5910,879,559,82711,531,352,674131,400,000.00$39,166,415$41,512,870TRUE