| Fecha | Valor Residual | Cap.Actualizado | Interes | Capital | Cupon |
|---|---|---|---|---|---|
| 2023-09-30 | 100.00 | 68125.00 | 1864.92 | 0.00 | 1864.92 |
| 2023-12-30 | 100.00 | 98169.00 | 2687.38 | 0.00 | 2687.38 |
| 2024-03-30 | 100.00 | 101535.00 | 2779.52 | 0.00 | 2779.52 |
| 2024-06-30 | 100.00 | 133409.00 | 3652.07 | 0.00 | 3652.07 |
| 2024-09-30 | 100.00 | 121470.00 | 3325.24 | 0.00 | 3325.24 |
| 2024-12-30 | 100.00 | 107582.00 | 2945.06 | 0.00 | 2945.06 |
| 2025-03-30 | 100.00 | 107582.00 | 2945.06 | 0.00 | 2945.06 |
| 2025-06-30 | 100.00 | 107582.00 | 2945.06 | 0.00 | 2945.06 |
| 2025-09-30 | 100.00 | 107582.00 | 2945.06 | 0.00 | 2945.06 |
| 2025-12-30 | 100.00 | 107582.00 | 2945.06 | 0.00 | 2945.06 |
| 2026-03-30 | 100.00 | 107582.00 | 2945.06 | 0.00 | 2945.06 |
| 2026-06-30 | 0.00 | 0.00 | 2945.06 | 107582.00 | 110527.06 |
| Datos | |||||
|---|---|---|---|---|---|
| Simbolo | MTCGO | Valor Tecnico | 109218.14 | Semana TIR | 3.62% |
| Emisor | Mastellone Hermanos S.A.Mastellone Hermanos S.A. | Valor Residual | 100.00% | Mes TIR | 0.96% |
| Tipo | Corporativo | Paridad | 107.21% | Semestre TIR | -18.10% |
| País | Argentina | TIR | 6.29% | 1ero Enero TIR | -49.17% |
| Mercado | BYMA | Macaulay Dur. | 1.48 | Año TIR | -39.89% |
| Moneda | ARS | Modified Dur. | 1.40 | Semana Precio | -4.04% |
| Fecha/Hora | 2024-11-20 17:00:24 | Effective Dur. | 0.09 | Mes Precio | -6.84% |
| Volumen | 218548 | Convexidad | 3.37 | Semestre Precio | 0.52% |
| Precio | 117090.00 | Int. Corrido | 1636.14 | 1ero Enero Precio | 18.32% |
| Variación | -0.69% | Cupon | 2945.06 | Año Precio | 29.96% |
| Sensibilidad Precio | |||
|---|---|---|---|
| Precio | Variación Precio | TIR | Variación TIR |
| 128799.00 | 10.00% | -0.31 | -104.97% |
| 127628.10 | 9.00% | 0.30 | -95.24% |
| 126457.20 | 8.00% | 0.92 | -85.35% |
| 125286.30 | 7.00% | 1.55 | -75.28% |
| 124115.40 | 6.00% | 2.20 | -65.07% |
| 122944.50 | 5.00% | 2.85 | -54.68% |
| 121773.60 | 4.00% | 3.51 | -44.12% |
| 120602.70 | 3.00% | 4.19 | -33.39% |
| 119431.80 | 2.00% | 4.88 | -22.48% |
| 118260.90 | 1.00% | 5.57 | -11.38% |
| 117090.00 | 0.00% | 6.29 | 0.00% |
| 115919.10 | -1.00% | 7.01 | 11.41% |
| 114748.20 | -2.00% | 7.74 | 23.11% |
| 113577.30 | -3.00% | 8.49 | 35.02% |
| 112406.40 | -4.00% | 9.25 | 47.13% |
| 111235.50 | -5.00% | 10.03 | 59.47% |
| 110064.60 | -6.00% | 10.82 | 72.03% |
| 108893.70 | -7.00% | 11.63 | 84.84% |
| 107722.80 | -8.00% | 12.45 | 97.88% |
| 106551.90 | -9.00% | 13.28 | 111.17% |
| 105381.00 | -10.00% | 14.13 | 124.72% |
| Sensibilidad TIR | |||
|---|---|---|---|
| TIR | Variación TIR | Precio | Variación Precio |
| 6.86 | 9.00% | 116162.79 | -0.79% |
| 6.79 | 8.00% | 116264.25 | -0.71% |
| 6.73 | 7.00% | 116365.85 | -0.62% |
| 6.67 | 6.00% | 116467.61 | -0.53% |
| 6.60 | 5.00% | 116569.52 | -0.44% |
| 6.54 | 4.00% | 116671.59 | -0.36% |
| 6.48 | 3.00% | 116773.81 | -0.27% |
| 6.42 | 2.00% | 116876.18 | -0.18% |
| 6.35 | 1.00% | 116978.72 | -0.10% |
| 6.29 | 0.00% | 117090.00 | 0.00% |
| 6.23 | -1.00% | 117184.25 | 0.08% |
| 6.16 | -2.00% | 117287.25 | 0.17% |
| 6.10 | -3.00% | 117390.40 | 0.26% |
| 6.04 | -4.00% | 117493.72 | 0.34% |
| 5.98 | -5.00% | 117597.19 | 0.43% |
| 5.91 | -6.00% | 117700.82 | 0.52% |
| 5.85 | -7.00% | 117804.60 | 0.61% |
| 5.79 | -8.00% | 117908.55 | 0.70% |
| 5.72 | -9.00% | 118012.65 | 0.79% |
| Desarrollo TIR 6.29% | ||||
|---|---|---|---|---|
| Fecha | Formula | Operacion | Factor | Tipo |
| 2024-12-30 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(40/360)] | 2925.16 | i |
| 2025-03-30 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(130/360)] | 2880.89 | i |
| 2025-06-30 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(220/360)] | 2837.29 | i |
| 2025-09-30 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(310/360)] | 2794.35 | i |
| 2025-12-30 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(400/360)] | 2752.06 | i |
| 2026-03-30 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(490/360)] | 2710.41 | i |
| 2026-06-30 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(580/360)] | 2669.39 | i |
| 2026-06-30 | [Amortizacion % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [1 x 100.00 x 1075.82]/[(1+6.29)^(580/360)] | 97511.85 | k |
| Desarrollo Interes Corrido | Fecha | Formula | Operacion | Interes Corrido |
|---|---|---|---|
| 2024-11-20 | (TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP x (Dias Corridos / Dias entre Cupones) | (0.1095 x (90/360)) x 1.00 x 1 x 100.00 x 1075.82 x (50/90) | 1636.14 |
| Desarrollo Duracion Macaulay | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Fecha | Per. Ponderados Formula | Per. Pond. Operacion | Periodos Ponderados | Factor Formula | Factor Operacion | Factor | Factor/Precio | Factor/Precio x Num. Periodos | Cap. o Int. | |
| 2024-12-30 | (Dias para cupon / Dias Año) | (40 / 360) | 0.11 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(40/360)] | 2925.18 | 0.02 | 0.00 | i | |
| 2025-03-30 | (Dias para cupon / Dias Año) | (130 / 360) | 0.36 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(130/360)] | 2880.93 | 0.02 | 0.01 | i | |
| 2025-06-30 | (Dias para cupon / Dias Año) | (220 / 360) | 0.61 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(220/360)] | 2837.36 | 0.02 | 0.01 | i | |
| 2025-09-30 | (Dias para cupon / Dias Año) | (310 / 360) | 0.86 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(310/360)] | 2794.45 | 0.02 | 0.02 | i | |
| 2025-12-30 | (Dias para cupon / Dias Año) | (400 / 360) | 1.11 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(400/360)] | 2752.18 | 0.02 | 0.03 | i | |
| 2026-03-30 | (Dias para cupon / Dias Año) | (490 / 360) | 1.36 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(490/360)] | 2710.56 | 0.02 | 0.03 | i | |
| 2026-06-30 | (Dias para cupon / Dias Año) | (580 / 360) | 1.61 | [Amortizacion % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] + [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [1 x 100.00 x 1075.82]/[(1+6.29)^(580/360)]+[(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(580/360)] | 100187.79 | 0.86 | 1.38 | ki | |
| Desarrollo Duracion Macaulay Valor Final | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Formula | Operacion | Duracion Macaulay | |||||||
| Suma Factores | 1.48 | 1.48 | |||||||
| Desarrollo Duracion Modificada | ||
|---|---|---|
| Formula | Operacion | Duracion Modificada |
| (Macaulay Duration)/(1 + TIR) | (1.48)/(1 + 6.29/100) | 1.40 |
| Desarrollo Duracion Efectiva | ||
|---|---|---|
| Formula | Operacion | Duracion Efectiva |
| (P+ - P-)/(2 x Po x ΔTIR) | (116985.82 - 117191.23 )/( 2 x 117090 x 0.01) | 0.09 |
| Desarrollo Convexidad Suma Factores | ||||||||
|---|---|---|---|---|---|---|---|---|
| Fecha | Formula n2+n | Operacion n2+n | Factor n2+n | Formula VAN | Operacion VAN | Factor VAN | Formula n2+n X Factor VAN | Cap. o Int. |
| 2024-12-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (40 / 360) ^ 2 + (40 / 360) | 0.12 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(40/360)] | 2925.18 | 361.13 | i |
| 2025-03-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (130 / 360) ^ 2 + (130 / 360) | 0.49 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(130/360)] | 2880.93 | 1416.01 | i |
| 2025-06-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (220 / 360) ^ 2 + (220 / 360) | 0.98 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(220/360)] | 2837.36 | 2793.58 | i |
| 2025-09-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (310 / 360) ^ 2 + (310 / 360) | 1.60 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(310/360)] | 2794.45 | 4478.45 | i |
| 2025-12-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (400 / 360) ^ 2 + (400 / 360) | 2.35 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(400/360)] | 2752.18 | 6455.74 | i |
| 2026-03-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (490 / 360) ^ 2 + (490 / 360) | 3.21 | [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(490/360)] | 2710.56 | 8711.01 | i |
| 2026-06-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (580 / 360) ^ 2 + (580 / 360) | 4.21 | [Amortizacion % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] + [(TNA x (Dias entre Cupones/Año)) x Valor Residual % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [1 x 100.00 x 1075.82]/[(1+6.29)^(580/360)]+[(0.1095 x (90/360)) x 100.00% x 100.00 x 1075.82]/[(1+6.29)^(580/360)] | 100187.79 | 421468.99 | ki |
| Formula Convexidad Valor Final | ||
|---|---|---|
| Formula | Operacion | Convexidad |
| [[1 / [Precio x ((1 + TIR) ^ 2)] x Suma Factores] | [1 / [117090 x ((1 + 6.2856875000001) ^ 2)]] x 445684.92] | 3.37 |
| F. de Emision | 2021-06-30 | ||
| F. de Vencimiento | 2026-06-30 | ||
| Ajuste | |||
| Dias previos para calculo ajuste o interes | |||
| Capital | Integra al Vencimiento | ||
| Interes | Se devengarán a una tasa del 10,95% anual | ||
| Frecuencia | El 30 de marzo, 30 de junio, 30 de septiembre y 30 de diciembre de cada año, a partir del 30 de septiembre de 2021. | ||
| ISIN | USP6460MAK01 |