Aave - Leverage Farming - Google Sheets

	B	C	D	E	G	H	K	L	M	N
1
2	Aave Market Details
3							ETH Price	2750
4			Lend	Borrow	Maximum LTV	80%	BTC Price	96000
5		APR	1.81%	0.25%	Liquidation threshold	84.00%	ETHBTC	0.02865
6		Rewards			Used LTV	60%
7
8
9	Summary of My Position
10							Deposit (ETH)	Total Lend (ETH)	Total Borrow (BTC)	Liquidation Ratio
11		My Deposit:	550000		Total Lend	1,370,011.54	200	498.19	8.54	0.02041
12		Iterations:	10		Total Borrow	820,011.54
13					APR:	4.14%	Target ETHBTC	Profit (ETH)
14					My LTV	59.85%	0.04	84.64
15					Days to liquidation	-6,429
16
17
18	My Iterations
19
20		Iteration	Lend	Borrow
21		1	550,000.00	330,000.00
22		2	330,000.00	198,000.00
23		3	198,000.00	118,800.00
24		4	118,800.00	71,280.00
25		5	71,280.00	42,768.00
26		6	42,768.00	25,660.80
27		7	25,660.80	15,396.48
28		8	15,396.48	9,237.89
29		9	9,237.89	5,542.73
30		10	5,542.73	3,325.64
31		11	3,325.64
32		12
33		13
34		14
35		15
36		16
37		17
38		18
39		19
40		20
41
42
43
44
45
46
47
48
49
50
51
52
53
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