{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Eine Variable","Zwei Variable","Drei Variable"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",4]
[null,"Thema","Integrierte Analyse-Methoden"]
[]
[null,"Inhalt","Datentabelle"]
[null,null,"● mit einer Variablen"]
[null,null,"● mit zwei Variablen"]
[null,null,"● mit mehr als zwei Variablen"]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Eine Variable","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Anzahlung",0,null,"Zinssatz","Zahlung"]
["Zinssatz",9.2999999999999999E-2,null,null,{"$f":"PMT(Zinssatz/12,Laufzeit,-Darlehen+Anzahlung)","v":{"$error":"#NAME?"}}]
["Laufzeit",240,null,9.0999999999999998E-2,{"$error":"#NAME?"}]
["Darlehen",50000,null,9.1999999999999998E-2,{"$error":"#NAME?"}]
[null,null,null,9.2999999999999999E-2,{"$error":"#NAME?"}]
[null,null,null,9.4E-2,{"$error":"#NAME?"}]
[null,null,null,9.5000000000000001E-2,{"$error":"#NAME?"}]
[null,null,null,9.6000000000000002E-2,{"$error":"#NAME?"}]
[null,null,null,9.7000000000000003E-2,{"$error":"#NAME?"}]
[null,null,null,9.8000000000000004E-2,{"$error":"#NAME?"}]

{"sheet":"Zwei Variable","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,5,0,8]]}
["Anzahlung",0,null,null,null,"Monate"]
["Zinssatz",9.2999999999999999E-2,null,null,{"$f":"PMT(Zinssatz/12,Laufzeit,-Darlehen+Anzahlung)","v":{"$error":"#NAME?"}},180,240,300,360]
["Laufzeit",240,null,null,9.0999999999999998E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["Darlehen",50000,null,null,9.1999999999999998E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,9.2999999999999999E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,9.4E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,9.5000000000000001E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,9.6000000000000002E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,9.7000000000000003E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,9.8000000000000004E-2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]

{"sheet":"Drei Variable","index":3,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Investition\nRückfluss",{"$f":"\"-125.000 €\" & CHAR(10) & \"5.000 €\"","v":"-125.000 €\n5.000 €"}]
["Laufzeit ",12]
[]
["Jahr","Rückfluss","IKV",null,"Investition","Rückfluss",null,"Laufzeit"]
[0,{"$f":"LEFT(Werte,-1+FIND(CHAR(10),Werte))*1","v":-125000},{"$f":"IRR(B5:B17)","v":-9.8113034526911003E-2},null,null,null,{"$f":"TEXT(IRR(Rückfluss),\"0,0 %\") & CHAR(10) & TEXT(NPV(6%,Rückfluss),\"#.##0,00 €\")","v":"-9,8 %\n-78.378,09 €"},10,11,12,13,14,15,16,17,18,19,20]
[1,{"$f":"IF(Jahr<=LZeit,MID(Werte,FIND(CHAR(10),Werte)+1,99)*1,0)","v":5000},null,null,-125000,8000,{"$f":"TEXT(Invest,\"#.##0,00 €\") & CHAR(10) & TEXT(Rück,\"#.##0,00 €\")","v":"-125.000,00 €\n8.000,00 €"},"-7,4 %\n-62.376,70 €","-5,4 %\n-58.400,95 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €","-3,8 %\n-54.650,23 €"]
[2,5000,null,null,-125000,10000,"-125.000,00 €\n10.000,00 €","-3,9 %\n-48.489,74 €","-2,1 %\n-43.520,05 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €","-0,6 %\n-38.831,66 €"]
[3,5000,null,null,-125000,12000,"-125.000,00 €\n12.000,00 €","-0,7 %\n-34.602,79 €","0,9 %\n-28.639,16 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €","2,2 %\n-23.013,09 €"]
[4,5000,null,null,-120000,8000,"-120.000,00 €\n8.000,00 €","-6,8 %\n-57.659,72 €","-4,8 %\n-53.683,97 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €","-3,3 %\n-49.933,25 €"]
[5,5000,null,null,-120000,10000,"-120.000,00 €\n10.000,00 €","-3,2 %\n-43.772,76 €","-1,4 %\n-38.803,07 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €","0,0 %\n-34.114,68 €"]
[6,5000,null,null,-120000,12000,"-120.000,00 €\n12.000,00 €","0,0 %\n-29.885,81 €","1,6 %\n-23.922,17 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €","2,9 %\n-18.296,11 €"]
[7,5000,null,null,-115000,8000,"-115.000,00 €\n8.000,00 €","-6,1 %\n-52.942,74 €","-4,2 %\n-48.966,98 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €","-2,7 %\n-45.216,27 €"]
[8,5000,null,null,-115000,10000,"-115.000,00 €\n10.000,00 €","-2,5 %\n-39.055,78 €","-0,7 %\n-34.086,09 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €","0,7 %\n-29.397,70 €"]
[9,5000,null,null,-115000,12000,"-115.000,00 €\n12.000,00 €","0,8 %\n-25.168,83 €","2,4 %\n-19.205,19 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €","3,6 %\n-13.579,13 €"]
[10,5000,null,null,-110000,8000,"-110.000,00 €\n8.000,00 €","-5,4 %\n-48.225,76 €","-3,5 %\n-44.250,00 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €","-2,0 %\n-40.499,29 €"]
[11,5000,null,null,-110000,10000,"-110.000,00 €\n10.000,00 €","-1,7 %\n-34.338,80 €","0,0 %\n-29.369,11 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €","1,4 %\n-24.680,72 €"]
[12,5000,null,null,-110000,12000,"-110.000,00 €\n12.000,00 €","1,6 %\n-20.451,84 €","3,2 %\n-14.488,21 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €","4,4 %\n-8.862,14 €"]