{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Zał_nr_1_wydr"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"Zał_nr_1_wydr","index":0,"n_rows":56,"n_cols":33,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,20,5,20],[4,29,5,29],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,19,5,19],[4,21,5,21],[4,22,5,22],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,7,4,8],[0,20,0,29],[58,19,58,29],[1,1,1,29],[3,1,4,1],[3,2,4,2],[56,19,56,29],[3,3,3,29],[4,5,4,6],[4,3,5,3],[4,4,5,4],[4,23,5,23],[4,24,5,24],[4,25,5,25],[4,26,5,26],[4,27,5,27],[4,28,5,28]],"flags":["formulas_cached_only"]}
[{"$nulls":20},"Załącznik Nr 1"]
[null,"Realizacja w I półroczu 2012 r. Wieloletniej Prognozy Finansowej  dla Gminy Mrągowo na lata 2012–2031"]
[]
[null,"Lp.","Wyszczególnienie","Lata objęte prognozą finansową"]
[null,null,null,"Rok budżetowy  2009 - wykonanie","Rok budżetowy  2010 - wykonanie","Rok budżetowy  2011",null,"Rok budżetowy  2012",null,"Rok 2013","Rok 2014","Rok 2015","Rok 2016","Rok 2017","Rok 2018","Rok 2019","Rok 2020","Rok 2021","Rok 2022","Rok 2023","Rok 2024","Rok 2025","Rok 2026","Rok 2027","Rok 2028","Rok 2029","Rok 2030","Rok 2031","Rok 2032","Rok 2032"]
[{"$nulls":5},"Plan","Wykonanie","Plan","Wykonanie"]
[null,1,"Dochody ogółem, z tego:",17909266.04,19208868.64,20643419.76,20032850.709999997,26350277.76,11711997.66,26400000,23147600,22050000,22150000,22250000,22300000,22000000,21900000,22200000,22344630,22400000,22600000,22800000,23000000,23200000,23300000,23400000,23500000,23800000,24150000,24550000]
[null,"a","dochody bieżące",17307564.66,18752439.72,19632189.76,19142269.83,21229160.1,10988727.7,21350000,21500000,21700000,21800000,21900000,21950000,21650000,21850000,22150000,22294630,22350000,22550000,22750000,22950000,23150000,23250000,23350000,23450000,23750000,24100000,24500000]
[null,"b","dochody majątkowe, w tym:",601701.38,456428.92,1011230,890580.88,5121117.66,723269.96,5050000,1647600,350000,350000,350000,350000,350000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,"c"," ze sprzedaży majątku",201834.78,151893.39,315431,220163.11,950000,21434.61,350000,350000,150000,150000,150000,150000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,2,"Wydatki bieżące (bez odsetek i prowizji od kredytów oraz wyemitowanych papierów wartościowych, czyli kosztów obsługi długu), w tym:",16355695.58,17392429.69,19114189.76,18466770.02,19753673.1,9888634.22,18505000,18580063,18650000,18833700,19000000,19000000,19100000,19250000,19300000,19430000,19520000,19620000,19800000,19900000,20000000,20200000,20300000,20400000,20500000,20600000,20700000]
[null,"a","na wynagrodzenia i składki od nich naliczane",6670357.23,7095686.24,7654685.41,7476026.03,8206554,4371373.79,8300000,8400000,8500000,8600000,8700000,8800000,8900000,9000000,9200000,9400000,9600000,9800000,10100000,10200000,10300000,10300000,10300000,10300000,10400000,10500000,10600000,null," "]
[null,"b","na funkcjonowanie organów JST, w tym:",2144590.98,2073779.44,2375327,2268353.44,2983742,1389021.43,2850000,2900000,2900000,3000000,3200000,3400000,3600000,3800000,4000000,4200000,4300000,4400000,4500000,4500000,4500000,4500000,4500000,4500000,4600000,4600000,4600000]
[null,"c","z tytułu gwarancji i poręczeń, w tym:",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"d","gwarancje i poręczenia podlegające wyłączeniu z limitów spłaty zobowiązań",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"e","wydatki bieżące objęte limitem na przedsięwzięcia",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,"Wynik budżetu po zaplanowaniu wydatków bieżących (bez obsługi długu)  poz.1– poz. 2",1553570.459999999,1816438.9499999993,1529230,1566080.6899999976,6596604.66,1823363.4399999995,7895000,4567537,3400000,3316300,3250000,3300000,2900000,2650000,2900000,2914630,2880000,2980000,3000000,3100000,3200000,3100000,3100000,3100000,3300000,3550000,3850000]
[null,4,"Nadwyżka budżetowa z lat ubiegłych + wolne środki, w tym:",226000,243639.01,601656,601656.54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"a","nadwyżka budżetowa z lat ubiegłych + wolne środki angażowane na pokrycie deficytu budżetu roku bieżącego",226000,243639.01,601656,601656.54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"Inne przychody niezwiązane z zaciągnięciem długu",0,0,47461,47461,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,"Środki do dyspozycji (suma poz. 3 +poz. 4+ poz. 5)",1779570.459999999,2060077.9599999993,2178347,2215198.2299999977,6596604.66,1823363.4399999995,7895000,4567537,3400000,3316300,3250000,3300000,2900000,2650000,2900000,2914630,2880000,2980000,3000000,3100000,3200000,3100000,3100000,3100000,3300000,3550000,3850000]
[null,7,"Spłata i obsługa długu, z tego:",1767633.75,1660269.28,2219196,2019191.88,3862358.66,982011.8,3720130,1500000,2000000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2250000,2250000,1236324,0,0]
[null,"a","rozchody z tytułu spłaty rat kapitałowych oraz wykupu papierów wartościowych ",1364000,1208000,1716000,1516000,3212358.66,671169.64,3220130,1000000,1500000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1750000,1750000,936324,0,0]
[null,"b","wydatki bieżące na obsługę długu:",403633.75,404808.41,503196,503191.88,650000,310842.16,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,300000,0,0]
[null,8,"Inne rozchody (bez spłaty długu)",0,47460.87,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,"Środki do dyspozycji na wydatki majątkowe (poz. 6–poz. 7–poz. 8)",11936.709999999031,352347.80999999924,-40849,196006.34999999776,2734246,841351.6399999994,4174870,3067537,1400000,1216300,1150000,1200000,800000,550000,800000,814630,780000,880000,900000,1000000,1100000,1000000,850000,850000,2063676,3550000,3850000]
[null,10,"Wydatki majątkowe, w tym:",1676414.51,2349586,3907614,3056704.27,8893167,2422637.27,6895000,3197537,2386463,2768340,2393500,2343880,2746500,2090380,2100000,1800000,1800000,1800000,1800000,1800000,1100000,1000000,850000,850000,2063676,3550000,3850000]
[null,"a","wydatki majątkowe objęte limitem",1676414.51,2349586,9165500,3056704.27,7354937,2422637.27,6443914,2627537,1813963,2286500,1870500,2028750,2553500,1597380,1200000,1199630,0,0,0,0,0,0,0,0,0,0,0,null,null,45621452.54]
[null,11,"Przychody z kredytów, pożyczek i emisji obligacji",1961000,2066000,3948463,2839628.66,6158921,1900812.18,2720130,130000,986463,1552040,1243500,1143880,1946500,1540380,1300000,985370,1020000,920000,900000,800000,0,0,0,0,0,0,0]
[null,12,"Wynik finansowy budżetu (poz. 9 – poz.10 + poz. 11)",296522.199999999,68761.80999999912,0,-21069.260000002105,0,319526.54999999935,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,13,"Kwota długu na koniec roku, w tym:",8790000,9648000,11880463,10971628.66,13918191,12201271.2,13418191,12548191,12034654,11986694,11630194,11174074,11520574,11460954,11160954,10546324,9966324,9286324,8586324,7786324,6186324,4586324,2836324,1086324,150000,150000,150000]
[null,"a","łączna kwota wyłączeń z art. 243 ust. 3 pkt 1 ufp oraz art. 170 ust. 3 sufp",0,0,1377130,294498.66,1500000,499931,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"b","kwota wyłączeń z art. 243 ust. 3 pkt 1 ufp oraz art. 170 ust. 3 sufp przypadająca na dany rok budżetowy",0,0,0,0,1294498.66,111169.64,500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,14,"Kwota zobowiązań związku współtworzonego przez jst przypadających do spłaty w danym roku budżetowym podlegających do doliczenia z art. 244 ufp",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,15,"Planowana łączna kwota spłaty zobowiązań",9.869939650525177,8.643243447158062,10.750137456876475,9.781285772779343,14.66,3.3048689958097808,14.09,6.480153450033697,9.070294784580499,9.480812641083523,9.438202247191011,9.417040358744394,9.545454545454547,9.58904109589041,9.45945945945946,9.398231252878208,9.375,9.29203539823009,9.210526315789473,9.130434782608695,9.051724137931034,9.012875536480687,9.615384615384617,8.72,6.89,0,0]
[null,"a","Maksymalny dopuszczalny wskaźnik spłaty z art.. 243 ",15,15,15,15,15,15,5.59,7.06,9.46,11.473214165711443,12.007682437595065,11.839103421823747,11.49,10.74,10.19,10.057872318146293,10.478157490318157,10.74737362426032,10.80158712980126,10.854454536045127,11.080903811407445,11.30239704709049,11.367025714610506,11.302613476285224,11.111246393868985,11.59332763838396,10.80158712980126]
[null,16,"Spełnienie wskaźnika spłaty z art. 243 po uwzględnieniu art.. 244","Zgodny/ niezgodny","Zgodny/ niezgodny","Zgodny/ niezgodny","Zgodny/ niezgodny","Zgodny/ niezgodny","Zgodny/ niezgodny","Niezgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny"]
[null,17,"Planowana łączna kwota spłaty zobowiązań/dochody ogółem /max 15% art.. 169 sufp/",9.869939650525176,8.643243447158062,10.750137456876475,9.781285772779345,14.66,3.3,14.09,6.48,9.07,9.48,9.44,9.42,9.55,9.59,9.46,9.4,9.38,9.29,9.21,9.13,9.05,9.01,9.62,8.72,6.89,0,0]
[null,18,"Zadłużenie/dochody ogółem (poz. 13-poz. 13a):poz. 1 /max. 60% art.. 170 sufp/",49.080738319301894,50.22679982260527,50.87981120430406,51.721711441864315,53.01,46.3,51.79,55.31,55.73,55.26,53.41,51.25,53.52,53.49,51.42,48.34,45.63,42.22,38.77,34.96,27.76,20.78,13.21,5.7,0,0,0]
[null,19,"Wydatki bieżące razem (poz. 2 + poz. 7b)",16759329.33,17797238.1,19617385.76,18969961.9,20403673.1,10199476.38,19005000,19080063,19150000,19333700,19500000,19500000,19600000,19750000,19800000,19930000,20020000,20120000,20300000,20400000,20500000,20700000,20800000,20900000,20800000,20600000,20700000]
[null,20,"Wydatki ogółem (poz. 10+ poz. 19)",18435743.84,20146824.1,23524999.76,22026666.169999998,29296840.1,12622113.65,25900000,22277600,21536463,22102040,21893500,21843880,22346500,21840380,21900000,21730000,21820000,21920000,22100000,22200000,21600000,21700000,21650000,21750000,22863676,24150000,24550000]
[null,21,"Wynik budżetu (poz. 1 – poz. 20)",-526477.8000000007,-937955.4600000009,-2881580,-1993815.460000001,-2946562.34,-910115.9900000002,500000,870000,513537,47960,356500,456120,-346500,59620,300000,614630,580000,680000,700000,800000,1600000,1600000,1750000,1750000,936324,0,0]
[null,22,"Przychody budżetu",2187000,2309639.01,4550119,3441285.2,6158921,1900812.18,2720130,130000,986463,1552040,1243500,1143880,1946500,1540380,1300000,985370,1020000,920000,900000,800000,0,0,0,0,0,0,0]
[null,23,"Rozchody budżetu (poz. 7a + poz. 8)",1364000,1208000,1716000,1516000,3212358.66,671169.64,3220130,1000000,1500000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1600000,1750000,1750000,936324,0,0]
[{"$nulls":5},2834119,null,null,1229642.54,-500000,-870000,-513537,-47960,-356500,-456120,346500,-59620,-300000,-614630]
[]
[null,null,"Wydatki ogółem",18435743.84,20146824.1,28782885.76,22026666.169999998,27758610.1,12622113.65,25448914,21707600,20963963,21620200,21370500,21528750,22153500,21347380,21000000,21129630,20020000,20120000,20300000,20400000,20500000,20700000,20800000,20900000,20800000,20600000,20700000]
[null,null,"Dochody ogółem",17909266.04,19208868.64,20643419.76,20032850.709999997,26350277.76,11711997.66,26400000,23147600,22050000,22150000,22250000,22300000,22000000,21900000,22200000,22344630,22400000,22600000,22800000,23000000,23200000,23300000,23400000,23500000,23800000,24150000,24550000]
[null,null,"planowana spłata w danym roku – spłata UE",1767633.75,1660269.28,2219196,2019191.88,2567860,870842.16,3220130,1500000,2000000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2100000,2250000,2250000,1236324,0,0]
[null,null,"Kwota długu na koniec roku,",8790000,9648000,10503333,10677130,12418191,12201271.2,13418191,12548191,12034654,11986694,11630194,11174074,11520574,11460954,11160954,10546324,9966324,9286324,8586324,7786324,6186324,4586324,2836324,1086324,150000,150000,150000]
[null,null,"planowana spłata  do dochodów",0.09869939650525177,0.08643243447158062,0.10750137456876475,0.10079403621732477,0.09745096516204617,0.07435470747865569,12.197462121212121,6.480153450033697,9.070294784580499,9.480812641083523,9.438202247191011,9.417040358744394,9.545454545454547,9.58904109589041,9.45945945945946,9.398231252878208,9.375,9.29203539823009,9.210526315789473,9.130434782608695,9.051724137931034,9.012875536480687,9.615384615384617,9.574468085106384,5.194638655462184,0,0]
[]
[null,null,"dochody bieżące + dochody ze sprzedaży maj.",17509399.44,18904333.11,19947620.76,19362432.939999998,22179160.1,11010162.309999999,21700000,21850000,21850000,21950000,22050000,22100000,21700000,21900000,22200000,22344630,22400000,22600000,22800000,23000000,23200000,23300000,23400000,23500000,23800000,24150000,24550000]
[null,null,"dochody bieżące – wydatki bieżące – odsetki",750070.1100000013,1107095.0099999981,330235,392471.03999999806,1775487,810685.9299999981,2695000,2769937,2700000,2616300,2550000,2600000,2100000,2150000,2400000,2414630,2380000,2480000,2500000,2600000,2700000,2600000,2600000,2600000,3000000,3550000,3850000]
[null,null,null,0.041881677804368654,0.05763457654630503,0.015997107254481367,0.01959137247521564,0.06738020054935466,0.0692184163226684,0.10208333333333333,0.11966411204617325,0.12244897959183673,0.11811738148984198,0.1146067415730337,0.11659192825112108,0.09545454545454546,0.09817351598173515,0.10810810810810811,0.10806310061970147,0.10625,0.10973451327433628,0.10964912280701754,0.11304347826086956,0.11637931034482758,0.11158798283261803,0.1111111111111111,0.11063829787234042,0.12605042016806722,0.14699792960662525,0.15682281059063136]
[null,null,null,"x","x","x","x","x","x",4.881478844806302,6.363104071040579,9.637588197628705,11.473214165711443,12.007682437595065,11.839103421823745,11.643868377133224,10.888440509290007,10.34066632291339,10.057872318146291,10.478157490318159,10.801587129801257,10.854454536045127,11.080903811407445,11.30239704709049,11.367025714610504,11.302613476285224,11.111246393868985,11.593327638383958,12.789554921567762,12.42691079549892]