{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1","2","3","4","5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"1","index":0,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["CUADRO 1. CAPACIDAD/NECESIDAD DE FINANCIACIÓN EN 2022 Y ESTIMACIONES PARA 2023 PREVISTAS EN ABRIL (INFORME PRESUPUESTOS 2023) Y EN LA ACTUALIDAD POR LAS 24 GRANDES CORPORACIONES LOCALES"]
["CNF: Capacidad o necesidad de financiación"]
["INF: Ingresos no financieros"]
["%: Porcentaje de CNF sobre INF"]
["(*) La capacidad/necesidad de financiación de 2022 y/o 2023 es la comunicada por la entidad local pero corregida de los ajustes de Contabilidad Nacional derivados de la liquidación de 2020 del Sistema de Financiación y/o de los del PRTR para hacerlos neutrales."]
["Ayuntamientos de más de 250.000 habitantes Diputaciones, Consejos y Cabildos de mayor presupuesto y Diputaciones Forales"]
["Efecto en la Capacidad (+) o necesidad (menos) de financiación de la liquidación del Sistema de Financiación 2020 (en millones de euros y como porcentaje sobre ingresos no financieros)"]
["Entidad","CNF Cierre 2022","INF Cierre 2022","%","CNF Presupuesto 2023","INF Presupuesto 2023","%","CNF Previsión Cierre 2023","INF Previsión Cierre 2023","%"]
["Ayuntamiento Madrid",-236.30039300000001,5262.7498958199994,-4.4900555351810346E-2,56.136660880000001,5643.5399153599992,9.9470654450787323E-3,117.660860189999,5652.3301708569006,2.0816345937583729E-2]
["Ayuntamiento Barcelona*",-190.77912703999999,3186.3445793600004,-5.9873978563335206E-2,2.6190069999999999E-2,3295.6795725700003,7.9467889469535874E-6,-113.64931147,3358.9332524400002,-3.3834941908251003E-2]
["Ayuntamiento Valencia",28.518362140000001,1024.3462106900001,2.7840550238175839E-2,34.908813007500001,1010.7242440499999,3.4538414620014876E-2,42.723626327186999,1066.30878546896,4.0066842653272573E-2]
["Ayuntamiento Sevilla",36.260461740000004,924.61328228999992,3.9216894711044295E-2,154.24977974999999,985.36775102000001,0.15654031663846199,118.271824,966.96313899999996,0.12231265001715852]
["Ayuntamiento Zaragoza",42.286360090000002,857.16572138999993,4.9332770822224967E-2,41.083618259999994,860.06011699999999,4.7768309968034474E-2,74.180279589999998,872.68159522000008,8.5002685969674197E-2]
["Ayuntamiento Málaga",9.4970516699999994,733.96680437999999,1.2939347683472409E-2,149.77793983000001,736.63539802999992,0.20332710080258756,70.736893549999991,707.85141271000009,9.9931839196569089E-2]
["Ayuntamiento Murcia*",-18.542907399999997,435.33006191000004,-4.2595053782050897E-2,41.993657130000003,409.613631,0.10252016522858343,-7.6795594258509992,435.82733603743202,-1.762064650573323E-2]
["Ayuntamiento Palma",17.928543910000002,498.51215544999997,3.5964105817672905E-2,-1.00200486,478.90034297000005,-2.0923034921751329E-3,9.3156686266659996,484.85179477266701,1.9213435377781467E-2]
["Ayuntamiento Las Palmas Gran Canaria",-11.292567999999999,386.32455758999998,-2.9230779607815196E-2,-10.1174897,445.10834312999998,-2.2730397792263015E-2,-25.770028379999999,445.10834288999996,-5.7896080340081542E-2]
["Ayuntamiento Bilbao",40.181915009999997,685.59284587000002,5.8609005697849957E-2,-50.059233526882004,648.65894000000003,-7.7173427266541653E-2,-56.800924646871003,653.63515853999991,-8.6900044932933351E-2]
["Ayuntamiento Alicante*",12.499207689999999,323.37412018999999,3.8652467558801647E-2,7.8280312800000003,283.75317460000002,2.7587466787058812E-2,14.70527128,283.75317460000002,5.1824164789450074E-2]
["Ayuntamiento Córdoba*",5.6648566900000006,308.54774563999996,1.8359740980280918E-2,34.001968079634999,331.95389830680699,0.1024297899589925,1.72518583,344.94081338999996,5.0013966542412471E-3]
["Ayuntamiento Valladolid",-31.386339020000001,301.47596073,-0.10410892776989743,0.88813681999999994,316.67307899999997,2.8045857980873706E-3,-32.258916380000002,312.35638119999999,-0.10327599601477264]
["Ayuntamiento Vigo",4.4702712599999996,294.33487114999997,1.5187705223421673E-2,0,291.52783499999998,0,-22.423159640000002,306.57419463000002,-7.3141053724571276E-2]
["Ayuntamiento Gijón/Xixón*",-12.796403810000001,266.25349098999999,-4.8060980392856563E-2,41.390436460000004,240.92493425000001,0.17179806062352387,16.554217818333001,287.07319999999999,5.7665493742825875E-2]
["Ayuntamiento L'Hospitalet*",5.5125520899999998,276.77121739,1.9917360417691949E-2,20.892156170000003,258.22812584999997,8.0905811871693156E-2,14.951142239999999,249.15298322000001,6.0007879684098604E-2]
["Diputación Barcelona",76.41063681,967.57720548999998,7.897110057621104E-2,53.150002749999999,967.61800000000005,5.4928704044364611E-2,27.809671051319,997.88194099999998,2.7868698599205335E-2]
["Diputación Valencia*",-6.7544860595829999,582.60273182000003,-1.1593639525998402E-2,36.282450060000002,583.97854036000001,6.2129765997280116E-2,32.434981620833,595.86133701999995,5.4433774446661788E-2]
["Diputación Sevilla",-41.346517320000004,449.78791841000003,-9.1924472907498084E-2,-6.7177634699999995,451.56819024999999,-1.4876520567759366E-2,58.957889170000001,450.41792203,0.13089596636004444]
["Cabildo Insular Tenerife*",-10.96878021,807.74382496999999,-1.357952839863231E-2,65.96571788,946.10895950999998,6.9723172174761303E-2,24.389110635832999,894.06682457000011,2.7278845345327402E-2]
["Consell Insular Mallorca*",10.25592984,526.42941472999996,1.9482060753121398E-2,43.590379188995001,601.25617201,7.2498846944510059E-2,53.449341242963001,616.08323064780905,8.6756689005739102E-2]
["Agregado sin Diputaciones Forales",-270.68137291958294,19099.844616259998,-1.4171914921713429E-2,714.26944605924791,19787.879164266804,3.6096311288836072E-2,419.28406323041099,19982.652990243769,2.0982402258354793E-2]
["Diputación Foral de Araba",-5.4192709000000008,808.57661810000013,-6.7022354823148946E-3,-50.139446360000001,818.78916000000004,-6.1236089593565211E-2,-50.139446360000001,818.78916000000004,-6.1236089593565211E-2]
["Diputación Foral de Gipuzkoa",108.1756824,1671.5026851499993,6.4717624064296611E-2,-11.65277416,1697.9845937200002,-6.8627090040144128E-3,-91.627814200000003,1699.3636117200003,-5.3918898561832497E-2]
["Diputación Foral de Bizkaia",32.693561459999998,3089.3939317999984,1.0582516241608426E-2,-110.52356254,2846.1420790000002,-3.8832763604982348E-2,-147.250417318399,2847.2430837500001,-5.1716840813064983E-2]
["Agregado Diputaciones Forales",135.44997296,5569.473235049998,2.4320068926372E-2,-172.31578306,5362.9158327200003,-3.213098777509691E-2,-289.01767787839901,5365.3958554700002,-5.3866981237506759E-2]
["Total",-135.23139995958294,24669.317851309996,-5.4817648698138547E-3,541.95366299924785,25150.794996986806,2.1548172257146413E-2,130.26638535201198,25348.048845713769,5.1391089761940153E-3]

{"sheet":"2","index":1,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["CUADRO 2. EFECTO EN LA CAPACIDAD/NECESIDAD DE FINANCIACIÓN EN 2022 Y 2023 (PREVISIONES DE LAS CORPORACIONES LOCALES) DE LA LIQUIDACIÓN DEL SISTEMA DE FINANCIACIÓN DE 2020 Y COMPENSACIONES EXTRAORDINARIAS  (millones de euros y porcentaje de ingresos no financieros)"]
["CNF: Capacidad o necesidad de financiación"]
["INF: Ingresos no financieros"]
["%: Porcentaje de CNF sobre INF"]
["Cierre 2022 SF:  Cierre 2022 sin efecto liquidación Sistema de Financiación 2020 y compensaciones extraordinarias."]
["Cierre 2023 SF:  Cierre 2023 sin efecto liquidación Sistema de Financiación 2020 y compensaciones extraordinarias."]
["Entidad","CNF Cierre 2022","%  Cierre 2022","CNF Cierre 2022 SF","INF Cierre 2022 SF","% Cierre 2022 SF","CNF Previsión Cierre 2023","% Previsión Cierre\n2023","CNF Previsión Cierre 2023 SF","INF Previsión Cierre 2023 SF","% Previsión Cierre 2023 SF"]
["Ayuntamiento Madrid",-236.30039300000001,-4.4900555351810346E-2,-80.165494560624978,5262.7498958199994,-1.5232624796458094E-2,117.660860189999,2.0816345937583729E-2,-29.551308691667714,5652.3301708569006,-5.2281639250361936E-3]
["Ayuntamiento Barcelona",-190.77912703999999,-5.9873978563335206E-2,-71.705947029791616,3186.3445793600004,-2.2504140793270469E-2,-113.64931147,-3.3834941908251003E-2,-219.90949985833333,3358.9332524400002,-6.5470041626634418E-2]
["Ayuntamiento Valencia",28.518362140000001,2.7840550238175839E-2,63.86523188562505,1024.3462106900001,6.2347311113305527E-2,42.723626327186999,4.0066842653272573E-2,9.9527410896870023,1066.30878546896,9.3338263974912395E-3]
["Ayuntamiento Sevilla",36.260461740000004,3.9216894711044295E-2,68.830888648333371,924.61328228999992,7.4442894090661502E-2,118.271824,0.12231265001715852,88.525698756666657,966.96313899999996,9.1550231013166533E-2]
["Ayuntamiento Zaragoza",42.286360090000002,4.9332770822224967E-2,69.121415815625028,857.16572138999993,8.0639500729842675E-2,74.180279589999998,8.5002685969674197E-2,49.380035150833329,872.68159522000008,5.6584251829425586E-2]
["Ayuntamiento Málaga",9.4970516699999994,1.2939347683472409E-2,34.12022655874997,733.96680437999999,4.648742471067499E-2,70.736893549999991,9.9931839196569089E-2,47.669617085833323,707.85141271000009,6.7344101078121471E-2]
["Ayuntamiento Murcia",-18.542907399999997,-4.2595053782050897E-2,-10.579700130416665,435.33006191000004,-2.4302709727875186E-2,-7.6795594258509992,-1.762064650573323E-2,-16.552456235017669,435.82733603743202,-3.7979389694812592E-2]
["Ayuntamiento Palma",17.928543910000002,3.5964105817672905E-2,26.348330768333334,498.51215544999997,5.2853938425130399E-2,9.3156686266659996,1.9213435377781467E-2,1.5235901649993338,484.85179477266701,3.1423832631447741E-3]
["Ayuntamiento Las Palmas Gran Canaria",-11.292567999999999,-2.9230779607815196E-2,-0.47203442104167692,386.32455758999998,-1.2218597336559676E-3,-25.770028379999999,-5.7896080340081542E-2,-35.384215644999998,445.10834288999996,-7.9495736735144804E-2]
["Ayuntamiento Bilbao",40.181915009999997,5.8609005697849957E-2,40.181915009999997,685.59284587000002,5.8609005697849957E-2,-56.800924646871003,-8.6900044932933351E-2,-56.800924646871003,653.63515853999991,-8.6900044932933351E-2]
["Ayuntamiento Alicante",12.499207689999999,3.8652467558801647E-2,19.586686574791663,323.37412018999999,6.0569740594217665E-2,14.70527128,5.1824164789450074E-2,7.8280286941666661,283.75317460000002,2.7587457674091747E-2]
["Ayuntamiento Córdoba",5.6648566900000006,1.8359740980280918E-2,13.697339329166669,308.54774563999996,4.4392932772058316E-2,1.72518583,5.0013966542412471E-3,-5.8138672716666662,344.94081338999996,-1.6854680704580301E-2]
["Ayuntamiento Valladolid",-31.386339020000001,-0.10410892776989743,-24.0406676375,301.47596073,-7.9743232526027746E-2,-32.258916380000002,-0.10327599601477264,-39.47955863166667,312.35638119999999,-0.12639267518721872]
["Ayuntamiento Vigo",4.4702712599999996,1.5187705223421673E-2,11.864526311458333,294.33487114999997,4.0309618310267734E-2,-22.423159640000002,-7.3141053724571276E-2,-29.270565171666668,306.57419463000002,-9.5476284972363351E-2]
["Ayuntamiento Gijón/Xixón",-12.796403810000001,-4.8060980392856563E-2,-5.7421835181250032,266.25349098999999,-2.1566603678224334E-2,16.554217818333001,5.7665493742825875E-2,10.106756649999667,287.07319999999999,3.5206200543971597E-2]
["Ayuntamiento L'Hospitalet",5.5125520899999998,1.9917360417691949E-2,12.923881972291664,276.77121739,4.6695180568868705E-2,14.951142239999999,6.0007879684098604E-2,8.0551159749999997,249.15298322000001,3.2330000110363515E-2]
["Diputación Barcelona",76.41063681,7.897110057621104E-2,125.41475367020834,967.57720548999998,0.12961730904635757,27.809671051319,2.7868698599205335E-2,-23.919330234514327,997.88194099999998,-2.3970100321230613E-2]
["Diputación Valencia",-6.7544860595829999,-1.1593639525998402E-2,33.165139140000328,582.60273182000003,5.6925821539482543E-2,32.434981620833,5.4433774446661788E-2,-6.0187430400003379,595.86133701999995,-1.0100912185544805E-2]
["Diputación Sevilla",-41.346517320000004,-9.1924472907498084E-2,-18.862599081250014,449.78791841000003,-4.1936651273180678E-2,58.957889170000001,0.13089596636004444,36.805029258333334,450.41792203,8.1713065706745885E-2]
["Cabildo Insular Tenerife",-10.96878021,-1.357952839863231E-2,1.0255659960249961,807.74382496999999,1.269667392459591E-3,24.389110635832999,2.7278845345327402E-2,12.950215172332998,894.06682457000011,1.4484616604090395E-2]
["Consell Insular Mallorca",10.25592984,1.9482060753121398E-2,18.519617025000009,526.42941472999996,3.5179677477746044E-2,53.449341242963001,8.6756689005739102E-2,45.635032387129669,616.08323064780905,7.4072836456114247E-2]
["Agregado sin Diputaciones Forales",-270.68137291958294,-1.4171914921713429E-2,327.09689232685884,19099.844616259998,1.7125631066568787E-2,419.28406323041099,2.0982402258354793E-2,-144.26860904142239,19982.652990243769,-7.2196924558445459E-3]
["Diputación Foral de Araba",-5.4192709000000008,-6.7022354823148946E-3,-5.4192709000000008,808.57661810000013,-6.7022354823148946E-3,-50.139446360000001,-6.1236089593565211E-2,-50.139446360000001,818.78916000000004,-6.1236089593565211E-2]
["Diputación Foral de Gipuzkoa",108.1756824,6.4717624064296611E-2,108.1756824,1671.5026851499993,6.4717624064296611E-2,-91.627814200000003,-5.3918898561832497E-2,-91.627814200000003,1699.3636117200003,-5.3918898561832497E-2]
["Diputación Foral de Bizkaia",32.693561459999998,1.0582516241608426E-2,32.693561459999998,3089.3939317999984,1.0582516241608426E-2,-147.250417318399,-5.1716840813064983E-2,-147.250417318399,2847.2430837500001,-5.1716840813064983E-2]
["Agregado Diputaciones Forales",135.44997296,2.4320068926372E-2,135.44997296,5569.473235049998,2.4320068926372E-2,-289.01767787839901,-5.3866981237506759E-2,-289.01767787839901,5365.3958554700002,-5.3866981237506759E-2]
["Total",-135.23139995958294,-5.4817648698138547E-3,462.54686528685886,24669.317851309996,1.8749884697857447E-2,130.26638535201198,5.1391089761940153E-3,-433.28628691982141,25348.048845713769,-1.7093476880887738E-2]

{"sheet":"3","index":2,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["CUADRO 3. 24 GRANDES CORPORACIONES LOCALES VISIÓN DE LOS PRINCIPALES INDICADORES FISCALES (PREVISIONES AIREF EN MATERIA DE ESTABILIDAD 2023)"]
["Significado de los indicadores de previsión"]
["Superávit","Superávit o previsión de superávit "]
["Déficit","Déficit o previsión de déficit"]
["Empeora","Empeora en la valoración: pasa de superávit en Informe PRESUPUESTO 2023 a déficit"]
["Mejora","Mejora en la valoración: pasa de déficit en Informe PRESUPUESTO 2023 a superávit"]
["Sin datos","No han comunicado los datos necesarios para la realización de este cuadro"]
["(*)","Crecimiento acumulado del gasto computable desde el nivel verificado en la liquidación de 2019."]
["EVOLUCIÓN DE LA SITUACIÓN EN EL PERÍODO DE SUSPENSIÓN DE REGLAS FISCALES (2020-2022) Y PREVISIONES 2023"]
["CORPORACIONES LOCALES","ESTABILIDAD PRESUPUESTARIA EN 2020","ESTABILIDAD PRESUPUESTARIA EN 2021","ESTABILIDAD PRESUPUESTARIA EN 2022","Crecimiento \n2020-2022\nGasto computable(*)","Previsión estabilidad en 2023","Previsión gasto computable en 2023","Previsión ratio deuda en 2023"]
["MADRID","Superávit","Superávit","Déficit",0.31734075419507835,"Superávit",7.4018317135370104E-2,0.36019400000000001]
["BARCELONA ","Déficit","Déficit","Déficit",0.28315701731945842,"Déficit",5.296260661594121E-2,0.41859400000000002]
["VALENCIA","Superávit","Superávit","Superávit",0.21439841903991774,"Superávit",0.10573582502534551,0.23271500000000001]
["SEVILLA","Déficit","Superávit","Superávit",9.5153880269869706E-2,"Superávit",1.6234198240403952E-2,0.25561800000000001]
["ZARAGOZA ","Déficit","Superávit","Superávit",0.19266813795894897,"Superávit",1.6891826381014274E-2,0.71357999999999999]
["MÁLAGA","Superávit","Superávit","Superávit",0.20170114690370089,"Superávit",7.8943758708505118E-3,0.34640799999999999]
["MURCIA","Superávit","Superávit","Déficit",0.11841219820500438,"Superávit",5.1405198120471729E-2,0.60782199999999997]
["PALMA ","Superávit","Superávit","Superávit",0.24164690635503949,"Superávit",1.4020641752448437E-2,0.39413300000000001]
["LAS PALMAS DE GRAN CANARIA","Superávit","Superávit","Déficit",0.12642108543315289,"Superávit",0.27430988445441118,1.1158E-2]
["BILBAO","Déficit","Superávit","Superávit",6.284945636974526E-2,"Déficit, empeora",0.11796811477311377,3.2356999999999997E-2]
["ALICANTE","Superávit","Superávit","Superávit",0.27858404462319353,"Superávit","Sin datos",6.8079000000000001E-2]
["CÓRDOBA","Superávit","Déficit","Superávit",0.23350961680749838,"Superávit",0.26191947748366617,0.58128599999999997]
["VALLADOLID","Déficit","Superávit","Déficit",0.25552639674209177,"Déficit, empeora",0.10879583542509375,0.59199400000000002]
["VIGO","Superávit","Superávit","Superávit",0.16336003829263412,"Superávit",0.22213019137894421,0]
["GIJÓN","Déficit","Déficit","Déficit",0.16829955155653464,"Superávit",5.2709248838774148E-2,0.36082900000000001]
["L'HOSPITALET DE LLOBREGAT","Déficit","Superávit","Superávit",9.3545170654773191E-2,"Superávit",-7.0560997871834202E-2,0.28635100000000002]
["DIPUTACIÓN BARCELONA","Superávit","Superávit","Superávit",2.4181122940682975E-3,"Superávit",0.25523862270273945,0]
["DIPUTACIÓN VALENCIA","Superávit","Superávit","Déficit",0.31146571598056161,"Superávit",0.11551309444793943,7.8253000000000003E-2]
["DIPUTACIÓN SEVILLA","Superávit","Déficit","Déficit",1.4535664362076193,"Superávit, mejora",-0.27395797991432902,1.3723000000000001E-2]
["CABILDO INSULAR DE TENERIFE","Superávit","Superávit","Déficit",0.75507964013093731,"Superávit",5.7089115060812823E-2,0.171787]
["CONSELL INSULAR DE MALLORCA","Superávit","Superávit","Superávit",0.38466442334207485,"Superávit",0.13947015739824842,0.200317]
["DIPUTACIÓN FORAL DE ARABA/ÁLAVA","Déficit","Superávit","Déficit, empeora",0.11845287486821278,"Superávit","Sin datos",0.74409199999999998]
["DIPUTACIÓN FORAL DE GIPUZKOA","Déficit","Superávit","Superávit",0.14343819110568012,"Déficit, empeora",0.35838736727956499,0.26955699999999999]
["DIPUTACIÓN FORAL DE BIZKAIA","Déficit","Superávit","Superávit",0.1493330127948751,"Déficit, empeora",0.12389001788424302,0.74306399999999995]

{"sheet":"4","index":3,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["CUADRO 4. CALIFICACIÓN DE LA SITUACIÓN DE RIESGO DE SOSTENIBILIDAD A MEDIO PLAZO"]
["Sin datos: no se han suministrado los datos necesarios para la realización de este cuadro."]
["Incumplimiento: Incumplimiento del deber de colaboración con la AIReF."]
["CORPORACIÓN LOCAL","NIVEL DE RIESGO","Deuda viva más Remanente Tesorería sobre Ingresos corrientes","PMP","Saldo no financiero ajustado sobre Ingresos corrientes ","Capacidad de financiación ajustada sobre Ingresos corrientes "]
["Jaén","Crítico",5.1236312344175436,734.4,-9.3176514232529872E-2,-0.10769632789187369]
["Jerez de la Frontera","Crítico",4.5835132448040223,383.14,-4.8252904128113651E-2,3.6199778887961262E-2]
["Parla","Crítico",10.052351777145686,325.70999999999998,-0.17174587770315478,-0.17945686030980221]
["Barrios (Los)","Muy Alto",6.0122818751909426,21.63,0.21190838016387198,0.1802695343663176]
["Navalcarnero","Muy Alto","Sin datos",45.31,"Sin datos","Sin datos"]
["Alcorcón","Alto",0.75269688197520723,9.77,0.20170924291533532,0.2065206110523457]
["Algeciras","Alto",1.9088366244558683,17.96,9.4819929374961552E-3,2.0721338431260942E-2]
["Arcos de la Frontera","Alto",2.0818256209180719,221.66,4.5516195310526933E-2,2.470230309524702E-2]
["Barbate","Alto","Incumplimiento","Incumplimiento","Incumplimiento","Incumplimiento"]
["Gandía","Alto",2.6988502863219801,14.72,8.6064965667970061E-2,8.4772052717176166E-2]
["Línea de la Concepción","Alto",1.8517770355211591,17.97,6.7968731673744898E-2,6.2874951027049444E-2]
["Palacios y Villafranca (Los)","Alto",1.4528911043277457,320.33,5.7439858646488526E-2,5.5899619413648564E-2]
["San Fernando de Henares","Alto",1.3603415307953706,7.26,3.6161710753859461E-2,8.9680680979490404E-2]
["Totana","Alto",3.4588468718997474,49.16,0.10832680052946324,0.12032516107397917]
["Aranjuez","Moderado",2.3799687869678219,214.03,0.16366906719908031,0.16357861973393817]
["Arganda del Rey","Moderado",1.3832857560443439,21.68,7.3242108702351677E-2,0.11122608038566255]
["Ayamonte","Moderado",1.0057854544239322,308.31,6.137467957111413E-2,6.6391661706236504E-2]
["Alboraia/Alboraya","Bajo",1.7308817732848445,12.65,0.15897075967765165,0.14269142131587173]
["Caravaca de la Cruz","Bajo",1.168341702202214,34.700000000000003,4.954294273651963E-2,5.5232505201602153E-2]
["Puerto Real","Bajo",2.0383709663506124,67.72,0.17796045716314435,0.21355295837343252]
["San Andrés del Rabanedo","Bajo",1.3247187895661341,26.24,0.22934351260101288,0.22490688637840858]
["CORPORACIÓN LOCAL","NIVEL DE RIESGO","Deuda viva más Remanente Tesorería sobre Ingresos corrientes","PMP","Saldo no financiero ajustado sobre Ingresos corrientes ","Capacidad de financiación ajustada sobre Ingresos corrientes "]
["Almonte","Sin riesgo que determine análisis estructural",0.89052660651870408,139.63999999999999,8.0832790622119358E-2,8.8952534064845518E-2]

{"sheet":"5","index":4,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["CUADRO 5. CAPACIDAD/NECESIDAD DE FINANCIACIÓN EN 2022 Y ESTIMACIONES PARA 2023 DE LAS ENTIDADES CON RIESGOS DE SOSTENIBILIDAD"]
["CNF: Capacidad o necesidad de financiación"]
["INF: Ingresos no financieros"]
["%: Porcentaje de CNF sobre INF"]
["Cierre 2022 SF: Cierre de 2022 sin efecto liquidación del Sistema de Financiación 2020 y compesaciones extraordinarias."]
["Cierre 2023 SF: Cierre de 2023 sin efecto liquidación del Sistema de Financiación 2020 y compesaciones extraordinarias."]
["(*) La capacidad/necesidad de financiación de 2022 y/o 2023 es la comunicada por la entidad local pero corregida de los ajustes de Contabilidad Nacional derivados de la liquidación de 2020 del Sistema de Financiación y/o de los del PRTR para hacerlos neutrales."]
["Efecto en la Capacidad (+) o necesidad (menos) de financiación de la liquidación del Sistema de Financiación 2020"]
["Entidad","CNF Cierre 2022","% Cierre 2022","CNF Cierre 2022 SF","% Cierre 2022 SF","CNF Previsión Cierre 2023","% Previsión Cierre 2023","CNF Previsión Cierre 2023 SF","% Previsión Cierre 2023 SF"]
["Ayuntamiento Jerez de la Frontera*",15.089851272917,6.8170308901327512E-2,19.348631060000329,8.7409884452961065E-2,21.631207750000002,9.3194737575045483E-2,17.07842772916667,7.3579783838656335E-2]
["Ayuntamiento Alcorcón",18.852223840000001,0.11369461921894823,22.709946757083333,0.13695990303015507,35.156725849799997,0.20582203989418327,31.345102628133329,0.18350721825398961]
["Ayuntamiento Parla",-26.242132170000001,-0.31764099062768864,-24.304313737499999,-0.29418517680248546,-10.568050980000001,-0.12906757462424218,-12.5537825425,-0.15331930818530434]
["Ayuntamiento Algeciras*",-4.0011083300000001,-3.0987383152197012E-2,-1.3638934874999977,-1.0562945711582035E-2,12.857293484167,0.11024339095485426,10.430649260000333,8.9436407880027366E-2]
["Ayuntamiento Jaén*",-27.600257389999999,-0.22920498718072657,-24.811582415625001,-0.20604657228911694,-49.358732979999999,-0.5315635749055635,-51.918401635000002,-0.55912965163968142]
["Ayuntamiento Gandía*",2.7925628100000002,2.5818502643736717E-2,4.9129197162499993,4.5422158537757953E-2,8.2799957400000004,8.6426757447277888E-2,6.4275021150000002,6.7090392764498047E-2]
["Ayuntamiento Línea de la Concepción*",3.6810920400000002,4.6649823868755269E-2,3.4677715100000004,4.3946450781651061E-2,6.8246549100000005,9.5883700719713458E-2,6.8246549100000005,9.5883700719713458E-2]
["Ayuntamiento Aranjuez*",5.0277460168749997,9.4470891817796734E-2,6.5612682599999994,0.12328563572972029,4.8898814841670006,9.0160529155061966E-2,3.5571611200003339,6.5587587328545943E-2]
["Ayuntamiento Arganda del Rey*",4.8281730999999999,7.0418122116630136E-2,6.0797178347916674,8.8671699224084119E-2,4.6995069300000001,5.8361163598735492E-2,3.2769907425000002,4.0695544380138664E-2]
["Ayuntamiento Puerto Real",8.1711235900000005,0.19378874263756246,9.2625374102083331,0.21967303010254149,6.97806193,0.14341000963828993,5.9985490641666672,0.12327949905539128]
["Ayuntamiento San Fernando de Henares",6.1483176200000003,0.12418508184381205,7.3864298645833335,0.14919274734327384,7.5814933799999995,0.1505758367428004,6.6775000041666663,0.13262164854352862]
["Ayuntamiento Palacios y Villafranca (Los)*",0.23831787312500002,6.4003720603697852E-3,1.6198893900000002,4.3504478521455225E-2,2.0863173741669998,5.5434413452684961E-2,1.2503166200003333,3.3221488407311747E-2]
["Ayuntamiento Totana",-2.17561786,-7.0672695607080074E-2,-1.3006325300000001,-4.2249702293470068E-2,0.98082934220899998,3.2288465596238589E-2,0.26716476887566665,8.7949453356900627E-3]
["Ayuntamiento Arcos de la Frontera",-2.22878314,-6.4680207564941403E-2,-1.3561843729166667,-3.9357030822020626E-2,-1.0094866600000001,-2.9220915728954702E-2,-1.6608508841666669,-4.8075507728446931E-2]
["Ayuntamiento San Andrés del Rabanedo",5.4670157000000001,0.22325567281755326,6.3835429602083336,0.26068375449169956,3.9080436700000001,0.16106080110005441,3.2605375191666668,0.13437536250810814]
["Ayuntamiento Navalcarnero","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos"]
["Ayuntamiento Caravaca de la Cruz*",0.42454986,1.6646613323489295E-2,1.1138551960416665,4.3674297164683989E-2,-2.7462273500000003,-0.10154970025555632,-3.2890090550000002,-0.12162062389811264]
["Ayuntamiento Alboraia/Alboraya*",2.337193605,8.0761557565634634E-2,2.9748040025,0.10279413916776657,-2.5730483333000001E-2,-9.3391750622289155E-4,-0.55221308583299988,-2.0043209501757663E-2]
["Ayuntamiento Almonte",9.7208818000000008,0.21031658404179349,10.148503278125,0.21956840814505052,7.4491668200000003,0.16554800067858891,6.9062327483333341,0.15348200024705311]
["Ayuntamiento Barrios (Los)",8.1502097300000003,0.24560003298947344,8.7458116797916663,0.2635480200184438,6.799366,0.22179082783316906,6.2555748166666669,0.2040527186153569]
["Ayuntamiento Barbate","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos","Sin datos"]
["Ayuntamiento Ayamonte",3.0530516000000003,0.10153199574520487,3.676755313958334,0.12227382756746624,2.763677814167,9.8078380894675424E-2,2.3039029100003332,8.1761725622663192E-2]
["Total",31.734411567917004,2.249492954097327E-2,61.255777690000329,4.3421142382459053E-2,69.177994025344006,5.0118839725727435E-2,41.886009753677328,3.0346040517244828E-2]