{"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,1]
[]
["Inwestycja:","k=",{"$f":"E3/100","v":0.7},null,70]
[]
[null,0,1,2,3,4]
[{"$f":"OFFSET(dane!A2,$D$1,)","v":"Inwestycja-A"},{"$f":"OFFSET(dane!B2,$D$1,)","v":-101100},{"$f":"OFFSET(dane!C2,$D$1,)","v":50550},{"$f":"OFFSET(dane!D2,$D$1,)","v":60660},{"$f":"OFFSET(dane!E2,$D$1,)","v":70770},{"$f":"OFFSET(dane!F2,$D$1,)","v":80880}]
[]
["NPV =",{"$f":"NPV($C$3,$C$6:$F$6)+$B$6","v":-26286.653655966758}]
["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 nieopłacalna ponieważ: przy k= 70%, NPV= -26 tys."},null,null,null,null,null,{"$f":"\"NPV= \"&TEXT(B8,\"# ##0 \")&\" tys.\"","v":"NPV= -26 tys."}]
[null,null,null,"x","y",null,{"$f":"\"k= \"&TEXT(C3,\"0%\")","v":"k= 70%"}]
[0,{"$f":"NPV(A29,$C$6:$F$6)+$B$6","v":161760},null,{"$f":"C3","v":0.7},{"$f":"B8","v":-26286.653655966758}]
[0.05,{"$f":"NPV(A30,$C$6:$F$6)+$B$6","v":129737.22831536242}]
[0.1,103399.45358923567,null,0,{"$f":"E29","v":-26286.653655966758}]
[0.15,81500.022870129877,null,{"$f":"D29","v":0.7},{"$f":"E29","v":-26286.653655966758}]
[0.2,63109.490740740759,null,{"$f":"D32","v":0.7},0]
[0.25,47525.087999999989]
[0.3,34208.550120794098]
[0.35,22742.701259406007]
[0.4,12800.666389004604]
[0.45,4123.7272031908215]
[0.5,-3494.8148148148175]
[0.55000000000000004,-10221.541361809868]
[0.6,-16191.796875]
[0.65,-21516.38271014679]
[0.7,-26286.653655966758]
[0.75,-30578.433985839234]
[0.8,-34455.052583447658]
[0.85,-37969.714501582319]
[0.9,-41167.368267585422]
[0.95,-44086.186810037514]
[1,-46758.75]

{"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]