{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kapitalbedarf"],"not_rendered":{"charts":2},"read":"whole","date_system":"1900"}

{"sheet":"Kapitalbedarf","index":0,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,0,0,13],[1,0,1,13],[3,0,3,4],[3,5,3,9],[3,10,3,13],[4,2,4,4],[4,5,8,9],[4,12,4,13],[5,2,5,4],[5,12,5,13],[6,2,6,4],[6,12,6,13],[7,2,7,4],[8,2,8,4],[10,0,10,8],[10,10,10,16],[25,0,25,1],[27,0,27,8],[37,10,37,13],[38,10,38,11],[38,12,38,13],[39,10,39,11],[39,12,39,13],[40,10,40,11],[40,12,40,13],[41,10,41,11],[41,12,41,13],[44,0,44,1],[46,0,46,5],[59,0,59,1],[61,0,61,8],[63,6,63,8],[64,7,64,8],[65,7,65,8],[66,7,66,8]]}
["Kapitalbedarfsplan"]
["Vorlage – Investitionen, laufende Kosten, Einnahmen und Puffer"]
[]
["Stammdaten",{"$nulls":4},"So benutzt du die Vorlage",{"$nulls":4},"Puffer / Reserve"]
["Unternehmen/Projekt",null,"Beispiel GmbH (E-Commerce)",null,null,"1) Einmalige Kosten eintragen.\n2) Laufende Kosten und Einnahmen pflegen.\n3) Puffer wählen.\n4) Rechts den maximalen Kapitalbedarf ablesen.",{"$nulls":4},"Methode",null,"Fixbetrag"]
["Planungsstart (Monat)",null,"2026-03-01",{"$nulls":7},"Wert (€, % oder Monate)",null,{"v":5000,"d":"5000.00000 €"}]
["Planungsmonate",null,12,{"$nulls":7},"Berechneter Puffer (€)",null,{"$f":"IF($M$5=\"Fixbetrag\",$M$6,IF($M$5=\"% von Gesamtkosten\",$M$6*($F$26+SUM($M$13:$M$36)),IF($M$5=\"Monate laufende Kosten\",$M$6*AVERAGE($M$13:$M$36),0)))","v":{"v":5000,"d":"5000.00000 €"}}]
["Standard MwSt",null,{"v":0.19,"d":"19%"}]
["Währung",null,"EUR"]
[]
["Einmalige Investitionen & Gründungskosten",{"$nulls":9},"Monatsübersicht"]
["Kategorie","Posten","Netto (€)","MwSt (%)","MwSt (€)","Brutto (€)","Zahlungsmonat","Finanzierung","Notiz","#","Monat","Einmalig (€)","Laufend (€)","Einnahmen (€)","Netto Cashflow (€)","Kumuliert (€)","Defizit (€)"]
["Gründungskosten","Notar & Handelsregister",{"v":1200,"d":"1200.00000 €"},{"v":0.19,"d":"19%"},{"$f":"IF(C13=\"\",0,C13*IF(D13=\"\",$C$8,D13))","v":{"v":228,"d":"228.00000 €"}},{"$f":"IF(C13=\"\",0,C13+E13)","v":{"v":1428,"d":"1428.00000 €"}},0,"Eigenkapital",null,1,{"$f":"IF($J13<=$C$7,EDATE($C$6,$J13-1),\"\")","v":"2026-03-01"},{"$f":"IF($J13>$C$7,0,SUMIFS($F$13:$F$25,$G$13:$G$25,$J13)+IF($J13=1,SUMIFS($F$13:$F$25,$G$13:$G$25,0),0))","v":{"v":21400.5,"d":"21400.50000 €"}},{"$f":"IF($J13>$C$7,0,SUMPRODUCT(($J13>=($G$30:$G$44+0))*($J13<=($H$30:$H$44+0))*($F$30:$F$44+0)))","v":{"v":2329.3199999999997,"d":"2329.32000 €"}},{"$f":"IF($J13>$C$7,0,SUMPRODUCT(($J13>=($D$49:$D$59+0))*($J13<=($E$49:$E$59+0))*($C$49:$C$59+0)))","v":{"v":2000,"d":"2000.00000 €"}},{"$f":"IF($J13>$C$7,0,N13-L13-M13)","v":{"v":-21729.82,"d":"(21729.82000 €)"}},{"$f":"IF($J13>$C$7,0,IF($J13=1,O13,P12+O13))","v":{"v":-21729.82,"d":"(21729.82000 €)"}},{"$f":"IF($J13>$C$7,0,MIN(0,P13))","v":{"v":-21729.82,"d":"(21729.82000 €)"}}]
["Gründungskosten","Gewerbeanmeldung",{"v":40,"d":"40.00000 €"},{"v":0,"d":"0%"},0,{"v":40,"d":"40.00000 €"},0,"Eigenkapital",null,2,"2026-04-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":2800,"d":"2800.00000 €"},{"v":-49.320000000000164,"d":"(49.32000 €)"},{"v":-21779.14,"d":"(21779.14000 €)"},{"v":-21779.14,"d":"(21779.14000 €)"}]
["Investitionen","Laptop + Zubehör",{"v":1800,"d":"1800.00000 €"},{"v":0.19,"d":"19%"},{"v":342,"d":"342.00000 €"},{"v":2142,"d":"2142.00000 €"},0,"Eigenkapital",null,3,"2026-05-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":2800,"d":"2800.00000 €"},{"v":-49.320000000000164,"d":"(49.32000 €)"},{"v":-21828.46,"d":"(21828.46000 €)"},{"v":-21828.46,"d":"(21828.46000 €)"}]
["Software","Shop-Setup & Theme",{"v":900,"d":"900.00000 €"},{"v":0.19,"d":"19%"},{"v":171,"d":"171.00000 €"},{"v":1071,"d":"1071.00000 €"},1,"Eigenkapital",null,4,"2026-06-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":4800,"d":"4800.00000 €"},{"v":1950.6799999999998,"d":"1950.68000 €"},{"v":-19877.78,"d":"(19877.78000 €)"},{"v":-19877.78,"d":"(19877.78000 €)"}]
["Marketing","Fotos / Branding",{"v":650,"d":"650.00000 €"},{"v":0.19,"d":"19%"},{"v":123.5,"d":"123.50000 €"},{"v":773.5,"d":"773.50000 €"},1,"Eigenkapital",null,5,"2026-07-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":4800,"d":"4800.00000 €"},{"v":1950.6799999999998,"d":"1950.68000 €"},{"v":-17927.1,"d":"(17927.10000 €)"},{"v":-17927.1,"d":"(17927.10000 €)"}]
["Ausstattung","Regale & Verpackungstisch",{"v":1100,"d":"1100.00000 €"},{"v":0.19,"d":"19%"},{"v":209,"d":"209.00000 €"},{"v":1309,"d":"1309.00000 €"},1,"Darlehen",null,6,"2026-08-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":4800,"d":"4800.00000 €"},{"v":1950.6799999999998,"d":"1950.68000 €"},{"v":-15976.419999999998,"d":"(15976.42000 €)"},{"v":-15976.419999999998,"d":"(15976.42000 €)"}]
["Investitionen","Erstbestand Ware",{"v":12000,"d":"12000.00000 €"},{"v":0.19,"d":"19%"},{"v":2280,"d":"2280.00000 €"},{"v":14280,"d":"14280.00000 €"},0,"Darlehen",null,7,"2026-09-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":7300,"d":"7300.00000 €"},{"v":4450.68,"d":"4450.68000 €"},{"v":-11525.739999999998,"d":"(11525.74000 €)"},{"v":-11525.739999999998,"d":"(11525.74000 €)"}]
["Sonstiges","Puffer kleine Anschaffungen",{"v":300,"d":"300.00000 €"},{"v":0.19,"d":"19%"},{"v":57,"d":"57.00000 €"},{"v":357,"d":"357.00000 €"},0,"Eigenkapital",null,8,"2026-10-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":7300,"d":"7300.00000 €"},{"v":4450.68,"d":"4450.68000 €"},{"v":-7075.059999999998,"d":"(7075.06000 €)"},{"v":-7075.059999999998,"d":"(7075.06000 €)"}]
[{"$nulls":4},0,0,{"$nulls":3},9,"2026-11-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":7300,"d":"7300.00000 €"},{"v":4450.68,"d":"4450.68000 €"},{"v":-2624.3799999999974,"d":"(2624.38000 €)"},{"v":-2624.3799999999974,"d":"(2624.38000 €)"}]
[{"$nulls":4},0,0,{"$nulls":3},10,"2026-12-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":7300,"d":"7300.00000 €"},{"v":4450.68,"d":"4450.68000 €"},{"v":1826.300000000003,"d":"1826.30000 €"},0]
[{"$nulls":4},0,0,{"$nulls":3},11,"2027-01-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":7300,"d":"7300.00000 €"},{"v":4450.68,"d":"4450.68000 €"},{"v":6276.980000000003,"d":"6276.98000 €"},0]
[{"$nulls":4},0,0,{"$nulls":3},12,"2027-02-01",0,{"v":2849.32,"d":"2849.32000 €"},{"v":7300,"d":"7300.00000 €"},{"v":4450.68,"d":"4450.68000 €"},{"v":10727.660000000003,"d":"10727.66000 €"},0]
[{"$nulls":4},0,0,{"$nulls":3},13,"",0,0,0,0,0,0]
["Summe (Brutto)",{"$nulls":4},{"$f":"SUM(F13:F25)","v":{"v":21400.5,"d":"21400.50000 €"}},{"$nulls":3},14,"",0,0,0,0,0,0]
[{"$nulls":9},15,"",0,0,0,0,0,0]
["Laufende Kosten (monatlich)",{"$nulls":8},16,"",0,0,0,0,0,0]
["Kategorie","Posten","Netto/Monat (€)","MwSt (%)","MwSt/Monat (€)","Brutto/Monat (€)","Startmonat","Endmonat","Notiz",17,"",0,0,0,0,0,0]
["Miete","Lager/Office Miete",{"v":900,"d":"900.00000 €"},{"v":0.19,"d":"19%"},{"$f":"IF(C30=\"\",0,C30*IF(D30=\"\",$C$8,D30))","v":{"v":171,"d":"171.00000 €"}},{"$f":"IF(C30=\"\",0,C30+E30)","v":{"v":1071,"d":"1071.00000 €"}},1,12,null,18,"",0,0,0,0,0,0]
["Personal","Aushilfe (Minijob)",{"v":520,"d":"520.00000 €"},{"v":0,"d":"0%"},0,{"v":520,"d":"520.00000 €"},2,12,"inkl. Nebenkosten pauschal",19,"",0,0,0,0,0,0]
["IT","Shop-Software (SaaS)",{"v":79,"d":"79.00000 €"},{"v":0.19,"d":"19%"},{"v":15.01,"d":"15.01000 €"},{"v":94.01,"d":"94.01000 €"},1,12,null,20,"",0,0,0,0,0,0]
["Marketing","Ads (Google/Meta)",{"v":600,"d":"600.00000 €"},{"v":0.19,"d":"19%"},{"v":114,"d":"114.00000 €"},{"v":714,"d":"714.00000 €"},1,12,null,21,"",0,0,0,0,0,0]
["Versicherung","Betriebshaftpflicht",{"v":35,"d":"35.00000 €"},{"v":0,"d":"0%"},0,{"v":35,"d":"35.00000 €"},1,12,null,22,"",0,0,0,0,0,0]
["Material","Verpackungsmaterial",{"v":120,"d":"120.00000 €"},{"v":0.19,"d":"19%"},{"v":22.8,"d":"22.80000 €"},{"v":142.8,"d":"142.80000 €"},1,12,null,23,"",0,0,0,0,0,0]
["Sonstiges","Steuerberater",{"v":180,"d":"180.00000 €"},{"v":0.19,"d":"19%"},{"v":34.2,"d":"34.20000 €"},{"v":214.2,"d":"214.20000 €"},1,12,null,24,"",0,0,0,0,0,0]
["IT","Telefon/Internet",{"v":49,"d":"49.00000 €"},{"v":0.19,"d":"19%"},{"v":9.31,"d":"9.31000 €"},{"v":58.31,"d":"58.31000 €"},1,12]
[{"$nulls":4},0,0,{"$nulls":4},"Kapitalbedarf – Überblick"]
[{"$nulls":4},0,0,{"$nulls":4},"Summe Einmalig (Brutto)",null,{"$f":"$F$26","v":{"v":21400.5,"d":"21400.50000 €"}}]
[{"$nulls":4},0,0,{"$nulls":4},"Summe Laufend (Brutto)",null,{"$f":"SUM($M$13:$M$36)","v":{"v":33671.84,"d":"33671.84000 €"}}]
[{"$nulls":4},0,0,{"$nulls":4},"Max. kumuliertes Defizit",null,{"$f":"ABS(MIN($P$13:$P$36))","v":{"v":21828.46,"d":"21828.46000 €"}}]
[{"$nulls":4},0,0,{"$nulls":4},"Kapitalbedarf inkl. Puffer",null,{"$f":"ABS(MIN($P$13:$P$36))+$M$7","v":{"v":26828.46,"d":"26828.46000 €"}}]
[{"$nulls":4},0,0]
[{"$nulls":4},0,0]
["Summe (Durchschnitt/Monat, Brutto)",{"$nulls":4},{"$f":"SUM(F30:F44)","v":{"v":2849.32,"d":"2849.32000 €"}}]
[]
["Einnahmen (monatlich, optional)"]
["Kategorie","Quelle","Netto/Monat (€)","Startmonat","Endmonat","Hinweis"]
["Umsatz","Online-Shop (Launch)",{"v":2000,"d":"2000.00000 €"},1,3,"konservativer Start"]
["Umsatz","Online-Shop (Wachstum)",{"v":4000,"d":"4000.00000 €"},4,6]
["Umsatz","Online-Shop (stabil)",{"v":6500,"d":"6500.00000 €"},7,12]
["Sonstiges","Marktplatz-Verkäufe",{"v":800,"d":"800.00000 €"},2,12]
{"$rows_empty":7}
["Summe (Netto/Monat, wenn aktiv)",null,{"$f":"SUM(C49:C59)","v":{"v":13300,"d":"13300.00000 €"}}]
[]
["Finanzierung (Abgleich)"]
["Quelle","Typ","Betrag (€)","Auszahlungsmonat","Kommentar"]
["Eigenkapital Gründer","Eigenkapital",{"v":15000,"d":"15000.00000 €"},0,"Einzahlung zum Start",null,"Kennzahlen"]
["Bankdarlehen","Darlehen",{"v":12000,"d":"12000.00000 €"},0,"Auszahlung bei Gründung",null,"Summe Finanzierung (€)",{"$f":"SUM(C64:C74)","v":{"v":30000,"d":"30000.00000 €"}}]
["Zuschuss Digitalisierung","Zuschuss",{"v":3000,"d":"3000.00000 €"},2,"voraussichtlich Monat 2",null,"Kapitalbedarf inkl. Puffer (€)",{"$f":"M42","v":{"v":26828.46,"d":"26828.46000 €"}}]
[{"$nulls":6},"Deckung?",{"$f":"IF(H65>=H66,\"OK\",\"FEHLT\")","v":"OK"}]