Crypto Value Index Template

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1			FutureValue													Current UtilityValue
2	Ticker	MarketPrice	TargetMarket	TotalAddressableMarket	MarketShare	Lifespan	Top Dev Team?	Velocity	Future Market Cap	Sanity Check	FutureSupply	Future Coin Value	FutureDate	DiscountRate	SpeculationValue	Utility Value	Top Down Value	Bottom Up Value	Current Value	Total Value	CVI (Crypto Value Index)	Current UtilityValue	FutureValue	Chart Title

3	BTC	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	M1 money	$41,000,000,000,000	5%	2039	1	NA	$2,050,000,000,000	BTC market cap has been rising 10x every 2 years. If that trend continues, BTC market cap will be $3.2B in 10 years. This model predicts $2B market cap in 10 years, which is the right order of magnitude	20,000,000	$102,500	10	20%	$16,554.32	5%	$0	$20,000,000,000	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#VALUE!	BTC (M1 money)
4	BTC	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	Store of Value	$7,800,000,000,000	10%	2039	1	NA	$780,000,000,000	BTC market cap has been rising 10x every 2 years. If that trend continues, BTC market cap will be $3.2B in 10 years. This model predicts $2B market cap in 10 years, which is the right order of magnitude		#DIV/0!	10	20%	#DIV/0!	5%	$0		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	BTC (Store of Value)
5	BCH	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	M1 money	$41,000,000,000,000	5%	2031	1	NA	$2,050,000,000,000	Value depends on the flippening so discount rate is higher, but target market size is the same as BTC	20,000,000	$102,500	10	36%	$4,735.16	5%	#NAME?		#NAME?	#NAME?	#NAME?	#NAME?	#VALUE!	BCH (M1 money)
6	ETH	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	Equities	$76,300,000,000,000	20%	2033	1	10	$1,526,000,000,000		180,000,000	$8,478	10	32%	$527.89	5%	#NAME?	$1,866,666,667	#NAME?	#NAME?	#NAME?	#NAME?	#VALUE!	ETH (Equities)
7	ETH	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	Equities–Staked	$76,300,000,000,000	20%	2033	1	10	$1,526,000,000,000			#DIV/0!	10	32%	#DIV/0!	10%	#NAME?		#NAME?	#NAME?	#NAME?	#NAME?	#DIV/0!	ETH (Equities–Staked)
8	ZRX	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	Exchanges	$19,345,000,000,000	20%	2031	1	365	$10,600,000,000			#DIV/0!	10	36%	#DIV/0!	1%	#NAME?		#NAME?	#NAME?	#NAME?	#NAME?	#DIV/0!	ZRX (Exchanges)
9	XMR	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	Black Market	$8,250,000,000,000	5%	2034	1	20	$82,500,000,000			#DIV/0!	10	30%	#DIV/0!	10%	#NAME?		#NAME?	#NAME?	#NAME?	#NAME?	#DIV/0!	XMR (Black Market)
10	ZEC	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	Black Market	$8,250,000,000,000	5%	2032	1	20	$20,625,000,000		17,000,000	$1,213	10	34%	$65.00	10%	#NAME?		#NAME?	#NAME?	#NAME?	#NAME?	#VALUE!	ZEC (Black Market)
11	ADA	You are not logged in. Use the side panel, or 'CSLOGIN(email, password)' to login.	Equities	$76,300,000,000,000		2031	1	10	$0			#DIV/0!	10	36%	#DIV/0!	1%	#NAME?		#NAME?	#NAME?	#NAME?	#NAME?	#DIV/0!	ADA (Equities)
12			To improve the model, make a copy (File->Make a Copy...) then plug in your assumptions to the shaded cells and get your own Crypto Value Index (CVI)
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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