| 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 | 112996.00 | 3093.27 | 0.00 | 3093.27 |
| 2025-09-30 | 100.00 | 112996.00 | 3093.27 | 0.00 | 3093.27 |
| 2025-12-30 | 100.00 | 112996.00 | 3093.27 | 0.00 | 3093.27 |
| 2026-03-30 | 100.00 | 112996.00 | 3093.27 | 0.00 | 3093.27 |
| 2026-06-30 | 0.00 | 0.00 | 3093.27 | 112996.00 | 116089.27 |
| Datos | |||||
|---|---|---|---|---|---|
| Simbolo | MTCGO | Valor Tecnico | 114336.42 | Semana TIR | -3.02% |
| Emisor | Mastellone Hermanos S.A.Mastellone Hermanos S.A. | Valor Residual | 100.00% | Mes TIR | -0.12% |
| Tipo | Corporativo | Paridad | 103.37% | Semestre TIR | 25.12% |
| País | Argentina | TIR | 8.02% | 1ero Enero TIR | 47.16% |
| Mercado | BYMA | Macaulay Dur. | 1.08 | Año TIR | 8.67% |
| Moneda | ARS | Modified Dur. | 1.00 | Semana Precio | -3.91% |
| Fecha/Hora | 2025-05-09 13:04:45 | Effective Dur. | 0.08 | Mes Precio | -15.76% |
| Volumen | 31055 | Convexidad | 1.96 | Semestre Precio | -3.68% |
| Precio | 118190.00 | Int. Corrido | 1340.42 | 1ero Enero Precio | -6.42% |
| Variación | 0.42% | Cupon | 3093.27 | Año Precio | 4.25% |
| Sensibilidad Precio | |||
|---|---|---|---|
| Precio | Variación Precio | TIR | Variación TIR |
| 130009.00 | 10.00% | -1.10 | -113.43% |
| 128827.10 | 9.00% | -0.26 | -103.20% |
| 127645.20 | 8.00% | 0.59 | -92.77% |
| 126463.30 | 7.00% | 1.46 | -82.16% |
| 125281.40 | 6.00% | 2.35 | -71.34% |
| 124099.50 | 5.00% | 3.25 | -60.34% |
| 122917.60 | 4.00% | 4.17 | -49.11% |
| 121735.70 | 3.00% | 5.10 | -37.67% |
| 120553.80 | 2.00% | 6.06 | -26.02% |
| 119371.90 | 1.00% | 7.03 | -14.14% |
| 118190.00 | 0.00% | 8.02 | 0.00% |
| 117008.10 | -1.00% | 9.04 | 10.33% |
| 115826.20 | -2.00% | 10.07 | 22.93% |
| 114644.30 | -3.00% | 11.12 | 35.79% |
| 113462.40 | -4.00% | 12.20 | 48.91% |
| 112280.50 | -5.00% | 13.29 | 62.30% |
| 111098.60 | -6.00% | 14.41 | 75.98% |
| 109916.70 | -7.00% | 15.56 | 89.95% |
| 108734.80 | -8.00% | 16.72 | 104.20% |
| 107552.90 | -9.00% | 17.92 | 118.78% |
| 106371.00 | -10.00% | 19.14 | 133.66% |
| Sensibilidad TIR | |||
|---|---|---|---|
| TIR | Variación TIR | Precio | Variación Precio |
| 8.93 | 9.00% | 117133.66 | -0.89% |
| 8.85 | 8.00% | 117228.66 | -0.81% |
| 8.76 | 7.00% | 117323.81 | -0.73% |
| 8.68 | 6.00% | 117419.11 | -0.65% |
| 8.60 | 5.00% | 117514.57 | -0.57% |
| 8.52 | 4.00% | 117610.18 | -0.49% |
| 8.44 | 3.00% | 117705.94 | -0.41% |
| 8.35 | 2.00% | 117801.85 | -0.33% |
| 8.27 | 1.00% | 117897.92 | -0.25% |
| 8.11 | -1.00% | 118090.51 | -0.08% |
| 8.03 | -2.00% | 118187.04 | 0.00% |
| 8.19 | 0.00% | 118190.00 | 0.00% |
| 7.94 | -3.00% | 118283.73 | 0.08% |
| 7.86 | -4.00% | 118380.57 | 0.16% |
| 7.78 | -5.00% | 118477.57 | 0.24% |
| 7.70 | -6.00% | 118574.72 | 0.33% |
| 7.62 | -7.00% | 118672.03 | 0.41% |
| 7.53 | -8.00% | 118769.50 | 0.49% |
| 7.45 | -9.00% | 118867.12 | 0.57% |
| Desarrollo TIR 8.02% | ||||
|---|---|---|---|---|
| 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 1129.96]/[(1+8.02)^(51/360)] | 3059.64 | 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 1129.96]/[(1+8.02)^(141/360)] | 3001.20 | 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 1129.96]/[(1+8.02)^(231/360)] | 2943.87 | 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 1129.96]/[(1+8.02)^(321/360)] | 2887.64 | 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 1129.96]/[(1+8.02)^(411/360)] | 2832.48 | i |
| 2026-06-30 | [Amortizacion % x Valor Nominal x Conversion ARS/MEP]/[(1+TIR)^(Dias restantes/Dias año)] | [1 x 100.00 x 1129.96]/[(1+8.02)^(411/360)] | 103469.53 | k |
| Desarrollo Interes Corrido | Fecha | Formula | Operacion | Interes Corrido |
|---|---|---|---|
| 2025-05-09 | (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 1129.96 x (39/90) | 1340.42 |
| 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) | (51 / 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 1129.96]/[(1+8.02)^(51/360)] | 3059.62 | 0.03 | 0.00 | i | |
| 2025-09-30 | (Dias para cupon / Dias Año) | (141 / 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 1129.96]/[(1+8.02)^(141/360)] | 3001.15 | 0.03 | 0.01 | i | |
| 2025-12-30 | (Dias para cupon / Dias Año) | (231 / 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 1129.96]/[(1+8.02)^(231/360)] | 2943.79 | 0.02 | 0.02 | i | |
| 2026-03-30 | (Dias para cupon / Dias Año) | (321 / 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 1129.96]/[(1+8.02)^(321/360)] | 2887.53 | 0.02 | 0.02 | i | |
| 2026-06-30 | (Dias para cupon / Dias Año) | (411 / 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 1129.96]/[(1+8.02)^(411/360)]+[(0.1095 x (90/360)) x 100.00% x 100.00 x 1129.96]/[(1+8.02)^(411/360)] | 106296.74 | 0.90 | 1.03 | 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 + 8.02/100) | 1.00 |
| Desarrollo Duracion Efectiva | ||
|---|---|---|
| Formula | Operacion | Duracion Efectiva |
| (P+ - P-)/(2 x Po x ΔTIR) | (118094.24 - 118283.56 )/( 2 x 118190 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)] | (51 / 360) ^ 2 + (51 / 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 1129.96]/[(1+8.02)^(51/360)] | 3059.62 | 494.85 | i |
| 2025-09-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (141 / 360) ^ 2 + (141 / 360) | 0.55 | [(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 1129.96]/[(1+8.02)^(141/360)] | 3001.15 | 1635.83 | i |
| 2025-12-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (231 / 360) ^ 2 + (231 / 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 1129.96]/[(1+8.02)^(231/360)] | 2943.79 | 3100.99 | i |
| 2026-03-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (321 / 360) ^ 2 + (321 / 360) | 1.69 | [(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 1129.96]/[(1+8.02)^(321/360)] | 2887.53 | 4870.49 | i |
| 2026-06-30 | [(Dias para cupon / Año)] ^ 2 + [(Dias para cupon / Año)] | (411 / 360) ^ 2 + (411 / 360) | 2.45 | [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 1129.96]/[(1+8.02)^(411/360)]+[(0.1095 x (90/360)) x 100.00% x 100.00 x 1129.96]/[(1+8.02)^(411/360)] | 106296.74 | 259902.91 | ki |
| Formula Convexidad Valor Final | ||
|---|---|---|
| Formula | Operacion | Convexidad |
| [[1 / [Precio x ((1 + TIR) ^ 2)] x Suma Factores] | [1 / [118190 x ((1 + 8.0246875) ^ 2)]] x 270005.09] | 1.96 |
| 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 |