Tester

	A	B	C	D	E	F	G
1	- This is calculation sheet for Makai. - Please copy and use. - In a yellow cell, you should input the value based on your favorite case. - In a green cell, you don't have to edit it since it has function.
2	Asset	Price $	Amount	LTV	Deposit APR	Borrow APR
3	USDC	1	100	80%	20%	30%
4	Total Deposit	Total Borrow	Makai APR Deposit	Makai APR Borrow	Makai APR Total
5	500.00	400.00	100.00%	120.00%	220.00%
6	Loop Index	Deposit	Borrow	Total Deposit	Total Borrow	Collateral in USD	Leverage (x)
7	1	100.00		100.000		100	1
8	2		80.00	100.000	80.000	100	1
9	3	80.00		180.000	80.000	180	1.8
10	4		64.00	180.000	144.000	180	1.8
11	5	64.00		244.000	144.000	244	2.44
12	6		51.20	244.000	195.200	244	2.44
13	7	51.20		295.200	195.200	295.2	2.952
14	8		40.96	295.200	236.160	295.2	2.952
15	9	40.96		336.160	236.160	336.16	3.362
16	10		32.77	336.160	268.928	336.16	3.362
17	11	32.77		368.928	268.928	368.928	3.689
18	12		26.21	368.928	295.142	368.928	3.689
19	13	26.21		395.142	295.142	395.142	3.951
20	14		20.97	395.142	316.114	395.142	3.951
21	15	20.97		416.114	316.114	416.114	4.161
22	16		16.78	416.114	332.891	416.114	4.161
23	17	16.78		432.891	332.891	432.891	4.329
24	18		13.42	432.891	346.313	432.891	4.329
25	19	13.42		446.313	346.313	446.313	4.463
26	20		10.74	446.313	357.050	446.313	4.463
27	21	10.74		457.050	357.050	457.050	4.571
28	22		8.59	457.050	365.640	457.050	4.571
29	23	8.590		465.640	365.640	465.640	4.656
30	24		6.872	465.640	372.512	465.640	4.656
31	25	6.872		472.512	372.512	472.512	4.725
32	26		5.498	472.512	378.010	472.512	4.725
33	27	5.498		478.010	378.010	478.010	4.780
34	28		4.398	478.010	382.408	478.010	4.780
35	29	4.398		482.408	382.408	482.408	4.824
36	30		3.518	482.408	385.926	482.408	4.824
37	31	3.518		485.926	385.926	485.926	4.859
38	32		2.815	485.926	388.741	485.926	4.859
39	33	2.815		488.741	388.741	488.741	4.887
40	34		2.252	488.741	390.993	488.741	4.887
41	35	2.252		490.993	390.993	490.993	4.910
42	36		1.801	490.993	392.794	490.993	4.910
43	37	1.801		492.794	392.794	492.794	4.928
44	38		1.441	492.794	394.235	492.794	4.928
45	39	1.441		494.235	394.235	494.235	4.942
46	40		1.153	494.235	395.388	494.235	4.942
47	41	1.1529		495.388	395.388	495.388	4.954
48	42		0.9223	495.388	396.311	495.388	4.954
49	43	0.9223		496.311	396.311	496.311	4.963
50	44		0.7379	496.311	397.049	496.311	4.963
51	45	0.7379		497.049	397.049	497.049	4.970
52	46		0.5903	497.049	397.639	497.049	4.970
53	47	0.5903		497.639	397.639	497.639	4.976
54	48		0.4722	497.639	398.111	497.639	4.976
55	49	0.4722		498.111	398.111	498.111	4.981
56	50		0.3778	498.111	398.489	498.111	4.981
57	51	0.3778		498.489	398.489	498.489	4.985
58	52		0.3022	498.489	398.791	498.489	4.985
59	53	0.3022		498.791	398.791	498.791	4.988
60	54		0.2418	498.791	399.033	498.791	4.988
61	55	0.2418		499.033	399.033	499.033	4.990
62	56		0.1934	499.033	399.226	499.033	4.990
63	57	0.1934		499.226	399.226	499.226	4.992
64	58		0.1547	499.226	399.381	499.226	4.992
65	59	0.1547		499.381	399.381	499.381	4.994
66	60		0.1238	499.381	399.505	499.381	4.994
67	61	0.1238		499.505	399.505	499.505	4.995
68	62		0.0990	499.505	399.604	499.505	4.995
69	63	0.0990		499.604	399.604	499.604	4.996
70	64		0.0792	499.604	399.683	499.604	4.996
71	65	0.0792		499.683	399.683	499.683	4.997
72	66		0.0634	499.683	399.746	499.683	4.997
73	67	0.0634		499.746	399.746	499.746	4.997
74	68		0.0507	499.746	399.797	499.746	4.997
75	69	0.0507		499.797	399.797	499.797	4.998
76	70		0.0406	499.797	399.838	499.797	4.998
77	71	0.0406		499.838	399.838	499.838	4.998
78	72		0.0325	499.838	399.870	499.838	4.998
79	73	0.0325		499.870	399.870	499.870	4.999
80	74		0.0260	499.870	399.896	499.870	4.999
81	75	0.0260		499.896	399.896	499.896	4.999
82	76		0.0208	499.896	399.917	499.896	4.999
83	77	0.0208		499.917	399.917	499.917	4.999
84	78		0.0166	499.917	399.934	499.917	4.999
85	79	0.0166		499.934	399.934	499.934	4.999
86	80		0.0133	499.934	399.947	499.934	4.999
87	81	0.0133		499.947	399.947	499.947	4.999
88	82		0.0106	499.947	399.957	499.947	4.999
89	83	0.0106		499.957	399.957	499.957	5.000
90	84		0.0085	499.957	399.966	499.957	5.000
91	85	0.0085		499.966	399.966	499.966	5.000
92	86		0.0068	499.966	399.973	499.966	5.000
93	87	0.0068		499.973	399.973	499.973	5.000
94	88		0.0054	499.973	399.978	499.973	5.000
95	89	0.0054		499.978	399.978	499.978	5.000
96	90		0.0044	499.978	399.983	499.978	5.000
97	91	0.0044		499.983	399.983	499.983	5.000
98	92		0.0035	499.983	399.986	499.983	5.000
99	93	0.0035		499.986	399.986	499.986	5.000
100	94		0.0028	499.986	399.989	499.986	5.000