POL Loan Simulation - Collateral analysis for 2025-2026.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	Q	R	S	T	U	V	Z	AA	AB	AC	AD	AE	AF
1	A) Initial situation with current data													C) Forecasted results in 12 months						D) Forecasted results in 12 months with various price
2	LQ $ Price	1.7		LQ max. LTV	70.00%									LQ $ Price	1.7		LQ max. LTV	70.00%
3	Date	7/1/2025															Forecasted				LQ $ Price	2		LQ max. LTV	80.00%
4	LQ Collateral		Debt		HealthFactor									LQ Collateral		Debt future		HealthFactor			LQ Collateral		Debt future		HealthFactor
5	Tokens	USD	Tokens	USD										Tokens	USD	Tokens	USD		individual collateral is also rebalanced		Tokens	USD	Tokens	USD		individual collateral is also rebalanced
6	1,097,770	1,866,209	USDC	775,230	1.69									1,097,770	1,866,209	USDC	1,023,149	1.28			5,793,550	11,587,100	USDC	2,327,954
7	4,499,000	7,648,300	USDC	1,660,000	3.23									4,499,000	7,648,300	USDC	2,190,868	2.44			5,793,550	11,587,100	USDC	2,327,954
8	840,330	1,428,561	USDM	280,330	3.57									840,330	1,428,561	USDM	347,049	2.88			995,840	1,991,680	USDA	2,327,954
9	3,650,000	6,205,000	DJED	1,150,000	3.78									3,650,000	6,205,000	DJED	1,460,730	2.97			11,587,100	23,174,200		6,983,863	2.65
10	1,500,000	2,550,000	USDT	247,070	7.22									1,500,000	2,550,000	USDT	328,158	5.44
11	995,840	1,692,928	USDA	250,000	4.74									995,840	1,692,928	USDA	1,588,785	0.75
12	12,582,940	21,390,998		4,362,630	3.43									12,582,940	21,390,998		6,938,738	2.16
13	59.9%																				LQ $ Price	3		LQ max. LTV	80.00%
14														59.9%	of the total LQ supply in added as collateral						LQ Collateral		Debt future		HealthFactor
15																					Tokens	USD	Tokens	USD		individual collateral is also rebalanced
16	B) Simulation on the debt development over the next 12 months																				5,793,550	17,380,650	USDC	2,327,954
17														Simulation with Rebalancing and higher LTV							5,793,550	17,380,650	USDC	2,327,954
18	1. Current Debt amounts actualized with the current Interests rates						2. Current Debt amounts actualized with the current Interests rates (after rebalancing of the debt tokens)							Scenario: Debt only in USDM and USDA AND with lower interest rates							995,840	2,987,520	USDA	2,327,954
19	Tokens	Borrow APY	Debt	After12M	Increase		Tokens	Borrow APY	Debt	After12M	Increase			LQ $ Price	1.7		LQ max. LTV	80.00%			11,587,100	34,761,300		6,983,863	3.98
20	USDC	31.98%	775,230	1,023,149	247,919		USDM	23.80%	2,056,315	2,545,718	489,403						Forecasted
21	USDC	31.98%	1,660,000	2,190,868	530,868		USDA	23.80%	2,056,315	2,545,718	489,403			LQ Collateral		Debt future		HealthFactor			LQ $ Price	0.75		LQ max. LTV	80.00%
22	USDM	23.80%	280,330	347,049	66,719		USDA	13.21%	250,000	1,588,785				Tokens	USD	Tokens	USD		individual collateral is also rebalanced		LQ Collateral		Debt future		HealthFactor
23	DJED	27.02%	1,150,000	1,460,730	310,730				4,362,630	6,680,221				5,793,550	9,849,035	USDC	2,327,954				Tokens	USD	Tokens	USD
24	USDT	32.82%	247,070	328,158	81,088									5,793,550	9,849,035	USDC	2,327,954				5,793,550	4,345,163	USDC	2,327,954
25	USDA	13.21%	250,000	1,588,785										995,840	1,692,928	USDA	1,588,785				5,793,550	4,345,163	USDC	2,327,954
26			4,362,630	6,938,738	1,237,323		Current Debt amounts actualized with the current Interests rates (with a lower rates)							11,587,100	19,698,070		6,244,693	2.52			995,840	746,880	USDA	2,327,954
27							Tokens	Borrow APY	Debt	After12M	Increase										11,587,100	8,690,325		6,983,863	1.00
28							USDM	13.21%	2,056,315	2,327,954	271,639
29							USDA	13.21%	2,056,315	2,327,954	271,639
30							USDA	13.21%	250,000	1,588,785
31									4,362,630	6,244,693
32																					Summary
33																					LQ $price	Health Factor
34																					0.75	1.00
35																					1.7	2.52
36																					2	2.65
37																					3	3.98
38
39																				Summary:
40	Amount per month	1	2	3	4	5	6	7	8	9	10	11	12							This analysis does not include any debt repayments
41	Borrow USDA	125,000	251,299	378,911	507,849	638,127	769,759	902,760	1,037,142	1,172,921	1,310,112	1,448,728	1,588,785							and is based on high interest rates.
42																				-> This is a conservative risk model
43
44	Monthy	125,000
45	Int. Monthy	13.21%
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