{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","RMZ","BW","ZW","ZINS","ZINSZ","ZZR","NBW"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"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":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",3]
[null,"Thema","Formeln und Funktionen"]
[]
[null,"Inhalt","Barwertfunktionen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version","2.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2023-08-03"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"RMZ","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit","1"]
["Restwert",8000]
["Zinssatz p.a.",3.5000000000000003E-2]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["montl. Rate",{"$f":"PMT(Zinssatz/12,Laufzeit,Kreditbetrag,Restwert,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"BW","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatliche Zahlung",600]
["Laufzeit in Monate",72]
["Zielwert",50000]
["Zins",9.0499999999999997E-2]
["Startkapital",{"$f":"PV(Zinssatz/12,Laufzeit,Zahlung*-1,Zielwert,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"ZW","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatliche Zahlung",1200]
["Zinssatz p.a.",3.5000000000000003E-2]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["Restwert",{"$f":"FV(Zinssatz/12,Laufzeit,Zahlung*-1,Kreditbetrag,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"ZINS","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatl. Rate",1200]
["Restwert",4000]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["geschätzter Zins",3.5000000000000003E-2]
["Zinssatz p.a.",{"$f":"RATE(Laufzeit,Zahlung*-1,Kreditbetrag,Restwert,Fälligkeit,Zins)*12","v":{"$error":"#NAME?"}}]

{"sheet":"ZINSZ","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatl. Rate",1200]
["Zinssatz p.a.",3.5000000000000003E-2]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["Restwert",4000]
[]
["Peroide",12]
["Zinsanteil  ",{"$f":"IPMT(Zinssatz/12,Periode,Laufzeit,Kreditbetrag,Restwert,Fälligkeit)","v":{"$error":"#VALUE!"}}]

{"sheet":"ZZR","index":6,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatl. Rate",600]
["Restwert",4000]
["Zins",3.5000000000000003E-2]
["Kreditbetrag",50000]
["Laufzeit in Monate",{"$f":"ROUNDUP(NPER(Zinssatz/12,Zahlung*-1,Kreditbetrag,Restwert,Fälligkeit),0)","v":{"$error":"#NAME?"}}]

{"sheet":"NBW","index":7,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert",null,"Periode","Einzahlung","Auszahlung","Überschuss","Abzinssätze","Barwert"]
["Anschaffungskosten",50000,null,1,13500,8000,{"$f":"Einzahlung-Auszahlung","v":5500},{"$f":"(1+Zinssatz)^(-Periode)","v":0.96618357487922713},{"$f":"Überschuss*Abzins","v":5314.0096618357493}]
["kalkulatorischer Zinssatz",3.5000000000000003E-2,null,2,18200,8000,{"$f":"Einzahlung-Auszahlung","v":10200},{"$f":"(1+Zinssatz)^(-Periode)","v":0.93351070036640305},{"$f":"Überschuss*Abzins","v":9521.8091437373114}]
["Summe Barwerte",{"$f":"SUM(Barwert)","v":82261.375216602086},null,3,31600,8000,{"$f":"Einzahlung-Auszahlung","v":23600},{"$f":"(1+Zinssatz)^(-Periode)","v":0.90194270566802237},{"$f":"Überschuss*Abzins","v":21285.847853765328}]
["Kapitalwert",{"$f":"NPV(Zinssatz,Überschuss)-AnKosten","v":32261.375216602086},null,4,33700,8000,{"$f":"Einzahlung-Auszahlung","v":25700},{"$f":"(1+Zinssatz)^(-Periode)","v":0.87144222769857238},{"$f":"Überschuss*Abzins","v":22396.06525185331}]
[null,null,null,5,36200,8000,{"$f":"Einzahlung-Auszahlung","v":28200},{"$f":"(1+Zinssatz)^(-Periode)","v":0.84197316685852419},{"$f":"Überschuss*Abzins","v":23743.643305410384}]
[null,null,null,"Summen",{"$f":"SUM(E2:E6)","v":133200},{"$f":"SUM(F2:F6)","v":40000},{"$f":"SUM(G2:G6)","v":93200},null,{"$f":"SUM(Barwert)","v":82261.375216602086}]
[]
[null,null,null,null,null,null,null,"NBW aus Tabelle:",{"$f":"SuBarwert-AnKosten","v":32261.375216602086}]
[null,null,null,null,null,null,null,"NBW aus Formel:",{"$f":"NPV(Zinssatz,Überschuss)-AnKosten","v":32261.375216602086}]