{"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 5 DO UCHWAŁY RADY MIEJSKIEJ W OSTRÓDZIE\nNR LVII/316/2010 Z  DNIA 30 SIERPNIA 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,105359177,107822941,85319769,75400640,77200640,79200640,81550607,84000641,86700266,89500500,92400000]
[" A","Dochody własne, w tym:",35052055,37907400,36100000,36700000,37300000,38100000,39000000,40050000,41300000,42600000,43900000,45200000]
["1","z opłat",15647013,15392200,15800000,16100000,16300000,16800000,17300000,17900000,18500000,19100000,19700000,20300000]
["2","z majątku jednostki",1916356,4515200,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,18817562,19100000,19500000,20000000,20600000,21200000,21900000,22600000,23400000,24200000,25000000]
["C ","Dotacje celowe",18119712,17561416,17600041,17700169,18100640,18500640,19000640,19600607,20100641,20700266,21400500,22200000]
["D ","Środki unijne",762329,31072799,35022900,11419600,"-","-","-","-","-","-","-","-"]
["II ","Wydatki ogółem",81631655,122755002,102557000,80541200,70885000,72485000,74485000,76835000,80072000,83205000,87200500,90100000]
["  II  A","Planowane do zaciągnięcia kredyty, pożyczki","-",21000000,"-","-","-","-","-","-","-","-","-","-"]
[" III   ","Spłata zobowiązań (A+B+C+D)",3424323,5276409,7265941,6548569,6035640,5995640,5715640,5515607,4488641,3855266,2500000,2400000]
[" A  ","Spłata zaciągniętych pożyczek, kredytów, w tym:",3424323,5276409,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,1300000,1000000,870000,720000,580000,400000,300000,160000,60000,"-","-"]
["B","Spłata przewidywanych pożyczek, kredytów w tym:","-","-",2900000,2800000,2700000,2800000,2700000,2600000,2500000,2600000,2500000,2400000]
["1","spłata pożyczek, kredytów krajowych","-","-",1900000,1900000,1900000,2100000,2100000,2100000,2100000,2300000,2300000,2300000]
["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","-","-",1000000,900000,800000,700000,600000,500000,400000,300000,200000,100000]
["C","Wartość udzielonych poręczeń","-","-","-","-","-","-","-","-","-","-","-","-"]
["D","Wykup papierów wartościowych","-","-","-","-","-","-","-","-","-","-","-","-"]
["IV","Wynik (I-II)",-8600290,17395825,5265941,4778569,4515640,4715640,4715640,4715607,3928641,3495266,2300000,2300000]
["V","Planowana łączna kwota długu, w tym:",23707353,40730944,35465003,30686434,26170794,21455154,16739514,12023907,8095266,4600000,2300000,"-"]
["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,38.66,32.89,35.97,34.71,27.79,21.14,14.74,9.64,5.31,2.57,"-"]
["VI   2 ","Spłaty kredytów, pożyczek do dochodów (%) (art. 169 ust. 1 u.f.p.)",4.69,5.01,6.74,7.68,8,7.77,7.22,6.76,5.34,4.45,2.79,2.6]
["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.)","-","-","-","-","-","-","-","-","-","-","-","-"]