{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Přehled úvěrů","prům.příjmy","List3"],"not_rendered":{"charts":0,"images":1,"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":"Přehled úvěrů","index":0,"n_rows":160,"n_cols":15,"rows_kept":160,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["                                                             Město Velká Bíteš - přehled přijatých úvěrů v Kč"]
[]
["Dlouhodobé","Výkup poz.","zateplení","infrastruktura","reko a zatepl.","reko a zatepl.","reko a zatepl.","reko a zatepl.ZŠ Tišnov.115+prostr.","reko a zatepl","infrastruktura","zkapacitnění","stav.úpravy KD","kultur.kreativ.cen","celkem"]
["úvěry","Babinec","budov ZŠ","Babinec","ZŠ Tišnovská","ZŠ Tišnovská","ZŠ Tišnovská","ZŠ Tišnov.115","ZŠ Tišnov.115","Babinec","MŠ Masaryk.","soc.zař.VB","knihovna-pivovar"]
["účet 451",null,"okruž.křižov.",null,"č.115 - krát.","č.115","č.115 - KB","předprostorKB","refinancování","2.etapa","nám.86 KB","KB","a další akce"]
[]
["uzavř. sml.",20000000,20000000,30000000,30473886.86,40000000,15000000,35000000,30000000,20000000,60000000,null,130000000]
["vyčerpáno"]
["v r. 2013"]
["v r. 2014",17062200]
["v r. 2015",null,12716756.44]
["v r. 2016",null,7283243.5600000005]
["v r. 2017",null,null,29959508.2]
["v r. 2018",null,null,null,30473886.86,{"$nulls":4},20000000]
["v r. 2019",{"$nulls":4},40000000,15000000,35000000,30000000]
["v r.2021",{"$nulls":9},19842307.54]
["v r.2022",{"$nulls":9},40157692.46]
["v r.2023",{"$nulls":10},15000000]
["v r.2024"]
["v r.2025",{"$nulls":11},119400000]
["v r.2026",{"$nulls":11},10600000]
[]
["splátky"]
[" r. 2014"]
[" r. 2015",2000004,5600000]
["r. 2016",2000004,1800000,{"$nulls":11},"Dluhová"]
["r. 2017",2000004,1800000,{"$nulls":11},"služba"]
["r. 2018",2000004,1800000,6000000,{"$nulls":5},668000]
["r. 2019",2000004,1800000,6000000,30473886.86,null,null,null,3668349.92,4008000,null,null,null,47950240.78]
["r. 2020",2000004,1800000,6000000,null,5000000,15000000,1020000,26331650.08,4008000,null,null,null,61159654.08,0.3926979151190901]
["r. 2021",2000004,1800000,6000000,null,5000000,null,1020000,null,4008000,null,null,null,19828004,0.1218753922891566]
["r. 2022",2000004,1800000,5959508.2,null,5000000,null,1020000,null,4008000,37512760.5,null,null,57300272.7,0.30838727093015045]
["r. 2023",1062168,1800000,null,null,5000000,null,1020000,null,3300000,1500000,9244476,null,22926644,0.1316259044343667]
["r. 2024",{"$nulls":4},5000000,null,6240000,null,null,1500000,1923600,null,14663600,0.08558402835175154]
["r. 2025",{"$nulls":4},5000000,null,6240000,null,null,1500000,1923600,40000000,54663600,0.29172376313868886]
["r. 2026",{"$nulls":4},5000000,null,6240000,null,null,1500000,1908324,0,14648324,0.08313714352181656]
["r. 2027",{"$nulls":4},5000000,null,6240000,null,null,4122000,null,4500000,19862000,0.10740477390422294]
["r. 2028",{"$nulls":6},5960000,null,null,4122000,null,4500000,14582000,0.08022151217407736]
["r. 2029",{"$nulls":9},4122000,null,4500000,8622000,0.04902254132470573]
["r. 2030",{"$nulls":9},4121239.5,null,4500000,8621239.5,0.0485037915058496]
["r. 2031",{"$nulls":11},4500000,4500000,0.025826406034337807]
["r. 2032",{"$nulls":11},4500000,4500000,0.02532974437983131]
["r. 2033",{"$nulls":11},4500000,4500000,0.024833082725324813]
["r. 2034",{"$nulls":11},4500000,4500000,0.024336421070818317]
["r. 2035",{"$nulls":11},4500000,4500000,0.02383975941631182]
["r. 2036",{"$nulls":11},4500000,4500000,0.023343097761805324]
["r. 2037",{"$nulls":11},4500000,4500000,0.022846436107298827]
["r. 2038",{"$nulls":11},4500000,4500000,0.022846436107298827]
["r. 2039",{"$nulls":11},4500000,4500000,0.022796769941848177]
["r.2040",{"$nulls":11},4500000,4500000,0.022747103776397527]
["r.2041",{"$nulls":11},4500000,4500000,0.02265727671057712]
["r.2042",{"$nulls":11},4500000,4500000,0.02265727671057712]
["r.2043",{"$nulls":11},4500000,4500000,0.02265727671057712]
["r.2044",{"$nulls":11},4500000,4500000,0.02265727671057712]
["r.2045",{"$nulls":11},4500000,4500000,0.02265727671057712]
["r.2046",{"$nulls":11},4500000,4500000,0.02265727671057712]
[]
[]
["Dlouhodobé","Výkup poz.","zateplení","infrastruktura","reko a zatepl.","reko a zatepl.","reko a zatepl.","reko a zatepl.ZŠ Tišnov.115+prostr.","reko a zatepl","infrastruktura","zkapacitnění","stav.úpravy KD","zkapacitnění","celkem","Podíl na Ø"]
["úvěry","Babinec","budov ZŠ","Babinec","ZŠ Tišnovská","ZŠ Tišnovská","ZŠ Tišnovská","ZŠ Tišnov.115","ZŠ Tišnov.115","Babinec","MŠ Masaryk.","soc.zař.VB","MŠ Masaryk.",null,"příjmech za"]
["účet 451",null,"okruž.křižov.",null,"č.115 - krát.","č.115","č.115 - KB","předprostorKB","refinancování","2.etapa","nám.86 KB","KB","nám.86 KB",null,"posl.4 roky"]
["zůst.nespl.úvěrů"]
["k 31.12.14",17062200,{"$nulls":11},17062200]
[]
["k 31.12.15",15062196,7116756.4399999995,{"$nulls":10},22178952.439999998]
[]
["k 31.12.16",13062192,12600000,{"$nulls":10},25662192]
[]
["k 31.12.17",11062188,10800000,29959508.2,{"$nulls":9},51821696.2]
[]
["k 31.12.18",9062184,9000000,23959508.2,30473886.86,{"$nulls":4},19332000,null,null,null,91827579.06]
[]
["k 31.12.19",7062180,7200000,17959508.2,0,40000000,15000000,35000000,26331650.08,15324000,null,null,null,163877338.28]
[]
["k 31.12.20",5062176,5400000,11959508.2,null,35000000,0,33980000,0,11316000,null,null,null,102717684.2,0.6371728573918756]
[]
["k 31.12.21",3062172,3600000,5959508.199999999,null,30000000,null,32960000,null,7308000,19842307.54,null,null,102731987.74000001,0.5852043965674844]
[]
["k 31.12.22",1062168,1800000,0,null,25000000,null,31940000,null,3300000,22487239.5,null,null,85589407.5,0.4406438002652624]
[]
["k 31.12.23",0,0,null,null,20000000,null,30920000,null,0,20987239.5,5755524,null,77662763.5,0.38572116613456725]
[]
["k 31.12.24",{"$nulls":4},15000000,null,24680000,null,null,19487239.5,3831924,0,62999163.5,0.315556389226974]
[]
["k 31.12.25",{"$nulls":4},10000000,null,18440000,null,null,17987239.5,1908324,79400000,127735563.5,0.6358075962240493]
[]
["k 31.12.26",{"$nulls":4},5000000,null,12200000,null,null,16487239.5,0,90000000,123687239.5,0.553545293894474]
[]
["k 31.12.27",{"$nulls":4},0,null,5960000,null,null,12365239.5,0,85500000,103825239.5,0.46521850882811516]
[]
["k 31.12.28",{"$nulls":6},0,null,null,8243239.5,0,81000000,89243239.5,0.40037200898733155]
[]
["k 31.12.29",{"$nulls":6},0,null,null,4121239.5,null,76500000,80621239.5,0.3620297704996593]
[]
["k 31.12.30",{"$nulls":6},0,null,null,0,null,72000000,72000000,0.32369091397352384]
[]
["k 31.12.31",{"$nulls":11},67500000,67500000,0.30367930724718134]
[]
["k 31.12.32",{"$nulls":11},63000000,63000000,0.28366770052083884]
[]
["k 31.12.33",{"$nulls":11},58500000,58500000,0.26365609379449634]
[]
["k 31.12.34",{"$nulls":11},54000000,54000000,0.24364448706815384]
[]
["k 31.12.35",{"$nulls":11},49500000,49500000,0.22363288034181134]
[]
["k 31.12.36",{"$nulls":11},45000000,45000000,0.20362127361546883]
[]
["k 31.12.37",{"$nulls":11},40500000,40500000,0.18360966688912633]
[]
["k 31.12.38",{"$nulls":11},36000000,36000000,0.16359806016278383]
[]
["k 31.12.39",{"$nulls":11},31500000,31500000,0.14358645343644133]
[]
["k 31.12.40",{"$nulls":11},27000000,27000000,0.13746839604601158]
[]
["k 31.12.41",{"$nulls":11},22500000,22500000,0.10356323998375634]
[]
["k 31.12.42",{"$nulls":11},18000000,18000000,0.08355163325741384]
[]
["k 31.12.43",{"$nulls":11},13500000,13500000,0.06354002653107135]
[]
["k 31.12.44",{"$nulls":11},9000000,9000000,0.04352841980472885]
[]
["k 31.12.45",{"$nulls":11},4500000,4500000,0.02351681307838635]
[]
["k 31.12.46",{"$nulls":11},0,0,0.003899297533875728]
[]
[]
[]
[null,"Dluhová služba - kritická hodnota je 30% (je ovlivněna mimořádnými splátkami úvěrů z obdržených dotačních prostředků)"]
[]
[null,"Podíl dluhu (přijaté úvěry) na průměrných příjmech za poslední 4 roky by neměl překročit 60 %"]
{"$rows_empty":9}
[null,"Ostatní dlouhodobé závazky - účet 459/0300 až 0331:"]
[null,"(Jedná se o půjčky na výstavbu bytů a předplacené nájmy. Umořování"]
[null,"dluhu probíhá zápočtem s předpisem nájemného, pouze u půjčky od PBS probíhají měsíční splátky.)"]
[{"$nulls":8},"roční splátka/",null,"zůstatek v Kč "]
[null,"číslo účtu","Popis závazku",{"$nulls":5},"zápoč. v Kč",null,"k 31.12.2024"]
[]
[null,"459/0000","Ostatní dlouhodobé závazky - Encom",{"$nulls":5},0,null,18254]
[null,"459/0339","Ing. Vaňatka - splátka kotle U Stadionu",{"$nulls":5},154008,null,769960]
[]
[null,"Ost.dl.závazky celkem",{"$nulls":6},154008,null,788214]
[]
[]
[]
[]
[]
["Velká Bíteš 20.2.2025"]
[]
["Vyhotovila:  Bc. Věra Pokorná"]

{"sheet":"prům.příjmy","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Průměrné příjmy za 4 roky pro výpočet ukazatele podílu zadluženosti"]
[]
["Rok","Příjmy celkem","prům.příjmy za 4 roky"]
[2013,102774203.03]
[2014,129597925.27]
[2015,142874547.97]
[2016,132281266.28,126881985.63749999,"r.2013-2016"]
[2017,141507694.62,136565358.535,"r.2014-2017"]
[2018,147166119.28,140957407.0375,"r.2015-2018"]
["2019",174430795.52,148846468.92499998,"r.2016-2019"]
["2020",181729413.3,161208505.68,"r.2017-2020"]
["2021",198869269.49,175548899.3975,"r.2018-2021"]
[2022,221919226.73,194237176.26,"r.2019-2022"]
[2023,202859345.54,201344313.765,"r.2020-2023"]
["2024",184922412.91,202142563.6675,"r.2021-2024","odhad R"]
["2025",289777015.07,224869500.0625,"r.2022-2025"]

{"sheet":"List3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}