{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Cashflow-Planung","Cashflow-Tabelle"],"not_rendered":{"charts":1,"images":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Cashflow-Planung","index":0,"n_rows":64,"n_cols":16,"rows_kept":64,"merged":[[2,7,2,8],[4,14,5,14]]}
[{"$nulls":15}," "]
[]
[null,"Vorhandenes Bargeld",{"v":10000,"d":"10,000.00 €"},null,"Startdatum",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)","v":"2019-11-01"},null,"Benachrichtigung bei Mindestwert des Kassenbestands",null,{"v":2000,"d":"2,000.00 €"}]
[]
[null,null,{"$f":"IF(Anfangs_Datum=\"\",\"\",Anfangs_Datum)","v":"2019-11-01"},{"$f":"IF(C5=\"\",\"\",DATE(YEAR(C5),MONTH(C5)+1,1))","v":"2019-12-01"},{"$f":"IF(D5=\"\",\"\",DATE(YEAR(D5),MONTH(D5)+1,1))","v":"2020-01-01"},"2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","Ergebnis"]
[null,"Kassenbestand (Monatsanfang)",{"$f":"C3","v":{"v":10000,"d":"10,000.00 €"}},{"$f":"C55","v":{"v":8050,"d":"8,050.00 €"}},{"v":9350,"d":"9,350.00 €"},{"v":890,"d":"890.00 €"},{"v":2190,"d":"2,190.00 €"},{"v":13590,"d":"13,590.00 €"},{"v":13790,"d":"13,790.00 €"},{"v":15290,"d":"15,290.00 €"},{"v":16410,"d":"16,410.00 €"},{"v":14360,"d":"14,360.00 €"},{"v":16560,"d":"16,560.00 €"},{"v":18780,"d":"18,780.00 €"}]
[]
[null,"Bargeldeingänge"]
[]
[null,"Barverkäufe",{"v":2500,"d":"2,500.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":3600,"d":"3,600.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":14000,"d":"14,000.00 €"},{"v":6000,"d":"6,000.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":2800,"d":"2,800.00 €"},{"v":3500,"d":"3,500.00 €"},{"v":4000,"d":"4,000.00 €"},{"v":3800,"d":"3,800.00 €"},{"v":4200,"d":"4,200.00 €"},{"$f":"SUM(C10:N10)","v":{"v":53400,"d":"53,400.00 €"}}]
[null,"Retouren und Preisnachlässe",null,null,{"v":200,"d":"200.00 €"},{"$nulls":9},{"v":200,"d":"200.00 €"}]
[null,"Sammlungen bei Forderungen",{"$nulls":12},0]
[null,"Zinsen, sonstige Einkünfte",{"$nulls":12},0]
[null,"Darlehensvaluta",{"$nulls":12},0]
[null,"Beiträge des Besitzers",{"$nulls":12},0]
[null,"Sonstige Eingänge",{"$nulls":12},0]
[null,"Bargeldeingänge gesamt",{"$f":"SUM(C10,C12:C16,(C11*-1))","v":{"v":2500,"d":"2,500.00 €"}},{"$f":"SUM(D10,D12:D16,(D11*-1))","v":{"v":3000,"d":"3,000.00 €"}},{"v":3400,"d":"3,400.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":14000,"d":"14,000.00 €"},{"v":6000,"d":"6,000.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":2800,"d":"2,800.00 €"},{"v":3500,"d":"3,500.00 €"},{"v":4000,"d":"4,000.00 €"},{"v":3800,"d":"3,800.00 €"},{"v":4200,"d":"4,200.00 €"},{"$f":"SUM(O10:O16)","v":{"v":53600,"d":"53,600.00 €"}}]
[null,"Verfügbarer Barbestand gesamt",{"$f":"(C6+C17)","v":{"v":12500,"d":"12,500.00 €"}},{"v":11050,"d":"11,050.00 €"},{"v":12750,"d":"12,750.00 €"},{"v":3890,"d":"3,890.00 €"},{"v":16190,"d":"16,190.00 €"},{"v":19590,"d":"19,590.00 €"},{"v":16790,"d":"16,790.00 €"},{"v":18090,"d":"18,090.00 €"},{"v":19910,"d":"19,910.00 €"},{"v":18360,"d":"18,360.00 €"},{"v":20360,"d":"20,360.00 €"},{"v":22980,"d":"22,980.00 €"}]
[]
[null,"Barauszahlungen"]
[]
[null,"Werbung",{"v":3000,"d":"3,000.00 €"},{"$nulls":11},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"3,000.00 €"}}]
[null,"Gebühren und Provisionen",{"v":250,"d":"250.00 €"},{"v":300,"d":"300.00 €"},{"v":360,"d":"360.00 €"},{"v":300,"d":"300.00 €"},{"v":1400,"d":"1,400.00 €"},{"v":400,"d":"400.00 €"},{"v":300,"d":"300.00 €"},{"v":280,"d":"280.00 €"},{"v":350,"d":"350.00 €"},{"v":400,"d":"400.00 €"},{"v":380,"d":"380.00 €"},{"v":420,"d":"420.00 €"},{"v":5140,"d":"5,140.00 €"}]
[null,"Vertragsarbeit",null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},{"v":1200,"d":"1,200.00 €"}]
[null,"Besondere Sozialleistungen",{"$nulls":12},0]
[null,"Versicherungen (außer Krankenversicherung)",null,null,{"v":4000,"d":"4,000.00 €"},null,null,{"v":4000,"d":"4,000.00 €"},null,null,{"v":4000,"d":"4,000.00 €"},null,null,{"v":4000,"d":"4,000.00 €"},{"v":16000,"d":"16,000.00 €"}]
[null,"Zinsbelastung",{"$nulls":12},0]
[null,"Verbrauchsmaterialien und Betriebsmittel (in COGS)",{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":20700,"d":"20,700.00 €"}]
[null,"Verpflegung und Bewirtung",{"$nulls":12},0]
[null,"Hypothekenzinsen",{"$nulls":12},0]
[null,"Büroausgaben",{"$nulls":12},0]
[null,"Sonstige Zinsbelastungen",{"$nulls":12},0]
[null,"Renten- und Gewinnbeteiligungsprogramm",{"$nulls":12},0]
[null,"Käufe für den Weiterverkauf",{"$nulls":12},0]
[null,"Miete oder Leasing",{"$nulls":12},0]
[null,"Miete oder Leasing: Fahrzeuge, Ausrüstung",{"$nulls":12},0]
[null,"Reparaturen und Wartung",{"$nulls":12},0]
[null,"Zubehör (nicht in COGS)",{"$nulls":12},0]
[null,"Steuern und Lizenzen",{"$nulls":12},0]
[null,"Reise",{"$nulls":12},0]
[null,"Nebenkosten",{"$nulls":12},0]
[null,"Lohn (abzüglich Mitarbeitergutschriften)",{"$nulls":12},0]
[null,"Sonstige Kosten",{"$nulls":12},0]
[null,"Sonstige Kosten",{"$nulls":12},0]
[null,"Sonstige Kosten",{"$nulls":12},0]
[null,"Verschiedenes",{"$nulls":12},0]
[null,"Zwischensumme",{"$f":"SUM(C22:C46)","v":{"v":4450,"d":"4,450.00 €"}},{"v":1700,"d":"1,700.00 €"},{"v":11860,"d":"11,860.00 €"},{"v":1700,"d":"1,700.00 €"},{"v":2600,"d":"2,600.00 €"},{"v":5800,"d":"5,800.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1680,"d":"1,680.00 €"},{"v":5550,"d":"5,550.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1580,"d":"1,580.00 €"},{"v":5820,"d":"5,820.00 €"},{"v":46040,"d":"46,040.00 €"}]
[]
[null,"Darlehensrate",{"$nulls":12},0]
[null,"Kapitalkäufe",{"$nulls":12},0]
[null,"Sonstige Startup-Kosten",{"$nulls":12},0]
[null,"Reserven und/oder Anderkonten",{"$nulls":12},0]
[null,"Entnahmen des Eigentümers",{"$nulls":12},0]
[null,"Barauszahlungen gesamt",{"$f":"C47-SUM(C49:C53)","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"D47-SUM(D49:D53)","v":{"v":1700,"d":"1,700.00 €"}},{"v":11860,"d":"11,860.00 €"},{"v":1700,"d":"1,700.00 €"},{"v":2600,"d":"2,600.00 €"},{"v":5800,"d":"5,800.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1680,"d":"1,680.00 €"},{"v":5550,"d":"5,550.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1580,"d":"1,580.00 €"},{"v":5820,"d":"5,820.00 €"},{"$f":"SUM(O47,O49:O53)","v":{"v":46040,"d":"46,040.00 €"}}]
[null,"Kassenbestand (Monatsende)",{"$f":"(C18-C54)","v":{"v":8050,"d":"8,050.00 €"}},{"v":9350,"d":"9,350.00 €"},{"v":890,"d":"890.00 €"},{"v":2190,"d":"2,190.00 €"},{"v":13590,"d":"13,590.00 €"},{"v":13790,"d":"13,790.00 €"},{"v":15290,"d":"15,290.00 €"},{"v":16410,"d":"16,410.00 €"},{"v":14360,"d":"14,360.00 €"},{"v":16560,"d":"16,560.00 €"},{"v":18780,"d":"18,780.00 €"},{"v":17160,"d":"17,160.00 €"}]
[]
[null,"Sonstige Betriebsdaten"]
[]
[null,"Umsatzvolumen (Euro)"]
[null,"Forderungssaldo"]
[null,"Schuldensaldo"]
[null,"Lagerbestand"]
[null,"Schuldpostensaldo"]
[null,"Abschreibung"]

{"sheet":"Cashflow-Tabelle","index":1,"n_rows":15,"n_cols":15,"rows_kept":15}
[{"$nulls":11}," "]
[]
[null,"Monat","Kassenbestand",{"$nulls":9},{"$f":"B3","v":"Monat"},"Nicht unterhalb Minimum","Unterhalb Minimum"]
[null,{"$f":"'Cashflow-Planung'!C5","v":"2019-11-01"},{"$f":"'Cashflow-Planung'!C6","v":{"v":10000,"d":"10,000.00 €"}},{"$nulls":9},{"$f":"B4","v":"2019-11-01"},{"$f":"IF(C4<Cash_Minimum,0,C4)","v":{"v":10000,"d":"10,000.00 €"}},{"$f":"IF(C4<Cash_Minimum,C4,0)","v":0}]
[null,{"$f":"'Cashflow-Planung'!D5","v":"2019-12-01"},{"$f":"'Cashflow-Planung'!D6","v":{"v":8050,"d":"8,050.00 €"}},{"$nulls":9},"2019-12-01",{"v":8050,"d":"8,050.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!E5","v":"2020-01-01"},{"$f":"'Cashflow-Planung'!E6","v":{"v":9350,"d":"9,350.00 €"}},{"$nulls":9},"2020-01-01",{"v":9350,"d":"9,350.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!F5","v":"2020-02-01"},{"$f":"'Cashflow-Planung'!F6","v":{"v":890,"d":"890.00 €"}},{"$nulls":9},"2020-02-01",0,{"v":890,"d":"890.00 €"}]
[null,{"$f":"'Cashflow-Planung'!G5","v":"2020-03-01"},{"$f":"'Cashflow-Planung'!G6","v":{"v":2190,"d":"2,190.00 €"}},{"$nulls":9},"2020-03-01",{"v":2190,"d":"2,190.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!H5","v":"2020-04-01"},{"$f":"'Cashflow-Planung'!H6","v":{"v":13590,"d":"13,590.00 €"}},{"$nulls":9},"2020-04-01",{"v":13590,"d":"13,590.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!I5","v":"2020-05-01"},{"$f":"'Cashflow-Planung'!I6","v":{"v":13790,"d":"13,790.00 €"}},{"$nulls":9},"2020-05-01",{"v":13790,"d":"13,790.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!J5","v":"2020-06-01"},{"$f":"'Cashflow-Planung'!J6","v":{"v":15290,"d":"15,290.00 €"}},{"$nulls":9},"2020-06-01",{"v":15290,"d":"15,290.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!K5","v":"2020-07-01"},{"$f":"'Cashflow-Planung'!K6","v":{"v":16410,"d":"16,410.00 €"}},{"$nulls":9},"2020-07-01",{"v":16410,"d":"16,410.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!L5","v":"2020-08-01"},{"$f":"'Cashflow-Planung'!L6","v":{"v":14360,"d":"14,360.00 €"}},{"$nulls":9},"2020-08-01",{"v":14360,"d":"14,360.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!M5","v":"2020-09-01"},{"$f":"'Cashflow-Planung'!M6","v":{"v":16560,"d":"16,560.00 €"}},{"$nulls":9},"2020-09-01",{"v":16560,"d":"16,560.00 €"},0]
[null,{"$f":"'Cashflow-Planung'!N5","v":"2020-10-01"},{"$f":"'Cashflow-Planung'!N6","v":{"v":18780,"d":"18,780.00 €"}},{"$nulls":9},"2020-10-01",{"v":18780,"d":"18,780.00 €"},0]