{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Hypotheken-Rechner"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Hypotheken-Rechner","index":0,"n_rows":33,"n_cols":3,"rows_kept":33,"merged":[[0,0,0,3],[1,0,1,1],[5,1,5,2],[12,1,12,2],[19,1,19,2],[26,1,26,2]]}
["Einfacher Darlehens-Rechner"]
[]
[]
[null,"Anzahl der Zahlungen pro Jahr",12]
[]
[null,"Option A: Nach Zahlung pro Zeitraum"]
[null,"Gesamtschulden",{"v":15000,"d":"€15,000.00"}]
[null,"Jährlicher Zinssatz",{"v":0.075,"d":"7.500%"}]
[null,"Zahlungszeitraum (in Jahren)",5]
[null,"Zahlung",{"$f":"IF(COUNTA(C7:C9)<3,\" --- \",PMT(C8/$C$4,C9*$C$4,-C7))","v":{"v":300.5692289343565,"d":"€300.57"}}]
[null,"Gesamtverzinsung",{"$f":"IF(COUNTA(C8:C10)<3,\" --- \",C9*$C$4*C10-C7)","v":{"v":3034.1537360613875,"d":"€3,034.15"}}]
[]
[null,"Option B: Nach Gesamtschulden"]
[null,"Zahlung pro Zeitraum"]
[null,"Jährlicher Zinssatz"]
[null,"Zahlungszeitraum (in Jahren)"]
[null,"Gesamtschulden",{"$f":"IF(COUNTA(C14:C16)<3,\" --- \",PV(C15/$C$4,C16*$C$4,-C14))","v":" --- "}]
[null,"Gesamtverzinsung",{"$f":"IF(COUNTA(C14:C16)<3,\" --- \",C16*$C$4*C14-C17)","v":" --- "}]
[]
[null,"Option C: Nach jährlichem Zinssatz"]
[null,"Gesamtschulden"]
[null,"Zahlungsraum (in Jahren)"]
[null,"Zahlung pro Zeitraum"]
[null,"Jährlicher Zinssatz",{"$f":"IF(COUNTA(C21:C23)<3,\" --- \",RATE(C22*$C$4,-C23,C21,,,0.1)*$C$4)","v":" --- "}]
[null,"Gesamtverzinsung",{"$f":"IF(COUNTA(C21:C23)<3,\" --- \",C22*$C$4*C23-C21)","v":" --- "}]
[]
[null,"Option D: Nach Zahlungsreitraum"]
[null,"Gesamtschulden",{"v":100000,"d":"€100,000.00"}]
[null,"Jährlicher Zinssatz",{"v":0.02,"d":"2.000%"}]
[null,"Zahlung pro Zeitraum",{"v":500,"d":"€500.00"}]
[null,"Zahlungszeitraum (in Jahren)",{"$f":"IF(COUNTA(C28:C30)<3,\" --- \",NPER(C29/$C$4,-C30,C28)/$C$4)","v":{"v":20.290145095935674,"d":"20.29"}}]
[null,"Gesamtverzinsung",{"$f":"IF(COUNTA(C28:C30)<3,\" --- \",C31*$C$4*C30-C28)","v":{"v":21740.870575614055,"d":"€21,740.87"}}]
["[42]"]