{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Finanzplanung für Freiberufler","Tabelle2","Tabelle3"],"not_rendered":{"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Finanzplanung für Freiberufler","index":0,"n_rows":39,"n_cols":15,"rows_kept":39,"merged":[[5,3,5,14],[6,0,7,0],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,7,14],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[33,0,33,4],[33,8,33,9],[33,10,33,13],[34,0,34,4],[34,10,34,13]],"flags":["formulas_cached_only"]}
[]
[]
["Finanzplanung für Freiberufler"]
["- Einzahlungen/Auszahlungen in TEUR -"]
[]
["Name:",null,null,"Planungszeitraum"]
["Jahr:",null,"Monat:"]
[]
["I. Geldeingänge insgesamt, davon aus",null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["- ausstehenden Forderungen"]
["- geplanten Leistungen"]
["- Mieten"]
["- Anzahlungen"]
["- Privateinlagen"]
["- sonstigen Einzahlungen"]
["./. II. Geldausgänge insgesamt; davon aus",null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["- bestehenden Verbindlichkeiten"]
["- geplanten Einkäufen"]
["- Personal"]
["- Kapitaldienst"]
["- Investitionen"]
["- Privatentnahmen"]
["- sonstigen Auszahlungen"]
["= III. Liquiditätsbedarf/-überschuß pro Planungsperiode",null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["+ IV. Übertrag Ziffer V. der Vorperiode1",{"$nulls":3},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["= V. Liquiditätsbedarf/-überschuß kumuliert",null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["+ VI. Kreditlinien auf Geschäftsgirokonten"]
["= VII. Liquiditätsbedarf/-überschuß inkl. Kreditlinien",null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Nachrichtlich: Bankguthaben2"]
[]
["Erläuterungen zu den einzelnen Positionen sind aus der beigefügten Anlage ersichtlich."]
[]
[]
[{"$nulls":8},"Erstellt/Geprüft:"]
[" (Ort, Datum)                                                                (Unterschrift)",{"$nulls":9},"(Steuerberater/Wirtschaftsprüfer)"]
[]
["1 In der ersten Planungsperiode ist hier der Saldo aller Geschäftsgirokonten zu erfassen."]
["2 Z.B. Guthaben auf Tagesgeld- oder Festgeldkonten, die als Liquiditätsreserven zur Verfügung stehen und zum Ausgleich eines Liquiditätsbedarfs eingesetzt werden können. Nicht einzuberechnen sind Guthaben auf Geschäftsgirokonten,"]
["   die bereits unter Ziffer IV. erfaßt sind."]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}