{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["List1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"List1","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Příklad na poskytnutí obchodního úvěru"]
[]
[null,"a)"]
[null,"Pravděpodobnost zaplacení nového zákazníka",null,null,null,null,0.75]
[null,"Výnos",null,null,null,null,1200,"Kč"]
[null,"Náklad",null,null,null,null,1000,"Kč"]
[null,"Alternativní náklad kapitálu (cena peněz)",null,null,null,null,0.15]
[null,"Doba splatnosti faktury",null,null,null,null,30,"dní"]
[null,"Trvání roku",null,null,null,null,360]
[]
[]
[null,"Poskytnout?",null,{"$f":"IF(G13<0,\"Ne\",\"Ano\")","v":"Ne"},"Očekávaný zisk",null,{"$f":"+(G6-G7)/(1+G8*G9/G10)-(1-G5)*G7","v":-52.46913580246914}]
[]
[null,"b)"]
[null,"Když zaplatí, s jakou pravděpodobností se vrátí?",null,null,null,null,0.9]
[null,"Kolik zopakuje objednávek?",null,null,null,null,2]
[null,"S jakou pravděpodobností opět zaplatí?",null,null,null,null,0.95]
[null,"Interval objednávek",null,null,null,null,50,"dní"]
[]
[null,"Diskont pro interval mezi splatností a objednávkou",null,null,null,null,{"$f":"IF(G19>G9,1/(1+G8/G10*(G19-G9)),1+G8/G10*(G9-G19))","v":0.99173553719008267}]
[]
[null,"Očekávaný zisk opakované objednávky",null,null,null,null,{"$f":"+G18*(G6-G7)/(1+G8/G10*G9)-(1-G18)*G7","v":137.65432098765427}]
[null,"Očekávaný zisk opakované objednávky posunutý",null,null,null,null,{"$f":"+G23*G21","v":136.51668197122737}]
[]
[null,"Zde je funkce, která to spočítá pro příslušný počet opakování objednávek"]
[null,null,null,null,null,null,{"$f":"Zisk(G8,G24,G17,G19,G18,G10)","v":263.56077784649199}]
[null,"Poskytnout?",null,{"$f":"IF(G28<0,\"Ne\",\"Ano\")","v":"Ano"},"Očekávaný zisk",null,{"$f":"+(G27*G16+G6-G7)/(1+G8/G10*G9)*G5+(1-G5)*(-G7)","v":73.855333379142735}]