{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Polecenia","Inwestycja","dane"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"Polecenia","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["1) Wczytaj dane dotyczące przepływów"]
[]
["2) Zbuduj mechanizm pobierania danych do oceny efektywności wybranej inwestycji"]
[]
["3) Dla wybranej inwestycji oblicz NPV przy danej (wybieranej stopie duskontowej) i sporządź wykres zależności NPV od stopy dyskonta"]
[]
["4) Zabezpiecz arkusz przed modyfikacjami"]

{"sheet":"Inwestycja","index":1,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Wybór inwestycji:",null,null,2]
[]
["Inwestycja:","k=",{"$f":"E3/100","v":0.2},null,20]
[]
[null,0,1,2,3,4]
[{"$f":"OFFSET(dane!A2,$D$1,)","v":"Inwestycja-B"},{"$f":"OFFSET(dane!B2,$D$1,)","v":-101100},{"$f":"OFFSET(dane!C2,$D$1,)","v":63693},{"$f":"OFFSET(dane!D2,$D$1,)","v":63693},{"$f":"OFFSET(dane!E2,$D$1,)","v":63693},{"$f":"OFFSET(dane!F2,$D$1,)","v":63693}]
[]
["NPV =",{"$f":"NPV($C$3,$C$6:$F$6)+$B$6","v":63784.270833333343}]
["Wykres:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B8>=0,\"Inwestycja jest opłacalna ponieważ: przy k= \",\"Inwestycja jest nieopłacalna ponieważ: przy k= \")&TEXT(C3,\"0%\")&\", NPV= \"&TEXT(B8,\"# ##0 \")&\" tys.\"","v":"Inwestycja jest opłacalna ponieważ: przy k= 20%, NPV= 64 tys."},null,null,null,null,null,{"$f":"\"NPV= \"&TEXT(B8,\"# ##0 \")&\" tys.\"","v":"NPV= 64 tys."}]
[null,null,null,"x","y",null,{"$f":"\"k= \"&TEXT(C3,\"0%\")","v":"k= 20%"}]
[0,{"$f":"NPV(A29,$C$6:$F$6)+$B$6","v":153672},null,{"$f":"C3","v":0.2},{"$f":"B8","v":63784.270833333343}]
[0.05,{"$f":"NPV(A30,$C$6:$F$6)+$B$6","v":124752.22546161321}]
[0.1,100798.23987432549,null,0,{"$f":"E29","v":63784.270833333343}]
[0.15,80742.136856286292,null,{"$f":"D29","v":0.2},{"$f":"E29","v":63784.270833333343}]
[0.2,63784.270833333343,null,{"$f":"D32","v":0.2},0]
[0.25,49317.388799999986]
[0.3,36874.367494135338]
[0.35,26091.603922166323]
[0.4,16682.97376093296]
[0.45,8421.042895256629]
[0.5,1123.3333333333285]
[0.55000000000000004,-5357.8387930539902]
[0.6,-11142.967529296875]
[0.65,-16331.107620153445]
[0.7,-21004.266112714162]
[0.75,-25230.787172011667]
[0.8,-29067.983539094654]
[0.85,-32564.198977569176]
[0.9,-35760.437151341685]
[0.95,-38691.657388280051]
[1,-41387.8125]

{"sheet":"dane","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Dane o przepływach poszczególnych inwestycji:"]
[null,0,1,2,3,4]
["Inwestycja-A",-101100,50550,60660,70770,80880]
["Inwestycja-B",-101100,63693,63693,63693,63693]
["Inwestycja-C",-101100,75825,65715,55605,45495]
["Inwestycja-D",-101100,10110,20220,30330,272970]
["Inwestycja-E",-101100,35385,53077.5,79616.25,119424.38]
["Inwestycja-F",-101100,80880,60660,45495,34121.25]