Embed Size (px)
DESCRIPTION
Tasa equivalente en excel
Citation preview
Tasa 1 7Plazo 1 28 63 9.11702951Palzo 2 91Tasa 2 8.5
Tasa equivalente 7.0430 %
Tasa forward 63 9.117029506 %47
Tasa equivalente 47 9.0987 %
Tasa alambrada 75 8.34621642 %
Tasa 1 7 Tasa 2 7Plazo 1 28 Plazo 2 91
Tasa Forward 63 6.96209526 2847
Tasa equivalente 47 6.9514 6391
Tasa alambrada 47 6.99324757
Plazo 3 75 63 6.96209526Tasa 3 - 47
76.993247576.96209526
7
20 30 40 50 60 70 80 90 1006.94
6.95
6.96
6.97
6.98
6.99
7
7.01
Column H
28 747 6.9932475791 7
20 30 40 50 60 70 80 90 1006.94
6.95
6.96
6.97
6.98
6.99
7
7.01
Column H
20 30 40 50 60 70 80 90 1006.988
6.99
6.992
6.994
6.996
6.998
7
7.002
Column R
20 30 40 50 60 70 80 90 1006.988
6.99
6.992
6.994
6.996
6.998
7
7.002
Column R
Tasa 1 7 Tasa 2 7Plazo 1 28 Plazo 2 91
Tasa 75 7
20 30 40 50 60 70 80 90 1000
1
2
3
4
5
6
7
8
Column I
Plazo 3 75Tasa 3 7
28 775 791 7
20 30 40 50 60 70 80 90 1000
1
2
3
4
5
6
7
8
Column I
Plazo 28 91 182 3602.97 2.9777 2.9889 3.0110
3.0916 3.1 3.1121 3.13613.1783 3.1872 3.2 3.22533.4447 3.4551 3.4702 3.5
