{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Berechnung der Verzugszinsen"],"not_rendered":{"images":1,"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Berechnung der Verzugszinsen","index":0,"n_rows":95,"n_cols":14,"rows_kept":95}
[]
[]
[null,"Verzugszinsberechnung"]
[]
[null,"alle Werte in EUR",{"$nulls":11},"Weitere Informationen, wie Sie Verzugszinsen"]
[{"$nulls":13},"rechtssicher berechnen, lesen Sie in unserem"]
[null,"Forderung:",{"v":1000,"d":"1,000.00 €"},"vom:","2019-03-01",null,null,"aus Rechnung-Nr.:",null,"Ziel:",30,"Tage",null,"Themenspeicher"]
[]
[null,"Zahlungsdatum:","2020-10-13","(bzw. Tag vor Insolvenzeröffnung)",{"$nulls":3},"Handels- oder Verbrauchergeschäft:",null,null,9,"%"]
[]
[null,"Periode","Forderung","Anfang Verzug","Ende Verzug\ndatum","Tage","Tage/\nJahr","Basiszins\n f. Periode","Verzugs-\nzinssatz","Gesamt-%","Zinsbetrag/\nTag","Zinsbetrag"]
[]
[null,"Periode 1",{"$f":"$C$7","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"E7+K7","v":"2019-03-31"},{"$f":"IF(D13=\"\",\"\",IF(VLOOKUP($D13,$E$48:$G$118,3,1)>$C$9,$C$9,VLOOKUP($D13,$E$48:$G$118,3,1)))","v":"2019-06-30"},{"$f":"IF(E13=\"\",\"\",E13-D13+1)","v":92},{"$f":"IF(D13=\"\",\"\",DATE(YEAR(E13)+1,1,1)-DATE(YEAR(E13),1,1))","v":365},{"$f":"IF(D13=\"\",\"\",VLOOKUP($E13,$E$48:$H$118,4,1)*100)","v":-0.88},{"$f":"K9","v":9},{"$f":"IF(E13=\"\",\"\",I13+H13)","v":8.12},{"$f":"IF(E13=\"\",\"\",ROUND(C13/G13*J13/100,4))","v":{"v":0.2225,"d":"0.2225 €"}},{"$f":"IF(E13=\"\",\"\",C13/G13*F13*J13/100)","v":{"v":20.46684931506849,"d":"20.47 €"}},null,"In dieser mit einem Blattschutz versehenen Version"]
[null,"Periode 2",{"$f":"IF(D14=\"\",\"\",$C$7)","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"IF(E13<$C$9,E13+1,\"\")","v":"2019-07-01"},"2019-12-31",{"$f":"IF(E14=\"\",\"\",E14-D14+1)","v":184},{"$f":"IF(D14=\"\",\"\",DATE(YEAR(E14)+1,1,1)-DATE(YEAR(E14),1,1))","v":365},-0.88,{"$f":"I13","v":9},{"$f":"IF(E14=\"\",\"\",I14+H14)","v":8.12},{"$f":"IF(E14=\"\",\"\",ROUND(C14/G14*J14/100,4))","v":{"v":0.2225,"d":"0.2225 €"}},{"$f":"IF(E14=\"\",\"\",C14/G14*F14*J14/100)","v":{"v":40.93369863013698,"d":"40.93 €"}},null,"können Sie Mithilfe des Makros die Zeilen aufgliedern."]
[null,"Periode 3",{"$f":"IF(D15=\"\",\"\",$C$7)","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"IF($C$9>E14,E14+1,\"\")","v":"2020-01-01"},"2020-06-30",{"$f":"IF(E15=\"\",\"\",E15-D15+1)","v":182},{"$f":"IF(D15=\"\",\"\",DATE(YEAR(E15)+1,1,1)-DATE(YEAR(E15),1,1))","v":366},-0.88,{"$f":"IF(D15=\"\",\"\",I14)","v":9},{"$f":"IF(E15=\"\",\"\",I15+H15)","v":8.12},{"v":0.2219,"d":"0.2219 €"},{"$f":"IF(E15=\"\",\"\",ROUND(C15/G15*F15*J15/100,2))","v":{"v":40.38,"d":"40.38 €"}},null,"Eine Version ohne Blattschutz erhalten Sie gegen"]
[null,"Periode 4",{"$f":"IF(D16=\"\",\"\",$C$7)","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"IF($C$9>E15,E15+1,\"\")","v":"2020-07-01"},"2020-10-13",{"$f":"IF(E16=\"\",\"\",E16-D16+1)","v":105},366,-0.88,{"$f":"IF(D16=\"\",\"\",I15)","v":9},{"$f":"IF(E16=\"\",\"\",I16+H16)","v":8.12},{"v":0.2219,"d":"0.2219 €"},{"$f":"IF(E16=\"\",\"\",ROUND(C16/G16*F16*J16/100,2))","v":{"v":23.3,"d":"23.30 €"}},null,"einen kleinen Obolus bei unserem Service:"]
[null,"Periode 5","","","",{"$f":"IF(E17=\"\",\"\",E17-D17+1)","v":""},"","","",{"$f":"IF(E17=\"\",\"\",I17+H17)","v":""},"",{"$f":"IF(E17=\"\",\"\",ROUND(C17/G17*F17*J17/100,2))","v":""},null,"service@controllerspielwiese.de"]
[null,"Periode 6","","","","","","","","","",""]
[null,"Periode 7","","","","","","","","","",""]
[null,"Periode 8","","","","","","","","","",""]
[null,"Periode 9","","","","","","","","","",""]
[null,"Periode 10","","","","","","","","","",""]
[null,"Periode 11","","","","","","","","","",""]
[null,"Periode 12","","","",{"$f":"IF(E24=\"\",\"\",E24-D24+1)","v":""},{"$f":"IF(D24=\"\",\"\",DATE(YEAR(E24)+1,1,1)-DATE(YEAR(E24),1,1))","v":""},"",{"$f":"IF(D24=\"\",\"\",I23)","v":""},{"$f":"IF(E24=\"\",\"\",I24+H24)","v":""},{"$f":"IF(E24=\"\",\"\",ROUND(C24/G24*J24/100,4))","v":""},{"$f":"IF(E24=\"\",\"\",ROUND(C24/G24*F24*J24/100,2))","v":""}]
[null,"Periode 13","","","","","","","","","",""]
[null,"Periode 14","","","","","","","","","",""]
[null,"Periode 15","","","","","","","","","",""]
[null,"Periode 16","","","","","","","","","",""]
[null,"Periode 17","","","","","","","","","",""]
[null,"Periode 18","","","","","","","","","",""]
[null,"Periode 19","","","","","","","","","",""]
[null,"Periode 20","","","","","","","","","",""]
[null,"Periode 21","","","","","","","","","",""]
[null,"Periode 22","","","","","","","","","",""]
[null,"Periode 23","","","","","","","","","",""]
[null,"Periode 24","","","","","","","","","",""]
[null,"Periode 25","","","","","","","","","",""]
[null,"Periode 26","","","",{"$f":"IF(E38=\"\",\"\",E38-D38+1)","v":""},{"$f":"IF(D38=\"\",\"\",DATE(YEAR(E38)+1,1,1)-DATE(YEAR(E38),1,1))","v":""},{"$f":"IF(D38=\"\",\"\",VLOOKUP($E38,$E$48:$H$118,4,1)*100)","v":""},{"$f":"IF(D38=\"\",\"\",I37)","v":""},{"$f":"IF(E38=\"\",\"\",I38+H38)","v":""},{"$f":"IF(E38=\"\",\"\",ROUND(C38/G38*J38/100,4))","v":""},{"$f":"IF(E38=\"\",\"\",ROUND(C38/G38*F38*J38/100,2))","v":""}]
[null,"Periode 27","","","","","","","","","",""]
[null,"Periode 28","","","","","","","","","",""]
[null,"Periode 29","","","","","","","","","",""]
[null,"Periode 30","","",{"$f":"IF(D42=\"\",\"\",IF(VLOOKUP($D42,$E$48:$G$118,3,1)>$C$9,$C$9,VLOOKUP($D42,$E$48:$G$118,3,1)))","v":""},"","","","","","",""]
[]
[null,"Summe",{"$nulls":3},{"$f":"SUM(F13:F43)","v":563},{"$nulls":5},{"$f":"ROUND(SUM(L13:L43),2)","v":{"v":125.08,"d":"125.08 €"}}]
[]
[{"$nulls":10},"Die Gesamtforderung beträgt:",{"$f":"C7+L44","v":{"v":1125.08,"d":"1,125.08 €"}}]
[]
[null,"Basiszinssätze für den Zeitraum:",null,null,"1999-01-01","bis ","1999-04-30",{"v":0.025,"d":"2.50%"}]
[{"$nulls":4},"1999-05-01","bis ","1999-12-31",{"v":0.0195,"d":"1.95%"}]
[{"$nulls":4},"2000-05-01","bis ","2000-08-31",{"v":0.0342,"d":"3.42%"}]
[{"$nulls":4},"2000-09-01","bis ","2001-08-31",{"v":0.0426,"d":"4.26%"}]
[{"$nulls":4},"2001-09-01","bis ","2001-12-31",{"v":0.0362,"d":"3.62%"}]
[{"$nulls":4},"2002-01-01","bis ","2002-06-30",{"v":0.0257,"d":"2.57%"}]
[{"$nulls":4},"2002-07-01","bis ","2002-12-31",{"v":0.0247,"d":"2.47%"}]
[{"$nulls":4},"2003-01-01","bis ","2003-06-30",{"v":0.0197,"d":"1.97%"}]
[{"$nulls":4},"2003-07-01","bis ","2003-12-31",{"v":0.0122,"d":"1.22%"}]
[{"$nulls":4},"2004-01-01","bis ","2004-06-30",{"v":0.0114,"d":"1.14%"}]
[{"$nulls":4},"2004-07-01","bis ","2004-12-31",{"v":0.0113,"d":"1.13%"}]
[{"$nulls":4},"2005-01-01","bis ","2005-06-30",{"v":0.0121,"d":"1.21%"}]
[{"$nulls":4},"2005-07-01","bis ","2005-12-31",{"v":0.0117,"d":"1.17%"}]
[{"$nulls":4},"2006-01-01","bis ","2006-06-30",{"v":0.0137,"d":"1.37%"}]
[{"$nulls":4},"2006-07-01","bis ","2006-12-31",{"v":0.0195,"d":"1.95%"}]
[{"$nulls":4},"2007-01-01","bis ","2007-06-30",{"v":0.027,"d":"2.70%"}]
[{"$nulls":4},"2007-07-01","bis ","2007-12-31",{"v":0.0319,"d":"3.19%"}]
[{"$nulls":4},"2008-01-01","bis ","2008-06-30",{"v":0.0332,"d":"3.32%"}]
[{"$nulls":4},"2008-07-01","bis ","2008-12-31",{"v":0.0319,"d":"3.19%"}]
[{"$nulls":4},"2009-01-01","bis ","2009-06-30",{"v":0.0162,"d":"1.62%"}]
[{"$nulls":4},"2009-07-01","bis ","2009-12-31",{"v":0.0012,"d":"0.12%"}]
[{"$nulls":4},"2010-01-01","bis ","2010-06-30",{"v":0.0012,"d":"0.12%"}]
[{"$nulls":4},"2010-07-01","bis ","2010-12-31",{"v":0.0012,"d":"0.12%"}]
[{"$nulls":4},"2011-01-01","bis ","2011-06-30",{"v":0.0012,"d":"0.12%"}]
[{"$nulls":4},"2011-07-01","bis ","2011-12-31",{"v":0.0037,"d":"0.37%"}]
[{"$nulls":4},"2012-01-01","bis ","2012-06-30",{"v":0.0012,"d":"0.12%"}]
[{"$nulls":4},"2012-07-01","bis ","2012-12-31",{"v":0.0012,"d":"0.12%"}]
[{"$nulls":4},"2013-01-01","bis ","2013-06-30",{"v":-0.0013,"d":"-0.13%"}]
[{"$nulls":4},"2013-07-01","bis ","2013-12-31",{"v":-3.8E-3,"d":"-0.38%"}]
[{"$nulls":4},"2014-01-01","bis ","2014-06-30",{"v":-6.3E-3,"d":"-0.63%"}]
[{"$nulls":4},"2014-07-01","bis ","2014-12-31",{"v":-0.0073,"d":"-0.73%"}]
[{"$nulls":4},"2015-01-01","bis ","2015-06-30",{"v":-0.0083,"d":"-0.83%"}]
[{"$nulls":4},"2015-07-01","bis ","2015-12-31",{"v":-0.0083,"d":"-0.83%"}]
[{"$nulls":4},"2016-01-01","bis ","2016-06-30",{"v":-0.0083,"d":"-0.83%"}]
[{"$nulls":4},"2016-07-01","bis ","2016-12-31",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":4},"2017-01-01","bis ","2017-06-30",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":4},"2017-07-01","bis ","2017-12-31",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":4},"2018-01-01","bis ","2018-06-30",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":4},"2018-07-01","bis ","2018-12-31",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":4},"2019-01-01","bis ","2019-06-30",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":4},"2019-07-01","bis ","2019-12-31",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":4},"2020-01-01","bis ","2020-06-30",{"v":-0.0088,"d":"-0.88%"}]
[{"$nulls":3},"seit","2020-07-01","bis ","2020-12-31",{"v":-0.0088,"d":"-0.88%"}]
[null,"Erweitern Sie diese Tabelle"]
[null,"um die halbjährlich neu"]
[null,"festgelegten Werte. Diese "]
[null,"finden Sie bei uns:"]
[null,"Aktuelle Basiszinssätze"]