{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LRPbankzeit.de","LQ01","LQ02","LQ03","RENTA"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":2,"defined_names":11,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LRPbankzeit.de","index":0,"n_rows":38,"n_cols":59,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,38,12,63],[14,45,14,62],[19,38,20,63],[21,38,27,63],[30,39,30,47],[28,58,29,62],[30,58,30,62],[19,3,39,35],[31,58,31,62],[14,38,14,44],[1,0,3,9],[15,0,37,0],[35,38,36,52],[16,40,16,44],[16,45,16,48],[37,38,37,61],[31,39,31,47],[28,48,29,52],[30,48,30,52],[31,48,31,52],[28,53,29,57],[30,53,30,57],[31,53,31,57]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voreinstellungen Allgemein"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firmenname  ",null,null,null,null,null,null,"Hans Muster GmbH"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Startjahr  ",null,null,null,null,2022]
[]
[]
[null,null,null,"Vielen Dank für die Nutzung dieses kleinen selbst \"gestrickten\" Excel-Tools zur Unterstützung bei der kombinierten Erstellung von Liquiditätsplan und Renta-bilitätsrechnung für 3 Jahre.  Die Handhabung sollte weitestgehend selbsterklärend sein. Auf Basis der monatlichen Liquiditätsplanung werden die jährlichen Rentabilitätspläne erstellt und um die zusätzlich unter \"Voreinstellungen\" gemachte Werte ergänzt. Oberhalb der Eingabeseiten befindet sich Schaltflächen mit Symbolen für Druck und Navigation innerhalb des Tools.\nAbflüsse/Kosten bitte mit entsprechendem Vorzeichen (-) eingeben !\nFelder mit Eingabe oder Wert \"0\" werden immer \"blank\" angezeigt.\n\nRESET löscht alle Eingabewerte und setzt Firmenname,  Startjahr und auf dieser Seite ergänzte AfA-Werte wieder auf die Voreinstellungen.\n\nTrotz jahrzehntelanger Erfahrung und größtmöglicher Sorgfalt, kann bei diesem kleinen kosten- und werbefreien Tool natürlich keinerlei Haftung für Vollständigkeit, Richtigkeit, Fehlerfreiheit und Aktualität übernommen werden. \n\nEs gibt weitere Excel-Tools für Liquiditätsplanung (LQP LiquiPlaner) und Rentabilitätsplanung (REP RentaPlaner).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ergänzungen für die Rentabilitätsrechnung"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Während es beim Liquiditätsplan darum geht die tatsächlichen Geldströme abzubilden und damit unter anderem die zum Geschäftsbetrieb benötigten Eigenmittel bzw. den Betriebsmittelbedarf zu ermitteln, gibt die Rentabilitätsplanung Auskunft über die Höhe des  Betriebsergebnis (Erlöse - Kosten). Unter Berücksichtigung von Abschreibungen wird der Gewinn vor Steuern ermitteln. Hieraus sind dann neben Steuern auch Tilgungen und - außer bei Kapitalgesellschaften - die privaten Ausgaben zu decken."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT17","v":2022},null,null,null,null,{"$f":"AW29+1","v":2023},null,null,null,null,{"$f":"AW29+2","v":2024}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschreibungen AfA  ",null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschreibungen GWG  ",null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 1.0"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: März 2021  | www.bankzeit.de | info@bankzeit.de"]

{"sheet":"LQ01","index":1,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,1,49,3],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,7,14],[6,8,7,8],[6,9,7,9],[6,10,7,10],[47,8,48,9],[1,1,1,3],[6,16,8,17],[42,16,43,16],[42,17,43,17],[3,11,5,16],[3,3,5,10],[6,15,7,15],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7]]}
[]
[null,"Hinweise",null,null,null,null,null,{"$f":"LRPbankzeit.de!AT17","v":2022},null,null,{"$f":"H2+1","v":2023},null,null,{"$f":"K2+1","v":2024}]
[]
[null,null,null,{"$f":"IF(LRPbankzeit.de!AT15=\"\",\"\",LRPbankzeit.de!AT15)","v":"Hans Muster GmbH"},null,null,null,null,null,null,null,{"$f":"\"Liquiditätsplanung \"&LRPbankzeit.de!AT17","v":"Liquiditätsplanung 2022"}]
[]
[]
[null,null,null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Jahressummen"]
[]
[null,null,"Liquidität [+/-]      Vortrag",null,null,{"$f":"E44","v":0},{"$f":"F44","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Umsatzerlöse I [netto]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E10:P10)","v":0},{"$f":"IF(Q10=0,\"\",Q10/(Q$17))","v":""}]
[null,null,null,"Umsatzerlöse II [netto]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:P11)","v":0},{"$f":"IF(Q11=0,\"\",Q11/(Q$17))","v":""}]
[null,null,null,"Erhaltene Anzahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Einlagen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Darlehensauszahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Zinserträge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"sonstige Eingänge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Summe Liquiditätszufluss",null,{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(E17:P17)=0,\"\",SUM(E17:P17))","v":""},{"$f":"IF(OR(Q17=0,Q17=\"\"),\"\",100%)","v":""}]
[null,null,"Verfügbare Mittel",null,{"$f":"E9+E17","v":0},{"$f":"F9+F17","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Waren- Materialeinkauf",null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Q19=0,\"\",Q19/(Q$17))","v":""}]
[null,null,null,"Löhne Gehälter [Mitarbeiter]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Sozialabgaben [Mitarbeiter]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"GF-Bezüge [GmbH UG]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"GF-Sozialabgaben [GmbH UG]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Miete/Raumkosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Energiekosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Kfz-Kosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Leasingkosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Marketing/Werbung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Reisekosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Büromaterial Kommunikation",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Beratung Buchführung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Reparatur Instandhaltung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Versicherungsbeiträge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"sonstige Kosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Zinsaufwand",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Tilgung für Darlehen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Investitionen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Privatentnahmen allgemein",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Privatentnahmen Steuern",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Steuern [betrieblich]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Sonstige Ausgänge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Summe Liquiditätsabfluss",null,{"$f":"SUM(E19:E41)","v":0},{"$f":"SUM(F19:F41)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(E42:P42)=0,\"\",SUM(E42:P42))","v":""},{"$f":"IF(OR(Q42=0,Q42=\"\"),\"\",Q42/(Q$17))","v":""}]
[null,null,"Monatsliquidität [ + | - ]",null,{"$f":"E17+E42","v":0},{"$f":"F17+F42","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(P44-E9=0,\"\",P44-E9)","v":""},{"$f":"IF(OR(Q43=0,Q43=\"\"),\"\",Q43/(Q$17))","v":""}]
[null,null,"Liquidität kumuliert [ + | - ]",null,{"$f":"E9+E43","v":0},{"$f":"F9+F43","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-03-03"}]
[]
[null,null,null,null,null,null,null,null,"Datum",null,null,"Unterschrift"]

{"sheet":"LQ02","index":2,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,16,43,16],[42,17,43,17],[45,1,49,3],[47,8,48,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,7,14],[6,15,7,15],[1,1,1,3],[3,3,5,10],[3,11,5,16],[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,16,8,17]]}
[]
[null,"Hinweise",null,null,null,null,null,{"$f":"LRPbankzeit.de!AT17","v":2022},null,null,{"$f":"H2+1","v":2023},null,null,{"$f":"K2+1","v":2024}]
[]
[null,null,null,{"$f":"IF(LRPbankzeit.de!AT15=\"\",\"\",LRPbankzeit.de!AT15)","v":"Hans Muster GmbH"},null,null,null,null,null,null,null,{"$f":"\"Liquiditätsplanung \"&LRPbankzeit.de!AT17+1","v":"Liquiditätsplanung 2023"}]
[]
[]
[null,null,null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Jahressummen"]
[]
[null,null,"Liquidität [+/-]      Vortrag",null,{"$f":"'LQ01'!P44","v":0},{"$f":"E44","v":0},{"$f":"F44","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Umsatzerlöse I [netto]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E10:P10)","v":0},{"$f":"IF(Q10=0,\"\",Q10/(Q$17))","v":""}]
[null,null,null,"Umsatzerlöse II [netto]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:P11)","v":0},{"$f":"IF(Q11=0,\"\",Q11/(Q$17))","v":""}]
[null,null,null,"Erhaltene Anzahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Einlagen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Darlehensauszahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Zinserträge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"sonstige Eingänge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Summe Liquiditätszufluss",null,{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(E17:P17)=0,\"\",SUM(E17:P17))","v":""},{"$f":"IF(OR(Q17=0,Q17=\"\"),\"\",100%)","v":""}]
[null,null,"Verfügbare Mittel",null,{"$f":"E9+E17","v":0},{"$f":"F9+F17","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Waren- Materialeinkauf",null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Q19=0,\"\",Q19/(Q$17))","v":""}]
[null,null,null,"Löhne Gehälter [Mitarbeiter]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Sozialabgaben [Mitarbeiter]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"GF-Bezüge [GmbH UG]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"GF-Sozialabgaben [GmbH UG]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Miete/Raumkosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Energiekosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Kfz-Kosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Leasingkosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Marketing/Werbung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Reisekosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Büromaterial Kommunikation",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Beratung Buchführung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Reparatur Instandhaltung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Versicherungsbeiträge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"sonstige Kosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Zinsaufwand",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Tilgung für Darlehen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Investitionen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Privatentnahmen allgemein",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Privatentnahmen Steuern",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Steuern [betrieblich]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Sonstige Ausgänge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Summe Liquiditätsabfluss",null,{"$f":"SUM(E19:E41)","v":0},{"$f":"SUM(F19:F41)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(E42:P42)=0,\"\",SUM(E42:P42))","v":""},{"$f":"IF(OR(Q42=0,Q42=\"\"),\"\",Q42/(Q$17))","v":""}]
[null,null,"Monatsliquidität [ + | - ]",null,{"$f":"E17+E42","v":0},{"$f":"F17+F42","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(P44-E9=0,\"\",P44-E9)","v":""},{"$f":"IF(OR(Q43=0,Q43=\"\"),\"\",Q43/(Q$17))","v":""}]
[null,null,"Liquidität kumuliert [ + | - ]",null,{"$f":"E9+E43","v":0},{"$f":"F9+F43","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF('LQ01'!I48=\"\",\"\",'LQ01'!I48)","v":"2021-03-03"}]
[]
[null,null,null,null,null,null,null,null,"Datum",null,null,"Unterschrift"]

{"sheet":"LQ03","index":3,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,16,43,16],[42,17,43,17],[45,1,49,3],[47,8,48,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,7,14],[6,15,7,15],[1,1,1,3],[3,3,5,10],[3,11,5,16],[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,16,8,17]]}
[]
[null,"Hinweise",null,null,null,null,null,{"$f":"LRPbankzeit.de!AT17","v":2022},null,null,{"$f":"H2+1","v":2023},null,null,{"$f":"K2+1","v":2024}]
[]
[null,null,null,{"$f":"IF(LRPbankzeit.de!AT15=\"\",\"\",LRPbankzeit.de!AT15)","v":"Hans Muster GmbH"},null,null,null,null,null,null,null,{"$f":"\"Liquiditätsplanung \"&LRPbankzeit.de!AT17+2","v":"Liquiditätsplanung 2024"}]
[]
[]
[null,null,null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Jahressummen"]
[]
[null,null,"Liquidität [+/-]      Vortrag",null,{"$f":"'LQ02'!P44","v":0},{"$f":"E44","v":0},{"$f":"F44","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Umsatzerlöse I [netto]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E10:P10)","v":0},{"$f":"IF(Q10=0,\"\",Q10/(Q$17))","v":""}]
[null,null,null,"Umsatzerlöse II [netto]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:P11)","v":0},{"$f":"IF(Q11=0,\"\",Q11/(Q$17))","v":""}]
[null,null,null,"Erhaltene Anzahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Einlagen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Darlehensauszahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Zinserträge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"sonstige Eingänge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Summe Liquiditätszufluss",null,{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(E17:P17)=0,\"\",SUM(E17:P17))","v":""},{"$f":"IF(OR(Q17=0,Q17=\"\"),\"\",100%)","v":""}]
[null,null,"Verfügbare Mittel",null,{"$f":"E9+E17","v":0},{"$f":"F9+F17","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Waren- Materialeinkauf",null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Q19=0,\"\",Q19/(Q$17))","v":""}]
[null,null,null,"Löhne Gehälter [Mitarbeiter]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Sozialabgaben [Mitarbeiter]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"GF-Bezüge [GmbH UG]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"GF-Sozialabgaben [GmbH UG]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Miete/Raumkosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Energiekosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Kfz-Kosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Leasingkosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Marketing/Werbung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Reisekosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Büromaterial Kommunikation",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Beratung Buchführung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Reparatur Instandhaltung",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Versicherungsbeiträge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"sonstige Kosten",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Zinsaufwand",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Tilgung für Darlehen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Investitionen",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Privatentnahmen allgemein",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Privatentnahmen Steuern",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Steuern [betrieblich]",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,"Sonstige Ausgänge",null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Summe Liquiditätsabfluss",null,{"$f":"SUM(E19:E41)","v":0},{"$f":"SUM(F19:F41)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(E42:P42)=0,\"\",SUM(E42:P42))","v":""},{"$f":"IF(OR(Q42=0,Q42=\"\"),\"\",Q42/(Q$17))","v":""}]
[null,null,"Monatsliquidität [ + | - ]",null,{"$f":"E17+E42","v":0},{"$f":"F17+F42","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(P44-E9=0,\"\",P44-E9)","v":""},{"$f":"IF(OR(Q43=0,Q43=\"\"),\"\",Q43/(Q$17))","v":""}]
[null,null,"Liquidität kumuliert [ + | - ]",null,{"$f":"E9+E43","v":0},{"$f":"F9+F43","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF('LQ01'!I48=\"\",\"\",'LQ01'!I48)","v":"2021-03-03"}]
[]
[null,null,null,null,null,null,null,null,"Datum",null,null,"Unterschrift"]

{"sheet":"RENTA","index":4,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[49,1,53,2],[53,3,54,3],[9,9,10,11],[11,9,12,9],[11,10,12,10],[11,11,12,11],[9,1,12,3],[9,4,10,5],[11,4,12,4],[11,5,12,5],[9,6,10,8],[11,6,12,6],[11,7,12,7],[11,8,12,8],[45,2,45,3],[2,1,5,11],[37,2,37,3],[20,2,20,3],[41,2,41,3],[6,1,8,11]]}
[]
[]
[null,{"$f":"IF(LRPbankzeit.de!AT15=\"\",\"\",LRPbankzeit.de!AT15)","v":"Hans Muster GmbH"}]
[]
[]
[]
[null,{"$f":"\"Rentabilitätsplanung \"&E10&\" bis \"&J10","v":"Rentabilitätsplanung 2022 bis 2024"}]
[]
[]
[null,null,null,null,{"$f":"LRPbankzeit.de!AW29","v":2022},null,{"$f":"LRPbankzeit.de!BB29","v":2023},null,null,{"$f":"LRPbankzeit.de!BG29","v":2024}]
[]
[null,null,null,null,"in €","in % vom\nUmsatz","in €","in % vom\nUmsatz","in % ggü.\nVorjahr","in €","in % vom\nUmsatz","in % ggü.\nVorjahr"]
[]
[null,null,null,"Umsatzerlöse I [netto]",{"$f":"'LQ01'!Q10+'LQ01'!Q12","v":0},{"$f":"IF(OR(E14=0,$E$16=0),0,E14/$E$16)","v":0},{"$f":"'LQ02'!Q10+'LQ02'!Q12","v":0},{"$f":"IF(OR(G14=0,$G$16=0),0,G14/$G$16)","v":0},{"$f":"IF(OR(E14=0,G14=0),\"\",(G14-E14)/E14)","v":""},{"$f":"'LQ03'!Q10+'LQ03'!Q12","v":0},{"$f":"IF(OR(J14=0,$J$16=0),0,J14/$J$16)","v":0},{"$f":"IF(OR(G14=0,J14=0),\"\",(J14-G14)/G14)","v":""}]
[null,null,null,"Umsatzerlöse II [netto]",{"$f":"'LQ01'!Q11","v":0},{"$f":"IF(OR(E15=0,$E$16=0),0,E15/$E$16)","v":0},{"$f":"'LQ02'!Q11","v":0},{"$f":"IF(OR(G15=0,$G$16=0),0,G15/$G$16)","v":0},{"$f":"IF(OR(E15=0,G15=0),\"\",(G15-E15)/E15)","v":""},{"$f":"'LQ03'!Q11","v":0},{"$f":"IF(OR(J15=0,$J$16=0),0,J15/$J$16)","v":0},{"$f":"IF(OR(G15=0,J15=0),\"\",(J15-G15)/G15)","v":""}]
[null,null,"    Gesamtumsatz",null,{"$f":"SUM(E14:E15)","v":0},0,{"$f":"SUM(G14:G15)","v":0},0,"",{"$f":"SUM(J14:J15)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Waren- Materialeinkauf",{"$f":"'LQ01'!Q19","v":0},0,{"$f":"'LQ02'!Q19","v":0},0,"",{"$f":"'LQ03'!Q19","v":0},0,""]
[null,null,"    Gesamtumsatz","Vorleistungen",{"$f":"SUM(E17:E18)","v":0},0,{"$f":"SUM(G17:G18)","v":0},0,"",{"$f":"SUM(J17:J18)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,"Rohgewinn / Rohertrag",null,{"$f":"E16+E19","v":0},0,{"$f":"G16+G19","v":0},0,"",{"$f":"J16+J19","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Personalkosten Mitarbeiter",{"$f":"'LQ01'!Q20+'LQ01'!Q21","v":0},0,{"$f":"'LQ02'!Q20+'LQ02'!Q21","v":0},0,"",{"$f":"'LQ03'!Q20+'LQ03'!Q21","v":0},0,""]
[null,null,null,"GF-Bezüge [GmbH UG]",{"$f":"'LQ01'!Q22+'LQ01'!Q23","v":0},0,{"$f":"'LQ02'!Q22+'LQ02'!Q23","v":0},0,"",{"$f":"'LQ03'!Q22+'LQ03'!Q23","v":0},0,""]
[null,null,null,"Raumkosten inkl. Nebenkosten",{"$f":"'LQ01'!Q24+'LQ01'!Q25","v":0},0,{"$f":"'LQ02'!Q24+'LQ02'!Q25","v":0},0,"",{"$f":"'LQ03'!Q24+'LQ03'!Q25","v":0},0,""]
[null,null,null,"Kfz-Kosten",{"$f":"'LQ01'!Q26","v":0},0,{"$f":"'LQ02'!Q26","v":0},0,"",{"$f":"'LQ03'!Q26","v":0},0,""]
[null,null,null,"Leasingkosten",{"$f":"'LQ01'!Q27","v":0},0,{"$f":"'LQ02'!Q27","v":0},0,"",{"$f":"'LQ03'!Q27","v":0},0,""]
[null,null,null,"Marketing/Werbung",{"$f":"'LQ01'!Q28","v":0},0,{"$f":"'LQ02'!Q28","v":0},0,"",{"$f":"'LQ03'!Q28","v":0},0,""]
[null,null,null,"Reisekosten",{"$f":"'LQ01'!Q29","v":0},0,{"$f":"'LQ02'!Q29","v":0},0,"",{"$f":"'LQ03'!Q29","v":0},0,""]
[null,null,null,"Büromaterial Kommunikation",{"$f":"'LQ01'!Q30","v":0},0,{"$f":"'LQ02'!Q30","v":0},0,"",{"$f":"'LQ03'!Q30","v":0},0,""]
[null,null,null,"Beratung Buchführung",{"$f":"'LQ01'!Q31","v":0},0,{"$f":"'LQ02'!Q31","v":0},0,"",{"$f":"'LQ03'!Q31","v":0},0,""]
[null,null,null,"Reparatur Instandhaltung",{"$f":"'LQ01'!Q32","v":0},0,{"$f":"'LQ02'!Q32","v":0},0,"",{"$f":"'LQ03'!Q32","v":0},0,""]
[null,null,null,"Versicherungsbeiträge",{"$f":"'LQ01'!Q33","v":0},0,{"$f":"'LQ02'!Q33","v":0},0,"",{"$f":"'LQ03'!Q33","v":0},0,""]
[null,null,null,"Zinsaufwand",{"$f":"'LQ01'!Q35","v":0},0,{"$f":"'LQ02'!Q35","v":0},0,"",{"$f":"'LQ03'!Q35","v":0},0,""]
[null,null,null,"sonstige Kosten und Abgaben",{"$f":"'LQ01'!Q34","v":0},0,{"$f":"'LQ02'!Q34","v":0},0,"",{"$f":"'LQ03'!Q34","v":0},0,""]
[null,null,null,"Kosten / Aufwendungen",{"$f":"SUM(E22:E35)","v":0},0,{"$f":"SUM(G22:G35)","v":0},0,"",{"$f":"SUM(J22:J35)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,"Betriebsergebnis (Cash Flow)",null,{"$f":"E21+E36","v":0},0,{"$f":"G21+G36","v":0},0,"",{"$f":"J21+J36","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Abschreibungen AfA",{"$f":"-LRPbankzeit.de!AW31","v":0},0,{"$f":"-LRPbankzeit.de!BB31","v":0},0,"",{"$f":"-LRPbankzeit.de!BG31","v":0},0,""]
[null,null,null,"Abschreibungen GWG",{"$f":"-LRPbankzeit.de!AW32","v":0},0,{"$f":"-LRPbankzeit.de!BB32","v":0},0,"",{"$f":"-LRPbankzeit.de!BG32","v":0},0,""]
[null,null,"Gewinn / Verlust vor Steuern",null,{"$f":"SUM(E38:E41)","v":0},0,{"$f":"SUM(G38:G41)","v":0},0,"",{"$f":"SUM(J38:J41)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Tilgung",{"$f":"'LQ01'!Q36","v":0},0,{"$f":"'LQ02'!Q36","v":0},0,"",{"$f":"'LQ03'!Q36","v":0},0,""]
[null,null,null,"Steuern",{"$f":"'LQ01'!Q40+'LQ01'!Q39","v":0},0,{"$f":"'LQ02'!Q40+'LQ02'!Q39","v":0},0,"",{"$f":"'LQ03'!Q40+'LQ03'!Q39","v":0},0,""]
[null,null,"Ergebnis nach Steuern und Tilgung",null,{"$f":"SUM(E42:E45)","v":0},0,{"$f":"SUM(G42:G45)","v":0},0,"",{"$f":"SUM(J42:J45)","v":0},0,""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF('LQ01'!I48=\"\",\"\",'LQ01'!I48)","v":"2021-03-03"}]
[]
[null,null,null,"Datum","Unterschrift"]