{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Inicio","Principales magnitudes","Elecnor","Enerfín","Celeo","Cuenta de resultados","Cuenta de resultados segmentada","Balance","Balance segmentado","EFE","Estructura accionarial","Grupo Elecnor en Bolsa","Proyectos Enerfín 2022","Proyectos Enerfín 2021","Proyectos Celeo 2022","Proyectos Celeo 2021","Deuda financiera neta total","Vencimientos deuda","Tipos de cambio"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":73,"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":"Inicio","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[null,null,null,"Resultados 2022"]
[null,"Cuadros de información \neconómico-financiera"]
[]
[null,"Índice"]
[]
[null,1,"Principales magnitudes",null,10,"Estructura accionarial"]
[null,2,"Elecnor",null,11,"Grupo Elecnor en Bolsa"]
[null,3,"Enerfín",null,12,"Proyectos Enerfín a cierre de 2022"]
[null,4,"Celeo",null,13,"Proyectos Enerfín a cierre de 2021"]
[null,5,"Cuenta de resultados consolidada",null,14,"Proyectos Celeo a cierre de 2022"]
[null,6,"Detalle de cuenta de resultados por segmentos a 31.12.2022",null,15,"Proyectos Celeo a cierre de 2021"]
[null,7,"Balance consolidado",null,16,"Cálculo de la deuda financiera neta total"]
[null,8,"Balance por segmentos a 31.12.2022",null,17,"Perfil de vencimientos de deuda bruta dispuesta con recurso a 31.12.2022"]
[null,9,"Estado de Flujos de Efectivo",null,18,"Tipo de cambio respecto al Euro"]

{"sheet":"Principales magnitudes","index":1,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[[52,2,52,3],[39,2,39,3],[26,2,26,3],[1,2,1,3],[13,2,13,3],[24,1,24,4]]}
["< INICIO"]
[null,null,"Miles de euros"]
[]
[]
[null,"Principales magnitudes",2022,2021,"% Var."]
[null,"Cifra de negocio",3613672,3122421,15.733016143562958]
[null,"Ventas nacionales",1491563,1422918,4.8242414531266036]
[null,"Ventas internacionales",2122109,1699503,24.866446249285818]
[null,"EBITDA",302052,271769,11.142919170324799]
[null,"Resultado antes de impuestos",165931,142048,16.813330705113763]
[null,"Resultado neto atribuible",102813,85884,19.711471286852035]
[]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Cifra de negocio por segmentos",2022,2021,"% Var.",null,null,null,null,null," "]
[null,"Elecnor",3422866,2958160,15.709292262757932]
[null,"Enerfín",220412,166593,32.305679110166693]
[null,"Celeo",306575,278267,{"$f":"(C20-D20)/D20*100","v":10.172963376900602}]
[null,"Operaciones entre segmentos",-29606,-2332,"n.s."]
[null,"Eliminación por consolidación por el Método de Puesta en Equivalencia1",-306575,-278267,{"$f":"(C22-D22)/D22*100","v":10.172963376900602}]
[null,"Total cifra de negocio del Grupo",3613672,3122421,15.733016143562958]
[]
[null,"¹ La Cifra de negocio del subgrupo Celeo en el periodo no forma parte de la Cifra de negocio del Grupo, dado que se consolida por el Método de la Participación."]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"EBITDA consolidado por sociedades",2022,2021,"% Var."]
[null,"Elecnor",168928,165838,1.8632641493505711]
[null,"Enerfín",154490,116303,32.834062749886073]
[null,"Celeo",17153,14998,14.368582477663688]
[null,"Subtotal negocios",340571,297139,14.616728197914108]
[null,"Gestión del Grupo y otros ajustes",-29569,-25109,"n.s."]
[null,"Operaciones entre segmentos",-8950,-261,"n.s."]
[null,"Total",302052,271769,11.142919170324799]
[]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Resultado neto consolidado atribuible por sociedades",2022,2021,"% Var."]
[null,"Elecnor",77459,77119,0.44087708606180059]
[null,"Enerfín ",44124,23336,89.081247857387723]
[null,"Celeo",17153,14998,14.368582477663688]
[null,"Resultado neto consolidado de los negocios",138736,115453,20.16664790001126]
[null,"Gestión del Grupo y otros ajustes",-30622,-29990,"n.s."]
[null,"Operaciones entre segmentos",-5301,421,"n.s."]
[null,"Total",102813,85884,19.711471286852035]
[]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Cartera de Elecnor pendiente de ejecutar","31/12/2022","31/12/2021","% Var."]
[null,"Nacional",633939,579656,9.3646921622479535]
[null,"Internacional",1774464,1711829,3.6589519163421111]
[null,"Total",2408403,2291485,5.1022808353534934]

{"sheet":"Elecnor","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,2,1,3],[10,1,10,4],[11,2,11,3]]}
["< INICIO"]
[null,null,"Miles de euros"]
[]
[]
[null,"Elecnor (Servicios y Proyectos)",2022,2021,"% Var."]
[null,"Cifra de negocio",3422866,2958160,15.709292262757932]
[null,"EBITDA",168928,165838,1.8632641493505711]
[null,"Margen sobre ventas (%)",4.9352793828329826,5.606120020553317,"n.s."]
[null,"Resultado antes de impuestos",105913,114957,-7.867289508250912]
[null,"Resultado neto atribuible",77459,77119,0.44087708606180059]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Ventas nacionales vs internacionales",2022,2021,"% Var."]
[null,"Cifra de negocio",3422866,2958160,15.709292262757932]
[null,"Ventas nacionales",1422090,1371256,3.7071123116325468]
[null,"Ventas internacionales",2000776,1586904,26.080468635783895]

{"sheet":"Enerfín","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,3],[12,2,12,3]]}
["< INICIO"]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Enerfín",2022,2021,"% Var."]
[null,"Cifra de negocio",220412,166593,32.305679110166693]
[null,"EBITDA",154490,116303,32.834062749886073]
[null,"Resultado antes de impuestos",84934,44076,92.69897449859333]
[null,"Resultado neto atribuible",44124,23335,89.089350760659954]
[]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Ventas nacionales vs internacionales",2022,2021,"% Var."]
[null,"Cifra de negocio",220412,166593,32.305679110166693]
[null,"Ventas nacionales",87912,51869,69.488519154022626]
[null,"Ventas internacionales",132500,114724,15.494578292249225]

{"sheet":"Celeo","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,3],[10,1,10,4],[11,1,12,4]]}
["< INICIO"]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Celeo (subgrupo al 100%)",2022,2021,"% Var."]
[null,"Cifra de negocio",306575,278267,10.172963376900602]
[null,"EBITDA",241783,191790,26.066531101725847]
[null,"Resultado antes de impuestos",104070,59916,73.693170438614061]
[null,"Resultado neto atribuible",33806,29950,12.874791318864776]
[null,0]

{"sheet":"Cuenta de resultados","index":5,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["< INICIO"]
[null,null,"Miles de euros"]
[]
[]
[null,"Cuenta de resultados consolidada",2022,2021,"% Var."]
[null,"Importe neto de la cifra de negocios ",3613672,3122421,15.733016143562958]
[null,"Variación de existencias de productos terminados y en curso de fabricación",374,220,70]
[null,"Trabajos realizados por la empresa para su activo ",32891,10768,205.45133729569093]
[null,"Aprovisionamientos ",-1810781,-1582619,14.416735803121281]
[null,"Otros ingresos de explotación ",44109,23918,84.417593444267908]
[null,"Gastos de personal ",-984095,-868281,13.338308681175794]
[null,"Resultado neto en la enajenación de activos no corrientes y sociedades dependientes",14688,-4138,"c.s."]
[null,"Resultado de entidades integrantes de la actividad ordinaria por el método de participación  ",22498,22752,-1.1163853727144866]
[null,"Resultado bruto de explotación (EBITDA)",302052,271769,11.142919170324799]
[null,"Gastos por amortización, deterioro y dotación a provisiones ",-89310,-93086,-4.0564639150892718]
[null,"Resultado de explotación (EBIT)",212742,178683,19.061130605597622]
[null,"Ingresos financieros ",10573,8860,19.334085778781038]
[null,"Gastos financieros ",-55405,-50290,10.171008152714258]
[null,"Diferencias de cambio",-1979,5368,"c.s."]
[null,"Deterioro y resultado por enajenación de instrumentos financieros","-",-680,0]
[null,"Variación de valor razonable en instrumentos financieros ",null,107,0]
[null,"Resultado antes de impuestos",165931,142048,16.813330705113763]
[null,"Impuestos sobre las ganancias ",-50024,-48443,3.263629420143261]
[null,"Resultado neto ",115907,93605,23.825650339191281]
[null,"Resultado neto atribuido a intereses minoritarios ",13094,7722,69.567469567469558]
[null,"Resultado neto total atribuido a la sociedad dominante ",102813,85883,19.712865177043188]

{"sheet":"Cuenta de resultados segmentada","index":6,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,2,2,7]]}
["< INICIO"]
[]
[null,null,"Miles de euros"]
[]
[]
[null,"Detalle de la cuenta de resultados por segmentos a 31/12/2022","Elecnor","Enerfin","Celeo","Gestión de Grupo\ny Otros Ajustes","Intersegmentos","Total al 31/12/2022"]
[null,"Importe neto de la cifra de negocios",3422866,220412,"-","-",-29606,3613672]
[null,"Resultado bruto de explotación (EBITDA)",168928,154490,17153,-29569,-8950,302052]
[null,"Resultado de explotación (EBIT)",118812,115839,17153,-30955,-8107,212742]
[null,"Ingresos financieros",4935,5638,"-","-","-",10573]
[null,"Gastos financieros",-14204,-36142,"-",-5059,"-",-55405]
[null,"Resultado antes de impuestos",105914,84935,17153,-35960,-6111,165931]
[null,"Impuesto sobre las ganancias",-28458,-27712,"-",5338,808,-50024]
[null,"Resultado neto ",77456,57223,17153,-30622,-5303,115907]
[null,"Resultado neto atribuido a intereses minoritarios ",4,-13098,"-","-","-",-13094]
[null,"Resultado neto total atribuido a la sociedad dominante ",77460,44125,17153,-30622,-5303,102813]

{"sheet":"Balance","index":7,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["< INICIO"]
[null," ","Miles de euros"]
[]
[]
[null,"Balance consolidado","31/12/2022","31/12/2021","% Var."]
[null,"Activo no corriente",1781885,1554195,14.650027827910911]
[null,"Inmovilizado intangible (Fondo de Comercio y otros)",44071,43857,0.48794947214811774]
[null,"Activos por derechos de uso",80327,77521,3.6196643490151059]
[null,"Inmovilizado material ",901088,784666,14.837140898165588]
[null,"Inversiones contabilizadas aplicando el método de la participación",628150,517203,21.451345023134049]
[null,"Activos por impuestos diferidos ",80331,89413,-10.157359668057216]
[null,"Otros deudores",24571,22863,7.4705856624240035]
[null,"Activo corriente",1776030,1731706,2.5595568762826946]
[null,"Existencias",10308,11282,-8.6332210600957282]
[null,"Activos por contratos con clientes",393954,399621,-1.4180936437274316]
[null,"Deudores comerciales y otras cuentas a cobrar",855689,767035,11.558012346242348]
[null,"Deudores comerciales, empresas vinculadas y AAPP",85327,76216,11.95418284874567]
[null,"Otros deudores",24571,22863,7.4705856624240035]
[null,"Inversiones financieras a corto plazo",16742,17991,-6.9423600689233504]
[null,"Efectivo y otros activos líquidos equivalentes",372525,388105,-4.0143775524664713]
[null,"Activos no corrientes mantenidos para la venta",2976,37288,-92.018880068654795]
[null,"Otros Activos Corrientes",13938,11305,23.290579389650599]
[null,"Pasivo no corriente",955384,951945,0.36126036693296359]
[null,"Total activo",3557915,3285901,8.2782165378689125]
[null,"Provisiones a largo plazo",53993,54105,-0.20700489788374457]
[null,"Patrimonio neto total",833255,633665,31.497715669951788]
[null,"Pasivos por arrendamiento",69065,66795,3.3984579684108089]
[null,"Pasivo no corriente",955384,951945,0.36126036693296359]
[null,"Subvenciones oficiales",4642,4920,-5.6504065040650406]
[null,"Provisiones a largo plazo",53993,54105,-0.20700489788374457]
[null,"Deuda financiera a largo plazo",794823,778536,2.0920034526341746]
[null,"Pasivos por arrendamiento",69065,66795,3.3984579684108089]
[null,"Otros pasivos no corrientes ",5348,20060,-73.339980059820547]
[null,"Pasivos por impuestos diferidos",27513,27529,-5.8120527443786554E-2]
[null,"Acreedores comerciales y otras cuentas a pagar",935749,754947,23.9489659539014]
[null,"Pasivo corriente",276032,411529,-32.92526164620233]
[null,"Provisiones a corto plazo",80807,82103,-1.5785050485365943]
[null,"Deuda financiera a corto plazo",215363,246915,-12.77848652370249]
[null,"Acreedores comerciales y otras cuentas a pagar",935749,754947,23.9489659539014]
[null,"Pasivos por contratos con clientes",276032,411529,-32.92526164620233]
[null,"Pasivos por impuestos y otras deudas",242389,185935,30.36222335762498]
[null,"Pasivos por arrendamiento",18929,18857,0.3818210744020788]
[null,"Acreedores comerciales, empresas asociadas y vinculadas",7,5,40]
[null,"Total pasivo",3557915,3285901,8.2782165378689125]

{"sheet":"Balance segmentado","index":8,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
["< INICIO"]
[null,null,"Miles de euros"]
[]
[]
[null,"Balance por segmentos a 31/12/2022","Elecnor","Enerfin","Celeo","Gestión de Grupo\ny otros ajustes","Intersegmentos","Total al 31/12/2022"]
[null,"Activo",218491,687885,"-",10566,-15854]
[null,"Activos Intangibles",22662,12832,"-",8577,"-",44071]
[null,"Activos por derecho de uso",50830,27960,"-",1537,"-",80327]
[null,"Inmovilizado Material",218491,687885,"-",10566,-15854,901088]
[null,"Inversiones contabilizadas por el método de la participación",39660,2330,586160,"-","-",628150]
[null,"Activos financieros no corrientes",15430,26350,1,6137,"-",47918]
[null,"Existencias",10308,"-","-","-","-",10308]
[null,"Activos por contratos con clientes",393954,"-","-","-","-",393954,null," "]
[null,"Deudores y Administraciones públicas",927782,26518,"-",13443,-2156,965587]
[null,"Activos no corrientes mantenidos para la venta",2976,"-","-","-","-",2976]
[null,"Resto de activos",335880,60195,"-",7130,"-",403205]
[null,"Total activo",2066900,858716,586925,59880,-14506,3557915]
[null,"Provisiones para riesgos y gastos"]
[null,"Pasivo",2974,1668,"-","-","-"]
[null,"Pasivos financieros no corrientes",70228,414579,"-",310016,"-",794823]
[null,"Provisiones para riesgos y gastos",38513,11442,3056,982,"-",53993]
[null,"Subvenciones oficiales",2974,1668,"-","-","-",4642]
[null,"Pasivos por arrendamiento no corriente",38096,29893,"-",1076,"-",69065]
[null,"Otros Pasivos no corrientes",3202,2146,"-","-","-",5348]
[null,"Impuestos diferidos pasivos",7788,20315,"-",2470,-3060,27513]
[null,"Provisiones corto plazo",78639,2041,"-",127,"-",80807]
[null,"Deuda Financiera corriente",18530,80519,"-",116314,"-",215363]
[null,"Pasivos por arrendamiento corriente",14996,3152,"-",781,"-",18929]
[null,"Deudas no Financieras corrientes",1366353,46296,"-",48736,-7208,1454177]
[null,"Total pasivo",1639319,612051,3056,480502,-10268,2724660]
[]
[null,0]

{"sheet":"EFE","index":9,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["< INICIO"]
[null,null,"Miles de euros"]
[]
[]
[null,"Flujos de efectivo de las actividades de explotación",2022,2021,"% Var."]
[null,"  Resultado consolidado del ejercicio",115907,93605,23.825650339191281]
[null,"     Amortizaciones ",111643,89213,25.142075706455337]
[null,"     Deterioro y Resultado neto por enajenación de inmovilizado material y otros activos intangibles",-4776,2770,"c.s."]
[null,"     Variación de provisiones para riesgos y gastos y otras provisiones",-21307,5214,"c.s."]
[null,"     Imputación de subvenciones de inmovilizado",-220,-270,-18.518518518518519]
[null,"     Participación en (beneficios) / pérdidas del ejercicio de inversiones contabilizadas por el método de la participación      ",-22498,-22752,-1.1163853727144866]
[null,"     Ingresos y gastos financieros ",44833,41430,8.2138546946657005]
[null,"     Diferencias de cambio",1979,-5368,"c.s."]
[null,"     Otros ingresos y gastos",3698,4825,-23.357512953367877]
[null,"     Impuesto sobre sociedades",50024,48443,3.263629420143261]
[null,"Total flujo de operaciones",268638,257790,4.2080763412079598]
[null,"Variación de capital circulante:",-41764,-51600,-19.062015503875969]
[null,"    Deudores comerciales y otras cuentas a cobrar",-63990,-76190,-16.012600078750491]
[null,"    Existencias",975,-4914,"c.s."]
[null,"    Acreedores comerciales y otras cuentas a pagar",43809,82507,-46.9026870447356]
[null,"    Variación en otros activos y pasivos corrientes",14762,-14471,"c.s."]
[null,"    Impuesto sobre las ganancias pagados",-37320,-38532,-3.1454375583930236]
[null,"Flujos netos de efectivo de actividades de explotación (I)",226874,206190,10.031524322227073]
[]
[null,"Flujos de efectivo por actividades de inversión",2022,2021,"% Var."]
[null,"  Pagos por la adquisición de empresas del grupo, asociadas y entidades controladas conjuntamente","-",-3520,"n.s."]
[null,"  Pagos por la adquisición de activos intangibles",-6665,-8197,-18.689764548005368]
[null,"  Pagos por la adquisición de activos financieros",-6344,-5655,12.183908045977011]
[null,"  Pagos por la adquisición de inmovilizado material",-149248,-99519,49.969352585938367]
[null,"  Pagos por aportaciones a empresas asociadas",-520,-13405,-96.120850428944422]
[null,"  Cobro de dividendos de empresas asociadas",728,644,13.043478260869565]
[null,"  Cobro de intereses",10572,8860,19.322799097065463]
[null,"  Cobros por enajenación de empresas del grupo, asociadas y entidades controladas conjuntamente",9102,6970,30.588235294117649]
[null,"  Cobros procedentes de la venta de activos intangibles e inmovilizado material ",6200,10024,-38.148443735035912]
[null,"  Cobros procedentes de activos financieros, neto",7627,3836,98.82690302398332]
[null,"Flujos netos de efectivo de las actividades de inversión (II)",-128548,-99962,28.596866809387567]
[]
[null,"Flujos de efectivo por actividades de financiación",2022,2021,"% Var."]
[null,"  Entradas de efectivo por deuda financiera y otra deuda a largo plazo",1236575,1503309,-17.743125332183869]
[null,"  Intereses pagados",-49247,-38575,27.665586519766688]
[null,"  Reembolso de deuda financiera y otra deuda a largo plazo",-1238759,-1520734,-18.542032991963094]
[null,"  Pagos procedentes de pasivos por arrendamiento",-18472,-16516,11.843061273916202]
[null,"  Dividendos pagados",-41175,-34668,18.769470404984425]
[null,"  Cobros/Pagos netos derivados de aportaciones/devoluciones de fondos por/a socios no dominante",-2816,-2580,9.1472868217054266]
[null,"  Entradas de efectivo por enajenación de acciones propias",2479,2435,1.8069815195071868]
[null,"  Salidas de efectivo por compra de acciones propias",-2491,-2422,2.8488852188274154]
[null,"Flujos netos de efectivo de las actividades de financiación (III)",-113906,-109751,3.7858424980182415]
[]
[null,"Incremento neto de efectivo y equivalentes al efectivo (I+II+III+IV)",-15580,-3523,342.23673005960831]
[null,"Efectivo y equivalentes al efectivo al principio del período",388105,391628,-0.89957817112157457]
[null,"Efectivo y equivalentes al efectivo al final del período",372525,388105,-4.0143775524664713]

{"sheet":"Estructura accionarial","index":10,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["< INICIO"]
[]
[]
[]
[]
[null,"Estructura accionarial","31/12/2022"]
[null,"Cantiles XXI, S.L.",0.52759999999999996]
[null,"Francisco Paramés",3.0099999999999998E-2]
[null,"Autocartera",2.6700000000000002E-2]
[null,"Consejo de Administración",2.9600000000000001E-2]
[null,"Otros",0.38]
[null,null,0]
[null,"¹ Testing estructura accionarial"]

{"sheet":"Grupo Elecnor en Bolsa","index":11,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["< INICIO"]
[null,"Grupo Elecnor en Bolsa"]
[null,"Cotización",2022,2021]
[null,"Inicio",10.5,11]
[null,"Mínimo",9.5399999999999991,9.42]
[null,"Máximo",13.4,11.3]
[null,"Cierre periodo",10.6,10.5]
[null,"Media",10.895787937743188,10.363951562500006]
[]
[null,"Otros Indicadores Bursátiles",2022,2021]
[null,"Capitalización bursátil (euros)",922200000,913500000]
[null,"Nº de acciones",87000000,87000000]
[null,"Valor nominal de la acción (euros/acción)",0.1,0.1]
[null,"Volumen acumulado (acciones)",6081521,5580690]
[null,"Volumen medio diario (acciones)",23663.505836575874,21799.5703125]
[null,"Volumen efectivo acumulado (euros)",66588571.370000027,57956022.090000011]
[null,"Volumen efectivo medio diario (euros)",259099.49949416352,226390.71128906254]
[]
[null,"Elecnor vs Índices",2022,2021]
[null,"Elecnor",9.52380952380949E-3,-4.5454545454545456E-2]
[null,"Ibex 35",-5.5624411852463786E-2,7.9282113529112977E-2]
[null,"Ibex Small Cap",-0.12820015045257099,1.7744903125424347E-2]
[null,"¹ % de variación de cotización cierre en el periodo desde 30-12-2021 hasta el 30-12-2022"]

{"sheet":"Proyectos Enerfín 2022","index":12,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,7,33,8],[34,7,34,8],[33,4,33,5]]}
["< INICIO"]
[null,"Proyectos Enerfín a cierre 2022"]
[]
[null,"Proyectos Nacional:","EBITDA ","Deuda Bruta","Caja","Deuda Neta","Capacidad instalada (MW)","Generación (GWh)","Factor de carga","% Participación","Fecha entrada en operación","Fin de la concesion","Perfil de ingresos"]
[null,"Eólica Montes de Cierzo , S.L.",15529,"--",1607,1607,60,113.65247600000001,0.21455311626656642,1,2001,0,"Mercado"]
[null,"Eólica Páramo de Poza , S.A.",14825,"--",1067,1067,100,127.47129600000001,0.14454671509108155,0.7,2002,0,"Mercado/Regulado"]
[null,"Parque Eólico Malpica,S.A.",9370,"--",469,469,17,64.277325000000005,0.44605435733022447,0.95550000000000002,2004,0,"Mercado/Regulado"]
[null,"Aerogeneradores del Sur , S.A.",20911,-3671,2694,-977,54,139.41820099999998,0.29256102479519197,1,2005,0,"Mercado/Regulado"]
[null,"Galicia Vento, S.L.",44160,-8565,7482,-1083,128,305.26914299999999,0.27225059128852735,0.90599999999999992,"1997- Repowered 2017",0,"Mercado/Regulado"]
[null,"Parque Eólico Cofrentes,S.L.U.",8853,-57950,6741,-51209,50,131.48633000000001,0.30146324609019992,1,2020,0,"Mercado/PPA Cepsa Gas y Electricidad"]
[null,"Renovables del Cierzo, S.L.U.",-20,-52000,2395,-49605,139,0,0,1,2023,0,"Mercado"]
[null,"Cobertura de precio de energía ",-46235,-21579,1544,-20035,0,0,0,0,0,null,0]
[]
[null,"Proyectos Brasil:"]
[null,"Ventos do Sul, S.A.",31155,-30513,9313,-21200,150,334.61725100000001,0.2546554421613394,0.8,2006,0,"PROINFA 2004"]
[null,"Parques Eólicos Palmares, S.A.",6465,-11038,3676,-7362,58,149.301172009,0.29640891802461783,0.8,"2010/2011/2012",0,"PROINFA‘04/LER’09/LER’10"]
[null,"Ventos da Lagoa, S.A.",5484,-11787,2218,-9569,58,148.18607152199999,0.29419509930911253,0.8,2012,0,"LER 2009 / LFA 2009"]
[null,"Ventos do Litoral Energía, S.A.",4692,-11757,3829,-7928,58,139.55127830499998,0.27705236907881675,0.8,2013,0,"LER 2009 / LFA 2010"]
[null,"Ventos Dos Indios Energia, S.A.",2854,-15205,3026,-12179,53,137.65840168,0.2970591571932914,0.8,2014,0,"LER 2011 / A-5 2011"]
[null,"Ventos do Sao Fernando I Energía",3072,-46014,3140,-42874,76,244.77105467300001,0.36654730707567879,1,"Oct. 2020",0,"Free Market LT PPA"]
[null,"Ventos do Sao Fernando II Energía",6379,-39524,4062,-35462,73,219.02210468099997,0.34358284135510453,1,"Nov. 2020",0,"Regulated (A-6 2018) + Spot"]
[null,"Ventos do Sao Fernando III Energía",1878,-15031,4513,-10518,24,68.679226373000006,0.32316959335603268,1,"Nov. 2020",0,"Free Market ST PPA + Spot"]
[null,"Ventos de Sao Fernando IV Energía, S.A.",2879,-45692,5435,-40257,83,235.84369930700001,0.3237469543595885,1,"Feb. 2021",0,"Free Market LT PPA + Spot"]
[]
[null,"Proyectos Canadá:"]
[null,"Eoliennes de L´Érable, SEC.",25630,-124775,6645,-118130,100,319.54154633999997,0.36477345472602735,0.51,2013,0,"Hydro-Québec Distribution"]
[]
[null,"Estructura",-161,"--",2579,2579,0,"-","-","-",0,0,0]
[null,"Promociones y otras sociedades participadas",-3230,"--",7749,7749,271,0,0,"-",0,0,0]
[]
[null,"Total",154490,-495101,80184,-414917,1552,2878.7465768900001,null,null,null,0]
[]
[null,"Detalle Promociones y otras Sociedades participadas","MW","% participación","Fecha entrada en operación","Perfil de ingresos"]
[null,"Eólica de Andalucía S.A.",74,5.2999999999999999E-2,"No Consolidada"]
[null,"Solar Serrita",68,1,2024,"PPA"]
[null,"Portón del Sol (Colombia)",129,1,2024,"PPA"]

{"sheet":"Proyectos Enerfín 2021","index":13,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,4,32,5],[33,4,33,5],[33,7,33,8],[34,7,34,8]]}
["< INICIO"]
[null,"Proyectos Enerfín a cierre 2021"]
[]
[null,"Proyectos Nacional:","EBITDA ","Deuda Bruta","Caja","Deuda Neta","Capacidad instalada (MW)","Generación (GWh)","Factor de carga","% Participación","Fecha entrada en operación","Fin de la concesion","Perfil de ingresos"]
[null,"Eólica Montes de Cierzo, S.L.",9026,"--",718,718,60.2,120.64061700000001,0.22774532712926826,1,2001,0,"Mercado"]
[null,"Eólica Páramo de Poza, S.A.",9369,"--",1975,1975,99.75,131.024508,0.14857589765012769,0.7,2002,0,"Mercado/Regulado"]
[null,"Aerogeneradores del Sur, S.A.",10847,-7386,7471,85,54.4,119.187214,0.25010746961455815,1,2004,0,"Mercado/Regulado"]
[null,"Galicia Vento, S.L.",27663,-17235,15830,-1405,128,314.24960099999998,0.2802597040881849,0.91,2005,0,"Mercado/Regulado"]
[null,"Parque Eólico Malpica, S.A.",5454,-6939,4584,-2355,16.579999999999998,64.931610000000006,0.45059478702585676,0.96,"1997- Repowered 2017",0,"Mercado/Regulado"]
[null,"Parque Eólico Cofrentes, S.L.U.",6782,-52093,5033,-47060,50,143.619767,0.3292819957978762,1,2020,0,"Mercado/PPA Cepsa Gas y Electricidad"]
[null,"Cobertura de precio de energía contratada por Enerfín Sociedad de Energía, S.L.",-37558,-65987,0,-65987,0,0,0,0,0,null,0]
[]
[null,"Proyectos Brasil:"]
[null,"Ventos do Sul, S.A.",24483,-34607,7314,-27293,150,368.37568299999998,0.28034679071537288,0.8,2006,0,"PROINFA 2004"]
[null,"Parques Eólicos Palmares, S.A.",5509,-11403,2912,-8491,57.5,161.44182190700002,0.32051185607901528,0.8,"2010/2011/2012",0,"PROINFA‘04/LER’09/LER’10"]
[null,"Ventos da Lagoa, S.A.",4836,-12117,4245,-7872,57.5,161.37450972100004,0.32037822060948984,0.8,2012,0,"LER 2009 / LFA 2009"]
[null,"Ventos do Litoral Energía, S.A.",4441,-12019,4123,-7896,57.5,155.023017912,0.30776854856462182,0.8,2013,0,"LER 2009 / LFA 2010"]
[null,"Ventos Dos Indios Energia, S.A.",2448,-15021,2622,-12399,52.9,149.74101096199999,0.32313275449068202,0.8,2014,0,"LER 2011 / A-5 2011"]
[null,"Ventos do Sao Fernando I Energía",5630,-42326,1809,-40517,76.2,279.98665192800001,0.41928304561358115,1,"Oct. 2020",0,"Free Market LT PPA"]
[null,"Ventos do Sao Fernando II Energía",6111,-37421,4012,-33409,72.7,251.41643310800001,0.39440024821433395,1,"Nov. 2020",0,"Regulated (A-6 2018) + Spot"]
[null,"Ventos do Sao Fernando III Energía",2381,-12580,2641,-9939,24.2,79.774821087999996,0.37537983248446244,1,"Nov. 2020",0,"Free Market ST PPA + Spot"]
[null,"Ventos de Sao Fernando IV Energía, S.A.",5459,-40624,4928,-35696,83.2,271.04184910399999,0.37206409757501085,1,"Feb. 2021",0,"Free Market LT PPA + Spot"]
[]
[null,"Proyectos Canadá:"]
[null,"Eoliennes de L´Érable, SEC.",21441,-133662,5588,-128074,100,292.30354032000002,0.33367984054794525,0.51,2013,0,"Hydro-Québec Distribution"]
[]
[null,"Estructura",2894,"--",14230,14230,"--"]
[null,"Promociones y otras sociedades participadas",-914,"--",4264,4264,213]
[]
[null,"Total",116302,-501420,94299,-407121,1353.63]
[]
[null,"Detalle Promociones y otras Sociedades participadas","MW","% participación","Fecha entrada en operación","Perfil de ingresos"]
[null,"Eólica de Andalucía S.A.",74,5.2999999999999999E-2,"No Consolidada"]
[null,"P.E. Baix Ebre (Cataluña)",4,0,"No Consolidada"]
[null,"Parque Eolico Ribera de Navarra",139,1,2023,"Mercado"]

{"sheet":"Proyectos Celeo 2022","index":14,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["< INICIO"]
[null,"Proyectos Celeo a cierre 2022"]
[]
[null,"Proyectos Brasil:","EBITDA ","Deuda Bruta","Caja","Deuda Neta","KM","Capacidad instalada (MW)","% participación"]
[null,"Celeo Redes Transmissao de Energía,S.A.",24657.311689999999,60356.609950000005,1491,58865.609950000005,0,"-",0.51]
[null,"Lt Triangulo,S.A",20934.488940000003,0,4050,-4049.91509,695,"-",0.51]
[null,"Vila Do Conde Transmissora De Energia SA",9009.3308899999993,0,6257,-6257,324,"-",0.51]
[null,"Pedras Transmissora De Energía, S.A.",2667.8727499999995,1233.73083,3312,-2078.26917,0,"-",0.51]
[null,"Coqueiros Transmissora De Energía, S.A.",1068.6302700000001,503.58743999999996,467,36.587439999999958,65.400000000000006,"-",0.51]
[null,"Encruzo Novo Transmissora De Energia,S.A.",2300.7283599999996,3013.2387899999999,601,2412.2387899999999,220,"-",0.51]
[null,"Linha De Transmissao Corumba,S.A.",5061.9917700000005,5897.5480699999989,1215,4682.5480699999989,279,"-",0.51]
[null,"Integraçao Maranhense Tranmissora De Energia,S.A.",6025.5544800000007,9433.0082500000008,5963,3470.0082500000008,365,"-","26,01%"]
[null,"Caiua Transmissora De Energia,S.A.",4107.8199600000007,6380.6343299999999,3971,2409.6343299999999,142,"-","26,01%"]
[null,"Cantareira Transmissora De Energía,S.A.",21838.391529999997,85644.941419999988,20066,65578.941419999988,342,"-","26,01%"]
[null,"Serra De Ibiapa Transmissora de Energía,S.A. - SITE",16893.500769999999,154684.50408000001,18522,136162.50408000001,366,"-",0.51]
[null,"Brilhante Transmissora De Energia SA",9335.1365900000001,29180.56985,5245,23935.56985,581,"-",0.51]
[null,"Jauru Transmissora De Energia,S.A.",11697.184009999999,23565.017769999999,5965,17600.017769999999,940,"-","34,00%"]
[null,"Cachoeira Paulista Transmissora De Energía,S.A.",11939.373659999997,43932.117859999998,19605,24327.117859999998,181,"-","25,50%"]
[null,"Parintins Amazonas Transmissora de Energía,S.A.",-28.02703000000238,184483.40951999999,33598.613420000001,150884.79609999998,240,"-","25,50%"]
[null,"Celeo Sao Joao Do Piaui FV I,S.A.(6)",8614.0442999999996,69685.248790000012,4437,65248.248790000012,0,180,0.51]
[]
[null,"Proyectos Chile:"]
[null,"Celeo Redes Operación Chile,S.A.",42767.218919999999,505434.22396999999,27311.947989999997,478122.27597999998,0,0,0.51]
[null,"Alto Jahuel Transmisora de Energia,S.A.",21580.836700000003,-1212.1097400000001,7373.5722800000003,-8585.6820200000002,256,0,0.51]
[null,"Charrua Transmisora De Energia,S.A.",16892.29034,0,7002.65481,-7002.65481,198,0,0.51]
[null,"CRC Transmisión, SPA",14562.263949999999,181420.88269,4615.5857900000001,176805.29689999999,0,0,"25,50%"]
[null,"Casablanca Transmisora de Energía,S.A.",771.13767999999982,1491.37869,3230.88994,-1739.51125,110,0,"25,50%"]
[null,"Mataquito Transmisora de Energía,S.A.",848.60164000000009,1968.5338899999999,1099.1548700000001,869.37901999999985,387,0,"25,50%"]
[null,"Diego de Almagro Transmisora de Energía,S.A",4520.6741999999995,0,636.72110999999995,-636.72110999999995,52,0,"25,50%"]
[null,"Alfa Transmisora de Energía,S.A.",64097.496249999997,979196.12448,54446.996639999998,924749.12783999997,899,0,"10,20%"]
[null,"Transquillota Electrica de Quillota Limitada",2233.8353399999996,0,2529.2182900000003,0,8,0,"10,20%"]
[]
[null,"Proyectos Perú:"]
[null,"Puerto Maldonado Transmisora de Energía ",-185.92568,4086.0153799999998,70.204509999999999,4015.8108699999998,161.69999999999999,0,0.51]
[]
[null,"Proyectos España:"]
[null,"Celeo Fotovoltaico,S.L.U.",5724.8793499999983,30941.925500000001,4906,26035.925500000001,0,15,0.51]
[null,"Dioxipe Solar,S.L.",16863.886105999994,157061.98462,12888,144173.98462,0,50,"49,80%"]
[null,"Aries Solar Termoelectrica,S.L. ",30790.970322000001,325532.89604000002,18731.063890000001,306801.83215000003,0,100,0.51]
[null,"Celeo Redes,SLU",-81.310230000000089,4284.0557600000002,194.7056,4089.35016,0,0,0.51]
[]
[null,"Estructura y otros",53240.123859999992,0,55081.671190000001,0,0,0,0]
[]
[null,"Total",430750.31168799999,2868200.0782300001,334884.00033000001,2590927.05229,6812.0999999999995,345]
[]
[]
[null,0]

{"sheet":"Proyectos Celeo 2021","index":15,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["< INICIO"]
[null,"Proyectos Celeo a cierre 2021"]
[]
[null,"Proyectos Brasil:","EBITDA","Deuda bruta","Caja","Deuda neta","KM","Capacidad Instalada (MW)","% participación"]
[null,"Celeo Redes Transmissao de Energía, S.A.",6081,61349,6179,55171,"-",0,0.51]
[null,"LT Triangulo, S.A.",15167,"-",7875,"-",695,0,0.51]
[null,"Vila Do Conde Transmissora de Energía, S.A.",8456,"-",8891,"-",324,0,0.51]
[null,"Pedras Transmissora De Energía, S.A.",2160,2260,2849,-589,"-",0,0.51]
[null,"Coqueiros Transmissora De Energía, S.A.",914,729,217,512,65,0,0.51]
[null,"Encruzo Novo Transmissora De Energia, S.A.",1991,3313,1025,2288,220,0,0.51]
[null,"Linha De Transmissao Corumba, S.A.",3272,6662,2207,4455,279,0,0.51]
[null,"Integraçao Maranhense Tranmissora De Energia, S.A.",4954,10431,2615,7816,365,0,"26,01%"]
[null,"Caiua Transmissora De Energia, S.A.",3068,6813,969,5844,142,0,"26,01%"]
[null,"Cantareira Transmissora De Energía, S.A.",17033,80597,8297,72300,342,0,"26,01%"]
[null,"Serra De Ibiapa Transmissora de Energía, S.A. - SITE",10533,127062,11596,115466,366,0,0.51]
[null,"Grupo Celeo Sao Joao Do Piaui",12219,57766,23288,34478,"-",180,0.51]
[null,"Jauru Transmissora De Energia, S.A.",8497,24163,4133,20031,940,0,"34,00%"]
[null,"Brilhante Transmissora De Energía, S.A.",5902,27163,4902,22262,581,0,0.51]
[null,"Brilhante II Transmissora De Energía, S.A.",687,"-","-","-","-",0,0.51]
[null,"Cachoeira Paulista Transmissora De Energía, S.A.",7883,40232,16788,23445,181,0,"25,50%"]
[null,"Parintins Amazonas Transmissora de Energía, S.A.",-95,87714,36282,51433,240,0,"25,50%"]
[]
[null,"Proyectos Chile:"]
[null,"Celeo Redes Operaciones Chile, S.A.",22706,468886,17774,451111,"-",0,0.51]
[null,"Alto Jahuel Transmisora de Energía, S.A.",22895,"-",10542,"-",256,0,0.51]
[null,"Charrua Transmisora de Energía, S.A.",14763,"-",5175,"-",198,0,0.51]
[null,"CRC Transmision, SPA",9122,151868,21284,130584,"-",0,"25,50%"]
[null,"Casablanca Transmisora de Energía, S.A.",-270,4076,7833,-3757,110,0,"25,50%"]
[null,"Mataquito Transmisora de Energía, S.A.",-288,5209,9796,-4587,387,0,"25,50%"]
[null,"Diego de Almagro Transmisora de Energía, S.A.",4268,"-",944,"-",52,0,"25,50%"]
[null,"Alfa Transmisora de Energía, S.A.",29964,973281,72557,900723,899,0,"10,20%"]
[]
[null,"Proyectos Perú:"]
[null,"Puerto Maldonado Transmisora de Energía",-44,860,1995,-1134,162,0,0.51]
[]
[null,"Proyectos España:"]
[null,"Celeo Fotovoltaico, S.L.U.",4734,32400,2203,30197,"-",15,0.51]
[null,"Dioxipe Solar, S.L.",16162,196123,6015,190109,"-",50,"49,80%"]
[null,"Aries Solar Termoelectrica, S.L.",36583,373603,18473,355130,"-",100,0.51]
[null,"Celeo Redes,SLU",-102,4273,23,4250,"-",0,0.51]
[]
[null,"Estructura y otros",30667,0,0,0,0,0,0]
[]
[null,"Total",299882,2746833,312727,2467538,6804,345]

{"sheet":"Deuda financiera neta total","index":16,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["< INICIO"]
[null,"Cálculo de la deuda financiera neta total",175951,134581,30.739851836440508]
[null,"Cálculo de la deuda financiera neta total:","31/12/2022","31/12/2021","% Var."]
[null," + Pasivos financieros por emisión de obligaciones y otros valores negociables ",175951,134581,30.739851836440508]
[null," +  Pasivos financieros con entidades de crédito",779682,789598,-1.2558289154734434]
[null," +  Instrumentos financieros derivados (del Pasivo no corriente y Pasivo corriente del Estado de Situación Financiera Consolidado)",54553,101272,-46.132198435895411]
[null," -  Inversiones en empresas viculadas a CP",-761,-323,135.60371517027863]
[null," -  Instrumentos financieros derivados ",-3905,-6454,-39.494886891850015]
[null," -  Efectivo y otros activos líquidos equivalentes",-372525,-388105,-4.0143775524664713]
[null," - Otras inversiones financieras a corto plazo",-12076,-11214,7.6868200463706087]
[null," - Instrumentos financieros derivados (del Activo no corriente) ",-9639,-371,"n.s."]
[null," - Cuenta de reserva del servicio de la deuda dentro de \"Otros activos líquidos equivalentes\"",-17825,-17681,0.81443357276172157]
[null," + Préstamos concedidos por entidades públicas",3801,4622,-17.762873215058416]
[null," +  Instrumentos financieros derivados (del Activo corriente del Estado de Situación Financiera Consolidado) de cobertura de tipo de cambio",2361,6122,-61.434171839268217]
[null," +  Instrumentos financieros derivados (del Activo corriente del Estado de Situación Financiera Consolidado) de cobertura de tipo de precio energía ",1544,0,"n.s."]
[null," +  Instrumentos financieros derivados (del Activo no corriente del Estado de Situación Financiera Consolidado) de cobertura de tipo de cambio",0,101,-100]
[null," -  Instrumentos financieros derivados (del Pasivo no corriente y Pasivo corriente del Estado de Situación Financiera Consolidado) de cobertura de tipo de cambio",-5552,-10723,-48.223444931455752]
[null," -  Instrumentos financieros derivados (del Pasivo no corriente y Pasivo corriente del Estado de Situación Financiera Consolidado) de cobertura de tipo de precio energía ",-48696,-84610,-42.446519323956977]
[null,"Deuda financiera neta total",546913,516815,5.8237473757534133]
[null,0,0,0,0]
[null,0]

{"sheet":"Vencimientos deuda","index":17,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["< INICIO"]
[null,"Perfil de vencimientos de deuda bruta dispuesta con recurso a 31.12.2022 (miles euros)"]
[]
[null,null,2023,{"$f":"C4+1","v":2024},{"$f":"D4+1","v":2025},2026,"2027 en adelante","Total"]
[null,"Financiación L/P",0,0,0,0,100000,100000]
[null,"Sindicado",0,0,0,235895,0,235895]
[null,"Otros",121275.67040138901,4882.5969896869001,3113.1770575279002,578.23573855063296,1955.2040801670955,131804.88426732155]
[null,"Total",121275.67040138901,4882.5969896869001,3113.1770575279002,236473.23573855063,101955.2040801671,467699.88426732155]

{"sheet":"Tipos de cambio","index":18,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,4,2,5]]}
["< INICIO"]
[null,"Evolución de tipos de cambio en 2022 y 2021"]
[null,null,2022,null,2021]
[null,"Tipos de Cambio respecto al Euro","Cierre","Medio","Cierre","Medio"]
[null,"US Dólar",1.0621,1.0526500000000001,1.1335999999999999,1.18503]
[null,"Dólar Canadiense",1.4442999999999999,1.3664400000000001,1.4483999999999999,1.48394]
[null,"Dólar Australiano",1.5694999999999999,1.51407,1.5713999999999999,1.5751599999999999]
[null,"Real Brasileño",5.6246999999999998,5.4343000000000004,6.3101000000000003,6.3764599999999998]
[null,"Peso Chileno",929.17,917.10666000000003,961.25,894.61235999999997]
[null,0,0,0,0,0]
[null,0,0,0,0,0]