Tiempo (meses) Tasa (q) BND Log (q) Tiempo (dias) Np (Bn) 1/q D

0.5 660 2.8195439 15 9900 0.00151515 0.1019992

1.5 596 2.7752463 45 36720 0.00167785 0.0289382
2.5 579 2.7626786 75 80145 0.00172712 0.1017210
3.5 523 2.7185017 105 135060 0.00191205 -0.0151806
4.5 531 2.7250945 135 206745 0.00188324 0.2321292
5.5 421 2.6242821 165 276210 0.00237530 0.0047619
6.5 419 2.6222140 195 357915 0.00238663 0.0217138
7.5 410 2.6127839 225 450165 0.00243902 -0.1063356
8.5 456 2.6589648 255 566445 0.00219298 0.1770722
9.5 382 2.5820634 285 675315 0.00261780 -0.0584665
10.5 405 2.6074550 315 802890 0.00246914 0.0532445
11.5 384 2.5843312 345 935370 0.00260417 0.0534887
12.5 364 2.5611014 375 1071870 0.00274725 -0.0054795
13.5 366 2.5634811 405 1220100 0.00273224 0.1249810
14.5 323 2.5092025 435 1360605 0.00309598 -

700
Log q vs. t 600 q
2.8500000 500
2.8000000 400
2.7500000
300
2.7000000
2.6500000 Log q vs. t 200
2.6000000 100
2.5500000
0
2.5000000 0
2.4500000
2.4000000
2.3500000
0 2 4 6 8 10 12 14 16

Log q vs. Np
2.8500000
2.8000000 800
2.7500000
700
2.7000000
2.6500000 600
2.6000000 Log q vs. Np
500
2.5500000
2.5000000 400
2.4500000
2.4000000 300
2.3500000 200
0 0 0 0 0 0 0 0 0
0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 100
20 40 60 80 10
0
12
0
14
0
16
0
0
0 2 4 6

1/q vs. t
0.00350000

0.00300000

0.00250000
 1/q vs. t
0.00350000

0.00300000

0.00250000

0.00200000

0.00150000

0.00100000

0.00050000

0.00000000
0.0000000 2.0000000 4.0000000 6.0000000 8.0000000 10.0000000 12.0000000 14.0000000
 1/D Tiempo (meses)
9.8040015
34.5564120
9.8308104 1/D vs. t
-65.8737350
10.0000000
4.3079460 4.5
9.0000000
209.9996032
8.0000000
46.0537461
7.0000000
-9.4041838
6.0000000 1/D vs. t
5.6474139 8.5
5.0000000
-17.1038237
4.0000000
18.7812775
3.0000000
18.6955428
2.0000000
-182.4995434
1.0000000
8.0012155 13.5
0.0000000
- 4 5 6 7 8 9 10 11 12 13 14

700
600 q vs. Np
500
400
300
200 q vs. Np
100
0
0 500000 1000000 1500000

q vs. t

q vs. t

0 2 4 6 8 10 12 14 16
 1/q vs. t

12.0000000 14.0000000 16.0000000

Tiempo (meses) Tasa (q) BND Log (q) Log t D
0 350 2.5440680 -
1 345 2.5378191 0.000000
2 340 2.5314789 0.301030
3 335 2.5250448 0.477121
4 330 2.5185139 0.602060
5 325 2.5118834 0.698970
6 320 2.5051500 0.778151
7 315 2.4983106 0.845098
8 310 2.4913617 0.903090
9 306 2.4857214 0.954243
10 301 2.4785665 1.000000
11 297 2.4727564 1.041393
12 292 2.4653829 1.079181
13 288 2.4593925 1.113943
14 284 2.4533183 1.146128

q vs. t Log(q
400 2.5600000
350 2.5400000
300 2.5200000
250 2.5000000
q vs. t
200 2.4800000
150
2.4600000
100
2.4400000
50
2.4200000
0
0 2 4 6 8 10 12 14 16 2.4000000
0 2 4 6 8

Log q vs. Log t

2.5600000
2.5400000
2.5200000
2.5000000
Log q vs. Log t
2.4800000
2.4600000
2.4400000
2.4200000
2.4000000
0.000000 0.200000 0.400000 0.600000 0.800000 1.000000 1.200000 1.400000
2.4600000
2.4400000
2.4200000
2.4000000
0.000000 0.200000 0.400000 0.600000 0.800000 1.000000 1.200000 1.400000
 Log(q) vs. t
600000
400000
200000
000000
Log(q) vs. t
800000
600000
400000
200000
000000
0 2 4 6 8 10 12 14 16

Log q vs. Log t

tiempo (años) tasa (q) Log (q) Δq/Δt*q tiempo (dias) tiempo (meses)tiempo (años)
0.1 9.63 0.9836263 - 36.5 1.2 0.1
0.2 9.29 0.9680157 0.0304987 73.0 2.4 0.2
0.3 8.98 0.9532763 0.0287676 109.5 3.6 0.3
0.4 8.68 0.9385197 0.0288018 146.0 4.8 0.4
0.5 8.4 0.9242793 0.0277778 182.5 6 0.5
0.6 8.14 0.9106244 0.0266175 219.0 7.2 0.6
0.7 7.9 0.8976271 0.0253165 255.5 8.4 0.7
0.8 7.67 0.8847954 0.0249891 292.0 9.6 0.8
0.9 7.45 0.8721563 0.0246085 328.5 10.8 0.9
1 7.25 0.8603380 0.0229885 365.0 12 1
1.1 7.05 0.8481891 0.0236407 401.5 13.2 1.1
1.2 6.87 0.8369567 0.0218341 438.0 14.4 1.2
1.3 6.69 0.8254261 0.0224215 474.5 15.6 1.3
1.4 6.53 0.8149132 0.0204186 511.0 16.8 1.4
1.5 6.37 0.8041394 0.0209314 547.5 18 1.5
1.6 6.22 0.7937904 0.0200965 584.0 19.2 1.6
1.7 6.08 0.7839036 0.0191886 620.5 20.4 1.7
1.8 5.94 0.7737864 0.0196409 657.0 21.6 1.8
1.9 5.81 0.7641761 0.0186460 693.5 22.8 1.9
2 5.68 0.7543483 0.0190728 730.0 24 2
2.1 5.56 0.7450748 0.0179856 766.5 25.2 2.1
2.2 5.45 0.7363965 0.0168196 803.0 26.4 2.2
2.3 5.34 0.7275413 0.0171660 839.5 27.6 2.3
2.4 5.23 0.7185017 0.0175271 876.0 28.8 2.4
2.5 5.13 0.7101174 0.0162443 912.5 30 2.5
2.6 5.03 0.7015680 0.0165673 949.0 31.2 2.6
2.7 4.94 0.6937269 0.0151822 985.5 32.4 2.7
2.8 4.84 0.6848454 0.0172176 1022.0 33.6 2.8
2.9 4.76 0.6776070 0.0140056 1058.5 34.8 2.9
3 4.67 0.6693169 0.0160600 1095.0 36 3
3.1 4.59 0.6618127 0.0145243 1131.5 37.2 3.1
3.2 4.51 0.6541765 0.0147820 1168.0 38.4 3.2
3.3 4.44 0.6473830 0.0131381 1204.5 39.6 3.3
3.4 4.36 0.6394865 0.0152905 1241.0 40.8 3.4
tasa (q) Np (MBn)
9.63 0.53
9.29 0.93
8.98 1.13 Log(q) vs. t
8.68 1.59 1.2000000
8.4 1.99
8.14 2.30 1.0000000
7.9 2.47
0.8000000
7.67 2.74
7.45 3.08 0.6000000
7.25 3.17
7.05 3.58 0.4000000
6.87 3.67
0.2000000
6.69 4.05
6.53 4.05 0.0000000
6.37 4.30 0 0.5 1 1.5 2 2.5 3
6.22 4.46
6.08 4.50
5.94 4.77 q vs. t
5.81 4.88 12
5.68 5.21
5.56 5.35 10
5.45 5.28
8
5.34 5.39
5.23 5.68 6
5.13 5.72
5.03 5.92 4
4.94 5.84
2
4.84 6.36
4.76 6.12 0
4.67 6.48 0 0.5 1 1.5 2 2.5 3 3
4.59 6.50
4.51 6.66
4.44 6.45 -Δq/Δt*q vs. q
4.36 6.86
148.04 0.0350000

0.0300000

0.0250000

0.0200000

0.0150000

0.0100000

0.0050000

0.0000000
4 5 6 7 8 9
 0.0050000

0.0000000
4 5 6 7 8 9

q vs. t
12

10

6 q vs. t

0
0 1 2 3 4 5 6 7 8 9 10
Log(q) vs. t

Log(q) vs. t

2 2.5 3 3.5 4

q vs. t

q vs. t

2 2.5 3 3.5 4

q vs. q

-Δq/Δt*q vs. q

8 9 10
 8 9 10

q vs. t

0
tiempo (años) tasa (q) Log (q) Δq/Δt*q tiempo (dias) Np
0.1 9.63 0.9836263 - 36.5 351.495
0.2 9.28 0.9675480 0.00103330 73 1028.935 -
0.3 8.95 0.9518230 0.00101018 109.5 2008.960 0.00120000
0.4 8.64 0.9365137 0.00098300 146 3270.400
0.5 8.35 0.9216865 0.00095152 182.5 4794.275 0.00100000
0.6 8.07 0.9068735 0.00095059 219 6561.605
0.00080000
0.7 7.81 0.8926510 0.00091207 255.5 8557.060
0.8 7.55 0.8779470 0.00094348 292 10761.660 0.00060000
0.9 7.32 0.8645111 0.00086084 328.5 13166.280
1 7.09 0.8506462 0.00088877 365 15754.130 0.00040000
1.1 6.87 0.8369567 0.00087735 401.5 18512.435
0.00020000
1.2 6.67 0.8241258 0.00082151 438 21433.895
1.3 6.47 0.8109043 0.00084690 474.5 24503.910 0.00000000
1.4 6.28 0.7979596 0.00082890 511 27712.990 3 4 5
1.5 6.1 0.7853298 0.00080844 547.5 31052.740
1.6 5.93 0.7730547 0.00078542 584 34515.860
1.7 5.77 0.7611758 0.00075972 620.5 38096.145 Log(
1.8 5.61 0.7489629 0.00078138 657 41781.915
12
1.9 5.46 0.7371926 0.00075267 693.5 45568.425
2 5.32 0.7259116 0.00072098 730 49452.025 10
2.1 5.18 0.7143298 0.00074047 766.5 53422.495
2.2 5.05 0.7032914 0.00070528 803 57477.645 8
2.3 4.92 0.6919651 0.00072391 839.5 61607.985
6
2.4 4.8 0.6812412 0.00068493 876 65812.785
2.5 4.68 0.6702459 0.00070249 912.5 70083.285 4
2.6 4.57 0.6599162 0.00065945 949 74420.215
2.7 4.46 0.6493349 0.00067572 985.5 78815.545 2
2.8 4.35 0.6384893 0.00069280 1022 83261.245
0
2.9 4.25 0.6283889 0.00064464 1058.5 87759.870 0 0.5 1 1.5 2
3 4.15 0.6180481 0.00066017 1095 92304.120
3.1 4.06 0.6085260 0.00060733 1131.5 96898.010
3.2 3.97 0.5987905 0.00062110 1168 101534.970
3.3 3.88 0.5888317 0.00063550 1204.5 106208.430
12
3.4 3.8 0.5797836 0.00057678 1241 110924.230
10

0
0 2 4
2

0
0 2 4
 -Δq/Δt*q vs. q
0000

0000

0000
-Δq/Δt*q vs. q
0000

0000

0000

0000
3 4 5 6 7 8 9 10

Log(q) vs. t

Log(q) vs. t

0.5 1 1.5 2 2.5 3 3.5 4

q vs. t

q vs. t

2 4 6 8 10 12 14
2 4 6 8 10 12 14
tiempo (años) tasa (q) Δq/Δt*q tiempo (dias) tiempo (meses) Gp (MPCN)
1 904.84 2.9565718 365 12 330266.6
2 818.73 0.0087646 2.9131407 730 24 927939.5
3 740.82 0.0087639 2.8697127 1095 36 1739137.4
4 670.32 0.0087645 2.8262822 1460 48 2717804.6
5 606.53 0.0087643 2.7828523 1825 60 3824721.85
6 548.81 0.0087644 2.7394220 2190 72 5026615.75 0.0100000
7 496.59 0.0087631 2.6959980 2555 84 6295403.2
8 449.33 0.0087649 2.6525654 2920 96 7607446.8 0.0090000
9 406.57 0.0087644 2.6091353 3285 108 8943029.25
10 367.88 0.0087642 2.5657062 3650 120 10285791.3 0.0080000
11 332.87 0.0087647 2.5222747 4015 132 11622264.3
12 301.19 0.0087652 2.4788405 4380 144 12941476.5 0.0070000
13 272.53 0.0087636 2.4354143 4745 156 14234631.4
14 246.6 0.0087625 2.3919931 5110 168 15494757.4 0.0060000
15 223.13 0.0087654 2.3485580 5475 180 16716394.1
16 201.9 0.0087626 2.3051363 5840 192 17895490.1 0.0050000
17 182.68 0.0087676 2.2616910 6205 204 19029019.5 0 100 2
18 165.3 0.0087618 2.2182729 6570 216 20115040.5
19 149.57 0.0087640 2.1748445 6935 228 21152308.5
20 135.34 0.0087619 2.1314262 7300 240 22140290.5
21 122.46 0.0087648 2.0879943 7665 252 23078946.4 3.5000000
22 110.8 0.0087696 2.0445398 8030 264 23968670.4
3.0000000
23 100.26 0.0087606 2.0011277 8395 276 24810353.1
24 90.72 0.0087632 1.9577030 8760 288 25605060.3 2.5000000

2.0000000

1.5000000
q vs. t 1.0000000
1200 0.5000000

0.0000000
1000 0

800

q vs. t
600

400

200

0
0 5 10 15 20 25 30
200

0
0 5 10 15 20 25 30
 -Δq/Δt*q vs. q
0.0100000

0.0090000

0.0080000 -Δq/Δt*q vs. q

0.0070000

0.0060000

0.0050000
0 100 200 300 400 500 600 700 800 900

Log(q) vs. t
3.5000000

3.0000000

2.5000000

2.0000000 Log(q) vs. t

1.5000000

1.0000000

0.5000000

0.0000000
0 10 20 30 40 50 60 70
tiempo (años) tasa (q) Log (q) Δq/Δt*q tiempo (dias)tiempo (meses) Np
1 1810 3.2576786 - 365 12 950000
2 1637 3.2140487 0.00028954 730 24 1815000 -Δ
3 1482 3.1708482 0.00028654 1095 36 2590000 0.0006
4 1341 3.1274288 0.00028807 1460 48 3295000
5 1213 3.0838608 0.00028911 1825 60 3935000 0.0005
6 1098 3.0406023 0.00028695 2190 72 4510000
7 993 2.9969492 0.0002897 2555 84 5035000 0.0004
8 899 2.9537597 0.00028647 2920 96 5505000
9 813 2.9100905 0.00028981 3285 108 5935000 0.0003
10 736 2.8668778 0.00028663 3650 120 6320000
11 666 2.8234742 0.00028796 4015 132 6670000 0.0002
12 602 2.7795965 0.00029127 4380 144 6990000
13 545 2.7363965 0.00028654 4745 156 7275000 0.0001
14 493 2.6928469 0.00028898 5110 168 7535000 0 200 400 600 8
15 446 2.6493349 0.00028872 5475 180 7770000
16 404 2.6063814 0.00028482 5840 192 7980000
17 365 2.5622929 0.00029274 6205 204 8175000
18 331 2.5198280 0.00028142 6570 216 8345000
19 299 2.4756712 0.00029321 6935 228 8505000
3.5000000
20 271 2.4329693 0.00028307 7300 240 8645000
21 245 2.3891661 0.00029075 7665 252 8775000 3.0000000
22 222 2.3463530 0.00028385 8030 264 8890000
2.5000000
23 201 2.3031961 0.00028624 8395 276 8995000
24 181 2.2576786 0.00030273 8760 288 9095000 2.0000000
153535000 1.5000000

1.0000000
q vs. t 0.5000000
2000 0.0000000
1800 0 10 20
1600
1400
1200 q vs. t
1000
800
600
400
200
0
0 5 10 15 20 25 30
 -Δq/Δt*q vs. t
0.0006

0.0005

0.0004 -Δq/Δt*q vs. t

0.0003

0.0002

0.0001
0 200 400 600 800 1000 1200 1400 1600 1800

Log(q) vs. t
3.5000000

3.0000000

2.5000000

2.0000000 Log(q) vs. t

1.5000000

1.0000000

0.5000000

0.0000000
0 10 20 30 40 50 60 70 80