{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Liquiditätsplanung"],"read":"whole","date_system":"1900"}

{"sheet":"Liquiditätsplanung","index":0,"n_rows":43,"n_cols":14,"rows_kept":43,"merged":[[0,0,0,13],[10,0,10,13],[20,0,20,13]]}
["Liquiditätsplanung (Liquiditätsplan / Cashflow-Plan)"]
[]
["Unternehmen","Beispiel GmbH"]
["Startmonat (Datum)","2026-01-01"]
["Währung","EUR"]
["Kontokorrent-Limit",{"v":10000,"d":"€ 10,000.00"}]
[]
["Finanzposition",{"$f":"CHOOSE(MONTH(EDATE($B$4,0)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Januar"},{"$f":"CHOOSE(MONTH(EDATE($B$4,1)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Februar"},{"$f":"CHOOSE(MONTH(EDATE($B$4,2)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"März"},{"$f":"CHOOSE(MONTH(EDATE($B$4,3)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"April"},{"$f":"CHOOSE(MONTH(EDATE($B$4,4)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Mai"},{"$f":"CHOOSE(MONTH(EDATE($B$4,5)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Juni"},{"$f":"CHOOSE(MONTH(EDATE($B$4,6)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Juli"},{"$f":"CHOOSE(MONTH(EDATE($B$4,7)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"August"},{"$f":"CHOOSE(MONTH(EDATE($B$4,8)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"September"},{"$f":"CHOOSE(MONTH(EDATE($B$4,9)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Oktober"},{"$f":"CHOOSE(MONTH(EDATE($B$4,10)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"November"},{"$f":"CHOOSE(MONTH(EDATE($B$4,11)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Dezember"},"Gesamt"]
["Anfangsbestand an liquiden Mitteln",{"v":25000,"d":"€ 25,000.00"},{"$f":"B41","v":{"v":33420,"d":"€ 33,420.00"}},{"v":33580,"d":"€ 33,580.00"},{"v":34530,"d":"€ 34,530.00"},{"v":35550,"d":"€ 35,550.00"},{"v":37980,"d":"€ 37,980.00"},{"v":40450,"d":"€ 40,450.00"},{"v":42680,"d":"€ 42,680.00"},{"v":46150,"d":"€ 46,150.00"},{"v":52980,"d":"€ 52,980.00"},{"v":56880,"d":"€ 56,880.00"},{"v":61450,"d":"€ 61,450.00"}]
[]
["Einzahlungen"]
["Forderungen aus Lieferung und Leistungen",{"v":18000,"d":"€ 18,000.00"},{"v":19000,"d":"€ 19,000.00"},{"v":20000,"d":"€ 20,000.00"},{"v":21000,"d":"€ 21,000.00"},{"v":22000,"d":"€ 22,000.00"},{"v":22500,"d":"€ 22,500.00"},{"v":23000,"d":"€ 23,000.00"},{"v":24000,"d":"€ 24,000.00"},{"v":25000,"d":"€ 25,000.00"},{"v":25500,"d":"€ 25,500.00"},{"v":26000,"d":"€ 26,000.00"},{"v":27000,"d":"€ 27,000.00"},{"$f":"SUM(B12:M12)","v":{"v":273000,"d":"€ 273,000.00"}}]
["Barverkäufe",{"v":2500,"d":"€ 2,500.00"},{"v":2600,"d":"€ 2,600.00"},{"v":2550,"d":"€ 2,550.00"},{"v":2700,"d":"€ 2,700.00"},{"v":2800,"d":"€ 2,800.00"},{"v":2750,"d":"€ 2,750.00"},{"v":2900,"d":"€ 2,900.00"},{"v":3000,"d":"€ 3,000.00"},{"v":3100,"d":"€ 3,100.00"},{"v":3050,"d":"€ 3,050.00"},{"v":3200,"d":"€ 3,200.00"},{"v":3300,"d":"€ 3,300.00"},{"v":34450,"d":"€ 34,450.00"}]
["Erwartete Kundenanzahlungen",{"v":800,"d":"€ 800.00"},{"v":700,"d":"€ 700.00"},{"v":900,"d":"€ 900.00"},{"v":750,"d":"€ 750.00"},{"v":850,"d":"€ 850.00"},{"v":800,"d":"€ 800.00"},{"v":900,"d":"€ 900.00"},{"v":850,"d":"€ 850.00"},{"v":950,"d":"€ 950.00"},{"v":900,"d":"€ 900.00"},{"v":1000,"d":"€ 1,000.00"},{"v":950,"d":"€ 950.00"},{"v":10350,"d":"€ 10,350.00"}]
["Eigenkapital-Einlagen",{"v":5000,"d":"€ 5,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":5000,"d":"€ 5,000.00"}]
["Kreditauszahlung",{"v":20000,"d":"€ 20,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":20000,"d":"€ 20,000.00"}]
["Desinvestment / Anlageverkäufe",{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":2500,"d":"€ 2,500.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":2500,"d":"€ 2,500.00"}]
["Sonstige Einnahmen",{"v":300,"d":"€ 300.00"},{"v":250,"d":"€ 250.00"},{"v":300,"d":"€ 300.00"},{"v":280,"d":"€ 280.00"},{"v":300,"d":"€ 300.00"},{"v":300,"d":"€ 300.00"},{"v":320,"d":"€ 320.00"},{"v":320,"d":"€ 320.00"},{"v":340,"d":"€ 340.00"},{"v":320,"d":"€ 320.00"},{"v":350,"d":"€ 350.00"},{"v":360,"d":"€ 360.00"},{"v":3740,"d":"€ 3,740.00"}]
["Summe Einzahlungen",{"$f":"SUM(B12:B18)","v":{"v":46600,"d":"€ 46,600.00"}},{"v":22550,"d":"€ 22,550.00"},{"v":23750,"d":"€ 23,750.00"},{"v":24730,"d":"€ 24,730.00"},{"v":25950,"d":"€ 25,950.00"},{"v":26350,"d":"€ 26,350.00"},{"v":27120,"d":"€ 27,120.00"},{"v":28170,"d":"€ 28,170.00"},{"v":31890,"d":"€ 31,890.00"},{"v":29770,"d":"€ 29,770.00"},{"v":30550,"d":"€ 30,550.00"},{"v":31610,"d":"€ 31,610.00"},{"v":349040,"d":"€ 349,040.00"}]
[]
["Auszahlungen"]
["Grundstück/Gebäude/Umbaumaßnahmen",{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"$f":"SUM(B22:M22)","v":{"v":0,"d":"€ 0.00"}}]
["Anschaffung Maschinen/Geräte",{"v":12000,"d":"€ 12,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":12000,"d":"€ 12,000.00"}]
["Büroausstattung, PCs, Firmenfahrzeug",{"v":3500,"d":"€ 3,500.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":3500,"d":"€ 3,500.00"}]
["Ware/Material/Roh-/Hilfs-/Betriebsstoffe",{"v":8000,"d":"€ 8,000.00"},{"v":8200,"d":"€ 8,200.00"},{"v":8400,"d":"€ 8,400.00"},{"v":8600,"d":"€ 8,600.00"},{"v":8800,"d":"€ 8,800.00"},{"v":9000,"d":"€ 9,000.00"},{"v":9200,"d":"€ 9,200.00"},{"v":9400,"d":"€ 9,400.00"},{"v":9600,"d":"€ 9,600.00"},{"v":9800,"d":"€ 9,800.00"},{"v":10000,"d":"€ 10,000.00"},{"v":10200,"d":"€ 10,200.00"},{"v":109200,"d":"€ 109,200.00"}]
["Personalkosten",{"v":7000,"d":"€ 7,000.00"},{"v":7000,"d":"€ 7,000.00"},{"v":7200,"d":"€ 7,200.00"},{"v":7200,"d":"€ 7,200.00"},{"v":7400,"d":"€ 7,400.00"},{"v":7400,"d":"€ 7,400.00"},{"v":7600,"d":"€ 7,600.00"},{"v":7600,"d":"€ 7,600.00"},{"v":7800,"d":"€ 7,800.00"},{"v":7800,"d":"€ 7,800.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":90000,"d":"€ 90,000.00"}]
["Fremdleistungen",{"v":2200,"d":"€ 2,200.00"},{"v":2400,"d":"€ 2,400.00"},{"v":2300,"d":"€ 2,300.00"},{"v":2500,"d":"€ 2,500.00"},{"v":2400,"d":"€ 2,400.00"},{"v":2600,"d":"€ 2,600.00"},{"v":2500,"d":"€ 2,500.00"},{"v":2700,"d":"€ 2,700.00"},{"v":2600,"d":"€ 2,600.00"},{"v":2700,"d":"€ 2,700.00"},{"v":2800,"d":"€ 2,800.00"},{"v":2900,"d":"€ 2,900.00"},{"v":30600,"d":"€ 30,600.00"}]
["Miete inkl. Nebenkosten",{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1500,"d":"€ 1,500.00"},{"v":18000,"d":"€ 18,000.00"}]
["Leasing Maschinen",{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":10800,"d":"€ 10,800.00"}]
["Reparaturen, Wartung",{"v":600,"d":"€ 600.00"},{"v":300,"d":"€ 300.00"},{"v":450,"d":"€ 450.00"},{"v":300,"d":"€ 300.00"},{"v":400,"d":"€ 400.00"},{"v":300,"d":"€ 300.00"},{"v":450,"d":"€ 450.00"},{"v":300,"d":"€ 300.00"},{"v":400,"d":"€ 400.00"},{"v":300,"d":"€ 300.00"},{"v":450,"d":"€ 450.00"},{"v":300,"d":"€ 300.00"},{"v":4550,"d":"€ 4,550.00"}]
["KFZ-Kosten (Leasing/Steuern/Vers.)",{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"},{"v":5400,"d":"€ 5,400.00"}]
["KFZ-Kosten (Benzin/Instandhaltung)",{"v":350,"d":"€ 350.00"},{"v":360,"d":"€ 360.00"},{"v":370,"d":"€ 370.00"},{"v":380,"d":"€ 380.00"},{"v":390,"d":"€ 390.00"},{"v":400,"d":"€ 400.00"},{"v":410,"d":"€ 410.00"},{"v":420,"d":"€ 420.00"},{"v":430,"d":"€ 430.00"},{"v":440,"d":"€ 440.00"},{"v":450,"d":"€ 450.00"},{"v":460,"d":"€ 460.00"},{"v":4860,"d":"€ 4,860.00"}]
["Versicherungen / Beiträge",{"v":500,"d":"€ 500.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":500,"d":"€ 500.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":500,"d":"€ 500.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":500,"d":"€ 500.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":2000,"d":"€ 2,000.00"}]
["Telefon/Internet/Porto",{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":180,"d":"€ 180.00"},{"v":2160,"d":"€ 2,160.00"}]
["Marketing/Werbung/Messen/Bewirtung",{"v":600,"d":"€ 600.00"},{"v":700,"d":"€ 700.00"},{"v":650,"d":"€ 650.00"},{"v":800,"d":"€ 800.00"},{"v":700,"d":"€ 700.00"},{"v":750,"d":"€ 750.00"},{"v":800,"d":"€ 800.00"},{"v":850,"d":"€ 850.00"},{"v":800,"d":"€ 800.00"},{"v":900,"d":"€ 900.00"},{"v":850,"d":"€ 850.00"},{"v":950,"d":"€ 950.00"},{"v":9350,"d":"€ 9,350.00"}]
["Steuerberatung / Buchführung / Sonstiges",{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":4800,"d":"€ 4,800.00"}]
["Summe Auszahlungen",{"$f":"SUM(B22:B36)","v":{"v":38180,"d":"€ 38,180.00"}},{"v":22390,"d":"€ 22,390.00"},{"v":22800,"d":"€ 22,800.00"},{"v":23710,"d":"€ 23,710.00"},{"v":23520,"d":"€ 23,520.00"},{"v":23880,"d":"€ 23,880.00"},{"v":24890,"d":"€ 24,890.00"},{"v":24700,"d":"€ 24,700.00"},{"v":25060,"d":"€ 25,060.00"},{"v":25870,"d":"€ 25,870.00"},{"v":25980,"d":"€ 25,980.00"},{"v":26240,"d":"€ 26,240.00"},{"v":307220,"d":"€ 307,220.00"}]
[]
["Netto-Cashflow (Einzahlungen - Auszahlungen)",{"$f":"B19-B37","v":{"v":8420,"d":"€ 8,420.00"}},{"v":160,"d":"€ 160.00"},{"v":950,"d":"€ 950.00"},{"v":1020,"d":"€ 1,020.00"},{"v":2430,"d":"€ 2,430.00"},{"v":2470,"d":"€ 2,470.00"},{"v":2230,"d":"€ 2,230.00"},{"v":3470,"d":"€ 3,470.00"},{"v":6830,"d":"€ 6,830.00"},{"v":3900,"d":"€ 3,900.00"},{"v":4570,"d":"€ 4,570.00"},{"v":5370,"d":"€ 5,370.00"},{"$f":"SUM(B39:M39)","v":{"v":41820,"d":"€ 41,820.00"}}]
[]
["Endbestand liquide Mittel",{"$f":"B9+B39","v":{"v":33420,"d":"€ 33,420.00"}},{"v":33580,"d":"€ 33,580.00"},{"v":34530,"d":"€ 34,530.00"},{"v":35550,"d":"€ 35,550.00"},{"v":37980,"d":"€ 37,980.00"},{"v":40450,"d":"€ 40,450.00"},{"v":42680,"d":"€ 42,680.00"},{"v":46150,"d":"€ 46,150.00"},{"v":52980,"d":"€ 52,980.00"},{"v":56880,"d":"€ 56,880.00"},{"v":61450,"d":"€ 61,450.00"},{"v":66820,"d":"€ 66,820.00"},{"$f":"M41","v":{"v":66820,"d":"€ 66,820.00"}}]
[]
["Liquidität inkl. Kontokorrent-Limit",{"$f":"B41+$B$6","v":{"v":43420,"d":"€ 43,420.00"}},{"v":43580,"d":"€ 43,580.00"},{"v":44530,"d":"€ 44,530.00"},{"v":45550,"d":"€ 45,550.00"},{"v":47980,"d":"€ 47,980.00"},{"v":50450,"d":"€ 50,450.00"},{"v":52680,"d":"€ 52,680.00"},{"v":56150,"d":"€ 56,150.00"},{"v":62980,"d":"€ 62,980.00"},{"v":66880,"d":"€ 66,880.00"},{"v":71450,"d":"€ 71,450.00"},{"v":76820,"d":"€ 76,820.00"},{"$f":"M43","v":{"v":76820,"d":"€ 76,820.00"}}]