{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Einkommensbedarf","Investitionsbedarf","Kapitalbedarf Anlaufphase","Finanzierungsbedarf","Personalkostenbedarf","Vorschau 1.Jahr","Vorschau 2.Jahr","Vorschau 3.Jahr","Summen Vorschau"],"read":"whole","date_system":"1900"}

{"sheet":"Einkommensbedarf","index":0,"n_rows":41,"n_cols":10,"rows_kept":41,"merged":[[39,1,39,7],[40,1,41,7]]}
[]
[null,"Persönlicher Einkommensbedarf"]
[null,"WOHNEN","Kosten Monat","x Zahlmonate","Kosten Jahr",null,"MOBILITÄT","Kosten Monat","x Zahlmonate","Kosten Jahr"]
[null,"Miete",{"v":0,"d":"0.00 "},12,{"$f":"C4*D4","v":{"v":0,"d":"0.00 "}},null,"Fahrzeugkosten",{"v":0,"d":"0.00 "},0,{"$f":"H4*I4","v":{"v":0,"d":"0.00 "}}]
[null,"Strom",{"v":0,"d":"0.00 "},12,{"$f":"C5*D5","v":{"v":0,"d":"0.00 "}},null,"Bus/Bahn / Taxi",{"v":0,"d":"0.00 "},0,{"$f":"H5*I5","v":{"v":0,"d":"0.00 "}}]
[null,"Heizung",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Fahrzeug Versicherung",{"v":0,"d":"0.00 "},1,{"v":0,"d":"0.00 "}]
[null,"Nebenkosten",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Fahrzeug Steuer",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "}]
[null,"Telefon/Internet/  TV",{"v":0,"d":"0.00 "},12,{"v":0,"d":"0.00 "},null,"Kraftstoff",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "}]
[null,"Sonstiges",{"v":0,"d":"0.00 "},0,{"$f":"C9*D9","v":{"v":0,"d":"0.00 "}},null,"Inspektionen / Reparatur",{"v":0,"d":"0.00 "},1,{"v":0,"d":"0.00 "}]
[null,"Zwischensumme",{"$f":"SUM(C4:C9)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(E4:E9)","v":{"v":0,"d":"0.00 "}},null,"Zwischensumme",{"$f":"SUM(H4:H9)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(J4:J9)","v":{"v":0,"d":"0.00 "}}]
[]
[null,"VERSICHERUNGEN","Kosten Monat","x Zahlmonate","Kosten Jahr",null,"BANK","Kosten Monat","x Zahlmonate","Kosten Jahr"]
[null,"Haftpflicht",{"v":0,"d":"0.00 "},1,{"$f":"C13*D13","v":{"v":0,"d":"0.00 "}},null,"Kontogebühren",{"v":0,"d":"0.00 €"},12,{"$f":"H13*I13","v":{"v":0,"d":"0.00 "}}]
[null,"Hausrat",{"v":0,"d":"0.00 "},0,{"$f":"C14*D14","v":{"v":0,"d":"0.00 "}},null,"Buchungskosten",{"v":0,"d":"0.00 €"},0,{"$f":"H14*I14","v":{"v":0,"d":"0.00 "}}]
[null,"Krankenversicherung",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Kreditkarte A",{"v":0,"d":"0.00 €"},1,{"v":0,"d":"0.00 "}]
[null,"Altersvorsorge",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Kreditkarte B",{"v":0,"d":"0.00 €"},0,{"v":0,"d":"0.00 "}]
[null,"Lebensversicherung",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Kredit Tilgungsrate",{"v":0,"d":"0.00 €"},12,{"v":0,"d":"0.00 "}]
[null,"Sonstiges",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Zinsen",{"v":0,"d":"0.00 €"},0,{"v":0,"d":"0.00 "}]
[null,"Zwischensumme",{"$f":"SUM(C13:C18)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(E13:E18)","v":{"v":0,"d":"0.00 "}},null,"Zwischensumme",{"$f":"SUM(H13:H18)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(J13:J18)","v":{"v":0,"d":"0.00 "}}]
[]
[null,"ESSEN & TRINKEN","Kosten Monat","x Zahlmonate","Kosten Jahr",null,"HOBBIES","Kosten Monat","x Zahlmonate","Kosten Jahr"]
[null,"Lebensmitteleinkauf",{"v":0,"d":"0.00 "},12,{"$f":"C22*D22","v":{"v":0,"d":"0.00 "}},null,"Mitgliedsbeitrag A",{"v":0,"d":"0.00 €"},1,{"$f":"H22*I22","v":{"v":0,"d":"0.00 "}}]
[null,"Restaurantbesuch",{"v":0,"d":"0.00 "},12,{"$f":"C23*D23","v":{"v":0,"d":"0.00 "}},null,"Mitgliedsbeitrag B",{"v":0,"d":"0.00 €"},0,{"$f":"H23*I23","v":{"v":0,"d":"0.00 "}}]
[null,"Sonstiges",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 €"},0,{"v":0,"d":"0.00 "}]
[null,"Sonstiges",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 €"},0,{"v":0,"d":"0.00 "}]
[null,"Sonstiges",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 €"},0,{"v":0,"d":"0.00 "}]
[null,"Sonstiges",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 €"},0,{"v":0,"d":"0.00 "}]
[null,"Zwischensumme",{"$f":"SUM(C22:C27)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(E22:E27)","v":{"v":0,"d":"0.00 "}},null,"Zwischensumme",{"$f":"SUM(H22:H27)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(J22:J27)","v":{"v":0,"d":"0.00 "}}]
[]
[null,"UNTERHALTUNG","Kosten Monat","x Zahlmonate","Kosten Jahr",null,"ZUSAMMENFASSUNG",null,"Monat","Jahr"]
[null,"Abo Videostreaming",{"v":0,"d":"0.00 "},0,{"$f":"C31*D31","v":{"v":0,"d":"0.00 "}},null,"Wohnen",null,{"$f":"C10","v":{"v":0,"d":"0.00 "}},{"$f":"E10","v":{"v":0,"d":"0.00 "}}]
[null,"Abo Musikstreaming",{"v":0,"d":"0.00 "},0,{"$f":"C32*D32","v":{"v":0,"d":"0.00 "}},null,"Mobilität",null,{"$f":"H10","v":{"v":0,"d":"0.00 "}},{"$f":"J10","v":{"v":0,"d":"0.00 "}}]
[null,"Konzerte",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Versicherungen",null,{"$f":"C19","v":{"v":0,"d":"0.00 "}},{"$f":"E19","v":{"v":0,"d":"0.00 "}}]
[null,"Theater",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Bank",null,{"$f":"H19","v":{"v":0,"d":"0.00 "}},{"$f":"J19","v":{"v":0,"d":"0.00 "}}]
[null,"Kino",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Essen & Trinken",null,{"$f":"C28","v":{"v":0,"d":"0.00 "}},{"$f":"E28","v":{"v":0,"d":"0.00 "}}]
[null,"Sportveranstaltungen",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Hobbies",null,{"$f":"H28","v":{"v":0,"d":"0.00 "}},{"$f":"J28","v":{"v":0,"d":"0.00 "}}]
[null,"Sonstiges",{"v":0,"d":"0.00 "},0,{"v":0,"d":"0.00 "},null,"Unterhaltung",null,{"$f":"C38","v":{"v":0,"d":"0.00 "}},{"$f":"E38","v":{"v":0,"d":"0.00 "}}]
[null,"Zwischensumme",{"$f":"SUM(C31:C37)","v":{"v":0,"d":"0.00 "}},null,{"$f":"D39+SUM(E31:E37)","v":{"v":0,"d":"0.00 "}},null,"Gesamtbedarf",null,{"$f":"H39+SUM(I31:I37)","v":{"v":0,"d":"0.00 "}},{"$f":"I39+SUM(J31:J37)","v":{"v":0,"d":"0.00 "}}]
[]
[null,"Nutze dieses Arbeitsblatt, um Deinen privaten Einkommensbedarf zu berechnen.\nTrage in den verschiedenen Kategorien Deine monatlichen Ausgaben in Spalte C und H ein. In den Spalten D und I gibst Du die Anzahl der Zahlungstermine ein. Die Zusammenfassung Deines monatlichen und jährlichen Einkommensbedarfs wird automatisch berechnet. Die in den Spalten B  und G eingegebenen Texte kannst Du mit Deinen eigenen Angaben überschreiben."]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Investitionsbedarf","index":1,"n_rows":35,"n_cols":12,"rows_kept":35,"merged":[[33,1,33,7],[34,1,35,7]]}
[]
[null,"Investitionsbedarf"]
[null,"GASTRAUM","Planbudget","Angebot I","Angebot II","Angebot III",null,"KÜCHENAUSSTATTUNG","Planbudget","Angebot I","Angebot II","Angebot III"]
[null,"Verkaufstresen",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Herd",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"I4*K4","v":{"v":0,"d":"0.00 "}}]
[null,"Kaffeemaschine",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Backofen",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"I5*K5","v":{"v":0,"d":"0.00 "}}]
[null,"Mobiliar",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Kühlschränke",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Geschirr / Besteck",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Arbeitstisch",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Dekoartikel",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Spüle",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Getränkekühler",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Geschirrspüler",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Sonstiges ",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Koch / Backgeschirr",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Sonstiges ",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Regale",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Sonstiges ",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Sonstiges ",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"I13*K13","v":{"v":0,"d":"0.00 "}}]
[null,"Zwischensumme",{"$f":"SUM(C4:C13)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"SUM(F4:F13)","v":{"v":0,"d":"0.00 "}},null,"Zwischensumme",{"$f":"SUM(I4:I13)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(J4:J13)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(K4:K13)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(L4:L13)","v":{"v":0,"d":"0.00 "}}]
[]
[null,"BÜROBEDARF","Planbudget","Angebot I","Angebot II","Angebot III",null,"BAULICHE MAßNAHMEN","Planbudget","Angebot I","Angebot II","Angebot III"]
[null,"Kassensystem",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"C17*E17","v":{"v":0,"d":"0.00 "}},null,"Umbaumaßnahmen",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"I17*K17","v":{"v":0,"d":"0.00 "}}]
[null,"Bondrucker",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"C18*E18","v":{"v":0,"d":"0.00 "}},null,"Malerarbeiten",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"I18*K18","v":{"v":0,"d":"0.00 "}}]
[null,"Tablet",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"C19*E19","v":{"v":0,"d":"0.00 "}},null,"Elektrik",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Computer",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Anschlussarbeiten",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Drucker",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Telefon",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Sonstiges",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"I22*K22","v":{"v":0,"d":"0.00 "}}]
[null,"Bürobedarfsutensilien",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"C23*E23","v":{"v":0,"d":"0.00 "}},null,"Sonstiges",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"I23*K23","v":{"v":0,"d":"0.00 "}}]
[null,"Zwischensumme",{"$f":"SUM(C17:C23)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(D17:D23)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,"Zwischensumme",{"$f":"SUM(I17:I23)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(J17:J23)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(K17:K23)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(L17:L23)","v":{"v":0,"d":"0.00 "}}]
[]
[null,"INVESTITIONSBEDARF","Planbudget","Möglichkeit I","Möglichkeit II","Möglichkeit III"]
[null,"Gastraum",{"$f":"C14","v":{"v":0,"d":"0.00 "}},{"$f":"D14","v":{"v":0,"d":"0.00 "}},{"$f":"E14","v":{"v":0,"d":"0.00 "}},{"$f":"F14","v":{"v":0,"d":"0.00 "}}]
[null,"Küchenausstattung",{"$f":"I14","v":{"v":0,"d":"0.00 "}},{"$f":"J14","v":{"v":0,"d":"0.00 "}},{"$f":"K14","v":{"v":0,"d":"0.00 "}},{"$f":"L14","v":{"v":0,"d":"0.00 "}}]
[null,"Bürobedarf",{"$f":"C24","v":{"v":0,"d":"0.00 "}},{"$f":"D24","v":{"v":0,"d":"0.00 "}},{"$f":"E24","v":{"v":0,"d":"0.00 "}},{"$f":"F24","v":{"v":0,"d":"0.00 "}}]
[null,"Bauliche Maßnahmen",{"$f":"I24","v":{"v":0,"d":"0.00 "}},{"$f":"J24","v":{"v":0,"d":"0.00 "}},{"$f":"K24","v":{"v":0,"d":"0.00 "}},{"$f":"L24","v":{"v":0,"d":"0.00 "}}]
[null,"Unvorhersehbares",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"GESAMT",{"$f":"SUM(C27:C31)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(D27:D31)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[]
[null,"Nutze dieses Arbeitsblatt, um Deinen Investitionsbedarf zu berechnen.\nTrage in den verschiedenen Kategorien deine geplanten Ausgaben in Spalte C ein. Eintragungen in den Spalten D/E/F kannst du nutzen, um unterschiedliche Varianten/Angebote zu vergleichen. Die Zusammenfassung deines Investitionsbedarfs wird automatisch berechnet. Die in Spalte B und H eingegebenen Texte kannst du mit deinen eigenen Angaben überschreiben."]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Kapitalbedarf Anlaufphase","index":2,"n_rows":27,"n_cols":9,"rows_kept":27,"merged":[[22,13,22,20],[25,1,25,7],[26,1,27,7]]}
[]
[null,"Kapitalbedarf für die Anlaufphase"]
[null,"Betriebsausgaben","Vorlaufkosten","1. Monat","2. Monat","3. Monat","4. Monat","5. Monat","6. Monat"]
[null,"Gründungsberatung/Coaching"]
[null,"Investitionskosten/Einrichtung etc."]
[null,"Bauliche Maßnahmen"]
[null,"Gebühren"]
[null,"Miete/Pacht"]
[null,"Versicherungen"]
[null,"Bücher/Informationsmaterial"]
[null,"Workshops/Seminare"]
[null,"Beiträge/Abonnements"]
[null,"Kfz-Kosten"]
[null,"Leasing"]
[null,"Kapitaldienst"]
[null,"Werbung/Marketing"]
[null,"Steuerberatung"]
[null,"Personalkosten"]
[null,"Warenkosten"]
[null,"Summe Betriebsausgaben",{"$f":"SUM(C4:C19)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(D4:D19)","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 "}]
[null,"Summe Privatentnahmen\nprivater Einkommensbedarf"]
[null,"Betriebseinnahmen \ngeplante Umsatzerlöse"]
[null,"Kapitalbedarf",{"$f":"(C20+C21)-C22","v":{"v":0,"d":"0.00 "}},{"$f":"(D20+D21)-D22","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 "}]
[null,"Kapitalbedarf Gesamt",{"$f":"SUM(C23:I23)","v":{"v":0,"d":"0.00 "}}]
[]
[null,"Nutze dieses Arbeitsblatt, um Deinen Kapitalbedarf für die Anlaufphase zu berechnen. \nTrage in den verschiedenen Kategorien Deine geplanten Vorlaufkosten in Spalte C ein. \nIn den Spalten D/E/F/G/H/I werden die geplanten Kosten, Privatentnahmen und Einnahmen eingetragen. \nDie Gegenüberstellung der geplanten Kosten und der voraussichtlichen Einnahmen zeigt Dir den Kapitalbedarf, den du in der Anlaufphase benötigst. Die Zusammenfassung deines gesamten Kapitalbedarfs für die Anfangsphase wird automatisch berechnet. \nDie in Spalte B eingegebenen Texte kannst du mit deinen eigenen Angaben überschreiben."]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Finanzierungsbedarf","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[11,1,11,7],[12,1,13,7]]}
[]
[null,"Finanzierungsbedarf"]
[null,"Betriebseinrichtung"]
[null,"Umbaukosten"]
[null,"Erstbestand Waren"]
[null,"Kosten Anlaufphase"]
[null,"Liquiditätsreserve"]
[null,"Kapitalbedarf",{"$f":"SUM(C3:C7)","v":{"v":0,"d":"0.00 "}}]
[null,"(-) Eigenmittel"]
[null,"Finanzierungsbedarf",{"$f":"C8-C9","v":{"v":0,"d":"0.00 "}}]
[]
[null,"Nutze dieses Arbeitsblatt, um deinen Finanzierungsbedarf zu berechnen. \nTrage in den verschiedenen Kategorien deine geplanten Ausgaben und die Summe der Eigenmittel, die du einbringst, in Spalte C ein. Die Zusammenfassung deines Finanzierungsbedarfs wird automatisch berechnet. Die in Spalte B eingegebenen Texte kannst du mit deinen eigenen Angaben überschreiben."]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Personalkostenbedarf","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"merged":[[19,1,19,7],[20,1,21,7]]}
[]
[null,"Personalkosten"]
[null,null,"Monatlicher\nBruttolohn","Arbeitgeberanteil\n25%","Personalnebenkosten\n5%","Monatliche \nGesamtkosten "]
[null,"Service"]
[null,"Servicekraft I",{"v":0,"d":"0.00 "},{"$f":"C5*25%","v":{"v":0,"d":"0.00 "}},{"$f":"C5*5%","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(C5:E5)","v":{"v":0,"d":"0.00 "}}]
[null,"Servicekraft II",{"v":0,"d":"0.00 "},{"$f":"C6*25%","v":{"v":0,"d":"0.00 "}},{"$f":"C6*5%","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(C6:E6)","v":{"v":0,"d":"0.00 "}}]
[null,"Servicekraft III",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Küche"]
[null,"Küchenkraft I",{"v":0,"d":"0.00 "},{"$f":"C9*25%","v":{"v":0,"d":"0.00 "}},{"$f":"C9*5%","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(C9:E9)","v":{"v":0,"d":"0.00 "}}]
[null,"Küchenkraft II",{"v":0,"d":"0.00 "},{"$f":"C10*25%","v":{"v":0,"d":"0.00 "}},{"$f":"C10*5%","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(C10:E10)","v":{"v":0,"d":"0.00 "}}]
[null,"Küchenkraft III",{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Reinigung"]
[null,"Reinigungskraft I",{"v":0,"d":"0.00 "},{"$f":"C13*25%","v":{"v":0,"d":"0.00 "}},{"$f":"C13*5%","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(C13:E13)","v":{"v":0,"d":"0.00 "}}]
[null,"Reinigungskraft II",{"v":0,"d":"0.00 "},{"$f":"C14*25%","v":{"v":0,"d":"0.00 "}},{"$f":"C14*5%","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(C14:E14)","v":{"v":0,"d":"0.00 "}}]
[null,"Verwaltung"]
[null,"Bürokraft ",{"v":0,"d":"0.00 "},{"$f":"C16*25%","v":{"v":0,"d":"0.00 "}},{"$f":"C16*5%","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(C16:E16)","v":{"v":0,"d":"0.00 "}}]
[null,"Personalkosten Monat",{"$nulls":3},{"$f":"SUM(F4:F16)","v":{"v":0,"d":"0.00 "}}]
[null,"Personalkosten Jahr",{"$nulls":3},{"$f":"F17*12","v":{"v":0,"d":"0.00 "}}]
[]
[null,"Nutze dieses Arbeitsblatt, um Deine Personalkosten zu ermitteln.\nTrage den jeweiligen Bruttolohn in Spalte C ein.  Arbeitgeberanteil, Personalnebenkosten und die monatlichen sowie jährlichen Gesamtkosten werden automatisch berechnet.  Die angegebenen Prozentwerte für Arbeitgeberanteil und Personalkosten sind nur als unverbindliche Richtwerte zu verstehen. Die in den Spalten B  und G eingegebenen Texte kannst Du mit Deinen eigenen Angaben überschreiben."]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Vorschau 1.Jahr","index":5,"n_rows":30,"n_cols":15,"rows_kept":30,"merged":[[27,6,27,14],[28,1,28,9],[29,1,30,9]]}
[]
[null,"Wirtschaftlichkeitsvorschau 1. Jahr"]
[null,"Einnahmen ","Januar","Februar","März","April","Mai ","Juni","Juli","August","Sept.","Okt.","Nov.","Dez.","Gesamt"]
[null,"Speisen",{"$nulls":12},{"$f":"SUM(C4:N4)","v":{"v":0,"d":"0 "}}]
[null,"Getränke",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Außer Haus",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Handelswaren",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Summe Einnahmen ",{"$f":"SUM(C4:C7)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D4:D7)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(C8:N8)","v":{"v":0,"d":"0 "}}]
[null,"Summe Warenkosten (35%)",{"$f":"C8*35%","v":{"v":0,"d":"0 "}},{"$f":"D8*35%","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Rohertrag",{"$f":"SUM(C8-C9)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D8-D9)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Kosten"]
[null,"Personalkosten",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Marketing/ Werbung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Energie",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Versicherungen",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Beiträge/ Abonnements",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Gema/ GEZ",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Verwaltungskosten/ Beratung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Sonstige Betriebskosten",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Müll/ Entsorgung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Betriebsergebnis I",{"$f":"SUM(C10-C12-C13-C14-C15-C16-C17-C18-C19-C20)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Miete/ Pacht",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Leasing",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Reparaturen/ Instandhaltung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"AfA und GWG",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Zinsen/ Tilgung/ Geldverkehr",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Betriebsergebnis II",{"$f":"SUM(C21-C22-C23-C24-C25-C26)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Nutze dieses Arbeitsblatt, um die Wirtschaftlichkeit im 1. Jahr darzustellen.\nTrage in den verschiedenen Kategorien Deine monatlich geplanten Einnahmen und Kosten ein. Die Summen werden automatisch berechnet.\nWichtig ist, dass außer bei den Personalkosten nur Nettobeträge eingetragen werden. \nBeachte, das errechnete Betriebsergebnis ist vor Steuern!"]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Vorschau 2.Jahr","index":6,"n_rows":30,"n_cols":15,"rows_kept":30,"merged":[[27,6,27,14],[28,1,28,9],[29,1,30,9]]}
[]
[null,"Wirtschaftlichkeitsvorschau 2. Jahr"]
[null,"Einnahmen ","Januar","Februar","März","April","Mai ","Juni","Juli","August","Sept.","Okt.","Nov.","Dez.","Gesamt"]
[null,"Speisen",{"$nulls":12},{"$f":"SUM(C4:N4)","v":{"v":0,"d":"0 "}}]
[null,"Getränke",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Außer Haus",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Handelswaren",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Summe Einnahmen ",{"$f":"SUM(C4:C7)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D4:D7)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Summe Warenkosten (35%)",{"$f":"C8*35%","v":{"v":0,"d":"0 "}},{"$f":"D8*35%","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Rohertrag",{"$f":"SUM(C8-C9)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D8-D9)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Kosten"]
[null,"Personalkosten",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Marketing/ Werbung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Energie",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Versicherungen",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Beiträge/ Abonnements",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Gema/ GEZ",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Verwaltungskosten/ Beratung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Sonstige Betriebskosten",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Müll/ Entsorgung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Betriebsergebnis I",{"$f":"SUM(C10-C12-C13-C14-C15-C16-C17-C18-C19-C20)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Miete/ Pacht",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Leasing",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Reparaturen/ Instandhaltung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"AfA und GWG",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Zinsen/ Tilgung/ Geldverkehr",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Betriebsergebnis II",{"$f":"SUM(C21-C22-C23-C24-C25-C26)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Nutze dieses Arbeitsblatt, um die Wirtschaftlichkeit im 2. Jahr darzustellen.\nTrage in den verschiedenen Kategorien Deine monatlich geplanten Einnahmen und Kosten ein. Die Summen werden automatisch berechnet.\nWichtig ist, dass außer bei den Personalkosten nur Nettobeträge eingetragen werden. \nBeachte, das errechnete Betriebsergebnis ist vor Steuern!"]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Vorschau 3.Jahr","index":7,"n_rows":30,"n_cols":15,"rows_kept":30,"merged":[[27,6,27,14],[28,1,28,9],[29,1,30,9]]}
[]
[null,"Wirtschaftlichkeitsvorschau 3. Jahr"]
[null,"Einnahmen ","Januar","Februar","März","April","Mai ","Juni","Juli","August","Sept.","Okt.","Nov.","Dez.","Gesamt"]
[null,"Speisen",{"$nulls":12},{"$f":"SUM(C4:N4)","v":{"v":0,"d":"0 "}}]
[null,"Getränke",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Außer Haus",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Handelswaren",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Summe Einnahmen ",{"$f":"SUM(C4:C7)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D4:D7)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Summe Warenkosten (35%)",{"$f":"C8*35%","v":{"v":0,"d":"0 "}},{"$f":"D8*35%","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Rohertrag",{"$f":"SUM(C8-C9)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D8-D9)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Kosten"]
[null,"Personalkosten",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Marketing/ Werbung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Energie",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Versicherungen",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Beiträge/ Abonnements",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Gema/ GEZ",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Verwaltungskosten/ Beratung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Sonstige Betriebskosten",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Müll/ Entsorgung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Betriebsergebnis I",{"$f":"SUM(C10-C12-C13-C14-C15-C16-C17-C18-C19-C20)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Miete/ Pacht",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Leasing",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Reparaturen/ Instandhaltung",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"AfA und GWG",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Zinsen/ Tilgung/ Geldverkehr",{"$nulls":12},{"v":0,"d":"0 "}]
[null,"Betriebsergebnis II",{"$f":"SUM(C21-C22-C23-C24-C25-C26)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Nutze dieses Arbeitsblatt, um die Wirtschaftlichkeit im 3. Jahr darzustellen.\nTrage in den verschiedenen Kategorien Deine monatlich geplanten Einnahmen und Kosten ein. Die Summen werden automatisch berechnet.\nWichtig ist, dass außer bei den Personalkosten nur Nettobeträge eingetragen werden. \nBeachte, das errechnete Betriebsergebnis ist vor Steuern!"]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]

{"sheet":"Summen Vorschau","index":8,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[1,1,1,7],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[5,8,5,9],[11,2,11,3],[11,4,11,5],[11,6,11,7],[29,1,29,7],[30,1,31,9],[63,8,63,12],[64,8,64,12]]}
[]
[null,"Zusammenfassung \nWirtschaftlichkeitsvorschau\n3 Jahre"]
[null,"Einnahmen ","1. Jahr",null,"2. Jahr",null,"3. Jahr"]
[null,null,"EURO","%","EURO","%","EURO","%"]
[null,"Speisen",{"$f":"'Vorschau 1.Jahr'!C4","v":{"v":0,"d":"0 "}},{"$f":"(C5*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O4","v":{"v":0,"d":"0 "}},{"$f":"(E5*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O4","v":{"v":0,"d":"0 "}},{"$f":"(G5*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Getränke",{"$f":"'Vorschau 1.Jahr'!C5","v":{"v":0,"d":"0 "}},{"$f":"(C6*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O5","v":{"v":0,"d":"0 "}},{"$f":"(E6*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O5","v":{"v":0,"d":"0 "}},{"$f":"(G6*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Außer Haus",{"$f":"'Vorschau 1.Jahr'!C6","v":{"v":0,"d":"0 "}},{"$f":"(C7*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O6","v":{"v":0,"d":"0 "}},{"$f":"(E7*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O6","v":{"v":0,"d":"0 "}},{"$f":"(G7*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Handelswaren",{"$f":"'Vorschau 1.Jahr'!C7","v":{"v":0,"d":"0 "}},{"$f":"(C8*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O7","v":{"v":0,"d":"0 "}},{"$f":"(E8*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O7","v":{"v":0,"d":"0 "}},{"$f":"(G8*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Summe Einnahmen ",{"$f":"SUM(C5:C8)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D5:D8)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E5:E8)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F5:F8)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G5:G8)","v":{"v":0,"d":"0 "}},{"$f":"SUM(H5:H8)","v":{"$error":"#DIV/0!"}}]
[null,"Summe Warenkosten",{"$f":"C9*35%","v":{"v":0,"d":"0 "}},{"$f":"(C10*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"E9*35%","v":{"v":0,"d":"0 "}},{"$f":"(E10*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"G9*35%","v":{"v":0,"d":"0 "}},{"$f":"(G10*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Rohertrag",{"$f":"SUM(C9-C10)","v":{"v":0,"d":"0 "}},{"$f":"(C11*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E9-E10)","v":{"v":0,"d":"0 "}},{"$f":"(E11*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G9-G10)","v":{"v":0,"d":"0 "}},{"$f":"(G11*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Kosten"]
[null,"Personalkosten",{"$f":"'Vorschau 1.Jahr'!C12","v":{"v":0,"d":"0 "}},{"$f":"(C13*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C12","v":{"v":0,"d":"0 "}},{"$f":"(E13*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C12","v":{"v":0,"d":"0 "}},{"$f":"(G13*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Marketing/ Werbung",{"$f":"'Vorschau 1.Jahr'!C13","v":{"v":0,"d":"0 "}},{"$f":"(C14*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C13","v":{"v":0,"d":"0 "}},{"$f":"(E14*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C13","v":{"v":0,"d":"0 "}},{"$f":"(G14*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Energie",{"$f":"'Vorschau 1.Jahr'!C14","v":{"v":0,"d":"0 "}},{"$f":"(C15*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C14","v":{"v":0,"d":"0 "}},{"$f":"(E15*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C14","v":{"v":0,"d":"0 "}},{"$f":"(G15*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Versicherungen",{"$f":"'Vorschau 1.Jahr'!C15","v":{"v":0,"d":"0 "}},{"$f":"(C16*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C15","v":{"v":0,"d":"0 "}},{"$f":"(E16*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C15","v":{"v":0,"d":"0 "}},{"$f":"(G16*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Beiträge/ Abonnements",{"$f":"'Vorschau 1.Jahr'!C16","v":{"v":0,"d":"0 "}},{"$f":"(C17*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C16","v":{"v":0,"d":"0 "}},{"$f":"(E17*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C16","v":{"v":0,"d":"0 "}},{"$f":"(G17*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Gema/ GEZ",{"$f":"'Vorschau 1.Jahr'!C17","v":{"v":0,"d":"0 "}},{"$f":"(C18*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C17","v":{"v":0,"d":"0 "}},{"$f":"(E18*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C17","v":{"v":0,"d":"0 "}},{"$f":"(G18*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Verwaltungskosten/ Beratung",{"$f":"'Vorschau 1.Jahr'!C18","v":{"v":0,"d":"0 "}},{"$f":"(C19*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C18","v":{"v":0,"d":"0 "}},{"$f":"(E19*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C18","v":{"v":0,"d":"0 "}},{"$f":"(G19*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Sonstige Betriebskosten",{"$f":"'Vorschau 1.Jahr'!C19","v":{"v":0,"d":"0 "}},{"$f":"(C20*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C19","v":{"v":0,"d":"0 "}},{"$f":"(E20*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C19","v":{"v":0,"d":"0 "}},{"$f":"(G20*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Müll/ Entsorgung",{"$f":"'Vorschau 1.Jahr'!C20","v":{"v":0,"d":"0 "}},{"$f":"(C21*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!C20","v":{"v":0,"d":"0 "}},{"$f":"(E21*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!C20","v":{"v":0,"d":"0 "}},{"$f":"(G21*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Betriebsergebnis I",{"$f":"C11-(C13+C14+C15+C16+C17+C18+C19+C20+C21)","v":{"v":0,"d":"0 "}},{"$f":"(C22*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"E11-(E13+E14+E15+E16+E17+E18+E19+E20+E21)","v":{"v":0,"d":"0 "}},{"$f":"(E22*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"G11-(G13+G14+G15+G16+G17+G18+G19+G20+G21)","v":{"v":0,"d":"0 "}},{"$f":"(G22*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Miete/ Pacht",{"$f":"'Vorschau 1.Jahr'!O22","v":{"v":0,"d":"0 "}},{"$f":"(C23*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O22","v":{"v":0,"d":"0 "}},{"$f":"(E23*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O22","v":{"v":0,"d":"0 "}},{"$f":"(G23*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Leasing",{"$f":"'Vorschau 1.Jahr'!O23","v":{"v":0,"d":"0 "}},{"$f":"(C24*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O23","v":{"v":0,"d":"0 "}},{"$f":"(E24*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O23","v":{"v":0,"d":"0 "}},{"$f":"(G24*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Reparaturen/ Instandhaltung",{"$f":"'Vorschau 1.Jahr'!O24","v":{"v":0,"d":"0 "}},{"$f":"(C25*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O24","v":{"v":0,"d":"0 "}},{"$f":"(E25*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O24","v":{"v":0,"d":"0 "}},{"$f":"(G25*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"AfA und GWG",{"$f":"'Vorschau 1.Jahr'!O25","v":{"v":0,"d":"0 "}},{"$f":"(C26*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O25","v":{"v":0,"d":"0 "}},{"$f":"(E26*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O25","v":{"v":0,"d":"0 "}},{"$f":"(G26*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Zinsen/ Tilgung/ Geldverkehr",{"$f":"'Vorschau 1.Jahr'!O26","v":{"v":0,"d":"0 "}},{"$f":"(C27*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 2.Jahr'!O26","v":{"v":0,"d":"0 "}},{"$f":"(E27*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"'Vorschau 3.Jahr'!O26","v":{"v":0,"d":"0 "}},{"$f":"(G27*100)/G9","v":{"$error":"#DIV/0!"}}]
[null,"Betriebsergebnis II",{"$f":"C22-(C23+C24+C25+C26+C27)","v":{"v":0,"d":"0 "}},{"$f":"(C28*100)/C9","v":{"$error":"#DIV/0!"}},{"$f":"E22-(E23+E24+E25+E26+E27)","v":{"v":0,"d":"0 "}},{"$f":"(E28*100)/E9","v":{"$error":"#DIV/0!"}},{"$f":"G22-(G23+G24+G25+G26+G27)","v":{"v":0,"d":"0 "}},{"$f":"(G28*100)/G9","v":{"$error":"#DIV/0!"}}]
[]
[null,"Keine Eintragungen in diesem Arbeitsblatt!!!\nDie Tabelle ist mit Formeln hinterlegt und zieht sich die Ergebnisse aus den Wirtschaftsjahren 1 bis 3.\nEine Eintragung wirkt sich auf die hinterlegten Formeln und die damit verbundenen Berechnungen aus.\nBeachte, das errechnete Betriebsergebnis ist vor Steuern!"]
[null,"Hinweis:\nFür die Korrektheit der eingegebenen Formeln und der daraus resultierenden Ergebnisse wird keine Gewähr übernommen."]