{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Návratnosť"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Návratnosť","index":0,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Efektivnosť projektu"]
[null,null,null,null,"Údaje sa uvádzajú v €"]
[null,"R.č.","Položka",null,2020,{"$f":"E4+1","v":2021},{"$f":"F4+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,{"$f":"P4+1","v":2032},{"$f":"Q4+1","v":2033},"SPOLU"]
[null,null,"Rok investovania",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,"1","Investícia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:R6)","v":0}]
[null,"2","Výnosy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:R7)","v":0}]
[null,"3","Náklady bez daní a úrokov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:R8)","v":0}]
[null,"4","Odpisy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:R9)","v":0}]
[null,"5","EBIT",null,{"$f":"E7-E8","v":0},{"$f":"F7-F8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E10:R10)","v":0}]
[null,"6","Daňova sadzba (20%)",null,0.21,{"$f":"E11","v":0.21},{"$f":"F11","v":0.21},0.21,0.21,0.21,0.21,0.21,0.21,0.21,0.21,0.21,0.21,0.21]
[null,"7","Daň",null,{"$f":"E10*E11","v":0},{"$f":"F10*F11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,"X"]
[null,"8","Cash flow bez investícií",null,{"$f":"E10-E12+E9","v":0},{"$f":"F10-F12+F9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,"x"]
[null,"9","Cash flow z projektu",null,{"$f":"E13-E6","v":0},{"$f":"F13-F6","v":0},0,0,0,0,0,0,0,0,{"$f":"O13-O6","v":0},{"$f":"P13-P6","v":0},{"$f":"Q13-Q6","v":0},{"$f":"R13-R6","v":0},"x"]
[null,"10","Kumulovaný Cash flow z projektu",null,{"$f":"E14","v":0},{"$f":"F14+E15","v":0},0,0,0,0,0,0,0,0,{"$f":"O14+N15","v":0},{"$f":"P14+O15","v":0},{"$f":"Q14+P15","v":0},{"$f":"R14+Q15","v":0},"X"]
[null,"11","Súčasná hodnota Cash flow z proj.",null,{"$f":"E14/POWER(1.05,E5)","v":0},{"$f":"F14/POWER(1.05,F5)","v":0},{"$f":"G14/POWER(1.05,G5)","v":0},0,0,0,0,0,0,0,0,0,0,0,"X"]
[null,"12","Čistá.súč. hodnota CF",null,{"$f":"E16","v":0},{"$f":"F16+E17","v":0},0,0,0,0,0,0,0,0,{"$f":"O16+N17","v":0},{"$f":"P16+O17","v":0},{"$f":"Q16+P17","v":0},{"$f":"R16+Q17","v":0},"X"]
[null,"13","Splatenie investície  (ÁNO/NIE)",null,{"$f":"IF(E17>0,\"Áno\",\"NIE\")","v":"NIE"},"NIE","NIE","NIE","NIE","NIE","NIE","NIE","NIE","NIE",{"$f":"IF(O17>0,\"Áno\",\"NIE\")","v":"NIE"},{"$f":"IF(P17>0,\"Áno\",\"NIE\")","v":"NIE"},{"$f":"IF(Q17>0,\"Áno\",\"NIE\")","v":"NIE"},{"$f":"IF(R17>0,\"Áno\",\"NIE\")","v":"NIE"},"X"]
[null,14,"Vyhodnotenie",null,{"$f":"IF(E18=\"Áno\",IF(D18=\"Áno\",\"\",E4),\"\")","v":""},{"$f":"IF(F18=\"Áno\",IF(E18=\"Áno\",\"\",F4),\"\")","v":""},"","","","","","","","","","","","","x"]
[null,"15","Rentabilita investície v %",null,{"$f":"IF(S6=0,0,R17/S6)","v":0}]
[null,"16","Úroková sadzba",null,0.08]
[null,"17","NPV projektu (z prvých 5 rokov)",null,{"$f":"NPV(E21,E14:I14)","v":0}]
[null,"18","Rentabilita investície v %",null,{"$f":"IF(S8=0,0,R17/S8)","v":0}]
[null,"16","Úroková sadzba pre NPV=0 , použi riešiteľa",null,0.05]
[null,"17","NPV projektu (z prvých 5 rokov)",null,{"$f":"NPV(E24,E14:I14)","v":0}]