{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["DATOS","SUPUESTOS","P&G","BALANCE","FLUJO DE CAJA","KPI'S","DASHBOARD"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DATOS","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Ingrese los siguientes datos:",null,null,"Variables resultantes:",null,null,null,null,null,null,"ROMA INVESTI"]
[]
[null,"Horizonte de proyecto (años)",5,null,"Costos Construcción/m2 inicial",{"$f":"+DATOS!C20*DATOS!C7","v":2378000}]
[null,"Terreno (m2)",500,null,"Área comercializable (m2)",{"$f":"+DATOS!C4*DATOS!C5*DATOS!C6","v":700}]
[null,"índice de construcción",2.8,null,"Volumen de ventas inicial",{"$f":"+DATOS!C20*DATOS!F4","v":2870000000}]
[null,"Factor de eficiencia",0.5,null,"Capital de inicio (Efectivo+PP&E+Intangibles)",{"$f":"+DATOS!F5*DATOS!C21","v":1004499999.9999999}]
[null,"Costos construcción  (% ventas)",0.57999999999999996]
[null,"Costo terreno (% ventas)",0.14000000000000001]
[null,"Costos estructuración (% ventas)",0.03]
[null,"Costos gerencia  (% construcción)",0.1]
[null,"Gastos comercialización  (% ventas)",0.03]
[null,"Costos licencias y permisos (% ventas)",0.02]
[null,"Gastos Fiduciarios (% total inversión proyecto)",0.03]
[null,"Gastos escrituración  (% ventas)",2.7000000000000001E-3]
[null,"Apalancamiento (Deuda/Costo Construcción)",0.7]
[null,"Tasa de Interés (E.A)",0.12]
[null,"Costo del Capital-WACC (E.A)",0.15]
[null,"Inicio construcción (Año)",2]
[null,"Inicio ventas (Año)",2]
[null,"Precio venta/m2 inicial ",4100000]
[null,"% Capital inicial /ventas",0.35]

{"sheet":"SUPUESTOS","index":1,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[null,"Supuestos",null,null,null,null,null,null,null,null,null,"ROMA INVESTI"]
[]
[null,null,"Año 1","Año 2","Año 3","Año 4","Año 5"]
[null,"Costos estructuración",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":86100000},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$C$9*DATOS!$F$5,0))","v":""}]
[null,"Costo terreno",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":401800000.00000006},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$5*DATOS!$C$8,0))","v":""}]
[null,"Costos de licencias y permisos",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":57400000},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$5*DATOS!$C$12,0))","v":""}]
[null,"Costos construcción/m2",{"$f":"IF(ISBLANK(C3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(C3,5,3))))","v":2496900},{"$f":"IF(ISBLANK(D3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(D3,5,3))))","v":2621745},{"$f":"IF(ISBLANK(E3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(E3,5,3))))","v":2752832.2500000005},{"$f":"IF(ISBLANK(F3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(F3,5,3))))","v":2890473.8624999998},{"$f":"IF(ISBLANK(G3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(G3,5,3))))","v":3034997.5556250005},{"$f":"IF(ISBLANK(H3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(H3,5,3))))","v":""},{"$f":"IF(ISBLANK(I3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(I3,5,3))))","v":""},{"$f":"IF(ISBLANK(J3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(J3,5,3))))","v":""},{"$f":"IF(ISBLANK(K3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(K3,5,3))))","v":""},{"$f":"IF(ISBLANK(L3),\"\",DATOS!$F$3*((1+SUPUESTOS!$C$61)^(MID(L3,5,3))))","v":""}]
[null,"Indice avance construcción acumulado (Curva S)",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(C3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(D3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":7.0103716545108136E-2},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(E3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":0.49999999999999994},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(F3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":0.92989628345489184},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(G3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":1},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(H3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(I3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(J3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(K3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))>=DATOS!$C$18,((1/(1+EXP(-10*(((MID(L3,5,3)-DATOS!$C$18+1)/(DATOS!$C$3-DATOS!$C$18+1))-0.5))))-(1/(1+EXP(-10*(0-0.5)))))/((1/(1+EXP(-10*(1-0.5))))-(1/(1+EXP(-10*(0-0.5))))),0))","v":""}]
[null,"Indice avance construcción periodo",{"$f":"+IF(C3=\"\",\"\",IF(ISNUMBER(B8)=FALSE,C8,C8-B8))","v":0},7.0103716545108136E-2,0.42989628345489184,0.42989628345489189,7.0103716545108163E-2,"","","","",""]
[null,"Costo construcción",{"$f":"+IF(C3=\"\",\"\",DATOS!$F$4*C7*C9)","v":0},{"$f":"+IF(D3=\"\",\"\",DATOS!$F$4*D7*D9)","v":128655847.83348817},{"$f":"+IF(E3=\"\",\"\",DATOS!$F$4*E7*E9)","v":828402647.27483749},{"$f":"+IF(F3=\"\",\"\",DATOS!$F$4*F7*F9)","v":869822779.63857925},{"$f":"+IF(G3=\"\",\"\",DATOS!$F$4*G7*G9)","v":148935225.84824181},{"$f":"+IF(H3=\"\",\"\",DATOS!$F$4*H7*H9)","v":""},{"$f":"+IF(I3=\"\",\"\",DATOS!$F$4*I7*I9)","v":""},{"$f":"+IF(J3=\"\",\"\",DATOS!$F$4*J7*J9)","v":""},{"$f":"+IF(K3=\"\",\"\",DATOS!$F$4*K7*K9)","v":""},{"$f":"+IF(L3=\"\",\"\",DATOS!$F$4*L7*L9)","v":""}]
[null,"Costos gerencia proyecto",{"$f":"+IF(C3=\"\",\"\",C10*DATOS!$C$10)","v":0},{"$f":"+IF(D3=\"\",\"\",D10*DATOS!$C$10)","v":12865584.783348817},{"$f":"+IF(E3=\"\",\"\",E10*DATOS!$C$10)","v":82840264.727483749},{"$f":"+IF(F3=\"\",\"\",F10*DATOS!$C$10)","v":86982277.963857934},{"$f":"+IF(G3=\"\",\"\",G10*DATOS!$C$10)","v":14893522.584824182},{"$f":"+IF(H3=\"\",\"\",H10*DATOS!$C$10)","v":""},{"$f":"+IF(I3=\"\",\"\",I10*DATOS!$C$10)","v":""},{"$f":"+IF(J3=\"\",\"\",J10*DATOS!$C$10)","v":""},{"$f":"+IF(K3=\"\",\"\",K10*DATOS!$C$10)","v":""},{"$f":"+IF(L3=\"\",\"\",L10*DATOS!$C$10)","v":""}]
[null,"Gastos fiduciarios",{"$f":"+IF(C3=\"\",\"\",DATOS!$C$13*(C4+C5+C6+C7+C10+C11+C16+C17+C18))","v":16433907},{"$f":"+IF(D3=\"\",\"\",DATOS!$C$13*(D4+D5+D6+D7+D10+D11+D16+D17+D18))","v":4785754.4777051089},{"$f":"+IF(E3=\"\",\"\",DATOS!$C$13*(E4+E5+E6+E7+E10+E11+E16+E17+E18))","v":27909019.025721636},{"$f":"+IF(F3=\"\",\"\",DATOS!$C$13*(F4+F5+F6+F7+F10+F11+F16+F17+F18))","v":29309361.443989232},{"$f":"+IF(G3=\"\",\"\",DATOS!$C$13*(G4+G5+G6+G7+G10+G11+G16+G17+G18))","v":8853148.9899658412},{"$f":"+IF(H3=\"\",\"\",DATOS!$C$13*(H4+H5+H6+H7+H10+H11+H16+H17+H18))","v":""},{"$f":"+IF(I3=\"\",\"\",DATOS!$C$13*(I4+I5+I6+I7+I10+I11+I16+I17+I18))","v":""},{"$f":"+IF(J3=\"\",\"\",DATOS!$C$13*(J4+J5+J6+J7+J10+J11+J16+J17+J18))","v":""},{"$f":"+IF(K3=\"\",\"\",DATOS!$C$13*(K4+K5+K6+K7+K10+K11+K16+K17+K18))","v":""},{"$f":"+IF(L3=\"\",\"\",DATOS!$C$13*(L4+L5+L6+L7+L10+L11+L16+L17+L18))","v":""}]
[null,"Índice ventas periodo",{"$f":"+IF(C3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":9.9999999999999992E-2},{"$f":"+IF(E3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":9.9999999999999992E-2},{"$f":"+IF(F3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":9.9999999999999992E-2},{"$f":"+IF(G3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":0.7},{"$f":"+IF(H3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(AND((DATOS!$C$3-DATOS!$C$19)=0,(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3))))=DATOS!$C$19),1,IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))<DATOS!$C$19,0,IF((VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3))))=DATOS!$C$3,0.7,(0.3/(DATOS!$C$3-DATOS!$C$19))))))","v":""}]
[null,"Precio / m2",{"$f":"IF(ISBLANK(C3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(C3,5,3)))","v":4346000},{"$f":"IF(ISBLANK(D3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(D3,5,3)))","v":4606760.0000000009},{"$f":"IF(ISBLANK(E3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(E3,5,3)))","v":4883165.6000000015},{"$f":"IF(ISBLANK(F3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(F3,5,3)))","v":5176155.5360000012},{"$f":"IF(ISBLANK(G3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(G3,5,3)))","v":5486724.8681600019},{"$f":"IF(ISBLANK(H3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(H3,5,3)))","v":""},{"$f":"IF(ISBLANK(I3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(I3,5,3)))","v":""},{"$f":"IF(ISBLANK(J3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(J3,5,3)))","v":""},{"$f":"IF(ISBLANK(K3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(K3,5,3)))","v":""},{"$f":"IF(ISBLANK(L3),\"\",DATOS!$C$20*(1+SUPUESTOS!$C$62)^(MID(L3,5,3)))","v":""}]
[null,"Ventas ($)",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))>=DATOS!$C$19,C13*C14*DATOS!$F$4,0))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))>=DATOS!$C$19,D13*D14*DATOS!$F$4,0))","v":322473200.00000006},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))>=DATOS!$C$19,E13*E14*DATOS!$F$4,0))","v":341821592.00000006},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))>=DATOS!$C$19,F13*F14*DATOS!$F$4,0))","v":362330887.5200001},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))>=DATOS!$C$19,G13*G14*DATOS!$F$4,0))","v":2688495185.3984008},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))>=DATOS!$C$19,H13*H14*DATOS!$F$4,0))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))>=DATOS!$C$19,I13*I14*DATOS!$F$4,0))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))>=DATOS!$C$19,J13*J14*DATOS!$F$4,0))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))>=DATOS!$C$19,K13*K14*DATOS!$F$4,0))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))>=DATOS!$C$19,L13*L14*DATOS!$F$4,0))","v":""}]
[null,"Costos comercialización",{"$f":"+IF(C3=\"\",\"\",C15*DATOS!$C$11)","v":0},{"$f":"+IF(D3=\"\",\"\",D15*DATOS!$C$11)","v":9674196.0000000019},{"$f":"+IF(E3=\"\",\"\",E15*DATOS!$C$11)","v":10254647.760000002},{"$f":"+IF(F3=\"\",\"\",F15*DATOS!$C$11)","v":10869926.625600003},{"$f":"+IF(G3=\"\",\"\",G15*DATOS!$C$11)","v":80654855.561952025},{"$f":"+IF(H3=\"\",\"\",H15*DATOS!$C$11)","v":""},{"$f":"+IF(I3=\"\",\"\",I15*DATOS!$C$11)","v":""},{"$f":"+IF(J3=\"\",\"\",J15*DATOS!$C$11)","v":""},{"$f":"+IF(K3=\"\",\"\",K15*DATOS!$C$11)","v":""},{"$f":"+IF(L3=\"\",\"\",L15*DATOS!$C$11)","v":""}]
[null,"Gastos de escrituración",{"$f":"+IF(C3=\"\",\"\",C15*DATOS!$C$14)","v":0},{"$f":"+IF(D3=\"\",\"\",D15*DATOS!$C$14)","v":870677.64000000025},{"$f":"+IF(E3=\"\",\"\",E15*DATOS!$C$14)","v":922918.2984000002},{"$f":"+IF(F3=\"\",\"\",F15*DATOS!$C$14)","v":978293.39630400029},{"$f":"+IF(G3=\"\",\"\",G15*DATOS!$C$14)","v":7258937.0005756821},{"$f":"+IF(H3=\"\",\"\",H15*DATOS!$C$14)","v":""},{"$f":"+IF(I3=\"\",\"\",I15*DATOS!$C$14)","v":""},{"$f":"+IF(J3=\"\",\"\",J15*DATOS!$C$14)","v":""},{"$f":"+IF(K3=\"\",\"\",K15*DATOS!$C$14)","v":""},{"$f":"+IF(L3=\"\",\"\",L15*DATOS!$C$14)","v":""}]
[null,"ICA",{"$f":"+IF(C3=\"\",\"\",C15*SUPUESTOS!$C$59)","v":0},{"$f":"+IF(D3=\"\",\"\",D15*SUPUESTOS!$C$59)","v":4837098.0000000009},{"$f":"+IF(E3=\"\",\"\",E15*SUPUESTOS!$C$59)","v":5127323.8800000008},{"$f":"+IF(F3=\"\",\"\",F15*SUPUESTOS!$C$59)","v":5434963.3128000014},{"$f":"+IF(G3=\"\",\"\",G15*SUPUESTOS!$C$59)","v":40327427.780976012},{"$f":"+IF(H3=\"\",\"\",H15*SUPUESTOS!$C$59)","v":""},{"$f":"+IF(I3=\"\",\"\",I15*SUPUESTOS!$C$59)","v":""},{"$f":"+IF(J3=\"\",\"\",J15*SUPUESTOS!$C$59)","v":""},{"$f":"+IF(K3=\"\",\"\",K15*SUPUESTOS!$C$59)","v":""},{"$f":"+IF(L3=\"\",\"\",L15*SUPUESTOS!$C$59)","v":""}]
[null,"Deuda del período",{"$f":"+IF(C3=\"\",\"\",C10*DATOS!$C$15)","v":0},{"$f":"+IF(D3=\"\",\"\",D10*DATOS!$C$15)","v":90059093.48344171},{"$f":"+IF(E3=\"\",\"\",E10*DATOS!$C$15)","v":579881853.09238625},{"$f":"+IF(F3=\"\",\"\",F10*DATOS!$C$15)","v":608875945.74700546},null,null,{"$f":"+IF(I3=\"\",\"\",I10*DATOS!$C$15)","v":""},{"$f":"+IF(J3=\"\",\"\",J10*DATOS!$C$15)","v":""},{"$f":"+IF(K3=\"\",\"\",K10*DATOS!$C$15)","v":""},{"$f":"+IF(L3=\"\",\"\",L10*DATOS!$C$15)","v":""}]
[null,"Amortizaciones de deuda",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=DATOS!$C$3,B21+C19,(B21+C19)/(DATOS!$C$3+1-MID(C3,5,3)))))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=DATOS!$C$3,C21+D19,(C21+D19)/(DATOS!$C$3+1-MID(D3,5,3)))))","v":22514773.370860428},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=DATOS!$C$3,D21+E19,(D21+E19)/(DATOS!$C$3+1-MID(E3,5,3)))))","v":215808724.40165582},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=DATOS!$C$3,E21+F19,(E21+F19)/(DATOS!$C$3+1-MID(F3,5,3)))))","v":520246697.27515858},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=DATOS!$C$3,F21+G19,(F21+G19)/(DATOS!$C$3+1-MID(G3,5,3)))))","v":520246697.27515858},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=DATOS!$C$3,G21+H19,(G21+H19)/(DATOS!$C$3+1-MID(H3,5,3)))))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=DATOS!$C$3,H21+I19,(H21+I19)/(DATOS!$C$3+1-MID(I3,5,3)))))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=DATOS!$C$3,I21+J19,(I21+J19)/(DATOS!$C$3+1-MID(J3,5,3)))))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=DATOS!$C$3,J21+K19,(J21+K19)/(DATOS!$C$3+1-MID(K3,5,3)))))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))<DATOS!$C$18,0,IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=DATOS!$C$3,K21+L19,(K21+L19)/(DATOS!$C$3+1-MID(L3,5,3)))))","v":""}]
[null,"Deuda Acumulada",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,C19-C20,B21+C19-C20))","v":0},67544320.112581283,431617448.80331171,520246697.27515858,0,"","","","",""]
[null,"Intereses",{"$f":"+IF(C3=\"\",\"\",IF(ISNUMBER(B21)=FALSE,0,B21*DATOS!$C$16))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(ISNUMBER(C21)=FALSE,0,C21*DATOS!$C$16))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(ISNUMBER(D21)=FALSE,0,D21*DATOS!$C$16))","v":8105318.4135097535},{"$f":"+IF(F3=\"\",\"\",IF(ISNUMBER(E21)=FALSE,0,E21*DATOS!$C$16))","v":51794093.856397405},{"$f":"+IF(G3=\"\",\"\",IF(ISNUMBER(F21)=FALSE,0,F21*DATOS!$C$16))","v":62429603.673019029},{"$f":"+IF(H3=\"\",\"\",IF(ISNUMBER(G21)=FALSE,0,G21*DATOS!$C$16))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(ISNUMBER(H21)=FALSE,0,H21*DATOS!$C$16))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(ISNUMBER(I21)=FALSE,0,I21*DATOS!$C$16))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(ISNUMBER(J21)=FALSE,0,J21*DATOS!$C$16))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(ISNUMBER(K21)=FALSE,0,K21*DATOS!$C$16))","v":""}]
[null,"% Deuda CP",{"$f":"+IF(C3=\"\",\"\",0.2)","v":0.2},0.2,0.2,0.2,0.2,"","","","",""]
[null,"% Deuda LP",{"$f":"+IF(C3=\"\",\"\",(1-C23))","v":0.8},0.8,0.8,0.8,0.8,"","","","",""]
[]
[null,"Depreciaciones & Amortizaciones"]
[null,"Depreciaciónes del costo ",{"$f":"+IF(C3=\"\",\"\",1/(50*12))","v":1.6666666666666668E-3},1.6666666666666668E-3,1.6666666666666668E-3,1.6666666666666668E-3,1.6666666666666668E-3,"","","","",""]
[null,"Amortizaciones del costo ",{"$f":"+IF(C3=\"\",\"\",0%)","v":0},0,0,0,0,"","","","",""]
[null,"Depreciaciónes del gasto - Activos fijos ",{"$f":"+IF(C3=\"\",\"\",10%)","v":0.1},0.1,0.1,0.1,0.1,"","","","",""]
[null,"Amortizaciones del gasto - Intangibles",{"$f":"+IF(C3=\"\",\"\",5%)","v":0.05},0.05,0.05,0.05,0.05,"","","","",""]
[]
[null,"Otros Ingresos & Egresos"]
[null,"Ingresos financieros - Yield de Efectivo",{"$f":"+IF(C3=\"\",\"\",(1+0.08)^(1/12)-1)","v":6.4340301100034303E-3},6.4340301100034303E-3,6.4340301100034303E-3,6.4340301100034303E-3,6.4340301100034303E-3,"","","","",""]
[null,"Otros Gastos financieros - Porcentaje de Erogaciones (4x1000)",{"$f":"+IF(C3=\"\",\"\",0.4%)","v":4.0000000000000001E-3},4.0000000000000001E-3,4.0000000000000001E-3,4.0000000000000001E-3,4.0000000000000001E-3,"","","","",""]
[]
[null,"Dividendos"]
[null,"PayOut Ratio",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[]
[null,"Capital de Trabajo"]
[null,"Días de cartera",{"$f":"+IF(C3=\"\",\"\",30)","v":30},30,30,30,30,"","","","",""]
[null,"Días de proveedores ",{"$f":"+IF(C3=\"\",\"\",30)","v":30},30,30,30,30,"","","","",""]
[]
[null,"CapEx"]
[null,"CapEx no operativo-porcentaje del total CapEx",{"$f":"+IF(C3=\"\",\"\",90%)","v":0.9},0.9,0.9,0.9,0.9,"","","","",""]
[null,"Aportes de capital adicional",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[]
[null,"Activos Inicio"]
[null,"% del capital inicial en efectivo",{"$f":"1-C49-C50","v":0.95},null,null,null,null,null,null,null,{"$f":"+IF(K3=\"\",\"\",500000000)","v":""},{"$f":"+IF(L3=\"\",\"\",500000000)","v":""}]
[null,"% del capital inicial en PP&E",0.04,null,null,null,null,null,null,null,{"$f":"+IF(K3=\"\",\"\",50%)","v":""},{"$f":"+IF(L3=\"\",\"\",50%)","v":""}]
[null,"% del capital inicial en Intangibles",0.01]
[null,"PP&E",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$6*$C$49*(1-C29),B51*(1-C29)))","v":36161999.999999993},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$6*$C$49*(1-D29),C51*(1-D29)))","v":32545799.999999993},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$6*$C$49*(1-E29),D51*(1-E29)))","v":29291219.999999993},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$6*$C$49*(1-F29),E51*(1-F29)))","v":26362097.999999993},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$6*$C$49*(1-G29),F51*(1-G29)))","v":23725888.199999996},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$6*$C$49*(1-H29),G51*(1-H29)))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$6*$C$49*(1-I29),H51*(1-I29)))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$6*$C$49*(1-J29),I51*(1-J29)))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$6*$C$49*(1-K29),J51*(1-K29)))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$6*$C$49*(1-L29),K51*(1-L29)))","v":""}]
[null,"Intangibles",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$6*$C$50*(1-C30),B52*(1-C30)))","v":9542749.9999999981},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$6*$C$50*(1-D30),C52*(1-D30)))","v":9065612.4999999981},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$6*$C$50*(1-E30),D52*(1-E30)))","v":8612331.8749999981},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$6*$C$50*(1-F30),E52*(1-F30)))","v":8181715.2812499981},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$6*$C$50*(1-G30),F52*(1-G30)))","v":7772629.5171874976},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$6*$C$50*(1-H30),G52*(1-H30)))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$6*$C$50*(1-I30),H52*(1-I30)))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$6*$C$50*(1-J30),I52*(1-J30)))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$6*$C$50*(1-K30),J52*(1-K30)))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$6*$C$50*(1-L30),K52*(1-L30)))","v":""}]
[]
[null,"Otros Pasivos"]
[null,"Beneficios a los empleados-porcentaje de utilidad neta",{"$f":"+IF(C3=\"\",\"\",2%)","v":0.02},0.02,0.02,0.02,0.02,"","","","",""]
[null,"Provisiones beneficios a los empleados-porcentaje utilidad neta",{"$f":"+IF(C3=\"\",\"\",1%)","v":0.01},0.01,0.01,0.01,0.01,"","","","",""]
[]
[null,"Macroeconómicos"]
[null,"ICA",1.4999999999999999E-2]
[null,"Impuesto renta",0.35]
[null,"ICCVN",0.05]
[null,"IPVN",{"$f":"+C61+1%","v":6.0000000000000005E-2}]

{"sheet":"P&G","index":2,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"ESTADO DE RESULTADOS INTEGRAL",null,null,null,null,null,null,null,null,null,"ROMA INVESTI"]
[]
[null,null,{"$f":"IF(SUPUESTOS!C3=\"\",\"\",SUPUESTOS!C3)","v":"Año 1"},{"$f":"IF(SUPUESTOS!D3=\"\",\"\",SUPUESTOS!D3)","v":"Año 2"},{"$f":"IF(SUPUESTOS!E3=\"\",\"\",SUPUESTOS!E3)","v":"Año 3"},{"$f":"IF(SUPUESTOS!F3=\"\",\"\",SUPUESTOS!F3)","v":"Año 4"},{"$f":"IF(SUPUESTOS!G3=\"\",\"\",SUPUESTOS!G3)","v":"Año 5"},{"$f":"IF(SUPUESTOS!H3=\"\",\"\",SUPUESTOS!H3)","v":""},{"$f":"IF(SUPUESTOS!I3=\"\",\"\",SUPUESTOS!I3)","v":""},{"$f":"IF(SUPUESTOS!J3=\"\",\"\",SUPUESTOS!J3)","v":""},{"$f":"IF(SUPUESTOS!K3=\"\",\"\",SUPUESTOS!K3)","v":""},{"$f":"IF(SUPUESTOS!L3=\"\",\"\",SUPUESTOS!L3)","v":""}]
[null,"(+) Ventas",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C15)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D15)","v":322473200.00000006},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E15)","v":341821592.00000006},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F15)","v":362330887.5200001},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G15)","v":2688495185.3984008},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H15)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I15)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J15)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K15)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L15)","v":""}]
[null,"Total Ingresos",{"$f":"+IF(C3=\"\",\"\",C4)","v":0},322473200.00000006,341821592.00000006,362330887.5200001,2688495185.3984008,"","","","",""]
[null,"( - ) Costo Directo",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C10+SUPUESTOS!C11)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D10+SUPUESTOS!D11)","v":141521432.61683699},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E10+SUPUESTOS!E11)","v":911242912.00232124},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F10+SUPUESTOS!F11)","v":956805057.60243714},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G10+SUPUESTOS!G11)","v":163828748.43306598},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H10+SUPUESTOS!H11)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I10+SUPUESTOS!I11)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J10+SUPUESTOS!J11)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K10+SUPUESTOS!K11)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L10+SUPUESTOS!L11)","v":""}]
[null,"( - ) Depreciaciones costo",{"$f":"+IF(C3=\"\",\"\",C6*SUPUESTOS!C27)","v":0},{"$f":"+IF(D3=\"\",\"\",D6*SUPUESTOS!D27)","v":235869.05436139501},{"$f":"+IF(E3=\"\",\"\",E6*SUPUESTOS!E27)","v":1518738.1866705355},{"$f":"+IF(F3=\"\",\"\",F6*SUPUESTOS!F27)","v":1594675.0960040621},{"$f":"+IF(G3=\"\",\"\",G6*SUPUESTOS!G27)","v":273047.91405511001},{"$f":"+IF(H3=\"\",\"\",H6*SUPUESTOS!H27)","v":""},{"$f":"+IF(I3=\"\",\"\",I6*SUPUESTOS!I27)","v":""},{"$f":"+IF(J3=\"\",\"\",J6*SUPUESTOS!J27)","v":""},{"$f":"+IF(K3=\"\",\"\",K6*SUPUESTOS!K27)","v":""},{"$f":"+IF(L3=\"\",\"\",L6*SUPUESTOS!L27)","v":""}]
[null,"( - ) Amortizaciones costo",{"$f":"++IF(C3=\"\",\"\",C6*SUPUESTOS!C28)","v":0},{"$f":"++IF(D3=\"\",\"\",D6*SUPUESTOS!D28)","v":0},{"$f":"++IF(E3=\"\",\"\",E6*SUPUESTOS!E28)","v":0},{"$f":"++IF(F3=\"\",\"\",F6*SUPUESTOS!F28)","v":0},{"$f":"++IF(G3=\"\",\"\",G6*SUPUESTOS!G28)","v":0},{"$f":"++IF(H3=\"\",\"\",H6*SUPUESTOS!H28)","v":""},{"$f":"++IF(I3=\"\",\"\",I6*SUPUESTOS!I28)","v":""},{"$f":"++IF(J3=\"\",\"\",J6*SUPUESTOS!J28)","v":""},{"$f":"++IF(K3=\"\",\"\",K6*SUPUESTOS!K28)","v":""},{"$f":"++IF(L3=\"\",\"\",L6*SUPUESTOS!L28)","v":""}]
[null,"(=) Utilidad Bruta",{"$f":"IF(C3=\"\",\"\",C5-SUM(C6:C8))","v":0},180715898.32880166,-570940058.18899179,-596068845.17844105,2524393389.0512795,"","","","",""]
[null,"( - ) Gastos Generales, Administración & Ventas",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C16+SUPUESTOS!C17+SUPUESTOS!C18+SUPUESTOS!C12)","v":16433907},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D16+SUPUESTOS!D17+SUPUESTOS!D18+SUPUESTOS!D12)","v":20167726.117705114},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E16+SUPUESTOS!E17+SUPUESTOS!E18+SUPUESTOS!E12)","v":44213908.96412164},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F16+SUPUESTOS!F17+SUPUESTOS!F18+SUPUESTOS!F12)","v":46592544.778693236},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G16+SUPUESTOS!G17+SUPUESTOS!G18+SUPUESTOS!G12)","v":137094369.33346957},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H16+SUPUESTOS!H17+SUPUESTOS!H18+SUPUESTOS!H12)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I16+SUPUESTOS!I17+SUPUESTOS!I18+SUPUESTOS!I12)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J16+SUPUESTOS!J17+SUPUESTOS!J18+SUPUESTOS!J12)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K16+SUPUESTOS!K17+SUPUESTOS!K18+SUPUESTOS!K12)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L16+SUPUESTOS!L17+SUPUESTOS!L18+SUPUESTOS!L12)","v":""}]
[null,"( - ) Depreciaciones gasto",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!B51-SUPUESTOS!C51))","v":4018000},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!C51-SUPUESTOS!D51))","v":3616200},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!D51-SUPUESTOS!E51))","v":3254580},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!E51-SUPUESTOS!F51))","v":2929122},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!F51-SUPUESTOS!G51))","v":2636209.799999997},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!G51-SUPUESTOS!H51))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!H51-SUPUESTOS!I51))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!I51-SUPUESTOS!J51))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!J51-SUPUESTOS!K51))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$6*SUPUESTOS!$C$49-SUPUESTOS!$C$51,SUPUESTOS!K51-SUPUESTOS!L51))","v":""}]
[null,"( - ) Amortizaciones gasto",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!B52-SUPUESTOS!C52))","v":502250},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!C52-SUPUESTOS!D52))","v":477137.5},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!D52-SUPUESTOS!E52))","v":453280.625},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!E52-SUPUESTOS!F52))","v":430616.59375},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!F52-SUPUESTOS!G52))","v":409085.76406250056},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!G52-SUPUESTOS!H52))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!H52-SUPUESTOS!I52))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!I52-SUPUESTOS!J52))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!J52-SUPUESTOS!K52))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$6*SUPUESTOS!$C$50-SUPUESTOS!$C$52,SUPUESTOS!K52-SUPUESTOS!L52))","v":""}]
[null,"(=) Utilidad Operacional",{"$f":"IF(C3=\"\",\"\",C9-SUM(C10:C12))","v":-20954157},156454834.71109655,-618861827.77811337,-646021128.55088425,2384253724.1537476,"","","","",""]
[null,"( + ) Ingresos Financieros ",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!C33,BALANCE!B6*SUPUESTOS!C33))","v":6139834.0832235226},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!D33,BALANCE!C6*SUPUESTOS!D33))","v":2241552.9818527675},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!E33,BALANCE!D6*SUPUESTOS!E33))","v":5491594.5960377948},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!F33,BALANCE!E6*SUPUESTOS!F33))","v":5268192.1328302613},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!G33,BALANCE!F6*SUPUESTOS!G33))","v":1357197.5857785859},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!H33,BALANCE!G6*SUPUESTOS!H33))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!I33,BALANCE!H6*SUPUESTOS!I33))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!J33,BALANCE!I6*SUPUESTOS!J33))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!K33,BALANCE!J6*SUPUESTOS!K33))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$6*SUPUESTOS!$C$48*SUPUESTOS!L33,BALANCE!K6*SUPUESTOS!L33))","v":""}]
[null,"( - ) Intereses",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C22)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D22)","v":0},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E22)","v":8105318.4135097535},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F22)","v":51794093.856397405},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G22)","v":62429603.673019029},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H22)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I22)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J22)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K22)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L22)","v":""}]
[null,"( - ) Otros Gastos Financieros",{"$f":"+IF(C3=\"\",\"\",(C6+C10+C15)*SUPUESTOS!C34)","v":65735.627999999997},{"$f":"+IF(D3=\"\",\"\",(D6+D10+D15)*SUPUESTOS!D34)","v":646756.63493816846},{"$f":"+IF(E3=\"\",\"\",(E6+E10+E15)*SUPUESTOS!E34)","v":3854248.5575198103},{"$f":"+IF(F3=\"\",\"\",(F6+F10+F15)*SUPUESTOS!F34)","v":4220766.7849501111},{"$f":"+IF(G3=\"\",\"\",(G6+G10+G15)*SUPUESTOS!G34)","v":1453410.8857582184},{"$f":"+IF(H3=\"\",\"\",(H6+H10+H15)*SUPUESTOS!H34)","v":""},{"$f":"+IF(I3=\"\",\"\",(I6+I10+I15)*SUPUESTOS!I34)","v":""},{"$f":"+IF(J3=\"\",\"\",(J6+J10+J15)*SUPUESTOS!J34)","v":""},{"$f":"+IF(K3=\"\",\"\",(K6+K10+K15)*SUPUESTOS!K34)","v":""},{"$f":"+IF(L3=\"\",\"\",(L6+L10+L15)*SUPUESTOS!L34)","v":""}]
[null,"(=) Utilidad antes de Impuestos",{"$f":"+IF(C3=\"\",\"\",C13+C14-C15-C16)","v":-14880058.544776479},158049631.05801114,-625329800.15310514,-696767797.05940151,2321727907.1807489,"","","","",""]
[null,"( - ) Impuestos",{"$f":"+IF('P&G'!C3=\"\",\"\",C17*SUPUESTOS!$C$60)","v":-5208020.4906717669},{"$f":"+IF('P&G'!D3=\"\",\"\",D17*SUPUESTOS!$C$60)","v":55317370.870303899},{"$f":"+IF('P&G'!E3=\"\",\"\",E17*SUPUESTOS!$C$60)","v":-218865430.05358678},{"$f":"+IF('P&G'!F3=\"\",\"\",F17*SUPUESTOS!$C$60)","v":-243868728.97079051},{"$f":"+IF('P&G'!G3=\"\",\"\",G17*SUPUESTOS!$C$60)","v":812604767.51326203},{"$f":"+IF('P&G'!H3=\"\",\"\",H17*SUPUESTOS!$C$60)","v":""},{"$f":"+IF('P&G'!I3=\"\",\"\",I17*SUPUESTOS!$C$60)","v":""},{"$f":"+IF('P&G'!J3=\"\",\"\",J17*SUPUESTOS!$C$60)","v":""},{"$f":"+IF('P&G'!K3=\"\",\"\",K17*SUPUESTOS!$C$60)","v":""},{"$f":"+IF('P&G'!L3=\"\",\"\",L17*SUPUESTOS!$C$60)","v":""}]
[null,"Utilidad Neta",{"$f":"+IF(C3=\"\",\"\",C17-C18)","v":-9672038.0541047119},102732260.18770725,-406464370.09951836,-452899068.08861101,1509123139.6674869,"","","","",""]

{"sheet":"BALANCE","index":3,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"ESTADO DE LA SITUACIÓN FINANCIERA",null,null,null,null,null,null,null,null,null,"ROMA INVESTI"]
[]
[null,null,{"$f":"+IF(SUPUESTOS!C3=\"\",\"\",SUPUESTOS!C3)","v":"Año 1"},{"$f":"+IF(SUPUESTOS!D3=\"\",\"\",SUPUESTOS!D3)","v":"Año 2"},{"$f":"+IF(SUPUESTOS!E3=\"\",\"\",SUPUESTOS!E3)","v":"Año 3"},{"$f":"+IF(SUPUESTOS!F3=\"\",\"\",SUPUESTOS!F3)","v":"Año 4"},{"$f":"+IF(SUPUESTOS!G3=\"\",\"\",SUPUESTOS!G3)","v":"Año 5"},{"$f":"+IF(SUPUESTOS!H3=\"\",\"\",SUPUESTOS!H3)","v":""},{"$f":"+IF(SUPUESTOS!I3=\"\",\"\",SUPUESTOS!I3)","v":""},{"$f":"+IF(SUPUESTOS!J3=\"\",\"\",SUPUESTOS!J3)","v":""},{"$f":"+IF(SUPUESTOS!K3=\"\",\"\",SUPUESTOS!K3)","v":""},{"$f":"+IF(SUPUESTOS!L3=\"\",\"\",SUPUESTOS!L3)","v":""}]
[null,"ACTIVO"]
[null,"Activo Corriente"]
[null,"Efectivo y equivalentes",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,DATOS!$F$6*SUPUESTOS!C48+'FLUJO DE CAJA'!C36,BALANCE!B6+'FLUJO DE CAJA'!C36))","v":348390191.45522344},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,DATOS!$F$6*SUPUESTOS!D53+'FLUJO DE CAJA'!D36,BALANCE!C6+'FLUJO DE CAJA'!D36))","v":853523297.55181503},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,DATOS!$F$6*SUPUESTOS!E53+'FLUJO DE CAJA'!E36,BALANCE!D6+'FLUJO DE CAJA'!E36))","v":818801286.71444035},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,DATOS!$F$6*SUPUESTOS!F53+'FLUJO DE CAJA'!F36,BALANCE!E6+'FLUJO DE CAJA'!F36))","v":210940508.91500449},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,DATOS!$F$6*SUPUESTOS!G53+'FLUJO DE CAJA'!G36,BALANCE!F6+'FLUJO DE CAJA'!G36))","v":1710870100.0857971},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,DATOS!$F$6*SUPUESTOS!H53+'FLUJO DE CAJA'!H36,BALANCE!G6+'FLUJO DE CAJA'!H36))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,DATOS!$F$6*SUPUESTOS!I53+'FLUJO DE CAJA'!I36,BALANCE!H6+'FLUJO DE CAJA'!I36))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,DATOS!$F$6*SUPUESTOS!J53+'FLUJO DE CAJA'!J36,BALANCE!I6+'FLUJO DE CAJA'!J36))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,DATOS!$F$6*SUPUESTOS!K53+'FLUJO DE CAJA'!K36,BALANCE!J6+'FLUJO DE CAJA'!K36))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,DATOS!$F$6*SUPUESTOS!L53+'FLUJO DE CAJA'!L36,BALANCE!K6+'FLUJO DE CAJA'!L36))","v":""}]
[null,"Excedentes (requerimientos) de efectivo",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Deudores comerciales y otras cuentas por cobrar",{"$f":"IF(C3=\"\",\"\",('P&G'!C5/360)*SUPUESTOS!C40)","v":0},{"$f":"IF(D3=\"\",\"\",('P&G'!D5/360)*SUPUESTOS!D40)","v":26872766.666666672},{"$f":"IF(E3=\"\",\"\",('P&G'!E5/360)*SUPUESTOS!E40)","v":28485132.666666672},{"$f":"IF(F3=\"\",\"\",('P&G'!F5/360)*SUPUESTOS!F40)","v":30194240.626666676},{"$f":"IF(G3=\"\",\"\",('P&G'!G5/360)*SUPUESTOS!G40)","v":224041265.44986671},{"$f":"IF(H3=\"\",\"\",('P&G'!H5/360)*SUPUESTOS!H40)","v":""},{"$f":"IF(I3=\"\",\"\",('P&G'!I5/360)*SUPUESTOS!I40)","v":""},{"$f":"IF(J3=\"\",\"\",('P&G'!J5/360)*SUPUESTOS!J40)","v":""},{"$f":"IF(K3=\"\",\"\",('P&G'!K5/360)*SUPUESTOS!K40)","v":""},{"$f":"IF(L3=\"\",\"\",('P&G'!L5/360)*SUPUESTOS!L40)","v":""}]
[null,"Inventario ",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,IF((SUPUESTOS!C4+SUPUESTOS!C5+SUPUESTOS!C6-'KPI''S'!C17)<0,0,SUPUESTOS!C4+SUPUESTOS!C5+SUPUESTOS!C6-'KPI''S'!C17),IF((B9+SUPUESTOS!C4+SUPUESTOS!C5+SUPUESTOS!C6-'KPI''S'!C17)<0,0,B9+SUPUESTOS!C4+SUPUESTOS!C5+SUPUESTOS!C6-'KPI''S'!C17)))","v":545300000},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,IF((SUPUESTOS!D4+SUPUESTOS!D5+SUPUESTOS!D6-'KPI''S'!D17)<0,0,SUPUESTOS!D4+SUPUESTOS!D5+SUPUESTOS!D6-'KPI''S'!D17),IF((C9+SUPUESTOS!D4+SUPUESTOS!D5+SUPUESTOS!D6-'KPI''S'!D17)<0,0,C9+SUPUESTOS!D4+SUPUESTOS!D5+SUPUESTOS!D6-'KPI''S'!D17)))","v":222826799.99999994},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,IF((SUPUESTOS!E4+SUPUESTOS!E5+SUPUESTOS!E6-'KPI''S'!E17)<0,0,SUPUESTOS!E4+SUPUESTOS!E5+SUPUESTOS!E6-'KPI''S'!E17),IF((D9+SUPUESTOS!E4+SUPUESTOS!E5+SUPUESTOS!E6-'KPI''S'!E17)<0,0,D9+SUPUESTOS!E4+SUPUESTOS!E5+SUPUESTOS!E6-'KPI''S'!E17)))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,IF((SUPUESTOS!F4+SUPUESTOS!F5+SUPUESTOS!F6-'KPI''S'!F17)<0,0,SUPUESTOS!F4+SUPUESTOS!F5+SUPUESTOS!F6-'KPI''S'!F17),IF((E9+SUPUESTOS!F4+SUPUESTOS!F5+SUPUESTOS!F6-'KPI''S'!F17)<0,0,E9+SUPUESTOS!F4+SUPUESTOS!F5+SUPUESTOS!F6-'KPI''S'!F17)))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,IF((SUPUESTOS!G4+SUPUESTOS!G5+SUPUESTOS!G6-'KPI''S'!G17)<0,0,SUPUESTOS!G4+SUPUESTOS!G5+SUPUESTOS!G6-'KPI''S'!G17),IF((F9+SUPUESTOS!G4+SUPUESTOS!G5+SUPUESTOS!G6-'KPI''S'!G17)<0,0,F9+SUPUESTOS!G4+SUPUESTOS!G5+SUPUESTOS!G6-'KPI''S'!G17)))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,IF((SUPUESTOS!H4+SUPUESTOS!H5+SUPUESTOS!H6-'KPI''S'!H17)<0,0,SUPUESTOS!H4+SUPUESTOS!H5+SUPUESTOS!H6-'KPI''S'!H17),IF((G9+SUPUESTOS!H4+SUPUESTOS!H5+SUPUESTOS!H6-'KPI''S'!H17)<0,0,G9+SUPUESTOS!H4+SUPUESTOS!H5+SUPUESTOS!H6-'KPI''S'!H17)))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,IF((SUPUESTOS!I4+SUPUESTOS!I5+SUPUESTOS!I6-'KPI''S'!I17)<0,0,SUPUESTOS!I4+SUPUESTOS!I5+SUPUESTOS!I6-'KPI''S'!I17),IF((H9+SUPUESTOS!I4+SUPUESTOS!I5+SUPUESTOS!I6-'KPI''S'!I17)<0,0,H9+SUPUESTOS!I4+SUPUESTOS!I5+SUPUESTOS!I6-'KPI''S'!I17)))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,IF((SUPUESTOS!J4+SUPUESTOS!J5+SUPUESTOS!J6-'KPI''S'!J17)<0,0,SUPUESTOS!J4+SUPUESTOS!J5+SUPUESTOS!J6-'KPI''S'!J17),IF((I9+SUPUESTOS!J4+SUPUESTOS!J5+SUPUESTOS!J6-'KPI''S'!J17)<0,0,I9+SUPUESTOS!J4+SUPUESTOS!J5+SUPUESTOS!J6-'KPI''S'!J17)))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,IF((SUPUESTOS!K4+SUPUESTOS!K5+SUPUESTOS!K6-'KPI''S'!K17)<0,0,SUPUESTOS!K4+SUPUESTOS!K5+SUPUESTOS!K6-'KPI''S'!K17),IF((J9+SUPUESTOS!K4+SUPUESTOS!K5+SUPUESTOS!K6-'KPI''S'!K17)<0,0,J9+SUPUESTOS!K4+SUPUESTOS!K5+SUPUESTOS!K6-'KPI''S'!K17)))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,IF((SUPUESTOS!L4+SUPUESTOS!L5+SUPUESTOS!L6-'KPI''S'!L17)<0,0,SUPUESTOS!L4+SUPUESTOS!L5+SUPUESTOS!L6-'KPI''S'!L17),IF((K9+SUPUESTOS!L4+SUPUESTOS!L5+SUPUESTOS!L6-'KPI''S'!L17)<0,0,K9+SUPUESTOS!L4+SUPUESTOS!L5+SUPUESTOS!L6-'KPI''S'!L17)))","v":""}]
[null,"Activos por impuestos",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Otros activos no financieros",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Total Activo Corriente",{"$f":"IF(C3=\"\",\"\",SUM(C6:C11))","v":893690191.45522344},1103222864.2184815,847286419.38110697,241134749.54167116,1934911365.5356638,"","","","",""]
[null,"Activo No Corriente"]
[null,"Propiedad, Planta y Equipo (Neto)",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C51)","v":36161999.999999993},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D51)","v":32545799.999999993},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E51)","v":29291219.999999993},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F51)","v":26362097.999999993},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G51)","v":23725888.199999996},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H51)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I51)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J51)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K51)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L51)","v":""}]
[null,"Inmuebles (Neto)",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Depreciaciónes + Amortizaciónes acumuladas",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,'P&G'!C7+'P&G'!C8+'P&G'!C11+'P&G'!C12,BALANCE!B16+'P&G'!C7+'P&G'!C8+'P&G'!C11+'P&G'!C12))","v":4520250},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,'P&G'!D7+'P&G'!D8+'P&G'!D11+'P&G'!D12,BALANCE!C16+'P&G'!D7+'P&G'!D8+'P&G'!D11+'P&G'!D12))","v":8849456.5543613955},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,'P&G'!E7+'P&G'!E8+'P&G'!E11+'P&G'!E12,BALANCE!D16+'P&G'!E7+'P&G'!E8+'P&G'!E11+'P&G'!E12))","v":14076055.366031932},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,'P&G'!F7+'P&G'!F8+'P&G'!F11+'P&G'!F12,BALANCE!E16+'P&G'!F7+'P&G'!F8+'P&G'!F11+'P&G'!F12))","v":19030469.055785991},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,'P&G'!G7+'P&G'!G8+'P&G'!G11+'P&G'!G12,BALANCE!F16+'P&G'!G7+'P&G'!G8+'P&G'!G11+'P&G'!G12))","v":22348812.533903599},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,'P&G'!H7+'P&G'!H8+'P&G'!H11+'P&G'!H12,BALANCE!G16+'P&G'!H7+'P&G'!H8+'P&G'!H11+'P&G'!H12))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,'P&G'!I7+'P&G'!I8+'P&G'!I11+'P&G'!I12,BALANCE!H16+'P&G'!I7+'P&G'!I8+'P&G'!I11+'P&G'!I12))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,'P&G'!J7+'P&G'!J8+'P&G'!J11+'P&G'!J12,BALANCE!I16+'P&G'!J7+'P&G'!J8+'P&G'!J11+'P&G'!J12))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,'P&G'!K7+'P&G'!K8+'P&G'!K11+'P&G'!K12,BALANCE!J16+'P&G'!K7+'P&G'!K8+'P&G'!K11+'P&G'!K12))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,'P&G'!L7+'P&G'!L8+'P&G'!L11+'P&G'!L12,BALANCE!K16+'P&G'!L7+'P&G'!L8+'P&G'!L11+'P&G'!L12))","v":""}]
[null,"Activos intangibles (Neto)",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C52)","v":9542749.9999999981},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D52)","v":9065612.4999999981},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E52)","v":8612331.8749999981},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F52)","v":8181715.2812499981},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G52)","v":7772629.5171874976},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H52)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I52)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J52)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K52)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L52)","v":""}]
[null,"Inversiones financieras",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Deudores comerciales-LP",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Activos por impuestos diferidos",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,IF('P&G'!C18<0,ABS('P&G'!C18),0),IF('P&G'!C18<0,ABS('P&G'!C18)+B20,IF((B20-'P&G'!C18)>0,(B20-'P&G'!C18),0))))","v":5208020.4906717669},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,IF('P&G'!D18<0,ABS('P&G'!D18),0),IF('P&G'!D18<0,ABS('P&G'!D18)+C20,IF((C20-'P&G'!D18)>0,(C20-'P&G'!D18),0))))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,IF('P&G'!E18<0,ABS('P&G'!E18),0),IF('P&G'!E18<0,ABS('P&G'!E18)+D20,IF((D20-'P&G'!E18)>0,(D20-'P&G'!E18),0))))","v":218865430.05358678},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,IF('P&G'!F18<0,ABS('P&G'!F18),0),IF('P&G'!F18<0,ABS('P&G'!F18)+E20,IF((E20-'P&G'!F18)>0,(E20-'P&G'!F18),0))))","v":462734159.02437729},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,IF('P&G'!G18<0,ABS('P&G'!G18),0),IF('P&G'!G18<0,ABS('P&G'!G18)+F20,IF((F20-'P&G'!G18)>0,(F20-'P&G'!G18),0))))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,IF('P&G'!H18<0,ABS('P&G'!H18),0),IF('P&G'!H18<0,ABS('P&G'!H18)+G20,IF((G20-'P&G'!H18)>0,(G20-'P&G'!H18),0))))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,IF('P&G'!I18<0,ABS('P&G'!I18),0),IF('P&G'!I18<0,ABS('P&G'!I18)+H20,IF((H20-'P&G'!I18)>0,(H20-'P&G'!I18),0))))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,IF('P&G'!J18<0,ABS('P&G'!J18),0),IF('P&G'!J18<0,ABS('P&G'!J18)+I20,IF((I20-'P&G'!J18)>0,(I20-'P&G'!J18),0))))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,IF('P&G'!K18<0,ABS('P&G'!K18),0),IF('P&G'!K18<0,ABS('P&G'!K18)+J20,IF((J20-'P&G'!K18)>0,(J20-'P&G'!K18),0))))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,IF('P&G'!L18<0,ABS('P&G'!L18),0),IF('P&G'!L18<0,ABS('P&G'!L18)+K20,IF((K20-'P&G'!L18)>0,(K20-'P&G'!L18),0))))","v":""}]
[null,"Otros activos-LP",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Total Activo No Corriente",{"$f":"IF(C3=\"\",\"\",SUM(C14:C15,C17:C21))","v":50912770.490671761},41611412.499999993,256768981.92858678,497277972.30562729,31498517.717187494,"","","","",""]
[null,"TOTAL ACTIVO",{"$f":"+IF(C3=\"\",\"\",C12+C22)","v":944602961.9458952},1144834276.7184815,1104055401.3096938,738412721.84729838,1966409883.2528512,"","","","",""]
[]
[null,"PASIVO"]
[null,"Pasivo Corriente"]
[null,"Pasivos financieros CP",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C21*SUPUESTOS!C23)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D21*SUPUESTOS!D23)","v":13508864.022516258},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E21*SUPUESTOS!E23)","v":86323489.760662347},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F21*SUPUESTOS!F23)","v":104049339.45503172},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G21*SUPUESTOS!G23)","v":0},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H21*SUPUESTOS!H23)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I21*SUPUESTOS!I23)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J21*SUPUESTOS!J23)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K21*SUPUESTOS!K23)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L21*SUPUESTOS!L23)","v":""}]
[null,"Pasivos comerciales y otras cuentas por pagar",{"$f":"+IF(C3=\"\",\"\",'P&G'!C5/360*SUPUESTOS!C41)","v":0},{"$f":"+IF(D3=\"\",\"\",'P&G'!D5/360*SUPUESTOS!D41)","v":26872766.666666672},{"$f":"+IF(E3=\"\",\"\",'P&G'!E5/360*SUPUESTOS!E41)","v":28485132.666666672},{"$f":"+IF(F3=\"\",\"\",'P&G'!F5/360*SUPUESTOS!F41)","v":30194240.626666676},{"$f":"+IF(G3=\"\",\"\",'P&G'!G5/360*SUPUESTOS!G41)","v":224041265.44986671},{"$f":"+IF(H3=\"\",\"\",'P&G'!H5/360*SUPUESTOS!H41)","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I5/360*SUPUESTOS!I41)","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J5/360*SUPUESTOS!J41)","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K5/360*SUPUESTOS!K41)","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L5/360*SUPUESTOS!L41)","v":""}]
[null,"Otras provisiones",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Pasivos por impuestos-CP",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Beneficios a empleados",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C55,0),IF('P&G'!B19>0,'P&G'!B19*SUPUESTOS!B55+IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C55,0),IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C55,0))))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D55,0),IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C55+IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D55,0),IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D55,0))))","v":2054645.203754145},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E55,0),IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D55+IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E55,0),IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E55,0))))","v":2054645.203754145},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F55,0),IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E55+IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F55,0),IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F55,0))))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G55,0),IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F55+IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G55,0),IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G55,0))))","v":30182462.793349739},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H55,0),IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G55+IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H55,0),IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H55,0))))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I55,0),IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H55+IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I55,0),IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I55,0))))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J55,0),IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I55+IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J55,0),IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J55,0))))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K55,0),IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J55+IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K55,0),IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K55,0))))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,IF('P&G'!L19>0,'P&G'!L19*SUPUESTOS!L55,0),IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K55+IF('P&G'!L19>0,'P&G'!L19*SUPUESTOS!L55,0),IF('P&G'!L19>0,'P&G'!L19*SUPUESTOS!L55,0))))","v":""}]
[null,"Otros pasivos",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Total Pasivo Corriente",{"$f":"IF(C3=\"\",\"\",SUM(C27:C32))","v":0},42436275.892937072,116863267.63108316,134243580.08169839,254223728.24321645,"","","","",""]
[null,"Pasivo No Corriente"]
[null,"Pasivos financieros LP",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C21*SUPUESTOS!C24)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D21*SUPUESTOS!D24)","v":54035456.090065032},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E21*SUPUESTOS!E24)","v":345293959.04264939},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F21*SUPUESTOS!F24)","v":416197357.82012689},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G21*SUPUESTOS!G24)","v":0},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H21*SUPUESTOS!H24)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I21*SUPUESTOS!I24)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J21*SUPUESTOS!J24)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K21*SUPUESTOS!K24)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L21*SUPUESTOS!L24)","v":""}]
[null,"Otras provisiones no corrientes",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Pasivos por impuestos diferidos",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Provisiones por beneficios a empleados",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C56,0),IF('P&G'!B19>0,'P&G'!B19*SUPUESTOS!B56+IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C56,0),IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C56,0))))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D56,0),IF('P&G'!C19>0,'P&G'!C19*SUPUESTOS!C56+IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D56,0),IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D56,0))))","v":1027322.6018770725},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E56,0),IF('P&G'!D19>0,'P&G'!D19*SUPUESTOS!D56+IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E56,0),IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E56,0))))","v":1027322.6018770725},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F56,0),IF('P&G'!E19>0,'P&G'!E19*SUPUESTOS!E56+IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F56,0),IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F56,0))))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G56,0),IF('P&G'!F19>0,'P&G'!F19*SUPUESTOS!F56+IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G56,0),IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G56,0))))","v":15091231.39667487},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H56,0),IF('P&G'!G19>0,'P&G'!G19*SUPUESTOS!G56+IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H56,0),IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H56,0))))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I56,0),IF('P&G'!H19>0,'P&G'!H19*SUPUESTOS!H56+IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I56,0),IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I56,0))))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J56,0),IF('P&G'!I19>0,'P&G'!I19*SUPUESTOS!I56+IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J56,0),IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J56,0))))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K56,0),IF('P&G'!J19>0,'P&G'!J19*SUPUESTOS!J56+IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K56,0),IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K56,0))))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,IF('P&G'!L19>0,'P&G'!L19*SUPUESTOS!L56,0),IF('P&G'!K19>0,'P&G'!K19*SUPUESTOS!K56+IF('P&G'!L19>0,'P&G'!L19*SUPUESTOS!L56,0),IF('P&G'!L19>0,'P&G'!L19*SUPUESTOS!L56,0))))","v":""}]
[null,"Total Pasivo No Corriente",{"$f":"IF(C3=\"\",\"\",SUM(C35:C38))","v":0},55062778.691942103,346321281.64452648,416197357.82012689,15091231.39667487,"","","","",""]
[null,"TOTAL PASIVO",{"$f":"IF(C3=\"\",\"\",C39+C33)","v":0},97499054.584879175,463184549.27560961,550440937.90182531,269314959.63989133,"","","","",""]
[]
[null,"PATRIMONIO"]
[null,"Capital suscrito y pagado",{"$f":"+IF(C3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":954274999.99999988},{"$f":"+IF(D3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":954274999.99999988},{"$f":"+IF(E3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":954274999.99999988},{"$f":"+IF(F3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":954274999.99999988},{"$f":"+IF(G3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":954274999.99999988},{"$f":"+IF(H3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":""},{"$f":"+IF(I3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":""},{"$f":"+IF(J3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":""},{"$f":"+IF(K3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":""},{"$f":"+IF(L3=\"\",\"\",DATOS!$F$6-DATOS!$F$6*(SUPUESTOS!$C$49+SUPUESTOS!$C$50))","v":""}]
[null,"Primas en colocación de acciones",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Reservas",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Ganancia neta del periodo",{"$f":"+IF(C3=\"\",\"\",'P&G'!C19)","v":-9672038.0541047119},{"$f":"+IF(D3=\"\",\"\",'P&G'!D19)","v":102732260.18770725},{"$f":"+IF(E3=\"\",\"\",'P&G'!E19)","v":-406464370.09951836},{"$f":"+IF(F3=\"\",\"\",'P&G'!F19)","v":-452899068.08861101},{"$f":"+IF(G3=\"\",\"\",'P&G'!G19)","v":1509123139.6674869},{"$f":"+IF(H3=\"\",\"\",'P&G'!H19)","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I19)","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J19)","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K19)","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L19)","v":""}]
[null,"Resultados acumulados",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,C46,B47+C46))","v":-9672038.0541047119},93060222.13360253,-313404147.9659158,-766303216.05452681,742819923.6129601,"","","","",""]
[null,"Otro resultado integral",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Ganancias acumuladas balance de apertura",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"Participaciones no controlada",{"$f":"+IF(C3=\"\",\"\",0)","v":0},0,0,0,0,"","","","",""]
[null,"TOTAL PATRIMONIO",{"$f":"IF(C3=\"\",\"\",SUM(C43:C45,C47:C50))","v":944602961.9458952},1047335222.1336024,640870852.03408408,187971783.94547307,1697094923.6129599,"","","","",""]
[null,"TOTAL PASIVO + PATRIMONIO",{"$f":"IF(C3=\"\",\"\",C51+C40)","v":944602961.9458952},1144834276.7184815,1104055401.3096938,738412721.84729838,1966409883.2528512,"","","","",""]
[null,"Check------->",{"$f":"IF(C3=\"\",\"\",C23-C52)","v":0},0,0,0,0,"","","","",""]

{"sheet":"FLUJO DE CAJA","index":4,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[22,0,34,0],[20,0,21,0]]}
[null,"ESTADO DE FLUJO DE CAJA",null,null,null,null,null,null,null,null,null,"ROMA INVESTI"]
[]
[null,null,{"$f":"+IF(SUPUESTOS!C3=\"\",\"\",SUPUESTOS!C3)","v":"Año 1"},{"$f":"+IF(SUPUESTOS!D3=\"\",\"\",SUPUESTOS!D3)","v":"Año 2"},{"$f":"+IF(SUPUESTOS!E3=\"\",\"\",SUPUESTOS!E3)","v":"Año 3"},{"$f":"+IF(SUPUESTOS!F3=\"\",\"\",SUPUESTOS!F3)","v":"Año 4"},{"$f":"+IF(SUPUESTOS!G3=\"\",\"\",SUPUESTOS!G3)","v":"Año 5"},{"$f":"+IF(SUPUESTOS!H3=\"\",\"\",SUPUESTOS!H3)","v":""},{"$f":"+IF(SUPUESTOS!I3=\"\",\"\",SUPUESTOS!I3)","v":""},{"$f":"+IF(SUPUESTOS!J3=\"\",\"\",SUPUESTOS!J3)","v":""},{"$f":"+IF(SUPUESTOS!K3=\"\",\"\",SUPUESTOS!K3)","v":""},{"$f":"+IF(SUPUESTOS!L3=\"\",\"\",SUPUESTOS!L3)","v":""}]
[null,"(=) NOPAT",{"$f":"+IF(C3=\"\",\"\",'P&G'!C13*(1-SUPUESTOS!$C$60))","v":-13620202.050000001},{"$f":"+IF(D3=\"\",\"\",'P&G'!D13*(1-SUPUESTOS!$C$60))","v":101695642.56221277},{"$f":"+IF(E3=\"\",\"\",'P&G'!E13*(1-SUPUESTOS!$C$60))","v":-402260188.05577368},{"$f":"+IF(F3=\"\",\"\",'P&G'!F13*(1-SUPUESTOS!$C$60))","v":-419913733.55807477},{"$f":"+IF(G3=\"\",\"\",'P&G'!G13*(1-SUPUESTOS!$C$60))","v":1549764920.6999359},{"$f":"+IF(H3=\"\",\"\",'P&G'!H13*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I13*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J13*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K13*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L13*(1-SUPUESTOS!$C$60))","v":""}]
[null,"(+) Depreciaciones",{"$f":"+IF(C3=\"\",\"\",'P&G'!C7+'P&G'!C11)","v":4018000},{"$f":"+IF(D3=\"\",\"\",'P&G'!D7+'P&G'!D11)","v":3852069.0543613951},{"$f":"+IF(E3=\"\",\"\",'P&G'!E7+'P&G'!E11)","v":4773318.1866705352},{"$f":"+IF(F3=\"\",\"\",'P&G'!F7+'P&G'!F11)","v":4523797.0960040623},{"$f":"+IF(G3=\"\",\"\",'P&G'!G7+'P&G'!G11)","v":2909257.714055107},{"$f":"+IF(H3=\"\",\"\",'P&G'!H7+'P&G'!H11)","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I7+'P&G'!I11)","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J7+'P&G'!J11)","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K7+'P&G'!K11)","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L7+'P&G'!L11)","v":""}]
[null,"(+) Amortizaciones",{"$f":"+IF(C3=\"\",\"\",'P&G'!C8+'P&G'!C12)","v":502250},{"$f":"+IF(D3=\"\",\"\",'P&G'!D8+'P&G'!D12)","v":477137.5},{"$f":"+IF(E3=\"\",\"\",'P&G'!E8+'P&G'!E12)","v":453280.625},{"$f":"+IF(F3=\"\",\"\",'P&G'!F8+'P&G'!F12)","v":430616.59375},{"$f":"+IF(G3=\"\",\"\",'P&G'!G8+'P&G'!G12)","v":409085.76406250056},{"$f":"+IF(H3=\"\",\"\",'P&G'!H8+'P&G'!H12)","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I8+'P&G'!I12)","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J8+'P&G'!J12)","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K8+'P&G'!K12)","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L8+'P&G'!L12)","v":""}]
[null,"(=) Flujo de Caja Bruto",{"$f":"IF(C3=\"\",\"\",C4+C5+C6)","v":-9099952.0500000007},106024849.11657415,-397033589.24410313,-414959319.8683207,1553083264.1780534,"","","","",""]
[null,"(-) Incremento en cartera",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C8,BALANCE!C8-BALANCE!B8))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D8,BALANCE!D8-BALANCE!C8))","v":26872766.666666672},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E8,BALANCE!E8-BALANCE!D8))","v":1612366},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F8,BALANCE!F8-BALANCE!E8))","v":1709107.9600000046},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G8,BALANCE!G8-BALANCE!F8))","v":193847024.82320005},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H8,BALANCE!H8-BALANCE!G8))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I8,BALANCE!I8-BALANCE!H8))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J8,BALANCE!J8-BALANCE!I8))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K8,BALANCE!K8-BALANCE!J8))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L8,BALANCE!L8-BALANCE!K8))","v":""}]
[null,"(-) Incremento en inventario",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C9,BALANCE!C9-BALANCE!B9))","v":545300000},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D9,BALANCE!D9-BALANCE!C9))","v":-322473200.00000006},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E9,BALANCE!E9-BALANCE!D9))","v":-222826799.99999994},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F9,BALANCE!F9-BALANCE!E9))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G9,BALANCE!G9-BALANCE!F9))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H9,BALANCE!H9-BALANCE!G9))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I9,BALANCE!I9-BALANCE!H9))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J9,BALANCE!J9-BALANCE!I9))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K9,BALANCE!K9-BALANCE!J9))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L9,BALANCE!L9-BALANCE!K9))","v":""}]
[null,"(+) Incremento en cuentas por pagar",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C28,BALANCE!C28-BALANCE!B28))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D28,BALANCE!D28-BALANCE!C28))","v":26872766.666666672},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E28,BALANCE!E28-BALANCE!D28))","v":1612366},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F28,BALANCE!F28-BALANCE!E28))","v":1709107.9600000046},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G28,BALANCE!G28-BALANCE!F28))","v":193847024.82320005},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H28,BALANCE!H28-BALANCE!G28))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I28,BALANCE!I28-BALANCE!H28))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J28,BALANCE!J28-BALANCE!I28))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K28,BALANCE!K28-BALANCE!J28))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L28,BALANCE!L28-BALANCE!K28))","v":""}]
[null,"(-) CapEx",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C14+BALANCE!C15+BALANCE!C17+C5+C6,(BALANCE!C14+BALANCE!C15+BALANCE!C17)-(BALANCE!B14+BALANCE!B15+BALANCE!B17)+C5+C6))","v":50224999.999999993},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D14+BALANCE!D15+BALANCE!D17+D5+D6,(BALANCE!D14+BALANCE!D15+BALANCE!D17)-(BALANCE!C14+BALANCE!C15+BALANCE!C17)+D5+D6))","v":235869.05436139507},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E14+BALANCE!E15+BALANCE!E17+E5+E6,(BALANCE!E14+BALANCE!E15+BALANCE!E17)-(BALANCE!D14+BALANCE!D15+BALANCE!D17)+E5+E6))","v":1518738.1866705352},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F14+BALANCE!F15+BALANCE!F17+F5+F6,(BALANCE!F14+BALANCE!F15+BALANCE!F17)-(BALANCE!E14+BALANCE!E15+BALANCE!E17)+F5+F6))","v":1594675.0960040623},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G14+BALANCE!G15+BALANCE!G17+G5+G6,(BALANCE!G14+BALANCE!G15+BALANCE!G17)-(BALANCE!F14+BALANCE!F15+BALANCE!F17)+G5+G6))","v":273047.91405510902},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H14+BALANCE!H15+BALANCE!H17+H5+H6,(BALANCE!H14+BALANCE!H15+BALANCE!H17)-(BALANCE!G14+BALANCE!G15+BALANCE!G17)+H5+H6))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I14+BALANCE!I15+BALANCE!I17+I5+I6,(BALANCE!I14+BALANCE!I15+BALANCE!I17)-(BALANCE!H14+BALANCE!H15+BALANCE!H17)+I5+I6))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J14+BALANCE!J15+BALANCE!J17+J5+J6,(BALANCE!J14+BALANCE!J15+BALANCE!J17)-(BALANCE!I14+BALANCE!I15+BALANCE!I17)+J5+J6))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K14+BALANCE!K15+BALANCE!K17+K5+K6,(BALANCE!K14+BALANCE!K15+BALANCE!K17)-(BALANCE!J14+BALANCE!J15+BALANCE!J17)+K5+K6))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L14+BALANCE!L15+BALANCE!L17+L5+L6,(BALANCE!L14+BALANCE!L15+BALANCE!L17)-(BALANCE!K14+BALANCE!K15+BALANCE!K17)+L5+L6))","v":""}]
[null,"CapEx operativo",{"$f":"IF(C3=\"\",\"\",C$11*(1-SUPUESTOS!C44))","v":5022499.9999999981},{"$f":"IF(D3=\"\",\"\",D$11*(1-SUPUESTOS!D44))","v":23586.905436139503},{"$f":"IF(E3=\"\",\"\",E$11*(1-SUPUESTOS!E44))","v":151873.81866705348},{"$f":"IF(F3=\"\",\"\",F$11*(1-SUPUESTOS!F44))","v":159467.50960040619},{"$f":"IF(G3=\"\",\"\",G$11*(1-SUPUESTOS!G44))","v":27304.791405510896},{"$f":"IF(H3=\"\",\"\",H$11*(1-SUPUESTOS!H44))","v":""},{"$f":"IF(I3=\"\",\"\",I$11*(1-SUPUESTOS!I44))","v":""},{"$f":"IF(J3=\"\",\"\",J$11*(1-SUPUESTOS!J44))","v":""},{"$f":"IF(K3=\"\",\"\",K$11*(1-SUPUESTOS!K44))","v":""},{"$f":"IF(L3=\"\",\"\",L$11*(1-SUPUESTOS!L44))","v":""}]
[null,"CapEx no operativo",{"$f":"+IF(C3=\"\",\"\",C11*SUPUESTOS!C44)","v":45202499.999999993},{"$f":"+IF(D3=\"\",\"\",D11*SUPUESTOS!D44)","v":212282.14892525558},{"$f":"+IF(E3=\"\",\"\",E11*SUPUESTOS!E44)","v":1366864.3680034818},{"$f":"+IF(F3=\"\",\"\",F11*SUPUESTOS!F44)","v":1435207.5864036561},{"$f":"+IF(G3=\"\",\"\",G11*SUPUESTOS!G44)","v":245743.12264959814},{"$f":"+IF(H3=\"\",\"\",H11*SUPUESTOS!H44)","v":""},{"$f":"+IF(I3=\"\",\"\",I11*SUPUESTOS!I44)","v":""},{"$f":"+IF(J3=\"\",\"\",J11*SUPUESTOS!J44)","v":""},{"$f":"+IF(K3=\"\",\"\",K11*SUPUESTOS!K44)","v":""},{"$f":"+IF(L3=\"\",\"\",L11*SUPUESTOS!L44)","v":""}]
[null,"(=) Flujo de Caja Libre (Antes de capex no operativo)",{"$f":"+IF(C3=\"\",\"\",C7-C8-C9+C10-C12)","v":-559422452.04999995},428474462.21113807,-174358663.06277025,-415118787.3779211,1553055959.3866479,"","","","",""]
[null,"(=) Flujo de Caja Libre (Después de capex no operativo)",{"$f":"IF(C3=\"\",\"\",C14-C13)","v":-604624952.04999995},428262180.06221282,-175725527.43077374,-416553994.96432477,1552810216.2639983,"","","","",""]
[null,"(-) Intereses ajustados",{"$f":"+IF('FLUJO DE CAJA'!C3=\"\",\"\",'P&G'!C15*(1-SUPUESTOS!$C$60))","v":0},{"$f":"+IF('FLUJO DE CAJA'!D3=\"\",\"\",'P&G'!D15*(1-SUPUESTOS!$C$60))","v":0},{"$f":"+IF('FLUJO DE CAJA'!E3=\"\",\"\",'P&G'!E15*(1-SUPUESTOS!$C$60))","v":5268456.9687813399},{"$f":"+IF('FLUJO DE CAJA'!F3=\"\",\"\",'P&G'!F15*(1-SUPUESTOS!$C$60))","v":33666161.006658316},{"$f":"+IF('FLUJO DE CAJA'!G3=\"\",\"\",'P&G'!G15*(1-SUPUESTOS!$C$60))","v":40579242.38746237},{"$f":"+IF('FLUJO DE CAJA'!H3=\"\",\"\",'P&G'!H15*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF('FLUJO DE CAJA'!I3=\"\",\"\",'P&G'!I15*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF('FLUJO DE CAJA'!J3=\"\",\"\",'P&G'!J15*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF('FLUJO DE CAJA'!K3=\"\",\"\",'P&G'!K15*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF('FLUJO DE CAJA'!L3=\"\",\"\",'P&G'!L15*(1-SUPUESTOS!$C$60))","v":""}]
[null,"(+) Incremento Obligaciones financieras -CP",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C27,BALANCE!C27-BALANCE!B27))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D27,BALANCE!D27-BALANCE!C27))","v":13508864.022516258},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E27,BALANCE!E27-BALANCE!D27))","v":72814625.738146096},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F27,BALANCE!F27-BALANCE!E27))","v":17725849.694369376},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G27,BALANCE!G27-BALANCE!F27))","v":-104049339.45503172},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H27,BALANCE!H27-BALANCE!G27))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I27,BALANCE!I27-BALANCE!H27))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J27,BALANCE!J27-BALANCE!I27))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K27,BALANCE!K27-BALANCE!J27))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L27,BALANCE!L27-BALANCE!K27))","v":""}]
[null,"(+) Incremento Obligaciones financieras -LP",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C35,BALANCE!C35-BALANCE!B35))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D35,BALANCE!D35-BALANCE!C35))","v":54035456.090065032},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E35,BALANCE!E35-BALANCE!D35))","v":291258502.95258439},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F35,BALANCE!F35-BALANCE!E35))","v":70903398.777477503},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G35,BALANCE!G35-BALANCE!F35))","v":-416197357.82012689},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H35,BALANCE!H35-BALANCE!G35))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I35,BALANCE!I35-BALANCE!H35))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J35,BALANCE!J35-BALANCE!I35))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K35,BALANCE!K35-BALANCE!J35))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L35,BALANCE!L35-BALANCE!K35))","v":""}]
[null,"(=) Flujo de Caja Libre del Inversionista",{"$f":"IF(C3=\"\",\"\",C15-C16+C17+C18)","v":-604624952.04999995},495806500.17479408,183079144.2911754,-361590907.49913621,991984276.60137737,"","","","",""]
[null,"Ajustes de caja"]
["P&G","(+) Ingresos financieros ajustados",{"$f":"+IF(C3=\"\",\"\",'P&G'!C14*(1-SUPUESTOS!$C$60))","v":3990892.1540952898},{"$f":"+IF(D3=\"\",\"\",'P&G'!D14*(1-SUPUESTOS!$C$60))","v":1457009.438204299},{"$f":"+IF(E3=\"\",\"\",'P&G'!E14*(1-SUPUESTOS!$C$60))","v":3569536.4874245669},{"$f":"+IF(F3=\"\",\"\",'P&G'!F14*(1-SUPUESTOS!$C$60))","v":3424324.88633967},{"$f":"+IF(G3=\"\",\"\",'P&G'!G14*(1-SUPUESTOS!$C$60))","v":882178.4307560809},{"$f":"+IF(H3=\"\",\"\",'P&G'!H14*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I14*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J14*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K14*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L14*(1-SUPUESTOS!$C$60))","v":""}]
[null,"(-) Otros gastos financieros",{"$f":"+IF(C3=\"\",\"\",'P&G'!C16*(1-SUPUESTOS!$C$60))","v":42728.158199999998},{"$f":"+IF(D3=\"\",\"\",'P&G'!D16*(1-SUPUESTOS!$C$60))","v":420391.81270980951},{"$f":"+IF(E3=\"\",\"\",'P&G'!E16*(1-SUPUESTOS!$C$60))","v":2505261.5623878767},{"$f":"+IF(F3=\"\",\"\",'P&G'!F16*(1-SUPUESTOS!$C$60))","v":2743498.4102175725},{"$f":"+IF(G3=\"\",\"\",'P&G'!G16*(1-SUPUESTOS!$C$60))","v":944717.07574284193},{"$f":"+IF(H3=\"\",\"\",'P&G'!H16*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I16*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J16*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K16*(1-SUPUESTOS!$C$60))","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L16*(1-SUPUESTOS!$C$60))","v":""}]
["BALANCE","(-) Incremento en activos por impuestos",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C10,BALANCE!C10-BALANCE!B10))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D10,BALANCE!D10-BALANCE!C10))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E10,BALANCE!E10-BALANCE!D10))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F10,BALANCE!F10-BALANCE!E10))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G10,BALANCE!G10-BALANCE!F10))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H10,BALANCE!H10-BALANCE!G10))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I10,BALANCE!I10-BALANCE!H10))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J10,BALANCE!J10-BALANCE!I10))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K10,BALANCE!K10-BALANCE!J10))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L10,BALANCE!L10-BALANCE!K10))","v":""}]
[null,"(-) Incremento en inversiones financieras",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C18,BALANCE!C18-BALANCE!B18))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D18,BALANCE!D18-BALANCE!C18))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E18,BALANCE!E18-BALANCE!D18))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F18,BALANCE!F18-BALANCE!E18))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G18,BALANCE!G18-BALANCE!F18))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H18,BALANCE!H18-BALANCE!G18))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I18,BALANCE!I18-BALANCE!H18))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J18,BALANCE!J18-BALANCE!I18))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K18,BALANCE!K18-BALANCE!J18))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L18,BALANCE!L18-BALANCE!K18))","v":""}]
[null,"(-) Incremento en otros activos no financieros",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C11,BALANCE!C11-BALANCE!B11))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D11,BALANCE!D11-BALANCE!C11))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E11,BALANCE!E11-BALANCE!D11))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F11,BALANCE!F11-BALANCE!E11))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G11,BALANCE!G11-BALANCE!F11))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H11,BALANCE!H11-BALANCE!G11))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I11,BALANCE!I11-BALANCE!H11))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J11,BALANCE!J11-BALANCE!I11))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K11,BALANCE!K11-BALANCE!J11))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L11,BALANCE!L11-BALANCE!K11))","v":""}]
[null,"(-) Incremento en deudores comerciales - LP",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C19,BALANCE!C19-BALANCE!B19))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D19,BALANCE!D19-BALANCE!C19))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E19,BALANCE!E19-BALANCE!D19))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F19,BALANCE!F19-BALANCE!E19))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G19,BALANCE!G19-BALANCE!F19))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H19,BALANCE!H19-BALANCE!G19))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I19,BALANCE!I19-BALANCE!H19))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J19,BALANCE!J19-BALANCE!I19))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K19,BALANCE!K19-BALANCE!J19))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L19,BALANCE!L19-BALANCE!K19))","v":""}]
[null,"(-) Incremento en activos por impuestos diferidos",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C20,BALANCE!C20-BALANCE!B20))","v":5208020.4906717669},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D20,BALANCE!D20-BALANCE!C20))","v":-5208020.4906717669},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E20,BALANCE!E20-BALANCE!D20))","v":218865430.05358678},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F20,BALANCE!F20-BALANCE!E20))","v":243868728.97079051},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G20,BALANCE!G20-BALANCE!F20))","v":-462734159.02437729},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H20,BALANCE!H20-BALANCE!G20))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I20,BALANCE!I20-BALANCE!H20))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J20,BALANCE!J20-BALANCE!I20))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K20,BALANCE!K20-BALANCE!J20))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L20,BALANCE!L20-BALANCE!K20))","v":""}]
[null,"(-) Incremento en otros activos - LP",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C21,BALANCE!C21-BALANCE!B21))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D21,BALANCE!D21-BALANCE!C21))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E21,BALANCE!E21-BALANCE!D21))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F21,BALANCE!F21-BALANCE!E21))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G21,BALANCE!G21-BALANCE!F21))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H21,BALANCE!H21-BALANCE!G21))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I21,BALANCE!I21-BALANCE!H21))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J21,BALANCE!J21-BALANCE!I21))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K21,BALANCE!K21-BALANCE!J21))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L21,BALANCE!L21-BALANCE!K21))","v":""}]
[null,"(+) Incremento en pasivos por impuestos - CP",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C30,BALANCE!C30-BALANCE!B30))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D30,BALANCE!D30-BALANCE!C30))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E30,BALANCE!E30-BALANCE!D30))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F30,BALANCE!F30-BALANCE!E30))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G30,BALANCE!G30-BALANCE!F30))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H30,BALANCE!H30-BALANCE!G30))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I30,BALANCE!I30-BALANCE!H30))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J30,BALANCE!J30-BALANCE!I30))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K30,BALANCE!K30-BALANCE!J30))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L30,BALANCE!L30-BALANCE!K30))","v":""}]
[null,"(+) Incremento en beneficio a empleados",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C31,BALANCE!C31-BALANCE!B31))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D31,BALANCE!D31-BALANCE!C31))","v":2054645.203754145},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E31,BALANCE!E31-BALANCE!D31))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F31,BALANCE!F31-BALANCE!E31))","v":-2054645.203754145},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G31,BALANCE!G31-BALANCE!F31))","v":30182462.793349739},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H31,BALANCE!H31-BALANCE!G31))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I31,BALANCE!I31-BALANCE!H31))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J31,BALANCE!J31-BALANCE!I31))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K31,BALANCE!K31-BALANCE!J31))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L31,BALANCE!L31-BALANCE!K31))","v":""}]
[null,"(+) Incremento en otros pasivos",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C32,BALANCE!C32-BALANCE!B32))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D32,BALANCE!D32-BALANCE!C32))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E32,BALANCE!E32-BALANCE!D32))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F32,BALANCE!F32-BALANCE!E32))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G32,BALANCE!G32-BALANCE!F32))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H32,BALANCE!H32-BALANCE!G32))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I32,BALANCE!I32-BALANCE!H32))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J32,BALANCE!J32-BALANCE!I32))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K32,BALANCE!K32-BALANCE!J32))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L32,BALANCE!L32-BALANCE!K32))","v":""}]
[null,"(+) Incremento en otras provisiones",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C29,BALANCE!C29-BALANCE!B29))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D29,BALANCE!D29-BALANCE!C29))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E29,BALANCE!E29-BALANCE!D29))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F29,BALANCE!F29-BALANCE!E29))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G29,BALANCE!G29-BALANCE!F29))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H29,BALANCE!H29-BALANCE!G29))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I29,BALANCE!I29-BALANCE!H29))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J29,BALANCE!J29-BALANCE!I29))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K29,BALANCE!K29-BALANCE!J29))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L29,BALANCE!L29-BALANCE!K29))","v":""}]
[null,"(+) Incremento en pasivo por impuestos diferidos",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C37,BALANCE!C37-BALANCE!B37))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D37,BALANCE!D37-BALANCE!C37))","v":0},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E37,BALANCE!E37-BALANCE!D37))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F37,BALANCE!F37-BALANCE!E37))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G37,BALANCE!G37-BALANCE!F37))","v":0},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H37,BALANCE!H37-BALANCE!G37))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I37,BALANCE!I37-BALANCE!H37))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J37,BALANCE!J37-BALANCE!I37))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K37,BALANCE!K37-BALANCE!J37))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L37,BALANCE!L37-BALANCE!K37))","v":""}]
[null,"(+) Incremento en provisiones por beneficios a empleados",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,BALANCE!C38,BALANCE!C38-BALANCE!B38))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,BALANCE!D38,BALANCE!D38-BALANCE!C38))","v":1027322.6018770725},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,BALANCE!E38,BALANCE!E38-BALANCE!D38))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,BALANCE!F38,BALANCE!F38-BALANCE!E38))","v":-1027322.6018770725},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,BALANCE!G38,BALANCE!G38-BALANCE!F38))","v":15091231.39667487},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,BALANCE!H38,BALANCE!H38-BALANCE!G38))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,BALANCE!I38,BALANCE!I38-BALANCE!H38))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,BALANCE!J38,BALANCE!J38-BALANCE!I38))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,BALANCE!K38,BALANCE!K38-BALANCE!J38))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,BALANCE!L38,BALANCE!L38-BALANCE!K38))","v":""}]
[null,"(-) Dividendos",{"$f":"+IF(C3=\"\",\"\",'P&G'!C19*SUPUESTOS!C37)","v":0},{"$f":"+IF(D3=\"\",\"\",'P&G'!D19*SUPUESTOS!D37)","v":0},{"$f":"+IF(E3=\"\",\"\",'P&G'!E19*SUPUESTOS!E37)","v":0},{"$f":"+IF(F3=\"\",\"\",'P&G'!F19*SUPUESTOS!F37)","v":0},{"$f":"+IF(G3=\"\",\"\",'P&G'!G19*SUPUESTOS!G37)","v":0},{"$f":"+IF(H3=\"\",\"\",'P&G'!H19*SUPUESTOS!H37)","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I19*SUPUESTOS!I37)","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J19*SUPUESTOS!J37)","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K19*SUPUESTOS!K37)","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L19*SUPUESTOS!L37)","v":""}]
[null,"(=) Cambio en efectivo",{"$f":"IF(C3=\"\",\"\",C19+C21-SUM(C22:C28)+SUM(C29:C34)-C35)","v":-605884808.54477644},505133106.09659153,-34722010.837374717,-607860777.79943585,1499929591.1707926,"","","","",""]
[]
[null,null,null,null,null,null,null,1576960]

{"sheet":"KPI'S","index":5,"n_rows":29,"n_cols":122,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"KPI'S",null,null,null,null,null,null,null,null,null,"ROMA INVESTI"]
[]
[null,null,{"$f":"+IF(SUPUESTOS!C3=\"\",\"\",SUPUESTOS!C3)","v":"Año 1"},{"$f":"+IF(SUPUESTOS!D3=\"\",\"\",SUPUESTOS!D3)","v":"Año 2"},{"$f":"+IF(SUPUESTOS!E3=\"\",\"\",SUPUESTOS!E3)","v":"Año 3"},{"$f":"+IF(SUPUESTOS!F3=\"\",\"\",SUPUESTOS!F3)","v":"Año 4"},{"$f":"+IF(SUPUESTOS!G3=\"\",\"\",SUPUESTOS!G3)","v":"Año 5"},{"$f":"+IF(SUPUESTOS!H3=\"\",\"\",SUPUESTOS!H3)","v":""},{"$f":"+IF(SUPUESTOS!I3=\"\",\"\",SUPUESTOS!I3)","v":""},{"$f":"+IF(SUPUESTOS!J3=\"\",\"\",SUPUESTOS!J3)","v":""},{"$f":"+IF(SUPUESTOS!K3=\"\",\"\",SUPUESTOS!K3)","v":""},{"$f":"+IF(SUPUESTOS!L3=\"\",\"\",SUPUESTOS!L3)","v":""}]
[null,"Avance acumulado (Curva S)",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C8)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D8)","v":7.0103716545108136E-2},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E8)","v":0.49999999999999994},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F8)","v":0.92989628345489184},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G8)","v":1},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H8)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I8)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J8)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K8)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L8)","v":""}]
[null,"Terreno",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C5)","v":401800000.00000006},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D5)","v":0},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E5)","v":0},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F5)","v":0},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G5)","v":0},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H5)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I5)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J5)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K5)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L5)","v":""}]
[null,"Estructuración",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C4)","v":86100000},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D4)","v":0},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E4)","v":0},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F4)","v":0},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G4)","v":0},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H4)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I4)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J4)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K4)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L4)","v":""}]
[null,"Licencias y permisos",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C6)","v":57400000},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D6)","v":0},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E6)","v":0},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F6)","v":0},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G6)","v":0},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H6)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I6)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J6)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K6)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L6)","v":""}]
[null,"Fiducia",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C12)","v":16433907},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D12)","v":4785754.4777051089},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E12)","v":27909019.025721636},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F12)","v":29309361.443989232},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G12)","v":8853148.9899658412},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H12)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I12)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J12)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K12)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L12)","v":""}]
[null,"Construcción",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C10)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D10)","v":128655847.83348817},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E10)","v":828402647.27483749},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F10)","v":869822779.63857925},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G10)","v":148935225.84824181},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H10)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I10)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J10)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K10)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L10)","v":""}]
[null,"Gerencia ",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C11)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D11)","v":12865584.783348817},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E11)","v":82840264.727483749},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F11)","v":86982277.963857934},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G11)","v":14893522.584824182},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H11)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I11)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J11)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K11)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L11)","v":""}]
[null,"Comercialización",{"$f":"+IF(C3=\"\",\"\",SUPUESTOS!C16+SUPUESTOS!C17)","v":0},{"$f":"+IF(D3=\"\",\"\",SUPUESTOS!D16+SUPUESTOS!D17)","v":10544873.640000002},{"$f":"+IF(E3=\"\",\"\",SUPUESTOS!E16+SUPUESTOS!E17)","v":11177566.058400001},{"$f":"+IF(F3=\"\",\"\",SUPUESTOS!F16+SUPUESTOS!F17)","v":11848220.021904003},{"$f":"+IF(G3=\"\",\"\",SUPUESTOS!G16+SUPUESTOS!G17)","v":87913792.562527701},{"$f":"+IF(H3=\"\",\"\",SUPUESTOS!H16+SUPUESTOS!H17)","v":""},{"$f":"+IF(I3=\"\",\"\",SUPUESTOS!I16+SUPUESTOS!I17)","v":""},{"$f":"+IF(J3=\"\",\"\",SUPUESTOS!J16+SUPUESTOS!J17)","v":""},{"$f":"+IF(K3=\"\",\"\",SUPUESTOS!K16+SUPUESTOS!K17)","v":""},{"$f":"+IF(L3=\"\",\"\",SUPUESTOS!L16+SUPUESTOS!L17)","v":""}]
[null,"Financieros (Neto)",{"$f":"+IF(C3=\"\",\"\",'P&G'!C15+'P&G'!C16-'P&G'!C14)","v":-6074098.4552235231},{"$f":"+IF(D3=\"\",\"\",'P&G'!D15+'P&G'!D16-'P&G'!D14)","v":-1594796.3469145992},{"$f":"+IF(E3=\"\",\"\",'P&G'!E15+'P&G'!E16-'P&G'!E14)","v":6467972.3749917699},{"$f":"+IF(F3=\"\",\"\",'P&G'!F15+'P&G'!F16-'P&G'!F14)","v":50746668.50851725},{"$f":"+IF(G3=\"\",\"\",'P&G'!G15+'P&G'!G16-'P&G'!G14)","v":62525816.972998664},{"$f":"+IF(H3=\"\",\"\",'P&G'!H15+'P&G'!H16-'P&G'!H14)","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I15+'P&G'!I16-'P&G'!I14)","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J15+'P&G'!J16-'P&G'!J14)","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K15+'P&G'!K16-'P&G'!K14)","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L15+'P&G'!L16-'P&G'!L14)","v":""}]
[null,"Impuestos ",{"$f":"+IF(C3=\"\",\"\",IF(SUPUESTOS!C18+'P&G'!C18<0,0,SUPUESTOS!C18+'P&G'!C18))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(SUPUESTOS!D18+'P&G'!D18<0,0,SUPUESTOS!D18+'P&G'!D18))","v":60154468.870303899},{"$f":"+IF(E3=\"\",\"\",IF(SUPUESTOS!E18+'P&G'!E18<0,0,SUPUESTOS!E18+'P&G'!E18))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(SUPUESTOS!F18+'P&G'!F18<0,0,SUPUESTOS!F18+'P&G'!F18))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(SUPUESTOS!G18+'P&G'!G18<0,0,SUPUESTOS!G18+'P&G'!G18))","v":852932195.29423809},{"$f":"+IF(H3=\"\",\"\",IF(SUPUESTOS!H18+'P&G'!H18<0,0,SUPUESTOS!H18+'P&G'!H18))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(SUPUESTOS!I18+'P&G'!I18<0,0,SUPUESTOS!I18+'P&G'!I18))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(SUPUESTOS!J18+'P&G'!J18<0,0,SUPUESTOS!J18+'P&G'!J18))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(SUPUESTOS!K18+'P&G'!K18<0,0,SUPUESTOS!K18+'P&G'!K18))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(SUPUESTOS!L18+'P&G'!L18<0,0,SUPUESTOS!L18+'P&G'!L18))","v":""}]
[null,"Inversión total ",{"$f":"+IF(C3=\"\",\"\",SUM(C5:C13))","v":555659808.54477644},215411733.25793141,956797469.46143472,1048709307.5768477,1176053702.2527962,"","","","",""]
[null,"Inversión total  acumulada",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,C14,B15+C14))","v":555659808.54477644},771071541.80270791,1727869011.2641425,2776578318.8409901,3952632021.0937862,"","","","",""]
[null,"Ventas",{"$f":"+IF(C3=\"\",\"\",'P&G'!C4)","v":0},{"$f":"+IF(D3=\"\",\"\",'P&G'!D4)","v":322473200.00000006},{"$f":"+IF(E3=\"\",\"\",'P&G'!E4)","v":341821592.00000006},{"$f":"+IF(F3=\"\",\"\",'P&G'!F4)","v":362330887.5200001},{"$f":"+IF(G3=\"\",\"\",'P&G'!G4)","v":2688495185.3984008},{"$f":"+IF(H3=\"\",\"\",'P&G'!H4)","v":""},{"$f":"+IF(I3=\"\",\"\",'P&G'!I4)","v":""},{"$f":"+IF(J3=\"\",\"\",'P&G'!J4)","v":""},{"$f":"+IF(K3=\"\",\"\",'P&G'!K4)","v":""},{"$f":"+IF(L3=\"\",\"\",'P&G'!L4)","v":""}]
[null,"Ventas acumuladas",{"$f":"+IF(C3=\"\",\"\",IF(VALUE(RIGHT(C3,LEN(C3)-FIND(\" \",C3)))=1,'P&G'!C4,B17+'P&G'!C4))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(VALUE(RIGHT(D3,LEN(D3)-FIND(\" \",D3)))=1,'P&G'!D4,C17+'P&G'!D4))","v":322473200.00000006},{"$f":"+IF(E3=\"\",\"\",IF(VALUE(RIGHT(E3,LEN(E3)-FIND(\" \",E3)))=1,'P&G'!E4,D17+'P&G'!E4))","v":664294792.00000012},{"$f":"+IF(F3=\"\",\"\",IF(VALUE(RIGHT(F3,LEN(F3)-FIND(\" \",F3)))=1,'P&G'!F4,E17+'P&G'!F4))","v":1026625679.5200002},{"$f":"+IF(G3=\"\",\"\",IF(VALUE(RIGHT(G3,LEN(G3)-FIND(\" \",G3)))=1,'P&G'!G4,F17+'P&G'!G4))","v":3715120864.9184008},{"$f":"+IF(H3=\"\",\"\",IF(VALUE(RIGHT(H3,LEN(H3)-FIND(\" \",H3)))=1,'P&G'!H4,G17+'P&G'!H4))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(VALUE(RIGHT(I3,LEN(I3)-FIND(\" \",I3)))=1,'P&G'!I4,H17+'P&G'!I4))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(VALUE(RIGHT(J3,LEN(J3)-FIND(\" \",J3)))=1,'P&G'!J4,I17+'P&G'!J4))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(VALUE(RIGHT(K3,LEN(K3)-FIND(\" \",K3)))=1,'P&G'!K4,J17+'P&G'!K4))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(VALUE(RIGHT(L3,LEN(L3)-FIND(\" \",L3)))=1,'P&G'!L4,K17+'P&G'!L4))","v":""}]
[null,"Punto de equilibrio",{"$f":"+IF(C3=\"\",\"\",IF((C17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,C17/(SUM(_xlfn._xlws.FILTER(C$14:L$14,$C$14:$L$14<>\"\")))))","v":0},{"$f":"+IF(D3=\"\",\"\",IF((D17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,D17/(SUM(_xlfn._xlws.FILTER(D$14:M$14,$C$14:$L$14<>\"\")))))","v":9.4929596070502914E-2},{"$f":"+IF(E3=\"\",\"\",IF((E17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,E17/(SUM(_xlfn._xlws.FILTER(E$14:N$14,$C$14:$L$14<>\"\")))))","v":0.20879527399335171},{"$f":"+IF(F3=\"\",\"\",IF((F17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,F17/(SUM(_xlfn._xlws.FILTER(F$14:O$14,$C$14:$L$14<>\"\")))))","v":0.46145395036867848},{"$f":"+IF(G3=\"\",\"\",IF((G17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,G17/(SUM(_xlfn._xlws.FILTER(G$14:P$14,$C$14:$L$14<>\"\")))))","v":3.1589721266995552},{"$f":"+IF(H3=\"\",\"\",IF((H17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,H17/(SUM(_xlfn._xlws.FILTER(H$14:Q$14,$C$14:$L$14<>\"\")))))","v":""},{"$f":"+IF(I3=\"\",\"\",IF((I17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,I17/(SUM(_xlfn._xlws.FILTER(I$14:R$14,$C$14:$L$14<>\"\")))))","v":""},{"$f":"+IF(J3=\"\",\"\",IF((J17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,J17/(SUM(_xlfn._xlws.FILTER(J$14:S$14,$C$14:$L$14<>\"\")))))","v":""},{"$f":"+IF(K3=\"\",\"\",IF((K17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,K17/(SUM(_xlfn._xlws.FILTER(K$14:T$14,$C$14:$L$14<>\"\")))))","v":""},{"$f":"+IF(L3=\"\",\"\",IF((L17/(SUM(_xlfn._xlws.FILTER($C$14:$L$14,$C$14:$L$14<>\"\"))))>1,1,L17/(SUM(_xlfn._xlws.FILTER(L$14:U$14,$C$14:$L$14<>\"\")))))","v":""}]
[null,"Efectivo Acumulado",{"$f":"+IF(C3=\"\",\"\",BALANCE!C6)","v":348390191.45522344},{"$f":"+IF(D3=\"\",\"\",BALANCE!D6)","v":853523297.55181503},{"$f":"+IF(E3=\"\",\"\",BALANCE!E6)","v":818801286.71444035},{"$f":"+IF(F3=\"\",\"\",BALANCE!F6)","v":210940508.91500449},{"$f":"+IF(G3=\"\",\"\",BALANCE!G6)","v":1710870100.0857971},{"$f":"+IF(H3=\"\",\"\",BALANCE!H6)","v":""},{"$f":"+IF(I3=\"\",\"\",BALANCE!I6)","v":""},{"$f":"+IF(J3=\"\",\"\",BALANCE!J6)","v":""},{"$f":"+IF(K3=\"\",\"\",BALANCE!K6)","v":""},{"$f":"+IF(L3=\"\",\"\",BALANCE!L6)","v":""}]
[null,"EBITDA",{"$f":"+IF(C3=\"\",\"\",IF('P&G'!C13<0,0,'P&G'!C13+'P&G'!C12+'P&G'!C11+'P&G'!C8+'P&G'!C7))","v":0},{"$f":"+IF(D3=\"\",\"\",IF('P&G'!D13<0,0,'P&G'!D13+'P&G'!D12+'P&G'!D11+'P&G'!D8+'P&G'!D7))","v":160784041.26545796},{"$f":"+IF(E3=\"\",\"\",IF('P&G'!E13<0,0,'P&G'!E13+'P&G'!E12+'P&G'!E11+'P&G'!E8+'P&G'!E7))","v":0},{"$f":"+IF(F3=\"\",\"\",IF('P&G'!F13<0,0,'P&G'!F13+'P&G'!F12+'P&G'!F11+'P&G'!F8+'P&G'!F7))","v":0},{"$f":"+IF(G3=\"\",\"\",IF('P&G'!G13<0,0,'P&G'!G13+'P&G'!G12+'P&G'!G11+'P&G'!G8+'P&G'!G7))","v":2387572067.6318655},{"$f":"+IF(H3=\"\",\"\",IF('P&G'!H13<0,0,'P&G'!H13+'P&G'!H12+'P&G'!H11+'P&G'!H8+'P&G'!H7))","v":""},{"$f":"+IF(I3=\"\",\"\",IF('P&G'!I13<0,0,'P&G'!I13+'P&G'!I12+'P&G'!I11+'P&G'!I8+'P&G'!I7))","v":""},{"$f":"+IF(J3=\"\",\"\",IF('P&G'!J13<0,0,'P&G'!J13+'P&G'!J12+'P&G'!J11+'P&G'!J8+'P&G'!J7))","v":""},{"$f":"+IF(K3=\"\",\"\",IF('P&G'!K13<0,0,'P&G'!K13+'P&G'!K12+'P&G'!K11+'P&G'!K8+'P&G'!K7))","v":""},{"$f":"+IF(L3=\"\",\"\",IF('P&G'!L13<0,0,'P&G'!L13+'P&G'!L12+'P&G'!L11+'P&G'!L8+'P&G'!L7))","v":""},{"$f":"+IF(M3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(N3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(O3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(P3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(Q3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(R3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(S3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(T3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(U3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(V3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(W3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(X3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(Y3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(Z3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AA3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AB3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AC3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AD3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AE3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AF3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AG3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AH3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AI3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AJ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AK3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AL3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AM3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AN3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AO3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AP3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AQ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AR3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AS3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AT3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AU3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AV3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AW3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AX3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AY3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(AZ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BA3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BB3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BC3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BD3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BE3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BF3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BG3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BH3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BI3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BJ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BK3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BL3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BM3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BN3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BO3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BP3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BQ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BR3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BS3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BT3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BU3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BV3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BW3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BX3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BY3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(BZ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CA3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CB3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CC3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CD3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CE3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CF3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CG3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CH3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CI3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CJ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CK3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CL3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CM3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CN3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CO3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CP3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CQ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CR3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CS3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CT3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CU3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CV3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CW3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CX3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CY3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(CZ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DA3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DB3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DC3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DD3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DE3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DF3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DG3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DH3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DI3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DJ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DK3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DL3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DM3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DN3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DO3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DP3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DQ3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""},{"$f":"+IF(DR3=\"\",\"\",#REF!+#REF!+#REF!+#REF!+#REF!)","v":""}]
[null,"Flujo de caja libre  (Año)",{"$f":"+IF(C3=\"\",\"\",'FLUJO DE CAJA'!C19)","v":-604624952.04999995},{"$f":"+IF(D3=\"\",\"\",'FLUJO DE CAJA'!D19)","v":495806500.17479408},{"$f":"+IF(E3=\"\",\"\",'FLUJO DE CAJA'!E19)","v":183079144.2911754},{"$f":"+IF(F3=\"\",\"\",'FLUJO DE CAJA'!F19)","v":-361590907.49913621},{"$f":"+IF(G3=\"\",\"\",'FLUJO DE CAJA'!G19)","v":991984276.60137737},{"$f":"+IF(H3=\"\",\"\",'FLUJO DE CAJA'!H19)","v":""},{"$f":"+IF(I3=\"\",\"\",'FLUJO DE CAJA'!I19)","v":""},{"$f":"+IF(J3=\"\",\"\",'FLUJO DE CAJA'!J19)","v":""},{"$f":"+IF(K3=\"\",\"\",'FLUJO DE CAJA'!K19)","v":""},{"$f":"+IF(L3=\"\",\"\",'FLUJO DE CAJA'!L19)","v":""}]
[null,"Margen Ebitda",{"$f":"+IF(C3=\"\",\"\",IF(C20=0,0,C20/'P&G'!C5))","v":0},{"$f":"+IF(D3=\"\",\"\",IF(D20=0,0,D20/'P&G'!D5))","v":0.49859660047860699},{"$f":"+IF(E3=\"\",\"\",IF(E20=0,0,E20/'P&G'!E5))","v":0},{"$f":"+IF(F3=\"\",\"\",IF(F20=0,0,F20/'P&G'!F5))","v":0},{"$f":"+IF(G3=\"\",\"\",IF(G20=0,0,G20/'P&G'!G5))","v":0.88807005517402771},{"$f":"+IF(H3=\"\",\"\",IF(H20=0,0,H20/'P&G'!H5))","v":""},{"$f":"+IF(I3=\"\",\"\",IF(I20=0,0,I20/'P&G'!I5))","v":""},{"$f":"+IF(J3=\"\",\"\",IF(J20=0,0,J20/'P&G'!J5))","v":""},{"$f":"+IF(K3=\"\",\"\",IF(K20=0,0,K20/'P&G'!K5))","v":""},{"$f":"+IF(L3=\"\",\"\",IF(L20=0,0,L20/'P&G'!L5))","v":""},{"$f":"+IF(M3=\"\",\"\",IF(M20<=0,0,M20/#REF!))","v":""},{"$f":"+IF(N3=\"\",\"\",IF(N20<=0,0,N20/#REF!))","v":""},{"$f":"+IF(O3=\"\",\"\",IF(O20<=0,0,O20/#REF!))","v":""},{"$f":"+IF(P3=\"\",\"\",IF(P20<=0,0,P20/#REF!))","v":""},{"$f":"+IF(Q3=\"\",\"\",IF(Q20<=0,0,Q20/#REF!))","v":""},{"$f":"+IF(R3=\"\",\"\",IF(R20<=0,0,R20/#REF!))","v":""},{"$f":"+IF(S3=\"\",\"\",IF(S20<=0,0,S20/#REF!))","v":""},{"$f":"+IF(T3=\"\",\"\",IF(T20<=0,0,T20/#REF!))","v":""},{"$f":"+IF(U3=\"\",\"\",IF(U20<=0,0,U20/#REF!))","v":""},{"$f":"+IF(V3=\"\",\"\",IF(V20<=0,0,V20/#REF!))","v":""},{"$f":"+IF(W3=\"\",\"\",IF(W20<=0,0,W20/#REF!))","v":""},{"$f":"+IF(X3=\"\",\"\",IF(X20<=0,0,X20/#REF!))","v":""},{"$f":"+IF(Y3=\"\",\"\",IF(Y20<=0,0,Y20/#REF!))","v":""},{"$f":"+IF(Z3=\"\",\"\",IF(Z20<=0,0,Z20/#REF!))","v":""},{"$f":"+IF(AA3=\"\",\"\",IF(AA20<=0,0,AA20/#REF!))","v":""},{"$f":"+IF(AB3=\"\",\"\",IF(AB20<=0,0,AB20/#REF!))","v":""},{"$f":"+IF(AC3=\"\",\"\",IF(AC20<=0,0,AC20/#REF!))","v":""},{"$f":"+IF(AD3=\"\",\"\",IF(AD20<=0,0,AD20/#REF!))","v":""},{"$f":"+IF(AE3=\"\",\"\",IF(AE20<=0,0,AE20/#REF!))","v":""},{"$f":"+IF(AF3=\"\",\"\",IF(AF20<=0,0,AF20/#REF!))","v":""},{"$f":"+IF(AG3=\"\",\"\",IF(AG20<=0,0,AG20/#REF!))","v":""},{"$f":"+IF(AH3=\"\",\"\",IF(AH20<=0,0,AH20/#REF!))","v":""},{"$f":"+IF(AI3=\"\",\"\",IF(AI20<=0,0,AI20/#REF!))","v":""},{"$f":"+IF(AJ3=\"\",\"\",IF(AJ20<=0,0,AJ20/#REF!))","v":""},{"$f":"+IF(AK3=\"\",\"\",IF(AK20<=0,0,AK20/#REF!))","v":""},{"$f":"+IF(AL3=\"\",\"\",IF(AL20<=0,0,AL20/#REF!))","v":""},{"$f":"+IF(AM3=\"\",\"\",IF(AM20<=0,0,AM20/#REF!))","v":""},{"$f":"+IF(AN3=\"\",\"\",IF(AN20<=0,0,AN20/#REF!))","v":""},{"$f":"+IF(AO3=\"\",\"\",IF(AO20<=0,0,AO20/#REF!))","v":""},{"$f":"+IF(AP3=\"\",\"\",IF(AP20<=0,0,AP20/#REF!))","v":""},{"$f":"+IF(AQ3=\"\",\"\",IF(AQ20<=0,0,AQ20/#REF!))","v":""},{"$f":"+IF(AR3=\"\",\"\",IF(AR20<=0,0,AR20/#REF!))","v":""},{"$f":"+IF(AS3=\"\",\"\",IF(AS20<=0,0,AS20/#REF!))","v":""},{"$f":"+IF(AT3=\"\",\"\",IF(AT20<=0,0,AT20/#REF!))","v":""},{"$f":"+IF(AU3=\"\",\"\",IF(AU20<=0,0,AU20/#REF!))","v":""},{"$f":"+IF(AV3=\"\",\"\",IF(AV20<=0,0,AV20/#REF!))","v":""},{"$f":"+IF(AW3=\"\",\"\",IF(AW20<=0,0,AW20/#REF!))","v":""},{"$f":"+IF(AX3=\"\",\"\",IF(AX20<=0,0,AX20/#REF!))","v":""},{"$f":"+IF(AY3=\"\",\"\",IF(AY20<=0,0,AY20/#REF!))","v":""},{"$f":"+IF(AZ3=\"\",\"\",IF(AZ20<=0,0,AZ20/#REF!))","v":""},{"$f":"+IF(BA3=\"\",\"\",IF(BA20<=0,0,BA20/#REF!))","v":""},{"$f":"+IF(BB3=\"\",\"\",IF(BB20<=0,0,BB20/#REF!))","v":""},{"$f":"+IF(BC3=\"\",\"\",IF(BC20<=0,0,BC20/#REF!))","v":""},{"$f":"+IF(BD3=\"\",\"\",IF(BD20<=0,0,BD20/#REF!))","v":""},{"$f":"+IF(BE3=\"\",\"\",IF(BE20<=0,0,BE20/#REF!))","v":""},{"$f":"+IF(BF3=\"\",\"\",IF(BF20<=0,0,BF20/#REF!))","v":""},{"$f":"+IF(BG3=\"\",\"\",IF(BG20<=0,0,BG20/#REF!))","v":""},{"$f":"+IF(BH3=\"\",\"\",IF(BH20<=0,0,BH20/#REF!))","v":""},{"$f":"+IF(BI3=\"\",\"\",IF(BI20<=0,0,BI20/#REF!))","v":""},{"$f":"+IF(BJ3=\"\",\"\",IF(BJ20<=0,0,BJ20/#REF!))","v":""},{"$f":"+IF(BK3=\"\",\"\",IF(BK20<=0,0,BK20/#REF!))","v":""},{"$f":"+IF(BL3=\"\",\"\",IF(BL20<=0,0,BL20/#REF!))","v":""},{"$f":"+IF(BM3=\"\",\"\",IF(BM20<=0,0,BM20/#REF!))","v":""},{"$f":"+IF(BN3=\"\",\"\",IF(BN20<=0,0,BN20/#REF!))","v":""},{"$f":"+IF(BO3=\"\",\"\",IF(BO20<=0,0,BO20/#REF!))","v":""},{"$f":"+IF(BP3=\"\",\"\",IF(BP20<=0,0,BP20/#REF!))","v":""},{"$f":"+IF(BQ3=\"\",\"\",IF(BQ20<=0,0,BQ20/#REF!))","v":""},{"$f":"+IF(BR3=\"\",\"\",IF(BR20<=0,0,BR20/#REF!))","v":""},{"$f":"+IF(BS3=\"\",\"\",IF(BS20<=0,0,BS20/#REF!))","v":""},{"$f":"+IF(BT3=\"\",\"\",IF(BT20<=0,0,BT20/#REF!))","v":""},{"$f":"+IF(BU3=\"\",\"\",IF(BU20<=0,0,BU20/#REF!))","v":""},{"$f":"+IF(BV3=\"\",\"\",IF(BV20<=0,0,BV20/#REF!))","v":""},{"$f":"+IF(BW3=\"\",\"\",IF(BW20<=0,0,BW20/#REF!))","v":""},{"$f":"+IF(BX3=\"\",\"\",IF(BX20<=0,0,BX20/#REF!))","v":""},{"$f":"+IF(BY3=\"\",\"\",IF(BY20<=0,0,BY20/#REF!))","v":""},{"$f":"+IF(BZ3=\"\",\"\",IF(BZ20<=0,0,BZ20/#REF!))","v":""},{"$f":"+IF(CA3=\"\",\"\",IF(CA20<=0,0,CA20/#REF!))","v":""},{"$f":"+IF(CB3=\"\",\"\",IF(CB20<=0,0,CB20/#REF!))","v":""},{"$f":"+IF(CC3=\"\",\"\",IF(CC20<=0,0,CC20/#REF!))","v":""},{"$f":"+IF(CD3=\"\",\"\",IF(CD20<=0,0,CD20/#REF!))","v":""},{"$f":"+IF(CE3=\"\",\"\",IF(CE20<=0,0,CE20/#REF!))","v":""},{"$f":"+IF(CF3=\"\",\"\",IF(CF20<=0,0,CF20/#REF!))","v":""},{"$f":"+IF(CG3=\"\",\"\",IF(CG20<=0,0,CG20/#REF!))","v":""},{"$f":"+IF(CH3=\"\",\"\",IF(CH20<=0,0,CH20/#REF!))","v":""},{"$f":"+IF(CI3=\"\",\"\",IF(CI20<=0,0,CI20/#REF!))","v":""},{"$f":"+IF(CJ3=\"\",\"\",IF(CJ20<=0,0,CJ20/#REF!))","v":""},{"$f":"+IF(CK3=\"\",\"\",IF(CK20<=0,0,CK20/#REF!))","v":""},{"$f":"+IF(CL3=\"\",\"\",IF(CL20<=0,0,CL20/#REF!))","v":""},{"$f":"+IF(CM3=\"\",\"\",IF(CM20<=0,0,CM20/#REF!))","v":""},{"$f":"+IF(CN3=\"\",\"\",IF(CN20<=0,0,CN20/#REF!))","v":""},{"$f":"+IF(CO3=\"\",\"\",IF(CO20<=0,0,CO20/#REF!))","v":""},{"$f":"+IF(CP3=\"\",\"\",IF(CP20<=0,0,CP20/#REF!))","v":""},{"$f":"+IF(CQ3=\"\",\"\",IF(CQ20<=0,0,CQ20/#REF!))","v":""},{"$f":"+IF(CR3=\"\",\"\",IF(CR20<=0,0,CR20/#REF!))","v":""},{"$f":"+IF(CS3=\"\",\"\",IF(CS20<=0,0,CS20/#REF!))","v":""},{"$f":"+IF(CT3=\"\",\"\",IF(CT20<=0,0,CT20/#REF!))","v":""},{"$f":"+IF(CU3=\"\",\"\",IF(CU20<=0,0,CU20/#REF!))","v":""},{"$f":"+IF(CV3=\"\",\"\",IF(CV20<=0,0,CV20/#REF!))","v":""},{"$f":"+IF(CW3=\"\",\"\",IF(CW20<=0,0,CW20/#REF!))","v":""},{"$f":"+IF(CX3=\"\",\"\",IF(CX20<=0,0,CX20/#REF!))","v":""},{"$f":"+IF(CY3=\"\",\"\",IF(CY20<=0,0,CY20/#REF!))","v":""},{"$f":"+IF(CZ3=\"\",\"\",IF(CZ20<=0,0,CZ20/#REF!))","v":""},{"$f":"+IF(DA3=\"\",\"\",IF(DA20<=0,0,DA20/#REF!))","v":""},{"$f":"+IF(DB3=\"\",\"\",IF(DB20<=0,0,DB20/#REF!))","v":""},{"$f":"+IF(DC3=\"\",\"\",IF(DC20<=0,0,DC20/#REF!))","v":""},{"$f":"+IF(DD3=\"\",\"\",IF(DD20<=0,0,DD20/#REF!))","v":""},{"$f":"+IF(DE3=\"\",\"\",IF(DE20<=0,0,DE20/#REF!))","v":""},{"$f":"+IF(DF3=\"\",\"\",IF(DF20<=0,0,DF20/#REF!))","v":""},{"$f":"+IF(DG3=\"\",\"\",IF(DG20<=0,0,DG20/#REF!))","v":""},{"$f":"+IF(DH3=\"\",\"\",IF(DH20<=0,0,DH20/#REF!))","v":""},{"$f":"+IF(DI3=\"\",\"\",IF(DI20<=0,0,DI20/#REF!))","v":""},{"$f":"+IF(DJ3=\"\",\"\",IF(DJ20<=0,0,DJ20/#REF!))","v":""},{"$f":"+IF(DK3=\"\",\"\",IF(DK20<=0,0,DK20/#REF!))","v":""},{"$f":"+IF(DL3=\"\",\"\",IF(DL20<=0,0,DL20/#REF!))","v":""},{"$f":"+IF(DM3=\"\",\"\",IF(DM20<=0,0,DM20/#REF!))","v":""},{"$f":"+IF(DN3=\"\",\"\",IF(DN20<=0,0,DN20/#REF!))","v":""},{"$f":"+IF(DO3=\"\",\"\",IF(DO20<=0,0,DO20/#REF!))","v":""},{"$f":"+IF(DP3=\"\",\"\",IF(DP20<=0,0,DP20/#REF!))","v":""},{"$f":"+IF(DQ3=\"\",\"\",IF(DQ20<=0,0,DQ20/#REF!))","v":""},{"$f":"+IF(DR3=\"\",\"\",IF(DR20<=0,0,DR20/#REF!))","v":""}]
[null,"Margen Neto",{"$f":"+IF(C3=\"\",\"\",IF('P&G'!C19<0,0,IF('P&G'!C5<=0,0,'P&G'!C19/'P&G'!C5)))","v":0},{"$f":"+IF(D3=\"\",\"\",IF('P&G'!D19<0,0,IF('P&G'!D5<=0,0,'P&G'!D19/'P&G'!D5)))","v":0.31857611791524759},{"$f":"+IF(E3=\"\",\"\",IF('P&G'!E19<0,0,IF('P&G'!E5<=0,0,'P&G'!E19/'P&G'!E5)))","v":0},{"$f":"+IF(F3=\"\",\"\",IF('P&G'!F19<0,0,IF('P&G'!F5<=0,0,'P&G'!F19/'P&G'!F5)))","v":0},{"$f":"+IF(G3=\"\",\"\",IF('P&G'!G19<0,0,IF('P&G'!G5<=0,0,'P&G'!G19/'P&G'!G5)))","v":0.56132633149716948},{"$f":"+IF(H3=\"\",\"\",IF('P&G'!H19<0,0,IF('P&G'!H5<=0,0,'P&G'!H19/'P&G'!H5)))","v":""},{"$f":"+IF(I3=\"\",\"\",IF('P&G'!I19<0,0,IF('P&G'!I5<=0,0,'P&G'!I19/'P&G'!I5)))","v":""},{"$f":"+IF(J3=\"\",\"\",IF('P&G'!J19<0,0,IF('P&G'!J5<=0,0,'P&G'!J19/'P&G'!J5)))","v":""},{"$f":"+IF(K3=\"\",\"\",IF('P&G'!K19<0,0,IF('P&G'!K5<=0,0,'P&G'!K19/'P&G'!K5)))","v":""},{"$f":"+IF(L3=\"\",\"\",IF('P&G'!L19<0,0,IF('P&G'!L5<=0,0,'P&G'!L19/'P&G'!L5)))","v":""},{"$f":"+IF(M3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(N3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(O3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(P3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(Q3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(R3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(S3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(T3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(U3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(V3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(W3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(X3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(Y3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(Z3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AA3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AB3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AC3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AD3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AE3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AF3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AG3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AH3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AI3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AJ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AK3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AL3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AM3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AN3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AO3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AP3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AQ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AR3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AS3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AT3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AU3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AV3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AW3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AX3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AY3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(AZ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BA3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BB3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BC3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BD3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BE3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BF3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BG3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BH3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BI3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BJ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BK3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BL3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BM3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BN3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BO3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BP3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BQ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BR3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BS3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BT3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BU3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BV3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BW3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BX3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BY3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(BZ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CA3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CB3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CC3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CD3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CE3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CF3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CG3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CH3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CI3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CJ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CK3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CL3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CM3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CN3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CO3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CP3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CQ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CR3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CS3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CT3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CU3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CV3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CW3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CX3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CY3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(CZ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DA3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DB3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DC3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DD3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DE3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DF3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DG3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DH3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DI3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DJ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DK3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DL3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DM3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DN3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DO3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DP3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DQ3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""},{"$f":"+IF(DR3=\"\",\"\",IF(#REF!<0,0,#REF!/#REF!))","v":""}]
[null,"Margen Operativo",{"$f":"+IF(C3=\"\",\"\",IF('P&G'!C13<0,0,'P&G'!C13/'P&G'!C5))","v":0},{"$f":"+IF(D3=\"\",\"\",IF('P&G'!D13<0,0,'P&G'!D13/'P&G'!D5))","v":0.48517158855711584},{"$f":"+IF(E3=\"\",\"\",IF('P&G'!E13<0,0,'P&G'!E13/'P&G'!E5))","v":0},{"$f":"+IF(F3=\"\",\"\",IF('P&G'!F13<0,0,'P&G'!F13/'P&G'!F5))","v":0},{"$f":"+IF(G3=\"\",\"\",IF('P&G'!G13<0,0,'P&G'!G13/'P&G'!G5))","v":0.88683577977114048},{"$f":"+IF(H3=\"\",\"\",IF('P&G'!H13<0,0,'P&G'!H13/'P&G'!H5))","v":""},{"$f":"+IF(I3=\"\",\"\",IF('P&G'!I13<0,0,'P&G'!I13/'P&G'!I5))","v":""},{"$f":"+IF(J3=\"\",\"\",IF('P&G'!J13<0,0,'P&G'!J13/'P&G'!J5))","v":""},{"$f":"+IF(K3=\"\",\"\",IF('P&G'!K13<0,0,'P&G'!K13/'P&G'!K5))","v":""},{"$f":"+IF(L3=\"\",\"\",IF('P&G'!L13<0,0,'P&G'!L13/'P&G'!L5))","v":""}]
[null,"ROA (E.A)",{"$f":"+IF(C3=\"\",\"\",IF('P&G'!C19<0,0,'P&G'!C19/BALANCE!C23))","v":0},{"$f":"+IF(D3=\"\",\"\",IF('P&G'!D19<0,0,'P&G'!D19/BALANCE!D23))","v":8.973548597983623E-2},{"$f":"+IF(E3=\"\",\"\",IF('P&G'!E19<0,0,'P&G'!E19/BALANCE!E23))","v":0},{"$f":"+IF(F3=\"\",\"\",IF('P&G'!F19<0,0,'P&G'!F19/BALANCE!F23))","v":0},{"$f":"+IF(G3=\"\",\"\",IF('P&G'!G19<0,0,'P&G'!G19/BALANCE!G23))","v":0.76745095339486558},{"$f":"+IF(H3=\"\",\"\",IF('P&G'!H19<0,0,'P&G'!H19/BALANCE!H23))","v":""},{"$f":"+IF(I3=\"\",\"\",IF('P&G'!I19<0,0,'P&G'!I19/BALANCE!I23))","v":""},{"$f":"+IF(J3=\"\",\"\",IF('P&G'!J19<0,0,'P&G'!J19/BALANCE!J23))","v":""},{"$f":"+IF(K3=\"\",\"\",IF('P&G'!K19<0,0,'P&G'!K19/BALANCE!K23))","v":""},{"$f":"+IF(L3=\"\",\"\",IF('P&G'!L19<0,0,'P&G'!L19/BALANCE!L23))","v":""}]
[null,"ROE (E.A)",{"$f":"+IF(C3=\"\",\"\",IF('P&G'!C19<0,0,'P&G'!C19/BALANCE!C51))","v":0},{"$f":"+IF(D3=\"\",\"\",IF('P&G'!D19<0,0,'P&G'!D19/BALANCE!D51))","v":9.8089186744263146E-2},{"$f":"+IF(E3=\"\",\"\",IF('P&G'!E19<0,0,'P&G'!E19/BALANCE!E51))","v":0},{"$f":"+IF(F3=\"\",\"\",IF('P&G'!F19<0,0,'P&G'!F19/BALANCE!F51))","v":0},{"$f":"+IF(G3=\"\",\"\",IF('P&G'!G19<0,0,'P&G'!G19/BALANCE!G51))","v":0.88923908655309736},{"$f":"+IF(H3=\"\",\"\",IF('P&G'!H19<0,0,'P&G'!H19/BALANCE!H51))","v":""},{"$f":"+IF(I3=\"\",\"\",IF('P&G'!I19<0,0,'P&G'!I19/BALANCE!I51))","v":""},{"$f":"+IF(J3=\"\",\"\",IF('P&G'!J19<0,0,'P&G'!J19/BALANCE!J51))","v":""},{"$f":"+IF(K3=\"\",\"\",IF('P&G'!K19<0,0,'P&G'!K19/BALANCE!K51))","v":""},{"$f":"+IF(L3=\"\",\"\",IF('P&G'!L19<0,0,'P&G'!L19/BALANCE!L51))","v":""}]
[null,"ROIC (E.A)",{"$f":"+IF(C3=\"\",\"\",IF('FLUJO DE CAJA'!C4<0,0,'FLUJO DE CAJA'!C4/(BALANCE!C51+BALANCE!C35+BALANCE!C27)))","v":0},{"$f":"+IF(D3=\"\",\"\",IF('FLUJO DE CAJA'!D4<0,0,'FLUJO DE CAJA'!D4/(BALANCE!D51+BALANCE!D35+BALANCE!D27)))","v":9.1216708809028185E-2},{"$f":"+IF(E3=\"\",\"\",IF('FLUJO DE CAJA'!E4<0,0,'FLUJO DE CAJA'!E4/(BALANCE!E51+BALANCE!E35+BALANCE!E27)))","v":0},{"$f":"+IF(F3=\"\",\"\",IF('FLUJO DE CAJA'!F4<0,0,'FLUJO DE CAJA'!F4/(BALANCE!F51+BALANCE!F35+BALANCE!F27)))","v":0},{"$f":"+IF(G3=\"\",\"\",IF('FLUJO DE CAJA'!G4<0,0,'FLUJO DE CAJA'!G4/(BALANCE!G51+BALANCE!G35+BALANCE!G27)))","v":0.91318694030421599},{"$f":"+IF(H3=\"\",\"\",IF('FLUJO DE CAJA'!H4<0,0,'FLUJO DE CAJA'!H4/(BALANCE!H51+BALANCE!H35+BALANCE!H27)))","v":""},{"$f":"+IF(I3=\"\",\"\",IF('FLUJO DE CAJA'!I4<0,0,'FLUJO DE CAJA'!I4/(BALANCE!I51+BALANCE!I35+BALANCE!I27)))","v":""},{"$f":"+IF(J3=\"\",\"\",IF('FLUJO DE CAJA'!J4<0,0,'FLUJO DE CAJA'!J4/(BALANCE!J51+BALANCE!J35+BALANCE!J27)))","v":""},{"$f":"+IF(K3=\"\",\"\",IF('FLUJO DE CAJA'!K4<0,0,'FLUJO DE CAJA'!K4/(BALANCE!K51+BALANCE!K35+BALANCE!K27)))","v":""},{"$f":"+IF(L3=\"\",\"\",IF('FLUJO DE CAJA'!L4<0,0,'FLUJO DE CAJA'!L4/(BALANCE!L51+BALANCE!L35+BALANCE!L27)))","v":""}]
[null,"TIR (E.A)",{"$f":"+IF(C$3=\"\",\"\",IRR(_xlfn._xlws.FILTER($C$21:$L$21,$C$21:$L$21<>\"\")))","v":0.36546111059821174},null,null,null,null,{"$f":"+IF(H$3=\"\",\"\",IRR(_xlfn._xlws.FILTER($C$21:$L$21,$C$21:$L$21<>\"\")))","v":""},{"$f":"+IF(I$3=\"\",\"\",IRR(_xlfn._xlws.FILTER($C$21:$L$21,$C$21:$L$21<>\"\")))","v":""},{"$f":"+IF(J$3=\"\",\"\",IRR(_xlfn._xlws.FILTER($C$21:$L$21,$C$21:$L$21<>\"\")))","v":""},{"$f":"+IF(K$3=\"\",\"\",IRR(_xlfn._xlws.FILTER($C$21:$L$21,$C$21:$L$21<>\"\")))","v":""},{"$f":"+IF(L$3=\"\",\"\",IRR(_xlfn._xlws.FILTER($C$21:$L$21,$C$21:$L$21<>\"\")))","v":""}]
[null,"VPN",{"$f":"NPV(DATOS!$C$17,_xlfn._xlws.FILTER(C21:L21,C21:L21<>\"\"))","v":255968355.80174157}]

{"sheet":"DASHBOARD","index":6,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,1,5,3],[4,5,4,7],[5,5,5,7],[4,9,4,11],[5,9,5,11],[7,1,7,3],[8,1,8,3],[7,5,7,7],[8,5,8,7],[7,9,7,11],[8,9,8,11]]}
[null,"DASHBOARD"]
[null,"DASHBOARD"]
[]
[null,"INDICADORES CLAVE"]
[null,"TIR (E.A)",null,null,null,"VPN",null,null,null,{"$f":"\"EBITDA (AÑO \"&DATOS!C3&\")\"","v":"EBITDA (AÑO 5)"}]
[null,{"$f":"+'KPI''S'!C28","v":0.36546111059821174},null,null,null,{"$f":"+'KPI''S'!C29","v":255968355.80174157},null,null,null,{"$f":"INDEX('KPI''S'!20:20,2+DATOS!C3)","v":2387572067.6318655}]
[]
[null,"MARGEN EBITDA",null,null,null,"MARGEN NETO",null,null,null,"ROE (E.A)"]
[null,{"$f":"INDEX('KPI''S'!22:22,2+DATOS!C3)","v":0.88807005517402771},null,null,null,{"$f":"INDEX('KPI''S'!23:23,2+DATOS!C3)","v":0.56132633149716948},null,null,null,{"$f":"INDEX('KPI''S'!26:26,2+DATOS!C3)","v":0.88923908655309736}]