Investor ROI Simulation [legacy]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
"Green" = you can modify the parameter freely
2
"Red" = the cells are being calculated. Do NOT edit.
3
4
CO Characteristics
Notes on the parameter
5
Token units (buy slope)1,00E+00
No influence on the financial model. Only influences the number of tokens created for psychological purpose ("people prefer having 1M shares than 10 shares")
6
Investment reserve10,00%
When an investor buys some tokens, how much of his investment is being put in the "buy-back fund" of the smart-contract.
7
Revenues reserve30,00%
When revenues are being used to buy tokens, how much of the revenues are being put in the "buy-back fund" of the smart-contract.
8
% dividends distributed to shareholders
30,00%
When revenues are being used to buy tokens, which part of these tokens are being distributed to shareholders (the other part being transferred/reinvested in the organisation)
9
Number of initial tokens minted1 000
How many tokens do you want to pre-mint at the start of the CO. This "free" tokens can be useful but obviously put a selling pressure on the other token holders.
11
Year12345678910
12
CO Cash-flows
13
Outside funding
2 590 0003 750 0005 310 0007 470 0009 630 00011 790 00013 950 00016 110 00018 270 00020 430 000
14
Investments1 600 000600 00000000000
15
Revenues990 0003 150 0005 310 0007 470 0009 630 00011 790 00013 950 00016 110 00018 270 00020 430 000
16
Money allocation
17
Organisation financing2 133 0002 745 0003 717 0005 229 0006 741 0008 253 0009 765 00011 277 00012 789 00014 301 000
18
Number of tokens in the CO reserve4677328869509799951 0041 0101 0141 017
19
price equivalent (end of year)1 529 1673 338 4995 164 3376 823 1478 405 3639 955 39711 490 06713 016 59214 538 42816 057 386
20
Buy-back fund457 0001 005 0001 593 0002 241 0002 889 0003 537 0004 185 0004 833 0005 481 0006 129 000
22
CO Smart Contract
23
Number of tokens issued3 2761 2851 2661 3571 3991 4221 4351 4431 4491 453
24
Price of latest token issued3275,964560,905827,017183,858582,8810004,4411439,3512882,7614331,9215785,13
25
Number of dividends tokens distributed
200314380407420426430433435436
26
% tokens distributed / new tokens issued
6,11%24,41%30,00%30,00%30,00%30,00%30,00%30,00%30,00%30,00%
27
ROI
28
Investment100 000
29
Investment month12
30
Minimum IRR (end of year)-91,12%-53,01%-27,03%-12,67%-4,52%0,34%3,37%5,31%6,58%7,42%
31
Equivalent Minimum ROI-0,91-0,78-0,61-0,42-0,210,020,260,510,771,05
32
Maximum IRR (end of year)4,30%25,33%29,25%29,74%28,99%27,80%26,51%25,24%24,04%22,93%
33
Equivalent Maximum ROI0,040,571,161,832,573,364,195,055,956,88
34
Organisation valuation (~)2 682 9815 200 4498 488 50412 901 92518 416 43825 022 22232 714 67441 491 38051 350 95862 292 564
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
101
102
Loading...
Main menu