Kegshare - Rate Table - Google Sheets

	A	B	C	D	E	F	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	As of:	04/06/2022
2
3	Token Purchasing			Token Financing: Monthly payment						Keg Rental - 3 Year Term				Surge - 3 Month Min.
4	Keg Size	Outright Purchase Price		Keg Size	1 year	2 years	3 years	4 years		Keg Size	Monthly			Keg Size	Monthly
5	19.5L	$80.00		19.5L	$7.47	$3.94	$2.78	$2.19		19.5L	$3.25			19.5L	$5.90
6	30L	$95.00		30L	$8.87	$4.68	$3.30	$2.61		30L	$3.65			30L	$6.90
7	50L	$115.00		50L	$10.73	$5.67	$3.99	$3.16		50L	$4.15			50L	$7.90
8
9
10	Membership Dues			Min order per pallet
11	Keg Size	Dues		Per Pallet	1	2	3	4	5	6	7	8	9	10
12	19.5L	$1.75		19.5L	20	40	60	80	100	120	140	160	180	200
13	30L	$1.85		30L	16	32	48	64	80	96	112	128	144	160
14	50L	$2.00		50L	8	16	24	32	40	48	56	64	72	80
15
16
17	Scanning Fees
18	Scan type	Cost per scan
19	Release to Member	$0.60
20	Return to Network	$0.60
21
22
23
24	Repositioning Fees
25										Ship To
26			Victoria, BC			Vancouver, BC			West Kelowna, BC			St. Albert, AB			Winnipeg, MB			Regina, SK			Brampton, ON			Orleans, ON			New Brunswick			Nova Scotia
27			19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L	19.5L	30L	50L
28		Victoria, BC				1.54	1.92	3.85	2.18	2.72	5.44	3.01	3.76	7.52	3.94	4.92	9.84	3.94	4.92	9.84	5.46	6.82	13.64	5.46	6.82	13.64
29		Vancouver, BC	1.54	1.92	3.85				1.02	1.28	2.56	1.86	2.32	4.64	2.78	3.48	6.96	2.78	3.48	6.96	4.30	5.38	10.76	4.30	5.38	10.76
30	Ship From	West Kelowna, BC	2.18	2.72	5.44	1.02	1.28	2.56				1.64	2.06	4.11	2.68	3.35	6.69	2.68	3.35	6.69	4.28	5.35	10.70	4.28	5.35	10.70
31		St. Albert, AB	2.48	3.10	6.20	1.33	1.66	3.32	1.23	1.54	3.08				1.49	1.86	3.73	1.49	1.86	3.73	3.28	4.10	8.21	3.28	4.10	8.21
32		Winnipeg, MB	4.04	5.05	10.10	2.88	3.61	7.21	2.69	3.37	6.73	1.92	2.40	4.81				1.92	2.40	4.81	2.05	2.57	5.13	2.05	2.57	5.13
33		Regina, SK	4.04	5.05	10.10	2.88	3.61	7.21	2.69	3.37	6.73	1.92	2.40	4.81	1.92	2.40	4.81				3.17	3.97	7.93	3.17	3.97	7.93
34		Brampton, ON	6.83	8.53	17.07	5.67	7.09	14.18	5.37	6.71	13.43	4.97	6.21	12.43	3.17	3.97	7.93	3.17	3.97	7.93				2.05	2.57	5.13	3.88	4.85	6.47	4.32	5.40	6.47
35		Orleans, ON	6.83	8.53	17.07	5.67	7.09	14.18	5.37	6.71	13.43	4.97	6.21	12.43	3.17	3.97	7.93	3.17	3.97	7.93	2.05	2.57	5.13				3.88	4.85	6.47	4.32	5.40	6.47
36		New Brunswick																			5.27	6.59	8.77	5.27	6.59	8.77
37		Nova Scotia																			5.87	7.32	9.78	5.87	7.32	9.78
38
39
40
41	Repurchase (Buy Back) Depreciation
42	"Token value is depreciated at 2% per month"					3 Year Rental Early Cancellation Fees
43	Years	19.5L	30L	50L		Keg Size	Per Keg
44	0	$80.00	$95.00	$115.00		19.5L	$9.75
45	1	$62.78	$74.55	$90.24		30L	$10.95
46	2	$49.26	$58.50	$70.81		50L	$12.45
47	3	$38.66	$45.91	$55.57
48	4	$30.33	$36.02	$43.61
49	5	$23.80	$28.27	$34.22
50	6	$18.68	$22.18	$26.85
51	7	$14.66	$17.41	$21.07
52	8	$11.50	$13.66	$16.53
53	9	$9.03	$10.72	$12.98
54	10	$7.08	$8.41	$10.18
55
56
57		20L Kegs			30L Kegs			50L Kegs
58	Month	Depreciation	End		Depreciation	End		Depreciation	End
59	0	Starting Value	$80.00		Starting Value	$95.00		Starting Value	$115.00
60	1	1.6	$78.40		1.9	$93.10		2.3	$112.70
61	2	1.57	$76.83		1.86	$91.24		2.25	$110.45
62	3	1.54	$75.30		1.82	$89.41		2.21	$108.24
63	4	1.51	$73.79		1.79	$87.62		2.16	$106.07
64	5	1.48	$72.31		1.75	$85.87		2.12	$103.95
65	6	1.45	$70.87		1.72	$84.16		2.08	$101.87
66	7	1.42	$69.45		1.68	$82.47		2.04	$99.83
67	8	1.39	$68.06		1.65	$80.82		2	$97.84
68	9	1.36	$66.70		1.62	$79.21		1.96	$95.88
69	10	1.33	$65.37		1.58	$77.62		1.92	$93.96
70	11	1.31	$64.06		1.55	$76.07		1.88	$92.08
71	12	1.28	$62.78		1.52	$74.55		1.84	$90.24
72	13	1.26	$61.52		1.49	$73.06		1.8	$88.44
73	14	1.23	$60.29		1.46	$71.60		1.77	$86.67
74	15	1.21	$59.09		1.43	$70.16		1.73	$84.94
75	16	1.18	$57.90		1.4	$68.76		1.7	$83.24
76	17	1.16	$56.75		1.38	$67.39		1.66	$81.57
77	18	1.13	$55.61		1.35	$66.04		1.63	$79.94
78	19	1.11	$54.50		1.32	$64.72		1.6	$78.34
79	20	1.09	$53.41		1.29	$63.42		1.57	$76.77
80	21	1.07	$52.34		1.27	$62.15		1.54	$75.24
81	22	1.05	$51.29		1.24	$60.91		1.5	$73.73
82	23	1.03	$50.27		1.22	$59.69		1.47	$72.26
83	24	1.01	$49.26		1.19	$58.50		1.45	$70.81
84	25	0.99	$48.28		1.17	$57.33		1.42	$69.40
85	26	0.97	$47.31		1.15	$56.18		1.39	$68.01
86	27	0.95	$46.37		1.12	$55.06		1.36	$66.65
87	28	0.93	$45.44		1.1	$53.96		1.33	$65.32
88	29	0.91	$44.53		1.08	$52.88		1.31	$64.01
89	30	0.89	$43.64		1.06	$51.82		1.28	$62.73
90	31	0.87	$42.77		1.04	$50.78		1.25	$61.48
91	32	0.86	$41.91		1.02	$49.77		1.23	$60.25
92	33	0.84	$41.07		1	$48.77		1.2	$59.04
93	34	0.82	$40.25		0.98	$47.80		1.18	$57.86
94	35	0.81	$39.45		0.96	$46.84		1.16	$56.70
95	36	0.79	$38.66		0.94	$45.91		1.13	$55.57
96	37	0.77	$37.88		0.92	$44.99		1.11	$54.46
97	38	0.76	$37.13		0.9	$44.09		1.09	$53.37
98	39	0.74	$36.38		0.88	$43.21		1.07	$52.30
99	40	0.73	$35.66		0.86	$42.34		1.05	$51.26
100	41	0.71	$34.94		0.85	$41.49		1.03	$50.23