{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Zał_nr_1_wydr"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"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":"Zał_nr_1_wydr","index":0,"n_rows":65,"n_cols":23,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,15,64,22],[8,2,8,22],[2,19,2,22],[5,19,5,22],[6,0,6,19],[8,0,9,0],[8,1,9,1],[0,19,0,22],[4,20,4,22],[1,20,1,22],[3,15,3,22]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":20},"Załącznik nr 1"]
[{"$nulls":19},"do uchwały Rady Gminy Mrągowo nr XXXIX/302/17"]
[{"$nulls":15},"w sprawie: zmiany  uchwalenia Wieloletniej Prognozy Finansowej Gminy Mrągowo na lata 2017-2030"]
[{"$nulls":20},"z dnia 13 września 2017 r."]
[]
["Wieloletnia Prognoza Finansowa  dla Gminy Mrągowo na lata 2017–2030"]
[{"$nulls":15},27167489,26998879,27123949,27076509]
["Lp.","Wyszczególnienie","Lata objęte prognozą finansową"]
[null,null,"Rok budżetowy  2009 - wykonanie","Rok budżetowy  2011 -wykonanie","Rok budżetowy  2012 -wykonanie","Rok budżetowy  2013 -wykonanie","Rok budżetowy  2014 -wykonanie","Rok budżetowy  2015 -wykonanie","Rok budżetowy  2016 -wykonanie","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"]
[1,"Dochody ogółem, z tego:",17909266.04,20032850.709999997,23727549.69,26464074.830000002,23571209.900000002,26393226.689999998,31638848.46,33488642.75,34098423,34102334,34114205,33877723,33327586,30910941,30852031,30700000,30800000,30850000,30850000,30850000,30895496]
["a","dochody bieżące",17307564.66,19142269.83,22454278.53,22644718.6,23299273.01,24649716.99,30005599.45,32202768.11,30990931,30958329,30950000,30906000,31101606,30860941,30802031,30650000,30750000,30800000,30800000,30800000,30845496]
["b","dochody majątkowe, w tym:",601701.38,890580.88,1273271.16,3819356.23,271936.89,1743509.7,1633249.01,1285874.64,3107492,3144005,3164205,2971723,2225980,50000,50000,50000,50000,50000,50000,50000,50000]
["c"," ze sprzedaży majątku",201834.78,220163.11,43875.61,142472.2,184317.65,249409.7,1595442.72,570000,694305,500000,250000,250000,250000,50000,50000,50000,50000,50000,50000,50000,50000]
[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,18466770.02,20908182.03,20494079.22,21639639.75,21943801.47,27479128.73,29691745.75,27400000,26400000.32,26937013,27143053,26899999,26782000,26720000,26920000,26920000,26900000,26850000,26800000,26800000]
["a","na wynagrodzenia i składki od nich naliczane",6670357.23,7563671.96,8249756.91,7885108.03,8137729.42,8588471.9,8796292.84,9174600.1,9700000,9800000,9900000,10000000,10100000,10200000,10300000,10400000,10500000,10600000,10700000,10800000,10900000]
["b","na funkcjonowanie organów JST, w tym:",2144590.98,2268353.44,2856326.28,2713500.3,2757860.2,2799504.73,3074700.67,4495137.63,4300000,4300000,4400000,4500000,4600000,4700000,4800000,4900000,5000000,5100000,5200000,5300000,5560000]
["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]
["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]
["e","wydatki bieżące objęte limitem na przedsięwzięcia",0,0,0,0,0,9100,592480,560260,568160,234360,0,0,0,0,0,0,0,0,0,0,0]
[3,"Wynik budżetu po zaplanowaniu wydatków bieżących (bez obsługi długu)  poz.1– poz. 2",1553570.459999999,1566080.6899999976,2819367.66,5969995.610000003,1931570.1500000022,4449425.219999999,4159719.7300000004,3796897,6698423,7702333.68,7177192,6734670,6427587,4128941,4132031,3780000,3880000,3950000,4000000,4050000,4095496]
[4,"Nadwyżka budżetowa z lat ubiegłych + wolne środki, w tym:",226000,601656.54,0,0,85474.18,87792.17,0,1090180,0,0,0,0,0,0,0,0,0,0,0,0,0]
["a","nadwyżka budżetowa z lat ubiegłych + wolne środki angażowane na pokrycie deficytu budżetu roku bieżącego",226000,601656.54,0,0,85474.18,87792.17,0,1090180,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,"Inne przychody niezwiązane z zaciągnięciem długu",0,47461,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,"Środki do dyspozycji (suma poz. 3 +poz. 4+ poz. 5)",1779570.459999999,2215198.2299999977,2819367.66,5969995.610000003,2017044.3300000022,4537217.389999999,4159719.7300000004,4887077,6698423,7702333.68,7177192,6734670,6427587,4128941,4132031,3780000,3880000,3950000,4000000,4050000,4095496]
[7,"Spłata i obsługa długu, z tego:",1767633.75,2019191.88,3047412.06,5175598.4399999995,876280.89,2564376.0100000002,1360976.44,1381098,1791999,2003259.68,1683496,1503926,1852939,1885489,1778879,1703949,1656509,1626509,1596509,1763509,1028471]
["a","rozchody z tytułu spłaty rat kapitałowych oraz wykupu papierów wartościowych ",1364000,1516000,2381169.64,4502073.47,215000,1940808.85,874118,851098,1217868,1446896.68,1158620,1000000,1400000,1500000,1500000,1500000,1500000,1500000,1500000,1700000,965717]
["b","wydatki bieżące na obsługę długu:",403633.75,503191.88,666242.42,673524.97,661280.89,623567.16,486858.44,530000,574131,556363,524876,503926,452939,385489,278879,203949,156509,126509,96509,63509,62754]
[8,"Inne rozchody (bez spłaty długu)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,"Środki do dyspozycji na wydatki majątkowe (poz. 6–poz. 7–poz. 8)",11936.709999999031,196006.34999999776,-228044.3999999999,794397.1700000037,1140763.4400000023,1972841.3799999985,2798743.2900000005,3505979,4906424,5699074,5493696,5230744,4574648,2243452,2353152,2076051,2223491,2323491,2403491,2286491,3067025]
[10,"Wydatki majątkowe, w tym:",1676414.51,3056704.27,4355241.53,6012803.83,2732491.49,5138886.78,1631191.72,4783345,6669939,5699074,5493696,5230744,4574648,2243452,2353152,2076051,2223491,2323491,2403491,2286491,3067025]
["a","wydatki majątkowe objęte limitem",1676414.51,3056704.27,4355241.53,298500,2743800,5138886.78,1370357,4144811,6669539,5122814,5260343,4885576,4278337,2169332,2169332,753666,0,0,0,0,0]
[11,"Przychody z kredytów, pożyczek i emisji obligacji",1961000,2839628.66,4737527.79,5313765.35,1685863.74,3135493.61,0,1277366,1763515,0,0,0,0,0,0,0,0,0,0,0,0]
[12,"Wynik finansowy budżetu (poz. 9 – poz.10 + poz. 11)",296522.199999999,-21069.260000002105,154241.86000000034,95358.6900000032,94135.69000000227,-30551.7900000019,1167551.5700000005,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Kwota długu na koniec roku, w tym:",8790000,10971628.66,13327986.81,13991288.18,15831354.83,16573436.68,15699318.68,16125586.68,16671233.68,15224337,14065717,13065717,11665717,10165717,8665717,7165717,5665717,4165717,2665717,965717,0]
["a","łączna kwota wyłączeń z art. 243 ust. 3 pkt 1 ufp oraz art. 170 ust. 3 sufp",0,294498.66,662858.15,222466.66,360447.24,935493.61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["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,null,1179823.47,0,1295940.85,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[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]
[15,"Planowana łączna kwota spłaty zobowiązań",9.869939650525177,10.079403621732478,12.843349186133343,19.557073025401507,3.717589778876815,4.805911663997458,4.301599161298932,3.98,5.12,5.74,4.8,4.3,5.43,6.03,5.78,5.550322475570033,5.378275974025974,5.272314424635332,5.175069692058347,5.7163987034035655,3.3288703311317613]
["a","Maksymalny dopuszczalny wskaźnik spłaty z art.. 243 ",15,0,0,0,3.9907165435691043,5.010148964470006,6.657354087586578,7.81,8.63,9.27,10.43,11.55,11.38,11.28,11.68,12.34,11.96,11.98,12.04,12.38,12.65]
[16,"Spełnienie wskaźnika spłaty z art. 243 po uwzględnieniu art.. 244","Zgodny/ niezgodny","Zgodny/ niezgodny","Zgodny/ niezgodny","Zgodny/ niezgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny","Zgodny"]
[17,"Planowana łączna kwota spłaty zobowiązań/dochody ogółem /max 15% art.. 169 sufp/",9.869939650525176,10.079403621732478,12.843349186133343,15.098865143286023,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[18,"Zadłużenie/dochody ogółem (poz. 13-poz. 13a):poz. 1 /max. 60% art.. 170 sufp/",49.080738319301894,57.3856352569005,56.17093624975988,52.02835016318611,65.63476230382217,62.79428004261195,49.620385836254925,48.15240438491644,48.89150938153357,44.64309393016912,41.23126128836947,38.56728210452633,35.003186249373115,32.88711592442301,28.08799524413806,23.34109771986971,18.395185064935063,13.503134521880066,8.640897893030795,3.130363047001621,0]
[19,"Wydatki bieżące razem (poz. 2 + poz. 7b)",16759329.33,18969961.9,21574424.450000003,21167604.189999998,22300920.64,22567368.63,27965987.17,30221745.75,27974131,26956363.32,27461889,27646979,27352938,27167489,26998879,27123949,27076509,27026509,26946509,26863509,26862754]
[20,"Wydatki ogółem (poz. 10+ poz. 19)",18435743.84,22026666.169999998,25929665.980000004,27180408.019999996,25033412.130000003,27706255.41,29597178.89,35005090.75,34644070,32655437.32,32955585,32877723,31927586,29410941,29352031,29200000,29300000,29350000,29350000,29150000,29929779]
[21,"Wynik budżetu (poz. 1 – poz. 20)",-526477.8000000007,-1993815.460000001,-2202116.290000003,-716333.1899999939,-1462202.2300000004,-1313028.7200000025,2041669.5700000003,-1516448,-545647,1446896.6799999997,1158620,1000000,1400000,1500000,1500000,1500000,1500000,1500000,1500000,1700000,965717]
[22,"Przychody budżetu",2187000,3441285.2,4737527.79,5313765.35,1771337.92,3223285.78,0,2367546,1763515,0,0,0,0,0,0,0,0,0,0,0,0]
[23,"Rozchody budżetu (poz. 7a + poz. 8)",1364000,1516000,2381169.64,4502073.47,215000,1940808.85,874118,1217868,1446896.68,1446896.68,1158620,1000000,1400000,1500000,1500000,1500000,1500000,1500000,1500000,1700000,965717]
[null,null,null,1925285.2000000002,2356358.15,811691.8799999999,1556337.92,1282476.9299999997,-874118,1149678,316618.32000000007,-1446896.68,-1158620,-1000000,-1400000]
[]
[null,"Wydatki ogółem",18435743.84,22026666.169999998,25929665.980000004,21466104.189999998,25044720.64,27706255.41,29336344.17,34366556.75,34643670,32079177.32,32722232,32532555,31631275,29336821,29168211,27877615,27076509,27026509,26946509,26863509,26862754]
[null,"Dochody ogółem",17909266.04,20032850.709999997,23727549.69,26464074.830000002,23571209.900000002,26393226.689999998,31638848.46,33488642.75,34098423,34102334,34114205,33877723,33327586,30910941,30852031,30700000,30800000,30850000,30850000,30850000,30895496]
[null,"planowana spłata w danym roku – spłata UE",1767633.75,2019191.88,3047412.06,5175598.4399999995,876280.89,2564376.0100000002,1360976.44,1381098,1791999,2003259.68,1683496,1503926,1852939,1885489,1778879,1703949,1656509,1626509,1596509,1763509,1028471]
[null,"Kwota długu na koniec roku,",8790000,11495978.64,13327986.81,13991288.18,15470907.59,16573436.68,15699318.68,16125586.68,16671233.68,15224337,14065717,13065717,11665717,10165717,8665717,7165717,5665717,4165717,2665717,965717,0]
[null,"planowana spłata  do dochodów",9.869939650525177,10.079403621732478,12.843349186133343,19.557073025401507,3.717589778876815,9.716038285578794,4.301599161298932,4.124078752041989,5.255372073951924,5.874259750080449,4.934882697691475,4.439277102537263,5.559775616511799,6.0997463648874355,5.765840829085126,5.550322475570033,5.378275974025974,5.272314424635332,5.175069692058347,5.7163987034035655,3.3288703311317613]
[]
[null,"dochody bieżące + dochody ze sprzedaży maj.",17509399.44,19362432.939999998,22498154.14,22787190.8,23483590.66,24899126.689999998,31601042.169999998,32772768.11,31685236,31458329,31200000,31156000,31351606,30910941,30852031,30700000,30800000,30850000,30850000,30850000,30895496]
[null,"wydatki bieżące",null,null,null,21167604.189999998,22300920.64,22567368.63,27965987.17,30221745.75,27974131,26956363.32,27461889,27646979,27352938,27167489,26998879,27123949,27076509,27026509,26946509,26863509,26862754]
[null,"dochody bieżące – wydatki bieżące – odsetki",750070.1100000013,392471.03999999806,923729.6899999994,1619586.6100000031,1182670.0199999996,2331758.0599999987,3635054.9999999963,2551022.3599999994,3711105,4501965.68,3738111,3509021,3998668,3743452,3853152,3576051,3723491,3823491,3903491,3986491,4032742]
[null,null,0.041881677804368654,1.959137247521564,3.89306819317001,6.11994419001574,5.017434510224269,8.834683562519725,11.489213978807356,7.617574647751287,10.883509187507,13.201341820181572,10.957637734779398,10.357900972270183,11.998072707696261,12.110443354021477,12.489135642318006,11.648374592833877,12.089256493506493,12.393811993517017,12.65313128038898,12.922175040518638,13.05284757363986]
[null,"program",{"$nulls":6},10.42,10.2,6.28,8.75,11.7,11.98,10.19,12.63,12.88,15.29,15.09,15.12,15.43,15.75,15.75]
[null,null,0,{"$error":"#REF!"},{"$error":"#REF!"},1.964695706165314,3.9907165435691043,5.010148964470006,6.657354087586578,8.44711068385045,9.313824063026122,9.99676593802188,10.567475218479952,11.680829580822657,11.505626842410383,11.104537138248613,11.488805677995973,12.19921723467858,12.08265119639112,12.075588909552792,12.04381435995246,12.378733255804164,12.656372771474878]
[null,"program",{"$nulls":6},6.59,8.03,9.75,8.97,8.41,8.91,10.81,11.29,11.6,11.9,13.6,14.42,15.17,15.21,15.21]
[]
[{"$nulls":7}," "]