Token Valuation Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUV
1
2
YUGO Supply 230,000,000 tokens
3
4
Max No. of Platform Users 200,000 pax
5
k 0.e
6
x0 40 in quarters
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Platform Economics
22
23
Avg Proportion of Users Conducting Transaction per Quarter
20%
24
USD Value per Transaction $ 1
25
Platform Fees per Transaction4%
26
Flow through to Token Holders50%
27
Quarterly USD Revenue to Token Holders per User $ 80,000,000,000 CHECK0.0
28
29
30
4,000,000,000 12345678910111213141516Terminal Value
31
Q1 2018Q2 2018Q3 2018Q4 2018Q1 2019Q2 2019Q3 2019Q4 2019Q1 2020Q2 2020Q3 2020Q4 2020Q1 2021Q2 2021Q3 2021Q4 2021
32
Revenues SwissBorg USD 10 10 10 10 15 15 15 15 37 37 37 37 63 63 63 63
33
34
SwissBorg CF (USD) $ 770,800,000,000 $ 770,800,000,000 $ 770,800,000,000 $ 770,800,000,000 $ 1,190,000,000,000 $ 1,190,000,000,000 $ 1,190,000,000,000 $ 1,190,000,000,000 $ 2,974,000,000,000 $ 2,974,000,000,000 $ 2,974,000,000,000 $ 2,974,000,000,000 $ 5,066,000,000,000 $ 5,066,000,000,000 $ 5,066,000,000,000 $ 5,066,000,000,000 $ 33,736,601,619,702
35
36
Discount Rate15%
37
PV of CF + Terminal Value$9,609,998,307,117
38
Price per Token$41,782.601335292
39
Market Cap$167,130,405,341,169.000
40
41
Sensitivity Analysis - Market Cap to No of Users and Revenue per User
Note: these sensititivities were calculated using Data Tables in MS Excel; unfortunately, Google Sheets does not support Data Tables directly. I will endeavour to set this up using Google Sheet ArrayFormulas for the next post.
42
No of Users -->
43
$9,609,998,307,117 20,000 20,000 100,000,000 1,000,000,000
44
Quarterly USD CF to Token Holder per User
$ 100 65,151,545 651,515,446 6,515,154,456 65,151,544,558
45
| $ 10 6,515,154 65,151,545 651,515,446 6,515,154,456
46
v $ 1 651,515 6,515,154 65,151,545 651,515,446
47
48
Sensitivity Analysis - Token Price to No of Users and Revenue per User
49
No of Users -->
50
Max Buyer Should Pay for Token at Launch 20,000 20,000 100,000,000 1,000,000,000
51
Quarterly USD CF to Token Holder per User
$ 100 $ 0.283268 $ 2.832676 $ 28.326759 $ 283.267585
52
| $ 10 $ 0.028327 $ 0.283268 $ 2.832676 $ 28.326759
53
v $ 1 $ 0.002833 $ 0.028327 $ 0.283268 $ 2.832676
54
55
Cash Flow to Token Holder (USD per Quarter) 1,534,883 15,348,830 153,488,303 1,534,883,028
<--- solved using Goal Seek
56
Max Token Market Cap at Launch 1,000,000 10,000,000 100,000,000 1,000,000,000
57
Max Buyer Should Pay for Token at Launch $ 0.004348 $ 0.043478 $ 0.434783 $ 4.347826
58
59
Sensitivity Analysis - Market Cap to Discount Rate
60
Discount Rate - Annual & Quarterly75%60%65%33%
61
$9,609,998,307,11715.0%12.5%13.3%7.4%
62
1 $ 65,151,545 $ 111,285,864 $ 92,202,075 $ 394,809,495
63
Max Buyer Should Pay for PRToken at Launch $ 0.283268 $ 0.483852 $ 0.400879 $ 1.716563
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...
Main menu