ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
Analisis de oportunidades de inversiónIntroduciendo valores en las casillas naranjas podemos jugar con las diferentes opcionesTIR < -10%
2
¡Paciencia! El resto de casillas NO TOCAR-10%<TIR<0%
3
Puede tardar unos 40-50 segundos en cargar los valores0%<TIR<7%
4
TIR anual objetivo10,00%7%<TIR<12%
5
Euribor3m medio2,00%TIR>12%
6
Todos los precios son limpios, no cuentan cupón corridoPrecio objetivoTIR anualizada si... (usando Interés actual)
7
ISINEmisorFecha amortización finalPróximo Put/CallÚltimo Precio negociado HOY (Ph) o mejor oferta de VENTAÚltimo Precio de cierreFecha último precioDías hasta próximo cupónCupón corrido hasta hoyFecha compra (Fc)Precio compra (Pc)Fecha venta (Fv)Precio venta (Pv)Precio al que debería comprar HOY para tener TIR anual de la casilla B4, si mantengo hasta el finalCompro hoy (Ph) y mantengo hasta el final (calculado con Euribor3m medio + margen)Compro hoy (Ph) y mantengo hasta el finalCompro hoy (Ph) y vendo (Pv) en FvCompro a Pc en Fc y mantengo hasta el finalCompro a Pc en Fc y vendo a Pv en FvInterés actual Interés basado en Euribor3m medio + margen cuando aplicaMargenInt ReferenciaNº pagos al año
8
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!6-oct-20120,00%18-abr-20200,00%#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
9
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,00%25-abr-2016110,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
10
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201287,88%23-jul-2014101,75%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
11
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201292,39%25-oct-2013100,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
12
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A2-may-201396,51%25-ene-201499,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
13
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201286,70%25-abr-201499,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
14
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201283,70%25-jul-201496,91%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
15
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201294,43%24-oct-2014109,34%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
16
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201290,73%10-jul-2015105,05%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
17
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201290,25%24-abr-2015104,50%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
18
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A16-oct-201281,70%24-jul-201594,60%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
19
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A13-ene-201391,00%30-dic-201595,70%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
20
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A13-ene-201392,00%22-ene-201699,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
21
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-2012100,89%22-abr-2016116,82%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
22
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201261,99%22-jul-201671,78%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
23
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!6-oct-201272,20%18-ago-201783,60%#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
24
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201280,94%20-ene-201793,72%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
25
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201289,64%21-abr-2017103,80%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
26
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,12%21-jul-2017110,14%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
27
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,05%20-oct-2017110,06%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
28
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201294,93%19-ene-2018109,92%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
29
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,03%20-abr-2018110,03%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
30
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,08%20-jul-2018110,09%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
31
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,02%19-oct-2018110,02%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
32
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201297,28%18-ene-2019112,64%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
33
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201290,96%19-abr-2019105,33%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
34
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201294,99%19-jul-2019109,99%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
35
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201287,40%18-oct-2019101,20%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
36
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201270,30%17-ene-202081,40%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
37
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201276,00%17-abr-202088,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
38
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!6-oct-201285,41%17-abr-202098,89%#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
39
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201276,69%17-abr-202088,80%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
40
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201280,66%1-jun-201393,39%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
41
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201285,49%16-abr-202198,99%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
42
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201267,93%16-jul-202178,65%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
43
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,00%15-oct-2021110,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
44
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A15-ago-201236,10%31-dic-204241,80%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
45
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A15-oct-201271,01%31-dic-204282,23%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
46
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201253,20%31-dic-202061,60%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
47
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201270,21%17-jul-202081,29%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
48
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A27-sept-201267,16%1-jun-201377,77%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
49
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201265,13%1-ene-204275,42%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
50
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,00%1-ene-2042110,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
51
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201269,35%1-ene-204280,30%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
52
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201294,97%1-ene-2042109,97%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
53
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!13-ene-201391,00%1-ene-204295,70%#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
54
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A13-ene-201385,00%1-ene-204292,40%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
55
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201293,90%1-ene-2042108,72%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
56
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201294,96%1-ene-2042109,96%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
57
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201284,08%1-ene-204297,35%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
58
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201242,75%1-ene-204249,50%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
59
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201276,50%1-ene-204288,58%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
60
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,00%1-ene-2042110,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
61
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201296,64%1-ene-2042111,90%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
62
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201294,99%1-ene-2042109,99%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
63
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201267,27%1-ene-204277,89%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
64
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,00%1-ene-2042110,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
65
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,00%1-ene-2042110,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
66
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201247,50%1-ene-204255,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
67
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201268,40%1-ene-204279,20%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
68
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!6-oct-201283,60%1-ene-204296,80%#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
69
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201239,90%1-ene-204246,20%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
70
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201234,20%1-ene-204239,60%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
71
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201237,66%1-ene-204243,60%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
72
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201232,72%1-ene-204237,89%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
73
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201293,58%1-ene-2042108,35%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
74
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201243,37%1-ene-204250,22%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
75
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201220,05%1-ene-204223,21%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
76
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201261,08%1-ene-204270,72%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
77
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,31%1-ene-2042110,36%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
78
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A13-dic-201260,50%1-ene-204281,97%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
79
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A11-abr-201489,96%1-ene-204258,30%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
80
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201257,00%1-ene-204266,00%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
81
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,73%1-ene-2042110,84%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
82
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201295,74%1-ene-2042110,86%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
83
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!6-oct-201264,36%1-ene-204274,53%#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
84
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201264,60%1-ene-204274,80%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
85
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201246,55%1-ene-204253,90%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
86
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A6-oct-201264,60%1-ene-204274,80%#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
87
88
89
90
91
92
93
94
95
96
97
98
99
100