Descarga la aplicación para disfrutar aún más
Vista previa del material en texto
Cover Modelación Financiera: modelo completo (3 estados financieros) de compañía Enel Generación Chile EAA324C: Banca de Inversión Grupo 2 1er semestre, 2020 Vicente García Casassus * vsgarcia@uc.cl Sebastián López Quiroz * sflopez1@uc.cl José Ignacio Nario Delgado * jinario@uc.cl María José Rojas Riveros * mjrojas@uc.cl mailto:vsgarcia@uc.clmailto:sflopez1@uc.clmailto:jinario@uc.clmailto:mjrojas@uc.cl Supuestos Supuestos 2015 1Q16 2Q16 3Q16 4Q16 2016 1Q17 2Q17 3Q17 4Q17 2017 1Q18 2Q18 3Q18 4Q18 2018 1Q19 2Q19 3Q19 4Q19 2019 1Q20 2Q20 3Q20 4Q20 2020 1Q21 2Q21 3Q21 4Q21 2021 1Q22 2Q22 3Q22 4Q22 2022 1Q23 2Q23 3Q23 4Q23 2023 1Q24 2Q24 3Q24 4Q24 2024 1Q25 2Q25 3Q25 4Q25 2025 1Q26 2Q26 3Q26 4Q26 2026 1Q27 2Q27 3Q27 4Q27 2027 1Q28 2Q28 3Q28 4Q28 2028 1Q29 2Q29 3Q29 4Q29 2029 Estado de Resultados Costos de explotación como % de ventas totales 57.06% 55.50% 59.33% 51.66% 48.65% 53.93% 58.80% 68.88% 53.95% 42.35% 55.29% 53.75% 60.44% 57.78% 43.21% 53.25% 44.09% 61.84% 45.54% 55.38% 50.96% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% 53.04% 62.63% 52.23% 47.40% 53.36% Gastos de admin y ventas como % de ventas totales 9.46% 6.58% 7.74% 15.74% 10.87% 10.24% 7.55% 7.99% 7.78% 12.66% 9.16% 8.98% 9.94% 7.74% 7.60% 8.47% 6.17% 9.47% 8.81% 9.02% 8.16% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% 7.32% 8.78% 10.02% 10.04% 9.01% Amortización - monto -13,424,071 -13,968,497 -537,097 -536,740 -567,616 -15,609,950 -16,144,771 -794,355 -792,282 - -17,731,408 -19,737,527 -999,052 -1,197,791 -3,020,212 -24,954,582 -25,726,829 -1,082,931 -1,041,508 -224,533 -28,075,801 -5,398,234 -853,359 -892,080 -953,090 -8,096,763 -5,398,234 -853,359 -892,080 -953,090 -8,096,763 -5,398,234 -853,359 -892,080 -953,090 -8,096,763 -5,398,234 -705,114 Tasa de impuesto efectiva (ETR) 25.51% 10.46% 16.70% 24.29% 0.84% 15.85% 21.49% 37.49% 24.67% 12.22% 20.85% 23.44% 22.08% 25.91% 25.88% 24.80% 27.07% 28.52% 4.50% 22.34% 10.44% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% 20.62% 26.20% 19.84% 15.32% 17.98% Tasa de impuesto marginal (MTR) 24.00% 25.50% 25.50% 25.50% 25.50% 25.50% 26.00% 26.00% 26.00% 26.00% 26.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% 27.00% Número de acciones (básicas) 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 Número de acciones (diluidas) 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 8,201,754,580 Politica de dividendos - % de utilidad neta 26.84% 106.23% 1.09% 2.23% 28.68% 39.09% 515.25% 4.56% 1.78% 57.47% 59.79% 400.62% 2.41% 1.80% 75.23% 58.43% -62.35% 0.04% 3.33% 96.73% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% Balance Otros activos financieros como % de ventas totales 0.28% 0.11% 0.29% 0.13% 0.03% 0.50% 0.42% 0.97% 4.41% 1.26% 6.18% 1.72% 1.26% 8.77% 2.54% 7.49% 11.48% 11.36% 0.04% 0.01% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% 3.61% 3.43% 3.47% 3.34% 0.96% Otros activos no financieros como % de ventas totales 2.96% 2.03% 1.28% 1.15% 0.27% 2.98% 2.24% 1.26% 0.47% 0.13% 2.00% 2.39% 1.26% 2.46% 0.71% 2.93% 6.42% 5.47% 1.95% 0.46% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% 2.72% 3.27% 2.32% 1.51% 0.39% PPC (ajustado por trimetre) 70 67 68 62 57 60 59 54 43 49 38 46 46 50 57 74 86 83 49 47 61 65 63 51 53 61 65 63 51 53 61 65 63 51 53 61 65 63 51 53 61 65 6351 53 61 65 63 51 53 61 65 63 51 53 61 65 63 51 53 61 65 63 51 53 61 65 63 51 53 CxC a entidades relacionadas, corrientes. Constante al ultimo año. 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 PPPI (ajustado por trimestre) 12 9 13 16 14 15 10 12 15 13 17 13 11 21 20 17 13 17 13 13 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 15 11 13 16 15 Activos por impuestos como % de las ventas totales 4.90% 3.58% 4.17% 8.98% 2.07% 9.42% 10.95% 11.82% 14.01% 3.99% 20.73% 17.95% 9.54% 12.00% 3.47% 8.51% 13.45% 11.86% 10.96% 2.60% 10.89% 11.48% 9.35% 11.49% 3.03% 12.39% 13.46% 10.64% 12.11% 3.27% 13.13% 14.09% 10.35% 11.64% 3.09% 11.23% 13.12% 10.55% 11.55% 3.00% 11.91% 13.04% 10.22% 11.70% 3.10% 12.16% 13.43% 10.44% 11.75% 3.12% 12.11% 13.42% 10.39% 11.66% 3.08% 11.85% 13.25% 10.40% 11.66% 3.07% 12.01% 13.28% 10.36% 11.69% 3.09% 12.03% 13.34% 10.40% 11.69% 3.09% Otros activos financieros, no corrientes como % de ventas totales 6.37% 6.65% 7.04% 1.79% 6.60% 6.89% 6.69% 7.29% 1.86% 7.36% 7.30% 7.65% 8.49% 0.13% 0.50% 0.58% 0.73% 0.75% 0.37% 1.48% 5.28% 5.43% 5.89% 1.04% 3.99% 5.01% 5.12% 5.60% 0.85% 3.33% 4.54% 4.73% 5.18% 0.60% 2.32% 3.86% 4.00% 4.36% 0.71% 2.78% 4.67% 4.82% 5.26% 0.80% 3.11% 4.52% 4.67% 5.10% 0.74% 2.89% 4.40% 4.56% 4.97% 0.71% 2.77% 4.36% 4.51% 4.92% 0.74% 2.89% 4.49% 4.64% 5.06% 0.75% 2.91% 4.44% 4.59% 5.01% 0.74% 2.86% Otros activos no financieros, no corrientes como % de ventas totales 1.14% 1.31% 1.30% 0.76% 2.82% 2.83% 2.96% 3.07% 0.72% 2.83% 2.05% 2.63% 2.55% 0.67% 2.67% 3.27% 3.35% 3.55% 0.77% 3.05% 2.32% 2.56% 2.62% 0.73% 2.84% 2.62% 2.88% 2.95% 0.72% 2.85% 2.57% 2.86% 2.92% 0.72% 2.85% 2.69% 2.91% 3.01% 0.74% 2.90% 2.55% 2.80% 2.87% 0.73% 2.86% 2.61% 2.86% 2.94% 0.73% 2.86% 2.60% 2.86% 2.93% 0.73% 2.87% 2.61% 2.86% 2.94% 0.73% 2.87% 2.59% 2.84% 2.92% 0.73% 2.87% 2.61% 2.86% 2.93% 0.73% 2.87% PPC (ajustado por trimetre) no corriente 0 0 0 2 1 0 0 0 0 0 1 1 0 0 0 0 0 0 19 18 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 CxC a entidades relacionadas, no corrientes. Constante al último año. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Inversiones contabilizadas utilizando el método de la participación. Constante al último dato disponible 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 7,911,342 Activos Intangibles distintos de plusvalía. Constante al último dato disponible 30,393,637 24,995,403 24,142,044 23,249,964 22,296,874 22,296,874 16,898,640 16,045,281 15,153,201 14,200,111 14,200,111 8,801,877 7,948,518 7,056,438 6,103,348 6,103,348 705,114 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Plusvalía (goodwill) - monto. Constante al último dato disponible 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 24,860,356 Activos por impuestos diferidos. No corriente. Valor cero 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - PPP (ajustado por trimestre) 124 126 127 167 139 104 77 106 153 133 118 85 90 132 124 103 102 109 96 100 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 112 98 108 137 124 CxP a entidades relacionadas, corriente. Constante al último año. 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 Otras provisiones, corrientes como % de ventas totales 2.10% 2.03% 2.71% 1.69% 0.39% 1.34% 1.37% 1.26% 1.14% 0.32% 1.68% 1.76% 1.41% 1.18% 0.34% 0.99% 1.46% 1.49% 0.93% 0.22% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% 1.53% 1.65% 1.72% 1.24% 0.32% Pasivos por impuestos diferidos. como % de las ventas. 3.82% 1.10% 10.68% 16.03% 3.70% 24.48% 6.92% 11.53% 14.39% 4.09% 22.06% 0.41% 0.41% 2.85% 0.82% 6.89% 17.99% 15.90% 4.54% 1.08% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% 14.31% 6.60% 9.63% 9.45% 2.42% Otros pasivos no financieros. Corrientes. Constante al último dato. 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 4,811,150 Pasivos incluidos en grupos de activos para su disposición clasificados como mantenidos para la venta o como mantenidos para distribuir a los propietarios. Valor cero. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Otras cuentas por pagar, no corrientes, como % de las ventas totales. 1.82% 0.42% 0.39% 0.38% 0.09% 0.35% 0.28% 0.20% 0.14% 0.04% 0.14% 0.13% 0.12% 0.10% 0.03% 0.08% 0.08% 0.11% 0.00% 0.00% 0.60% 0.23% 0.20% 0.15% 0.04% 0.29% 0.18% 0.16% 0.10% 0.03% 0.28% 0.15% 0.15% 0.09% 0.02% 0.31% 0.16% 0.15% 0.09% 0.02% 0.37% 0.18% 0.16% 0.11% 0.03% 0.31% 0.17% 0.15%0.09% 0.03% 0.32% 0.16% 0.15% 0.09% 0.02% 0.33% 0.17% 0.16% 0.10% 0.03% 0.33% 0.17% 0.16% 0.10% 0.03% 0.32% 0.17% 0.16% 0.10% 0.03% CxP a entidades relacionadas, no corriente. Valor 0. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Otras provisiones, no corrientes, como % de ventas totales 12.36% 12.94% 13.25% 14.95% 3.45% 15.12% 15.39% 14.81% 13.76% 3.91% 18.86% 19.09% 16.20% 18.07% 5.23% 15.20% 37.18% 36.13% 36.85% 8.76% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% 15.38% 21.15% 20.10% 20.91% 5.34% Pasivo por impuestos diferidos. No corriente. Como % de las ventas totales 47.98% 46.63% 45.97% 48.31% 11.16% 47.56% 48.33% 45.38% 34.46% 9.80% 46.20% 47.77% 42.37% 41.72% 12.06% 41.28% 29.93% 25.29% 33.42% 7.94% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% 45.76% 43.16% 39.75% 39.48% 10.24% Provisiones no corrientes por beneficios a los empleados. % de las ventas totales 3.70% 3.29% 3.31% 4.13% 0.95% 4.14% 3.91% 3.67% 3.20% 0.91% 4.29% 4.23% 3.61% 3.32% 0.96% 2.77% 4.07% 3.93% 4.92% 1.17% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% 3.73% 3.87% 3.63% 3.89% 1.00% Capital emitido. Constante al último dato. 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 Primas de emisión. Constante al último dato. 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 85,511,492 PP&E Capex como % de ventas totales -17.27% -0.91% -0.13% -30.95% -11.74% -16.83% -10.05% -11.13% -12.66% -12.65% -15.31% 15.57% -43.85% -10.62% -14.62% -13.57% -19.13% -2.93% -13.54% -12.37% -15.75% -3.63% -14.51% -16.94% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% -15.75% -3.63% -14.51% -16.94% 0.00% Depreciación como % de PP&E inicial 1.07% 1.07% 1.07% 1.07% 4.29% 0.89% 0.89% 0.89% 0.89% 3.57% 0.79% 0.79% 0.79% 0.79% 3.18% 0.72% 0.72% 0.72% 0.72% 2.89% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% 0.87% 0.87% 0.87% 0.87% 3.48% Patrimonio Capital emitido 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 552,777,321 Aumentos de capital 552,777,321 - - - - - - - - - - - - - - - - - - - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ganancias acumuladas 1,064,958,155 1,107,370,919 1,266,224,844 1,199,429,221 1,199,429,221 1,351,586,482 1,289,912,945 1,375,025,725 1,398,018,155 1,398,018,155 1,466,229,294 1,407,661,496 1,477,557,900 1,509,995,045 1,509,995,045 1,670,117,469 1,422,315,702 1,546,241,589 1,552,064,328 1,552,064,328 Primas de emisión. Constante al último dato Otras reservas. Constante al último dato -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 -226,577,889 Participaciones no controladoras. Constante al último dato. 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 10,079,142 Perfil de vencimiento de deuda Deuda 1 1,270,000 1,270,000 1,270,000 1,270,000 5,080,000 Deuda 2 450,000 450,000 450,000 450,000 1,800,000 Deuda 3 260,000 260,000 260,000 260,000 1,040,000 Deuda 4 710,000 710,000 710,000 710,000 2,840,000 Deuda 5 1,650,000 1,650,000 1,650,000 1,650,000 6,600,000 Deuda 6 6,575,000 6,575,000 6,575,000 6,575,000 26,300,000 Perfil de vencimiento de deuda Deuda 11 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000 2,000,000 2,000,000 2,000,000 2,000,000 8,000,000Deuda 12 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 600,000 600,000 600,000 600,000 2,400,000 Deuda 13 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 300,000 300,000 300,000 300,000 1,200,000 Deuda 14 (vence 2024) 15,000,000 15,000,000 15,000,000 15,000,000 60,000,000 15,000,000 15,000,000 15,000,000 15,000,000 60,000,000 15,000,000 15,000,000 15,000,000 15,000,000 60,000,000 15,000,000 15,000,000 15,000,000 15,000,000 60,000,000 15,000,000 15,000,000 15,000,000 15,000,000 60,000,000 0 0 0 0 0 Deuda 15 (vence 2029) 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,400,000 Deuda 16 (vence 2030) 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 5,150,000 5,150,000 5,150,000 5,150,000 20,600,000 Caja disponible para pagar deuda y distribuir capital Caja mínima operativa como % de ventas totales 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% Ingresos por intereses 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% 0.50% 0.50% 0.50% 0.50% 2.00% Cálculos Cálculos 2015 1Q16 2Q16 3Q16 4Q16 2016 1Q17 2Q17 3Q17 4Q17 2017 1Q18 2Q18 3Q18 4Q18 2018 1Q19 2Q19 3Q19 4Q19 2019 1Q20 2Q20 3Q20 4Q20 2020 1Q21 2Q21 3Q21 4Q21 2021 1Q22 2Q22 3Q22 4Q22 2022 1Q23 2Q23 3Q23 4Q23 2023 1Q24 2Q24 3Q24 4Q24 2024 1Q25 2Q25 3Q25 4Q25 2025 1Q26 2Q26 3Q26 4Q26 2026 1Q27 2Q27 3Q27 4Q27 2027 1Q28 2Q28 3Q28 4Q28 2028 1Q29 2Q29 3Q29 4Q29 2029 PP&E Balance inicial ERROR:#REF! 2,729,088,113 2,756,477,593 2,741,170,983 2,726,838,537 2,726,838,537 2,723,922,112 2,731,183,672 2,762,003,697 2,788,204,501 2,788,204,501 2,787,610,527 2,830,783,148 2,848,592,895 2,919,097,994 2,919,097,994 2,923,128,926 6,418,832 3,245,472 2,747,643,715 2,747,643,715 2,785,208,586 2,775,419,059 2,810,259,864 2,856,101,994 2,856,101,994 2,899,907,932 2,890,771,620 2,931,193,552 2,983,645,940 2,983,645,940 3,029,088,736 3,019,460,112 3,061,286,664 3,115,549,369 3,115,549,369 3,162,460,184 3,152,283,279 3,195,444,818 3,251,496,720 3,251,496,720 3,299,876,541 3,289,132,618 3,333,693,668 3,391,656,102 3,391,656,102 3,441,139,240 3,429,610,231 3,474,353,236 3,532,281,682 3,532,281,682 3,581,519,804 3,568,996,983 3,613,451,100 3,671,261,439 3,671,261,439 3,720,169,925 3,706,645,276 3,750,732,213 3,808,329,836 3,808,329,836 3,860,079,803 3,846,278,256 3,892,959,160 3,953,821,386 3,953,821,386 4,008,540,802 3,994,434,866 4,043,825,596 4,108,101,860 Capex (acumulado) Capex (trimestral) 0 -71,706,408 -3,932,584 -562,614 -118,678,789 -194,880,395 -64,543,717 -38,542,588 -44,818,321 -58,871,037 -206,775,663 -52,564,436 52,564,436 -175,602,750 -46,724,298 -222,327,048 -70,996,339 -68,182,881 -10,842,504 -52,723,664 -202,745,388 -61,488,655 -14,461,336 -59,006,430 -70,311,114 -205,267,535 -68,674,071 -16,113,239 -65,591,934 -77,974,344 -228,353,588 -71,421,456 -16,745,707 -68,117,047 -80,917,384 0 -74,037,961 -17,358,694 -70,608,528 -83,874,699 0 -76,690,663 -17,988,162 -73,199,588 -86,988,967 0 -79,014,350 -18,433,053 -74,604,685 -88,179,703 0 -79,993,764 -18,661,538 -75,529,439 -89,272,725 0 -80,874,227 -18,866,939 -76,360,765 -90,255,318 0 -84,909,165 -19,808,239 -80,170,519 -94,758,293 0 -89,145,412 -20,796,502 -84,170,348 -99,485,928 0 Depreciación -111,411,488 -18,451,503 -33,063,903 -32,962,260 -32,512,384 -116,990,050 -14,048,229 -27,936,645 -28,004,718 -29,617,000 -99,606,592 -8,444,473 -28,823,948 -27,420,209 -28,122,788 -92,811,418 -2,092,171 -26,187,069 -25,047,492 -26,053,467 -79,380,199 -23,923,784 -24,250,862 -24,165,625 -24,468,984 -96,809,256 -24,868,133 -25,249,552 -25,170,002 -25,521,956 -100,809,642 -25,978,660 -26,374,331 -26,290,495 -26,654,679 -105,298,166 -27,127,146 -27,535,599 -27,446,989 -27,822,797 -109,932,530 -28,310,842 -28,732,086 -28,638,538 -29,026,532 -114,707,998 -29,531,212 -29,962,063 -29,861,679 -30,251,258 -119,606,212 -30,755,642 -31,184,359 -31,075,322 -31,462,385 -124,477,708 -31,965,741 -32,391,588 -32,273,829 -32,657,694 -129,288,852 -33,159,198 -33,609,786 -33,489,616 -33,896,067 -134,154,666 -34,425,996 -34,902,439 -34,779,618 -35,209,664 -139,317,716 Balance final ERROR:#REF! 2,729,088,113 2,756,477,593 2,741,170,983 2,726,838,537 2,726,838,537 2,723,922,112 2,731,183,672 2,762,003,697 2,788,204,501 2,788,204,501 2,787,610,527 2,830,783,148 2,848,592,895 2,919,097,994 2,919,097,994 2,923,128,926 6,418,832 3,245,472 2,747,643,715 2,747,643,715 2,785,208,586 2,775,419,059 2,810,259,864 2,856,101,994 2,856,101,994 2,899,907,932 2,890,771,620 2,931,193,552 2,983,645,940 2,983,645,940 3,029,088,736 3,019,460,112 3,061,286,664 3,115,549,369 3,115,549,369 3,162,460,184 3,152,283,279 3,195,444,818 3,251,496,720 3,251,496,720 3,299,876,541 3,289,132,618 3,333,693,668 3,391,656,102 3,391,656,102 3,441,139,240 3,429,610,231 3,474,353,236 3,532,281,682 3,532,281,682 3,581,519,804 3,568,996,983 3,613,451,100 3,671,261,439 3,671,261,439 3,720,169,925 3,706,645,276 3,750,732,213 3,808,329,836 3,808,329,836 3,860,079,803 3,846,278,256 3,892,959,1603,953,821,386 3,953,821,386 4,008,540,802 3,994,434,866 4,043,825,596 4,108,101,860 4,108,101,860 Capital de trabajo Cuentas por cobrar ERROR:#REF! 316,450,649 318,815,753 317,899,195 260,440,086 260,440,086 251,735,919 248,371,894 236,428,510 218,178,007 218,178,007 144,137,969 170,590,083 200,869,172 239,425,507 239,425,507 423,229,773 337,378,306 335,781,621 209,178,012 209,178,012 258,899,231 281,671,765 279,644,026 231,937,092 231,937,092 289,153,568 313,846,841 310,854,131 257,215,985 257,215,985 300,721,491 326,165,787 322,821,177 266,924,268 266,924,268 311,738,338 338,105,278 334,628,835 276,679,640 276,679,640 322,907,593 350,365,803 346,908,419 286,952,755 286,952,755 332,691,525 359,031,194 353,567,474 290,880,668 290,880,668 336,815,366 363,481,526 357,950,081 294,486,247 294,486,247 340,522,573 367,482,239 361,889,911 297,727,553 297,727,553 357,511,761 385,816,485 379,945,147 312,581,632 312,581,632 375,348,565 405,065,454 398,901,187 328,176,804 328,176,804 Cuentas a entidades relacionadas CP 91,690,759 59,394,835 79,921,284 82,727,781 82,727,781 66,869,564 67,187,803 64,361,209 109,797,820 109,797,820 76,884,812 68,257,416 54,123,688 135,105,117 135,105,117 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 81,411,670 203,795,840 267,772,411 288,344,589 288,344,589 Inventarios ERROR:#REF! 31,248,474 25,601,788 32,672,748 33,390,799 33,390,799 37,885,713 29,393,149 28,381,222 31,740,903 31,740,903 33,786,110 30,044,167 27,503,125 43,770,781 43,770,781 43,643,421 32,395,774 31,909,880 29,674,090 29,674,090 34,610,893 30,767,163 30,843,213 35,028,271 35,028,271 38,655,438 34,281,665 34,285,518 38,846,013 38,846,013 40,201,894 35,627,270 35,605,418 40,312,205 40,312,205 41,674,679 36,931,427 36,907,738 41,785,509 41,785,509 43,167,839 38,270,651 38,262,110 43,337,005 43,337,005 44,475,802 39,217,177 38,996,567 43,930,217 43,930,217 45,027,097 39,703,289 39,479,945 44,474,749 44,474,749 45,522,694 40,140,289 39,914,487 44,964,267 44,964,267 47,793,890 42,142,949 41,905,881 47,207,603 47,207,603 50,178,400 44,245,524 43,996,629 49,562,862 49,562,862 Cuentas por cobrar LP 30,108 29,055 28,256 6,788,437 6,788,437 1,051,458 913,535 872,398 1,032,923 1,032,923 2,059,500 2,039,249 2,022,298 1,156,638 1,156,638 1,154,782 1,047,030 1,078,772 82,929,822 82,929,822 1,076,047 1,138,508 1,037,022 3,119,670 3,119,670 1,201,791 1,268,558 1,152,761 3,459,684 3,459,684 1,249,870 1,318,351 1,197,139 3,590,265 3,590,265 1,295,658 1,366,610 1,240,926 3,721,479 3,721,479 1,342,080 1,416,166 1,286,463 3,859,658 3,859,658 1,382,745 1,451,192 1,311,157 3,912,490 3,912,490 1,399,884 1,469,180 1,327,410 3,960,987 3,960,987 1,415,293 1,485,351 1,342,020 4,004,584 4,004,584 1,485,904 1,559,457 1,408,975 4,204,379 4,204,379 1,560,038 1,637,261 1,479,271 4,414,142 4,414,142 Cuentas a entidades relacionadas LP 0 14,673,698 14,603,853 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80,339,778 80,339,778 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total activos operacionales corrientes ERROR:#REF! 439,419,990 418,515,129 445,125,336 383,347,103 383,347,103 357,542,654 345,866,381 330,043,339 360,749,653 360,749,653 256,868,391 270,930,915 284,518,283 419,458,043 419,458,043 549,439,646 574,616,950 636,542,684 690,466,291 690,466,291 375,997,840 517,373,276 579,296,672 558,429,621 558,429,621 410,422,467 553,192,904 614,064,820 587,866,270 587,866,270 423,584,925 566,907,248 627,396,145 599,171,327 599,171,327 436,120,345 580,199,155 640,549,910 610,531,217 610,531,217 448,829,182 593,848,460 654,229,403 622,494,007 622,494,007 459,961,741 603,495,403 661,647,610 627,067,964 627,067,964 464,654,017 608,449,835 666,529,847 631,266,573 631,266,573 468,872,230 612,903,718 670,918,829 635,040,994 635,040,994 488,203,225 633,314,731 691,032,415 652,338,203 652,338,203 508,498,672 654,744,079 712,149,498 670,498,397 670,498,397 Cuentas por pagar CP ERROR:#REF! 314,350,254 353,781,155 306,450,416 341,088,664 341,088,664 257,391,921 221,786,440 251,922,846 329,448,226 329,448,226 238,967,143 191,002,627 227,578,135 275,331,618 275,331,618 259,153,884 246,287,411 201,520,316 227,887,342 227,887,342 254,758,870 266,648,748 251,401,286 295,315,268 295,315,268 284,529,375 297,107,761 279,459,317 327,501,768 327,501,768 295,912,302 308,769,673 290,217,747 339,862,897 339,862,897 306,752,965 320,072,369 300,832,887 352,283,981 352,283,981 317,743,599 331,678,977 311,872,290 365,364,285 365,364,285 327,371,065 339,882,198 317,858,812 370,365,523 370,365,523 331,428,957 344,095,171 321,798,796 374,956,349 374,956,349 335,076,878 347,882,504 325,340,722 379,083,360 379,083,360 351,794,372 365,238,890 341,572,463 397,996,404 397,996,404 369,345,926 383,461,212 358,614,032 417,853,048 417,853,048 Cuentas entidades relacionadas CP 284,697,162 174,182,104 57,755,797 121,018,039 121,018,039 110,552,032 67,154,341 54,923,327 122,862,944 122,862,944 102,108,386 67,857,080 98,493,128 152,932,289 152,932,289 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 80,924,544 93,606,415 67,728,199 137,867,183 137,867,183 Cuentas por pagar LP 7,550,187 1,820,255 1,661,677 1,453,022 1,453,022 1,333,742 1,065,270 813,675 632,643 632,643 489,117 444,765 460,737 450,421 450,421 442,269 272,774 390,842 2 2 2,336,084 902,793 824,759 640,451 640,451 1,279,086 790,982 707,014 451,876 451,876 1,268,376 707,161 680,714 423,776 423,776 1,476,046 758,741 742,055 422,334 422,334 1,808,231 887,968 828,238 547,518 547,518 1,578,293 849,727 794,474 492,963 492,963 1,624,841 846,305 801,870 494,504 494,504 1,694,344 870,341 822,596 506,763 506,763 1,800,402 925,751 868,909 545,774 545,774 1,837,311 958,274 902,233 559,710 559,710 Cuentas entidades relacionadas LP 254,178 251,527 251,527 251,527 251,527 0 0 0 318,518 318,518 0 0 0 0 0 0 0 0 2,497,660 2,497,660 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total pasivos operacionales corrientes ERROR:#REF! 606,851,781 530,035,041 366,119,417 463,811,252 463,811,252 369,277,695 290,006,051 307,659,848 453,262,331 453,262,331 341,564,646 259,304,472 326,532,000 428,714,328 428,714,328 340,520,697 340,166,600 269,639,357 368,252,187 368,252,187 338,019,498 361,157,957 319,954,245 433,822,902 433,822,902 366,733,005 391,505,158 347,894,530 465,820,826 465,820,826 378,105,222 403,083,250 358,626,660 478,153,855 478,153,855 389,153,554 414,437,526 369,303,141 490,573,498 490,573,498 400,476,374 426,173,360 380,428,727 503,778,987 503,778,987 409,873,902 434,338,340 386,381,485 508,725,669 508,725,669 413,978,342 438,547,891 390,328,865 513,318,035 513,318,035 417,695,766 442,359,260 393,891,517 517,457,306 517,457,306 434,519,318 459,771,056 410,169,572 536,409,361 536,409,361 452,107,781 478,025,901 427,244,464 556,279,941 556,279,941 Capital de trabajo total (OWC) ERROR:#REF! -167,431,791 -111,519,912 79,005,919 -80,464,149 -80,464,149 -11,735,041 55,860,330 22,383,491 -92,512,678-92,512,678 -84,696,255 11,626,443 -42,013,717 -9,256,285 -9,256,285 208,918,949 234,450,350 366,903,327 322,214,104 322,214,104 37,978,343 156,215,319 259,342,428 124,606,719 124,606,719 43,689,463 161,687,746 266,170,291 122,045,444 122,045,444 45,479,703 163,823,998 268,769,485 121,017,472 121,017,472 46,966,791 165,761,629 271,246,769 119,957,719 119,957,719 48,352,808 167,675,101 273,800,676 118,715,020 118,715,020 50,087,839 169,157,063 275,266,124 118,342,295 118,342,295 50,675,675 169,901,944 276,200,981 117,948,538 117,948,538 51,176,464 170,544,458 277,027,312 117,583,687 117,583,687 53,683,907 173,543,674 280,862,843 115,928,842 115,928,842 56,390,891 176,718,179 284,905,034 114,218,455 114,218,455 Ventas Ventas 2015 1Q16 2Q16 3Q16 4Q16 2016 1Q17 2Q17 3Q17 4Q17 2017 1Q18 2Q18 3Q18 4Q18 2018 1Q19 2Q19 3Q19 4Q19 2019 1Q20 2Q20 3Q20 4Q20 2020 1Q21 2Q21 3Q21 4Q21 2021 1Q22 2Q22 3Q22 4Q22 2022 1Q23 2Q23 3Q23 4Q23 2023 1Q24 2Q24 3Q24 4Q24 2024 1Q25 2Q25 3Q25 4Q25 2025 1Q26 2Q26 3Q26 4Q26 2026 1Q27 2Q27 3Q27 4Q27 2027 1Q28 2Q28 3Q28 4Q28 2028 1Q29 2Q29 3Q29 4Q29 2029 88.85% : ====== ID#AAAAJTacMk4 Vicente Garcia Casassus (2020-04-09 21:11:19) Ventas está formado por 4 drivers: 1- Generación 2- Otras ventas 3- Otras prestaciones de servicios 4- Otros ingresos de explotación En promedio, Generación explica el 88,85% de las ventas. Razón por la cual ajustaremos por ese número. Operacional 1: Hidroelectrica Capacidad Instalada (MW) 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,456 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 3,606 Factor Planta(%) 32.50% 27.44% 28.23% 31.17% 29.84% 27.92% 19.55% 39.73% 40.96% 32.04% 33.03% 27.75% 34.35% 54.17% 37.33% 33.03% 24.91% 34.11% 42.10% 33.54% 69.25% 54.56% 74.69% 92.20% 290.70% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% 66.37% 52.29% 71.58% 88.36% 278.61% Generación Neta (GWh) 0.00 2,460.00 2,077.00 2,137.00 2,359.00 9,033.00 2,113.00 1,480.00 3,007.00 3,100.00 9,700.00 2,500.00 2,100.00 2,600.00 4,100.00 11,300.00 2,500.00 1,885.67 2,581.33 3,186.33 10,153.33 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 Operacional 2: Térmica Capacidad Instalada (MW) 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,740.00 2,740.00 2,740.00 2,580.00 2,580.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 Factor Planta(%) Carbon 26.29% 23.90% 31.60% 27.25% 109.05% 29.75% 32.38% 19.81% 14.25% 96.19% 28.50% 28.50% 28.50% 7.13% 92.63% 29.20% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Petroleo Gas 47.60% 56.47% 50.77% 34.63% 189.45% 50.30% 54.61% 48.27% 10.69% 163.88% 32.06% 49.88% 35.63% 14.25% 131.81% 47.45% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Generación Neta (GWh) 2,074.00 2,256.00 2,312.00 1,737.00 8,379.00 2,247.00 2,442.00 1,911.00 700.00 7,300.00 1,700.00 2,200.00 1,800.00 600.00 6,300.00 2,100.00 2,299.33 2,007.67 1,012.33 7,419.33 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 Operacional 3: Eólica, Solar & Geotérmica Capacidad Instalada (MW) 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 78.00 78.00 78.00 78.00 78.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 Factor Planta(%) 44.83% 6.90% 32.18% 90.80% 174.71% 29.89% 36.78% 48.28% 0.00% 114.94% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% 18.68% 14.56% 26.82% 30.27% 90.33% Generación Neta (GWh) 39.00 6.00 28.00 79.00 152.00 26.00 32.00 42.00 0.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 Total Generación Neta (GWh) 18,294 4,573 4,339 4,477 4,175 17,564 4,386 3,954 4,960 3,800 17,100 4,200 4,300 4,400 4,700 17,600 4,600 4,185 4,589 4,199 17,573 Ventas de energia totales (GWH) 23,558 6,025 6,114 5,823 5,727 23,689 5,771 5,657 5,872 6,056 23,356 5,800 5,657 5,872 6,014 23,343 5,9005,657 5,872 6,014 23,443 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Clientes Regulados 17622 4,850 4,728 4,502 4,436 18,516 4,420 4,230 4,350 4,010 17,010 4,000 4,230 4,350 4,413 16,993 3,300 4,230 4,350 4,413 16,293 Clientes Libres 4319 882 1,001 1,204 1,234 4,321 1,221 1,401 1,378 1,604 5,604 1,700 1,401 1,378 1,119 5,598 2,500 1,401 1,378 1,119 6,398 Mercado Spot 1618 293 385 117 57 852 130 26 144 442 742 100 26 144 482 752 100 26 144 482 752 Venta de energía ($/GWh) Clientes Regulados 61,352 64,079 62,180 64,790 63,928 63,731 6,285 121,206 62,027 72,517 64,732 61,456 55,105 59,404 58,914 58,690 68,895 50,621 56,427 48,565 55,315 48,245 56,449 49,233 57,605 58,398 60,539 59,454 61,634 60,530 64,763 59,655 65,886 60,690 67,029 67,207 65,991 68,371 67,134 69,555 69,664 68,430 70,900 69,644 72,158 72,250 70,523 73,135 71,387 74,031 73,239 72,261 74,136 73,146 75,044 74,147 73,149 75,055 74,045 75,974 74,963 76,905 75,881 77,846 76,810 78,703 77,751 79,667 78,703 80,643 82,630 Clientes No Regulados 56,401 61,491 63,686 44,635 50,986 54,303 47,945 57,166 56,521 43,085 50,968 45,509 57,148 66,317 79,477 60,334 46,053 86,364 74,625 109,053 72,053 108,334 73,529 110,553 75,036 76,068 78,857 77,444 80,283 78,845 84,359 77,706 85,822 79,054 87,311 87,543 85,958 89,059 87,447 90,602 90,742 89,136 92,353 90,717 93,991 94,112 91,862 95,264 92,987 96,431 95,400 94,125 96,568 95,278 97,751 96,582 95,283 97,765 96,450 98,962 97,645 100,174 98,841 101,401 100,052 102,517 101,277 103,773 102,517 105,043 107,632 Mercado Spot 92,756 86,487 93,845 174,287 353,353 119,723 105,327 550,262 109,529 61,510 95,632 3,969 113,754 21,607 57,683 45,571 23,253 129,757 63,680 26,785 36,941 26,609 37,697 27,154 38,470 38,999 40,429 39,705 41,160 40,423 43,250 39,839 44,000 40,530 44,763 44,882 44,070 45,659 44,833 46,450 46,522 45,699 47,348 46,510 48,188 48,250 47,096 48,841 47,673 49,439 48,910 48,257 49,509 48,848 50,116 49,517 48,850 50,123 49,449 50,737 50,062 51,358 50,675 51,987 51,295 52,559 51,923 53,203 52,559 53,854 55,181 Venta de energía ($) 1,474,818,366 390,361,198 393,864,988 365,818,890 366,643,366 1,516,688,442 100,011,010 607,098,400 363,474,190 387,088,122 1,457,671,722 323,587,773 316,117,411 352,901,548 376,726,578 1,369,333,310 344,811,922 338,495,916 357,462,086 349,258,013 1,390,027,937 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 IPC: aumento / (disminución) (%) 4.30% 1.20% 0.90% 0.40% 0.10% 3.80% 1.10% -0.10% 0.20% 0.80% 2.20% 0.70% 0.70% 0.90% 0.30% 2.30% 0.60% 0.90% 0.40% 1.00% 2.20% 1.31% 0.81% 0.81% 0.81% 3.80% 0.79% 0.79% 0.79% 0.79% 3.20% 0.74% 0.74% 0.74% 0.74% 3.00% 0.74% 0.74% 0.74% 0.74% 3.00% 0.74% 0.74% 0.74% 0.74% 3.00% 0.74% 0.74% 0.74% 0.74% 3.00% 0.74% 0.74% 0.74% 0.74% 3.00% 0.74% 0.74% 0.74% 0.74% 3.00% 0.74% 0.74% 0.74% 0.74% 3.00% 0.74% 0.74% 0.74% 0.74% 3.00% PIB per cápita 14,722.40 14,771.30 14,748.50 15,130.20 15,777.70 16,564.42 17,243.92 17,934.00 18649.6 19426.2 19801.4 20183.8 20573.6 20970.9 21375.9 Crecimiento PIB (%) 0.08% 0.08% 0.08% 0.08% 0.33% -0.04% -0.04% -0.04% -0.04% -0.15% 0.64% 0.64% 0.64% 0.64% 2.59% 1.05% 1.05% 1.05% 1.05% 4.28% 1.22% 1.22% 1.22% 1.22% 4.99% 1.01% 1.01% 1.01% 1.01% 4.10% 0.99% 0.99% 0.99% 0.99% 4.00% 0.98% 0.98% 0.98% 0.98% 3.99% 1.03% 1.03% 1.03% 1.03% 4.16% 0.48% 0.48% 0.48% 0.48% 1.93% 0.48% 0.48% 0.48% 0.48% 1.93% 0.48% 0.48% 0.48% 0.48% 1.93% 0.48% 0.48% 0.48% 0.48% 1.93% 0.48% 0.48% 0.48% 0.48% 1.93% Participación de mercado en Ventas (%) 35% 36% 35% 35% 35% 34% 34% 34% 34.20% 34.20% 32.00% 32.00% 32.00% 32.80% 32.80% 32.00% 32.00% 32.00% 32.00% 32.00% 31.00% 31.00% 31.00% 31.00% 31.00% 32.00% 32.00% 32.00% 32.00% 32.00% 31.00% 31.00% 31.00% 31.00% 31.00% 30.00% 30.00% 30.00% 30.00% 30.00% 29.00% 29.00% 29.00% 29.00% 29.00% 28.00% 28.00% 28.00% 28.00% 28.00% 27.00% 27.00% 27.00% 27.00% 27.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% Crecimiento / (disminución) participación de mercado (%) 2.86% -2.78% 0.00% -2.86% 0.00% 0.00% 0.59% -2.29% -6.43% 0.00% 0.00% 2.50% -4.09% -2.44% 0.00% 0.00% 0.00% -2.44% -3.13% 0.00% 0.00% 0.00% -3.13% 3.23% 0.00% 0.00% 0.00% 3.23% -3.13% 0.00% 0.00% 0.00% -3.13% -3.23% 0.00% 0.00% 0.00% -3.23% -3.33% 0.00% 0.00% 0.00% -3.33% -3.45% 0.00% 0.00% 0.00% -3.45% -3.57% 0.00% 0.00% 0.00% -3.57% -3.70% 0.00% 0.00% 0.00% -3.70% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Crecimiento volumen de ventas (%) 0.08% 2.94% -2.70% 0.08% 0.33% -2.89% -0.04% -0.04% 0.55% -2.44% -5.83% 0.64% 0.64% 3.16% -1.61% -1.41% 1.05% 1.05% 1.05% 1.74% -1.94% 1.22% 1.22% 1.22% 1.71% 4.27% 1.01% 1.01% 1.01% 7.46% -2.17% 0.99% 0.99% 0.99% 0.75% -2.27% 0.98% 0.98% 0.98% 0.64% -2.34% 1.03% 1.03% 1.03% 0.69% -2.99% 0.48% 0.48% 0.48% -1.58% -3.11% 0.48% 0.48% 0.48% -1.71% -3.24% 0.48% 0.48% 0.48% -1.84% 0.48% 0.48% 0.48% 0.48% 1.93% 0.48% 0.48% 0.48% 0.48% 1.93% Crecimiento ventas en (%) 1.29% 3.87% -2.31% 0.18% 4.14% -1.82% -0.14% 0.16% 1.36% -0.29% -5.17% 1.35% 1.55% 3.47% 0.65% -0.82% 1.96% 1.46% 2.07% 3.97% -0.66% 2.05% 2.05% 2.05% 5.57% 5.09% 1.81% 1.81% 1.81% 10.90% -1.44% 1.73% 1.73% 1.73% 3.77% -1.55% 1.73% 1.73% 1.73% 3.65% -1.62% 1.77% 1.77% 1.77% 4% -2.27% 1.22% 1.22% 1.22% 1% -2.39% 1.22% 1.22% 1.22% 1% -2.52% 1.22% 1.22% 1.22% 1% 1.22% 1.22% 1.22% 1.22% 5% 1.22% 1.22% 1.22% 1.22% 4.99% Venta ajustada por driver (ver comentario celda B1) 1,659,865,658 439,340,302 443,283,717 411,718,640 412,646,564 1,706,989,224 112,559,516 683,271,790 409,079,748 435,656,549 1,640,567,603 364,188,733 355,781,055 397,180,543 423,994,929 1,541,145,261 388,075,902 380,967,419 402,313,298 393,079,850 1,564,436,468 390,488,509 398,489,125 406,653,663 414,985,483 1,610,616,779 436,120,051 444,008,128 452,038,875 460,214,875 1,792,381,929 453,567,538 461,436,094 469,441,154 477,585,088 1,862,029,874 470,183,856 478,327,234 486,611,652 495,039,552 1,930,162,295 487,030,047 495,672,550 504,468,418 513,420,370 2,000,591,386 501,786,804 507,931,728 514,151,905 520,448,254 2,044,318,690 508,006,647 514,227,741 520,525,018 526,899,413 2,069,658,820 513,598,096 519,887,663 526,254,253 532,698,808 2,092,438,821 539,222,284 545,825,647 552,509,876 559,275,960 2,196,833,766 566,124,902 573,057,716 580,075,431 587,179,085 2,306,437,135 Precio Medio de Mercado ($/MWh) 57.08 57.1 54.5 51.8 52.1 53.9 52.5 57.0 59.3 55.8 56.1 54.0 53.5 59.7 63.4 57.6 65.4 67.8 68.9 68.9 67.8 Costo Marginal (Precio Spot) ($/MWh) 52.34 40.44 47.04 40.40 31.35 39.81 38.49 41.31 32.25 26.17 34.56 32.46 41.28 42.88 35.34 37.99 38.57 40.56 33.01 27.08 34.81 Cap. Instalada & Gen 2015 1Q16 2Q16 3Q16 4Q16 2016 1Q17 2Q17 3Q17 4Q17 2017 1Q18 2Q18 3Q18 4Q18 2018 1Q19 2Q19 3Q19 4Q19 2019 1Q20 2Q20 3Q20 4Q20 2020 1Q21 2Q21 3Q21 4Q21 2021 1Q22 2Q22 3Q22 4Q22 2022 1Q23 2Q23 3Q23 4Q23 2023 1Q24 2Q24 3Q24 4Q24 2024 1Q25 2Q25 3Q25 4Q25 2025 1Q26 2Q26 3Q26 4Q26 2026 1Q27 2Q27 3Q27 4Q27 2027 1Q28 2Q28 3Q28 4Q28 2028 1Q292Q29 3Q29 4Q29 2029 Capacidad Instalada (MW) 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,351.00 6,274.00 6,274.00 6,274.00 6,274.00 6,274.00 6,114.00 6,114.00 6,168.00 6,168.00 6,168.00 6,168.00 6,168.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 6,318.00 Hidroeléctrica 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,456.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 3,606.00 Los Molles 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 Rapel-Sauzal 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 Maule 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 Laja 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 Ralco-Pangue 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 1,157 Los Cóndores 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 Térmica 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,807.00 2,740.00 2,740.00 2,740.00 2,580.00 2,580.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 2,625.00 GasAtacama 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 Tarapaca 182 182 182 182 182 182 182 182 182 182 182 182 182 182 182 182 182 182 182 182 182 D. Almagro-Taltal 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 Huasco 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 San Isidro 1 & 2 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 Bocamina 1 & 2 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 478 TG Quintero 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 Eólica, Solar & Geotérmica 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 78.00 78.00 78.00 78.00 78.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 Canela 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 Canela II 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 Ojos de Agua 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 Check (1) (1) (1) (1) (1) (1) (1) (1) (1) (1) (1) (1) (1) (1) 76 76 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Participación por sector (%) Hidroeléctrica 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 54.42% 55.08% 55.08% 55.08% 55.08% 55.08% 56.53% 56.53% 56.03% 56.03% 56.03% 56.03% 56.03% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% 57.08% Térmica 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.20% 44.74% 44.74% 43.67% 43.67% 43.67% 42.20% 42.20% 42.56% 42.56% 42.56% 42.56% 42.56% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% 41.55% Eólica, Solar & Geotérmica 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.37% 1.39% 1.39%1.24% 1.24% 1.24% 1.28% 1.28% 1.41% 1.41% 1.41% 1.41% 1.41% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% 1.38% Generación Neta (GWh) 18,294.00 4,573.00 4,339.00 4,477.00 4,175.00 17,564.00 4,387.00 3,953.00 4,960.00 3,773.00 17,073.00 4,300.00 4,300.00 4,300.00 4,473.00 17,373.00 4,700.00 4,300.00 4,300.00 4,500.00 17,800.00 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 4,439.75 4,197.67 4,612.33 4,225.00 17,474.75 Hidroeléctrica 2,460.00 2,077.00 2,137.00 2,359.00 9,033.00 2,113.00 1,480.00 3,007.00 3,100.00 9,700.00 2,500.00 2,100.00 2,600.00 4,100.00 11,300.00 2,500.00 1,885.67 2,581.33 3,186.33 10,153 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 2,393.25 1,885.67 2,581.33 3,186.33 10,046.58 Térmica 2,074.00 2,256.00 2,312.00 1,737.00 8,379.00 2,247.00 2,442.00 1,911.00 700.00 7,300.00 1,700.00 2,200.00 1,800.00 600.00 6,300.00 2,100.00 2,299.33 2,007.67 1,012.33 7,419 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 2,030.25 2,299.33 2,007.67 1,012.33 7,349.58 Carbón 738 671 887 765 3,061 835 909 556 400.00 2,700 800 800 800 200.00 2,600 800 0 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 Petróleo Gas 1,336 1,585 1,425 972 5,318 1,412 1,533 1,355 300.00 4,600 900 1,400 1,000 400.00 3,700 1,300 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Eólica, Solar & Geotérmica 39.00 6.00 28.00 79.00 152.00 26.00 32.00 42.00 0.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 0 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 16.25 12.67 23.33 26.33 78.58 Check 0 0 0 0 0 (1) 1 0 27 27 (100) 0 100 227 227 (100) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Factor Planta 32.88% 31.20% 32.19% 30.02% 31.57% 31.54% 28.42% 35.66% 27.13% 30.69% 30.92% 30.92% 30.92% 32.55% 31.61% 34.21% 31.30% 31.30% 33.61% 33.23% 32.87% 31.08% 34.15% 31.28% 32.34% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% 32.09% 30.34% 33.33% 30.54% 31.57% Deuda & Patrimonio Deuda y Patrimonio 2015 1Q16 2Q16 3Q16 4Q16 2016 1Q17 2Q17 3Q17 4Q17 2017 1Q18 2Q18 3Q18 4Q18 2018 1Q19 2Q19 3Q19 4Q19 2019 1Q20 2Q20 3Q20 4Q20 2020 1Q21 2Q21 3Q21 4Q21 2021 1Q22 2Q22 3Q22 4Q22 2022 1Q23 2Q23 3Q23 4Q23 2023 1Q24 2Q24 3Q24 4Q24 2024 1Q25 2Q25 3Q25 4Q25 2025 1Q26 2Q26 3Q26 4Q26 2026 1Q27 2Q27 3Q27 4Q27 2027 1Q28 2Q28 3Q28 4Q28 2028 1Q29 2Q29 3Q29 4Q29 2029 Caja inicial 139,649,084 19,175,921 9,152,758 13,487,584 13,487,584 -495494299.755653 -490447570.927108 -431274949.473628 -91866778.6879317 -86,544,202 209596151.738511 227718298.776253 312667258.331597 644496086.018479 644,496,086 924402510.467824 947846298.155763 1043474468.32904 1387184848.44342 1,387,184,848 1675546909.21503 1699301877.68023 1794812651.09481 2155006009.57944 2,155,006,010 2,445,666,514 2477368663.66244 2581538778.66982 2946176390.44363 2,946,176,390 3,236,076,085 3268861872.14063 3375757834.51595 3744512995.45019 3,744,512,995 4,035,623,352 4069545944.38619 4178647231.80365 4551677496.10708 5,153,890,127 5,446,442,710 5481075072.41913 5590978693.85179 5967646460.56929 5,967,646,461 6,281,946,791 6324595219.29177 6445133801.19773 6837110129.78212 6,837,110,130 7,159,369,635 7209625502.78714 7340956937.34658 7750674201.31583 7,750,674,201 Caja mínima operativa 2,615,760 1,781,825 1,847,945 1,946,340 8,191,870 1,952,443 1,992,446 2,033,268 2,074,927 8,053,084 2,180,600 2,220,041 2,260,194 2,301,074 8,961,910 2,267,838 2,307,180 2,347,206 2,387,925 9,310,149 2,350,919 2,391,636 2,433,058 2,475,198 9,650,811 2,435,150 2,478,363 2,522,342 2,567,102 10,002,957 2,508,934 2,539,659 2,570,760 2,602,241 10,221,593 2,540,033 2,571,139 2,602,625 2,634,497 10,348,294 2,567,990 2,599,438 2,631,271 2,663,494 10,462,194 2,696,111 2,729,128 2,762,549 2,796,380 10,984,169 2,830,625 2,865,289 2,900,377 2,935,895 11,532,186 Flujo de caja disponible para pagar deuda 353,116,365 -59,227,782 -31,829,053 209,115,533 476,497,640 172,560,929 -55,856,684 -23,607,777 229,898,391 0 153,825,678 -53,654,656 -16,822,160 237,289,488 0 159,709,704 -55,901,426 -21,052,429 244,703,898 0 150,080,034 -51,320,843 -17,042,876 249,081,276 0 146,665,257 -51,681,062 -15,882,969 251,959,548 0 147,068,748 -51,010,455 -14,511,553 254,886,267 602,212,631 147,632,880 -50,563,389 -14,398,744 257,415,272 0 160,498,611 -47,101,026 -10,339,212 267,232,293 0 160,801,473 -44,253,348 -6,331,818 278,266,688 0 0 0 0 0 0 Caja disponible para pagar deuda y distribuir capital 490,149,689 -41,833,686 -24,524,240 220,656,777 481,793,354 -324,885,813 -548,296,700 -456,915,995 135,956,685 -94,597,286 361,241,229 171,843,602 293,584,904 879,484,500 635,534,176 1,081,844,376 889,637,691 1,020,074,834 1,629,500,821 1,377,874,699 1,823,276,024 1,645,589,398 1,775,336,717 2,401,612,088 2,145,355,198 2,589,896,621 2,423,209,239 2,563,133,468 3,195,568,837 2,936,173,434 3,380,635,899 3,215,311,758 3,358,675,5223,996,797,021 4,336,504,033 4,180,716,199 4,016,411,417 4,161,645,863 4,806,458,271 5,143,541,833 5,604,373,330 5,431,374,609 5,578,008,210 6,232,215,260 5,957,184,266 6,440,052,153 6,277,612,743 6,436,039,434 7,112,580,438 6,826,125,961 7,156,539,010 7,206,760,214 7,338,056,560 7,747,738,306 7,739,142,016 Pagos obligatorios 0 0 0 0 0 -24,150,000 -24,150,000 -24,150,000 -24,150,000 -96,600,000 -24,150,000 -24,150,000 -24,150,000 -24,150,000 -96,600,000 -24,150,000 -24,150,000 -24,150,000 -24,150,000 -96,600,000 -24,150,000 -24,150,000 -24,150,000 -24,150,000 -96,600,000 -24,150,000 -24,150,000 -24,150,000 -20,570,703 -93,020,703 -9,150,000 -9,150,000 -9,150,000 -9,150,000 -36,600,000 -9,150,000 -9,150,000 -9,150,000 -9,150,000 -36,600,000 -9,150,000 -9,150,000 -9,150,000 -9,150,000 -36,600,000 -9,150,000 -9,150,000 -9,150,000 -9,150,000 -36,600,000 -9,150,000 -9,150,000 -9,150,000 -9,132,519 -36,582,519 Caja disponible después de pagos obligatorios 490,149,689 -41,833,686 -24,524,240 220,656,777 481,793,354 -349,035,813 -572,446,700 -481,065,995 111,806,685 -191,197,286 337,091,229 147,693,602 269,434,904 855,334,500 538,934,176 1,057,694,376 865,487,691 995,924,834 1,605,350,821 1,281,274,699 1,799,126,024 1,621,439,398 1,751,186,717 2,377,462,088 2,048,755,198 2,565,746,621 2,399,059,239 2,538,983,468 3,174,998,134 2,843,152,731 3,371,485,899 3,206,161,758 3,349,525,522 3,987,647,021 4,299,904,033 4,171,566,199 4,007,261,417 4,152,495,863 4,797,308,271 5,106,941,833 5,595,223,330 5,422,224,609 5,568,858,210 6,223,065,260 5,920,584,266 6,430,902,153 6,268,462,743 6,426,889,434 7,103,430,438 6,789,525,961 7,147,389,010 7,197,610,214 7,328,906,560 7,738,605,787 7,702,559,497 Emision / pagos deuda revolver Caja disponible para distribuir dividendos y capital 490,149,689 -41,833,686 -24,524,240 220,656,777 481,793,354 -349,035,813 -572,446,700 -481,065,995 111,806,685 -191,197,286 337,091,229 147,693,602 269,434,904 855,334,500 538,934,176 1,057,694,376 865,487,691 995,924,834 1,605,350,821 1,281,274,699 1,799,126,024 1,621,439,398 1,751,186,717 2,377,462,088 2,048,755,198 2,565,746,621 2,399,059,239 2,538,983,468 3,174,998,134 2,843,152,731 3,371,485,899 3,206,161,758 3,349,525,522 3,987,647,021 4,299,904,033 4,171,566,199 4,007,261,417 4,152,495,863 4,797,308,271 5,106,941,833 5,595,223,330 5,422,224,609 5,568,858,210 6,223,065,260 5,920,584,266 6,430,902,153 6,268,462,743 6,426,889,434 7,103,430,438 6,789,525,961 7,147,389,010 7,197,610,214 7,328,906,560 7,738,605,787 7,702,559,497 Distribucion de dividendos y capital 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Caja disponible para acelerar deuda 490,149,689 -41,833,686 -24,524,240 220,656,777 481,793,354 -349,035,813 -572,446,700 -481,065,995 111,806,685 -191,197,286 337,091,229 147,693,602 269,434,904 855,334,500 538,934,176 1,057,694,376 865,487,691 995,924,834 1,605,350,821 1,281,274,699 1,799,126,024 1,621,439,398 1,751,186,717 2,377,462,088 2,048,755,198 2,565,746,621 2,399,059,239 2,538,983,468 3,174,998,134 2,843,152,731 3,371,485,899 3,206,161,758 3,349,525,522 3,987,647,021 4,299,904,033 4,171,566,199 4,007,261,417 4,152,495,863 4,797,308,271 5,106,941,833 5,595,223,330 5,422,224,609 5,568,858,210 6,223,065,260 5,920,584,266 6,430,902,153 6,268,462,743 6,426,889,434 7,103,430,438 6,789,525,961 7,147,389,010 7,197,610,214 7,328,906,560 7,738,605,787 7,702,559,497 Pagos acelerados Caja disponible después de pagos de deuda y dividendos 490,149,689 -41,833,686 -24,524,240 220,656,777 481,793,354 -349,035,813 -572,446,700 -481,065,995 111,806,685 -191,197,286 337,091,229 147,693,602 269,434,904 855,334,500 538,934,176 1,057,694,376 865,487,691 995,924,834 1,605,350,821 1,281,274,699 1,799,126,024 1,621,439,398 1,751,186,717 2,377,462,088 2,048,755,198 2,565,746,621 2,399,059,239 2,538,983,468 3,174,998,134 2,843,152,731 3,371,485,899 3,206,161,758 3,349,525,522 3,987,647,021 4,299,904,033 4,171,566,199 4,007,261,417 4,152,495,863 4,797,308,271 5,106,941,833 5,595,223,330 5,422,224,609 5,568,858,210 6,223,065,260 5,920,584,266 6,430,902,153 6,268,462,743 6,426,889,434 7,103,430,438 6,789,525,961 7,147,389,010 7,197,610,214 7,328,906,560 7,738,605,787 7,702,559,497 Derivados Financieros ERROR:#REF! 29,392,114 29,392,114 24,014,724 25,696,064 25,696,064 33,152,851 23,759,133 25,132,735 18,815,435 18,815,435 22,100,532 36,942,597 40,922,048 125,350,544 125,350,544 111,606,890 103,621,038 163,561,531 96,335,567 96,335,567 Total Deuda de Corto Plazo 16,613,346 18,893,793 15,891,570 18,758,264 16,168,473 16,168,473 18,978,364 16,021,640 18,546,379 15,455,782 15,455,782 18,303,003 28,242,651 31,485,385 41,780,543 41,780,543 44,376,146 41,883,093 45,336,378 43,388,605 43,388,605 BNY Mellon - Primera Emisión S-1 4,797,465 1,809,926 4,438,080 1,748,459 4,522,585 4,522,585 1,794,172 4,457,674 1,695,077 4,152,926 4,152,926 1,630,473 4,369,902 1,784,579 4,693,498 4,693,498 1,833,516 4,587,978 1,967,760 5,058,091 5,058,091 Tasa Efectiva 1 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% 7.96% BNY Mellon - Primera Emisión S-2 1,534,133 578,778 1,419,209 559,122 1,446,232 1,446,232 573,740 1,425,475 542,052 1,328,023 1,328,023 521,393 1,397,407 570,673 1,500,880 1,500,880 586,322 1,467,144 629,250 1,617,476 1,617,476 Tasa Efectiva 2 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% 7.40% BNY Mellon - Primera Emisión S-3 971,676 336,581 898,887 354,132 916,002 916,002 363,391 902,855 343,320 841,132 841,132 330,235 885,078 361,448 950,619 950,619 371,359 929,247 398,549 1,024,463 1,024,463 Tasa Efectiva 3 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% 8.26% BNY Mellon - Unica 24296 2,548,685 5,250,488 2,342,352 5,127,072 2,402,653 2,402,653 5,204,787 2,352,694 4,970,538 2,206,269 2,206,269 4,729,907 2,306,369 5,208,145 2,493,452 2,493,452 5,318,921 2,437,394 5,708,357 2,828,573 2,828,573 Tasa Efectiva 4 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% Banco Santander -317 Serie-H 6,232,249 7,366,824 6,288,804 7,395,841 6,337,021 6,337,021 7,400,291 6,366,839 7,362,817 6,374,051 6,374,051 7,380,890 6,413,478 7,397,280 6,513,162 6,513,162 7,413,782 6,544,779 7,450,318 6,592,332 6,592,332 Tasa Efectiva 5 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% 7.17% Banco Santander 522 Serie-M 529,138 3,551,196 504,238 3,573,638 543,980 543,980 3,641,983 516,103 3,632,575 553,381 553,381 3,710,105 12,870,417 16,163,260 25,628,932 25,628,932 28,852,246 25,916,551 29,182,144 26,267,670 26,267,670 Tasa Efectiva 6 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% ERROR:#REF! 10,498,321 13,500,544 5,256,460 9,527,591 9,527,591 14,174,487 7,737,493 6,586,356 3,359,653 3,359,653 3,797,529 8,699,946 9,436,663 83,570,001 83,570,001 67,230,744 61,737,945 118,225,153 52,946,962 52,946,962 Derivados Financieros ERROR:#REF! 967,940,065 967,940,065 988,638,395 854,016,751 854,016,751 843,895,859 843,858,793 812,210,548 781,978,145 781,978,145 771,001,420 811,698,891 826,553,755 799,813,225 799,813,225 786,541,948 774,109,087 821,539,566 829,976,921 829,976,921 Total Deuda de Largo Plazo 807,552,168 781,625,676 776,249,951 776,309,242 786,137,688 786,137,688 783,982,310 784,040,955 765,440,202 748,123,803 748,123,803 742,419,546 763,858,200 772,973,316 784,713,705 784,713,705 773,421,095 762,045,816 798,865,603 800,772,841 800,772,841 BNY Mellon - Primera Emisión S-1 145,068,065 136,775,515 135,056,915 134,384,548 136,759,395 136,759,395 135,644,927 135,728,871
Compartir