{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["prognozowana sytuacja finansowa"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"prognozowana sytuacja finansowa","index":0,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,14,0,17],[1,0,1,16],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,2,17]],"flags":["formulas_cached_only"]}
[{"$nulls":14},"ZAŁĄCZNIK NR 2 DO UCHWAŁY RADY MIEJSKIEJ W OSTRÓDZIE  NR VIII / 38 / 2011 \nZ  DNIA 19 KWIETNIA 2011 ROKU"]
["PROGNOZA KWOTY DŁUGU I SPŁATA ZOBOWIĄZAŃ DLA MIASTA OSTRÓDY NA LATA 2011 - 2023",{"$nulls":16},"w złotych"]
["LP","WYSZCZEGÓLNIENIE","WYKONANIE NA 31.12.2008","WYKONANIE NA 31.12.2009","WYKONANIE\n NA 2010","PLAN\n NA 2011","PROGNOZA"]
[{"$nulls":6},2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
["A","Dochody ogółem, z tego:",75112006,73031365,83689076,111738780.5,101613676,84027250,82673600,83167900,84963000,86881400,88669000,90367200,91858700,93376590,94600000,96100000]
[1,"Dochody bieżące",69590499,70141066,71590152,73358092.5,77169060,80942250,81163600,83167900,84963000,84881400,85669000,86367200,87858700,88376590,89600000,91100000]
[2,"Dochody majątkowe, w tym:",5521507,2890299,12098924,38380688,24444616,3085000,1510000,"-","-",2000000,3000000,4000000,4000000,5000000,5000000,5000000]
["2.1","Dochody ze sprzedaży majątku",2199816,1392800,3735562,2464000,4610000,1585000,1510000,"-","-","-","-","-","-","-","-","-"]
["B","Wydatki ogółem, z tego:",79340342,81631655,93379539,128432844.5,96777167,77211610,77657960,78152260,80047360,82552759,84973734,86467200,87458700,90576590,91700000,93100000]
[1,"Wydatki bieżące",61650702,66774092,71104553,73158092.5,72292162,72169610,73957960,74452260,75347360,76852759,77573734,78467200,79458700,80176590,81500000,82700000]
[2,"Wydatki majątkowe",17689640,14857563,22274986,55274752,24485005,5042000,3700000,3700000,4700000,5700000,7400000,8000000,8000000,10400000,10200000,10400000]
["C","Wyniki budżetu (A-B)",-4228336,-8600290,-9690463,-16694064,4836509,6815640,5015640,5015640,4915640,4328641,3695266,3900000,4400000,2800000,2900000,3000000]
["D","Finansowanie (D.1 - D.2)",5451356,9006800,9823591,16694064,-4836509,-5015640,-5015640,-5015640,-4915607,-4328641,-3695266,-3900000,-4400000,-2800000,-2900000,-3000000]
[1,"Przychody ogółem, z tego:",7572631,11625286,13800000,21360005,342060,"-","-","-","-","-","-","-","-","-","-","-"]
["1.1","Kredyty i pożyczki, w tym:",5499222,10402266,13800000,21000000,300000,"-","-","-","-","-","-","-","-","-","-","-"]
["1.1.1","Kredyty i pożyczki zaciągane na zadania finansowane  z udziałem środków UE i EFTA","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.2","Emitowane papiery wartościowe, w tym:","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.2.1","\nPapiery wartościowe emitowane na zadania finansowe z udziałem środków UE i EFTA\n","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.3","Zwrot pożyczek udzielonych","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.4","Przychody z prywatyzacji","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.5","Nadwyżka z lat ubiegłych","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.6","Wolne środki","-",1223020,"-",360005,42060,"-","-","-","-","-","-","-","-","-","-","-"]
["1.7","Inne źródła",2073409,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2,"Rozchody ogółem, z tego:",2121275,2618486,3976409,4665941,5178569,5015640,5015640,5015640,4915607,4328641,3695266,3900000,4400000,2800000,2900000,3000000]
["2.1","Spłaty kredytów i pożyczek, w tym:",2121275,2618486,3976409,4665941,5178569,5015640,5015640,5015640,4915607,4328641,3695266,3900000,4400000,2800000,2900000,3000000]
["2.1.1","Spłaty kredytów i pożyczek zaciąganych na zadania finansowane z udziałem środków UE i EFTA","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["2.2","Wykup papierów wartościowych, w tym:","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["2.2.1","Wykup papierów wartościowych wyemitowanych na zadania finansowane z udziałem środków UE i EFTA","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["2.3","Udzielone pożyczki","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["2.4","Inne rozchody (np. przelewy na rachunki lokat)","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["E","Umorzenia pożyczek","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["F","Udzielone poręczenia, w tym:","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[1,"Potencjalne spłaty kwot wynikających z udzielonych poręczeń oraz gwarancji przypadające w danym roku budżetowym, w tym:","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.1","Potencjalne spłaty kwot wynikających z poręczeń\n i gwarancji udzielanych samorządowym osobom prawnym realizującym zadania j.s.t. finansowane\n z udziałem środków UE i EFTA","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["G","Obciążenia związane z posiadanymi zobowiązaniami\n (bez poz. D2.1.1, D2.2.1, F1.1), z tego:",2925183,3424123,4926971,5619841,7032469,6719540,6579540,6419540,6146767,5348641,4525266,4480000,4820000,3070000,3100000,3100000]
[1,"Spłaty rat kredytów i pożyczek (D2.1 - D2.1.1)",2121275,2618486,3976409,4665941,5178569,5015640,5015640,5015640,4915607,4328641,3695266,3900000,4400000,2800000,2900000,3000000]
[2,"Spłaty odsetek od kredytów i pożyczek",803908,805637,950562,900000,1800000,1650000,1510000,1350000,1190000,1020000,830000,580000,420000,270000,200000,100000]
[3,"Wykup papierów wartościowych (D2.2 - D2.2.1)","-","-"]
[4,"Odsetki i dyskonto od papierów wartościowych","-","-"]
[5,"Potencjalne spłaty kwot wynikających z udzielonych poręczeń oraz gwarancji przypadające w danym roku budżetowym (F1 - F1.1)\n ","-","-"]
[6,"Kwoty zobowiązań związku współtworzonego przez j.s.t. przypadające do spłaty w danym roku budżetowym","-","-",null,53900,53900,53900,53900,53900,41160]
["H","Wskaźnik obsługi długu (G : A) w %",3.89,4.69,5.887233119887714,5.029445439490902,6.92078987478024,7.996858162084323,7.958453484546457,7.718771304794278,7.2346397843767285,6.156255539160281,5.103549154721492,4.957550969820908,5.2471894333362,3.2877619540400866,3.276955602536998,3.225806451612903]
["I","Łączna kwota długu na koniec roku budżetowego,\n z tego:",16728808,24978115,34427071,49855003,44986434,39970794,34955154,29939514,25023907,20695266,17000000,13100000,8700000,5900000,3000000,"-"]
[1,"Papiery wartościowe, w tym:","-","-"]
["1.1","\nPapiery wartościowe wyemitowane na zadania finansowane z udziałem środków UE I EFTA\n","-","-"]
[2,"Kredyty i pożyczki, w tym:",15923573,23707353,33530944,49855003,44986434,39970794,34955154,29939514,25023907,20695266,17000000,13100000,8700000,5900000,3000000,"-"]
["2.1","Kredyty i pożyczki zaciągnięte na zadania finansowane z udziałem środków UE i EFTA","-","-"]
[3,"Przyjęte depozyty","-","-"]
[4,"Wymagalne zobowiązania",805235,1270762,896127]
["J","Wskaźnik długu (I - I1.1 - I2.1) : A w %",22.27,34.2,41.13687549854177,44.6174575889523,44.272026926769186,47.568847010939905,42.280914342668034,35.998881780109876,29.452711180160772,23.820134113860963,19.17242779325356,14.496410201931676,9.471068064320527,6.3185001722594505,3.171247357293869,0]
["K","Średnia arytmetyczna z ostatnich trzech lat,\n o której mowa w art. 243 ustawy z 27 sierpnia 2009r.","-","-","X",8.35,4.65,5.59,8.02,10.74,11.12,10.78,10.35,9.9,9.04,9,8.89,8.83]
["L","Czy spełniony jest warunek, o którym mowa w art. 243 ustawy z 27 sierpnia 2009r. dla danego roku","-","-","X","X","NIE","NIE","TAK","TAK","TAK","TAK","TAK","TAK","TAK","TAK","TAK","TAK"]