{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1","2","3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["CUADRO 1. ESTIMACIÓN DE LAS 25 GRANDES CORPORACIONES LOCALES DE LA CAPACIDAD/NECESIDAD DE FINANCIACIÓN EN 2023 Y 2024"]
["Ayuntamientos de más de 250.000 habitantes Diputaciones, Consejos y Cabildos de mayor presupuesto y Diputaciones Forales"]
["CNF: Capacidad o necesidad de financiación"]
["INF: Ingresos no financieros"]
["%: Porcentaje de CNF sobre INF"]
["Entidad","CNF 2023 en millones de €","CNF % sobre INF","Previsión CNF en líneas 2024 en millones de €","Previsión CNF en líneas 2024 en % sobre INF","Previsión actual 2024 en millones de €","Previsión actual 2024 en % sobre INF"]
["Ayuntamiento Madrid",149.267299900084,2.6287752075084714,477.32116662999999,8.0959601433971784,181.98051679,3.0375805918015919]
["Ayuntamiento Barcelona",-0.73158940000200001,-1.9512219445486395E-2,3.043837422957,7.9143253971890509E-2,165.90721909999999,4.7619902773090121]
["Ayuntamiento Valencia",68.943152359999999,6.3539005940825888,29.926531623411996,2.8667237321540031,25.696606639999999,2.3274079269620973]
["Ayuntamiento Sevilla",67.267904489999992,6.6507089333109839,85.443102459999992,7.9614349614412463,129.1034927234,11.831807326207112]
["Ayuntamiento Zaragoza",44.933865909999994,5.1284675580333143,51.47176236,5.6979598686622595,50.107038807999999,5.2859935512637621]
["Ayuntamiento Málaga",61.01924503,7.6557514959510398,144.71083902000001,17.436512126491817,159.97898796999999,18.762083964591252]
["Ayuntamiento Murcia",-21.13444148,-4.9166812245705938,35.857094429999997,7.6654639817373402,34.676632789999999,7.7942245370863139]
["Ayuntamiento Palma",19.781632129999998,4.0590284290446084,10.983658439999999,2.2455639277650601,0,6.1672451676791917E-7]
["Ayuntamiento Las Palmas Gran Canaria",31.148014700000001,6.8342825245894359,0.97689791000000004,0.1986692071957335,41.64197927,7.7123383978287912]
["Ayuntamiento Bilbao",-25.818568035399998,-3.6775852417593029,-18.629000000000001,-2.5696200261803579,6.6891581114890002,0.88117334333836228]
["Ayuntamiento Alicante/Alacant",13.53922567,4.0832314432145314,"n. d.","n. d.",24.576641541000001,7.3818325044850992]
["Ayuntamiento Córdoba",-16.268645620000001,-4.5028684829799843,7.9010954299999998,1.8640350827654726,34.912077189999998,7.6630051299555939]
["Ayuntamiento Valladolid",-24.474006890000002,-7.1536169903978752,1.37707176,0.4119514499381971,22.076187641253,5.8986231318917923]
["Ayuntamiento Vigo",6.2254027199999999,2.0557464672462977,1.0807183999999999,0.3505346865137362,3.3466253500000001,1.0677418604395326]
["Ayuntamiento Gijón/Xixón",1.0819264099999999,0.34636529387658427,-4.8483038199999999,-1.7347459036179638,1.33287226,0.43162043336182759]
["Ayuntamiento L'Hospitalet",22.575665090000001,7.7268038425042267,6.5021053200000001,2.1793977139477416,38.206312152237999,12.986637166589949]
["Ayuntamiento Vitoria-Gasteiz","n. d.","n. d.","n. d.","n. d.","n. d.","n. d."]
["Diputación Barcelona",14.32724196,1.3814801858899108,68.276833783790011,5.881797466329437,17.180588042697,1.4817861233111271]
["Diputación Valencia",22.525897219999997,3.4845705281745376,38.794047329999998,6.2618340084581181,60.044631509999995,9.5359185492613427]
["Diputación Sevilla",91.741484079999992,18.53521601822672,9.5853557600000006,2.0310926594185421,50.153814079999997,10.523508224537832]
["Cabildo Insular Tenerife",6.4488526259999999,0.62902533596515064,-2.3569490000000002,-0.22980857175269784,0.75918414187899996,7.0736317290857886E-2]
["Consell Insular Mallorca*",30.207303191167998,4.8617058150880768,-1.1736716999999999,-0.22008939440796108,31.142244924736001,4.902393210465199]
["Agregado sin DD. FF.",562.60686206184971,2.7,946.24419356015915,4.45895178578232,1079.4387979266914,4.9563291735025103]
["Diputación Foral de Araba",13.704877139967,1.4810152022978353,"n. d.","n. d.",8.2932934972800005,0.92215674563281436]
["Diputación Foral de Gipuzkoa",30.617988839999999,1.6926221569539774,13.520942647790999,0.73224340399503118,35.522943750000003,1.8821529159874455]
["Diputación Foral de Bizkaia",-122.24825692000499,-3.6695035239673524,2.6677369999999998,7.8472652813781588E-2,55.417012479999997,1.6697604879637986]
["Agregado DD. FF.",-77.925390940038,-1.3,16.188679647790998,3.08585936691036,99.233249727279997,1.6252948859874701]
["Total",484.68147112181168,1.8,962.43287320795014,3.6363078895444398,1178.6720476539715,4.2269716044268]

{"sheet":"2","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["CUADRO 2. EXCESO DE GASTO COMPUTABLE SOBRE EL LÍMITE Y CAPACIDAD DE FINANCIACIÓN NECESARIA PARA CUMPLIR LA REGLA DE GASTO"]
["Entidad","CNF 2024 en \nmillones de €","CNF 2024 en \n% sobre INF","Gasto Computable 2024 en \nmillones de €","Variación 2024 (%)","Importe Límite \n(tasa 2,6%)","Exceso sobre el límite","% sobre gasto computable 2024","CNF compatible con cumplimiento regla de gasto 2024 en millones de €","CNF compatible con cumplimiento regla de gasto 2024 en % sobre INF"]
["Ayuntamiento Madrid",181.98051679,3.0375805918015919,5455.5734190399999,5.7702111295542924,5292.0555496281977,163.51786941180217,3.0898743952770942,345.49838620180219,5.7669865485459226]
["Ayuntamiento València",25.696606639999999,2.3274079269620973,986.29597611000008,7.5485285634482535,940.91447368512002,45.381502424880068,4.8231272548228583,71.078109064880067,6.4377276264006493]
["Ayuntamiento Palma",-7.4013110000000007E-2,-1.4489383275483231E-2,506.71110974999999,16.04404328047584,448.0071392781,58.703970471899993,13.103356023855584,58.62995736189999,11.477857417987282]
["Ayuntamiento Las Palmas Gran Canaria",41.64197927,7.7123383978287912,442.12535930000001,17.181017499283048,387.1110085254,55.014350774600018,14.211518030490289,96.656330044600026,17.901318301006434]
["Ayuntamiento Alicante/Alacant",24.576641541000001,7.3818325044850992,306.95994451000001,8.0037324244537125,291.60186967385999,15.35807483614002,5.2667957353350126,39.93471637714002,11.994779145001552]
["Ayuntamiento Gijón/Xixón",1.33287226,0.43162043336182759,293.73014115000001,16.135439045181087,259.49626341246,34.233877737540013,13.19243571655076,35.566749997540015,11.51748483925234]
["Diputación Barcelona",17.180588042697,1.4817861233111271,1169.60688441363,11.147856243928844,1079.6579474954401,89.948936918189929,8.3312439024647507,107.12952496088693,9.2396746310108178]
["Diputación Sevilla",50.153814079999997,10.523508224537832,347.08789314999996,8.6951623110689713,327.62468062080006,19.463212529199893,5.9407040068898347,69.617026609199883,14.607370656221569]
["Cabildo Insular Tenerife",0.75918414187899996,7.0736317290857886E-2,871.42137237812096,7.8270752820732259,829.17794600387992,42.243426374241039,5.0946152846717618,43.002610516120036,4.0067305598280836]
["Diputación Foral de Araba/Álava",8.2932934972800005,0.92215674563281436,532.55888517700998,5.7486305670661819,516.70212017079496,15.856765006215028,3.0688407086414902,24.150058503495028,2.6853190911100779]
["Total",351.54148315285602,2.8358852724426407,10912.070984978762,7.9387594094038727,10372.348998494055,539.72198648470817,4.8869943214233418,891.2634696375643,7.1898227337007903]

{"sheet":"3","index":2,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["CUADRO 3. 25 GRANDES CORPORACIONES LOCALES PRINCIPALES INDICADORES FISCALES. PREVISIONES AIREF 2024 DE ESTABILIDAD, GASTO COMPUTABLE Y DEUDA"]
["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 de Líneas Fundamentales 2024 a déficit"]
["Mejora","Mejora en la valoración: pasa de déficit en Informe de Líneas Fundamentales 2024 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","ESTABILIDAD PRESUPUESTARIA EN 2023","Crecimiento \n2020-2022\nGasto computable(*)","Crecimiento 2023\nGasto computable(*)","Previsión estabilidad AIReF 2024","Previsión AIReF crecimiento \nGasto computable 2024","Previsión AIReF ratio deuda en 2024"]
["MADRID","Superávit","Superávit","Déficit","Superávit",0.317,7.0000000000000007E-2,"Superávit",5.7700000000000001E-2,0.35749999999999998]
["BARCELONA ","Déficit","Déficit","Déficit","Déficit",0.28299999999999997,-6.0000000000000001E-3,"Superávit",7.4999999999999997E-3,0.34460000000000002]
["VALENCIA","Superávit","Superávit","Superávit","Superávit",0.214,0.127,"Superávit",9.1499999999999998E-2,0.1764]
["SEVILLA","Déficit","Superávit","Superávit","Superávit",9.5000000000000001E-2,7.8E-2,"Superávit",7.4000000000000003E-3,0.2432]
["ZARAGOZA ","Déficit","Superávit","Superávit","Superávit",0.192,8.5000000000000006E-2,"Superávit",1.7600000000000001E-2,0.66169999999999995]
["MÁLAGA","Superávit","Superávit","Superávit","Superávit",0.20100000000000001,1.7000000000000001E-2,"Superávit",-5.91E-2,0.48659999999999998]
["MURCIA","Superávit","Superávit","Déficit","Empeora",0.11799999999999999,0.08,"Superávit",-7.3800000000000004E-2,0.58199999999999996]
["PALMA ","Superávit","Superávit","Superávit","Superávit",0.24099999999999999,1.7000000000000001E-2,"Superávit",0.1736,0.33450000000000002]
["LAS PALMAS DE GRAN CANARIA","Superávit","Superávit","Déficit","Superávit",0.126,0.113,"Superávit",0.17180000000000001,1.78E-2]
["BILBAO","Déficit","Superávit","Superávit","Déficit",6.2E-2,6.3E-2,"Superávit",2.4299999999999999E-2,4.5100000000000001E-2]
["ALICANTE/ALACANT","Superávit","Superávit","Superávit","Superávit",0.20699999999999999,0.13100000000000001,"Superávit",0.08,5.9299999999999999E-2]
["CÓRDOBA","Superávit","Déficit","Superávit","Empeora",0.23300000000000001,0.19600000000000001,"Superávit",-1.7899999999999999E-2,0.4264]
["VALLADOLID","Déficit","Superávit","Déficit","Déficit",0.255,6.9000000000000006E-2,"Superávit",-7.7999999999999996E-3,0.3921]
["VIGO","Superávit","Superávit","Superávit","Mejora",0.16200000000000001,4.5999999999999999E-2,"Superávit",2.5700000000000001E-2,0.01]
["GIJÓN/XIXÓN","Déficit","Déficit","Déficit","Superávit",0.16800000000000001,4.1000000000000002E-2,"Superávit",0.13370000000000001,0.2797]
["L'HOSPITALET DE LLOBREGAT","Déficit","Superávit","Superávit","Superávit",9.2999999999999999E-2,1.4E-2,"Superávit",5.4999999999999997E-3,0.27129999999999999]
["VITORIA-GASTEIZ","Déficit","Superávit","Superávit","no disponible","no disponible","no disponible","no disponible","no disponible","no disponible"]
["DIPUTACIÓN BARCELONA","Superávit","Superávit","Superávit","Superávit",2E-3,0.27,"Superávit",0.1114,0.01]
["DIPUTACIÓN VALENCIA","Superávit","Superávit","Superávit","Superávit",0.311,0.17899999999999999,"Superávit",-0.109,0.1072]
["DIPUTACIÓN SEVILLA","Superávit","Déficit","Déficit","Mejora",1.286,-0.121,"Superávit",8.6900000000000005E-2,1.3299999999999999E-2]
["CABILDO INSULAR DE TENERIFE","Superávit","Superávit","Déficit","Mejora",0.755,0.246,"Superávit",7.8200000000000006E-2,9.1700000000000004E-2]
["CONSELL INSULAR DE MALLORCA","Superávit","Superávit","Superávit","Superávit",0.38400000000000001,0.19400000000000001,"Superávit",2.12E-2,0.15429999999999999]
["DIPUTACIÓN FORAL DE ARABA/ÁLAVA","Déficit","Superávit","Déficit","Superávit",0.109,7.6999999999999999E-2,"Superávit",5.74E-2,0.5857]
["DIPUTACIÓN FORAL DE GIPUZKOA","Déficit","Superávit","Superávit","Superávit",0.14299999999999999,0.28799999999999998,"Superávit",1.1299999999999999E-2,0.25040000000000001]
["DIPUTACIÓN FORAL DE BIZKAIA","Déficit","Superávit","Superávit","Déficit",{"$f":"INT(L35*1000)/1000","v":0},{"$f":"INT(M35*1000)/1000","v":0},"Superávit",{"$f":"INT(O35*10000)/10000","v":0},{"$f":"INT(P35*10000)/10000","v":0}]