Datos Enel V7

Vista previa del material en texto

[Content_Types].xml
 
_rels/.rels
 
xl/workbook.xml
 [2]Cover!$F$3 [1]Cover!$P$6 Cover!$F$3 110000 5000 10000 500000 700000 100000 500 10001 10002 10003 1001 1002 1003 501 502 503 1000 1000 500 2000 120000 15000 800000 "10/17/2019 12:42:15" "10/17/2019 12:42:15" 43262.104224537 6000 750000 0 50000 3000 130000 
xl/_rels/workbook.xml.rels
 
xl/worksheets/sheet1.xml
 387 0 "Modelación Financiera: modelo completo (3 estados financieros) de compañía Enel Generación Chile" Modelación Financiera: modelo completo (3 estados financieros) de compañía Enel Generación Chile 4 5 6 8 9 10 11 9 12 13 9 14 15 9 16"1,0" 
xl/worksheets/sheet2.xml
 1 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 7 76 77 +Ventas!C6 17622 +Ventas!D6 18516 +Ventas!E6 17010 +Ventas!F6 16993 +Ventas!G6 16993 16993 16993 18200 18200 18200 18200 18200 18200 18200 18200 78 +Ventas!C7 4319 +Ventas!D7 4321 +Ventas!E7 5604 +Ventas!F7 5598 +Ventas!G7 5598 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 79 +Ventas!C8 1618 +Ventas!D8 852 +Ventas!E8 742 +Ventas!F8 752 +Ventas!G8 752 +G6 752 +H6 752 752 752 752 752 752 752 752 752 501 77 +Ventas!C15 61351.848825331974 +Ventas!D15 63730.967649600345 +Ventas!E15 64731.869841269843 +Ventas!F15 58689.791973165418 +Ventas!G15 53036.827811451774 +H11+H12 52667.422040175181 +I11+I12 52301.710326611348 51939.655730183156 51581.221679719245 51226.371969759974 50875.070756900299 50527.282556169215 50182.972237445443 49842.105021908908 49504.646478527742 80 +Ventas!C16 56401.229451261868 +Ventas!D16 54302.68641518167 +Ventas!E16 50967.833154889362 +Ventas!F16 60333.78742408003 +Ventas!G16 82349.733476241512 +H11+H13 81980.327704964919 +I11+I13 81614.615991401079 81252.561394972901 80894.127344508976 80539.277634549711 80187.976421690037 79840.188220958953 79495.877902235181 79155.010686698646 78817.552143317473 79 +Ventas!C17 92755.980222496903 +Ventas!D17 119722.93075117371 +Ventas!E17 95631.912398921835 +Ventas!F17 45570.655585106382 +Ventas!G17 36940.577127659577 +G11*(1-1%) 36571.171356382984 +H11*(1-1%) 36205.459642819151 35843.405046390959 35484.970995927048 35130.121285967776 34778.820073108101 34431.031872377018 34086.721553653246 33745.854338116711 33408.395794735545 509 +G9-G11 16096.250683792197 +G12 16096.250683792197 +H12 16096.250683792197 16096.250683792197 16096.250683792197 16096.250683792197 16096.250683792197 16096.250683792197 16096.250683792197 16096.250683792197 16096.250683792197 510 +G10-G11 45409.156348581935 +G13 45409.156348581935 +H13 45409.156348581935 45409.156348581935 45409.156348581935 45409.156348581935 45409.156348581935 45409.156348581935 45409.156348581935 45409.156348581935 45409.156348581935 481 +C16+C20+C18+C19 -880891223 +D16+D20+D18+D19 -895060114 +E16+E20+E18+E19 -903978006 +F16+F20+F18+F19 -809974152 +G16+G20+G18+G19 -834936802 +H16+H20+H19+H18 -865484571.47615623 -844766142.90125442 -918648990.581429 -923189841.99794221 -935581644.56719041 -940075580.42582273 -944659395.00162768 -949334885.8689487 -947293230.59271264 -952406966.80945158 482 -320731795 -335731822 -346954692 -326365798 -327157312 -Ventas!H11 -386744437.58651519 -Ventas!I11 -361661484.38982052 -Ventas!J11 -431092516.9557665 -Ventas!K11 -431092516.9557665 -Ventas!L11 -450370948.83557636 -Ventas!M11 -450370948.83557636 -Ventas!N11 -450370948.83557636 -Ventas!O11 -450370948.83557636 -Ventas!P11 -431092516.9557665 -Ventas!Q11 -431092516.9557665 502 +Ventas!C12 60940.86927607828 +Ventas!D12 54813.358693877548 +Ventas!E12 55221.182874423044 +Ventas!F12 57621.080155367228 +Ventas!G12 59021.705213783149 +AVERAGE($C$17:$G$17) 57523.639242705853 +AVERAGE($C$17:$G$17) 57523.639242705853 57523.639242705853 57523.639242705853 57523.639242705853 57523.639242705853 57523.639242705853 57523.639242705853 57523.639242705853 57523.639242705853 486 -179691471 -192502995 -152869838 -141551194 -158965923 +AVERAGE($C18:$G18) -165116284.19999999 -165116284.19999999 -165116284.19999999 -165116284.19999999 -165116284.19999999 -165116284.19999999 -165116284.19999999 -165116284.19999999 -165116284.19999999 -165116284.19999999 487 -52964961 -71676459 -123414114 -111063406 -117869153 -95397618.599999994 -95397618.599999994 -95397618.599999994 -95397618.599999994 -95397618.599999994 -95397618.599999994 -95397618.599999994 -95397618.599999994 -95397618.599999994 -95397618.599999994 483 -327502996 -295148838 +SUM(E21:E23) -280739362 +SUM(F21:F23) -230993754 +SUM(G21:G23) -230944414 -H24*Generación!H31 -218226231.08964097 -I24*Generación!I31 -222590755.7114338 -J24*Generación!J31 -227042570.82566249 -K24*Generación!K31 -231583422.24217573 -L24*Generación!L31 -224696792.93161407 -M24*Generación!M31 -229190728.79024637 -N24*Generación!N31 -233774543.36605129 -O24*Generación!O31 -238450034.23337233 -P24*Generación!P31 -255686810.83694613 -Q24*Generación!Q31 -260800547.05368504 485 -170456730 -140113581 -134127364 484 -21227747 -11143015 -3326061 106 -89054885 -79737158 -93490989 488 -C20/Generación!C31 53697.818658796525 -D20/Generación!D31 35224.828499820978 -E20/Generación!E31 38457.446849315071 -F20/Generación!F31 36665.675238095238 -G20/Generación!G31 31128.779350316756 +G24*(1+Inflación!H10) 31751.354937323093 +H24*(1+Inflación!I10) 32386.382036069554 +I24*(1+Inflación!J10) 33034.109676790948 +J24*(1+Inflación!K10) 33694.791870326764 +K24*(1+Inflación!L10) 34368.687707733297 +L24*(1+Inflación!M10) 35056.061461887963 +M24*(1+Inflación!N10) 35757.182691125723 +N24*(1+Inflación!O10) 36472.32634494824 +O24*(1+Inflación!P10) 37201.772871847206 +P24*(1+Inflación!Q10) 37945.808329284147 17 -EERR!C11/EERR!C2 9.460901212515993E-2 -EERR!D11/EERR!D2 0.10236321997533329 -EERR!E11/EERR!E2 9.1634723539806118E-2 -EERR!F11/EERR!F2 8.4697847676676832E-2 -EERR!G11/EERR!G2 8.1602247105972137E-2 AVERAGE(G26,F26,E26,D26) 9.0074509574447098E-2 H26 9.0074509574447098E-2 9.0074509574447098E-2 9.0074509574447098E-2 9.0074509574447098E-2 9.0074509574447098E-2 9.0074509574447098E-2 9.0074509574447098E-2 9.0074509574447098E-2 9.0074509574447098E-2 19 +EERR!C19 -13424071 +EERR!D19 -15609950 +EERR!E19 -17731408 +EERR!F19 -24954582 +EERR!G19 -28075801 -2500000 -2500000 -2500000 -2500000 -2500000 -2500000 -2500000 -2500000 -2500000 -2500000 20 -EERR!C33/EERR!C32 0.25510520700222716 -EERR!D33/EERR!D32 0.15848532691395739 -EERR!E33/EERR!E32 0.20850158377058298 -EERR!F33/EERR!F32 0.2480125345029682 -EERR!G33/EERR!G32 0.10435796142074169 AVERAGE(G28,F28,E28,D28) 0.17983935165206255 H28 0.17983935165206255 0.17983935165206255 0.17983935165206255 0.17983935165206255 0.17983935165206255 0.17983935165206255 0.17983935165206255 0.17983935165206255 0.17983935165206255 22 0.24 0.255 0.26 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 23 EERR!D43 8201754580 EERR!E43 8201754580 EERR!F43 8201754580 EERR!G43 8201754580 +G30 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 24 +EERR!D44 8201754580 +EERR!E44 8201754580 +EERR!F44 8201754580 +EERR!G44 8201754580 +G31 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 8201754580 25 -#REF!/EERR!D34 #REF! -#REF!/EERR!E34 #REF! -#REF!/EERR!F34 #REF! -#REF!/EERR!G34 #REF! 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 28 29 Balance!D5/EERR!D2 2.9348561540542509E-4 Balance!E5/EERR!E2 1.2552946076821309E-2 Balance!F5/EERR!F2 2.5353818470613139E-2 Balance!G5/EERR!G2 1.0008398570778101E-4 AVERAGE(G35,F35,E35,D35) 9.5750835371369129E-3 H35 9.5750835371369129E-3 9.5750835371369129E-3 9.5750835371369129E-3 9.5750835371369129E-3 9.5750835371369129E-3 9.5750835371369129E-3 9.5750835371369129E-3 9.5750835371369129E-3 9.5750835371369129E-3 31 Balance!D6/EERR!D2 2.6566344947090694E-3 Balance!E6/EERR!E2 1.3255997020068663E-3 Balance!F6/EERR!F2 7.1254814096014998E-3 Balance!G6/EERR!G2 4.6320193069470097E-3 AVERAGE(G36,F36,E36,D36) 3.9349337283161112E-3 H36 3.9349337283161112E-3 3.9349337283161112E-3 3.9349337283161112E-3 3.9349337283161112E-33.9349337283161112E-3 3.9349337283161112E-3 3.9349337283161112E-3 3.9349337283161112E-3 3.9349337283161112E-3 491 ROUND(365/(EERR!D2/Balance!D7),) 57 ROUND(365/(EERR!E2/Balance!E7),) 49 ROUND(365/(EERR!F2/Balance!F7),) 57 ROUND(365/(EERR!G2/Balance!G7),) 47 AVERAGE(G37,F37,E37,D37) 52.5 H37 52.5 52.5 52.5 52.5 52.5 52.5 52.5 52.5 52.5 33 Balance!G8 288344589 Balance!H8 288344589 Balance!I8 288344589 Balance!J8 288344589 Balance!K8 288344589 Balance!L8 288344589 Balance!M8 288344589 Balance!N8 288344589 Balance!O8 288344589 Balance!P8 288344589 492 ROUND(-365/(EERR!D5/Balance!D9),) 14 ROUND(-365/(EERR!E5/Balance!E9),) 13 ROUND(-365/(EERR!F5/Balance!F9),) 20 ROUND(-365/(EERR!G5/Balance!G9),) 13 AVERAGE(G39,F39,E39,D39) 15 H39 15 15 15 15 15 15 15 15 15 36 Balance!D10/EERR!D2 2.0749441323783972E-2 Balance!E10/EERR!E2 3.9857626318322972E-2 Balance!F10/EERR!F2 3.4695200827847009E-2 Balance!G10/EERR!G2 2.603057299493278E-2 AVERAGE(G40,F40,E40,D40) 3.0333210366221684E-2 AVERAGE(H40,G40,F40,E40) 3.2729152626831112E-2 3.0947034203958144E-2 3.0009992547985927E-2 3.1004847436249219E-2 3.1172756703756101E-2 3.078365772298735E-2 3.0742813602744647E-2 3.092601886643433E-2 3.090631172398061E-2 37 Balance!D14/EERR!D2 1.7353798546387449E-2 Balance!E14/EERR!E2 2.0423660361224928E-2 Balance!F14/EERR!F2 1.5532453154194395E-3 Balance!G14/EERR!G2 4.3881488597841516E-3 AVERAGE(G42,F42,E42,D42) 1.0929713270703991E-2 9.3236919517831265E-3 6.548699849422677E-3 7.7975634829234863E-3 8.6499171387083192E-3 8.0799681057094029E-3 7.7690371441909711E-3 8.0741214678830449E-3 8.1432609641229337E-3 8.0165969204765881E-3 38 Balance!D15/EERR!D2 7.4219693961717799E-3 Balance!E15/EERR!E2 7.8617457431081443E-3 Balance!F15/EERR!F2 8.2477670089293343E-3 Balance!G15/EERR!G2 9.0612119088803907E-3 8.1481735142724127E-3 8.3297245437975696E-3 8.4467192439699277E-3 8.496457302730076E-3 8.3552686511924965E-3 8.4070424354225175E-3 8.4263719083287544E-3 8.4212850744184616E-3 8.4024920173405571E-3 8.4142978588775726E-3 493 ROUND(365/(EERR!D2/Balance!D16),) 1 ROUND(365/(EERR!E2/Balance!E16),) 0 ROUND(365/(EERR!F2/Balance!F16),) 0 ROUND(365/(EERR!G2/Balance!G16),) 18 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 AVERAGE(F44,E44,D44) 0.33333333333333331 39 0 0 0 0 0 0 0 0 0 0 40 Balance!G18 7911342 +G46 7911342 7911342 7911342 7911342 7911342 7911342 7911342 7911342 7911342 7911342 383 Balance!G19 30393637 +G47+H27 27893637 25393637 22893637 20393637 17893637 15393637 12893637 10393637 7893637 5393637 41 Balance!G20 24860356 +G48 24860356 24860356 24860356 24860356 24860356 24860356 24860356 24860356 24860356 24860356 42 0 0 0 0 0 0 0 0 0 0 0 494 ROUND(-365/(EERR!D5/Balance!D30),) 139 ROUND(-365/(EERR!E5/Balance!E30),) 133 ROUND(-365/(EERR!F5/Balance!F30),) 124 ROUND(-365/(EERR!G5/Balance!G30),) 100 AVERAGE(G51,F51,E51,D51) 124 H51 124 124 124 124 124 124 124 124 124 43 +Balance!G8 288344589 +G52 288344589 288344589 288344589 288344589 288344589 288344589 288344589 288344589 288344589 288344589 44 Balance!D32/EERR!D2 3.9123470305658702E-3 Balance!E32/EERR!E2 3.2396569409096497E-3 Balance!F32/EERR!F2 3.4074181455753709E-3 Balance!G32/EERR!G2 2.2093453631466318E-3 AVERAGE(G53,F53,E53,D53) 3.1921918700493802E-3 H53 3.1921918700493802E-3 3.1921918700493802E-3 3.1921918700493802E-3 3.1921918700493802E-3 3.1921918700493802E-3 3.1921918700493802E-3 3.1921918700493802E-3 3.1921918700493802E-3 3.1921918700493802E-3 45 Balance!D33/EERR!D2 3.7028945121697722E-2 Balance!E33/EERR!E2 4.0939351791536918E-2 Balance!F33/EERR!F2 8.2450550736528749E-3 Balance!G33/EERR!G2 1.0780652036714449E-2 AVERAGE(G54,F54,E54,D54) 2.4248501005900491E-2 H54 2.4248501005900491E-2 2.4248501005900491E-2 2.4248501005900491E-2 2.4248501005900491E-2 2.4248501005900491E-2 2.4248501005900491E-2 2.4248501005900491E-2 2.4248501005900491E-2 2.4248501005900491E-2 46 Balance!G34 4811150 +G55 4811150 4811150 4811150 4811150 4811150 4811150 4811150 4811150 4811150 4811150 47 0 0 0 0 0 0 0 0 0 0 0 48 Balance!D38/EERR!D2 8.7545843382676788E-4 Balance!E38/EERR!E2 3.8695252477618402E-4 Balance!F38/EERR!F2 2.9612426646259763E-4 Balance!G38/EERR!G2 1.2207224968169661E-9 AVERAGE(G58,F58,E58,D58) 3.8963411144701159E-4 2.6817803085207252E-4 2.3848440737104463E-4 2.2407444259815639E-4 2.800927480670713E-4 2.527074072220862E-4 2.4883975131458964E-4 2.5142858730047588E-4 2.5826712347605573E-4 2.5281071732830186E-4 49 0 0 0 0 0 0 0 0 0 0 0 50 Balance!D40/EERR!D2 3.4539364003839189E-2 Balance!E40/EERR!E2 3.9140692882967357E-2 Balance!F40/EERR!F2 5.2262313501032838E-2 Balance!G40/EERR!G2 8.755515224240619E-2 AVERAGE(G60,F60,E60,D60) 5.33743806575614E-2 H60 5.33743806575614E-2 5.33743806575614E-2 5.33743806575614E-2 5.33743806575614E-2 5.33743806575614E-2 5.33743806575614E-2 5.33743806575614E-2 5.33743806575614E-2 5.33743806575614E-2 51 Balance!D41/EERR!D2 0.11163101220863431 Balance!E41/EERR!E2 9.8042870153406528E-2 Balance!F41/EERR!F2 0.12063174745932755 Balance!G41/EERR!G2 7.9404779372719544E-2 AVERAGE(G61,F61,E61,D61) 0.10242760229852198 H61 0.10242760229852198 0.10242760229852198 0.10242760229852198 0.10242760229852198 0.10242760229852198 0.10242760229852198 0.10242760229852198 0.10242760229852198 0.10242760229852198 52 Balance!D42/EERR!D2 9.5320236400323662E-3 Balance!E42/EERR!E2 9.098789739298823E-3 Balance!F42/EERR!F2 9.6058226729623004E-3 Balance!G42/EERR!G2 1.1684312006904406E-2 AVERAGE(G62,F62,E62,D62) 9.9802370147994736E-3 H62 9.9802370147994736E-3 9.9802370147994736E-3 9.9802370147994736E-3 9.9802370147994736E-3 9.9802370147994736E-3 9.9802370147994736E-3 9.9802370147994736E-3 9.9802370147994736E-3 9.9802370147994736E-3 53 Balance!G47 552777321 +G64 552777321 552777321 552777321 552777321 552777321 552777321 552777321 552777321 552777321 552777321 54 Balance!G49 85511492 +G65 85511492 85511492 85511492 85511492 85511492 85511492 85511492 85511492 85511492 85511492 2 55 Cálculos!D4/EERR!D2 0.11741713848120805 Cálculos!E4/EERR!E2 0.12647316869090369 Cálculos!F4/EERR!F2 0.14616643985026173 Cálculos!G4/EERR!G2 0.12374792812874227 AVERAGE(G68,F68,E68,D68) 0.12845116878777896 H68 0.12845116878777896 0.12845116878777896 0.12845116878777896 0.12845116878777896 0.12845116878777896 0.12845116878777896 0.12845116878777896 0.12845116878777896 0.12845116878777896 474 (957.3*1000*695-419021*1000)/2 123151250 (957.3*1000*695-419021*1000)/2 123151250 0 0 0 0 0 0 0 0 0 479 82832000 82832000 82832000 82832000 82832000 56 -EERR!D18/Balance!D21 4.2903181986238742E-2 -EERR!E18/Balance!E21 3.5724277743714894E-2 -EERR!F18/Balance!F21 3.1794553725420428E-2 -EERR!G18/Balance!G21 2.8890280994819592E-2 AVERAGE(G71,F71,E71,D71) 3.4828073612548416E-2 H71 3.4828073612548416E-2 3.4828073612548416E-2 3.4828073612548416E-2 3.4828073612548416E-2 3.4828073612548416E-2 3.4828073612548416E-2 3.4828073612548416E-2 3.4828073612548416E-2 3.4828073612548416E-2 202 +EERR!D21 0 +EERR!E21 0 +EERR!F21 -101000 +EERR!G21 -1348000 0 0 0 0 0 0 0 0 0 0 57 58 +Balance!D47 552777321+Balance!E47 552777321 +Balance!F47 552777321 +Balance!G47 552777321 +G76 552777321 552777321 552777321 552777321 552777321 552777321 552777321 552777321 552777321 552777321 59 0 0 0 0 0 0 0 0 0 0 60 +Balance!H51-Balance!H50-Balance!H49-Balance!H47 1615568433.3065805 +Balance!I51-Balance!I50-Balance!I49-Balance!I47 1666450639.1652331 +Balance!J51-Balance!J50-Balance!J49-Balance!J47 1678360636.5671811 +Balance!K51-Balance!K50-Balance!K49-Balance!K47 1670852628.0920634 +Balance!L51-Balance!L50-Balance!L49-Balance!L47 1861474816.6581731 +Balance!M51-Balance!M50-Balance!M49-Balance!M47 1646287604.135787 +Balance!N51-Balance!N50-Balance!N49-Balance!N47 1555757026.254775 +Balance!O51-Balance!O50-Balance!O49-Balance!O47 1459836122.334641 +Balance!P51-Balance!P50-Balance!P49-Balance!P47 1355427355.5947831 +Balance!Q51-Balance!Q50-Balance!Q49-Balance!Q47 1217450075.4056096 61 +Balance!G49 85511492 +G79 85511492 85511492 85511492 85511492 85511492 85511492 85511492 85511492 85511492 85511492 62 Balance!G50 -226577889 +G80 -226577889 -226577889 -226577889 -226577889 -226577889 -226577889 -226577889 -226577889 -226577889 -226577889 504 +EERR!C38/EERR!C36 0.38133033286894802 +EERR!D38/EERR!D36 9.3730342595007593E-2 +EERR!E38/EERR!E36 1.6656405243195737E-2 +EERR!F38/EERR!F36 2.8836756179192659E-2 +EERR!G38/EERR!G36 2.4750421953904481E-2 +G81 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 2.4750421953904481E-2 63 66 0 0 0 0 0 10449623 10449623 10449623 10449623 10449623 67 0 0 0 0 0 3334972 3334972 3334972 3334972 3334972 68 0 0 0 0 0 2120644 2120644 2120644 2120644 2120644 69 0 0 0 0 296420703 0 0 0 0 0 70 5888467 5888467 5888467 5888467 5888467 5888467 5888467 5888467 5888467 5888467 71 25736309 25736309 25736309 25736309 25736309 25736309 25736309 25736309 25736309 25736309 405 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 408 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.0000000000000007E-2 72 73 +AVERAGE(Balance!D4:G4/EERR!D2:G2) 7.6552257884829208E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 7.4999999999999997E-2 74 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02xl/worksheets/sheet3.xml
 0 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2 3 +H19+H25 2747643715 +I19+I25+I46 2958965969.7584348 +J19+J25+J46 3004195896.2580662 3016318635.4700737 2985712852.4847198 2912644774.4783692 2817522246.2685966 2720626796.1563931 2622863508.8820233 2525131185.429564 476 -SUM('EFE acumulado'!D23:D24) 194880395 -SUM('EFE acumulado'!E23:E24) 206775663 -SUM('EFE acumulado'!F23:F24) 222327048 -SUM('EFE acumulado'!G23:G24) 202745388 Supuestos!H68*EERR!H2 201442799.12974229 Supuestos!I68*EERR!I2 200205990.45434853 Supuestos!J68*EERR!J2 207910446.90239915 Supuestos!K68*EERR!K2 206636632.66141942 Supuestos!L68*EERR!L2 205375556.56284952 Supuestos!M68*EERR!M2 204127091.22526529 Supuestos!N68*EERR!N2 202891110.54105693 Supuestos!O68*EERR!O2 201667489.66369063 Supuestos!P68*EERR!P2 200456104.99509802 Supuestos!Q68*EERR!Q2 199256834.17319131 477 H47 123151250 J47 0 0 0 0 0 0 0 0 0 479 -Supuestos!H70 -82832000 -Supuestos!I70 -82832000 -Supuestos!J70 -82832000 -Supuestos!K70 -82832000 -Supuestos!L70 0 -Supuestos!M70 0 -Supuestos!N70 0 -Supuestos!O70 0 -Supuestos!P70 0 -Supuestos!Q70 0 18 +H20+H27+H48 -113271794.37130755 +I20+I27+I48 -154976063.95471665 -195787707.69039142 -237242415.64677328 -278443634.56920016 -299249619.43503743 -299786560.65326053 -299430776.93806052 -298188428.44755757 -296958503.44195956 21 +H3+H4+H5+H7 2958965969.7584348 +I3+I4+I5+I7 3004195896.2580667 3016318635.4700737 2985712852.4847198 2912644774.4783692 2817522246.2685971 2720626796.1563931 2622863508.8820229 2525131185.429564 2427429516.1607962 390 391 5713190162 +G12+SUM(H6) 5630358162 +H12+SUM(I6) 5547526162 5464694162 5381862162 5381862162 5381862162 5381862162 5381862162 5381862162 5381862162 392 -2965546447 +G13+H20 -3057134570.8333335 +H13+I20 -3148722694.666667 -3240310818.5000005 -3331898942.333334 -3423487066.1666675 -3515075190.000001 -3606663313.8333344 -3698251437.6666679 -3789839561.5000014 -3881427685.3333349 393 +G12+G13 2747643715 +SUM(H12:H13) 2573223591.1666665 2398803467.333333 2224383343.4999995 2049963219.666666 1958375095.8333325 1866786971.999999 1775198848.1666656 1683610724.3333321 1592022600.4999986 1500434476.6666651 394 G12/Cálculos!G4 28.179137480552701 396 30 3 +F21 2919097994 +G21 2747643715 2656055591.1666665 2564467467.333333 2472879343.4999995 2381291219.666666 2289703095.8333325 2198114971.999999 2106526848.1666658 2014938724.3333325 1923350600.4999993 212 +G21-G19 -171454279 -MIN($G$14/$C$17,G21) -91588123.833333328 -MIN($G$14/$C$17,H21) -91588123.833333328 -91588123.833333328 -91588123.833333328 -91588123.833333328 -91588123.833333328 -91588123.833333328 -91588123.833333328 -91588123.833333328 -91588123.833333328 21 +Balance!F21 2919097994 +G14 2747643715 +H19+H20 2656055591.1666665 2564467467.333333 2472879343.4999995 2381291219.666666 2289703095.8333325 2198114971.999999 2106526848.1666658 2014938724.3333325 1923350600.4999993 1831762476.666666 480 3 +G28 0 +H28 181298519.21676806 +I28 321195350.79973328 427984995.09507436 492046117.19305384 513644944.27003652 513189321.14359772 510960776.11472744 507864393.92369092 504798975.55456471 397 Supuestos!H68*EERR!H2 201442799.12974229 Supuestos!I68*EERR!I2 200205990.45434853 Supuestos!J68*EERR!J2 207910446.90239915 Supuestos!K68*EERR!K2 206636632.66141942 Supuestos!L68*EERR!L2 205375556.56284952 Supuestos!M68*EERR!M2 204127091.22526529 Supuestos!N68*EERR!N2 202891110.54105693 Supuestos!O68*EERR!O2 201667489.66369063 Supuestos!P68*EERR!P2 200456104.99509802 Supuestos!Q68*EERR!Q2 199256834.17319131 398 -H43 -20144279.912974231 -I43 -60309158.871383317 -J43 -101120802.60705808 -142575510.56343994 -183776729.48586684 -204582714.35170412 -205119655.56992722 -204763871.85472718 -203521523.36422423 -202291598.35862625 21 0 +H26+H27+H25 181298519.21676806 +I26+I27+I25 321195350.79973328 427984995.09507436 492046117.19305384 513644944.27003652 513189321.14359772 510960776.11472744 507864393.92369092 504798975.55456471 501764211.36912978 395 5 368 265 +TRANSPOSE(H1:Q1) 2020 +TRANSPOSE(H26:Q26) 201442799.12974229 +$G$32/$C$30/2 20144279.912974231 +$G$32/$C$30 40288559.825948462 40288559.825948462 40288559.825948462 40288559.825948462 +H32 20144279.912974231 2021 200205990.45434853 +$G$33/$C$30/2 20020599.045434855 $G$33/$C$30 40041198.09086971 $G$33/$C$30 40041198.09086971 $G$33/$C$30 40041198.09086971 $G$33/$C$30 40041198.09086971 +$G$33/$C$30/2 20020599.045434855 2022 207910446.90239915 +$G$34/$C$30/2 20791044.690239914 +$G$34/$C$30 41582089.380479828 +$G$34/$C$30 41582089.380479828 +$G$34/$C$30 41582089.380479828 +$G$34/$C$30 41582089.380479828 +$G$34/$C$30/2 20791044.690239914 2023 206636632.66141942 +$G$35/$C$30/2 20663663.266141944 +$G$35/$C$30 41327326.532283887 +$G$35/$C$30 41327326.532283887 +$G$35/$C$30 41327326.532283887 +$G$35/$C$30 41327326.532283887 +$G$35/$C$30/2 20663663.266141944 2024 205375556.56284952 +$G$36/$C$30/2 20537555.656284951 +$G$36/$C$30 41075111.312569901 +$G$36/$C$30 41075111.312569901 +$G$36/$C$30 41075111.312569901 +$G$36/$C$30 41075111.312569901 +$G$36/$C$30/2 20537555.656284951 2025 204127091.22526529 +$G$37/$C$30/2 20412709.12252653 +$G$37/$C$30 40825418.24505306 +$G$37/$C$30 40825418.24505306 +$G$37/$C$30 40825418.24505306 +$G$37/$C$30 40825418.24505306 2026 202891110.54105693 +$G$38/$C$30/2 20289111.054105692 +$G$38/$C$30 40578222.108211383 +$G$38/$C$30 40578222.108211383 +$G$38/$C$30 40578222.108211383 2027 201667489.66369063 +$G$39/$C$30/2 20166748.966369063 +$G$39/$C$30 40333497.932738125 +$G$39/$C$30 40333497.932738125 2028 200456104.99509802 +$G$40/$C$30/2 20045610.499509804 +$G$40/$C$30 40091220.999019608 2029 199256834.17319131 +$G$41/$C$30/2 19925683.41731913 399 SUM(H32:H41) 20144279.912974231 60309158.871383317 101120802.60705808 142575510.56343994 183776729.48586684 204582714.35170412 205119655.56992722 204763871.85472718 203521523.36422423 202291598.35862625 475 3 +G49 0 +H49 121611859.375 +I49 118533078.125 115454296.875 112375515.625 109296734.375 106217953.125 103139171.875 100060390.625 96981609.375 503 +Supuestos!H69 123151250 +Supuestos!I69 0 +Supuestos!J69 0 +Supuestos!K69 0 +Supuestos!L69 0 +Supuestos!M69 0 +Supuestos!N69 0 +Supuestos!O69 0 +Supuestos!P69 0 +Supuestos!Q69 0 212 -$H$47/$C$50/2 -1539390.625 -$H$47/$C$50 -3078781.25 -3078781.25 -3078781.25 -3078781.25 -3078781.25 -3078781.25 -3078781.25 -3078781.25 -3078781.25 21 0 +SUM(H46:H48) 121611859.375 +SUM(I46:I48) 118533078.125 115454296.875 112375515.625 109296734.375 106217953.125 103139171.875 100060390.625 96981609.375 93902828.125 395 40 26 27 Balance!D7 260440086 Balance!E7 218178007 Balance!F7 239425507 Balance!G7 209178012 Balance!H7 225569369.77167571 Balance!I7 224184429.95430836 Balance!J7 232811640.22406232 Balance!K7 231385262.72739679 Balance!L7 229973149.00569794 Balance!M7 228575156.42121604 Balance!N7 227191143.76257896 Balance!O7 225820971.2305283 Balance!P7 224464500.42379805 Balance!Q7 223121594.3251352 375 Balance!D8 82727781 Balance!E8 109797820Balance!F8 135105117 Balance!G8 288344589 Balance!H8 288344589 Balance!I8 288344589 Balance!J8 288344589 Balance!K8 288344589 Balance!L8 288344589 Balance!M8 288344589 Balance!N8 288344589 Balance!O8 288344589 Balance!P8 288344589 Balance!Q8 288344589 30 Balance!D9 33390799 Balance!E9 31740903 Balance!F9 43770781 Balance!G9 29674090 Balance!H9 35567859.101759844 Balance!I9 34716416.831558399 Balance!J9 37752698.243072428 Balance!K9 37939308.575257897 Balance!L9 38448560.735637963 Balance!M9 38633243.031198196 Balance!N9 38821618.972669631 Balance!O9 39013762.432970494 Balance!P9 38929858.791481338 Balance!Q9 39140012.334634997 377 Balance!D16 6788437 Balance!E16 1032923 Balance!F16 1156638 Balance!G16 82929822 Balance!H16 1432186.4747407981 Balance!I16 1423393.2060591008 Balance!J16 1478169.1442797608 Balance!K16 1469112.7792215669 Balance!L16 1460146.9778139549 Balance!M16 1451270.8344204193 Balance!N16 1442483.4524608189 Balance!O16 1433783.9443208142 Balance!P16 1425171.43126221 Balance!Q16 1416645.0433341917 376 Balance!D17 0 Balance!E17 0 Balance!F17 0 Balance!G17 80339778 Balance!H17 0 Balance!I17 0 Balance!J17 0 Balance!K17 0 Balance!L17 0 Balance!M17 0 Balance!N17 0 Balance!O17 0 Balance!P17 0 Balance!Q17 0 32 SUM(D54:D58) 383347103 360749653 419458043 690466291 550914004.34817624 548668828.99192584 560387096.61141443 559138273.08187628 558226445.71914983 557004259.2868346 555799835.18770933 554613106.60781956 553164119.64654171 SUM(Q54:Q58) 552022840.7031045 378 Balance!D30 341088664 Balance!E30 329448226 Balance!F30 275331618 Balance!G30 227887342 Balance!H30 294027635.24121469 Balance!I30 286989045.80754948 Balance!J30 312088972.14273202 Balance!K30 313631617.55546528 Balance!L30 317841435.41460711 Balance!M30 319368142.39123839 Balance!N30 320925383.50740224 Balance!O30 322513769.44588941 Balance!P30 321820166.00957906 Balance!Q30 323557435.2996493 379 Balance!D31 121018039 Balance!E31 122862944 Balance!F31 152932289 Balance!G31 137867183 Balance!H31 288344589 Balance!I31 288344589 Balance!J31 288344589 Balance!K31 288344589 Balance!L31 288344589 Balance!M31 288344589 Balance!N31 288344589 Balance!O31 288344589 Balance!P31 288344589 Balance!Q31 288344589 380 +Balance!D38 1453022 +Balance!E38 632643 +Balance!F38 450421 +Balance!G38 2 +Balance!H38 611041.43144070439 +Balance!I38 417986.45190641697 +Balance!J38 386009.72014265659 +Balance!K38 360463.73669410159 +Balance!L38 447829.35465952492 +Balance!M38 401587.84426904243 +Balance!N38 393047.20982640819 +Balance!O38 394741.22741808172 +Balance!P38 403042.04398351698 +Balance!Q38 392166.63931736583 381 +Balance!D39 251527 +Balance!E39 318518 +Balance!F39 0 +Balance!G39 2497660 +Balance!H39 0 +Balance!I39 0 +Balance!J39 0 +Balance!K39 0 +Balance!L39 0 +Balance!M39 0 +Balance!N39 0 +Balance!O39 0 +Balance!P39 0 +Balance!Q39 0 34 +SUM(D61:D64) 463811252 453262331 428714328 368252187 582983265.67265546 575751621.25945592 600819570.86287463 602336670.29215932 606633853.76926661 608114319.23550749 609663019.71722853 611253099.67330754 610567797.05356252 +SUM(Q61:Q64) 612294190.93896663 35 D59-D65 -80464149 -92512678 -9256285 G59-G65 322214104 -32069261.324479222 -27082792.267530084 -40432474.251460195 -43198397.210283041 -48407408.050116777 -51110059.948672891 -53863184.5295192 -56639993.065487981 -57403677.407020807 -60271350.235862136 388xl/worksheets/sheet4.xml
 64 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 +AVERAGE(C20:G20/EERR!C2:G2) 0.9018754853233204 75 Generación!C29 18296 Generación!D29 17564 Generación!E29 17073 Generación!F29 17679 Generación!G29 17800 Generación!H29 17021.773815461347 Generación!I29 17457.819822405792 Generación!J29 17457.819822405792 Generación!K29 17457.819822405792 Generación!L29 17122.6805277852 Generación!M29 17122.6805277852 Generación!N29 17122.6805277852 Generación!O29 17122.6805277852 Generación!P29 17457.819822405792 Generación!Q29 17457.819822405792 496 +SUM(C6:C8) 23559 +SUM(D6:D8) 23689 +SUM(E6:E8) 23356 +SUM(F6:F8) 23343 +SUM(G6:G8) 23343 +SUM(H6:H8) 23745 23745 24952 24952 24952 24952 24952 24952 24952 24952 77 17622 18516 17010 16993 16993 +Supuestos!H4 16993 +Supuestos!I4 16993 +Supuestos!J4 18200 +Supuestos!K4 18200 +Supuestos!L4 18200 +Supuestos!M4 18200 +Supuestos!N4 18200 +Supuestos!O4 18200 +Supuestos!P4 18200 +Supuestos!Q4 18200 78 4319 4321 5604 5598 5598 +Supuestos!H5 6000 +Supuestos!I5 6000 +Supuestos!J5 6000 +Supuestos!K5 6000 +Supuestos!L5 6000 +Supuestos!M5 6000 +Supuestos!N5 6000 +Supuestos!O5 6000 +Supuestos!P5 6000 +Supuestos!Q5 6000 79 1618 852 742 752 752 +Supuestos!H6 752 +Supuestos!I6 752 +Supuestos!J6 752 +Supuestos!K6 752 +Supuestos!L6 752 +Supuestos!M6 752 +Supuestos!N6 752 +Supuestos!O6 752 +Supuestos!P6 752 +Supuestos!Q6 752 497 +C5-C3 5263 +D5-D3 6125 6283 5664 5543 6723.2261845386529 6287.1801775942076 7494.1801775942076 7494.1801775942076 7829.3194722148 7829.3194722148 7829.3194722148 7829.3194722148 7494.1801775942076 7494.1801775942076 498 -Supuestos!C16 320731795 -Supuestos!D16 335731822 -Supuestos!E16 346954692 -Supuestos!F16 326365798 -Supuestos!G16 327157312 +H10*H12 386744437.58651519 +I10*I12 361661484.38982052 431092516.9557665 431092516.9557665 450370948.83557636 450370948.83557636 450370948.83557636 450370948.83557636 431092516.9557665 431092516.9557665 500 +C11/C10 60940.86927607828 +D11/D10 54813.358693877548 55221.182874423044 57621.080155367228 59021.705213783149 +Supuestos!H17 57523.639242705853 +Supuestos!I17 57523.639242705853 +Supuestos!J17 57523.639242705853 +Supuestos!K17 57523.639242705853 +Supuestos!L17 57523.639242705853 +Supuestos!M17 57523.639242705853 +Supuestos!N17 57523.639242705853 +Supuestos!O17 57523.639242705853 +Supuestos!P17 57523.639242705853 +Supuestos!Q17 57523.639242705853 389 77 C21/C6 61351.848825331974 63730.967649600345 64731.869841269843 58689.791973165418 53036.827811451774 +Supuestos!H9 52667.422040175181 +Supuestos!I9 52301.710326611348 +Supuestos!J9 51939.655730183156 +Supuestos!K9 51581.221679719245 +Supuestos!L9 51226.371969759974 +Supuestos!M9 50875.070756900299 +Supuestos!N9 50527.282556169215 +Supuestos!O9 50182.972237445443 +Supuestos!P9 49842.105021908908 +Supuestos!Q9 49504.646478527742 80 56401.229451261868 54302.68641518167 50967.833154889362 60333.78742408003 82349.733476241512 +Supuestos!H10 81980.327704964919 +Supuestos!I10 81614.615991401079 +Supuestos!J10 81252.561394972901 +Supuestos!K10 80894.127344508976 +Supuestos!L10 80539.277634549711 +Supuestos!M10 80187.976421690037 +Supuestos!N10 79840.188220958953 +Supuestos!O10 79495.877902235181 +Supuestos!P10 79155.010686698646 +Supuestos!Q10 78817.552143317473 79 92755.980222496903 119722.93075117371 95631.912398921835 45570.655585106382 36940.577127659577 +Supuestos!H11 36571.171356382984 +Supuestos!I11 36205.459642819151 +Supuestos!J11 35843.405046390959 +Supuestos!K11 35484.970995927048 +Supuestos!L11 35130.121285967776 +Supuestos!M11 34778.820073108101 +Supuestos!N11 34431.031872377018 +Supuestos!O11 34086.721553653246 +Supuestos!P11 33745.854338116711 +Supuestos!Q11 33408.395794735545 499 264 +SUM(C21:C23) 1474818366 1516688442 1457671722 1369333310 1390027937 1414360989.8184862 +SUM(I21:I23) 1405677165.179913 1459771343.2540569 1450827696.8268814 1441973486.8639774 1433207819.0007029 1424529807.816061 1415938576.7432654 1407433257.9811978 1399012992.4067509 267 1081142280 1180042597 1101089106 997315635 901254815 +H15*H6 894977502.72869682 +I15*I6 888762963.58010662 945301734.28933346 938778234.57089031 932319969.84963155 925926287.77558541 919596542.52227974 913330094.72150707 907126311.39874208 900984565.90920496 268 243596910 234641908 285623737 337748542 460993808 +H16*H7 491881966.2297895 +I16*I7 489687695.94840646 487515368.3698374 485364764.06705385 483235665.80729824 481127858.53014022 479041129.32575369 476975267.41341108 474930064.12019187 472905312.85990483 269 150079176 102003937 70958879 34269133 27779314 +H17*H8 27501520.860000003 +I17*I8 27226505.6514 26954240.594886001 26684698.188937139 26417851.207047768 26153672.694977291 25892135.968027517 25633214.608347241 25376882.462263767 25123113.637641128 81 +SUMPRODUCT(C6:C8,C15:C17) 1474818366 +SUMPRODUCT(D6:D8,D15:D17) 1516688442 +SUMPRODUCT(E6:E8,E15:E17) 1457671722 +SUMPRODUCT(F6:F8,F15:F17) 1369333310 +SUMPRODUCT(G6:G8,G15:G17) 1390027937 +H20 1414360989.8184862 1405677165.179913 1459771343.2540569 1450827696.8268814 1441973486.8639774 1433207819.0007029 1424529807.816061 1415938576.7432654 1407433257.9811978 1399012992.4067509 82 C25/$B$2 1635279359.513005 D25/$B$2 1681704921.2245419 E25/$B$2 1616267151.8645701 F25/$B$2 1518317475.3986101 G25/$B$2 1541263688.4144578 H25/$B$2 1568244189.8411739 1558615560.6347153 1618595212.9863381 1608678493.2476158 1598860940.7062807 1589141563.6903591 1579519380.4445968 1569993419.0312917 1560562717.23212 1551226322.4509399 
xl/worksheets/sheet5.xml
 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 65 6351 6351 6351 6350 6350 H3+H10+H18 6168 I3+I10+I18 6318 J3+J10+J18 6318 K3+K10+K18 6318 L3+L10+L18 6190 M3+M10+M18 6190 N3+N10+N18 6190 O3+O10+O18 6190 P3+P10+P18 6318 Q3+Q10+Q18 6318 83 SUM(C4:C8) 3456 3456 SUM(E4:E8) 3456 SUM(F4:F8) 3456 SUM(G4:G8) 3456 SUM(H4:H8) 3456 SUM(I4:I9) 3606 SUM(J4:J9) 3606 SUM(K4:K9) 3606 SUM(L4:L9) 3606 SUM(M4:M9) 3606 SUM(N4:N9) 3606 SUM(O4:O9) 3606 SUM(P4:P9) 3606 SUM(Q4:Q9) 3606 84 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 85 466 466 466 466 466 466 466 466 466 466 466 466 466 466 466 86 875 875 875 875 875 875 875 875 875 875 875 875 875 875 875 87 940 940 940 940 940 940 940 940 940 940 940 940 940 940 940 88 1157 1157 1157 1157 1157 1157 1157 1157 1157 1157 1157 1157 1157 1157 1157 89 150 150 150 150 150 150 150 150 150 90 SUM(C11:C17) 2807 2807 SUM(E11:E17) 2807SUM(F11:F17) 2807 SUM(G11:G17) 2807 SUM(H11:H17) 2625 SUM(I11:I17) 2625 SUM(J11:J17) 2625 SUM(K11:K17) 2625 SUM(L11:L17) 2497 SUM(M11:M17) 2497 SUM(N11:N17) 2497 SUM(O11:O17) 2497 SUM(P11:P17) 2625 SUM(Q11:Q17) 2625 91 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 92 182 182 182 182 182 93 268 268 268 268 268 268 268 268 268 268 268 268 268 268 268 94 64 64 64 64 64 64 64 64 64 64 64 64 64 64 64 95 778 778 778 778 778 778 778 778 778 778 778 778 778 778 778 478 478 478 478 478 478 478 478 478 478 350 350 350 350 478 478 96 257 257 257 257 257 257 257 257 257 257 257 257 257 257 257 97 SUM(C19:C21) 87 SUM(D19:D21) 87 SUM(E19:E21) 87 SUM(F19:F21) 87 SUM(G19:G21) 87 87 SUM(I19:I21) 87 SUM(J19:J21) 87 SUM(K19:K21) 87 SUM(L19:L21) 87 SUM(M19:M21) 87 SUM(N19:N21) 87 SUM(O19:O21) 87 SUM(P19:P21) 87 SUM(Q19:Q21) 87 98 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 99 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 100 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 101 C3+C10+C18-C2 -1 D3+D10+D18-D2 -1 E3+E10+E18-E2 -1 F3+F10+F18-F2 0 G3+G10+G18-G2 0 H3+H10+H18-H2 0 I3+I10+I18-I2 0 J3+J10+J18-J2 0 K3+K10+K18-K2 0 L3+L10+L18-L2 0 M3+M10+M18-M2 0 N3+N10+N18-N2 0 O3+O10+O18-O2 0 P3+P10+P18-P2 0 Q3+Q10+Q18-Q2 0 495 B3 Hidroeléctrica +C30/(C3*24*365)*1000 0.31078899247420938 +D30/(D3*24*365)*1000 0.29836932394723492 +E30/(E3*24*365)*1000 0.32040102316928798 +F30/(F3*24*365)*1000 0.37325067647556232 +G30/(G3*24*365)*1000 0.33536408126162692 +AVERAGE($D25:$G25) 0.33184627621342805 +AVERAGE($D25:$G25) 0.33184627621342805 0.33184627621342805 0.33184627621342805 0.33184627621342805 0.33184627621342805 0.33184627621342805 0.33184627621342805 0.33184627621342805 0.33184627621342805 B10 Térmica +C31/(C10*24*365)*1000 0.24803451254447051 +D31/(D10*24*365)*1000 0.34075769480408569 +E31/(E10*24*365)*1000 0.2968768554803467 +F31/(F10*24*365)*1000 0.25620879308577871 +G31/(G10*24*365)*1000 0.30171635490530035 +AVERAGE($D26:$G26) 0.29888992456887786 0.29888992456887786 0.29888992456887786 0.29888992456887786 0.29888992456887786 0.29888992456887786 0.29888992456887786 0.29888992456887786 0.29888992456887786 0.29888992456887786 B18 Eólica, Solar & Geotérmica +C34/(C18*24*365)*1000 0.24274392484123233 +D34/(D18*24*365)*1000 0.19944365716685036 +E34/(E18*24*365)*1000 0.1312129323466121 +F34/(F18*24*365)*1000 0.10313336482443709 +G34/(G18*24*365)*1000 0.10313336482443709 +AVERAGE($D27:$G27) 0.13423082979058415 0.13423082979058415 0.13423082979058415 0.13423082979058415 0.13423082979058415 0.13423082979058415 0.13423082979058415 0.13423082979058415 0.13423082979058415 0.13423082979058415 508 18296 17564 17073 17679 17800 +SUM(H30,H31,H34) 17021.773815461347 +SUM(I30,I31,I34) 17457.819822405792 17457.819822405792 17457.819822405792 17122.6805277852 17122.6805277852 17122.6805277852 17122.6805277852 17457.819822405792 17457.819822405792 83 9409 9033 9700 11300 10153 +H25*24*365*H3/1000 10046.500000000002 10482.546006944445 10482.546006944445 10482.546006944445 10482.546006944445 10482.546006944445 10482.546006944445 10482.546006944445 10482.546006944445 10482.546006944445 90 +SUM(C32:C33) 6099 +SUM(D32:D33) 8379 SUM(E32:E33) 7300 SUM(F32:F33) 6300 7419 +H26*24*365*H10/1000 6872.9738154613469 6872.9738154613469 6872.9738154613469 6872.9738154613469 6537.8345208407554 6537.8345208407554 6537.8345208407554 6537.8345208407554 6872.9738154613469 6872.9738154613469 106 1554 3061 2700 2600 107 4545 5318 4600 3700 97 185 152 100 78.599999999999994 78.599999999999994 +H27*24*365*H18/1000 102.3 102.3 102.3 102.3 102.3 102.3 102.3 102.3 102.3 102.3 101 D30+D31+D34-D29 0 27 -0.40000000000145519xl/worksheets/sheet6.xml
 102 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 103 +Balance!G4 13487584 +Balance!H4 141361196.23808801 +Balance!I4 116896167.04760367 +Balance!J4 121394640.97397536 +Balance!K4 120650886.99357122 +Balance!L4 119914570.55297107 +Balance!M4 119185617.27677691 +Balance!N4 118463953.53334475 +Balance!O4 117749506.42734689 +Balance!P4 117042203.792409 104 +EERR!H2*Supuestos!H96 117618314.23808804 +EERR!I2*Supuestos!I96 116896167.04760365 +EERR!J2*Supuestos!J96 121394640.97397536 +EERR!K2*Supuestos!K96 120650886.99357118 +EERR!L2*Supuestos!L96 119914570.55297105 +EERR!M2*Supuestos!M96 119185617.27677692 +EERR!N2*Supuestos!N96 118463953.53334476 +EERR!O2*Supuestos!O96 117749506.42734687 +EERR!P2*Supuestos!P96 117042203.792409 +EERR!Q2*Supuestos!Q96 116341974.18382049 105 +EFE!H17+EFE!H24 405907279.79783261 +EFE!I17+EFE!I24 222751199.04115745 +EFE!J17+EFE!J24 242601265.86439726 +EFE!K17+EFE!K24 212769445.17602858 +EFE!L17+EFE!L24 272199555.22171569 +EFE!M17+EFE!M24 267058210.7807568 +EFE!N17+EFE!N24 258028858.90715879 +EFE!O17+EFE!O24 246792616.72803527 +EFE!P17+EFE!P24 240461432.49802908 +EFE!Q17+EFE!Q24 232969692.75992215 72 +H4-H5+H6 301776549.5597446 +I4-I5+I6 247216228.23164183 238102791.93802556 213513199.15643275 272935871.66231585 267787164.05695093 258750522.65059096 247507063.83403313 241168735.13296697 233669922.36851066 108 +SUM(H154:H159) -31624776 +SUM(I154:I159) -31624776 -31624776 -31624776 -328045479 -47530015 -47530015 -44404798 -40067306 -15905239 109 +H7+H8 270151773.5597446 +I7+I8 215591452.23164183 206478015.93802556 181888423.15643275 -55109607.337684155 220257149.05695093 211220507.65059096 203102265.83403313 201101429.13296697 217764683.36851066 409 -H122 -43388605 -I122 0 0 0 55109607.337684155 -55109607.337684155 0 0 0 0 410 +H133 0 +I133 0 0 0 0 213351530.52490878 31522873.738396287 34643144.826282859 40894793.179881215 47898381.219826937 110 +H9+H10+H11 226763168.5597446 +I9+I10+I11 215591452.23164183 206478015.93802556 181888423.15643275 0 378499072.24417555 242743381.38898724 237745410.66031599 241996222.31284818 265663064.5883376 111 SUM(-H182,H183,H184) -226763168.5597446 SUM(-I182,I183,I184) -215591452.23164183 -206478015.93802556 -181888423.15643275 0 -378499072.24417555 -242743381.38898724 -237745410.66031599 -241996222.31284818 -265663064.5883376 112 +H12+H13 0 +I12+I13 0 0 0 0 0 0 0 0 0 113 -SUM(H57,H68,H79,H90,H101,H112) 0 -SUM(I57,I68,I79,I90,I101,I112) 0 0 0 0 0 0 0 0 0 114 +H15+H14 0 +I15+I14 0 0 0 0 0 0 0 0 0 Balance!#REF! #REF! Balance!D29 25696064 Balance!E29 18815435 Balance!F29 125350544 Balance!G29 96335567 116 C21+C23+C25+C27+C29+C31 16613346 16168473 #REF! 41780543 43388605 117 4797465 4522585 #REF! #REF! 4693498 5058091 118 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 (1+F22)-1 7.9600000000000115E-2 119 1534133 1446232 #REF! #REF! 1500880 1617476 120 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 (1+F24)-1 7.4000000000000066E-2 121 971676 916002 #REF! #REF! 950619 1024463 122 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 (1+F26)-1 8.2600000000000007E-2 123 2548685 2402653 #REF! #REF! 2493452 2828573 124 4.3200000000000002E-2 4.3200000000000002E-2 4.3200000000000002E-2 4.3200000000000002E-2 (1+F28)-1 4.3199999999999905E-2 125 6232249 6337021 #REF! #REF! 6513162 6592332 126 7.17E-2 7.17E-2 7.17E-2 7.17E-2 (1+F30)-1 7.1700000000000097E-2 127 529138 543980 #REF! #REF! 25628932 26267670 128 4.82E-2 4.82E-2 4.82E-2 4.82E-2 (1+F32)-1 4.8200000000000021E-2 115 C19-C20 #REF! 9527591 #REF! 83570001 52946962 Balance!#REF! #REF! Balance!D37 854016751 Balance!E37 781978145 Balance!F37 799813225 Balance!G37 829976921 129 C37+C39+C41+C43+C45+C47 807552168 786137688 #REF! 784713705 800772841 117 145068065 136759395 #REF! #REF! 142300747 153480285 130 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 119 49690671 46792429 #REF! #REF! 48131124 51960662 131 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 121 23252023 21608757 #REF! #REF! 22694249 24876133 132 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 123 275784382 263417893 #REF! #REF! 274469150 296420703 133 4.3200000000000002E-2 4.3200000000000002E-2 4.3200000000000002E-2 4.3200000000000002E-2 4.3200000000000002E-2 125 61024011 57509284 #REF! #REF! 48321664 43982519 134 7.17E-2 7.17E-2 7.17E-2 7.17E-2 7.17E-2 127 252733016 260049930 #REF! #REF! 248796771 230052539 135 4.82E-2 4.82E-2 4.82E-2 4.82E-2 4.82E-2 115 C35-C36 #REF! 67879063 #REF! 15099520 G35-G36 29204080 473 H7 301776549.5597446 I7 247216228.23164183 238102791.93802556 213513199.15643275 272935871.66231585 267787164.05695093 258750522.65059096 247507063.83403313 241168735.13296697 233669922.36851066 141 +H14 0 +I14 0 0 0 0 0 0 0 0 0 66 136 #REF! #REF! #REF! #REF! #REF! #REF! +G58 153480285 +H58 153480285 153480285 153480285 153480285 153480285 143030662 132581039 122131416 111681793 137 D58-D55 #REF! #REF! #REF! MIN(H55,Supuestos!H85) 0 MIN(I55,Supuestos!I85) 0 MIN(J55,Supuestos!J85) 0 MIN(K55,Supuestos!K85) 0 MIN(L55,Supuestos!L85) 0 MIN(M55,Supuestos!M85) 10449623 MIN(N55,Supuestos!N85) 10449623 MIN(O55,Supuestos!O85) 10449623 MIN(P55,Supuestos!P85) 10449623 MIN(Q55,Supuestos!Q85) 10449623 138 +MIN(H52,H55+H56) 0 +MIN(I52,I55+I56) 0 0 0 0 0 0 0 0 0 21 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! G37 153480285 +H55-H56-H57 153480285 +I55-I56 153480285 153480285 153480285 153480285 143030662 132581039 122131416 111681793 101232170 139 G38 7.9600000000000004E-2 +G59 7.9600000000000004E-2 +H59 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 7.9600000000000004E-2 140 +G59*AVERAGE(H58,G58) 12217030.686000001 +H59*AVERAGE(I58,H58) 12217030.686000001 12217030.686000001 12217030.686000001 12217030.686000001 11801135.6906 10969345.699800001 10137555.709000001 9305765.7182 8473975.7274000011 142 H51-H56 301776549.5597446 I51-I56 247216228.23164183 238102791.93802556 213513199.15643275 272935871.66231585 257337541.05695093 N51-N56 248300899.65059096 237057440.83403313 230719112.13296697 223220299.36851066 143 +H52-H57 0 +I52-I57 0 0 0 0 0 0 0 0 0 67 136 #REF! #REF! #REF! #REF! #REF! #REF! +G69 51960662 +H69 51960662 51960662 51960662 51960662 51960662 48625690 45290718 41955746 38620774 137 D69-D66 #REF! #REF! #REF! MIN(H66,Supuestos!H86) 0 MIN(I66,Supuestos!I86) 0 MIN(J66,Supuestos!J86)0 MIN(K66,Supuestos!K86) 0 MIN(L66,Supuestos!L86) 0 MIN(M66,Supuestos!M86) 3334972 MIN(N66,Supuestos!N86) 3334972 MIN(O66,Supuestos!O86) 3334972 MIN(P66,Supuestos!P86) 3334972 MIN(Q66,Supuestos!Q86) 3334972 138 +MIN(H63,H66+H67) 0 +MIN(I63,I66+I67) 0 +MIN(J63,J66+J67) 0 +MIN(K63,K66+K67) 0 +MIN(L63,L66+L67) 0 +MIN(M63,M66+M67) 0 +MIN(N63,N66+N67) 0 +MIN(O63,O66+O67) 0 +MIN(P63,P66+P67) 0 +MIN(Q63,Q66+Q67) 0 21 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! G39 51960662 +H66-H67-H68 51960662 +I66-I67 51960662 51960662 51960662 51960662 48625690 45290718 41955746 38620774 35285802 139 G40 7.3999999999999996E-2 +G70 7.3999999999999996E-2 +H70 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 7.3999999999999996E-2 140 +G70*AVERAGE(H69,G69) 3845088.9879999999 +H70*AVERAGE(I69,H69) 3845088.9879999999 3845088.9879999999 3845088.9879999999 3845088.9879999999 3721695.0239999997 3474907.0959999999 3228119.1680000001 2981331.2399999998 2734543.3119999999 144 H62-H67 301776549.5597446 I62-I67 247216228.23164183 238102791.93802556 213513199.15643275 272935871.66231585 254002569.05695093 244965927.65059096 233722468.83403313 227384140.13296697 219885327.36851066 145 +H63-H68 0 +I63-I68 0 0 0 0 0 0 0 0 0 68 136 #REF! #REF! #REF! #REF! #REF! #REF! +G80 24876133 24876133 24876133 24876133 24876133 24876133 22755489 20634845 18514201 16393557 137 D80-D77 #REF! #REF! #REF! MIN(H77,Supuestos!H87) 0 MIN(I77,Supuestos!I87) 0 MIN(J77,Supuestos!J87) 0 MIN(K77,Supuestos!K87) 0 MIN(L77,Supuestos!L87) 0 MIN(M77,Supuestos!M87) 2120644 MIN(N77,Supuestos!N87) 2120644 MIN(O77,Supuestos!O87) 2120644 MIN(P77,Supuestos!P87) 2120644 MIN(Q77,Supuestos!Q87) 2120644 138 +MIN(H74,H77+H78) 0 +MIN(I74,I77+I78) 0 +MIN(J74,J77+J78) 0 +MIN(K74,K77+K78) 0 +MIN(L74,L77+L78) 0 +MIN(M74,M77+M78) 0 +MIN(N74,N77+N78) 0 +MIN(O74,O77+O78) 0 +MIN(P74,P77+P78) 0 +MIN(Q74,Q77+Q78) 0 21 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! G41 24876133 +H77-H78-H79 24876133 +I77-I78 24876133 24876133 24876133 24876133 22755489 20634845 18514201 16393557 14272913 139 G42 8.2600000000000007E-2 +G81 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 8.2600000000000007E-2 140 +G81*AVERAGE(H80,G80) 2054768.5858000002 2054768.5858000002 2054768.5858000002 2054768.5858000002 2054768.5858000002 1967185.9886000003 1792020.7942000001 1616855.5998000002 1441690.4054 1266525.2110000001 146 H73-H78 301776549.5597446 I73-I78 247216228.23164183 238102791.93802556 213513199.15643275 272935871.66231585 251881925.05695093 242845283.65059096 231601824.83403313 225263496.13296697 217764683.36851066 147 +H74-H79 0 +I74-I79 0 0 0 0 0 0 0 0 0 148 136 #REF! #REF! #REF! #REF! #REF! #REF! +G91 296420703 +H91 296420703 +I91 296420703 +J91 296420703 +K91 296420703 137 D91-D88 #REF! #REF! #REF! MIN(H88,Supuestos!H88) 0 MIN(I88,Supuestos!I88) 0 MIN(J88,Supuestos!J88) 0 MIN(K88,Supuestos!K88) 0 MIN(L88,Supuestos!L88) 296420703 138 +MIN(H85,H88+H89) 0 +MIN(I85,I88+I89) 0 +MIN(J85,J88+J89) 0 +MIN(K85,K88+K89) 0 +MIN(L85,L88+L89) 0 +MIN(M85,M88+M89) 0 +MIN(N85,N88+N89) 0 +MIN(O85,O88+O89) 0 +MIN(P85,P88+P89) 0 +MIN(Q85,Q88+Q89) 0 21 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! G43 296420703 +H88-H89-H90 296420703 +I88-I89 296420703 296420703 296420703 0 0 0 0 0 0 139 G44 4.3200000000000002E-2 +G92 4.3200000000000002E-2 +H92 4.3200000000000002E-2 +I92 4.3200000000000002E-2 +J92 4.3200000000000002E-2 +K92 4.3200000000000002E-2 140 +G92*AVERAGE(H91,G91) 12805374.3696 +H92*AVERAGE(I91,H91) 12805374.3696 +I92*AVERAGE(J91,I91) 12805374.3696 +J92*AVERAGE(K91,J91) 12805374.3696 +K92*AVERAGE(L91,K91) 6402687.1847999999 149 H84-H89 301776549.5597446 I84-I89 247216228.23164183 238102791.93802556 213513199.15643275 -23484831.337684155 251881925.05695093 242845283.65059096 231601824.83403313 225263496.13296697 217764683.36851066 150 +H85-H90 0 +I85-I90 0 0 0 0 0 0 0 0 0 151 136 #REF! #REF! #REF! #REF! #REF! #REF! +G102 43982519 38094052 32205585 26317118 20428651 14540184 8651717 2763250 0 0 137 D102-D99 #REF! #REF! #REF! MIN(H99,Supuestos!H89) 5888467 MIN(I99,Supuestos!I89) 5888467 MIN(J99,Supuestos!J89) 5888467 MIN(K99,Supuestos!K89) 5888467 MIN(L99,Supuestos!L89) 5888467 MIN(M99,Supuestos!M89) 5888467 MIN(N99,Supuestos!N89) 5888467 MIN(O99,Supuestos!O89) 2763250 MIN(P99,Supuestos!P89) 0 MIN(Q99,Supuestos!Q89) 0 138 +MIN(H96,H99+H100) 0 +MIN(I96,I99+I100) 0 +MIN(J96,J99+J100) 0 +MIN(K96,K99+K100) 0 +MIN(L96,L99+L100) 0 +MIN(M96,M99+M100) 0 +MIN(N96,N99+N100) 0 +MIN(O96,O99+O100) 0 +MIN(P96,P99+P100) 0 +MIN(Q96,Q99+Q100) 0 21 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! G45 43982519 +H99-H100-H101 38094052 +I99-I100 32205585 26317118 20428651 14540184 8651717 2763250 0 0 0 139 G46 7.17E-2 (1+$G$103)*(1+Inflación!H9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!I9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!J9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!K9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!L9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!M9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!N9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!O9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!P9)-1 0.10385100000000014 (1+$G$103)*(1+Inflación!Q9)-1 0.10385100000000014 140 +G103*AVERAGE(H102,G102) 2942445.0703500002 3650343.8010435048 3038820.614626504 2427297.4282095032 1815774.2417925023 1204251.0553755015 592727.8689585008 143483.13787500019 0 0 152 H95-H100 295888082.5597446 241327761.23164183 232214324.93802556 207624732.15643275 -29373298.337684155 245993458.05695093 236956816.65059096 228838574.83403313 225263496.13296697 217764683.36851066 153 +H96-H101 0 +I96-I101 0 0 0 0 0 0 0 0 0 154 136 #REF! #REF! #REF! #REF! #REF! #REF! +G113 230052539 204316230 178579921 152843612 127107303 101370994 75634685 49898376 24162067 0 137 D113-D110 #REF! #REF! #REF! MIN(H110,Supuestos!H90) 25736309 MIN(I110,Supuestos!I90) 25736309 MIN(J110,Supuestos!J90) 25736309 MIN(K110,Supuestos!K90) 25736309 MIN(L110,Supuestos!L90) 25736309 MIN(M110,Supuestos!M90) 25736309 MIN(N110,Supuestos!N90) 25736309 MIN(O110,Supuestos!O90) 25736309 MIN(P110,Supuestos!P90) 24162067 MIN(Q110,Supuestos!Q90) 0 138 +MIN(H107,H110+H111) 0 +MIN(I107,I110+I111) 0 +MIN(J107,J110+J111) 0 +MIN(K107,K110+K111) 0 +MIN(L107,L110+L111) 0 +MIN(M107,M110+M111) 0 +MIN(N107,N110+N111) 0 +MIN(O107,O110+O111) 0 +MIN(P107,P110+P111) 0 +MIN(Q107,Q110+Q111) 0 21 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! G47 230052539 +H110-H111-H112 204316230 +I110-I111 178579921 152843612 127107303 101370994 75634685 49898376 24162067 0 0 139 G48 4.82E-2 (1+$G$114)*(1+Inflación!H9)-1 7.9646000000000106E-2 (1+$G$114)*(1+Inflación!I9)-1 7.9646000000000106E-2 (1+$G$114)*(1+Inflación!J9)-1 7.9646000000000106E-2 (1+$G$114)*(1+Inflación!K9)-1 7.9646000000000106E-2 (1+$G$114)*(1+Inflación!L9)-1 7.9646000000000106E-2 (1+$G$114)*(1+Inflación!M9)-1