| 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 | 116911.00 | 3200.44 | 0.00 | 3200.44 |
| 2025-03-30 | 100.00 | 130269.00 | 3566.11 | 0.00 | 3566.11 |
| 2025-06-30 | 100.00 | 114581.00 | 3136.65 | 0.00 | 3136.65 |
| 2025-09-30 | 100.00 | 114581.00 | 3136.65 | 0.00 | 3136.65 |
| 2025-12-30 | 100.00 | 114581.00 | 3136.65 | 0.00 | 3136.65 |
| 2026-03-30 | 100.00 | 114581.00 | 3136.65 | 0.00 | 3136.65 |
| 2026-06-30 | 0.00 | 0.00 | 3136.65 | 114581.00 | 117717.65 |
| Datos | |||||
|---|---|---|---|---|---|
| Simbolo | MTCGO | Valor Tecnico | 115975.07 | Semana TIR | -4.11% |
| Emisor | Mastellone Hermanos S.A.Mastellone Hermanos S.A. | Valor Residual | 100.00% | Mes TIR | -12.95% |
| Tipo | Corporativo | Paridad | 103.46% | Semestre TIR | 23.71% |
| País | Argentina | TIR | 7.93% | 1ero Enero TIR | 45.50% |
| Mercado | BYMA | Macaulay Dur. | 1.08 | Año TIR | 9.08% |
| Moneda | ARS | Modified Dur. | 1.00 | Semana Precio | -2.45% |
| Fecha/Hora | 2025-05-09 17:00:15 | Effective Dur. | 0.08 | Mes Precio | -14.23% |
| Volumen | 112469 | Convexidad | 1.95 | Semestre Precio | -2.21% |
| Precio | 119990.00 | Int. Corrido | 1394.07 | 1ero Enero Precio | -5.00% |
| Variación | 1.95% | Cupon | 3136.65 | Año Precio | 6.47% |
| Sensibilidad Precio | |||
|---|---|---|---|
| Precio | Variación Precio | TIR | Variación TIR |
| 131989.00 | 10.00% | -1.21 | -115.27% |
| 130789.10 | 9.00% | -0.37 | -104.69% |
| 129589.20 | 8.00% | 0.48 | -93.90% |
| 128389.30 | 7.00% | 1.35 | -82.92% |
| 127189.40 | 6.00% | 2.24 | -71.74% |
| 125989.50 | 5.00% | 3.14 | -60.36% |
| 124789.60 | 4.00% | 4.06 | -48.75% |
| 123589.70 | 3.00% | 5.00 | -36.91% |
| 122389.80 | 2.00% | 5.96 | -24.86% |
| 121189.90 | 1.00% | 6.93 | -12.57% |
| 119990.00 | 0.00% | 7.93 | 0.00% |
| 118790.10 | -1.00% | 8.94 | 12.74% |
| 117590.20 | -2.00% | 9.97 | 25.78% |
| 116390.30 | -3.00% | 11.03 | 39.08% |
| 115190.40 | -4.00% | 12.11 | 52.65% |
| 113990.50 | -5.00% | 13.20 | 66.52% |
| 112790.60 | -6.00% | 14.33 | 80.66% |
| 111590.70 | -7.00% | 15.47 | 95.11% |
| 110390.80 | -8.00% | 16.64 | 109.87% |
| 109190.90 | -9.00% | 17.84 | 124.94% |
| 107991.00 | -10.00% | 19.06 | 140.34% |
| Sensibilidad TIR | |||
|---|---|---|---|
| TIR | Variación TIR | Precio | Variación Precio |
| 8.64 | 9.00% | 119138.13 | -0.71% |
| 8.56 | 8.00% | 119231.69 | -0.63% |
| 8.49 | 7.00% | 119325.41 | -0.55% |
| 8.41 | 6.00% | 119419.26 | -0.48% |
| 8.33 | 5.00% | 119513.26 | -0.40% |
| 8.25 | 4.00% | 119607.41 | -0.32% |
| 8.17 | 3.00% | 119701.71 | -0.24% |
| 8.09 | 2.00% | 119796.15 | -0.16% |
| 8.01 | 1.00% | 119890.73 | -0.08% |
| 7.93 | 0.00% | 119990.00 | 0.00% |
| 7.85 | -1.00% | 120080.35 | 0.08% |
| 7.77 | -2.00% | 120175.38 | 0.15% |
| 7.69 | -3.00% | 120270.55 | 0.23% |
| 7.61 | -4.00% | 120365.88 | 0.31% |
| 7.53 | -5.00% | 120461.35 | 0.39% |
| 7.45 | -6.00% | 120556.98 | 0.47% |
| 7.37 | -7.00% | 120652.75 | 0.55% |
| 7.30 | -8.00% | 120748.67 | 0.63% |
| 7.22 | -9.00% | 120844.75 | 0.71% |
| Desarrollo TIR 7.93% | ||||
|---|---|---|---|---|
| Fecha | Formula | Operacion | Factor | Tipo |
| 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 1145.81]/[(1+7.93)^(50/360)] | 3103.59 | 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 1145.81]/[(1+7.93)^(140/360)] | 3044.94 | 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 1145.81]/[(1+7.93)^(230/360)] | 2987.39 | 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 1145.81]/[(1+7.93)^(320/360)] | 2930.94 | 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 1145.81]/[(1+7.93)^(410/360)] | 2875.55 | i |
| 2026-06-30 | [Amortizacion % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [1 x 100.00 x 1145.81]/[(1+7.93)^(410/360)] | 105043.06 | k |
| Desarrollo Interes Corrido | Fecha | Formula | Operacion | Interes Corrido |
|---|---|---|---|
| 2025-05-10 | (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 1145.81 x (40/90) | 1394.07 |
| 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. | |
| 2025-06-30 | (Dias para cupon / Dias Año) | (50 / 360) | 0.14 | [(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 1145.81]/[(1+7.93)^(50/360)] | 3103.60 | 0.03 | 0.00 | i | |
| 2025-09-30 | (Dias para cupon / Dias Año) | (140 / 360) | 0.39 | [(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 1145.81]/[(1+7.93)^(140/360)] | 3044.97 | 0.03 | 0.01 | i | |
| 2025-12-30 | (Dias para cupon / Dias Año) | (230 / 360) | 0.64 | [(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 1145.81]/[(1+7.93)^(230/360)] | 2987.45 | 0.02 | 0.02 | i | |
| 2026-03-30 | (Dias para cupon / Dias Año) | (320 / 360) | 0.89 | [(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 1145.81]/[(1+7.93)^(320/360)] | 2931.02 | 0.02 | 0.02 | i | |
| 2026-06-30 | (Dias para cupon / Dias Año) | (410 / 360) | 1.14 | [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 1145.81]/[(1+7.93)^(410/360)]+[(0.1095 x (90/360)) x 100.00% x 100.00 x 1145.81]/[(1+7.93)^(410/360)] | 107922.38 | 0.90 | 1.02 | ki | |
| Desarrollo Duracion Macaulay Valor Final | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Formula | Operacion | Duracion Macaulay | |||||||
| Suma Factores | 1.08 | 1.08 | |||||||
| Desarrollo Duracion Modificada | ||
|---|---|---|
| Formula | Operacion | Duracion Modificada |
| (Macaulay Duration)/(1 + TIR) | (1.08)/(1 + 7.93/100) | 1.00 |
| Desarrollo Duracion Efectiva | ||
|---|---|---|
| Formula | Operacion | Duracion Efectiva |
| (P+ - P-)/(2 x Po x ΔTIR) | (119894.73 - 120084.27 )/( 2 x 119990 x 0.01) | 0.08 |
| 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. |
| 2025-06-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (50 / 360) ^ 2 + (50 / 360) | 0.16 | [(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 1145.81]/[(1+7.93)^(50/360)] | 3103.60 | 490.92 | i |
| 2025-09-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (140 / 360) ^ 2 + (140 / 360) | 0.54 | [(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 1145.81]/[(1+7.93)^(140/360)] | 3044.97 | 1644.66 | i |
| 2025-12-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (230 / 360) ^ 2 + (230 / 360) | 1.05 | [(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 1145.81]/[(1+7.93)^(230/360)] | 2987.45 | 3128.07 | i |
| 2026-03-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (320 / 360) ^ 2 + (320 / 360) | 1.68 | [(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 1145.81]/[(1+7.93)^(320/360)] | 2931.02 | 4921.22 | i |
| 2026-06-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (410 / 360) ^ 2 + (410 / 360) | 2.44 | [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 1145.81]/[(1+7.93)^(410/360)]+[(0.1095 x (90/360)) x 100.00% x 100.00 x 1145.81]/[(1+7.93)^(410/360)] | 107922.38 | 262894.26 | ki |
| Formula Convexidad Valor Final | ||
|---|---|---|
| Formula | Operacion | Convexidad |
| [[1 / [Precio x ((1 + TIR) ^ 2)] x Suma Factores] | [1 / [119990 x ((1 + 7.9266875000001) ^ 2)]] x 273079.13] | 1.95 |
| 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 |