{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Start","01_Kapitalbedarf_1","01_Kapitalbedarf_2","01_Finanzierung_1","01_Finanzierung_2","01_Finanzierung_3","01_Umsatzplan","01_Ertragsplan"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":17,"n_cols":31,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Start"]
[null,"Lernsoftware \"Unternehmensgründung\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD1+1","v":1},"01_Gruendungsphasen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD2+1","v":2},"02_Geschaeftsidee"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Anmerkungen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"03_Entscheidungen"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bei der Erarbeitung des Businessplanes sind eine von",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"04_Standort"]
[null,null,null,null,null,null,null,null,null,null,null,null,"tabellarischen Übersichten  zu erstellen, so zum Kapitalbedarf,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"05_Rechtsform"]
[null,null,null,null,null,null,null,null,null,null,null,null,"zur Absicherung des Kapitalbedarfs nach Finanzierungsquellen ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"06_Startfinanzierung"]
[null,null,null,null,null,null,null,null,null,null,null,null,"sowie zu einem erwarteten Umsatz- und Ertragsgrößen in  den",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"07_Businessplan"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ersten drei Geschäftsjahren.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"08_BWL_Grundbegriffe"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hierfür gibt es in dieser Datei Vorlagen, die erweitert, verändert ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"09_Entscheidungstest 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"und mit Zahlen \"gefüttert\" werden können:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"- Ermittlung des Kapitalbedarfs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"- Finanzierung nach Quellen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"- Kapitaldienst"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"- Umsatzplan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"- Ertragsplan."]

{"sheet":"01_Kapitalbedarf_1","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[39,3,39,7],[40,3,40,7],[20,3,20,7],[33,3,33,7],[34,3,34,7],[35,3,35,7],[36,3,36,7],[37,3,37,7],[38,3,38,7],[28,3,28,7],[19,3,19,7],[21,3,21,7],[32,3,32,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[26,3,26,7],[27,3,27,7]]}
[]
[]
[null,null,"Muster-Vorlagen"]
[null,null,"Ermittlung des Kapitalbedarfs"]
[]
[null,null,"Der Kapitalbedarf für eine Existenzgründung umfasst im Geldausdruck die Gesamtheit jener Mittel, die benötigt"]
[null,null," werden, um den Geschäftsbetrieb eines Unternehmens in Gang zu setzen."]
[null,null,"Dazu gehören die Mittel für"]
[null,null,"  - das Begleichen von Gründungskosten (Beratung, Anmeldungen, Genehmigungen u. a.),"]
[null,null,"  - die Erstinvestitionen im Bereich des Anlagevermögens (Grundstücke, Maschinen und dgl.),"]
[null,null,"  - die Schaffung eines ersten Material- und Warenlagers im Bereich des Umlaufvermögens,"]
[null,null,"  - die Absicherung der notwendigen Betriebsausgaben in der Anlaufphase (Kapitaldienst,  Personal, Miete, Werbung u. a.)"]
[null,null,"sowie auch für"]
[null,null,"  - die Absicherung des Lebensunterhalts des Existenzgründers in der Gründungs-  und Anlaufphase."]
[]
[null,null,"Nachfolgend werden Muster-Tabellen dargestellt, die für die Ermittlung des Kapitalbedarfs verwendet werden können. "]
[]
[null,null,"A. Ermittlung der Gründungskosten"]
[]
[null,null,1,"Beratungskosten",null,null,null,null,null," EUR"]
[null,null,1,"Beratungskosten",null,null,null,null,null," EUR"]
[null,null,{"$f":"C20+1","v":2},"Gebühren für Anmeldungen (Gewerbeamt u. a.)",null,null,null,null,null," EUR"]
[null,null,{"$f":"C22+1","v":3},"Gebühren für Genehmigungen (z. B. Baugenehmigung u. a.)",null,null,null,null,null," EUR"]
[null,null,4,"Notarkosten",null,null,null,null,null," EUR"]
[null,null,5,"IHK- /HWK-Gebühren",null,null,null,null,null," EUR"]
[null,null,6,"Kosten des Eintrags ins Handelsregister (falls erforderlich)",null,null,null,null,null," EUR"]
[null,null,7,"...",null,null,null,null,null," EUR"]
[null,null,8,"...",null,null,null,null,null," EUR"]
[null,null,null,"Summe Gündungskosten",null,null,null,null,{"$f":"SUM(I21:I28)","v":0}," EUR"]
[]
[null,null,"B. Erstinvestitionen im Bereich des Anlagevermögens"]
[]
[null,null,1,"Kosten für Erwerb oder Pacht eines Grundstücks",null,null,null,null,null," EUR"]
[null,null,{"$f":"C33+1","v":2},"Kosten für notwendige Umbauten",null,null,null,null,null," EUR"]
[null,null,{"$f":"C34+1","v":3},"Anschaffungskosten der benötigten Betriebsmittel (Maschinen und dgl.)",null,null,null,null,null," EUR"]
[null,null,4,"Anschaffungskosten der benötigten Fahrzeuge",null,null,null,null,null," EUR"]
[null,null,5,"Anschaffungskosten der Geschäftsausstattung (Büromöbel, Computer, Kopierer, Kommunikationstechnik u. a.)",null,null,null,null,null," EUR"]
[null,null,6,"Anschaffungskosten diverser geringwertiger Wirtschaftsgüter",null,null,null,null,null," EUR"]
[null,null,7,"...",null,null,null,null,null," EUR"]
[null,null,8,"...",null,null,null,null,null," EUR"]
[null,null,null,"Summe Kapitalbedarf im Bereich Anlagevermögen",null,null,null,null,{"$f":"SUM(I33:I40)","v":0}," EUR"]

{"sheet":"01_Kapitalbedarf_2","index":2,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,3,31,7],[23,3,23,7],[27,3,27,7],[28,3,28,7],[16,3,16,7],[17,3,17,7],[21,3,21,7],[22,3,22,7],[29,3,29,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[30,3,30,7],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7]]}
[]
[]
[null,null,"Muster-Vorlagen"]
[null,null,"Ermittlung des Kapitalbedarfs"]
[]
[]
[null,null,"C.  Positionen im Bereich des Umlaufvermögens"]
[]
[]
[null,null,1,"Kosten für Schaffung eines ersten Material- und Warenlagers",null,null,null,null,null," EUR"]
[null,null,{"$f":"C10+1","v":2},"Erforderliche liquide Mittel zur Absicherung der Aufwendungen in der Anlaufphase (Kapitaldienst, Werbungskosten, Personalkosten, Miete, Energie u. a.)",null,null,null,null,null," EUR"]
[null,null,{"$f":"C11+1","v":3},"...",null,null,null,null,null," EUR"]
[null,null,null,"Summe Kapitalbedarf im Bereich Umlaufvermögen",null,null,null,null,{"$f":"SUM(I10:I12)","v":0}," EUR"]
[]
[null,null,"D. Absicherung des Lebensunterhalts in der Gründungs- und Anlaufphase"]
[]
[null,null,1,"Mietkosten (privat)",null,null,null,null,null," EUR"]
[null,null,{"$f":"C17+1","v":2},"Energiekosten, Kommunikationskosten",null,null,null,null,null," EUR"]
[null,null,3,"Versicherungen",null,null,null,null,null," EUR"]
[null,null,4,"Kfz-Kosten",null,null,null,null,null," EUR"]
[null,null,5,"Sonstiger Lebensunterhalt",null,null,null,null,null," EUR"]
[null,null,6,"...",null,null,null,null,null," EUR"]
[null,null,7,"...",null,null,null,null,null," EUR"]
[null,null,null,"Summe Kapitalbedarf im Bereich Lebensunterhalt",null,null,null,null,{"$f":"SUM(I17:I23)","v":0}," EUR"]
[]
[null,null,"E. Kapitalbedarf gesamt"]
[]
[null,null,"A.","Gründungskosten",null,null,null,null,{"$f":"'01_Kapitalbedarf_1'!I29","v":0}," EUR"]
[null,null,"B.","Anlagevermögen",null,null,null,null,{"$f":"'01_Kapitalbedarf_1'!I41","v":0}," EUR"]
[null,null,"C.","Umlaufvermögen",null,null,null,null,{"$f":"I13","v":0}," EUR"]
[null,null,"D.","Privater Lebensunterhalt",null,null,null,null,{"$f":"I24","v":0}," EUR"]
[null,null,null,"Summe Kapitalbedarf gesamt",null,null,null,null,{"$f":"SUM(I28:I30)","v":0}," EUR"]

{"sheet":"01_Finanzierung_1","index":3,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,3,31,7],[32,3,32,7],[24,3,24,7],[9,3,9,7],[10,3,10,7],[14,3,14,7],[15,3,15,7],[19,3,19,7],[20,3,20,7],[11,3,11,7],[12,3,12,7],[21,3,21,7],[22,3,22,7],[23,3,23,7]]}
[]
[]
[null,null,"Muster-Vorlagen"]
[null,null,"Finanzierung (Abdeckung des Kapitalbedarfs)"]
[]
[]
[null,null,"A.  Eigene Mittel (zinsfrei)"]
[]
[]
[null,null,1,"Verfügbare liquide Mittel des Gründers",null,null,null,null,null," EUR"]
[null,null,{"$f":"C10+1","v":2},"Sacheinlagen des Gründers:  Grundstück, Gebäude",null,null,null,null,null," EUR"]
[null,null,{"$f":"C11+1","v":3},"Sacheinlagen des Gründers:  Fahrzeuge",null,null,null,null,null," EUR"]
[null,null,4,"Sacheinlagen des Gründers: Computer und dgl.",null,null,null,null,null," EUR"]
[null,null,5,"…",null,null,null,null,null," EUR"]
[null,null,6,"...",null,null,null,null,null," EUR"]
[null,null,null,"Summe Eigene Mittel (Einlagen als Eigenkapital)",null,null,null,null,{"$f":"SUM(I10:I15)","v":0}," EUR"]
[]
[null,null,"B. Fremde Mittel (Kredite, Zuschüsse, Fördermittel u. a. als \"haftendes Eigenkapital\")"]
[]
[null,null,1,"ERP-Kredit für Gründer",null,null,null,null,null," EUR"]
[null,null,{"$f":"C20+1","v":2},"KfW-Unternehmerkredit",null,null,null,null,null," EUR"]
[null,null,3,"Mittel von Kapitalbeteiligungsgesellschaften",null,null,null,null,null," EUR"]
[null,null,4,"…",null,null,null,null,null," EUR"]
[null,null,5,"...",null,null,null,null,null," EUR"]
[null,null,null,"Summe \"Haftendes Eigenkapital\"",null,null,null,null,{"$f":"SUM(I20:I24)","v":0}," EUR"]
[]
[null,null,"C. Darlehen von Kreditinstituten (zinsgebunden)"]
[]
[null,null,1,"Darlehen von …",null,null,null,null,{"$f":"'01_Kapitalbedarf_1'!I29","v":0}," EUR"]
[null,null,{"$f":"C29+1","v":2},"Darlehen von …",null,null,null,null,{"$f":"'01_Kapitalbedarf_1'!I41","v":0}," EUR"]
[null,null,{"$f":"C30+1","v":3},"Darlehen von …",null,null,null,null,{"$f":"I16","v":0}," EUR"]
[null,null,4,"…",null,null,null,null,{"$f":"I25","v":0}," EUR"]
[null,null,null,"Summe \"Darlehen\" (Kreditinstitute)",null,null,null,null,{"$f":"SUM(I29:I31)","v":0}," EUR"]

{"sheet":"01_Finanzierung_2","index":4,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,3,28,7],[29,3,29,7],[32,3,32,7],[33,3,33,7],[34,3,34,7],[24,3,24,7],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[22,3,22,7],[23,3,23,7],[17,3,17,7],[20,3,20,7],[21,3,21,7]]}
[]
[]
[null,null,"Muster-Vorlagen"]
[null,null,"Finanzierung (Abdeckung des Kapitalbedarfs)"]
[]
[]
[null,null,"D.  Weitere Quellen"]
[]
[]
[null,null,1,"Beteiligungen (z. B. Stille Gesellschfater)",null,null,null,null,null," EUR"]
[null,null,{"$f":"C10+1","v":2},"Leasing von Wirschaftsgütern",null,null,null,null,null," EUR"]
[null,null,{"$f":"C11+1","v":3},"…",null,null,null,null,null," EUR"]
[null,null,4,"...",null,null,null,null,null," EUR"]
[null,null,null,"Summe Weitere Quellen ",null,null,null,null,{"$f":"SUM(I10:I13)","v":0}," EUR"]
[]
[null,null,"E. Abstimmung \"Kapitalbedarf - Finanzierung\""]
[]
[null,null,"K","Höhe des Kapitalbedarfs",null,null,null,null,{"$f":"'01_Kapitalbedarf_2'!I32","v":0}," EUR"]
[]
[null,null,"Finanzierungsquellen:"]
[null,null,1,"Eigene Mittel (Einlagen)",null,null,null,null,{"$f":"'01_Finanzierung_1'!I16","v":0}," EUR"]
[null,null,{"$f":"C21+1","v":2},"Fremde Mittel (\"haftends Eigenkapital\")",null,null,null,null,{"$f":"'01_Finanzierung_1'!I25","v":0}," EUR"]
[null,null,3,"Darlehen (Kreditinstitute)",null,null,null,null,{"$f":"'01_Finanzierung_1'!I33","v":0}]
[null,null,4,"Weitere Quellen",null,null,null,null,{"$f":"I14","v":0}]
[null,null,"F","Summe \"Finanzierungsmittel\"",null,null,null,null,{"$f":"SUM(I18:I24)","v":0}," EUR"]
[]
[null,null,"Überprüfung"]
[]
[null,null,1,"Überdeckung (+), Unterdeckung (-)  [Zeile F ./. Zeile K]",null,null,null,null,{"$f":"I25-I18","v":0}," EUR"]
[null,null,2,"Möglicher Kontokorrentkredit (Umlaufmittelbereich)",null,null,null,null,0," EUR"]
[]
[null,null,"Kommentar:"]

{"sheet":"01_Finanzierung_3","index":5,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Muster-Vorlagen"]
[null,null,"Kapitaldienst"]
[]
[null,null,"Nr.","Finanzierungsquelle","Kredithöhe","Auszahlungs-satz [%]","Auszahlungs-betrag [EUR]","Laufzeit [Jahre]","tilgungsfreie Zeit [Jahre]","Normal-zinssatz [%]","Tilungsrate (1. Jahr)","Zinsbetrag  (1. Jahr)"]
[null,null,"1.","ERP-Gründerkredit - Startgeld"]
[null,null,"2.","ERP-Kapital für Gründung"]
[null,null,"3.","ERP-Gründerkapital - universell"]
[null,null,"4.","Darlehen von ..."]
[null,null,"5.","Darlehen von ..."]
[null,null,"6.","befristete Beteiligung von ..."]
[null,null,"7.","..."]
[null,null,"8.","..."]
[]
[null,null,null,"Summe",{"$f":"SUM(E7:E14)","v":0},null,{"$f":"SUM(G7:G14)","v":0},null,null,null,{"$f":"SUM(K7:K14)","v":0},{"$f":"SUM(L7:L14)","v":0}]
[]
[null,null," Probleme:"]

{"sheet":"01_Umsatzplan","index":6,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,10,5,12],[14,2,14,3],[5,2,6,2],[5,3,6,3],[5,4,5,6],[5,7,5,9]]}
[]
[]
[null,null,"Muster-Vorlagen"]
[null,null,"Umsatzplan"]
[]
[null,null,"Nr.","Position","1. Jahr",null,null,"2. Jahr",null,null,"3. Jahr"]
[null,null,null,null,"Preis [EUR/ME]","Menge [ME]","Umsatz [EUR]","Preis [EUR/ME]","Menge [ME]","Umsatz [EUR]","Preis [EUR/ME]","Menge [ME]","Umsatz [EUR]"]
[null,null,"1.1","Produkt P1"]
[null,null,"1.2","Produkt P2"]
[null,null,"1.3","..."]
[null,null,"1.4","Dienstleistung L1"]
[null,null,"1.5","Dienstleistung L2"]
[null,null,"1.6","..."]
[]
[null,null,"Summe Umsatz",null,null,null,{"$f":"SUM(G8:G13)","v":0},null,null,{"$f":"SUM(J8:J13)","v":0},null,null,{"$f":"SUM(M6:M13)","v":0}]
[]
[null,null,"  Amerkungen:"]

{"sheet":"01_Ertragsplan","index":7,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[12,3,12,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[24,3,24,5],[25,3,25,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[21,3,21,5],[22,3,22,5],[23,3,23,5]]}
[]
[]
[null,null,"Muster-Vorlagen"]
[null,null,"Ertragsrechnung"]
[]
[null,null,"Nr.","Position",null,null,"1. Jahr Betrag [EUR]","2. Jahr Betrag [EUR]","3. Jahr Betrag [EUR]"]
[null,null,"1.","Umsatz lt. Umsatzplan"]
[null,null,"2.","./. Material-/Wareneinsatz"]
[null,null,"3.","= Rohertrag 1"]
[null,null,"4.","./. Personalaufwendungen (Brutto)"]
[null,null,"5.","./. SV-Beiträge des Arbeitgebers"]
[null,null,"6.","./. Sonstige Personalkosten"]
[null,null,"7.","= Rohertrag 2"]
[null,null,"8.","./. Raumkosten (Miete etc.)"]
[null,null,"9.","./. Energiekosten"]
[null,null,"10.","./. Versicherungen/Beiträge"]
[null,null,"11.","./. Kfz-Kosten (außer Kfz-Steuern)"]
[null,null,"12.","./. Werbe-/Reisekosten"]
[null,null,"13.","./. Abschreibungen"]
[null,null,"14.","./. Aufwendungen für Reparaturen u. a."]
[null,null,"15.","./. Kommunikationskosten"]
[null,null,"16.","./. Sonstige Sachmittelkosten (Bürobedarf, Fachliteratur u. a.)"]
[null,null,"17.","= Betriebsergebnis 1"]
[null,null,"18.","./. Zinsaufwendungen"]
[null,null,"19.","./. Betriebssteuern"]
[null,null,"20.","= Betriebsergebnis 2 (Plan)"]
[]
[null,null,"  Amerkungen:"]