Etherplan Financials draft v1

Chargement en cours...

	A	B	C	D	E
1	Assumptions:
2
3	Customer Lifetime Value (CLV)	Year 1	Year 2	Year 3	Year 4
4	Cost per visit		0.25	0.25	0.25
5	Conversion to trials		10.00%	10.00%	10.00%
6	Conversion to funded SPs		10.00%	10.00%	10.00%
7	Marketing spend		25,000.00	1,000,000.00	2,000,000.00
8	Churn rate		8%	8%	8%
9	Discount rate		12%	12%	12%
10	Gross margin		90%	90%	90%
11
12	Assets under management (AUM)	Year 1	Year 2
13	Initial account opening AUM per customer		25,000.00
14	Annual savings per customer 5% per year		1,250.00
15	Expected return bonds		4.00%
16	Expected return stocks		8.00%
17	Expected crypto		20.00%
18	Expected gold		5.00%
19	Allocation bonds		25.00%
20	Allocation stocks		50.00%
21	Allocation crypto		12.50%
22	Allocation gold		12.50%
23
24	Smart portfolio expense ratio	Year 1	Year 2	Year 3	Year 4
25	Etherplan base fee		0.25%	0.25%	0.25%
26	Advisor annual fee		0.25%	0.25%	0.25%
27	Underlying assets fees		0.15%	0.15%	0.15%
28	Exchange commission per TX		0.10%	0.10%	0.10%
29	Trustee fees		1.00%	1.00%	1.00%
30	Payout to beneficiaries one time fee		1.00%	1.00%	1.00%
31	Number of assets/investments per SP		30	30	30
32	SP investment turnover/yr		50%	50%	50%
33	GAS per TX		100,000	100,000	100,000
34	GAS price in Szabo		1	1	1
35	Ether price in USD		$10	$10	$10
36
37	Funding	Year 1	Year 2	Year 3	Year 4
38	Seed, series A, B, C, etc.	1,000,000.00	10,000,000.00	0.00	0.00
39
40	AUM growth rate
41	2020	50%
42	2021	50%
43	2022	50%
44	2023	50%
45	2024	50%
46	2025	50%
47	2026	50%
48
49	The DAO revenue share
50	2017	20%
51	2018	20%
52	2019	20%
53	2020	20%
54	2021	20%
55	2022	20%
56	2023	20%
57	2024	20%
58	2025	20%
59	2026	20%
60
61	The DAO proposal
62	Investment	1,000,000.00
63	Cap	5,000,000.00
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

Chargement en cours...