{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Liquidiätsplan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"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":"Liquidiätsplan","index":0,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,24,1,26],[1,27,1,29],[4,25,4,26],[4,28,4,29],[9,7,14,18],[5,1,5,21],[2,7,2,9],[3,7,3,9],[2,1,2,4],[3,1,3,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aktuelles Jahr",null,null,"Vorjahr"]
[null,"Firma:",null,null,null,null,null,"Müller KG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahr","Monat","Tag","Jahr","Monat","Tag"]
[null,"Datum:",null,null,null,null,null,"2018-01-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+YEAR(H4)","v":2018},{"$f":"+MONTH(H4)","v":1},{"$f":"+DAY(H4)","v":31},{"$f":"+Y4-1","v":2017},{"$f":"+Z4","v":1},{"$f":"+AA4","v":31}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum",{"$f":"DATE(Y4,Z4,AA4)","v":"2018-01-31"},null,"Datum",{"$f":"DATE(AB4,AC4,AD4)","v":"2017-01-31"}]
[null,{"$f":"IF(OR(H3=\"\",H4=\"\"),\"Liquiditätsplan\",\"Liquidiätsplan der \"&H3&\" zum \"&AA4&\".\"&Z4&\".\"&Y4)","v":"Liquidiätsplan der Müller KG zum 31.1.2018"}]
[]
[]
[]
[null,null,null,"Vortragswerte",null,null,null,"Trotz zweier geplanter Investitionen in den Monaten April und September ist unsere Liquiditätslage als gut zu bezeichnen."]
[]
[null,null,null,null,"Vortrag liquide Mittel (Bank, Kasse …)",220000]
[null,null,null,null,"Kontokorrent",50000]
[]
[null,null,null,"Liquiditätswerte"]
[]
[null,null,null,null,null,null,null,{"$f":"+DATE(Y4,Z4,1)","v":"2018-01-01"},{"$f":"+H17+32","v":"2018-02-02"},"2018-03-06","2018-04-07","2018-05-09","2018-06-10","2018-07-12","2018-08-13","2018-09-14","2018-10-16","2018-11-17","2018-12-19"]
[null,null,null,"1. Einnahmen – Liquiditätszufluss"]
[null,null,null,null,"Umsatzerlöse (Zahlungseingang)",null,null,325000,340000,295000,275000,290000,240000,210000,225000,245000,255000,280000,268000]
[null,null,null,null,"Erhaltene Anzahlungen",null,null,10000,0,0,15000,0,0,0,0,10000,0,0,1000]
[null,null,null,null,"Sonstige Einnahmen",null,null,10000,5000,2000,4000,5000,10000,5000,2000,4000,5000,2000,1000]
[null,null,null,null,"Sonstige Einnahmen",null,null,0,5000,0,0,0,5000,0,0,0,10000,0,0]
[null,null,null,null,"Summe Einnahmen – Liquiditätszufluss",null,null,{"$f":"SUM(H19:H22)","v":345000},350000,297000,294000,295000,255000,215000,227000,259000,270000,282000,270000]
[]
[null,null,null,"2. Ausgaben – Liquiditätsabfluss"]
[null,null,null,null,"Ausgaben/Auszahlungen allgemein",null,null,25000,70000,30000,40000,50000,20000,15000,10000,2000,40000,25000,10000]
[null,null,null,null,"Löhne und Gehälter",null,null,70000,70000,70000,70000,70000,80000,70000,70000,70000,70000,100000,70000]
[null,null,null,null,"Sozialabgaben",null,null,20000,20000,20000,20000,20000,25000,20000,20000,20000,20000,40000,20000]
[null,null,null,null,"Wareneinsatz ",null,null,50000,70000,40000,70000,20000,30000,20000,50000,20000,10000,15000,10000]
[null,null,null,null,"Mieten",null,null,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,null,null,null,"Betriebliche Steuern",null,null,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000]
[null,null,null,null,"Versicherungen",null,null,3000,20000,10000,12000,4000,2000,1000,3000,1000,2000,3000,1000]
[null,null,null,null,"Zinsen",null,null,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000]
[null,null,null,null,"Geleistete Anzahlungen",null,null,12000,0,0,0,0,0,10000,0,0,0,0,0]
[null,null,null,null,"Tilgungen für Kredite",null,null,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[null,null,null,null,"Investitionen",null,null,18000,10000,5000,2000,1000,5000,10000,8000,15000,20000,3000,5000]
[null,null,null,null,"Sonstige Ausgaben",null,null,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,null,null,null,"Sonstige Ausgaben",null,null,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,null,null,null,"Sonstige Ausgaben",null,null,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,null,null,null,"Summe Ausgaben – Liquiditätsabfluss",null,null,{"$f":"SUM(H26:H39)","v":267000},329000,244000,283000,234000,231000,215000,230000,197000,231000,255000,185000]
[]
[null,null,null,"3. Kapitalverwendung"]
[null,null,null,null,"Tilgung (–)/Aufnahme (+) von Darlehen",null,null,-50000,null,null,-50000,null,null,-50000,null,null,-50000]
[null,null,null,null,"Erhöhung (–)/Verminderung (+) von Finanzanlagen"]
[null,null,null,null,"Entnahmen (–)/Einlagen (+)"]
[null,null,null,null,"Investitionen (– /Deinvestition (+)",null,null,null,null,null,-150000,null,null,null,-75000]
[null,null,null,null,"Summe Kapitalverwendung",null,null,{"$f":"SUM(H43:H46)","v":-50000},0,0,-200000,0,0,-50000,-75000,0,-50000,0,0]
[]
[null,null,null,"4. Liquiditätsveränderung"]
[null,null,null,null,"Liquiditätsveränderung im Monat",null,null,{"$f":"SUM(H23,-H40,H47)","v":28000},21000,53000,-189000,61000,24000,-50000,-78000,62000,-11000,27000,85000]
[null,null,null,null,"Liquiditätsveränderung kumuliert",null,null,{"$f":"+H50","v":28000},{"$f":"+I50+H51","v":49000},102000,-87000,-26000,-2000,-52000,-130000,-68000,-79000,-52000,33000]
[]
[null,null,null,"5. Kontokorrent","Feststellung des Liquiditätsstatus"]
[null,null,null,null,"Liquide Mittel",{"$f":"+F12","v":220000},null,{"$f":"+F54+H50","v":248000},{"$f":"+H54+I50","v":269000},{"$f":"+I54+J50","v":322000},133000,194000,218000,168000,90000,152000,141000,168000,253000]
[null,null,null,null,"Verfügbarer Kontokorrent",{"$f":"+F13","v":50000},null,{"$f":"+$F$13","v":50000},50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,null,null,null,"Summe liquide Mittel",null,null,{"$f":"SUM(H54:H55)","v":298000},{"$f":"SUM(I54:I55)","v":319000},372000,183000,244000,268000,218000,140000,202000,191000,218000,303000]