{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["doc1"],"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":"doc1","index":0,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,11,1,20],[2,0,2,20],[3,19,4,20],[5,0,5,2],[5,3,5,8],[5,12,5,14],[5,15,5,18],[6,0,6,2],[6,3,6,8],[6,12,6,14],[6,15,6,18],[7,0,7,2],[7,3,7,8],[7,12,7,14],[7,15,7,18],[8,0,8,2],[8,3,8,8],[8,12,8,14],[8,15,8,18],[9,0,9,2],[9,3,9,8],[9,12,9,14],[9,15,9,18],[10,0,10,2],[10,3,10,8],[10,12,10,14],[10,15,10,18],[11,0,11,2],[11,3,11,8],[11,12,11,14],[11,15,11,18],[12,0,12,2],[12,3,12,8],[12,12,12,14],[12,15,12,18],[13,0,13,2],[13,3,13,8],[13,12,13,14],[13,15,13,18],[14,0,14,2],[14,3,14,8],[14,12,14,14],[14,15,14,18],[15,0,15,2],[15,3,15,8],[15,12,15,14],[15,15,15,18],[16,0,16,2],[16,3,16,8],[16,12,16,14],[16,15,16,18],[17,0,17,2],[17,3,17,8],[17,12,17,14],[17,15,17,18],[18,0,18,2],[18,3,18,8],[18,12,18,14],[18,15,18,18],[19,0,19,2],[19,3,19,8],[19,12,19,14],[19,15,19,18],[20,0,20,2],[20,3,20,8],[20,12,20,14],[20,15,20,18],[21,0,21,2],[21,3,21,8],[21,12,21,14],[21,15,21,18],[22,0,22,2],[22,3,22,8],[22,12,22,14],[22,15,22,18],[23,0,23,2],[23,3,23,8],[23,12,23,14],[23,15,23,18],[24,0,24,2],[24,3,24,8],[24,12,24,14],[24,15,24,18],[25,0,25,2],[25,3,25,8],[25,12,25,14],[25,15,25,18],[26,0,26,2],[26,3,26,8],[26,12,26,14],[26,15,26,18],[27,0,27,2],[27,3,27,8],[27,12,27,14],[27,15,27,18],[28,0,28,2],[28,3,28,8],[28,12,28,14],[28,15,28,18],[29,0,29,2],[29,3,29,8],[29,12,29,14],[29,15,29,18],[30,0,30,2],[30,3,30,8],[30,12,30,14],[30,15,30,18],[31,0,31,2],[31,3,31,8],[31,12,31,14],[31,15,31,18],[32,0,32,2],[32,3,32,8],[32,12,32,14],[32,15,32,18],[33,0,33,2],[33,3,33,8],[33,12,33,14],[33,15,33,18],[34,0,34,2],[34,3,34,8],[34,12,34,14],[34,15,34,18],[35,0,35,2],[35,3,35,8],[35,12,35,14],[35,15,35,18],[36,0,36,2],[36,3,36,8],[36,12,36,14],[36,15,36,18],[37,0,37,2],[37,3,37,8],[37,12,37,14],[37,15,37,18],[38,0,38,2],[38,3,38,8],[38,12,38,14],[38,15,38,18],[39,0,39,2],[39,3,39,8],[39,12,39,14],[39,15,39,18],[40,0,40,2],[40,3,40,8],[40,12,40,14],[40,15,40,18],[41,0,41,2],[41,3,41,8],[41,12,41,14],[41,15,41,18],[42,0,42,2],[42,3,42,8],[42,12,42,14],[42,15,42,18],[43,0,43,2],[43,3,43,8],[43,12,43,14],[43,15,43,18]],"flags":["formulas_cached_only"]}
[{"$nulls":11},"ZAŁĄCZNIK NR 1 DO UCHWAŁY RADY MIEJSKIEJ W OSTRÓDZIE \nNR VIII / 38 / 2011 Z DNIA 19 KWIETNIA  2011 ROKU"]
[]
["                        WIELOLETNIA PROGNOZA FINANSOWA \n                        DLA MIASTA OSTRÓDY NA LATA 2011 – 2014"]
[{"$nulls":19},"w złotych"]
[]
["L.p.",null,null,"Wyszczególnienie",{"$nulls":5},"Wykonanie 2008","Wykonanie 2009","Wykonanie 2010","Prognoza 2011",null,null,"Prognoza 2012",null,null,null,"Prognoza 2013","Prognoza 2014"]
["1",null,null,"Dochody ogółem, z tego:",{"$nulls":5},"75 112 006,00","73 031 365,00","83 689 076,00","111 738 780,50",null,null,"101 613 676,00",null,null,null,"84 027 250,00","82 673 600,00"]
["1a",null,null," dochody bieżące",{"$nulls":5},"69 590 499,00","70 141 066,00","71 590 152,00","73 358 092,50",null,null,"77 169 060,00",null,null,null,"80 942 250,00","81 163 600,00"]
["1b",null,null," dochody majątkowe, w tym",{"$nulls":5},"5 521 507,00","2 890 299,00","12 098 924,00","38 380 688,00",null,null,"24 444 616,00",null,null,null,"3 085 000,00","1 510 000,00"]
["1c",null,null,"  ze sprzedaży majątku",{"$nulls":5},"2 199 816,00","1 392 800,06","3 735 562,00","2 464 000,00",null,null,"4 610 000,00",null,null,null,"1 585 000,00","1 510 000,00"]
["2",null,null,"Wydatki bieżące (bez odsetek i prowizji od: kredytów i pożyczek oraz wyemitowanych papierów wartościowych), w tym:",{"$nulls":5},"60 846 794,00","65 968 455,00","70 153 991,00","72 258 092,50",null,null,"70 492 162,00",null,null,null,"70 519 610,00","72 447 960,00"]
["2a",null,null," na wynagrodzenia i składki od nich naliczane",{"$nulls":5},"0,00","0,00","30 019 256,00","32 441 134,00",null,null,"32 486 676,00",null,null,null,"32 786 676,00","33 136 676,00"]
["2b",null,null," związane z funkcjonowaniem JST",{"$nulls":5},"60 846 794,00","65 968 455,00","40 134 735,00","38 716 722,50",null,null,"36 980 060,00",null,null,null,"38 932 934,00","39 311 284,00"]
["2c",null,null," z tytułu gwarancji i poręczeń, w tym:",{"$nulls":5},"0,00","0,00","0,00","0,00",null,null,"0,00",null,null,null,"0,00","0,00"]
["2d",null,null,"  gwarancje i poręczenia podlegające wyłączeniu z limitów spłaty zobowiązań z art. 243 ufp/169sufp",{"$nulls":5},"0,00","0,00","0,00","0,00",null,null,"0,00",null,null,null,"0,00","0,00"]
["2e",null,null," wydatki bieżące objęte limitem art. 226 ust. 4 ufp",{"$nulls":5},"0,00","0,00","0,00","1 100 236,00",null,null,"1 033 426,00",null,null,null,"0,00","0,00"]
["3",null,null,"Różnica (1-2)",{"$nulls":5},"14 265 212,00","7 062 910,00","13 535 085,00","39 480 688,00",null,null,"31 121 514,00",null,null,null,"13 507 640,00","10 225 640,00"]
["4",null,null,"Nadwyżka budżetowa z lat ubiegłych plus wolne środki, zgodnie z art. 217 ufp, w tym:",{"$nulls":5},"2 073 409,00","1 223 020,00","0,00","360 005,00",null,null,"42 060,00",null,null,null,"5 015 640,00","5 015 640,00"]
["4a",null,null," nadwyżka budżetowa z lat ubiegłych plus wolne środki, zgodnie z art. 217 ufp, angażowane na pokrycie deficytu budżetu roku bieżącego",{"$nulls":5},"2 073 409,00","1 223 020,00","0,00","360 005,00",null,null,"42 060,00",null,null,null,"5 015 640,00","5 015 640,00"]
["5",null,null,"Inne przychody nie związane z zaciągnięciem długu",{"$nulls":5},"0,00","0,00","0,00","0,00",null,null,"0,00",null,null,null,"0,00","0,00"]
["6",null,null,"Środki do dyspozycji (3+4+5)",{"$nulls":5},"16 338 621,00","8 285 930,00","13 535 085,00","39 840 693,00",null,null,"31 163 574,00",null,null,null,"18 523 280,00","15 241 280,00"]
["7",null,null,"Spłata i obsługa długu, z tego:",{"$nulls":5},"2 925 183,00","3 424 123,00","4 926 971,00","5 565 941,00",null,null,"6 978 569,00",null,null,null,"6 665 640,00","6 525 640,00"]
["7a",null,null," rozchody z tytułu spłaty rat kapitałowych oraz wykupu papierów wartościowych",{"$nulls":5},"2 121 275,00","2 618 486,00","3 976 409,00","4 665 941,00",null,null,"5 178 569,00",null,null,null,"5 015 640,00","5 015 640,00"]
["7b",null,null," wydatki bieżące na obsługę długu",{"$nulls":5},"803 908,00","805 637,00","950 562,00","900 000,00",null,null,"1 800 000,00",null,null,null,"1 650 000,00","1 510 000,00"]
["8",null,null,"Inne rozchody (bez spłaty długu np. udzielane pożyczki)",{"$nulls":5},"0,00","0,00","0,00","0,00",null,null,"0,00",null,null,null,"0,00","0,00"]
["9",null,null,"Środki do dyspozycji (6-7-8)",{"$nulls":5},"13 413 438,00","4 861 807,00","8 608 114,00","34 274 752,00",null,null,"24 185 005,00",null,null,null,"11 857 640,00","8 715 640,00"]
["10",null,null,"Wydatki majątkowe, w tym:",{"$nulls":5},"17 689 640,00","14 857 563,00","22 274 986,00","55 274 752,00",null,null,"24 485 005,00",null,null,null,"5 042 000,00","3 700 000,00"]
["10a",null,null," wydatki majątkowe objęte limitem art. 226 ust. 4 ufp",{"$nulls":5},"0,00","0,00","0,00","17 258 347,00",null,null,"23 685 005,00",null,null,null,"5 042 000,00","0,00"]
["11",null,null,"Przychody (kredyty, pożyczki, emisje obligacji)",{"$nulls":5},"5 499 222,00","10 402 266,00","13 800 000,00","21 000 000,00",null,null,"300 000,00",null,null,null,"0,00","0,00"]
["12",null,null,"Rozliczenie budżetu (9-10+11)",{"$nulls":5},"1 223 020,00","406 510,00","133 128,00","0,00",null,null,"0,00",null,null,null,"6 815 640,00","5 015 640,00"]
["13",null,null,"Kwota długu, w tym:",{"$nulls":5},"15 923 573,00","23 707 353,00","33 530 944,00","49 855 003,00",null,null,"44 986 434,00",null,null,null,"39 970 794,00","34 955 154,00"]
["13a",null,null," łączna kwota wyłączeń z art. 243 ust. 3 pkt 1 ufp oraz art. 170 ust. 3 sufp",{"$nulls":5},"0,00","0,00","0,00","0,00",null,null,"0,00",null,null,null,"0,00","0,00"]
["13b",null,null," kwota wyłączeń z art. 243 ust. 3 pkt 1 ufp oraz art. 170 ust. 3 sufp przypadająca na dany rok budżetowy",{"$nulls":5},"0,00","0,00","0,00","0,00",null,null,"0,00",null,null,null,"0,00","0,00"]
["14",null,null,"Kwota zobowiązań związku współtworzonego przez jst przypadających do spłaty w danym roku budżetowym podlegająca doliczeniu zgodnie z art. 244 ufp",{"$nulls":5},"0,00","0,00","0,00","53 900,00",null,null,"53 900,00",null,null,null,"53 900,00","53 900,00"]
["15",null,null,"Planowana łączna kwota spłaty zobowiązań",{"$nulls":5},"3,89%","4,69%","5,89%","5,02%",null,null,"6,87%",null,null,null,"7,93%","7,89%"]
["15a",null,null,"Maksymalny dopuszczalny wskaźnik spłaty z art. 243 ufp",{"$nulls":5},"0,00%","0,00%","0,00%","8,35%",null,null,"4,65%",null,null,null,"5,59%","8,02%"]
["16",null,null,"Spełnienie wskaźnika spłaty z art. 243 ufp po uwzględnieniu art. 244 ufp",{"$nulls":5},"TAK","TAK","TAK","TAK",null,null,"NIE",null,null,null,"NIE","TAK"]
["17",null,null,"Planowana łączna kwota spłaty zobowiązań do dochodów ogółem -max 15% z art. 169 sufp",{"$nulls":5},"3,89%","4,69%","5,89%","5,02%",null,null,"6,87%",null,null,null,"7,93%","7,89%"]
["18",null,null,"Zadłużenie/dochody ogółem [(13–13a):1] - max 60% z art. 170 sufp",{"$nulls":5},"21,20%","32,46%","40,07%","44,93%",null,null,"44,27%",null,null,null,"47,57%","42,28%"]
["19",null,null,"Wydatki bieżące razem (2 + 7b)",{"$nulls":5},"61 650 702,00","66 774 092,00","71 104 553,00","73 158 092,50",null,null,"72 292 162,00",null,null,null,"72 169 610,00","73 957 960,00"]
["20",null,null,"Wydatki ogółem (10+19)",{"$nulls":5},"79 340 342,00","81 631 655,00","93 379 539,00","128 432 844,50",null,null,"96 777 167,00",null,null,null,"77 211 610,00","77 657 960,00"]
["21",null,null,"Wynik budżetu (1 - 20)",{"$nulls":5},"-4 228 336,00","-8 600 290,00","-9 690 463,00","-16 694 064,00",null,null,"4 836 509,00",null,null,null,"6 815 640,00","5 015 640,00"]
["22",null,null,"Przychody budżetu (4+5+11)",{"$nulls":5},"7 572 631,00","11 625 286,00","13 800 000,00","21 360 005,00",null,null,"342 060,00",null,null,null,"5 015 640,00","5 015 640,00"]
["23",null,null,"Rozchody budżetu (7a + 8)",{"$nulls":5},"2 121 275,00","2 618 486,00","3 976 409,00","4 665 941,00",null,null,"5 178 569,00",null,null,null,"5 015 640,00","5 015 640,00"]