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

{"sheet":"Kapitalbedarf","index":0,"n_rows":49,"n_cols":9,"rows_kept":49,"merged":[[0,0,0,8],[2,1,2,3],[3,4,3,5],[4,4,4,5],[5,4,5,5],[7,7,7,8]]}
["Kapitalbedarfsplan"]
[]
["Unternehmen / Projekt","Beispiel GmbH – Online-Handel"]
["Planungsstart","2026-03-01",null,null,"Nur Eingabefelder bearbeiten"]
["Horizont (Monate)",6,null,null,"Dropdowns bei “Finanzierung” nutzen"]
["Puffer / Reserve (%)",{"v":0.1,"d":"10.0%"},null,null,"Alle Berechnungen aktualisieren automatisch"]
[]
["Nr.","Posten","Beschreibung","Betrag (€)","Finanzierung","Notiz",null,"Finanzierung"]
[1,"Laptop & Zubehör","2 Laptops, Docking, Monitore",{"v":4200,"d":"4,200 €"},"Eigenkapital","",null,"Quelle","Betrag (€)"]
[2,"Regale & Lagerausstattung","Regalsysteme, Packtische",{"v":6500,"d":"6,500 €"},"Fremdkapital","",null,"Eigenkapital",{"v":15000,"d":"15,000 €"}]
[3,"Website / Shop-System","Setup + Theme + Plugins",{"v":2800,"d":"2,800 €"},"Eigenkapital","",null,"Bankdarlehen",{"v":25000,"d":"25,000 €"}]
[4,"Fotografie-Equipment","Kamera, Licht, Stativ",{"v":1900,"d":"1,900 €"},"Eigenkapital","",null,"Fördermittel",{"v":5000,"d":"5,000 €"}]
[5,"Erstbestand Waren","Initialer Lagerbestand",{"v":12000,"d":"12,000 €"},"Fremdkapital","",null,"Investoren",{"v":0,"d":"0 €"}]
[6,"Transport / Versandmaterial","Kartonagen, Etiketten, Waage",{"v":1500,"d":"1,500 €"},"Eigenkapital","",null,"Privatdarlehen",{"v":0,"d":"0 €"}]
[7,{"$nulls":6},"Sonstiges",{"v":0,"d":"0 €"}]
[8,{"$nulls":6},"Summe Finanzierung",{"$f":"SUM(I10:I15)","v":{"v":45000,"d":"45,000 €"}}]
[9,{"$nulls":6},"Finanzierungslücke",{"$f":"$B$49-I16","v":{"v":1167,"d":"1,167 €"}}]
[10]
[11,{"$nulls":6},"Kategorie","Betrag"]
[12,{"$nulls":6},"Anfangsinvestitionen",{"$f":"$D$21","v":{"v":28900,"d":"28,900 €"}}]
[null,null,"Summe Anfangsinvestitionen",{"$f":"SUM(D9:D20)","v":{"v":28900,"d":"28,900 €"}},{"$nulls":3},"Gründungskosten",{"$f":"$D$32","v":{"v":3410,"d":"3,410 €"}}]
[{"$nulls":7},"Betriebsmittelbedarf",{"$f":"$B$47","v":{"v":9660,"d":"9,660 €"}}]
["Nr.","Posten","Beschreibung","Betrag (€)","Finanzierung","Notiz",null,"Reserve",{"$f":"$B$48","v":{"v":4197,"d":"4,197 €"}}]
[1,"Notar & Handelsregister","Gründungsformalitäten",{"v":900,"d":"900 €"},"Eigenkapital",""]
[2,"Gewerbeanmeldung","Kommunale Gebühren",{"v":60,"d":"60 €"},"Eigenkapital",""]
[3,"Beratung / Steuer","Startberatung",{"v":800,"d":"800 €"},"Eigenkapital",""]
[4,"Logo & Branding","Designpaket",{"v":450,"d":"450 €"},"Eigenkapital",""]
[5,"Launch-Marketing","Ads & Content zum Start",{"v":1200,"d":"1,200 €"},"Fremdkapital",""]
[6]
[7]
[8]
[null,null,"Summe Gründungskosten",{"$f":"SUM(D24:D31)","v":{"v":3410,"d":"3,410 €"}}]
[]
["Kostenart","Betrag / Monat (€)","Kommentar","Darlehen?"]
["Miete Lager/Büro",{"v":1200,"d":"1,200 €"},"","Nein"]
["Löhne (2 Personen)",{"v":6200,"d":"6,200 €"},"","Nein"]
["Versicherungen",{"v":250,"d":"250 €"},"","Nein"]
["Marketing (laufend)",{"v":900,"d":"900 €"},"","Nein"]
["Material / Verpackung",{"v":600,"d":"600 €"},"variable Basis","Nein"]
["Software / Tools",{"v":180,"d":"180 €"},"","Nein"]
["Telefon / Internet",{"v":80,"d":"80 €"},"","Nein"]
["Sonstiges",{"v":200,"d":"200 €"},"","Nein"]
["Summe Kosten / Monat",{"$f":"SUM(B35:B42)","v":{"v":9610,"d":"9,610 €"}}]
[]
["Einnahmen / Monat (Ø)",{"v":8000,"d":"8,000 €"}]
["Netto-Bedarf / Monat",{"$f":"MAX(0,B43-B45)","v":{"v":1610,"d":"1,610 €"}}]
["Betriebsmittelbedarf (Horizont)",{"$f":"B46*$B$5","v":{"v":9660,"d":"9,660 €"}}]
["Sicherheitsreserve (Puffer)",{"$f":"($D$21+$D$32+B47)*$B$6","v":{"v":4197,"d":"4,197 €"}}]
["Kapitalbedarf gesamt",{"$f":"($D$21+$D$32+B47)+B48","v":{"v":46167,"d":"46,167 €"}}]