{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["prognozowana sytuacja finansowa"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,10,0,17],[1,0,1,16],[2,14,2,17],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,3,17]],"flags":["formulas_cached_only"]}
[{"$nulls":10},"ZAŁĄCZNIK NR 2 DO UCHWAŁY RADY MIEJSKIEJ W OSTRÓDZIE\nNR....................... Z  DNIA ............................. ROKU"]
["PROGNOZA KWOTY DŁUGU I SPŁATA ZOBOWIĄZAŃ DLA MIASTA OSTRÓDY NA LATA 2011 - 2023"]
[{"$nulls":14},"w złotych"]
["LP","WYSZCZEGÓLNIENIE","WYKONANIE NA 31.12.2008","WYKONANIE NA 31.12.2009","PLAN NA 2010","PLAN 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,105218126,112365740,92654536,79885250,82673600,83167900,85063000,87081400,88869000,90567200,92058700,93676590,94900000,96300000]
[1,"Dochody bieżące",69590499,70141066,70169338,71488279,76669060,78600250,81163600,83167900,85063000,85081400,85869000,86567200,88058700,88676590,89900000,91300000]
[2,"Dochody majątkowe, w tym:",5521507,2890299,35048788,40877461,15985476,1285000,1510000,"-","-",2000000,3000000,4000000,4000000,5000000,5000000,5000000]
["2.1","Dochody ze sprzedaży majątku",2199816,1392800,3970200,2464000,4110000,1285000,1510000,"-","-","-","-","-","-","-","-","-"]
["B","Wydatki ogółem, z tego:",79340342,81631655,122521951,125193638,86875967,74369610,76957960,77452260,79347360,81852759,84073734,86967200,88458700,91076590,92300000,93700000]
[1,"Dochody bieżące",61650702,66774092,70835701,71488279,73000111,73369610,73957960,74452260,75347360,76852759,77573734,78467200,79458700,80176590,81500000,82700000]
[2,"Wydatki majątkowe",17689640,14857563,51686250,53705359,13875856,1000000,3000000,3000000,4000000,5000000,6500000,8500000,9000000,10900000,10800000,11000000]
["C","Wyniki budżetu (A-B)",-4228336,-8600290,-17303825,-12827898,5778569,5515640,5715640,5715640,5715640,5228641,4795266,3600000,3600000,2600000,2600000,2600000]
["D","Finansowanie (D.1 - D.2)",5451356,9006800,17303825,12827898,-5778569,-5515640,-5715640,-5715640,-5715640,-5228641,-4795266,3600000,3600000,2600000,2600000,2600000]
[1,"Przychody ogółem, z tego:",7572631,11625286,21280234,18093839,"-","-","-","-","-","-","-","-","-","-","-","-"]
["1.1","Kredyty i pożyczki, w tym:",5499222,10402266,21000000,18000000,"-","-","-","-","-","-","-","-","-","-","-","-"]
["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","Papiery wartościowe emitowane na zadania finansowe z udziałem środków UE i EFTA","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.3","Zwrot pożyczek udzielonych","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.4","Przychody z prywatyzacji","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.5","Nadwyżka z lat ubiegłych","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.6","Wolne środki","-",1223020,280234,93839,"-","-","-","-","-","-","-","-","-","-","-","-"]
["1.7","Inne źródła",2073409,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2,"Rozchody ogółem, z tego:",2121275,2618486,3976409,5265941,5778569,5715640,5715640,5715640,5715640,5228641,4795266,3600000,3600000,2600000,2600000,2600000]
["2.1","Spłaty kredytów i pożyczek, w tym:",2121275,2618486,3976409,5265941,5778569,5715640,5715640,5715640,5715640,5228641,4795266,3600000,3600000,2600000,2600000,2600000]
["2.1.1","Spłaty kredytów i pożyczaek zaciąganych na zadania finansowane z udziałem środków UE\n 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ń i gwarancji udzielanych samorządowym osobom prawnym realizującym zadania j.s.t. finansowane z udziałem środków UE i EFTA","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["G","Obciążenia związane z posiadanymi zobowiązaniami (bez poz. D2.1.1, D2.2.1, F1.1), z tego:",2925183,3424123,5276409,6165941,7578569,7165640,7225640,7065640,6905640,6248641,5625266,4180000,4020000,2870000,2800000,2700000]
[1,"Spłaty rat kredytów i pożyczek (D2.1 - D2.1.1)",2121275,2618486,3976409,5265941,5778569,5515640,5715640,5715640,5715640,5228641,4795266,3600000,3600000,2600000,2600000,2600000]
[2,"Spłaty odsetek od kredytów i pożyczek",803908,805637,1300000,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","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["H","Wskaźnik obsługi długu (G : A) w %",3.89,4.69,5.01,5.49,8.18,8.97,8.74,8.5,8.12,7.18,6.33,4.62,4.37,3.06,2.95,2.8]
["I","Łączna kwota długu na koniec roku budżetowego, z tego:",16728808,24978115,40730944,53465003,47686434,42170794,36455154,30739514,25023907,19795266,15000000,11400000,7800000,5200000,2600000,"-"]
[1,"Papiery wartościowe, w tym:","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["1.1","Papiery wartościowe wyemitowane na zadania finansowane z udziałem środków UE\n I EFTA","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2,"Kredyty i pożyczki, w tym:",15923573,23707353,40730944,53465003,47686434,42170794,36455154,30739514,25023907,19795266,15000000,11400000,7800000,5200000,2600000,"-"]
["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,"-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["J","Wskaźnik długu (I - I1.1 - I2.1) : A w %",22.27,34.2,38.71,47.58,51.47,52.79,44.1,36.96,29.42,22.73,16.88,12.59,8.47,5.55,2.74,"-"]
["K","Średnia arytmetyczna z osatnich trzech lat, o której mowa w art. 243 ustawy z 27 sierpnia 2009r.","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["L","Czy spełniony jest warunek, o którym mowa w art. 243 ustawy z 27 sierpnia 2009r. dla danego roku","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]