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

{"sheet":"Liquiditätsplan","index":0,"n_rows":72,"n_cols":14,"rows_kept":72,"merged":[[0,0,0,13],[1,1,1,3],[2,1,2,13],[8,0,8,13],[20,0,20,13],[26,0,26,13],[45,0,45,13],[48,0,48,13],[60,0,60,13]]}
["Liquiditätsplanung (12 Monate)"]
["Name / Firma:","Beispiel GmbH",null,null,"Jahr:",2026,"Währung:","EUR"]
["Hinweis:","Eingaben nur in gelb markierten Feldern. Monate in Zeile 22 überschreibbar."]
[]
["Beträge in €"]
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Summe"]
["Übertrag Liquiditäts-Endbestand Vormonat",{"v":15000,"d":"15,000.00 €"},{"$f":"B56","v":{"v":14560,"d":"14,560.00 €"}},{"v":20450,"d":"20,450.00 €"},{"v":-13080,"d":"-13,080.00 €"},{"v":-22110,"d":"-22,110.00 €"},{"v":-27440,"d":"-27,440.00 €"},{"v":-29220,"d":"-29,220.00 €"},{"v":-34570,"d":"-34,570.00 €"},{"v":-39730,"d":"-39,730.00 €"},{"v":-44140,"d":"-44,140.00 €"},{"v":-50220,"d":"-50,220.00 €"},{"v":-53850,"d":"-53,850.00 €"},""]
[]
["A) Einzahlungen (brutto)"]
["Forderungen aus Lieferung u. Leistungen",{"v":18000,"d":"18,000.00 €"},{"v":19000,"d":"19,000.00 €"},{"v":21000,"d":"21,000.00 €"},{"v":22000,"d":"22,000.00 €"},{"v":24000,"d":"24,000.00 €"},{"v":23000,"d":"23,000.00 €"},{"v":25000,"d":"25,000.00 €"},{"v":24500,"d":"24,500.00 €"},{"v":26000,"d":"26,000.00 €"},{"v":27000,"d":"27,000.00 €"},{"v":28000,"d":"28,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"$f":"SUM(B10:M10)","v":{"v":287500,"d":"287,500.00 €"}}]
["Barverkäufe",{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":24000,"d":"24,000.00 €"}]
["erwartete Kundenanzahlungen",{"v":1500,"d":"1,500.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1400,"d":"1,400.00 €"},{"v":1600,"d":"1,600.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1700,"d":"1,700.00 €"},{"v":1900,"d":"1,900.00 €"},{"v":2100,"d":"2,100.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":21900,"d":"21,900.00 €"}]
["Eigenkapital-Einlagen",{"v":10000,"d":"10,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":10000,"d":"10,000.00 €"}]
["Kreditauszahlung",{"v":0,"d":"0.00 €"},{"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":20000,"d":"20,000.00 €"}]
["Desinvestment und 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":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":5000,"d":"5,000.00 €"}]
["sonstige Einnahmen",{"v":300,"d":"300.00 €"},{"v":400,"d":"400.00 €"},{"v":350,"d":"350.00 €"},{"v":300,"d":"300.00 €"},{"v":500,"d":"500.00 €"},{"v":450,"d":"450.00 €"},{"v":400,"d":"400.00 €"},{"v":380,"d":"380.00 €"},{"v":420,"d":"420.00 €"},{"v":500,"d":"500.00 €"},{"v":450,"d":"450.00 €"},{"v":600,"d":"600.00 €"},{"v":5050,"d":"5,050.00 €"}]
["Summe Liquiditätszugang",{"$f":"SUM(B10:B16)","v":{"v":31800,"d":"31,800.00 €"}},{"v":42600,"d":"42,600.00 €"},{"v":24750,"d":"24,750.00 €"},{"v":25900,"d":"25,900.00 €"},{"v":28500,"d":"28,500.00 €"},{"v":32250,"d":"32,250.00 €"},{"v":29100,"d":"29,100.00 €"},{"v":28780,"d":"28,780.00 €"},{"v":30520,"d":"30,520.00 €"},{"v":31700,"d":"31,700.00 €"},{"v":32450,"d":"32,450.00 €"},{"v":35100,"d":"35,100.00 €"},{"v":373450,"d":"373,450.00 €"}]
[]
["Rechengröße: vereinnahmte Umsatzsteuer (Mehrwertsteuer)",{"v":3400,"d":"3,400.00 €"},{"v":3600,"d":"3,600.00 €"},{"v":3900,"d":"3,900.00 €"},{"v":4100,"d":"4,100.00 €"},{"v":4400,"d":"4,400.00 €"},{"v":4250,"d":"4,250.00 €"},{"v":4650,"d":"4,650.00 €"},{"v":4580,"d":"4,580.00 €"},{"v":4900,"d":"4,900.00 €"},{"v":5100,"d":"5,100.00 €"},{"v":5300,"d":"5,300.00 €"},{"v":5700,"d":"5,700.00 €"},{"$f":"SUM(B19:M19)","v":{"v":53880,"d":"53,880.00 €"}}]
[]
["B) Auszahlungen für Investitionen"]
["Grundstück/Gebäude/Umbaumaßnahmen",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":25000,"d":"25,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 €"},{"$f":"SUM(B22:M22)","v":{"v":25000,"d":"25,000.00 €"}}]
["Anschaffung Maschinen/Geräte",{"v":0,"d":"0.00 €"},{"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 €"},{"$f":"SUM(B23:M23)","v":{"v":5000,"d":"5,000.00 €"}}]
["Büroausstattung, PCs, Firmenfahrzeug",{"v":1200,"d":"1,200.00 €"},{"v":800,"d":"800.00 €"},{"v":0,"d":"0.00 €"},{"v":500,"d":"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 €"},{"$f":"SUM(B24:M24)","v":{"v":2500,"d":"2,500.00 €"}}]
["Summe Investitionsausgaben",{"$f":"SUM(B22:B24)","v":{"v":1200,"d":"1,200.00 €"}},{"v":5800,"d":"5,800.00 €"},{"v":25000,"d":"25,000.00 €"},{"v":500,"d":"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 €"},{"$f":"SUM(B25:M25)","v":{"v":32500,"d":"32,500.00 €"}}]
[]
["C) Auszahlungen für betriebliche Kosten"]
["Ware, Material, Roh-/Hilfs-/Betriebsstoffe",{"v":9000,"d":"9,000.00 €"},{"v":9500,"d":"9,500.00 €"},{"v":10000,"d":"10,000.00 €"},{"v":10200,"d":"10,200.00 €"},{"v":11000,"d":"11,000.00 €"},{"v":10800,"d":"10,800.00 €"},{"v":11200,"d":"11,200.00 €"},{"v":11000,"d":"11,000.00 €"},{"v":11500,"d":"11,500.00 €"},{"v":11800,"d":"11,800.00 €"},{"v":12000,"d":"12,000.00 €"},{"v":12500,"d":"12,500.00 €"},{"$f":"SUM(B28:M28)","v":{"v":130500,"d":"130,500.00 €"}}]
["Personalkosten",{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":108000,"d":"108,000.00 €"}]
["Fremdleistungen",{"v":2000,"d":"2,000.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2100,"d":"2,100.00 €"},{"v":2300,"d":"2,300.00 €"},{"v":2400,"d":"2,400.00 €"},{"v":2350,"d":"2,350.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2600,"d":"2,600.00 €"},{"v":2700,"d":"2,700.00 €"},{"v":2650,"d":"2,650.00 €"},{"v":2800,"d":"2,800.00 €"},{"v":28400,"d":"28,400.00 €"}]
["Miete einschl. Nebenkosten",{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":26400,"d":"26,400.00 €"}]
["Leasing Maschinen",{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":12000,"d":"12,000.00 €"}]
["Reparaturen, Wartung",{"v":300,"d":"300.00 €"},{"v":250,"d":"250.00 €"},{"v":400,"d":"400.00 €"},{"v":350,"d":"350.00 €"},{"v":300,"d":"300.00 €"},{"v":450,"d":"450.00 €"},{"v":320,"d":"320.00 €"},{"v":280,"d":"280.00 €"},{"v":300,"d":"300.00 €"},{"v":500,"d":"500.00 €"},{"v":350,"d":"350.00 €"},{"v":400,"d":"400.00 €"},{"v":4200,"d":"4,200.00 €"}]
["KFZ-Kosten: Leasing, Steuern, Versicherung",{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":9600,"d":"9,600.00 €"}]
["KFZ-Kosten: Benzin, Instandhaltung, Pflege",{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":3600,"d":"3,600.00 €"}]
["Sonstige Reisekosten",{"v":400,"d":"400.00 €"},{"v":350,"d":"350.00 €"},{"v":450,"d":"450.00 €"},{"v":500,"d":"500.00 €"},{"v":550,"d":"550.00 €"},{"v":600,"d":"600.00 €"},{"v":500,"d":"500.00 €"},{"v":450,"d":"450.00 €"},{"v":500,"d":"500.00 €"},{"v":650,"d":"650.00 €"},{"v":550,"d":"550.00 €"},{"v":700,"d":"700.00 €"},{"v":6200,"d":"6,200.00 €"}]
["Betriebl. Versicherungen / Beiträge",{"v":350,"d":"350.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":350,"d":"350.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":350,"d":"350.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":350,"d":"350.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":1400,"d":"1,400.00 €"}]
["Telefon/Fax/Internet/Handy/Porto",{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":220,"d":"220.00 €"},{"v":2640,"d":"2,640.00 €"}]
["Werbekosten, Internet, Messen, Bewirtung",{"v":500,"d":"500.00 €"},{"v":600,"d":"600.00 €"},{"v":800,"d":"800.00 €"},{"v":700,"d":"700.00 €"},{"v":650,"d":"650.00 €"},{"v":900,"d":"900.00 €"},{"v":750,"d":"750.00 €"},{"v":700,"d":"700.00 €"},{"v":800,"d":"800.00 €"},{"v":850,"d":"850.00 €"},{"v":900,"d":"900.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":9350,"d":"9,350.00 €"}]
["Buchführungs- und Steuerberatungskosten",{"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 €"}]
["Rechtsanwalts- und Beratungskosten",{"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":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":500,"d":"500.00 €"}]
["Sonstige Kosten (z.B. Gebühren, Abgaben)",{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":3600,"d":"3,600.00 €"}]
["Anzahlungen an Lieferanten",{"v":1000,"d":"1,000.00 €"},{"v":800,"d":"800.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":900,"d":"900.00 €"},{"v":1100,"d":"1,100.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":950,"d":"950.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1100,"d":"1,100.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1300,"d":"1,300.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":13050,"d":"13,050.00 €"}]
["Summe betriebliche Kosten",{"$f":"B28+B29+B30+B31+B32+B33+B34+B35+B36+B37+B38+B39+B40+B41+B42+B43","v":{"v":27820,"d":"27,820.00 €"}},{"v":27570,"d":"27,570.00 €"},{"v":29820,"d":"29,820.00 €"},{"v":29370,"d":"29,370.00 €"},{"v":30170,"d":"30,170.00 €"},{"v":30420,"d":"30,420.00 €"},{"v":30690,"d":"30,690.00 €"},{"v":30200,"d":"30,200.00 €"},{"v":31070,"d":"31,070.00 €"},{"v":32320,"d":"32,320.00 €"},{"v":32020,"d":"32,020.00 €"},{"v":33370,"d":"33,370.00 €"},{"v":364840,"d":"364,840.00 €"}]
[]
["D) Mittelabfluß aus Finanzierungen"]
["Zinsen für Darlehen und Kontokorrentkredite",{"v":220,"d":"220.00 €"},{"v":240,"d":"240.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"v":260,"d":"260.00 €"},{"$f":"SUM(B47:M47)","v":{"v":3060,"d":"3,060.00 €"}}]
["Tilgungsraten Darlehen",{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"v":800,"d":"800.00 €"},{"$f":"SUM(B48:M48)","v":{"v":9600,"d":"9,600.00 €"}}]
["E) Betriebliche Steuern"]
["Umsatzsteuer (Zahllast oder Erstattung)",{"v":1200,"d":"1,200.00 €"},{"v":1300,"d":"1,300.00 €"},{"v":1400,"d":"1,400.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1600,"d":"1,600.00 €"},{"v":1550,"d":"1,550.00 €"},{"v":1700,"d":"1,700.00 €"},{"v":1680,"d":"1,680.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1900,"d":"1,900.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":2200,"d":"2,200.00 €"},{"$f":"SUM(B50:M50)","v":{"v":19830,"d":"19,830.00 €"}}]
["Steuern (Voraus-, Nachzahlungen für GewSt, KöSt)",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":1500,"d":"1,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":1500,"d":"1,500.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":3000,"d":"3,000.00 €"}]
["Kapitalentnahmen",{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":12000,"d":"12,000.00 €"}]
["Summe Liquiditätsabgang",{"$f":"B25+B44+B47+B48+B50+B51+B52","v":{"v":32240,"d":"32,240.00 €"}},{"v":36710,"d":"36,710.00 €"},{"v":58280,"d":"58,280.00 €"},{"v":34930,"d":"34,930.00 €"},{"v":33830,"d":"33,830.00 €"},{"v":34030,"d":"34,030.00 €"},{"v":34450,"d":"34,450.00 €"},{"v":33940,"d":"33,940.00 €"},{"v":34930,"d":"34,930.00 €"},{"v":37780,"d":"37,780.00 €"},{"v":36080,"d":"36,080.00 €"},{"v":37630,"d":"37,630.00 €"},{"v":444830,"d":"444,830.00 €"}]
["Rechengröße: gezahlte Umsatzsteuer (Vorsteuer)",{"v":900,"d":"900.00 €"},{"v":950,"d":"950.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1050,"d":"1,050.00 €"},{"v":1100,"d":"1,100.00 €"},{"v":1080,"d":"1,080.00 €"},{"v":1150,"d":"1,150.00 €"},{"v":1130,"d":"1,130.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1300,"d":"1,300.00 €"},{"v":1400,"d":"1,400.00 €"},{"v":13510,"d":"13,510.00 €"}]
["+/- Mittelfluß an Konzernunternehmen",{"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 €"},{"v":0,"d":"0.00 €"}]
["Liquiditätssaldo (Endbestand Monat)",{"$f":"B7+B17-B53","v":{"v":14560,"d":"14,560.00 €"}},{"v":20450,"d":"20,450.00 €"},{"v":-13080,"d":"-13,080.00 €"},{"v":-22110,"d":"-22,110.00 €"},{"v":-27440,"d":"-27,440.00 €"},{"v":-29220,"d":"-29,220.00 €"},{"v":-34570,"d":"-34,570.00 €"},{"v":-39730,"d":"-39,730.00 €"},{"v":-44140,"d":"-44,140.00 €"},{"v":-50220,"d":"-50,220.00 €"},{"v":-53850,"d":"-53,850.00 €"},{"v":-56380,"d":"-56,380.00 €"},{"v":-335730,"d":"-335,730.00 €"}]
[]
[]
[]
[]
["Kontokorrent / Linien"]
["Bank 1",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":8000,"d":"8,000.00 €"},{"v":12000,"d":"12,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":7000,"d":"7,000.00 €"},{"v":5000,"d":"5,000.00 €"},{"v":4000,"d":"4,000.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B62:M62)","v":{"v":51000,"d":"51,000.00 €"}}]
["Bank 2",{"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 €"},{"v":0,"d":"0.00 €"}]
["Bank 3",{"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 €"},{"v":0,"d":"0.00 €"}]
["Bank 4",{"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 €"},{"v":0,"d":"0.00 €"}]
["Bank 5",{"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 €"},{"v":0,"d":"0.00 €"}]
["Bank 6",{"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 €"},{"v":0,"d":"0.00 €"}]
["Summe KK Stände (Inanspruchnahmen)",{"$f":"SUM(B62:B67)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":8000,"d":"8,000.00 €"},{"v":12000,"d":"12,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":7000,"d":"7,000.00 €"},{"v":5000,"d":"5,000.00 €"},{"v":4000,"d":"4,000.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":2000,"d":"2,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":0,"d":"0.00 €"},{"v":51000,"d":"51,000.00 €"}]
[]
["Linien zzgl. Festgelder",{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"v":30000,"d":"30,000.00 €"},{"$f":"SUM(B70:M70)","v":{"v":360000,"d":"360,000.00 €"}}]
[]
["Freie Linien",{"$f":"B70-B68","v":{"v":30000,"d":"30,000.00 €"}},{"v":30000,"d":"30,000.00 €"},{"v":22000,"d":"22,000.00 €"},{"v":18000,"d":"18,000.00 €"},{"v":21000,"d":"21,000.00 €"},{"v":23000,"d":"23,000.00 €"},{"v":25000,"d":"25,000.00 €"},{"v":26000,"d":"26,000.00 €"},{"v":27000,"d":"27,000.00 €"},{"v":28000,"d":"28,000.00 €"},{"v":29000,"d":"29,000.00 €"},{"v":30000,"d":"30,000.00 €"},""]