3-Token LBP.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Balancer Price Calculator		Select "File/Make a copy" to customize/modify
2	Sale duration	5	Days		Avg s/block	13.50				Ad hoc calculator
3	DAI Sale Rate	40,000.00	TKN / Day		Steps	36				Swap fee	0.1500%
4	WETH Sale Rate	40,000.00	TKN / Day		Duration (hours)	120				ETH Price	$555.00
5					Duration (blocks)	32000				TKN balance (pool)	500,000
6					DAI sale rate (h)	1,666.6667	WETH Sale rate (h)	1,666.6667		DAI balance (pool)	$50,000.00
7			Start weight	End weight	Start weight %	End weight %	Total Sale Rate	3,333.3333		WETH balance (pool)	90.00	Weight sum	Percentages
8	Initial TKN	500,000	32	8	80.00	20.00				TKN weight	32	40	80%
9	Initial DAI	$50,000.00	4	16	10.00	40.00				DAI weight	4		10%
10	Initial WETH	90.00	4	16	10.00	40.00				WETH weight	4		10%
11			40	40						TKN Price in DAI	$0.80
12	Lot Size	100	TKN		Proceeds	$364,752.26				TKN Price in WETH	0.0014	$0.80
13	Swap Fee	0.1500%			TKN	100,000				WETH price in DAI	557.0090						ETH Price Change (%)
14																	0%
15							TKN	DAI	WETH				TKN	DAI	WETH	Total		WETH price, in $
16	Step	Blocks	Hours	TKN Price (DAI)	TKN Price (WETH)	WETH Price (DAI)	Weights (denormalized)			TKN Balance	DAI Balance	WETH Balance	Weights (as percentages)			denorm	ETH Price	TKN Price
17	0	0	0.00	$0.80	0.001443	$557.01	32	4	4	500,000	$50,000.00	90.0000	80.00%	10.00%	10.00%	40	$550.00	$0.79
18	1	889	3.33	$0.81	0.001453	$556.96	31.33	4.33	4.33	488,889	$54,455.13	98.0192	78.33%	10.83%	10.83%	40	$550.00	$0.80
19	2	1778	6.67	$0.81	0.001463	$556.92	30.67	4.67	4.67	477,778	$58,940.09	106.0922	76.67%	11.67%	11.67%	40	$550.00	$0.80
20	3	2667	10.00	$0.82	0.001472	$556.88	30.00	5.00	5.00	466,667	$63,454.16	114.2175	75.00%	12.50%	12.50%	40	$550.00	$0.81
21	4	3556	13.33	$0.82	0.001481	$556.85	29.33	5.33	5.33	455,556	$67,996.81	122.3943	73.33%	13.33%	13.33%	40	$550.00	$0.81
22	5	4444	16.67	$0.83	0.001490	$556.82	28.67	5.67	5.67	444,444	$72,567.68	130.6218	71.67%	14.17%	14.17%	40	$550.00	$0.82
23	6	5333	20.00	$0.83	0.001499	$556.79	28.00	6.00	6.00	433,333	$77,166.55	138.8998	70.00%	15.00%	15.00%	40	$550.00	$0.82
24	7	6222	23.33	$0.84	0.001508	$556.77	27.33	6.33	6.33	422,222	$81,793.31	147.2280	68.33%	15.83%	15.83%	40	$550.00	$0.83
25	8	7111	26.67	$0.84	0.001517	$556.75	26.67	6.67	6.67	411,111	$86,447.99	155.6064	66.67%	16.67%	16.67%	40	$550.00	$0.83
26	9	8000	30.00	$0.85	0.001526	$556.73	26.00	7.00	7.00	400,000	$91,130.72	164.0353	65.00%	17.50%	17.50%	40	$550.00	$0.84
27	10	8889	33.33	$0.85	0.001536	$556.71	25.33	7.33	7.33	388,889	$95,841.75	172.5152	63.33%	18.33%	18.33%	40	$550.00	$0.84
28	11	9778	36.67	$0.86	0.001545	$556.70	24.67	7.67	7.67	377,778	$100,581.42	181.0466	61.67%	19.17%	19.17%	40	$550.00	$0.85
29	12	10667	40.00	$0.86	0.001555	$556.68	24.00	8.00	8.00	366,667	$105,350.20	189.6304	60.00%	20.00%	20.00%	40	$550.00	$0.86
30	13	11556	43.33	$0.87	0.001565	$556.67	23.33	8.33	8.33	355,556	$110,148.66	198.2676	58.33%	20.83%	20.83%	40	$550.00	$0.86
31	14	12444	46.67	$0.87	0.001575	$556.66	22.67	8.67	8.67	344,444	$114,977.48	206.9595	56.67%	21.67%	21.67%	40	$550.00	$0.87
32	15	13333	50.00	$0.88	0.001585	$556.65	22.00	9.00	9.00	333,333	$119,837.48	215.7075	55.00%	22.50%	22.50%	40	$550.00	$0.87
33	16	14222	53.33	$0.89	0.001596	$556.64	21.33	9.33	9.33	322,222	$124,729.61	224.5133	53.33%	23.33%	23.33%	40	$550.00	$0.88
34	17	15111	56.67	$0.89	0.001607	$556.63	20.67	9.67	9.67	311,111	$129,654.96	233.3789	51.67%	24.17%	24.17%	40	$550.00	$0.88
35	18	16000	60.00	$0.90	0.001619	$556.62	20.00	10.00	10.00	300,000	$134,614.78	242.3066	50.00%	25.00%	25.00%	40	$550.00	$0.89
36	19	16889	63.33	$0.91	0.001631	$556.61	19.33	10.33	10.33	288,889	$139,610.50	251.2989	48.33%	25.83%	25.83%	40	$550.00	$0.90
37	20	17778	66.67	$0.91	0.001644	$556.60	18.67	10.67	10.67	277,778	$144,643.75	260.3588	46.67%	26.67%	26.67%	40	$550.00	$0.90
38	21	18667	70.00	$0.92	0.001657	$556.60	18.00	11.00	11.00	266,667	$149,716.40	269.4895	45.00%	27.50%	27.50%	40	$550.00	$0.91
39	22	19556	73.33	$0.93	0.001671	$556.59	17.33	11.33	11.33	255,556	$154,830.57	278.6950	43.33%	28.33%	28.33%	40	$550.00	$0.92
40	23	20444	76.67	$0.94	0.001686	$556.58	16.67	11.67	11.67	244,444	$159,988.67	287.9796	41.67%	29.17%	29.17%	40	$550.00	$0.93
41	24	21333	80.00	$0.95	0.001703	$556.58	16.00	12.00	12.00	233,333	$165,193.50	297.3483	40.00%	30.00%	30.00%	40	$550.00	$0.94
42	25	22222	83.33	$0.96	0.001720	$556.57	15.33	12.33	12.33	222,222	$170,448.24	306.8068	38.33%	30.83%	30.83%	40	$550.00	$0.95
43	26	23111	86.67	$0.97	0.001739	$556.57	14.67	12.67	12.67	211,111	$175,756.59	316.3619	36.67%	31.67%	31.67%	40	$550.00	$0.96
44	27	24000	90.00	$0.98	0.001759	$556.56	14.00	13.00	13.00	200,000	$181,122.85	326.0211	35.00%	32.50%	32.50%	40	$550.00	$0.97
45	28	24889	93.33	$0.99	0.001781	$556.56	13.33	13.33	13.33	188,889	$186,552.01	335.7936	33.33%	33.33%	33.33%	40	$550.00	$0.98
46	29	25778	96.67	$1.00	0.001806	$556.55	12.67	13.67	13.67	177,778	$192,049.99	345.6900	31.67%	34.17%	34.17%	40	$550.00	$0.99
47	30	26667	100.00	$1.02	0.001833	$556.55	12.00	14.00	14.00	166,667	$197,623.79	355.7228	30.00%	35.00%	35.00%	40	$550.00	$1.01
48	31	27556	103.33	$1.04	0.001864	$556.54	11.33	14.33	14.33	155,556	$203,281.82	365.9073	28.33%	35.83%	35.83%	40	$550.00	$1.03
49	32	28444	106.67	$1.05	0.001898	$556.54	10.67	14.67	14.67	144,444	$209,034.27	376.2617	26.67%	36.67%	36.67%	40	$550.00	$1.04
50	33	29333	110.00	$1.08	0.001938	$556.53	10.00	15.00	15.00	133,333	$214,893.67	386.8086	25.00%	37.50%	37.50%	40	$550.00	$1.07
51	34	30222	113.33	$1.10	0.001984	$556.53	9.33	15.33	15.33	122,222	$220,875.64	397.5762	23.33%	38.33%	38.33%	40	$550.00	$1.09
52	35	31111	116.67	$1.13	0.002039	$556.53	8.67	15.67	15.67	111,111	$227,000.04	408.6001	21.67%	39.17%	39.17%	40	$550.00	$1.12
53	36	32000	120.00	$1.17	0.002104	$556.52	8.00	16.00	16.00	100,000	$233,292.59	419.9267	20.00%	40.00%	40.00%	40	$550.00	$1.16
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