Balancer V2 LBP Simulator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	P	Q
1	Balancer Price Calculator		Download or copy to modify!		下载或复制以进行修改!
2	Sale duration	3	Days		Avg s/block	13.50		Ad hoc calculator			Capital from price calculator				Inputs	Outputs
3	Sale Rate	1,280,000	TKN/Day		Steps	72		Swap fee	0.1500%		TKN balance	34			Sale duration (in hours)	Total proceeds
4					Duration (hours)	72		TKN balance (pool)	7,500,000		Desired price	1,500.00	Type in desired price		Initial balances and weights	Unsold tokens
5	Demo video	https://vimeo.com/466075719			Duration (blocks)	19,200		USDC balance (pool)	$1,333,333		Required USDC	$4,859.16	System will find		Final weights	Price curve
6	(For V1, but similar)				Sale rate (hourly)	53,333		TKN weight	90				required amount		Sale Rate (TKN/Hr)
7								USDC weight	10				of reserve currency		Lot Size (average size of sale)
8			Start weight %	End weight %				Resulting USDC Price	$1.60				(Using TKN/weights		Swap fee
9	Initial TKN	7,500,000	99	30									from ad hoc)		Avg s/block
10	Initial USDC	$1,333,333.00	1	70				Resources
11								https://medium.com/balancer-protocol/a-new-paradigm-for-token-distribution-c82de13626bb
12	Lot Size	10,000	TKN		Proceeds	$27,970,889.43		https://medium.com/balancer-protocol/building-liquidity-into-token-distribution-a49d4286e0d4
13	Swap Fee	0.1500%			Unsold tokens	3,660,000
14								V1 Simulator
15	Max Price		You can enter the max price users are willing to pay here					https://docs.google.com/spreadsheets/d/1t6VsMJF8lh4xuH_rfPNdT5DM3nY4orF9KFOj2HdMmuY
16			It represents the price at which users will start buying (after the "price discovery" period)
17			And will halt buying if the price spikes above this value
18
19					TKN	USDC							SL(out); on lot size
20	Step	Blocks	Hours	TKN Price	Weights		TKN Balance	USDC Balance	Balance override		Sale rate override (tokens/day)		Slippage
21	0	0	0.00	$18.86	99	1	7,500,000	$1,333,333.00	TKN	USDC			0.0672%
22	1	267	1.00	$16.30	98.04	1.96	7,446,667	$2,338,992.92					0.0684%
23	2	533	2.00	$14.81	97.08	2.92	7,393,333	$3,208,401.61					0.0696%
24	3	800	3.00	$13.77	96.13	3.88	7,340,000	$3,998,116.69					0.0708%
25	4	1067	4.00	$12.99	95.17	4.83	7,286,667	$4,732,690.07					0.0720%
26	5	1333	5.00	$12.37	94.21	5.79	7,233,333	$5,425,558.88					0.0733%
27	6	1600	6.00	$11.85	93.25	6.75	7,180,000	$6,085,094.88					0.0746%
28	7	1867	7.00	$11.41	92.29	7.71	7,126,667	$6,716,966.61					0.0759%
29	8	2133	8.00	$11.02	91.33	8.67	7,073,333	$7,325,241.78					0.0773%
30	9	2400	9.00	$10.68	90.38	9.63	7,020,000	$7,912,967.16					0.0787%
31	10	2667	10.00	$10.37	89.42	10.58	6,966,667	$8,482,501.29					0.0801%
32	11	2933	11.00	$10.10	88.46	11.54	6,913,333	$9,035,718.21					0.0816%
33	12	3200	12.00	$9.84	87.50	12.50	6,860,000	$9,574,138.80					0.0832%
34	13	3467	13.00	$9.61	86.54	13.46	6,806,667	$10,099,019.17					0.0848%
35	14	3733	14.00	$9.39	85.58	14.42	6,753,333	$10,611,412.07					0.0864%
36	15	4000	15.00	$9.19	84.63	15.38	6,700,000	$11,112,210.95					0.0881%
37	16	4267	16.00	$9.00	83.67	16.33	6,646,667	$11,602,182.22					0.0898%
38	17	4533	17.00	$8.82	82.71	17.29	6,593,333	$12,081,989.50					0.0916%
39	18	4800	18.00	$8.65	81.75	18.25	6,540,000	$12,552,212.10					0.0934%
40	19	5067	19.00	$8.48	80.79	19.21	6,486,667	$13,013,359.33					0.0953%
41	20	5333	20.00	$8.33	79.83	20.17	6,433,333	$13,465,881.89					0.0972%	Because sheets won't let you have multiple axes apparently!
42	21	5600	21.00	$8.18	78.88	21.13	6,380,000	$13,910,180.77					0.0992%
43	22	5867	22.00	$8.04	77.92	22.08	6,326,667	$14,346,614.59					0.1013%
44	23	6133	23.00	$7.91	76.96	23.04	6,273,333	$14,775,505.51					0.1034%
45	24	6400	24.00	$7.77	76.00	24.00	6,220,000	$15,197,144.07					0.1056%
46	25	6667	25.00	$7.65	75.04	24.96	6,166,667	$15,611,793.27					0.1079%
47	26	6933	26.00	$7.53	74.08	25.92	6,113,333	$16,019,691.92					0.1102%
48	27	7200	27.00	$7.41	73.13	26.88	6,060,000	$16,421,057.51					0.1127%
49	28	7467	28.00	$7.29	72.17	27.83	6,006,667	$16,816,088.62					0.1152%
50	29	7733	29.00	$7.18	71.21	28.79	5,953,333	$17,204,966.96					0.1178%
51	30	8000	30.00	$7.07	70.25	29.75	5,900,000	$17,587,859.14					0.1205%
52	31	8267	31.00	$6.96	69.29	30.71	5,846,667	$17,964,918.22					0.1232%
53	32	8533	32.00	$6.86	68.33	31.67	5,793,333	$18,336,284.99					0.1261%
54	33	8800	33.00	$6.76	67.38	32.63	5,740,000	$18,702,089.13					0.1291%
55	34	9067	34.00	$6.66	66.42	33.58	5,686,667	$19,062,450.22					0.1322%
56	35	9333	35.00	$6.56	65.46	34.54	5,633,333	$19,417,478.61					0.1354%
57	36	9600	36.00	$6.46	64.50	35.50	5,580,000	$19,767,276.18					0.1387%
58	37	9867	37.00	$6.37	63.54	36.46	5,526,667	$20,111,937.04					0.1422%
59	38	10133	38.00	$6.27	62.58	37.42	5,473,333	$20,451,548.14					0.1457%
60	39	10400	39.00	$6.18	61.63	38.38	5,420,000	$20,786,189.75					0.1495%
61	40	10667	40.00	$6.09	60.67	39.33	5,366,667	$21,115,936.01					0.1533%
62	41	10933	41.00	$6.00	59.71	40.29	5,313,333	$21,440,855.31					0.1574%
63	42	11200	42.00	$5.91	58.75	41.25	5,260,000	$21,761,010.66					0.1616%
64	43	11467	43.00	$5.83	57.79	42.21	5,206,667	$22,076,460.06					0.1659%
65	44	11733	44.00	$5.74	56.83	43.17	5,153,333	$22,387,256.78					0.1705%
66	45	12000	45.00	$5.66	55.88	44.13	5,100,000	$22,693,449.65					0.1752%
67	46	12267	46.00	$5.57	54.92	45.08	5,046,667	$22,995,083.27					0.1801%
68	47	12533	47.00	$5.49	53.96	46.04	4,993,333	$23,292,198.26					0.1853%
69	48	12800	48.00	$5.40	53.00	47.00	4,940,000	$23,584,831.44					0.1907%
70	49	13067	49.00	$5.32	52.04	47.96	4,886,667	$23,873,016.01					0.1963%
71	50	13333	50.00	$5.24	51.08	48.92	4,833,333	$24,156,781.69					0.2022%
72	51	13600	51.00	$5.16	50.13	49.88	4,780,000	$24,436,154.90					0.2084%
73	52	13867	52.00	$5.07	49.17	50.83	4,726,667	$24,711,158.84					0.2148%
74	53	14133	53.00	$4.99	48.21	51.79	4,673,333	$24,981,813.60					0.2216%
75	54	14400	54.00	$4.91	47.25	52.75	4,620,000	$25,248,136.31					0.2287%
76	55	14667	55.00	$4.83	46.29	53.71	4,566,667	$25,510,141.16					0.2362%
77	56	14933	56.00	$4.75	45.33	54.67	4,513,333	$25,767,839.52					0.2440%
78	57	15200	57.00	$4.67	44.38	55.63	4,460,000	$26,021,239.96					0.2523%
79	58	15467	58.00	$4.59	43.42	56.58	4,406,667	$26,270,348.36					0.2609%
80	59	15733	59.00	$4.51	42.46	57.54	4,353,333	$26,515,167.89					0.2701%
81	60	16000	60.00	$4.43	41.50	58.50	4,300,000	$26,755,699.10					0.2798%
82	61	16267	61.00	$4.35	40.54	59.46	4,246,667	$26,991,939.91					0.2900%
83	62	16533	62.00	$4.27	39.58	60.42	4,193,333	$27,223,885.65					0.3008%
84	63	16800	63.00	$4.19	38.63	61.38	4,140,000	$27,451,529.05					0.3122%
85	64	17067	64.00	$4.11	37.67	62.33	4,086,667	$27,674,860.26					0.3243%
86	65	17333	65.00	$4.03	36.71	63.29	4,033,333	$27,893,866.83					0.3372%
87	66	17600	66.00	$3.94	35.75	64.25	3,980,000	$28,108,533.70					0.3509%
88	67	17867	67.00	$3.86	34.79	65.21	3,926,667	$28,318,843.18					0.3654%
89	68	18133	68.00	$3.78	33.83	66.17	3,873,333	$28,524,774.94					0.3810%
90	69	18400	69.00	$3.70	32.88	67.13	3,820,000	$28,726,305.92					0.3975%
91	70	18667	70.00	$3.61	31.92	68.08	3,766,667	$28,923,410.36					0.4153%
92	71	18933	71.00	$3.53	30.96	69.04	3,713,333	$29,116,059.68					0.4343%
93	72	19200	72.00	$3.44	30	70	3,660,000	$29,304,222.43					0.4547%
94
95
96
97
98
99
100