EJERCICIO
EJERCICIO
EJERCICIO
TIEMPO 10
FRECUENCIA 1
TASA CUPON 9.00%
YTM 7.00%
VA CUPON 1800
VA $ 22,809.43
CONVEXIDAD DE UN BONO
CONVEXIDAD 32.72983
CONVEXIDAD*INCREMENTO YTM^2/2
DURA.MOD 4.62249629808
Valor espera #REF!
Riesgo #REF!
Var #REF!
Date RENTAB_A RENTAB_B RENTAB_C
2/1/2019 -0.01118356031 -0.0133097894 0.01064295961
3/1/2019 0.02841865121 0.0418571331 -0.01712864324
4/1/2019 -0.13795001046 -0.1266579703 -0.06703623921
5/1/2019 0.03003568081 0.05959080425 -0.0283454097
6/1/2019 -0.051312712 -0.0487201426 -0.1012795894
7/1/2019 0.03360072691 0.03664635545 0.03448024568
8/1/2019 0.04009520349 0.10951389695 -0.04772290463
9/1/2019 -0.00018285852 0.00191866619 0.01971183412
10/1/2019 0.05574131951 0.04562819794 0.05953734361
11/1/2019 -0.06029900074 0.02777473534 -0.13737663835
12/1/2019 0.05500325128 0.0903458106 0.02984276974
1/1/2020 0.01589799007 -0.0122498541 0.08323964828
2/1/2020 -0.0695932045 -0.0442587861 0.07572595945
3/1/2020 0.02348119602 0.00958660592 0.03347655925
4/1/2020 0.01441976798 0.04051687563 -0.01282478787
5/1/2020 0.07796164816 0.07966189159 0.02471959324
6/1/2020 0.10702476355 0.0562664513 0.06891660158
7/1/2020 -0.0593574146 -0.028441533 -0.0138313807
8/1/2020 -0.09862772506 -0.1035069674 -0.12044385526
9/1/2020 -0.46714753136 -0.3522065026 -0.00796960246
10/1/2020 0.16086820683 0.1038793954 0.09734318715
11/1/2020 -0.02101553446 0.04645408595 -0.00290508488
12/1/2020 -0.09116200805 -0.0767594336 0.02016944629
1/1/2021 -0.04660520338 0.02154975659 0.0433982112
2/1/2021 0.16286265746 0.18564718232 0.02744989757
3/1/2021 -0.05681489155 -0.0573928549 -0.08523859984
4/1/2021 0.03262661076 0.02876644786 -0.02667235669
5/1/2021 0.26637396339 0.16565140901 0.01608872288
6/1/2021 0.0311883791 0.07104306114 -0.01761892826
7/1/2021 -0.12294774845 -0.092895392 -0.05431738263
8/1/2021 0.292278409 0.19872317023 -0.02108935173
9/1/2021 -0.06154883908 -0.0225685226 0.09245480585
10/1/2021 -0.00448400734 0.06235497889 -0.00407352022
11/1/2021 -0.05300164432 -0.0270127244 0.04801179015
12/1/2021 -0.00565119709 -0.0378262949 -0.00898242386
1/1/2022 0.02831758256 0.08598153542 -0.01519330272
2/1/2022 -0.08189117308 -0.0514334633 -0.00347829037
3/1/2022 0.04659411458 0.05644170875 0.02150315634
4/1/2022 0.09989818761 0.08583119724 -0.04185226581
5/1/2022 -0.07846922907 -0.06367289 -0.00195949632
6/1/2022 0.19677381927 0.14399871522 0.06072617553
7/1/2022 -0.0457655843 -0.0722997211 -0.02228949364
8/1/2022 0.05830395391 0.02551413549 0.01481042976
9/1/2022 -0.01724190292 0.01916232251 0.01743493912
10/1/2022 -0.00514677309 0.02312579882 0.0603234616
11/1/2022 -0.07169692589 -0.0975278217 0.01794035768
12/1/2022 -0.1789106318 -0.233140944 0.03102612666
1/1/2023 0.11297586449 0.13909070646 0.03552626878
2/1/2023 0.07975452476 -0.005559315 -0.01609208071
3/1/2023 -0.1016233472 -0.0532467029 -0.03517226512
4/1/2023 0.15157113883 0.11455359901 0.09783881974
5/1/2023 0.06283873208 0.05298499731 -0.05169081423
6/1/2023 -0.10356789213 -0.119901534 -0.01553728675
7/1/2023 0.18765105007 0.1382192033 -0.03805339908
8/1/2023 0.06320877796 -0.0040054235 -0.03925574368
9/1/2023 -0.03903488702 -0.0244747416 0.02412796473
10/1/2023 0.02220448777 0.02211473205 0.04110867275
11/1/2023 -0.06152178751 -0.0564154501 -0.04395028156
12/1/2023 0.04897121897 0.03392070208 -0.00358461993
ponderación 0% 100% 0%
AÑO7 AÑO8
302,000 328,000
ER EN CAJA = 30% DEL PC
AÑO AÑO1 AÑO2 AÑO3 AV-01 AV-02 AV-03
Caja 27,000 16,150 47,500 9.37% 5.23% 13.15%
CxC 17,900 30,550 28,250 6.21% 9.89% 7.82%
Inventarios 17,200 28,300 35,300 5.97% 9.16% 9.77%
AC 62,100 75,000 111,050 21.56% 24.27% 30.74%
ANC 226,000 234,050 250,180 78.44% 75.73% 69.26%
ACTIVO 288,100 309,050 361,230 100.00% 100.00% 100.00%
DF CP 8,700 8,500 13,100 3.02% 2.75% 3.63%
CxP 26,300 35,500 44,020 9.13% 11.49% 12.19%
PC 35,000 44,000 57,120 12.15% 14.24% 15.81%
PNC 96,100 90,000 92,600 33.36% 29.12% 25.63%
PASIVO 131,100 134,000 149,720 45.51% 43.36% 41.45%
PATRIMONIO 157,000 175,050 211,510 54.49% 56.64% 58.55%
AÑO7 AÑO8
302,000 328,000
ER EN CAJA = 30% DEL PC
INGRESOS
1 146,000 146,000 146,000
2 172,000 172,000 18% 172,000
3 198,000 198,000 15% 198,000
4 224000 $ 237,600 20% 258400
5 250000 $ 287,496 21% 318800
6 276000 $ 350,745 22% 379200
7 302000 $ 431,416 23% 439600
8 328000 $ 534,956 24% 500000
LAUREL HARDY
TASA CUPÓN 8% 8%
FRECUENCIA 2 2 SEMESTRAL
VENCIMIENT 2 15 AÑOS
VALOR NOMI 1000 1000
VALOR CUPÓ 40 40
AUMENTO 10.00% 10.00%
% DEVENGAD 0.66483516
%NODEV 0.33516484
INTERES 30.4361538 VA CUPON *INTRES DEV
PRECIO 70 70
CUPON 90 50
BALANCE GENERAL
AÑO 0 AÑO 1 AÑO 2 AÑO 3
DEUDA FINANCIERA 2023 2745 2950 2078
FONDOS PROPIOS 4534 4923 5328 5897
INVERSIONES ACT. FIJOS 1055 1890 1950 1992
INVERSIONES NETAS DE CIRCULANTE NOF 5 5 5 5
DIVIDENDOS 476 501 672 739
AÑO 4
2346
6370
2231
5
784
PER1 21
PER2 33.25
4840 PER3 36.25
2346
7186
AÑO 4
0.966
0.971
0.162
0.469
1.529