{"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 1 DO ZARZĄDZENIA NR 16 / 2011\n BURMISTRZA MIASTA OSTRÓDY Z  DNIA 26 STYCZNIA 2011 ROKU\n"]
["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,91395288,110108967,100613676,83427250,82673600,83167900,85063000,87081400,88869000,90567200,92058700,93676590,94900000,96300000]
[1,"Dochody bieżące",69590499,70141066,71927633,71728279,76669060,80642250,81163600,83167900,85063000,85081400,85869000,86567200,88058700,88676590,89900000,91300000]
[2,"Dochody majątkowe, w tym:",5521507,2890299,19467655,38380688,23944616,2785000,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,101208879,126803031,97477167,78411610,77657960,78152260,80047360,82552759,84983734,86467200,87458700,90576590,91700000,93100000]
[1,"Wydatki bieżące",61650702,66774092,72319960,71528279,73000113,73369610,73957960,74452260,75347360,76852759,77583734,78467200,79458700,80176590,81500000,82700000]
[2,"Wydatki majątkowe",17689640,14857563,28888919,55274752,24477054,5042000,3700000,3700000,4700000,5700000,7400000,8000000,8000000,10400000,10200000,10400000]
["C","Wyniki budżetu (A-B)",-4228336,-8600290,-9813591,-16694064,3136509,5015640,5015640,5015640,5015640,4528641,3885266,4100000,4600000,3100000,3200000,3200000]
["D","Finansowanie (D.1 - D.2)",5451356,9006800,9813591,16694064,-3136509,-5015640,-5015640,-5015640,-5015640,-4528641,-3885266,4100000,4600000,3100000,3200000,3200000]
[1,"Przychody ogółem, z tego:",7572631,11625286,13800000,21360005,2042060,"-","-","-","-","-","-","-","-","-","-","-"]
["1.1","Kredyty i pożyczki, w tym:",5499222,10402266,13800000,21000000,2000000,"-","-","-","-","-","-","-","-","-","-","-"]
["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,"-",360005,42060,"-","-","-","-","-","-","-","-","-","-","-"]
["1.7","Inne źródła",2073409,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2,"Rozchody ogółem, z tego:",2121275,2618486,3986409,4665941,5178569,5015640,5015640,-5015640,5015607,"-","-",4100000,4600000,3100000,3200000,3200000]
["2.1","Spłaty kredytów i pożyczek, w tym:",2121275,2618486,3986409,4665941,5178569,5015640,5015640,5015640,5015607,4528641,3885266,4100000,4600000,3100000,3200000,3200000]
["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,4986409,5565941,6978569,6665640,6525640,6365640,6205640,5548641,4715266,4680000,5020000,3370000,3400000,3300000]
[1,"Spłaty rat kredytów i pożyczek (D2.1 - D2.1.1)",2121275,2618486,3986409,4665941,5178569,5015640,5015640,5015640,5015640,4528641,3885266,4100000,4600000,3100000,3200000,3200000]
[2,"Spłaty odsetek od kredytów i pożyczek",803908,805637,1000000,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.46,5.05,6.94,7.99,7.89,7.65,7.3,6.37,5.31,5.17,5.45,3.6,3.58,3.43]
["I","Łączna kwota długu na koniec roku budżetowego, z tego:",16728808,24978115,33520944,49855003,46676434,41660794,36645154,31629514,26613907,22085266,18200000,14100000,9500000,6400000,3200000,"-"]
[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,33520944,49855003,46676434,41660794,36645154,31629514,26613907,22085266,18200000,14100000,9500000,6400000,3200000,"-"]
["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,36.68,45.28,46.39,49.94,44.33,38.03,31.29,25.36,13.73,15.57,10.32,6.88,3.37,"-"]
["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","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]