Book1.xlsx

	C	D	E	F	G	H	I	K	L	M	N	O	P
1												100
2		Fecha	Amort.		Cupón	Cupón	Total	Intereses impagos			CANJE
3		31 mar 26		100.00			0.00	Emision	2/28/2025		MR35O
4		30 jun 26		100.00	2.250%	0.56	0.56	Canje	1/31/2026		LECGO
5		30 dic 26		100.00	2.250%	1.13	1.13	Días	337		Similares
6		30 jun 27		100.00	2.250%	1.13	1.13	Tasa	9.75%
7	5.2%	30 dic 27		100.00	2.250%	1.13	1.13	Total	9.13
8		30 jun 28		100.00	2.250%	1.13	1.13
9	5.2%	30 dic 28		100.00	2.250%	1.13	1.13	Capital	100
10		30 jun 29		100.00	2.250%	1.13	1.13	Intereses	9.13
11	5.2%	30 dic 29		100.00	2.250%	1.13	1.13	Total	109.13			1435	TC
12		30 jun 30		100.00	2.250%	1.13	1.13					34000	Px $
13	5.2%	30 dic 30		100.00	3.000%	1.50	1.50	TIR	c/1 VN	Relación	VPN	23.69337979	Px USD
14		30 jun 31		100.00	3.000%	1.50	1.50	15.00%	39.55	1.09	43.16	82.2%
15	7.0%	30 dic 31		100.00	3.000%	1.50	1.50	18.00%	32.42	1.09	35.38	49.3%
16		30 jun 32		100.00	3.000%	1.50	1.50	20.00%	28.58	1.09	31.19	31.6%
17	7.0%	30 dic 32		100.00	3.000%	1.50	1.50
18		30 jun 33		100.00	3.000%	1.50	1.50
19	7.0%	30 dic 33	5.00	95.00	3.000%	1.50	6.50
20		30 jun 34	10.00	85.00	3.000%	1.43	11.43
21	6.6%	30 dic 34	10.00	75.00	4.000%	1.70	11.70
22		30 jun 35	10.00	65.00	4.000%	1.50	11.50
23	7.0%	30 dic 35	10.00	55.00	4.000%	1.30	11.30
24		30 jun 36	55.00	0.00	4.000%	1.10	56.10
25			100.00			27.09	127.09
26
27
28
29
30
31
32
33
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