{"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],[8,0,8,13],[18,0,18,13]]}
["Liquiditätsplanung (Angaben in Euro)"]
[]
["Startmonat (Datum, 1. des Monats)","2026-01-01","USt-Satz (z.B. 0,19)",null,{"v":0.19,"d":"19.00%"},"Wareneinsatz-Quote (z.B. 0,40)",null,{"v":0.4,"d":"40.00%"},"Limit Überziehungskredit",null,{"v":10000,"d":"€ 10,000.00"}]
[]
["Position",{"$f":"\"Ist \" & TEXT($B$3,\"mm/yyyy\")","v":"Ist 01/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,1),\"mm/yyyy\")","v":"Plan 02/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,2),\"mm/yyyy\")","v":"Plan 03/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,3),\"mm/yyyy\")","v":"Plan 04/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,4),\"mm/yyyy\")","v":"Plan 05/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,5),\"mm/yyyy\")","v":"Plan 06/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,6),\"mm/yyyy\")","v":"Plan 07/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,7),\"mm/yyyy\")","v":"Plan 08/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,8),\"mm/yyyy\")","v":"Plan 09/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,9),\"mm/yyyy\")","v":"Plan 10/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,10),\"mm/yyyy\")","v":"Plan 11/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,11),\"mm/yyyy\")","v":"Plan 12/yyyy"},{"$f":"\"Plan \" & TEXT(EDATE($B$3,12),\"mm/yyyy\")","v":"Plan 01/yyyy"}]
[]
["Liquide Mittel am Anfang des Monats",{"v":8000,"d":"€ 8,000.00"},{"$f":"B37","v":{"v":16720,"d":"€ 16,720.00"}},{"v":24060,"d":"€ 24,060.00"},{"v":31725,"d":"€ 31,725.00"},{"v":39850,"d":"€ 39,850.00"},{"v":47895,"d":"€ 47,895.00"},{"v":56555,"d":"€ 56,555.00"},{"v":64190,"d":"€ 64,190.00"},{"v":74535,"d":"€ 74,535.00"},{"v":84500,"d":"€ 84,500.00"},{"v":93925,"d":"€ 93,925.00"},{"v":104570,"d":"€ 104,570.00"},{"v":115780,"d":"€ 115,780.00"}]
[]
["Einzahlungen"]
["Umsatz (inkl. USt)",{"v":22000,"d":"€ 22,000.00"},{"v":24000,"d":"€ 24,000.00"},{"v":25500,"d":"€ 25,500.00"},{"v":26500,"d":"€ 26,500.00"},{"v":27500,"d":"€ 27,500.00"},{"v":29000,"d":"€ 29,000.00"},{"v":30500,"d":"€ 30,500.00"},{"v":31500,"d":"€ 31,500.00"},{"v":32500,"d":"€ 32,500.00"},{"v":33500,"d":"€ 33,500.00"},{"v":34500,"d":"€ 34,500.00"},{"v":36000,"d":"€ 36,000.00"},{"v":38000,"d":"€ 38,000.00"}]
["Erträge aus Kapitalanlagen",{"v":50,"d":"€ 50.00"},{"v":50,"d":"€ 50.00"},{"v":60,"d":"€ 60.00"},{"v":60,"d":"€ 60.00"},{"v":70,"d":"€ 70.00"},{"v":70,"d":"€ 70.00"},{"v":80,"d":"€ 80.00"},{"v":80,"d":"€ 80.00"},{"v":90,"d":"€ 90.00"},{"v":90,"d":"€ 90.00"},{"v":100,"d":"€ 100.00"},{"v":100,"d":"€ 100.00"},{"v":110,"d":"€ 110.00"}]
["Kreditaufnahme",{"v":5000,"d":"€ 5,000.00"}]
["Gründungszuschuss",{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"}]
["Sonstige Einzahlungen",{"$nulls":3},{"v":500,"d":"€ 500.00"},{"$nulls":3},{"v":800,"d":"€ 800.00"}]
["….."]
[]
["Summe Einzahlungen",{"$f":"SUM(B10:B15)","v":{"v":28250,"d":"€ 28,250.00"}},{"$f":"SUM(C10:C15)","v":{"v":25250,"d":"€ 25,250.00"}},{"$f":"SUM(D10:D15)","v":{"v":26760,"d":"€ 26,760.00"}},{"$f":"SUM(E10:E15)","v":{"v":27060,"d":"€ 27,060.00"}},{"$f":"SUM(F10:F15)","v":{"v":27570,"d":"€ 27,570.00"}},{"$f":"SUM(G10:G15)","v":{"v":29070,"d":"€ 29,070.00"}},{"$f":"SUM(H10:H15)","v":{"v":30580,"d":"€ 30,580.00"}},{"$f":"SUM(I10:I15)","v":{"v":32380,"d":"€ 32,380.00"}},{"$f":"SUM(J10:J15)","v":{"v":32590,"d":"€ 32,590.00"}},{"$f":"SUM(K10:K15)","v":{"v":33590,"d":"€ 33,590.00"}},{"$f":"SUM(L10:L15)","v":{"v":34600,"d":"€ 34,600.00"}},{"$f":"SUM(M10:M15)","v":{"v":36100,"d":"€ 36,100.00"}},{"$f":"SUM(N10:N15)","v":{"v":38110,"d":"€ 38,110.00"}}]
[]
["Auszahlungen"]
["Material und Betriebsstoffe",{"$f":"B10*$H$3","v":{"v":8800,"d":"€ 8,800.00"}},{"$f":"C10*$H$3","v":{"v":9600,"d":"€ 9,600.00"}},{"$f":"D10*$H$3","v":{"v":10200,"d":"€ 10,200.00"}},{"$f":"E10*$H$3","v":{"v":10600,"d":"€ 10,600.00"}},{"$f":"F10*$H$3","v":{"v":11000,"d":"€ 11,000.00"}},{"$f":"G10*$H$3","v":{"v":11600,"d":"€ 11,600.00"}},{"$f":"H10*$H$3","v":{"v":12200,"d":"€ 12,200.00"}},{"$f":"I10*$H$3","v":{"v":12600,"d":"€ 12,600.00"}},{"$f":"J10*$H$3","v":{"v":13000,"d":"€ 13,000.00"}},{"$f":"K10*$H$3","v":{"v":13400,"d":"€ 13,400.00"}},{"$f":"L10*$H$3","v":{"v":13800,"d":"€ 13,800.00"}},{"$f":"M10*$H$3","v":{"v":14400,"d":"€ 14,400.00"}},{"$f":"N10*$H$3","v":{"v":15200,"d":"€ 15,200.00"}}]
["Beratungskosten",{"v":1200,"d":"€ 1,200.00"},{"v":900,"d":"€ 900.00"},{"v":700,"d":"€ 700.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"},{"v":500,"d":"€ 500.00"}]
["Werbung, Marketing",{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":900,"d":"€ 900.00"},{"v":1000,"d":"€ 1,000.00"},{"v":1000,"d":"€ 1,000.00"},{"v":1000,"d":"€ 1,000.00"}]
["Reparatur und Instandhaltung"]
["Versicherungen",{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"}]
["Reisekosten",{"v":200,"d":"€ 200.00"},{"v":250,"d":"€ 250.00"},{"v":250,"d":"€ 250.00"},{"v":300,"d":"€ 300.00"},{"v":300,"d":"€ 300.00"},{"v":300,"d":"€ 300.00"},{"v":350,"d":"€ 350.00"},{"v":350,"d":"€ 350.00"},{"v":350,"d":"€ 350.00"},{"v":400,"d":"€ 400.00"},{"v":400,"d":"€ 400.00"},{"v":450,"d":"€ 450.00"},{"v":450,"d":"€ 450.00"}]
["Investitionen",{"v":3000,"d":"€ 3,000.00"},{"$nulls":5},{"v":1500,"d":"€ 1,500.00"}]
["Kreditraten (Tilgung und Zinsen)",null,{"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"}]
["Privatentnahmen",{"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":1000,"d":"€ 1,000.00"}]
["Sonstige Auszahlungen",null,null,{"v":600,"d":"€ 600.00"},{"$nulls":6},{"v":900,"d":"€ 900.00"}]
["….."]
["Umsatzsteuerzahlung",{"$f":"B10*$E$3","v":{"v":4180,"d":"€ 4,180.00"}},{"$f":"C10*$E$3","v":{"v":4560,"d":"€ 4,560.00"}},{"$f":"D10*$E$3","v":{"v":4845,"d":"€ 4,845.00"}},{"$f":"E10*$E$3","v":{"v":5035,"d":"€ 5,035.00"}},{"$f":"F10*$E$3","v":{"v":5225,"d":"€ 5,225.00"}},{"$f":"G10*$E$3","v":{"v":5510,"d":"€ 5,510.00"}},{"$f":"H10*$E$3","v":{"v":5795,"d":"€ 5,795.00"}},{"$f":"I10*$E$3","v":{"v":5985,"d":"€ 5,985.00"}},{"$f":"J10*$E$3","v":{"v":6175,"d":"€ 6,175.00"}},{"$f":"K10*$E$3","v":{"v":6365,"d":"€ 6,365.00"}},{"$f":"L10*$E$3","v":{"v":6555,"d":"€ 6,555.00"}},{"$f":"M10*$E$3","v":{"v":6840,"d":"€ 6,840.00"}},{"$f":"N10*$E$3","v":{"v":7220,"d":"€ 7,220.00"}}]
[]
["Summe Auszahlungen",{"$f":"SUM(B20:B31)","v":{"v":19530,"d":"€ 19,530.00"}},{"$f":"SUM(C20:C31)","v":{"v":17910,"d":"€ 17,910.00"}},{"$f":"SUM(D20:D31)","v":{"v":19095,"d":"€ 19,095.00"}},{"$f":"SUM(E20:E31)","v":{"v":18935,"d":"€ 18,935.00"}},{"$f":"SUM(F20:F31)","v":{"v":19525,"d":"€ 19,525.00"}},{"$f":"SUM(G20:G31)","v":{"v":20410,"d":"€ 20,410.00"}},{"$f":"SUM(H20:H31)","v":{"v":22945,"d":"€ 22,945.00"}},{"$f":"SUM(I20:I31)","v":{"v":22035,"d":"€ 22,035.00"}},{"$f":"SUM(J20:J31)","v":{"v":22625,"d":"€ 22,625.00"}},{"$f":"SUM(K20:K31)","v":{"v":24165,"d":"€ 24,165.00"}},{"$f":"SUM(L20:L31)","v":{"v":23955,"d":"€ 23,955.00"}},{"$f":"SUM(M20:M31)","v":{"v":24890,"d":"€ 24,890.00"}},{"$f":"SUM(N20:N31)","v":{"v":26070,"d":"€ 26,070.00"}}]
[]
["Über-/ Unterdeckung pro Monat",{"$f":"B17-B33","v":{"v":8720,"d":"€ 8,720.00"}},{"$f":"C17-C33","v":{"v":7340,"d":"€ 7,340.00"}},{"$f":"D17-D33","v":{"v":7665,"d":"€ 7,665.00"}},{"$f":"E17-E33","v":{"v":8125,"d":"€ 8,125.00"}},{"$f":"F17-F33","v":{"v":8045,"d":"€ 8,045.00"}},{"$f":"G17-G33","v":{"v":8660,"d":"€ 8,660.00"}},{"$f":"H17-H33","v":{"v":7635,"d":"€ 7,635.00"}},{"$f":"I17-I33","v":{"v":10345,"d":"€ 10,345.00"}},{"$f":"J17-J33","v":{"v":9965,"d":"€ 9,965.00"}},{"$f":"K17-K33","v":{"v":9425,"d":"€ 9,425.00"}},{"$f":"L17-L33","v":{"v":10645,"d":"€ 10,645.00"}},{"$f":"M17-M33","v":{"v":11210,"d":"€ 11,210.00"}},{"$f":"N17-N33","v":{"v":12040,"d":"€ 12,040.00"}}]
[]
["Liquide Mittel am Ende des Monats",{"$f":"B7+B17-B33","v":{"v":16720,"d":"€ 16,720.00"}},{"$f":"C7+C17-C33","v":{"v":24060,"d":"€ 24,060.00"}},{"$f":"D7+D17-D33","v":{"v":31725,"d":"€ 31,725.00"}},{"$f":"E7+E17-E33","v":{"v":39850,"d":"€ 39,850.00"}},{"$f":"F7+F17-F33","v":{"v":47895,"d":"€ 47,895.00"}},{"$f":"G7+G17-G33","v":{"v":56555,"d":"€ 56,555.00"}},{"$f":"H7+H17-H33","v":{"v":64190,"d":"€ 64,190.00"}},{"$f":"I7+I17-I33","v":{"v":74535,"d":"€ 74,535.00"}},{"$f":"J7+J17-J33","v":{"v":84500,"d":"€ 84,500.00"}},{"$f":"K7+K17-K33","v":{"v":93925,"d":"€ 93,925.00"}},{"$f":"L7+L17-L33","v":{"v":104570,"d":"€ 104,570.00"}},{"$f":"M7+M17-M33","v":{"v":115780,"d":"€ 115,780.00"}},{"$f":"N7+N17-N33","v":{"v":127820,"d":"€ 127,820.00"}}]
[]
["Limit Überziehungskredit",{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"$K$3","v":{"v":10000,"d":"€ 10,000.00"}}]
[]
["Maximale Liquidität",{"$f":"B37+B39","v":{"v":26720,"d":"€ 26,720.00"}},{"v":34060,"d":"€ 34,060.00"},{"v":41725,"d":"€ 41,725.00"},{"v":49850,"d":"€ 49,850.00"},{"v":57895,"d":"€ 57,895.00"},{"v":66555,"d":"€ 66,555.00"},{"v":74190,"d":"€ 74,190.00"},{"v":84535,"d":"€ 84,535.00"},{"v":94500,"d":"€ 94,500.00"},{"v":103925,"d":"€ 103,925.00"},{"v":114570,"d":"€ 114,570.00"},{"v":125780,"d":"€ 125,780.00"},{"v":137820,"d":"€ 137,820.00"}]
[]
["Zusätzlicher Liquiditätsbedarf (wenn < 0)",{"$f":"MAX(0,-B41)","v":{"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"}]