{"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":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,9,0,13],[1,0,1,12],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,12]],"flags":["formulas_cached_only"]}
[{"$nulls":9},"ZAŁĄCZNIK NR 7 DO UCHWAŁY RADY MIEJSKIEJ W OSTRÓDZIE\nNR III / 8 / 2010 Z  DNIA 23 GRUDNIA 2010 ROKU"]
["PROGNOZOWANA SYTUACJA FINANSOWA GMINY W LATACH SPŁATY DŁUGU"]
[{"$nulls":13},"w złotych"]
["Lp","Wyszczególnienie"," Wykonanie za 2009 rok","Plan \nna 2010 rok","Lata spłaty kredytu/pożyczki"]
[{"$nulls":4},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
["I","Dochody ogółem: (A+B+C+D)",73031365,91001044,107822941,85319769,75400640,77200640,79200640,81550607,84000641,86700266,89500500,92400000]
[" A","Dochody własne, w tym:",35052055,37884520,36100000,36700000,37300000,38100000,39000000,40050000,41300000,42600000,43900000,45200000]
["1","z opłat",15647013,15459252,15800000,16100000,16300000,16800000,17300000,17900000,18500000,19100000,19700000,20300000]
["2","z majątku jednostki",1916356,4425200,1800000,1600000,1500000,1200000,1000000,800000,700000,700000,700000,700000]
["3 ","z udziału w podatkach budżetu państwa",17488686,18000000,18500000,19000000,19500000,20100000,20700000,21350000,22100000,22800000,23500000,24200000]
["B ","Subwencje",19097269,18852057,19100000,19500000,20000000,20600000,21200000,21900000,22600000,23400000,24200000,25000000]
["C ","Dotacje celowe",18119712,18724133,17600041,17700169,18100640,18500640,19000640,19600607,20100641,20700266,21400500,22200000]
["D ","Środki unijne",762329,15540334,35022900,11419600,"-","-","-","-","-","-","-","-"]
["II ","Wydatki ogółem",81631655,100814635,103157000,81141200,71485000,73285000,75285000,77635000,80672000,84005000,88000500,90900000]
["  II  A","Planowane do zaciągnięcia kredyty, pożyczki","-",13800000,"-","-","-","-","-","-","-","-","-","-"]
[" III   ","Spłata zobowiązań (A+B+C+D)",3424323,4976409,6272941,5598569,5128640,4931640,4693640,4536607,3752641,2953266,1632000,1534000]
[" A  ","Spłata zaciągniętych pożyczek, kredytów, w tym:",3424323,4976409,4365941,3748569,3335640,3195640,3015640,2915607,1988641,1255266,"-","-"]
["1","spłata pożyczek, kredytów krajowych",2618486,3976409,3365941,2878569,2615640,2615640,2615640,2615607,1828641,1195266,"-","-"]
["2","spłata pożyczek, kredytów zaciągniętych w związku ze środkami określonymi w umowie zawartej z podmiotem dysponującym\nz funduszami strukturalnymi lub F.S.U.E.","-","-","-","-","-","-","-","-","-","-","-","-"]
["3","odsetki",805837,1000000,1000000,870000,720000,580000,400000,300000,160000,60000,"-","-"]
["B","Spłata przewidywanych pożyczek, kredytów w tym:","-","-",1907000,1850000,1793000,1736000,1678000,1621000,1764000,1698000,1632000,1534000]
["1","spłata pożyczek, kredytów krajowych","-","-",1300000,1300000,1300000,1300000,1300000,1300000,1500000,1500000,1500000,1500000]
["2","spłata pożyczek, kredytów zaciągniętych w związku ze środkami określonymi w umowie zawartej z podmiotem dysponującym\nz funduszami strukturalnymi lub F.S.U.E.","-","-","-","-","-","-","-","-","-","-","-","-"]
["3","odsetki","-","-",607000,550000,493000,436000,378000,321000,264000,198000,132000,34000]
["C","Wartość udzielonych poręczeń","-","-","-","-","-","-","-","-","-","-","-","-"]
["D","Wykup papierów wartościowych","-","-","-","-","-","-","-","-","-","-","-","-"]
["IV","Wynik (I-II)",-8600290,-9813591,4665941,4178569,3915640,3915640,3915640,3915607,3328641,2695266,1500000,1500000]
["V","Planowana łączna kwota długu, w tym:",23707353,33530944,28865003,24686434,20770794,16855154,12939514,9023907,5695266,3000000,1500000,"-"]
["1","Dług zaciągniętej w związku ze środkami określonymi w umowie zawartej z podmiotem dysponującym z funduszami strukturalnymi \nlub F.S.U.E.","-","-","-","-","-","-","-","-","-","-","-","-"]
["VI   1 ","Dług/dochody (%) (art. 170 ust. 1 u.f.p.)",32.46,36.85,26.77,28.93,27.55,21.83,16.34,11.07,6.78,3.46,1.6800000000000002,"-"]
["VI   2 ","Spłaty kredytów, pożyczek do dochodów (%) (art. 169 ust. 1 u.f.p.)",4.69,5.47,5.82,6.56,6.8,6.39,5.93,5.56,4.47,3.41,1.82,1.66]
["VII  1 ","Dług/dochody po wyłączeniach (%) (art. 170 ust. 3 u.f.p.)","-","-","-","-","-","-","-","-","-","-","-","-"]
["VII  2 ","Spłaty kredytów, pożyczek do dochodów po wyłączeniach (%) (art. 169 ust. 3 u.f.p.)","-","-","-","-","-","-","-","-","-","-","-","-"]