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

{"sheet":"Cashflow","index":0,"n_rows":62,"n_cols":16,"rows_kept":62,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"ADATUM CORPORATION"]
[null,"Cashflow-Prognose für kleine Unternehmen"]
[]
[null,"Startdatum",{"$f":"TODAY()","v":"2023-03-22"}]
[null,"Benachrichtigung bei Mindestwert des Kassenbestands",null,{"$f":"Cash_minimum","v":0},{"$f":"Cash_minimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Anfang","Jan-xx","Feb-xx","Mär-xx","Apr-xx","Mai-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dez-xx","Summe"]
[null,"Kassenbestand (Monatsanfang)",null,{"$f":"C54","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"BARGELDEINGÄNGE"," ","Jan-xx","Feb-xx","Mär-xx","Apr-xx","Mai-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dez-xx","Summe"]
[null,"Barverkäufe",{"$nulls":13},{"$f":"SUM(D11:O11)","v":0}]
[null,"Retouren und Preisnachlässe",{"$nulls":13},0]
[null,"Sammlungen bei Forderungen",{"$nulls":13},0]
[null,"Zinsen, sonstige Einkünfte",{"$nulls":13},0]
[null,"Darlehensvaluta",{"$nulls":13},0]
[null,"Beiträge des Besitzers",{"$nulls":13},0]
[null,"GESAMTE BARGELDEINGÄNGE",null,{"$f":"SUM(D11,D13:D16,(D12*-1))","v":0},{"$f":"SUM(E11,E13:E16,(E12*-1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,CashReceipts[Summe])","v":0}]
[null,"Verfügbarer Barbestand",{"$f":"(C8+CashReceipts[[#Totals],[ ]])","v":0},{"$f":"(D8+CashReceipts[[#Totals],[Jan-xx]])","v":0},{"$f":"(E8+CashReceipts[[#Totals],[Feb-xx]])","v":0},{"$f":"(F8+CashReceipts[[#Totals],[Mär-xx]])","v":0},{"$f":"(G8+CashReceipts[[#Totals],[Apr-xx]])","v":0},{"$f":"(H8+CashReceipts[[#Totals],[Mai-xx]])","v":0},{"$f":"(I8+CashReceipts[[#Totals],[Jun-xx]])","v":0},{"$f":"(J8+CashReceipts[[#Totals],[Jul-xx]])","v":0},{"$f":"(K8+CashReceipts[[#Totals],[Aug-xx]])","v":0},{"$f":"(L8+CashReceipts[[#Totals],[Sep-xx]])","v":0},{"$f":"(M8+CashReceipts[[#Totals],[Okt-xx]])","v":0},{"$f":"(N8+CashReceipts[[#Totals],[Nov-xx]])","v":0},{"$f":"(O8+CashReceipts[[#Totals],[Dez-xx]])","v":0}]
[]
[null,"BARAUSZAHLUNGEN"," ","Jan-xx","Feb-xx","Mär-xx","Apr-xx","Mai-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dez-xx","Summe"]
[null,"Werbungskosten",{"$nulls":13},{"$f":"SUM(D21:O21)","v":0}]
[null,"Gebühren und Provisionen",{"$nulls":13},0]
[null,"Vertragsarbeit",{"$nulls":13},0]
[null,"Besondere Sozialleistungen",{"$nulls":13},0]
[null,"Versicherungen (außer Krankenversicherung)",{"$nulls":13},0]
[null,"Zinsbelastung",{"$nulls":13},0]
[null,"Verbrauchsmaterialien und Betriebsmittel (in COGS)",{"$nulls":13},0]
[null,"Verpflegung und Bewirtung",{"$nulls":13},0]
[null,"Hypothekenzinsen",{"$nulls":13},0]
[null,"Büroausgaben",{"$nulls":13},0]
[null,"Sonstige Zinsbelastungen",{"$nulls":13},0]
[null,"Renten- und Gewinnbeteiligungsprogramm",{"$nulls":13},0]
[null,"Käufe für den Weiterverkauf",{"$nulls":13},0]
[null,"Miete oder Leasing",{"$nulls":13},0]
[null,"Miete oder Leasing: Fahrzeuge, Ausrüstung",{"$nulls":13},0]
[null,"Reparaturen und Wartung",{"$nulls":13},0]
[null,"Zubehör (nicht in COGS)",{"$nulls":13},0]
[null,"Steuern und Lizenzen",{"$nulls":13},0]
[null,"Reise",{"$nulls":13},0]
[null,"Nebenkosten",{"$nulls":13},0]
[null,"Lohn (abzüglich Mitarbeitergutschriften)",{"$nulls":13},0]
[null,"Sonstige Kosten",{"$nulls":13},0]
[null,"Sonstige Kosten",{"$nulls":13},0]
[null,"Sonstige Kosten",{"$nulls":13},0]
[null,"Sonstiges",{"$nulls":13},0]
[null,"ZWISCHENSUMME",null,{"$f":"SUBTOTAL(109,Ausgaben[Jan-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Feb-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Mär-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Apr-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Mai-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Jun-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Jul-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Aug-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Sep-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Okt-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Nov-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Dez-xx])","v":0},{"$f":"SUBTOTAL(109,Ausgaben[Summe])","v":0}]
[null,"BARAUSZAHLUNGEN"," ","Jan-xx","Feb-xx","Mär-xx","Apr-xx","Mai-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dez-xx","Summe"]
[null,"Darlehensrate",{"$nulls":13},{"$f":"SUM(D48:O48)","v":0}]
[null,"Kapitalkäufe",{"$nulls":13},0]
[null,"Sonstige Startup-Kosten",{"$nulls":13},0]
[null,"Reserven und/oder Anderkonten",{"$nulls":13},0]
[null,"Entnahmen des Eigentümers",{"$nulls":13},0]
[null,"BARAUSZAHLUNGEN GESAMT",null,{"$f":"Ausgaben[[#Totals],[Jan-xx]]+SUBTOTAL(109,CashPaidOut[Jan-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Feb-xx]]+SUBTOTAL(109,CashPaidOut[Feb-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Mär-xx]]+SUBTOTAL(109,CashPaidOut[Mär-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Apr-xx]]+SUBTOTAL(109,CashPaidOut[Apr-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Mai-xx]]+SUBTOTAL(109,CashPaidOut[Mai-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Jun-xx]]+SUBTOTAL(109,CashPaidOut[Jun-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Jul-xx]]+SUBTOTAL(109,CashPaidOut[Jul-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Aug-xx]]+SUBTOTAL(109,CashPaidOut[Aug-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Sep-xx]]+SUBTOTAL(109,CashPaidOut[Sep-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Okt-xx]]+SUBTOTAL(109,CashPaidOut[Okt-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Nov-xx]]+SUBTOTAL(109,CashPaidOut[Nov-xx])","v":0},{"$f":"Ausgaben[[#Totals],[Dez-xx]]+SUBTOTAL(109,CashPaidOut[Dez-xx])","v":0},0]
[null,"Kassenbestand (Monatsende)",{"$f":"C18","v":0},{"$f":"D18-CashPaidOut[[#Totals],[Jan-xx]]","v":0},{"$f":"E18-CashPaidOut[[#Totals],[Feb-xx]]","v":0},{"$f":"F18-CashPaidOut[[#Totals],[Mär-xx]]","v":0},{"$f":"G18-CashPaidOut[[#Totals],[Apr-xx]]","v":0},{"$f":"H18-CashPaidOut[[#Totals],[Mai-xx]]","v":0},{"$f":"I18-CashPaidOut[[#Totals],[Jun-xx]]","v":0},{"$f":"J18-CashPaidOut[[#Totals],[Jul-xx]]","v":0},{"$f":"K18-CashPaidOut[[#Totals],[Aug-xx]]","v":0},{"$f":"L18-CashPaidOut[[#Totals],[Sep-xx]]","v":0},{"$f":"M18-CashPaidOut[[#Totals],[Okt-xx]]","v":0},{"$f":"N18-CashPaidOut[[#Totals],[Nov-xx]]","v":0},{"$f":"O18-CashPaidOut[[#Totals],[Dez-xx]]","v":0}]
[]
[null,"SONSTIGE BETRIEBSDATEN"," ","Jan-xx","Feb-xx","Mär-xx","Apr-xx","Mai-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dez-xx","Summe"]
[null,"Umsatzvolumen (Euro)",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-xx]:[Dez-xx]])","v":0}]
[null,"Forderungssaldo",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dez-xx]])","v":0}]
[null,"Schuldensaldo",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dez-xx]])","v":0}]
[null,"Lagerbestand",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dez-xx]])","v":0}]
[null,"Schuldpostensaldo",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dez-xx]])","v":0}]
[null,"Abschreibung",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-xx]:[Dez-xx]])","v":0}]

{"sheet":"Cashflow-Diagramm","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[1,1,1,5],[53,2,53,3]]}
[]
[null,"Benachrichtigung bei Mindestwert des Kassenbestands:",{"$nulls":4},{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"0 €"}}]