ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions:
2
1. Navigate to `File`, then `Make a Copy` to input your own variables
3
2. Only edit the cells highlighted in green, other cells will auto populate
4
5
6
7
Collateral Amount (Notional)$200,000Collateral Amount (Notional)$200,000Collateral Amount (Notional)$200,000Collateral Amount (Notional)$200,000Collateral Amount (Notional)$200,000
8
Loan-To-Value75%Loan-To-Value75%Loan-To-Value75%Loan-To-Value75%Loan-To-Value75%
9
GLP APR (ETH ONLY)32.34%GLP APR (ETH ONLY)32.34%GLP APR (ETH ONLY)32.34%GLP APR (ETH ONLY)32.34%GLP APR (ETH ONLY)32.34%
10
Lodestar Distribution APR (Supply)3.75%Lodestar Distribution APR (Supply)3.75%Lodestar Distribution APR (Supply)3.75%Lodestar Distribution APR (Supply)3.75%Lodestar Distribution APR (Supply)3.75%
11
Lodestar Distribution APR (Borrow)-5.00%Lodestar Distribution APR (Borrow)-5.00%Lodestar Distribution APR (Borrow)-5.00%Lodestar Distribution APR (Borrow)-5.00%Lodestar Distribution APR (Borrow)-5.00%
12
Total Number of Loops2Total Number of Loops3Total Number of Loops4Total Number of Loops5Total Number of Loops6
13
14
Loans Received$262,500Loans Received$346,875Loans Received$410,156Loans Received$457,617Loans Received$493,213
15
Total Notional including Collateral$462,500Total Notional including Collateral$546,875Total Notional including Collateral$610,156Total Notional including Collateral$657,617Total Notional including Collateral$693,213
16
Effective plvGLP APR29.11%Effective plvGLP APR29.11%Effective plvGLP APR29.11%Effective plvGLP APR29.11%Effective plvGLP APR29.11%
17
Effect APR on Initial Collateral69.42%Effect APR on Initial Collateral81.17%Effect APR on Initial Collateral89.98%Effect APR on Initial Collateral96.59%Effect APR on Initial Collateral101.55%
18
19
20
21
22
23
Collateral Amount (Notional)$200,000Collateral Amount (Notional)$200,000Collateral Amount (Notional)$200,000Collateral Amount (Notional)$200,000
24
Loan-To-Value75%Loan-To-Value75%Loan-To-Value75%Loan-To-Value75%
25
GLP APR (ETH ONLY)32.34%GLP APR (ETH ONLY)32.34%GLP APR (ETH ONLY)32.34%GLP APR (ETH ONLY)32.34%
26
Lodestar Distribution APR (Supply)3.75%Lodestar Distribution APR (Supply)3.75%Lodestar Distribution APR (Supply)3.75%Lodestar Distribution APR (Supply)3.75%
27
Lodestar Distribution APR (Borrow)-5.00%Lodestar Distribution APR (Borrow)-5.00%Lodestar Distribution APR (Borrow)-5.00%Lodestar Distribution APR (Borrow)-5.00%
28
Total Number of Loops7Total Number of Loops8Total Number of Loops9Total Number of Loops10
29
30
Loans Received$519,910Loans Received$539,932Loans Received$554,949Loans Received$566,212
31
Total Notional including Collateral$719,910Total Notional including Collateral$739,932Total Notional including Collateral$754,949Total Notional including Collateral$766,212
32
Effective plvGLP APR29.11%Effective plvGLP APR29.11%Effective plvGLP APR29.11%Effective plvGLP APR29.11%
33
Effect APR on Initial Collateral105.27%Effect APR on Initial Collateral108.06%Effect APR on Initial Collateral110.15%Effect APR on Initial Collateral111.72%
34
35
36
37
38
39
40
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