{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":44,"n_cols":19,"rows_kept":44,"cut":false,"hidden":false,"merged":[[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5],[0,0,0,7],[9,1,9,5],[10,1,10,5],[11,1,11,5],[7,1,7,5],[8,1,8,5],[5,0,6,5],[2,0,2,3],[3,0,3,3],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[33,1,33,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[42,1,42,5],[43,1,43,5],[2,4,2,7],[3,4,3,7],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[34,1,34,5],[35,1,35,5],[28,1,28,5],[36,1,36,5],[37,1,37,5],[30,1,30,5],[31,1,31,5],[32,1,32,5]]}
["Liquiditätsplan"]
[]
["Liquiditätsplan für Firma"]
["Anfangsdatum"]
[]
[null,null,null,null,null,null,"Total",{"$f":"IF($E$4<>0,+$E$4,\"Monat 1\")","v":"Monat 1"},{"$f":"IF(H6=\"Monat 1\",\"Monat 2\",+H6+31)","v":"Monat 2"},{"$f":"IF(I6=\"Monat 2\",\"Monat 3\",+I6+31)","v":"Monat 3"},{"$f":"IF(J6=\"Monat 3\",\"Monat 4\",+J6+31)","v":"Monat 4"},{"$f":"IF(K6=\"Monat 4\",\"Monat 5\",+K6+31)","v":"Monat 5"},{"$f":"IF(L6=\"Monat 5\",\"Monat 6\",+L6+31)","v":"Monat 6"},{"$f":"IF(M6=\"Monat 6\",\"Monat 7\",+M6+31)","v":"Monat 7"},{"$f":"IF(N6=\"Monat 7\",\"Monat 8\",+N6+31)","v":"Monat 8"},{"$f":"IF(O6=\"Monat 8\",\"Monat 9\",+O6+31)","v":"Monat 9"},{"$f":"IF(P6=\"Monat 9\",\"Monat 10\",+P6+31)","v":"Monat 10"},{"$f":"IF(Q6=\"Monat 10\",\"Monat 11\",+Q6+31)","v":"Monat 11"},{"$f":"IF(R6=\"Monat 11\",\"Monat 12\",+R6+31)","v":"Monat 12"}]
[null,null,null,null,null,null,"Total Soll","Soll","Soll","Soll","Soll","Soll","Soll","Soll","Soll","Soll","Soll","Soll","Soll"]
[null,"Bestand Kasse, Post, Bank",null,null,null,null,{"$f":"+H8","v":0},null,{"$f":"+H42","v":0},0,0,0,0,0,0,0,0,0,0]
["+","Barverkäufe",null,null,null,null,{"$f":"SUM(H9,I9,J9,K9,L9,M9,N9,O9,P9,Q9,R9,S9)","v":0}]
["+","Debitorenzahlungen",null,null,null,null,{"$f":"SUM(H10,I10,J10,K10,L10,M10,N10,O10,P10,Q10,R10,S10)","v":0}]
["+","Weitere Bareingänge (Miete, Wertschriften, Zinsen)",null,null,null,null,{"$f":"SUM(H11,I11,J11,K11,L11,M11,N11,O11,P11,Q11,R11,S11)","v":0}]
["+",null,null,null,null,null,{"$f":"SUM(H12,I12,J12,K12,L12,M12,N12,O12,P12,Q12,R12,S12)","v":0}]
["+",null,null,null,null,null,{"$f":"SUM(H13,I13,J13,K13,L13,M13,N13,O13,P13,Q13,R13,S13)","v":0}]
["=","Einzahlungen total",null,null,null,null,{"$f":"SUM(G9:G13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Verfügbare Mittel 1",null,null,null,null,{"$f":"+G8+G14","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["-","Waren und Materialzahlungen",null,null,null,null,{"$f":"SUM(H16,I16,J16,K16,L16,M16,N16,O16,P16,Q16,R16,S16)","v":0}]
["-","Mehrwertsteuer",null,null,null,null,0]
["-","Personalaufwand",null,null,null,null,0]
["-","Sozialleistungen",null,null,null,null,0]
["-","Kapitalzinsen",null,null,null,null,0]
["-","Steuern",null,null,null,null,0]
["-","Versicherungen",null,null,null,null,0]
["-","Mieten",null,null,null,null,0]
["-","Büro- und Verwaltungsaufwand",null,null,null,null,0]
["-","Werbung",null,null,null,null,0]
["-","Unterhalt, Reparaturen, Ersatz",null,null,null,null,0]
["-","Sonstige Auszahlungen (Strom, Wasser usw.)",null,null,null,null,0]
["-",null,null,null,null,null,0]
["-",null,null,null,null,null,0]
["=","Auszahlungen Total",null,null,null,null,{"$f":"SUM(G16:G29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["=","Brutto-Geldzufluss/-Geldabfluss",null,null,null,null,{"$f":"G14-G30","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Verfügbare Mittel 2",null,null,null,null,{"$f":"+G15-G30","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["+","Einzahlungen aus Anlagenverkauf (Desinvestitionen)",null,null,null,null,{"$f":"SUM(H33,I33,J33,K33,L33,M33,N33,O33,P33,Q33,R33,S33)","v":0}]
["+","Einzahlungen aus Aussenfinanzierung (Kreditaufnahme)",null,null,null,null,0]
["+","Übrige Einzahlungen (Anzahlungen von Kunden, etc.)",null,null,null,null,0]
["+","Privateinlagen/Kapitalerhöhung",null,null,null,null,0]
["-","Auszahlungen für Investitionen",null,null,null,null,0]
["-","Kapitalrückzahlungen / Kreditauszahlungen an Dritte",null,null,null,null,0]
["-","Übrige Auszahlungen /Akontozahlungen an Lieferanten, etc.)",null,null,null,null,0]
["-","Privatentnahmen",null,null,null,null,0]
["=","Netto-Geldzufluss/Netto-Geldabfluss",null,null,null,null,{"$f":"G31+SUM(G33:G36)-SUM(G37:G40)","v":0},{"$f":"H31+SUM(H33:H36)-SUM(H37:H40)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Endbestand verfügbare Mittel",null,null,null,null,{"$f":"+G32+SUM(G33:G36)-SUM(G37:G40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["+","Kreditlimiten",null,null,null,null,{"$f":"S43","v":0},0,{"$f":"H43","v":0},{"$f":"I43","v":0},0,0,0,0,0,0,0,0,0]
["=","Überschuss / Manko",null,null,null,null,{"$f":"SUM(G42:G43)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]