{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Zinsrechner"],"read":"whole","date_system":"1900"}

{"sheet":"Zinsrechner","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"merged":[[0,1,0,5],[1,1,1,5],[3,1,4,5],[6,1,6,5],[7,1,7,5],[19,1,19,5],[20,1,20,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5]]}
[null,"Taggenauer Zinsrechner"]
[null,"Berechnung von Zinsen nach 360- und 365-Tage-Methode"]
[]
[null,"Bitte geben Sie Kapital, Zinssatz sowie Start- und Enddatum ein. Die Zinstage, Zinsen und der Endbetrag werden automatisch berechnet."]
[]
[]
[null,"Zinsberechnung nach 360 Tagen"]
[null,"Bankübliche Methode mit 30/360-Berechnung."]
[]
[null,"Kapital",null,{"v":12500,"d":"12,500.00 €"}]
[null,"Zinssatz p.a.",null,{"v":0.0425,"d":"4.25%"}]
[null,"Startdatum",null,"2026-01-01"]
[null,"Enddatum",null,"2026-03-31"]
[null,"Zinstage",null,{"$f":"IF(OR(D10=\"\",D11=\"\",D12=\"\",D13=\"\"),\"\",IF(D13<D12,\"\",DAYS360(D12,D13,FALSE)))","v":90}]
[null,"Zinsen",null,{"$f":"IFERROR(IF(D14=\"\",\"\",D10*D11*D14/360),\"\")","v":{"v":132.8125,"d":"132.81 €"}}]
[null,"Endbetrag",null,{"$f":"IF(D15=\"\",\"\",D10+D15)","v":{"v":12632.8125,"d":"12,632.81 €"}}]
[null,"Hinweis",null,{"$f":"IF(OR(D12=\"\",D13=\"\"),\"\",IF(D13<D12,\"Enddatum liegt vor dem Startdatum\",\"Berechnung erfolgreich\"))","v":"Berechnung erfolgreich"}]
[]
[]
[null,"Zinsberechnung nach 365 Tagen"]
[null,"Taggenaue Berechnung auf Basis eines 365-Tage-Jahres."]
[]
[null,"Kapital",null,{"v":12500,"d":"12,500.00 €"}]
[null,"Zinssatz p.a.",null,{"v":0.0425,"d":"4.25%"}]
[null,"Startdatum",null,"2026-01-01"]
[null,"Enddatum",null,"2026-03-31"]
[null,"Zinstage",null,{"$f":"IF(OR(D23=\"\",D24=\"\",D25=\"\",D26=\"\"),\"\",IF(D26<D25,\"\",_xlfn.DAYS(D26,D25)))","v":89}]
[null,"Zinsen",null,{"$f":"IFERROR(IF(D27=\"\",\"\",D23*D24*D27/365),\"\")","v":{"v":129.5376712328767,"d":"129.54 €"}}]
[null,"Endbetrag",null,{"$f":"IF(D28=\"\",\"\",D23+D28)","v":{"v":12629.537671232876,"d":"12,629.54 €"}}]
[null,"Hinweis",null,{"$f":"IF(OR(D25=\"\",D26=\"\"),\"\",IF(D26<D25,\"Enddatum liegt vor dem Startdatum\",\"Berechnung erfolgreich\"))","v":"Berechnung erfolgreich"}]
[]
[]
[null,"Hinweise"]
[null,"• Es handelt sich um eine Berechnung einfacher Zinsen."]
[null,"• Zinseszinsen sind in dieser Vorlage nicht enthalten."]
[null,"• Bitte Ergebnisse bei Bedarf fachlich prüfen."]