{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Titel","Hinweise","1 Umsatz","2 Kosten","3 Investitionen","4 Finanzierung","5 Erfolg","6 Liquidität","7 Bilanz","8 Kennzahlen"],"not_rendered":{"images":7,"defined_names":19,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Titel","index":0,"n_rows":28,"n_cols":6,"rows_kept":28}
[{"$nulls":3},2012,"Januar","Schlechtestes"]
[{"$nulls":3},2013,"Februar","Erwartetes"]
[{"$nulls":3},2014,"März","Bestes"]
[{"$nulls":3},2015,"April"]
[{"$nulls":3},2016,"Mai"]
[{"$nulls":3},2017,"Juni"]
[{"$nulls":3},2018,"Juli"]
[{"$nulls":3},2019,"August"]
[{"$nulls":3},2020,"September"]
[{"$nulls":3},2021,"Oktober"]
[{"$nulls":3},2022,"November"]
[{"$nulls":3},2023,"Dezember"]
[{"$nulls":3},2024]
[{"$nulls":3},2025]
[{"$nulls":3},2026]
[{"$nulls":3},2027]
["[Finanzplan 20XX-20XX]",null,null,2028]
["[Ihre Firma]",null,null,2029]
[{"$nulls":3},2030]
[]
[]
[]
["Version","[Versionsnummer]"]
["Erstes Planjahr","[1. Planjahr]"]
["Erster Planmonat",1]
["Szenario",2]
["Stand","[Datum]"]
["Status","[VERTRAULICH]"]

{"sheet":"Hinweise","index":1,"n_rows":40,"n_cols":4,"rows_kept":40,"merged":[[9,0,9,3],[13,0,13,3],[17,0,17,3]]}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Zum Finanzplan"]
[]
["Sie planen Ihre Finanzen für die nächsten drei Jahre. \n\nEs geht um\n▪ das Aufbereiten der historischen Finanzzahlen (bei bestehenden Unternehmen).\n▪ eine Prognose des zukünftigen Erfolges.\n▪ ein Aufzeigen der prognostizierten, zukünftigen finanziellen Situation.\n▪ die Ermittlung des Finanzbedarfs.\n▪ einen prägnanten Antrag an die Geschäftsleitung, an einen möglichen Fremdkapitalgeber oder Investor, in erster Linie an Ihre Bank.\n\nDazu\n▪ dokumentieren Sie die historischen Finanzzahlen Ihres Unternehmens.\n▪ erstellen Sie bei der Finanzplanung eine Bilanz, eine Erfolgsrechnung und eine Mittel- bzw. Liquiditätsrechnung für die kommenden Jahre. \n▪ berechnen den Finanzbedarf.\n▪ definieren Sie die Finanzierungsquellen und bereiten das Finanzierungsgespräch vor."]
[]
["Anwendungshinweise"]
[]
["▪ Geben Sie Ihre Angaben ausschliesslich in den gelb und/oder mit \"[Text]\" markierten Feldern ein. Die restlichen Felder werden automatisch berechnet.\n▪ Arbeiten Sie die Prozessschritte in der angegebenen Reihenfolge ab.\n▪ In dieser Vorlage wird angenommen, dass Rechnungen von Lieferanten oder von unseren Kunden beim Zeitpunkt der Rechnungsstellung bezahlt werden.\n▪ Bei einigen Feldern finden Sie Hinweise. Diese Felder sind mit einer roten Ecke oben rechts markiert. Fahren Sie mit dem Mauszeiger darüber.\n▪ Vergangenheitszahlen (Erfolg, Bilanz, Kennzahlen) erfassen Sie, indem Sie über die Gliederungsfunktion \"Detail anzeigen\" die Ist-Felder einblenden.\n▪ Über die Gliederungsfunktion \"Detail anzeigen / Detail ausblenden\" können Sie auf einigen Tabellenblättern zusätzliche Felder ein- und ausblenden.\n▪ Achten Sie insbesondere beim Schritt Investitionen und Finanzierung darauf, ob es sich um Bestandes- oder Veränderungswerte handelt.\n▪ Eine Vorlage kann i.d.R. nicht alle möglichen Bedürfnisse abbilden. Daher können Sie die Datei beliebig verändern. Achten Sie dabei auf die Formelbezüge."]
[]
["Impressum"]
[]
["▪ Diese Finanzplanvorlage in der vorliegenden Version 1.1 wurde von Stocker Unternehmensentwicklung AG (www.stocker.pro) entwickelt.\n▪ Sämtliche Rechte an dieser Vorlage liegen bei Stocker Unternehmensentwicklung AG.\n▪ Jegliche Haftung durch die Benutzung dieser Vorlage ist ausgeschlossen.\n▪ Rückmeldungen und insbesondere Verbesserungsvorschläge sind herzlich willkommen.\n▪ Kontakt: Stocker Unternehmensentwicklung AG, Pascal O. Stocker, Tel. 055 420 30 30, E-Mail info@stocker.pro."]
[]
["Vorgehen"]
[]
["Prozessschritt",null,null,"Erläuterung"]
[]
[1,"Umsatz",null,"Aufgrund Ihrer Marktanalyse, Ihrer Marktanteilsziele und Ihrer evtl. bereits eingegangenen Kundenbestellungen lassen sich über die Produkt bzw. Dienstleistungspreise die Umsatzvolumen planen."]
[]
[2,"Kosten",null,"Um die geplanten Umsatzvolumen zu erreichen, entstehen Kosten für Personal, Marketing usw. Diese Kosten halten Sie in der Kostenplanung fest."]
[]
[3,"Investitionen",null,"In der Investitionsplanung halten Sie die geplanten Anschaffungen (Maschinen, Büromobiliar usw.) fest. Als Investitionen gelten alle Ausgaben, die als Vermögen in der Bilanz aufgeführt werden können. Alle anderen Ausgaben fliessen in die Kostenplanung."]
[]
[4,"Finanzierung",null,"Sämtliche Investitionen ins Umlauf- und Anlagevermögen sind zu finanzieren. Aufgrund der ersten drei Planungsschritte erkennen Sie den Kapitalbedarf auf der Zeitachse (siehe auch Schritt 6 / Liquidität). Es ist somit von Wichtigkeit, wann welche Umsätze, Kosten und Investitionen anfallen. Aufgrund des Kapitalbedarfs können Sie die Finanzierung mittels Eigen- und Fremdkapital festlegen."]
[]
[5,"Erfolg",null,"Aus den ersten vier Planungsschritten lässt sich die Erfolgsrechnung erstellen. Welche Erträge stehen welchen Aufwänden gegenüber, ab wann resultiert ein geplanter Gewinn, wie können allfällige Verluste der ersten Jahre gedeckt werden?"]
[]
[6,"Liquidität",null,"Pro Jahr fliessen die ersten fünf Planungsschritte in die Liqudiditätsrechnung ein: Es wird aufgezeigt, wie hoch die künftigen jährlichen freien Mittelflüsse sind. Neben der langfristigen Finanzplanung, die sehr wichtig ist, ist die kurzfristige Liquiditätsplanung oftmals sogar überlebenswichtig. Die Liquiditätsflüsse werden i.d.R. auf Monatsbasis geplant werden. Verteilen Sie die jeweiligen Jahreskosten und den Nettoumsatz auf die Monate in denen die Kosten und Umsätze anfallen. Nur so erkennen Sie Ihren Liquiditätsbedarf und können mit Ihrer Bank rechtzeitig bzw. frühzeitig Kontakt aufnehmen. Meist wird die Mittelfluss- und Liquiditätsrechnung separat dargestellt. In dieser Finanzplanvorlage sind beide Rechnung in einer integriert."]
[]
[7,"Bilanz",null,"Die Zusammenfassung der ersten sechs Planungsschritte erfolgt in der Planbilanz. Dabei wird stichtagsbezogen aufgezeigt, über welches Vermögen (Aktiven) das Unternehmen verfügt und wie das Unternehmen finanziert ist (Passiven). Aus der Bilanz ist auch der kummulierte Verlust- bzw. Gewinnvortrag ersichtlich. Dies ist insbesondere zur Beurteilung der Verschuldungssituation des Unternehmens von Bedeutung (OR 725a). Erfassen Sie nebst den Planwerten mindestens die historischen Werte des letzten Jahres oder halten Sie bei einer Neugründung die Eröffnungsbilanz als Vorjahreswerte fest."]
[]
[8,"Kennzahlen",null,"Zusätzlich zu den bereits erarbeiteten Plänen helfen auch Kennzahlen, die finanzielle Situation des Unternehmens besser zu verstehen. Kennzahlen können innerbetrieblich verwendet werden für Vergleiche mit Vorperioden oder zwischenbetrieblich zum Vergleich mit Konkurrenzunternehmen oder der ganzen Branche. Welche Kennzahlen Sie in Ihren Businessplan integrieren, hängt von Ihrer Zielgruppe ab, d.h. für wen Sie Ihren Business- bzw. Finanzplan schreiben."]
[]
["!","Tipps",null,"▪ Vermeiden Sie bei der Prognostizierung der geplanten Finanzzahlen eine übertriebene Scheingenauigkeit.\n▪ Ihre Annahmen sollten auf geprüften Quellen basieren.\n▪ Ihre Annahmen sollen realistisch, nachvollziehbar und begründbar sein.\n▪ Erarbeiten Sie drei (Schlechtestes, Erwartetes, Bestes) Szenarien. Speichern Sie diese in separaten Dateien ab."]

{"sheet":"1 Umsatz","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"merged":[[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1]]}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Umsatzplanung",null,null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Berechnung Nettoumsatz:"]
{"$rows_empty":9}
["Total Nettoumsatz",null,null,{"$f":"SUM(D10:D19)","v":0},null,{"$f":"SUM(F10:F19)","v":0},null,{"$f":"SUM(H10:H19)","v":0}]

{"sheet":"2 Kosten","index":3,"n_rows":42,"n_cols":7,"rows_kept":42}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Kostenplanung",null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Waren"]
["Personal"]
["Raum"]
["Miete"]
["Werbung"]
["Verwaltung"]
["Diverses"]
["[Weiterer Aufwand]"]
["[Weiterer Aufwand]"]
["[Weiterer Aufwand]"]
["Sonstiges"]
[]
["Liquiditätswirksame Kosten (ohne Zins und Steuern)",null,{"$f":"SUM(C10:C20)","v":0},null,{"$f":"SUM(E10:E20)","v":0},null,{"$f":"SUM(G10:G20)","v":0}]
[]
[]
["Kalkulatorische Zinsen und Steuern",null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Angenommener kalkulatorischer Steuersatz"]
["Angenommener kalkulatorischer Zinssatz Fremdkapital"]
[]
[]
["Abschreibungen (liquiditätsunwirksam)",null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
[{"$f":"'3 Investitionen'!A44","v":"Maschinen"}]
[{"$f":"'3 Investitionen'!A45","v":"Mobilen"}]
[{"$f":"'3 Investitionen'!A46","v":"Fahrzeuge"}]
[{"$f":"'3 Investitionen'!A47","v":"Immobilien"}]
[{"$f":"'3 Investitionen'!A48","v":"Immaterielle Anlagen (Patente, Lizenzen)"}]
[{"$f":"'3 Investitionen'!A49","v":"Beteiligungen"}]
[{"$f":"'3 Investitionen'!A50","v":"[Weiteres Anlagevermögen]"}]
[{"$f":"'3 Investitionen'!A51","v":"[Weiteres Anlagevermögen]"}]
[]
["Liquiditätsunwirksame Abschreibungen",null,{"$f":"SUM(C33:C40)","v":0},null,{"$f":"SUM(E33:E40)","v":0},null,{"$f":"SUM(G33:G40)","v":0}]

{"sheet":"3 Investitionen","index":4,"n_rows":68,"n_cols":9,"rows_kept":68}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Berechnung Bestand Liquidität",{"$nulls":3},{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Anfangsbestand",{"$nulls":3},{"$f":"C18","v":0},null,{"$f":"E18","v":0},null,{"$f":"G18","v":0}]
["Bilanzgewinn/-verlust",{"$nulls":3},{"$f":"'5 Erfolg'!P29+'2 Kosten'!C42","v":0},null,{"$f":"'5 Erfolg'!T29+'2 Kosten'!E42","v":0},null,{"$f":"'5 Erfolg'!X29+'2 Kosten'!G42","v":0}]
["Veränderung Umlaufvermögen ohne Liquidität",{"$nulls":3},{"$f":"SUM('3 Investitionen'!C19:C25)-SUM('3 Investitionen'!E19:E25)","v":0},null,{"$f":"SUM('3 Investitionen'!E19:E25)-SUM('3 Investitionen'!G19:G25)","v":0},null,{"$f":"SUM('3 Investitionen'!G19:G25)-SUM('3 Investitionen'!I19:I25)","v":0}]
["Nettoinvestitionen (Investitionen ./. Desinvestitionen)",{"$nulls":3},{"$f":"E53-E40","v":0},null,{"$f":"G53-G40","v":0},null,{"$f":"I53-I40","v":0}]
["Finanzierung",{"$nulls":3},{"$f":"('4 Finanzierung'!E21+'4 Finanzierung'!E30+'4 Finanzierung'!E34)-('4 Finanzierung'!C21+'4 Finanzierung'!C30+'4 Finanzierung'!C34)","v":0},null,{"$f":"('4 Finanzierung'!G21+'4 Finanzierung'!G30+'4 Finanzierung'!G34)-('4 Finanzierung'!E21+'4 Finanzierung'!E30+'4 Finanzierung'!E34)","v":0},null,{"$f":"('4 Finanzierung'!I21+'4 Finanzierung'!I30+'4 Finanzierung'!I34)-('4 Finanzierung'!G21+'4 Finanzierung'!G30+'4 Finanzierung'!G34)","v":0}]
[]
["Bestand Umlaufvermögen",null,{"$f":"\"Bestand 31.12.\"&Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Planbestand \"&Titel!$B$24","v":"Planbestand [1. Planjahr]"},null,{"$f":"\"Planbestand \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Planbestand \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Liquide Mittel (Kasse, Bank)",{"$nulls":3},{"$f":"E11+E14+E10+E13+E12","v":0},null,{"$f":"G11+G14+G10+G13+G12","v":0},null,{"$f":"I11+I14+I10+I13+I12","v":0}]
["Forderungen (Debitoren)"]
["Vorräte"]
["Halb- und Fertigfabrikate"]
["[Weiteres Umlaufvermögen]"]
["[Weiteres Umlaufvermögen]"]
["[Weiteres Umlaufvermögen]"]
["[Weiteres Umlaufvermögen]"]
[]
["Total Bestand Umlaufvermögen",null,{"$f":"SUM(C18:C25)","v":0},null,{"$f":"SUM(E18:E25)","v":0},null,{"$f":"SUM(G18:G25)","v":0},null,{"$f":"SUM(I18:I25)","v":0}]
[]
["Neuinvestitionen Anlagevermögen",{"$nulls":3},{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Maschinen"]
["Mobilen"]
["Fahrzeuge"]
["Immobilien"]
["Immaterielle Anlagen (Patente, Lizenzen)"]
["Beteiligungen"]
["[Weiteres Anlagevermögen]"]
["[Weiteres Anlagevermögen]"]
[]
["Total Neuinvestitionen Anlagevermögen",{"$nulls":3},{"$f":"SUM(E31:E38)","v":0},null,{"$f":"SUM(G31:G38)","v":0},null,{"$f":"SUM(I31:I38)","v":0}]
[]
["Desinvestitionen Anlagevermögen",{"$nulls":3},{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
[{"$f":"A31","v":"Maschinen"}]
[{"$f":"A32","v":"Mobilen"}]
["Fahrzeuge"]
["Immobilien"]
["Immaterielle Anlagen (Patente, Lizenzen)"]
["Beteiligungen"]
["[Weiteres Anlagevermögen]"]
["[Weiteres Anlagevermögen]"]
[]
["Total Desinvestitionen Anlagevermögen",{"$nulls":3},{"$f":"SUM(E44:E51)","v":0},null,{"$f":"SUM(G44:G51)","v":0},null,{"$f":"SUM(I44:I51)","v":0}]
[]
["Bestand Anlagevermögen",null,{"$f":"\"Bestand 31.12.\"&Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
[{"$f":"A31","v":"Maschinen"},{"$nulls":3},{"$f":"C57+E31-E44-'2 Kosten'!C33","v":0},null,{"$f":"E57+G31-G44-'2 Kosten'!E33","v":0},null,{"$f":"G57+I31-I44-'2 Kosten'!G33","v":0}]
[{"$f":"A32","v":"Mobilen"},{"$nulls":3},{"$f":"C58+E32-E45-'2 Kosten'!C34","v":0},null,{"$f":"E58+G32-G45-'2 Kosten'!E34","v":0},null,{"$f":"G58+I32-I45-'2 Kosten'!G34","v":0}]
["Fahrzeuge",{"$nulls":3},{"$f":"C59+E33-E46-'2 Kosten'!C35","v":0},null,{"$f":"E59+G33-G46-'2 Kosten'!E35","v":0},null,{"$f":"G59+I33-I46-'2 Kosten'!G35","v":0}]
["Immobilien",{"$nulls":3},{"$f":"C60+E34-E47-'2 Kosten'!C36","v":0},null,{"$f":"E60+G34-G47-'2 Kosten'!E36","v":0},null,{"$f":"G60+I34-I47-'2 Kosten'!G36","v":0}]
["Immaterielle Anlagen (Patente, Lizenzen)",{"$nulls":3},{"$f":"C61+E35-E48-'2 Kosten'!C37","v":0},null,{"$f":"E61+G35-G48-'2 Kosten'!E37","v":0},null,{"$f":"G61+I35-I48-'2 Kosten'!G37","v":0}]
["Beteiligungen",{"$nulls":3},{"$f":"C62+E36-E49-'2 Kosten'!C38","v":0},null,{"$f":"E62+G36-G49-'2 Kosten'!E38","v":0},null,{"$f":"G62+I36-I49-'2 Kosten'!G38","v":0}]
["[Weiteres Anlagevermögen]",{"$nulls":3},{"$f":"C63+E37-E50-'2 Kosten'!C39","v":0},null,{"$f":"E63+G37-G50-'2 Kosten'!E39","v":0},null,{"$f":"G63+I37-I50-'2 Kosten'!G39","v":0}]
["[Weiteres Anlagevermögen]",{"$nulls":3},{"$f":"C64+E38-E51-'2 Kosten'!C40","v":0},null,{"$f":"E64+G38-G51-'2 Kosten'!E40","v":0},null,{"$f":"G64+I38-I51-'2 Kosten'!G40","v":0}]
[]
["Total Bestand Anlagevermögen",null,{"$f":"SUM(C57:C65)","v":0},null,{"$f":"SUM(E57:E65)","v":0},null,{"$f":"SUM(G57:G65)","v":0},null,{"$f":"SUM(I57:I65)","v":0}]
[]
["Total Aktiven",null,{"$f":"C27+C66","v":0},{"$f":"D42+#REF!","v":{"$error":"#REF!"}},{"$f":"E27+E66","v":0},{"$f":"#REF!+F28+F6","v":{"$error":"#REF!"}},{"$f":"G27+G66","v":0},{"$f":"#REF!+H28+H6","v":{"$error":"#REF!"}},{"$f":"I27+I66","v":0}]

{"sheet":"4 Finanzierung","index":5,"n_rows":44,"n_cols":9,"rows_kept":44}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Nettokapitalbedarf gemäss Investitionsplanung"]
[]
["Nettoinvestitionen Umlauf- und Anlagevermögen",{"$nulls":3},{"$f":"'3 Investitionen'!E40-'3 Investitionen'!E53+(SUM('3 Investitionen'!E19:E25)-SUM('3 Investitionen'!C19:C25))","v":0},null,{"$f":"'3 Investitionen'!G40-'3 Investitionen'!G53+(SUM('3 Investitionen'!G19:G25)-SUM('3 Investitionen'!E19:E25))","v":0},null,{"$f":"'3 Investitionen'!I40-'3 Investitionen'!I53+(SUM('3 Investitionen'!I19:I25)-SUM('3 Investitionen'!G19:G25))","v":0}]
["Minimaler Finanzierungsbedarf / Geldbestand",null,{"$f":"'3 Investitionen'!C68-'4 Finanzierung'!C21-'4 Finanzierung'!C30-'4 Finanzierung'!C38","v":0},null,{"$f":"E10-'3 Investitionen'!E10-'3 Investitionen'!E11-'3 Investitionen'!E14","v":0},null,{"$f":"G10-'3 Investitionen'!G10-'3 Investitionen'!G11-'3 Investitionen'!G14","v":0},null,{"$f":"I10-'3 Investitionen'!I10-'3 Investitionen'!I11-'3 Investitionen'!I14","v":0}]
[]
["Finanzierung"]
[]
["Bestand Kurzfristiges Fremdkapital",null,{"$f":"\"Bestand 31.12.\"&Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24","v":"Plan Ende [1. Planjahr]"},null,{"$f":"\"Plan Ende \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Kreditoren"]
["Bankschulden"]
["Andere kurzfristige Verbindlichkeiten"]
[]
["Total kurzfristiges Fremdkapital",null,{"$f":"SUM(C17:C19)","v":0},null,{"$f":"SUM(E17:E19)","v":0},null,{"$f":"SUM(G17:G19)","v":0},null,{"$f":"SUM(I17:I19)","v":0}]
[]
["Bestand Langfristiges Fremdkapital",null,{"$f":"\"Bestand 31.12.\"&Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24","v":"Plan Ende [1. Planjahr]"},null,{"$f":"\"Plan Ende \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Darlehen"]
["Hypotheken"]
["Andere langfristige Verbindlichkeiten"]
["Rückstellungen"]
[]
["Total langfristiges Fremdkapital",null,{"$f":"SUM(C25:C28)","v":0},null,{"$f":"SUM(E25:E28)","v":0},null,{"$f":"SUM(G25:G28)","v":0},null,{"$f":"SUM(I25:I28)","v":0}]
[]
["Bestand Eigenkapital",null,{"$f":"\"Bestand 31.12.\"&Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24","v":"Plan Ende [1. Planjahr]"},null,{"$f":"\"Plan Ende \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Aktienkapital/Stammkapital"]
["Reserven",{"$nulls":3},{"$f":"'7 Bilanz'!O54","v":0},null,{"$f":"'7 Bilanz'!S54","v":0},null,{"$f":"'7 Bilanz'!W54","v":0}]
["Bilanzgewinn / -verlust inkl. Vortrag",{"$nulls":3},{"$f":"'7 Bilanz'!O55","v":0},null,{"$f":"'7 Bilanz'!S55","v":0},null,{"$f":"'7 Bilanz'!W55","v":0}]
[]
["Total Eigenkapital",null,{"$f":"SUM(C34:C36)","v":0},null,{"$f":"SUM(E34:E36)","v":0},null,{"$f":"SUM(G34:G36)","v":0},null,{"$f":"SUM(I34:I36)","v":0}]
[]
["Total Passiven",null,{"$f":"C21+C30+C38","v":0},null,{"$f":"E21+E30+E38","v":0},null,{"$f":"G21+G30+G38","v":0},null,{"$f":"I21+I30+I38","v":0}]
[]
["Kreditlimite",null,{"$f":"Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24","v":"Plan Ende [1. Planjahr]"},null,{"$f":"\"Plan Ende \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan Ende \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["[Kreditlimite Bank XY]",{"$nulls":3},{"$f":"C44","v":0},null,{"$f":"E44","v":0},null,{"$f":"G44","v":0}]

{"sheet":"5 Erfolg","index":6,"n_rows":29,"n_cols":26,"rows_kept":29}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Planerfolgsrechnung",null,null,{"$f":"Titel!$B$24-3","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"Titel!$B$24-2","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,"in %",null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}},null,"in %"]
[]
[" = ","Nettoumsatz",{"$nulls":3},{"$f":"IF(ISERROR(D10/$D$10),\"\",D10/$D$10)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(H10/$H$10),\"\",H10/$H$10)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(L10/$L$10),\"\",L10/$L$10)","v":""},null,{"$f":"'1 Umsatz'!D20","v":0},null,{"$f":"IF(ISERROR(P10/$P$10),\"\",P10/$P$10)","v":""},null,{"$f":"'1 Umsatz'!F20","v":0},null,{"$f":"IF(ISERROR(T10/$T$10),\"\",T10/$T$10)","v":""},null,{"$f":"'1 Umsatz'!H20","v":0},null,{"$f":"IF(ISERROR(X10/$X$10),\"\",X10/$X$10)","v":""}]
[" ./. ",{"$f":"'2 Kosten'!A10","v":"Waren"},{"$nulls":3},{"$f":"IF(ISERROR(D11/$D$10),\"\",D11/$D$10)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(H11/$H$10),\"\",H11/$H$10)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(L11/$L$10),\"\",L11/$L$10)","v":""},null,{"$f":"'2 Kosten'!C10","v":0},null,{"$f":"IF(ISERROR(P11/$P$10),\"\",P11/$P$10)","v":""},null,{"$f":"'2 Kosten'!E10","v":0},null,{"$f":"IF(ISERROR(T11/$T$10),\"\",T11/$T$10)","v":""},null,{"$f":"'2 Kosten'!G10","v":0},null,{"$f":"IF(ISERROR(X11/$X$10),\"\",X11/$X$10)","v":""}]
[" = ","Bruttogewinn",null,{"$f":"D10-D11","v":0},null,"",null,{"$f":"H10-H11","v":0},null,"",null,{"$f":"L10-L11","v":0},null,"",null,{"$f":"P10-P11","v":0},null,"",null,{"$f":"T10-T11","v":0},null,"",null,{"$f":"X10-X11","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A11","v":"Personal"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C11","v":0},null,"",null,{"$f":"'2 Kosten'!E11","v":0},null,"",null,{"$f":"'2 Kosten'!G11","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A12","v":"Raum"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C12","v":0},null,"",null,{"$f":"'2 Kosten'!E12","v":0},null,"",null,{"$f":"'2 Kosten'!G12","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A13","v":"Miete"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C13","v":0},null,"",null,{"$f":"'2 Kosten'!E13","v":0},null,"",null,{"$f":"'2 Kosten'!G13","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A14","v":"Werbung"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C14","v":0},null,"",null,{"$f":"'2 Kosten'!E14","v":0},null,"",null,{"$f":"'2 Kosten'!G14","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A15","v":"Verwaltung"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C15","v":0},null,"",null,{"$f":"'2 Kosten'!E15","v":0},null,"",null,{"$f":"'2 Kosten'!G15","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A16","v":"Diverses"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C16","v":0},null,"",null,{"$f":"'2 Kosten'!E16","v":0},null,"",null,{"$f":"'2 Kosten'!G16","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A17","v":"[Weiterer Aufwand]"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C17","v":0},null,"",null,{"$f":"'2 Kosten'!E17","v":0},null,"",null,{"$f":"'2 Kosten'!G17","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A18","v":"[Weiterer Aufwand]"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C18","v":0},null,"",null,{"$f":"'2 Kosten'!E18","v":0},null,"",null,{"$f":"'2 Kosten'!G18","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A19","v":"[Weiterer Aufwand]"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C19","v":0},null,"",null,{"$f":"'2 Kosten'!E19","v":0},null,"",null,{"$f":"'2 Kosten'!G19","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A20","v":"Sonstiges"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C20","v":0},null,"",null,{"$f":"'2 Kosten'!E20","v":0},null,"",null,{"$f":"'2 Kosten'!G20","v":0},null,""]
[" = ","Betriebsergebnis vor Zinsen, Steuern und Abschreibungen",null,{"$f":"D10-D11-D12-D13-D14-D15-D16-D17","v":0},null,"",null,{"$f":"H10-H11-H12-H13-H14-H15-H16-H17","v":0},null,"",null,{"$f":"L10-L11-L12-L13-L14-L15-L16-L17","v":0},null,"",null,{"$f":"P12-SUM(P13:P22)","v":0},null,{"$f":"IF(ISERROR(P23/$P$10),\"\",P23/$P$10)","v":""},null,{"$f":"T12-SUM(T13:T22)","v":0},null,"",null,{"$f":"X12-SUM(X13:X22)","v":0},null,""]
[" ./. ",{"$f":"'2 Kosten'!A31","v":"Abschreibungen (liquiditätsunwirksam)"},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'2 Kosten'!C42","v":0},null,"",null,{"$f":"'2 Kosten'!E42","v":0},null,"",null,{"$f":"'2 Kosten'!G42","v":0},null,""]
[" = ","Betriebsergebnis vor Zinsen und Steuern",null,{"$f":"D12-D13-D14-D15-D16-D17-D18-D19","v":0},null,"",null,{"$f":"H12-H13-H14-H15-H16-H17-H18-H19","v":0},null,"",null,{"$f":"L12-L13-L14-L15-L16-L17-L18-L19","v":0},null,"",null,{"$f":"P23-SUM(P24)","v":0},null,"",null,{"$f":"T23-SUM(T24)","v":0},null,"",null,{"$f":"X23-SUM(X24)","v":0},null,""]
[" ./. ","Zinsen",{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"('4 Finanzierung'!E21+'4 Finanzierung'!E30)*'2 Kosten'!$C$28","v":0},null,"",null,{"$f":"('4 Finanzierung'!G21+'4 Finanzierung'!G30)*'2 Kosten'!$E$28","v":0},null,"",null,{"$f":"('4 Finanzierung'!I21+'4 Finanzierung'!I30)*'2 Kosten'!G28","v":0},null,""]
[" = ","Gewinn vor Steuern",null,{"$f":"D25-SUM(D26)","v":0},null,"",null,{"$f":"H25-SUM(H26)","v":0},null,"",null,{"$f":"L25-SUM(L26)","v":0},null,"",null,{"$f":"P25-SUM(P26)","v":0},null,"",null,{"$f":"T25-SUM(T26)","v":0},null,"",null,{"$f":"X25-SUM(X26)","v":0},null,""]
[" ./. ","Steuern",{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"IF(P27>=0,(P27*'2 Kosten'!$C$27),0)","v":0},null,"",null,{"$f":"IF(T27>=0,(T27*'2 Kosten'!$E$27),0)","v":0},null,"",null,{"$f":"IF(X27>=0,(X27*'2 Kosten'!$G$27),0)","v":0},null,""]
[" = ","Unternehmensgewinn / -verlust ",null,{"$f":"D27-D28","v":0},null,"",null,{"$f":"H27-H28","v":0},null,"",null,{"$f":"L27-L28","v":0},null,"",null,{"$f":"P27-SUM(P28)","v":0},null,{"$f":"IF(ISERROR(P29/$P$10),\"\",P29/$P$10)","v":""},null,{"$f":"T27-SUM(T28)","v":0},null,"",null,{"$f":"X27-SUM(X28)","v":0},null,""]

{"sheet":"6 Liquidität","index":7,"n_rows":50,"n_cols":86,"rows_kept":50}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Liquidität",null,null,{"$f":"Titel!$B$25","v":"1900-01-01"},null,{"$f":"D8+31","v":"1900-02-01"},null,{"$f":"F8+31","v":"1900-03-03"},null,{"$f":"H8+31","v":"1900-04-03"},null,{"$f":"J8+31","v":"1900-05-04"},null,{"$f":"L8+31","v":"1900-06-04"},null,{"$f":"N8+31","v":"1900-07-05"},null,{"$f":"P8+31","v":"1900-08-05"},null,{"$f":"R8+31","v":"1900-09-05"},null,{"$f":"T8+31","v":"1900-10-06"},null,{"$f":"V8+31","v":"1900-11-06"},null,{"$f":"X8+31","v":"1900-12-07"},null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,"Check",null,{"$f":"Titel!$B$25","v":"1900-01-01"},null,{"$f":"AF8+31","v":"1900-02-01"},null,{"$f":"AH8+31","v":"1900-03-03"},null,{"$f":"AJ8+31","v":"1900-04-03"},null,{"$f":"AL8+31","v":"1900-05-04"},null,{"$f":"AN8+31","v":"1900-06-04"},null,{"$f":"AP8+31","v":"1900-07-05"},null,{"$f":"AR8+31","v":"1900-08-05"},null,{"$f":"AT8+31","v":"1900-09-05"},null,{"$f":"AV8+31","v":"1900-10-06"},null,{"$f":"AX8+31","v":"1900-11-06"},null,{"$f":"AZ8+31","v":"1900-12-07"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,"Check",null,{"$f":"Titel!$B$25","v":"1900-01-01"},null,{"$f":"BH8+31","v":"1900-02-01"},null,{"$f":"BJ8+31","v":"1900-03-03"},null,{"$f":"BL8+31","v":"1900-04-03"},null,{"$f":"BN8+31","v":"1900-05-04"},null,{"$f":"BP8+31","v":"1900-06-04"},null,{"$f":"BR8+31","v":"1900-07-05"},null,{"$f":"BT8+31","v":"1900-08-05"},null,{"$f":"BV8+31","v":"1900-09-05"},null,{"$f":"BX8+31","v":"1900-10-06"},null,{"$f":"BZ8+31","v":"1900-11-06"},null,{"$f":"CB8+31","v":"1900-12-07"},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}},null,"Check"]
[]
[" = ","Anfangsbest. fl. Mittel / Kreditbeanspruchung",null,{"$f":"'3 Investitionen'!C18","v":0},null,{"$f":"D45","v":0},null,{"$f":"F45","v":0},null,{"$f":"H45","v":0},null,{"$f":"J45","v":0},null,{"$f":"L45","v":0},null,{"$f":"N45","v":0},null,{"$f":"P45","v":0},null,{"$f":"R45","v":0},null,{"$f":"T45","v":0},null,{"$f":"V45","v":0},null,{"$f":"X45","v":0},null,{"$f":"D10","v":0},{"$nulls":3},{"$f":"AB45","v":0},null,{"$f":"AF45","v":0},null,{"$f":"AH45","v":0},null,{"$f":"AJ45","v":0},null,{"$f":"AL45","v":0},null,{"$f":"AN45","v":0},null,{"$f":"AP45","v":0},null,{"$f":"AR45","v":0},null,{"$f":"AT45","v":0},null,{"$f":"AV45","v":0},null,{"$f":"AX45","v":0},null,{"$f":"AZ45","v":0},null,{"$f":"AF10","v":0},{"$nulls":3},{"$f":"BD45","v":0},null,{"$f":"BH45","v":0},null,{"$f":"BJ45","v":0},null,{"$f":"BL45","v":0},null,{"$f":"BN45","v":0},null,{"$f":"BP45","v":0},null,{"$f":"BR45","v":0},null,{"$f":"BT45","v":0},null,{"$f":"BV45","v":0},null,{"$f":"BX45","v":0},null,{"$f":"BZ45","v":0},null,{"$f":"CB45","v":0},null,{"$f":"BH10","v":0}]
[]
["./. ",{"$f":"'2 Kosten'!A10","v":"Waren"},{"$nulls":25},{"$f":"'5 Erfolg'!P11","v":0},null,{"$f":"AB12-SUM(D12:Z12)","v":0},{"$nulls":25},{"$f":"'5 Erfolg'!T11","v":0},null,{"$f":"BD12-SUM(AF12:BB12)","v":0},{"$nulls":25},{"$f":"'5 Erfolg'!X11","v":0},null,{"$f":"CF12-SUM(BH12:CD12)","v":0}]
["./. ",{"$f":"'2 Kosten'!A11","v":"Personal"},{"$nulls":25},{"$f":"'5 Erfolg'!P13","v":0},null,{"$f":"AB13-SUM(D13:Z13)","v":0},{"$nulls":25},{"$f":"'5 Erfolg'!T13","v":0},null,{"$f":"BD13-SUM(AF13:BB13)","v":0},{"$nulls":25},{"$f":"'5 Erfolg'!X13","v":0},null,{"$f":"CF13-SUM(BH13:CD13)","v":0}]
["./. ",{"$f":"'2 Kosten'!A12","v":"Raum"},{"$nulls":25},{"$f":"'5 Erfolg'!P14","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T14","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X14","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A13","v":"Miete"},{"$nulls":25},{"$f":"'5 Erfolg'!P15","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T15","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X15","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A14","v":"Werbung"},{"$nulls":25},{"$f":"'5 Erfolg'!P16","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T16","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X16","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A15","v":"Verwaltung"},{"$nulls":25},{"$f":"'5 Erfolg'!P17","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T17","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X17","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A16","v":"Diverses"},{"$nulls":25},{"$f":"'5 Erfolg'!P18","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T18","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X18","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A17","v":"[Weiterer Aufwand]"},{"$nulls":25},{"$f":"'5 Erfolg'!P19","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T19","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X19","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A18","v":"[Weiterer Aufwand]"},{"$nulls":25},{"$f":"'5 Erfolg'!P20","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T20","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X20","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A19","v":"[Weiterer Aufwand]"},{"$nulls":25},{"$f":"'5 Erfolg'!P21","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T21","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X21","v":0},null,0]
["./. ",{"$f":"'2 Kosten'!A20","v":"Sonstiges"},{"$nulls":25},{"$f":"'5 Erfolg'!P22","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T22","v":0},null,{"$f":"BD22-SUM(AF22:BB22)","v":0},{"$nulls":25},{"$f":"'5 Erfolg'!X22","v":0},null,0]
["./. ",{"$f":"'5 Erfolg'!B26","v":"Zinsen"},{"$nulls":25},{"$f":"'5 Erfolg'!P26","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T26","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X26","v":0},null,0]
["./. ",{"$f":"'5 Erfolg'!B28","v":"Steuern"},{"$nulls":25},{"$f":"'5 Erfolg'!P28","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!T28","v":0},null,0,{"$nulls":25},{"$f":"'5 Erfolg'!X28","v":0},null,0]
["= ","Zahlungsverpflichtungen",null,{"$f":"SUM(D12:D24)","v":0},null,{"$f":"SUM(F12:F24)","v":0},null,{"$f":"SUM(H12:H24)","v":0},null,{"$f":"SUM(J12:J24)","v":0},null,{"$f":"SUM(L12:L24)","v":0},null,{"$f":"SUM(N12:N24)","v":0},null,{"$f":"SUM(P12:P24)","v":0},null,{"$f":"SUM(R12:R24)","v":0},null,{"$f":"SUM(T12:T24)","v":0},null,{"$f":"SUM(V12:V24)","v":0},null,{"$f":"SUM(X12:X24)","v":0},null,{"$f":"SUM(Z12:Z24)","v":0},null,{"$f":"SUM(AB12:AB24)","v":0},{"$nulls":3},{"$f":"SUM(AF12:AF24)","v":0},null,{"$f":"SUM(AH12:AH24)","v":0},null,{"$f":"SUM(AJ12:AJ24)","v":0},null,{"$f":"SUM(AL12:AL24)","v":0},null,{"$f":"SUM(AN12:AN24)","v":0},null,{"$f":"SUM(AP12:AP24)","v":0},null,{"$f":"SUM(AR12:AR24)","v":0},null,{"$f":"SUM(AT12:AT24)","v":0},null,{"$f":"SUM(AV12:AV24)","v":0},null,{"$f":"SUM(AX12:AX24)","v":0},null,{"$f":"SUM(AZ12:AZ24)","v":0},null,{"$f":"SUM(BB12:BB24)","v":0},null,{"$f":"SUM(BD12:BD24)","v":0},{"$nulls":3},{"$f":"SUM(BH12:BH24)","v":0},null,{"$f":"SUM(BJ12:BJ24)","v":0},null,{"$f":"SUM(BL12:BL24)","v":0},null,{"$f":"SUM(BN12:BN24)","v":0},null,{"$f":"SUM(BP12:BP24)","v":0},null,{"$f":"SUM(BR12:BR24)","v":0},null,{"$f":"SUM(BT12:BT24)","v":0},null,{"$f":"SUM(BV12:BV24)","v":0},null,{"$f":"SUM(BX12:BX24)","v":0},null,{"$f":"SUM(BZ12:BZ24)","v":0},null,{"$f":"SUM(CB12:CB24)","v":0},null,{"$f":"SUM(CD12:CD24)","v":0},null,{"$f":"SUM(CF12:CF24)","v":0}]
[]
["+",{"$f":"'5 Erfolg'!B10","v":"Nettoumsatz"},{"$nulls":25},{"$f":"'5 Erfolg'!P10","v":0},null,{"$f":"AB27-SUM(D27:Z27)","v":0},{"$nulls":25},{"$f":"'5 Erfolg'!T10","v":0},null,{"$f":"BD27-SUM(AF27:BB27)","v":0},{"$nulls":25},{"$f":"'5 Erfolg'!X10","v":0},null,{"$f":"CF27-SUM(BH27:CD27)","v":0}]
["= ","Erwartete Einzahlungen",null,{"$f":"SUM(D27)","v":0},null,{"$f":"SUM(F27)","v":0},null,{"$f":"SUM(H27)","v":0},null,{"$f":"SUM(J27)","v":0},null,{"$f":"SUM(L27)","v":0},null,{"$f":"SUM(N27)","v":0},null,{"$f":"SUM(P27)","v":0},null,{"$f":"SUM(R27)","v":0},null,{"$f":"SUM(T27)","v":0},null,{"$f":"SUM(V27)","v":0},null,{"$f":"SUM(X27)","v":0},null,{"$f":"SUM(Z27)","v":0},null,{"$f":"AB27","v":0},{"$nulls":3},{"$f":"SUM(AF27)","v":0},null,{"$f":"SUM(AH27)","v":0},null,{"$f":"SUM(AJ27)","v":0},null,{"$f":"SUM(AL27)","v":0},null,{"$f":"SUM(AN27)","v":0},null,{"$f":"SUM(AP27)","v":0},null,{"$f":"SUM(AR27)","v":0},null,{"$f":"SUM(AT27)","v":0},null,{"$f":"SUM(AV27)","v":0},null,{"$f":"SUM(AX27)","v":0},null,{"$f":"SUM(AZ27)","v":0},null,{"$f":"SUM(BB27)","v":0},null,{"$f":"BD27","v":0},{"$nulls":3},{"$f":"SUM(BH27)","v":0},null,{"$f":"SUM(BJ27)","v":0},null,{"$f":"SUM(BL27)","v":0},null,{"$f":"SUM(BN27)","v":0},null,{"$f":"SUM(BP27)","v":0},null,{"$f":"SUM(BR27)","v":0},null,{"$f":"SUM(BT27)","v":0},null,{"$f":"SUM(BV27)","v":0},null,{"$f":"SUM(BX27)","v":0},null,{"$f":"SUM(BZ27)","v":0},null,{"$f":"SUM(CB27)","v":0},null,{"$f":"SUM(CD27)","v":0},null,{"$f":"CF27","v":0}]
[]
[" = ","Mittelfluss aus Geschäftstägigkeit (Cashflow)",null,{"$f":"D28-D25","v":0},null,{"$f":"F28-F25","v":0},null,{"$f":"H28-H25","v":0},null,{"$f":"J28-J25","v":0},null,{"$f":"L28-L25","v":0},null,{"$f":"N28-N25","v":0},null,{"$f":"P28-P25","v":0},null,{"$f":"R28-R25","v":0},null,{"$f":"T28-T25","v":0},null,{"$f":"V28-V25","v":0},null,{"$f":"X28-X25","v":0},null,{"$f":"Z28-Z25","v":0},null,{"$f":"AB28-AB25","v":0},{"$nulls":3},{"$f":"AF28-AF25","v":0},null,{"$f":"AH28-AH25","v":0},null,{"$f":"AJ28-AJ25","v":0},null,{"$f":"AL28-AL25","v":0},null,{"$f":"AN28-AN25","v":0},null,{"$f":"AP28-AP25","v":0},null,{"$f":"AR28-AR25","v":0},null,{"$f":"AT28-AT25","v":0},null,{"$f":"AV28-AV25","v":0},null,{"$f":"AX28-AX25","v":0},null,{"$f":"AZ28-AZ25","v":0},null,{"$f":"BB28-BB25","v":0},null,{"$f":"BD28-BD25","v":0},{"$nulls":3},{"$f":"BH28-BH25","v":0},null,{"$f":"BJ28-BJ25","v":0},null,{"$f":"BL28-BL25","v":0},null,{"$f":"BN28-BN25","v":0},null,{"$f":"BP28-BP25","v":0},null,{"$f":"BR28-BR25","v":0},null,{"$f":"BT28-BT25","v":0},null,{"$f":"BV28-BV25","v":0},null,{"$f":"BX28-BX25","v":0},null,{"$f":"BZ28-BZ25","v":0},null,{"$f":"CB28-CB25","v":0},null,{"$f":"CD28-CD25","v":0},null,{"$f":"CF28-CF25","v":0}]
[]
["./. ","Investitionen Umlaufvermögen",{"$nulls":25},{"$f":"'3 Investitionen'!E12*-1","v":0},null,{"$f":"AB32-SUM(D32:Z32)","v":0},{"$nulls":25},{"$f":"'3 Investitionen'!G12*-1","v":0},null,{"$f":"BD32-SUM(AF32:BB32)","v":0},{"$nulls":25},{"$f":"'3 Investitionen'!I12*-1","v":0},null,{"$f":"CF32-SUM(BH32:CD32)","v":0}]
["./. ","Investitionen Anlagevermögen",{"$nulls":25},{"$f":"'3 Investitionen'!E40","v":0},null,{"$f":"AB33-SUM(D33:Z33)","v":0},{"$nulls":25},{"$f":"'3 Investitionen'!G40","v":0},null,{"$f":"BD33-SUM(AF33:BB33)","v":0},{"$nulls":25},{"$f":"'3 Investitionen'!I40","v":0},null,{"$f":"CF33-SUM(BH33:CD33)","v":0}]
["+","Desinvestitionen Anlagevermögen",{"$nulls":25},{"$f":"'3 Investitionen'!E53","v":0},null,{"$f":"AB34-SUM(D34:Z34)","v":0},{"$nulls":25},{"$f":"'3 Investitionen'!G53","v":0},null,{"$f":"BD34-SUM(AF34:BB34)","v":0},{"$nulls":25},{"$f":"'3 Investitionen'!I53","v":0},null,{"$f":"CF34-SUM(BH34:CD34)","v":0}]
[]
["= ","Mittelfluss aus Investitionen",null,{"$f":"D34-SUM(D32:D33)","v":0},null,{"$f":"F34-SUM(F32:F33)","v":0},null,{"$f":"H34-SUM(H32:H33)","v":0},null,{"$f":"J34-SUM(J32:J33)","v":0},null,{"$f":"L34-SUM(L32:L33)","v":0},null,{"$f":"N34-SUM(N32:N33)","v":0},null,{"$f":"P34-SUM(P32:P33)","v":0},null,{"$f":"R34-SUM(R32:R33)","v":0},null,{"$f":"T34-SUM(T32:T33)","v":0},null,{"$f":"V34-SUM(V32:V33)","v":0},null,{"$f":"X34-SUM(X32:X33)","v":0},null,{"$f":"Z34-SUM(Z32:Z33)","v":0},null,{"$f":"AB34-SUM(AB32:AB33)","v":0},{"$nulls":3},{"$f":"AF34-SUM(AF32:AF33)","v":0},null,{"$f":"AH34-SUM(AH32:AH33)","v":0},null,{"$f":"AJ34-SUM(AJ32:AJ33)","v":0},null,{"$f":"AL34-SUM(AL32:AL33)","v":0},null,{"$f":"AN34-SUM(AN32:AN33)","v":0},null,{"$f":"AP34-SUM(AP32:AP33)","v":0},null,{"$f":"AR34-SUM(AR32:AR33)","v":0},null,{"$f":"AT34-SUM(AT32:AT33)","v":0},null,{"$f":"AV34-SUM(AV32:AV33)","v":0},null,{"$f":"AX34-SUM(AX32:AX33)","v":0},null,{"$f":"AZ34-SUM(AZ32:AZ33)","v":0},null,{"$f":"BB34-SUM(BB32:BB33)","v":0},null,{"$f":"BD34-SUM(BD32:BD33)","v":0},{"$nulls":3},{"$f":"BH34-SUM(BH32:BH33)","v":0},null,{"$f":"BJ34-SUM(BJ32:BJ33)","v":0},null,{"$f":"BL34-SUM(BL32:BL33)","v":0},null,{"$f":"BN34-SUM(BN32:BN33)","v":0},null,{"$f":"BP34-SUM(BP32:BP33)","v":0},null,{"$f":"BR34-SUM(BR32:BR33)","v":0},null,{"$f":"BT34-SUM(BT32:BT33)","v":0},null,{"$f":"BV34-SUM(BV32:BV33)","v":0},null,{"$f":"BX34-SUM(BX32:BX33)","v":0},null,{"$f":"BZ34-SUM(BZ32:BZ33)","v":0},null,{"$f":"CB34-SUM(CB32:CB33)","v":0},null,{"$f":"CD34-SUM(CD32:CD33)","v":0},null,{"$f":"CF34-SUM(CF32:CF33)","v":0}]
[]
["./. ","Kapitalrückzahlung",{"$nulls":25},{"$f":"(IF(('4 Finanzierung'!C21-'4 Finanzierung'!E21)>0,('4 Finanzierung'!C21-'4 Finanzierung'!E21),0))+(IF(('4 Finanzierung'!C30-'4 Finanzierung'!E30)>0,('4 Finanzierung'!C30-'4 Finanzierung'!E30),0))+(IF(('4 Finanzierung'!C34-'4 Finanzierung'!E34)>0,('4 Finanzierung'!C34-'4 Finanzierung'!E34),0))","v":0},null,{"$f":"AB38-SUM(D38:Z38)","v":0},{"$nulls":25},{"$f":"(IF(('4 Finanzierung'!E21-'4 Finanzierung'!G21)>0,('4 Finanzierung'!E21-'4 Finanzierung'!G21),0))+(IF(('4 Finanzierung'!E30-'4 Finanzierung'!G30)>0,('4 Finanzierung'!E30-'4 Finanzierung'!G30),0))+(IF(('4 Finanzierung'!E34-'4 Finanzierung'!G34)>0,('4 Finanzierung'!E34-'4 Finanzierung'!G34),0))","v":0},null,{"$f":"BD38-SUM(AF38:BB38)","v":0},{"$nulls":25},{"$f":"(IF(('4 Finanzierung'!G21-'4 Finanzierung'!I21)>0,('4 Finanzierung'!G21-'4 Finanzierung'!I21),0))+(IF(('4 Finanzierung'!G30-'4 Finanzierung'!I30)>0,('4 Finanzierung'!G30-'4 Finanzierung'!I30),0))+(IF(('4 Finanzierung'!G34-'4 Finanzierung'!I34)>0,('4 Finanzierung'!G34-'4 Finanzierung'!I34),0))","v":0},null,{"$f":"CF38-SUM(BH38:CD38)","v":0}]
["+","Kapitalaufnahme",{"$nulls":25},{"$f":"(IF(('4 Finanzierung'!C21-'4 Finanzierung'!E21)<0,('4 Finanzierung'!E21-'4 Finanzierung'!C21),0))+(IF(('4 Finanzierung'!C30-'4 Finanzierung'!E30)<0,('4 Finanzierung'!E30-'4 Finanzierung'!C30),0))+(IF(('4 Finanzierung'!C34-'4 Finanzierung'!E34)<0,('4 Finanzierung'!E34-'4 Finanzierung'!C34),0))","v":0},null,{"$f":"AB39-SUM(D39:Z39)","v":0},{"$nulls":25},{"$f":"(IF(('4 Finanzierung'!E21-'4 Finanzierung'!G21)<0,('4 Finanzierung'!G21-'4 Finanzierung'!E21),0))+(IF(('4 Finanzierung'!E30-'4 Finanzierung'!G30)<0,('4 Finanzierung'!G30-'4 Finanzierung'!E30),0))+(IF(('4 Finanzierung'!E34-'4 Finanzierung'!G34)<0,('4 Finanzierung'!G34-'4 Finanzierung'!E34),0))","v":0},null,{"$f":"BD39-SUM(AF39:BB39)","v":0},{"$nulls":25},{"$f":"(IF(('4 Finanzierung'!G21-'4 Finanzierung'!I21)<0,('4 Finanzierung'!I21-'4 Finanzierung'!G21),0))+(IF(('4 Finanzierung'!G30-'4 Finanzierung'!I30)<0,('4 Finanzierung'!I30-'4 Finanzierung'!G30),0))+(IF(('4 Finanzierung'!G34-'4 Finanzierung'!I34)<0,('4 Finanzierung'!I34-'4 Finanzierung'!G34),0))","v":0},null,{"$f":"CF39-SUM(BH39:CD39)","v":0}]
[]
["= ","Mittelfluss aus Finanzierung",null,{"$f":"D39-D38","v":0},null,{"$f":"F39-F38","v":0},null,{"$f":"H39-H38","v":0},null,{"$f":"J39-J38","v":0},null,{"$f":"L39-L38","v":0},null,{"$f":"N39-N38","v":0},null,{"$f":"P39-P38","v":0},null,{"$f":"R39-R38","v":0},null,{"$f":"T39-T38","v":0},null,{"$f":"V39-V38","v":0},null,{"$f":"X39-X38","v":0},null,{"$f":"Z39-Z38","v":0},null,{"$f":"AB39-AB38","v":0},{"$nulls":3},{"$f":"AF39-AF38","v":0},null,{"$f":"AH39-AH38","v":0},null,{"$f":"AJ39-AJ38","v":0},null,{"$f":"AL39-AL38","v":0},null,{"$f":"AN39-AN38","v":0},null,{"$f":"AP39-AP38","v":0},null,{"$f":"AR39-AR38","v":0},null,{"$f":"AT39-AT38","v":0},null,{"$f":"AV39-AV38","v":0},null,{"$f":"AX39-AX38","v":0},null,{"$f":"AZ39-AZ38","v":0},null,{"$f":"BB39-BB38","v":0},null,{"$f":"BD39-BD38","v":0},{"$nulls":3},{"$f":"BH39-BH38","v":0},null,{"$f":"BJ39-BJ38","v":0},null,{"$f":"BL39-BL38","v":0},null,{"$f":"BN39-BN38","v":0},null,{"$f":"BP39-BP38","v":0},null,{"$f":"BR39-BR38","v":0},null,{"$f":"BT39-BT38","v":0},null,{"$f":"BV39-BV38","v":0},null,{"$f":"BX39-BX38","v":0},null,{"$f":"BZ39-BZ38","v":0},null,{"$f":"CB39-CB38","v":0},null,{"$f":"CD39-CD38","v":0},null,{"$f":"CF39-CF38","v":0}]
[]
["= ","Total Zu-/Abnahme an flüssigen Mittel",null,{"$f":"D30+D36+D41","v":0},null,{"$f":"F30+F36+F41","v":0},null,{"$f":"H30+H36+H41","v":0},null,{"$f":"J30+J36+J41","v":0},null,{"$f":"L30+L36+L41","v":0},null,{"$f":"N30+N36+N41","v":0},null,{"$f":"P30+P36+P41","v":0},null,{"$f":"R30+R36+R41","v":0},null,{"$f":"T30+T36+T41","v":0},null,{"$f":"V30+V36+V41","v":0},null,{"$f":"X30+X36+X41","v":0},null,{"$f":"Z30+Z36+Z41","v":0},null,{"$f":"AB30+AB36+AB41","v":0},{"$nulls":3},{"$f":"AF30+AF36+AF41","v":0},null,{"$f":"AH30+AH36+AH41","v":0},null,{"$f":"AJ30+AJ36+AJ41","v":0},null,{"$f":"AL30+AL36+AL41","v":0},null,{"$f":"AN30+AN36+AN41","v":0},null,{"$f":"AP30+AP36+AP41","v":0},null,{"$f":"AR30+AR36+AR41","v":0},null,{"$f":"AT30+AT36+AT41","v":0},null,{"$f":"AV30+AV36+AV41","v":0},null,{"$f":"AX30+AX36+AX41","v":0},null,{"$f":"AZ30+AZ36+AZ41","v":0},null,{"$f":"BB30+BB36+BB41","v":0},null,{"$f":"BD30+BD36+BD41","v":0},{"$nulls":3},{"$f":"BH30+BH36+BH41","v":0},null,{"$f":"BJ30+BJ36+BJ41","v":0},null,{"$f":"BL30+BL36+BL41","v":0},null,{"$f":"BN30+BN36+BN41","v":0},null,{"$f":"BP30+BP36+BP41","v":0},null,{"$f":"BR30+BR36+BR41","v":0},null,{"$f":"BT30+BT36+BT41","v":0},null,{"$f":"BV30+BV36+BV41","v":0},null,{"$f":"BX30+BX36+BX41","v":0},null,{"$f":"BZ30+BZ36+BZ41","v":0},null,{"$f":"CB30+CB36+CB41","v":0},null,{"$f":"CD30+CD36+CD41","v":0},null,{"$f":"CF30+CF36+CF41","v":0}]
[]
["= ","Endbestand an flüssigen Mitteln",null,{"$f":"D10+D43","v":0},null,{"$f":"F10+F43","v":0},null,{"$f":"H10+H43","v":0},null,{"$f":"J10+J43","v":0},null,{"$f":"L10+L43","v":0},null,{"$f":"N10+N43","v":0},null,{"$f":"P10+P43","v":0},null,{"$f":"R10+R43","v":0},null,{"$f":"T10+T43","v":0},null,{"$f":"V10+V43","v":0},null,{"$f":"X10+X43","v":0},null,{"$f":"Z10+Z43","v":0},null,{"$f":"AB10+AB43","v":0},{"$nulls":3},{"$f":"AF10+AF43","v":0},null,{"$f":"AH10+AH43","v":0},null,{"$f":"AJ10+AJ43","v":0},null,{"$f":"AL10+AL43","v":0},null,{"$f":"AN10+AN43","v":0},null,{"$f":"AP10+AP43","v":0},null,{"$f":"AR10+AR43","v":0},null,{"$f":"AT10+AT43","v":0},null,{"$f":"AV10+AV43","v":0},null,{"$f":"AX10+AX43","v":0},null,{"$f":"AZ10+AZ43","v":0},null,{"$f":"BB10+BB43","v":0},null,{"$f":"BD10+BD43","v":0},{"$nulls":3},{"$f":"BH10+BH43","v":0},null,{"$f":"BJ10+BJ43","v":0},null,{"$f":"BL10+BL43","v":0},null,{"$f":"BN10+BN43","v":0},null,{"$f":"BP10+BP43","v":0},null,{"$f":"BR10+BR43","v":0},null,{"$f":"BT10+BT43","v":0},null,{"$f":"BV10+BV43","v":0},null,{"$f":"BX10+BX43","v":0},null,{"$f":"BZ10+BZ43","v":0},null,{"$f":"CB10+CB43","v":0},null,{"$f":"CD10+CD43","v":0},null,{"$f":"CF10+CF43","v":0}]
[]
["+","Kreditlimite",null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},{"$nulls":3},{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},{"$nulls":3},{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0},null,{"$f":"'4 Finanzierung'!$E$44","v":0}]
["./. ","Benutzte Kreditlimite",null,{"$f":"D45","v":0},null,{"$f":"F45","v":0},null,{"$f":"H45","v":0},null,{"$f":"J45","v":0},null,{"$f":"L45","v":0},null,{"$f":"N45","v":0},null,{"$f":"P45","v":0},null,{"$f":"R45","v":0},null,{"$f":"T45","v":0},null,{"$f":"V45","v":0},null,{"$f":"X45","v":0},null,{"$f":"Z45","v":0},null,{"$f":"AB45","v":0},{"$nulls":3},{"$f":"AF45","v":0},null,{"$f":"AH45","v":0},null,{"$f":"AJ45","v":0},null,{"$f":"AL45","v":0},null,{"$f":"AN45","v":0},null,{"$f":"AP45","v":0},null,{"$f":"AR45","v":0},null,{"$f":"AT45","v":0},null,{"$f":"AV45","v":0},null,{"$f":"AX45","v":0},null,{"$f":"AZ45","v":0},null,{"$f":"BB45","v":0},null,{"$f":"BD45","v":0},{"$nulls":3},{"$f":"BH45","v":0},null,{"$f":"BJ45","v":0},null,{"$f":"BL45","v":0},null,{"$f":"BN45","v":0},null,{"$f":"BP45","v":0},null,{"$f":"BR45","v":0},null,{"$f":"BT45","v":0},null,{"$f":"BV45","v":0},null,{"$f":"BX45","v":0},null,{"$f":"BZ45","v":0},null,{"$f":"CB45","v":0},null,{"$f":"CD45","v":0},null,{"$f":"CF45","v":0}]
[]
[null,"Verfügbar / Finanzierungsbedarf",null,{"$f":"D47+D48","v":0},null,{"$f":"F47+F48","v":0},null,{"$f":"H47+H48","v":0},null,{"$f":"J47+J48","v":0},null,{"$f":"L47+L48","v":0},null,{"$f":"N47+N48","v":0},null,{"$f":"P47+P48","v":0},null,{"$f":"R47+R48","v":0},null,{"$f":"T47+T48","v":0},null,{"$f":"V47+V48","v":0},null,{"$f":"X47+X48","v":0},null,{"$f":"Z47+Z48","v":0},null,{"$f":"AB47+AB48","v":0},{"$nulls":3},{"$f":"AF47+AF48","v":0},null,{"$f":"AH47+AH48","v":0},null,{"$f":"AJ47+AJ48","v":0},null,{"$f":"AL47+AL48","v":0},null,{"$f":"AN47+AN48","v":0},null,{"$f":"AP47+AP48","v":0},null,{"$f":"AR47+AR48","v":0},null,{"$f":"AT47+AT48","v":0},null,{"$f":"AV47+AV48","v":0},null,{"$f":"AX47+AX48","v":0},null,{"$f":"AZ47+AZ48","v":0},null,{"$f":"BB47+BB48","v":0},null,{"$f":"BD47+BD48","v":0},{"$nulls":3},{"$f":"BH47+BH48","v":0},null,{"$f":"BJ47+BJ48","v":0},null,{"$f":"BL47+BL48","v":0},null,{"$f":"BN47+BN48","v":0},null,{"$f":"BP47+BP48","v":0},null,{"$f":"BR47+BR48","v":0},null,{"$f":"BT47+BT48","v":0},null,{"$f":"BV47+BV48","v":0},null,{"$f":"BX47+BX48","v":0},null,{"$f":"BZ47+BZ48","v":0},null,{"$f":"CB47+CB48","v":0},null,{"$f":"CD47+CD48","v":0},null,{"$f":"CF47+CF48","v":0}]

{"sheet":"7 Bilanz","index":8,"n_rows":60,"n_cols":25,"rows_kept":60}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Planbilanz"]
[]
["AKTIVEN",null,{"$f":"Titel!$B$24-3","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"Titel!$B$24-2","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,"in %",null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}},null,"in %"]
[]
["Umlaufvermögen"]
[{"$f":"'3 Investitionen'!A18","v":"Liquide Mittel (Kasse, Bank)"},{"$nulls":3},{"$f":"IF(ISERROR(C13/$C$34),\"\",C13/$C$34)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G13/$G$34),\"\",G13/$G$34)","v":""},null,{"$f":"'3 Investitionen'!C18","v":0},null,{"$f":"IF(ISERROR(K13/$K$34),\"\",K13/$K$34)","v":""},null,{"$f":"'3 Investitionen'!E18","v":0},null,{"$f":"IF(ISERROR(O13/$O$34),\"\",O13/$O$34)","v":""},null,{"$f":"'3 Investitionen'!G18","v":0},null,{"$f":"IF(ISERROR(S13/$S$34),\"\",S13/$S$34)","v":""},null,{"$f":"'3 Investitionen'!I18","v":0},null,{"$f":"IF(ISERROR(W13/$W$34),\"\",W13/$W$34)","v":""}]
[{"$f":"'3 Investitionen'!A19","v":"Forderungen (Debitoren)"},{"$nulls":3},{"$f":"IF(ISERROR(C14/$C$34),\"\",C14/$C$34)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G14/$G$34),\"\",G14/$G$34)","v":""},null,{"$f":"'3 Investitionen'!C19","v":0},null,{"$f":"IF(ISERROR(K14/$K$34),\"\",K14/$K$34)","v":""},null,{"$f":"'3 Investitionen'!E19","v":0},null,{"$f":"IF(ISERROR(O14/$O$34),\"\",O14/$O$34)","v":""},null,{"$f":"'3 Investitionen'!G19","v":0},null,{"$f":"IF(ISERROR(S14/$S$34),\"\",S14/$S$34)","v":""},null,{"$f":"'3 Investitionen'!I19","v":0},null,{"$f":"IF(ISERROR(W14/$W$34),\"\",W14/$W$34)","v":""}]
[{"$f":"'3 Investitionen'!A20","v":"Vorräte"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C20","v":0},null,"",null,{"$f":"'3 Investitionen'!E20","v":0},null,"",null,{"$f":"'3 Investitionen'!G20","v":0},null,"",null,{"$f":"'3 Investitionen'!I20","v":0},null,""]
[{"$f":"'3 Investitionen'!A21","v":"Halb- und Fertigfabrikate"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C21","v":0},null,"",null,{"$f":"'3 Investitionen'!E21","v":0},null,"",null,{"$f":"'3 Investitionen'!G21","v":0},null,"",null,{"$f":"'3 Investitionen'!I21","v":0},null,""]
[{"$f":"'3 Investitionen'!A22","v":"[Weiteres Umlaufvermögen]"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C22","v":0},null,"",null,{"$f":"'3 Investitionen'!E22","v":0},null,"",null,{"$f":"'3 Investitionen'!G22","v":0},null,"",null,{"$f":"'3 Investitionen'!I22","v":0},null,""]
[{"$f":"'3 Investitionen'!A23","v":"[Weiteres Umlaufvermögen]"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C23","v":0},null,"",null,{"$f":"'3 Investitionen'!E23","v":0},null,"",null,{"$f":"'3 Investitionen'!G23","v":0},null,"",null,{"$f":"'3 Investitionen'!I23","v":0},null,""]
[{"$f":"'3 Investitionen'!A24","v":"[Weiteres Umlaufvermögen]"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C24","v":0},null,"",null,{"$f":"'3 Investitionen'!E24","v":0},null,"",null,{"$f":"'3 Investitionen'!G24","v":0},null,"",null,{"$f":"'3 Investitionen'!I24","v":0},null,""]
[{"$f":"'3 Investitionen'!A25","v":"[Weiteres Umlaufvermögen]"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C25","v":0},null,"",null,{"$f":"'3 Investitionen'!E25","v":0},null,"",null,{"$f":"'3 Investitionen'!G25","v":0},null,"",null,{"$f":"'3 Investitionen'!I25","v":0},null,""]
["Total Umlaufvermögen",null,{"$f":"SUM(C13:C20)","v":0},null,{"$f":"IF(ISERROR(C21/$C$34),\"\",C21/$C$34)","v":""},null,{"$f":"SUM(G13:G20)","v":0},null,{"$f":"IF(ISERROR(G21/$G$34),\"\",G21/$G$34)","v":""},null,{"$f":"SUM(K13:K20)","v":0},null,{"$f":"IF(ISERROR(K21/$K$34),\"\",K21/$K$34)","v":""},null,{"$f":"SUM(O13:O20)","v":0},null,"",null,{"$f":"SUM(S13:S20)","v":0},null,"",null,{"$f":"SUM(W13:W20)","v":0},null,""]
[]
["Anlagevermögen"]
[{"$f":"'3 Investitionen'!A31","v":"Maschinen"},{"$nulls":3},{"$f":"IF(ISERROR(C24/$C$34),\"\",C24/$C$34)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G24/$G$34),\"\",G24/$G$34)","v":""},null,{"$f":"'3 Investitionen'!C57","v":0},null,{"$f":"IF(ISERROR(K24/$K$34),\"\",K24/$K$34)","v":""},null,{"$f":"'3 Investitionen'!C57+'3 Investitionen'!E31-'3 Investitionen'!E44-'2 Kosten'!C33","v":0},null,{"$f":"IF(ISERROR(O24/$O$34),\"\",O24/$O$34)","v":""},null,{"$f":"O24+'3 Investitionen'!G31-'3 Investitionen'!G44-'2 Kosten'!E33","v":0},null,{"$f":"IF(ISERROR(S24/$S$34),\"\",S24/$S$34)","v":""},null,{"$f":"S24+'3 Investitionen'!I31-'3 Investitionen'!I44-'2 Kosten'!G33","v":0},null,{"$f":"IF(ISERROR(W24/$W$34),\"\",W24/$W$34)","v":""}]
[{"$f":"'3 Investitionen'!A32","v":"Mobilen"},{"$nulls":3},{"$f":"IF(ISERROR(C25/$C$34),\"\",C25/$C$34)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G25/$G$34),\"\",G25/$G$34)","v":""},null,{"$f":"'3 Investitionen'!C58","v":0},null,{"$f":"IF(ISERROR(K25/$K$34),\"\",K25/$K$34)","v":""},null,{"$f":"'3 Investitionen'!C58+'3 Investitionen'!E32-'3 Investitionen'!E45-'2 Kosten'!C34","v":0},null,{"$f":"IF(ISERROR(O25/$O$34),\"\",O25/$O$34)","v":""},null,{"$f":"O25+'3 Investitionen'!G32-'3 Investitionen'!G45-'2 Kosten'!E34","v":0},null,{"$f":"IF(ISERROR(S25/$S$34),\"\",S25/$S$34)","v":""},null,{"$f":"S25+'3 Investitionen'!I32-'3 Investitionen'!I45-'2 Kosten'!G34","v":0},null,{"$f":"IF(ISERROR(W25/$W$34),\"\",W25/$W$34)","v":""}]
[{"$f":"'3 Investitionen'!A33","v":"Fahrzeuge"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C59","v":0},null,"",null,{"$f":"'3 Investitionen'!C59+'3 Investitionen'!E33-'3 Investitionen'!E46-'2 Kosten'!C35","v":0},null,"",null,{"$f":"O26+'3 Investitionen'!G33-'3 Investitionen'!G46-'2 Kosten'!E35","v":0},null,"",null,{"$f":"S26+'3 Investitionen'!I33-'3 Investitionen'!I46-'2 Kosten'!G35","v":0},null,""]
[{"$f":"'3 Investitionen'!A34","v":"Immobilien"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C60","v":0},null,"",null,{"$f":"'3 Investitionen'!C60+'3 Investitionen'!E34-'3 Investitionen'!E47-'2 Kosten'!C36","v":0},null,"",null,{"$f":"O27+'3 Investitionen'!G34-'3 Investitionen'!G47-'2 Kosten'!E36","v":0},null,"",null,{"$f":"S27+'3 Investitionen'!I34-'3 Investitionen'!I47-'2 Kosten'!G36","v":0},null,""]
[{"$f":"'3 Investitionen'!A35","v":"Immaterielle Anlagen (Patente, Lizenzen)"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C61","v":0},null,"",null,{"$f":"'3 Investitionen'!C61+'3 Investitionen'!E35-'3 Investitionen'!E48-'2 Kosten'!C37","v":0},null,"",null,{"$f":"O28+'3 Investitionen'!G35-'3 Investitionen'!G48-'2 Kosten'!E37","v":0},null,"",null,{"$f":"S28+'3 Investitionen'!I35-'3 Investitionen'!I48-'2 Kosten'!G37","v":0},null,""]
[{"$f":"'3 Investitionen'!A36","v":"Beteiligungen"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C62","v":0},null,"",null,{"$f":"'3 Investitionen'!C62+'3 Investitionen'!E36-'3 Investitionen'!E49-'2 Kosten'!C38","v":0},null,"",null,{"$f":"O29+'3 Investitionen'!G36-'3 Investitionen'!G49-'2 Kosten'!E38","v":0},null,"",null,{"$f":"S29+'3 Investitionen'!I36-'3 Investitionen'!I49-'2 Kosten'!G38","v":0},null,""]
[{"$f":"'3 Investitionen'!A37","v":"[Weiteres Anlagevermögen]"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C63","v":0},null,"",null,{"$f":"'3 Investitionen'!C63+'3 Investitionen'!E37-'3 Investitionen'!E50-'2 Kosten'!C39","v":0},null,"",null,{"$f":"O30+'3 Investitionen'!G37-'3 Investitionen'!G50","v":0},null,"",null,{"$f":"S30+'3 Investitionen'!I37-'3 Investitionen'!I50","v":0},null,""]
[{"$f":"'3 Investitionen'!A38","v":"[Weiteres Anlagevermögen]"},{"$nulls":3},"",{"$nulls":3},"",null,{"$f":"'3 Investitionen'!C64","v":0},null,"",null,{"$f":"'3 Investitionen'!C64+'3 Investitionen'!E38-'3 Investitionen'!E51-'2 Kosten'!C40","v":0},null,"",null,{"$f":"O31+'3 Investitionen'!G38-'3 Investitionen'!G51","v":0},null,"",null,{"$f":"S31+'3 Investitionen'!I38-'3 Investitionen'!I51","v":0},null,""]
["Total Anlagevermögen",null,{"$f":"SUM(C24:C31)","v":0},null,{"$f":"IF(ISERROR(C32/$C$34),\"\",C32/$C$34)","v":""},null,{"$f":"SUM(G24:G31)","v":0},null,{"$f":"IF(ISERROR(G32/$G$34),\"\",G32/$G$34)","v":""},null,{"$f":"SUM(K24:K31)","v":0},null,{"$f":"IF(ISERROR(K32/$K$34),\"\",K32/$K$34)","v":""},null,{"$f":"SUM(O24:O31)","v":0},null,{"$f":"IF(ISERROR(O32/$O$34),\"\",O32/$O$34)","v":""},null,{"$f":"SUM(S24:S31)","v":0},null,{"$f":"IF(ISERROR(S32/$S$34),\"\",S32/$S$34)","v":""},null,{"$f":"SUM(W24:W31)","v":0},null,{"$f":"IF(ISERROR(W32/$W$34),\"\",W32/$W$34)","v":""}]
[]
["Total Aktiven",null,{"$f":"C21+C32","v":0},null,{"$f":"IF(ISERROR(C34/$C$34),\"\",C34/$C$34)","v":""},null,{"$f":"G21+G32","v":0},null,{"$f":"IF(ISERROR(G34/$G$34),\"\",G34/$G$34)","v":""},null,{"$f":"K21+K32","v":0},null,{"$f":"IF(ISERROR(K34/$K$34),\"\",K34/$K$34)","v":""},null,{"$f":"O21+O32","v":0},null,{"$f":"IF(ISERROR(O34/$O$34),\"\",O34/$O$34)","v":""},null,{"$f":"S21+S32","v":0},null,{"$f":"IF(ISERROR(S34/$S$34),\"\",S34/$S$34)","v":""},null,{"$f":"W21+W32","v":0},null,{"$f":"IF(ISERROR(W34/$W$34),\"\",W34/$W$34)","v":""}]
[]
[]
["PASSIVEN",null,{"$f":"Titel!$B$24-3","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"Titel!$B$24-2","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"\"Planjahr \"&Titel!$B$24","v":"Planjahr [1. Planjahr]"},null,"in %",null,{"$f":"\"Planjahr \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,"in %",null,{"$f":"\"Planjahr \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}},null,"in %"]
[]
["Kurzfristiges Fremdkapital"]
[{"$f":"'4 Finanzierung'!A17","v":"Kreditoren"},{"$nulls":3},{"$f":"IF(ISERROR(C40/$C$58),\"\",C40/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G40/$G$58),\"\",G40/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C17","v":0},null,{"$f":"IF(ISERROR(K40/$K$58),\"\",K40/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E17","v":0},null,{"$f":"IF(ISERROR(O40/$O$58),\"\",O40/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G17","v":0},null,{"$f":"IF(ISERROR(S40/$S$58),\"\",S40/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I17","v":0},null,{"$f":"IF(ISERROR(W40/$W$58),\"\",W40/$W$58)","v":""}]
[{"$f":"'4 Finanzierung'!A18","v":"Bankschulden"},{"$nulls":3},{"$f":"IF(ISERROR(C41/$C$58),\"\",C41/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G41/$G$58),\"\",G41/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C18","v":0},null,{"$f":"IF(ISERROR(K41/$K$58),\"\",K41/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E18","v":0},null,{"$f":"IF(ISERROR(O41/$O$58),\"\",O41/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G18","v":0},null,{"$f":"IF(ISERROR(S41/$S$58),\"\",S41/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I18","v":0},null,{"$f":"IF(ISERROR(W41/$W$58),\"\",W41/$W$58)","v":""}]
[{"$f":"'4 Finanzierung'!A19","v":"Andere kurzfristige Verbindlichkeiten"},{"$nulls":3},{"$f":"IF(ISERROR(C42/$C$58),\"\",C42/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G42/$G$58),\"\",G42/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C19","v":0},null,{"$f":"IF(ISERROR(K42/$K$58),\"\",K42/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E19","v":0},null,{"$f":"IF(ISERROR(O42/$O$58),\"\",O42/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G19","v":0},null,{"$f":"IF(ISERROR(S42/$S$58),\"\",S42/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I19","v":0},null,{"$f":"IF(ISERROR(W42/$W$58),\"\",W42/$W$58)","v":""}]
["Total kurzfristiges Fremdkapital",{"$f":"SUM(B40:B42)","v":0},{"$f":"SUM(C40:C42)","v":0},null,{"$f":"IF(ISERROR(C43/$C$58),\"\",C43/$C$58)","v":""},{"$f":"SUM(F40:F42)","v":0},{"$f":"SUM(G40:G42)","v":0},null,{"$f":"IF(ISERROR(G43/$G$58),\"\",G43/$G$58)","v":""},{"$f":"SUM(J40:J42)","v":0},{"$f":"SUM(K40:K42)","v":0},null,{"$f":"IF(ISERROR(K43/$K$58),\"\",K43/$K$58)","v":""},null,{"$f":"SUM(O40:O42)","v":0},null,{"$f":"IF(ISERROR(O43/$O$58),\"\",O43/$O$58)","v":""},{"$f":"SUM(R40:R42)","v":0},{"$f":"SUM(S40:S42)","v":0},null,{"$f":"IF(ISERROR(S43/$S$58),\"\",S43/$S$58)","v":""},{"$f":"SUM(V40:V42)","v":0},{"$f":"SUM(W40:W42)","v":0},null,{"$f":"IF(ISERROR(W43/$W$58),\"\",W43/$W$58)","v":""}]
[]
["Langfristiges Fremdkapital"]
[{"$f":"'4 Finanzierung'!A25","v":"Darlehen"},{"$nulls":3},{"$f":"IF(ISERROR(C46/$C$58),\"\",C46/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G46/$G$58),\"\",G46/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C25","v":0},null,{"$f":"IF(ISERROR(K46/$K$58),\"\",K46/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E25","v":0},null,{"$f":"IF(ISERROR(O46/$O$58),\"\",O46/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G25","v":0},null,{"$f":"IF(ISERROR(S46/$S$58),\"\",S46/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I25","v":0},null,{"$f":"IF(ISERROR(W46/$W$58),\"\",W46/$W$58)","v":""}]
[{"$f":"'4 Finanzierung'!A26","v":"Hypotheken"},{"$nulls":3},{"$f":"IF(ISERROR(C47/$C$58),\"\",C47/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G47/$G$58),\"\",G47/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C26","v":0},null,{"$f":"IF(ISERROR(K47/$K$58),\"\",K47/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E26","v":0},null,{"$f":"IF(ISERROR(O47/$O$58),\"\",O47/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G26","v":0},null,{"$f":"IF(ISERROR(S47/$S$58),\"\",S47/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I26","v":0},null,{"$f":"IF(ISERROR(W47/$W$58),\"\",W47/$W$58)","v":""}]
[{"$f":"'4 Finanzierung'!A27","v":"Andere langfristige Verbindlichkeiten"},{"$nulls":3},{"$f":"IF(ISERROR(C48/$C$58),\"\",C48/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G48/$G$58),\"\",G48/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C27","v":0},null,{"$f":"IF(ISERROR(K48/$K$58),\"\",K48/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E27","v":0},null,{"$f":"IF(ISERROR(O48/$O$58),\"\",O48/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G27","v":0},null,{"$f":"IF(ISERROR(S48/$S$58),\"\",S48/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I27","v":0},null,{"$f":"IF(ISERROR(W48/$W$58),\"\",W48/$W$58)","v":""}]
[{"$f":"'4 Finanzierung'!A28","v":"Rückstellungen"},{"$nulls":3},{"$f":"IF(ISERROR(C49/$C$58),\"\",C49/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G49/$G$58),\"\",G49/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C28","v":0},null,{"$f":"IF(ISERROR(K49/$K$58),\"\",K49/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E28","v":0},null,{"$f":"IF(ISERROR(O49/$O$58),\"\",O49/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G28","v":0},null,{"$f":"IF(ISERROR(S49/$S$58),\"\",S49/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I28","v":0},null,{"$f":"IF(ISERROR(W49/$W$58),\"\",W49/$W$58)","v":""}]
["Total langfristiges Fremdkapital",{"$f":"SUM(B46:B49)","v":0},{"$f":"SUM(C46:C49)","v":0},null,{"$f":"IF(ISERROR(C50/$C$58),\"\",C50/$C$58)","v":""},{"$f":"SUM(F46:F49)","v":0},{"$f":"SUM(G46:G49)","v":0},null,{"$f":"IF(ISERROR(G50/$G$58),\"\",G50/$G$58)","v":""},{"$f":"SUM(J46:J49)","v":0},{"$f":"SUM(K46:K49)","v":0},null,{"$f":"IF(ISERROR(K50/$K$58),\"\",K50/$K$58)","v":""},null,{"$f":"SUM(O46:O49)","v":0},null,{"$f":"IF(ISERROR(O50/$O$58),\"\",O50/$O$58)","v":""},{"$f":"SUM(R46:R49)","v":0},{"$f":"SUM(S46:S49)","v":0},null,{"$f":"IF(ISERROR(S50/$S$58),\"\",S50/$S$58)","v":""},{"$f":"SUM(V46:V49)","v":0},{"$f":"SUM(W46:W49)","v":0},null,{"$f":"IF(ISERROR(W50/$W$58),\"\",W50/$W$58)","v":""}]
[]
["Eigenkapital"]
[{"$f":"'4 Finanzierung'!A34","v":"Aktienkapital/Stammkapital"},{"$nulls":3},{"$f":"IF(ISERROR(C53/$C$58),\"\",C53/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G53/$G$58),\"\",G53/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C34","v":0},null,{"$f":"IF(ISERROR(K53/$K$58),\"\",K53/$K$58)","v":""},null,{"$f":"'4 Finanzierung'!E34","v":0},null,{"$f":"IF(ISERROR(O53/$O$58),\"\",O53/$O$58)","v":""},null,{"$f":"'4 Finanzierung'!G34","v":0},null,{"$f":"IF(ISERROR(S53/$S$58),\"\",S53/$S$58)","v":""},null,{"$f":"'4 Finanzierung'!I34","v":0},null,{"$f":"IF(ISERROR(W53/$W$58),\"\",W53/$W$58)","v":""}]
[{"$f":"'4 Finanzierung'!A35","v":"Reserven"},{"$nulls":3},{"$f":"IF(ISERROR(C54/$C$58),\"\",C54/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G54/$G$58),\"\",G54/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C35","v":0},null,{"$f":"IF(ISERROR(K54/$K$58),\"\",K54/$K$58)","v":""},null,{"$f":"K54","v":0},null,{"$f":"IF(ISERROR(O54/$O$58),\"\",O54/$O$58)","v":""},null,{"$f":"O54","v":0},null,{"$f":"IF(ISERROR(S54/$S$58),\"\",S54/$S$58)","v":""},null,{"$f":"S54","v":0},null,{"$f":"IF(ISERROR(W54/$W$58),\"\",W54/$W$58)","v":""}]
[{"$f":"'4 Finanzierung'!A36","v":"Bilanzgewinn / -verlust inkl. Vortrag"},{"$nulls":3},{"$f":"IF(ISERROR(C55/$C$58),\"\",C55/$C$58)","v":""},{"$nulls":3},{"$f":"IF(ISERROR(G55/$G$58),\"\",G55/$G$58)","v":""},null,{"$f":"'4 Finanzierung'!C36","v":0},null,{"$f":"IF(ISERROR(K55/$K$58),\"\",K55/$K$58)","v":""},null,{"$f":"K55+'5 Erfolg'!P29","v":0},null,{"$f":"IF(ISERROR(O55/$O$58),\"\",O55/$O$58)","v":""},null,{"$f":"O55+'5 Erfolg'!T29","v":0},null,{"$f":"IF(ISERROR(S55/$S$58),\"\",S55/$S$58)","v":""},null,{"$f":"S55+'5 Erfolg'!X29","v":0},null,{"$f":"IF(ISERROR(W55/$W$58),\"\",W55/$W$58)","v":""}]
["Total Eigenkapital",{"$f":"SUM(B53:B55)","v":0},{"$f":"SUM(C53:C55)","v":0},null,{"$f":"IF(ISERROR(C56/$C$58),\"\",C56/$C$58)","v":""},{"$f":"SUM(F53:F55)","v":0},{"$f":"SUM(G53:G55)","v":0},null,{"$f":"IF(ISERROR(G56/$G$58),\"\",G56/$G$58)","v":""},{"$f":"SUM(J53:J55)","v":0},{"$f":"SUM(K53:K55)","v":0},null,{"$f":"IF(ISERROR(K56/$K$58),\"\",K56/$K$58)","v":""},null,{"$f":"SUM(O53:O55)","v":0},null,{"$f":"IF(ISERROR(O56/$O$58),\"\",O56/$O$58)","v":""},{"$f":"SUM(R53:R55)","v":0},{"$f":"SUM(S53:S55)","v":0},null,{"$f":"IF(ISERROR(S56/$S$58),\"\",S56/$S$58)","v":""},{"$f":"SUM(V53:V55)","v":0},{"$f":"SUM(W53:W55)","v":0},null,{"$f":"IF(ISERROR(W56/$W$58),\"\",W56/$W$58)","v":""}]
[]
["Total Passiven",{"$f":"B43+B50+B56","v":0},{"$f":"C43+C50+C56","v":0},null,{"$f":"IF(ISERROR(C58/$C$58),\"\",C58/$C$58)","v":""},{"$f":"F43+F50+F56","v":0},{"$f":"G43+G50+G56","v":0},null,{"$f":"IF(ISERROR(G58/$G$58),\"\",G58/$G$58)","v":""},{"$f":"J43+J50+J56","v":0},{"$f":"K43+K50+K56","v":0},null,{"$f":"IF(ISERROR(K58/$K$58),\"\",K58/$K$58)","v":""},null,{"$f":"O43+O50+O56","v":0},null,{"$f":"IF(ISERROR(O58/$O$58),\"\",O58/$O$58)","v":""},{"$f":"R43+R50+R56","v":0},{"$f":"S43+S50+S56","v":0},null,{"$f":"IF(ISERROR(S58/$S$58),\"\",S58/$S$58)","v":""},{"$f":"V43+V50+V56","v":0},{"$f":"W43+W50+W56","v":0},null,{"$f":"IF(ISERROR(W58/$W$58),\"\",W58/$W$58)","v":""}]
[]
[{"$nulls":23},{"$f":"X58-X34","v":0}]

{"sheet":"8 Kennzahlen","index":9,"n_rows":27,"n_cols":17,"rows_kept":27}
[]
[]
[]
[{"$f":"Titel!A17","v":"[Finanzplan 20XX-20XX]"}]
[{"$f":"Titel!A18","v":"[Ihre Firma]"}]
[]
[]
["Kennzahlen",{"$nulls":3},"Zielgrössen",null,{"$f":"Titel!$B$24-3","v":{"$error":"#VALUE!"}},null,{"$f":"Titel!$B$24-2","v":{"$error":"#VALUE!"}},null,{"$f":"Titel!$B$24-1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24","v":"Plan [1. Planjahr]"},null,{"$f":"\"Plan \"&Titel!$B$24+1","v":{"$error":"#VALUE!"}},null,{"$f":"\"Plan \"&Titel!$B$24+2","v":{"$error":"#VALUE!"}}]
[]
["Erfolg",null,"Umsatz",{"$nulls":3},{"$f":"'5 Erfolg'!D10","v":0},null,{"$f":"'5 Erfolg'!H10","v":0},null,{"$f":"'5 Erfolg'!L10","v":0},null,{"$f":"'5 Erfolg'!P10","v":0},null,{"$f":"'5 Erfolg'!T10","v":0},null,{"$f":"'5 Erfolg'!X10","v":0}]
[null,null,"EBIT",{"$nulls":3},{"$f":"'5 Erfolg'!D25","v":0},null,{"$f":"'5 Erfolg'!H25","v":0},null,{"$f":"'5 Erfolg'!L25","v":0},null,{"$f":"'5 Erfolg'!P25","v":0},null,{"$f":"'5 Erfolg'!T25","v":0},null,{"$f":"'5 Erfolg'!X25","v":0}]
[null,null,"Reingewinn",{"$nulls":3},{"$f":"'5 Erfolg'!D29","v":0},null,{"$f":"'5 Erfolg'!H29","v":0},null,{"$f":"'5 Erfolg'!L29","v":0},null,{"$f":"'5 Erfolg'!P29","v":0},null,{"$f":"'5 Erfolg'!T29","v":0},null,{"$f":"'5 Erfolg'!X29","v":0}]
[null,null,"Eigenkapital-Rendite",{"$nulls":3},{"$f":"G12/'7 Bilanz'!C56","v":{"$error":"#DIV/0!"}},null,{"$f":"I12/'7 Bilanz'!G56","v":{"$error":"#DIV/0!"}},null,{"$f":"K12/'7 Bilanz'!K56","v":{"$error":"#DIV/0!"}},null,{"$f":"M12/'7 Bilanz'!O56","v":{"$error":"#DIV/0!"}},null,{"$f":"O12/'7 Bilanz'!S56","v":{"$error":"#DIV/0!"}},null,{"$f":"Q12/'7 Bilanz'!W56","v":{"$error":"#DIV/0!"}}]
[null,null,"Gesamtkapital-Rendite",{"$nulls":3},{"$f":"G12/'7 Bilanz'!C58","v":{"$error":"#DIV/0!"}},null,{"$f":"I12/'7 Bilanz'!G58","v":{"$error":"#DIV/0!"}},null,{"$f":"K12/'7 Bilanz'!K58","v":{"$error":"#DIV/0!"}},null,{"$f":"M12/'7 Bilanz'!O58","v":{"$error":"#DIV/0!"}},null,{"$f":"O12/'7 Bilanz'!S58","v":{"$error":"#DIV/0!"}},null,{"$f":"Q12/'7 Bilanz'!W58","v":{"$error":"#DIV/0!"}}]
[null,null,"Umsatz-Rendite",{"$nulls":3},{"$f":"G12/G10","v":{"$error":"#DIV/0!"}},null,{"$f":"I12/I10","v":{"$error":"#DIV/0!"}},null,{"$f":"K12/K10","v":{"$error":"#DIV/0!"}},null,{"$f":"M12/M10","v":{"$error":"#DIV/0!"}},null,{"$f":"O12/O10","v":{"$error":"#DIV/0!"}},null,{"$f":"Q12/Q10","v":{"$error":"#DIV/0!"}}]
[null,null,"Bruttogewinn-Marge",{"$nulls":3},{"$f":"'5 Erfolg'!D12/'5 Erfolg'!D10","v":{"$error":"#DIV/0!"}},null,{"$f":"'5 Erfolg'!H12/'5 Erfolg'!H10","v":{"$error":"#DIV/0!"}},null,{"$f":"'5 Erfolg'!L12/'5 Erfolg'!L10","v":{"$error":"#DIV/0!"}},null,{"$f":"'5 Erfolg'!P12/'5 Erfolg'!P10","v":{"$error":"#DIV/0!"}},null,{"$f":"'5 Erfolg'!T12/'5 Erfolg'!T10","v":{"$error":"#DIV/0!"}},null,{"$f":"'5 Erfolg'!X12/'5 Erfolg'!X10","v":{"$error":"#DIV/0!"}}]
[null,null,"Cashflow-Marge",{"$nulls":3},{"$f":"G24/G10","v":{"$error":"#DIV/0!"}},null,{"$f":"I24/I10","v":{"$error":"#DIV/0!"}},null,{"$f":"K24/K10","v":{"$error":"#DIV/0!"}},null,{"$f":"M24/M10","v":{"$error":"#DIV/0!"}},null,{"$f":"O24/O10","v":{"$error":"#DIV/0!"}},null,{"$f":"Q24/Q10","v":{"$error":"#DIV/0!"}}]
[]
["Sicherheit",null,"Eigenfinanzierungsgrad",{"$nulls":3},{"$f":"'7 Bilanz'!C56/'7 Bilanz'!C58","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!G56/'7 Bilanz'!G58","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!K56/'7 Bilanz'!K58","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!O56/'7 Bilanz'!O58","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!S56/'7 Bilanz'!S58","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!W56/'7 Bilanz'!W58","v":{"$error":"#DIV/0!"}}]
[null,null,"Verschuldungsfaktor",{"$nulls":3},{"$f":"('7 Bilanz'!C43+'7 Bilanz'!C50-'7 Bilanz'!C13-'7 Bilanz'!C14)/G24","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!G43+'7 Bilanz'!G50-'7 Bilanz'!G13-'7 Bilanz'!G14)/I24","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!K43+'7 Bilanz'!K50-'7 Bilanz'!K13-'7 Bilanz'!K14)/K24","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!O43+'7 Bilanz'!O50-'7 Bilanz'!O13-'7 Bilanz'!O14)/M24","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!S43+'7 Bilanz'!S50-'7 Bilanz'!S13-'7 Bilanz'!S14)/O24","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!W43+'7 Bilanz'!W50-'7 Bilanz'!W13-'7 Bilanz'!W14)/Q24","v":{"$error":"#DIV/0!"}}]
[null,null,"Anlagedeckungsgrad 2",{"$nulls":3},{"$f":"('7 Bilanz'!C56+'7 Bilanz'!C50)/'7 Bilanz'!C32","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!G56+'7 Bilanz'!G50)/'7 Bilanz'!G32","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!K56+'7 Bilanz'!K50)/'7 Bilanz'!K32","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!O56+'7 Bilanz'!O50)/'7 Bilanz'!O32","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!S56+'7 Bilanz'!S50)/'7 Bilanz'!S32","v":{"$error":"#DIV/0!"}},null,{"$f":"('7 Bilanz'!W56+'7 Bilanz'!W50)/'7 Bilanz'!W32","v":{"$error":"#DIV/0!"}}]
[null,null,"Verschuldung gemäss OR 725a",{"$nulls":3},{"$f":"SUMIF('7 Bilanz'!C55,\"<0\",'7 Bilanz'!C55)/('7 Bilanz'!C53+'7 Bilanz'!C54)*-1","v":{"$error":"#DIV/0!"}},null,{"$f":"SUMIF('7 Bilanz'!G55,\"<0\",'7 Bilanz'!G55)/('7 Bilanz'!G53+'7 Bilanz'!G54)*-1","v":{"$error":"#DIV/0!"}},null,{"$f":"SUMIF('7 Bilanz'!K55,\"<0\",'7 Bilanz'!K55)/('7 Bilanz'!K53+'7 Bilanz'!K54)*-1","v":{"$error":"#DIV/0!"}},null,{"$f":"SUMIF('7 Bilanz'!O55,\"<0\",'7 Bilanz'!O55)/('7 Bilanz'!O53+'7 Bilanz'!O54)*-1","v":{"$error":"#DIV/0!"}},null,{"$f":"SUMIF('7 Bilanz'!S55,\"<0\",'7 Bilanz'!S55)/('7 Bilanz'!S53+'7 Bilanz'!S54)*-1","v":{"$error":"#DIV/0!"}},null,{"$f":"SUMIF('7 Bilanz'!W55,\"<0\",'7 Bilanz'!W55)/('7 Bilanz'!W53+'7 Bilanz'!W54)*-1","v":{"$error":"#DIV/0!"}}]
[]
["Liquidität",null,"Cashflow",{"$nulls":3},{"$f":"'5 Erfolg'!D29+'5 Erfolg'!D24","v":0},null,{"$f":"'5 Erfolg'!H29+'5 Erfolg'!H24","v":0},null,{"$f":"'5 Erfolg'!L29+'5 Erfolg'!L24","v":0},null,{"$f":"'6 Liquidität'!AB30","v":0},null,{"$f":"'6 Liquidität'!BD30","v":0},null,{"$f":"'6 Liquidität'!CF30","v":0}]
[null,null,"Freecashflow",{"$nulls":3},"n.a.",null,"n.a.",null,"n.a.",null,{"$f":"'6 Liquidität'!AB30+'6 Liquidität'!AB36","v":0},null,{"$f":"'6 Liquidität'!BD30+'6 Liquidität'!BD36","v":0},null,{"$f":"'6 Liquidität'!CF30+'6 Liquidität'!CF36","v":0}]
[null,null,"Liquiditätsgrad 2",{"$nulls":3},{"$f":"SUM('7 Bilanz'!C13:C14)/'7 Bilanz'!C43","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM('7 Bilanz'!G13:G14)/'7 Bilanz'!G43","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM('7 Bilanz'!K13:K14)/'7 Bilanz'!K43","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM('7 Bilanz'!O13:O14)/'7 Bilanz'!O43","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM('7 Bilanz'!S13:S14)/'7 Bilanz'!S43","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM('7 Bilanz'!W13:W14)/'7 Bilanz'!W43","v":{"$error":"#DIV/0!"}}]
[null,null,"Liquiditätsgrad 3",{"$nulls":3},{"$f":"'7 Bilanz'!C21/'7 Bilanz'!C43","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!G21/'7 Bilanz'!G43","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!K21/'7 Bilanz'!K43","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!O21/'7 Bilanz'!O43","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!S21/'7 Bilanz'!S43","v":{"$error":"#DIV/0!"}},null,{"$f":"'7 Bilanz'!W21/'7 Bilanz'!W43","v":{"$error":"#DIV/0!"}}]