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

{"sheet":"REPbankzeit.de","index":0,"n_rows":40,"n_cols":47,"rows_kept":40,"cut":false,"hidden":false,"merged":[[18,3,39,35],[1,0,3,9],[10,39,11,61],[13,39,13,45],[13,46,13,60],[15,0,39,0],[15,41,15,45],[15,46,15,49],[37,39,38,53],[39,39,39,64]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Voreinstellungen"]
[]
[]
[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,"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,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 Erstellung einer Rentabilitätsplanung für 3 Jahre.\nDie Handhabung sollte weitestgehend selbsterklärend sein. \nOberhalb der Eingabeseiten befindet sich Schaltflächen mit Symbolen für einfaches Drucken und die Navigation innerhalb des Tools.\n\nAbflüsse/Kosten bitte mit entsprechendem Vorzeichen (-) eingeben !\n\nFelder mit Eingabe oder Wert \"0\" werden immer \"blank\" angezeigt.\n\nRESET löscht alle Eingabewerte und setzt Firmenname und Startjahr 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 eine kombinierte Liquiditäts-und Rentabilitätsplanung (LRP LiquiRentaPlaner)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Version 1.01"]
[]
[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,"Stand: Dezember 2021  | www.bankzeit.de | info@bankzeit.de"]

{"sheet":"RENTA","index":1,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[19,2,19,3],[36,2,36,3],[40,2,40,3],[44,2,44,3],[48,1,52,2],[52,3,53,3],[1,1,4,11],[5,1,7,11],[8,1,11,3],[8,4,9,5],[8,6,9,8],[8,9,9,11],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,8,11,8]]}
[]
[null,{"$f":"IF('REPbankzeit.de'!AU14=\"\",\"Musterrechnung\",'REPbankzeit.de'!AU14)","v":"Hans Muster GmbH"}]
[]
[]
[]
[null,{"$f":"\"Rentabilitätsplanung \"&E9&\" bis \"&J9","v":"Rentabilitätsplanung 2022 bis 2024"}]
[]
[]
[null,null,null,null,{"$f":"IF('REPbankzeit.de'!AU16=\"\",2022,'REPbankzeit.de'!AU16)","v":2022},null,{"$f":"E9+1","v":2023},null,null,{"$f":"E9+2","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]",null,{"$f":"IF(OR(E13=0,$E$15=0),0,E13/$E$15)","v":0},null,{"$f":"IF(OR(G13=0,$G$15=0),0,G13/$G$15)","v":0},{"$f":"IF(OR(E13=0,G13=0),\"\",(G13-E13)/E13)","v":""},null,{"$f":"IF(OR(J13=0,$J$15=0),0,J13/$J$15)","v":0},{"$f":"IF(OR(G13=0,J13=0),\"\",(J13-G13)/G13)","v":""}]
[null,null,null,"Umsatzerlöse II [netto]",null,{"$f":"IF(OR(E14=0,$E$15=0),0,E14/$E$15)","v":0},null,{"$f":"IF(OR(G14=0,$G$15=0),0,G14/$G$15)","v":0},{"$f":"IF(OR(E14=0,G14=0),\"\",(G14-E14)/E14)","v":""},null,{"$f":"IF(OR(J14=0,$J$15=0),0,J14/$J$15)","v":0},{"$f":"IF(OR(G14=0,J14=0),\"\",(J14-G14)/G14)","v":""}]
[null,null,"    Gesamtumsatz",null,{"$f":"SUM(E13:E14)","v":0},0,{"$f":"SUM(G13:G14)","v":0},0,"",{"$f":"SUM(J13:J14)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Waren- Materialeinkauf",null,0,null,0,"",null,0,""]
[null,null,"    Gesamtumsatz","Vorleistungen",{"$f":"SUM(E16:E17)","v":0},0,{"$f":"SUM(G16:G17)","v":0},0,"",{"$f":"SUM(J16:J17)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,"Rohgewinn / Rohertrag",null,{"$f":"E15+E18","v":0},0,{"$f":"G15+G18","v":0},0,"",{"$f":"J15+J18","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Personalkosten Mitarbeiter",null,0,null,0,"",null,0,""]
[null,null,null,"GF-Bezüge [GmbH UG]",null,0,null,0,"",null,0,""]
[null,null,null,"Raumkosten inkl. Nebenkosten",null,0,null,0,"",null,0,""]
[null,null,null,"Kfz-Kosten",null,0,null,0,"",null,0,""]
[null,null,null,"Leasingkosten",null,0,null,0,"",null,0,""]
[null,null,null,"Marketing/Werbung",null,0,null,0,"",null,0,""]
[null,null,null,"Reisekosten",null,0,null,0,"",null,0,""]
[null,null,null,"Büromaterial Kommunikation",null,0,null,0,"",null,0,""]
[null,null,null,"Beratung Buchführung",null,0,null,0,"",null,0,""]
[null,null,null,"Reparatur Instandhaltung",null,0,null,0,"",null,0,""]
[null,null,null,"Versicherungsbeiträge",null,0,null,0,"",null,0,""]
[null,null,null,"Zinsaufwand",null,0,null,0,"",null,0,""]
[null,null,null,"sonstige Kosten und Abgaben",null,0,null,0,"",null,0,""]
[null,null,null,"Kosten / Aufwendungen",{"$f":"SUM(E21:E34)","v":0},0,{"$f":"SUM(G21:G34)","v":0},0,"",{"$f":"SUM(J21:J34)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,"Betriebsergebnis (Cash Flow)",null,{"$f":"E20+E35","v":0},0,{"$f":"G20+G35","v":0},0,"",{"$f":"J20+J35","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Abschreibungen AfA",null,0,null,0,"",null,0,""]
[null,null,null,"Abschreibungen GWG",null,0,null,0,"",null,0,""]
[null,null,"Gewinn / Verlust vor Steuern",null,{"$f":"SUM(E37:E40)","v":0},0,{"$f":"SUM(G37:G40)","v":0},0,"",{"$f":"SUM(J37:J40)","v":0},0,""]
[null,null,null,null,null,0,null,0,"",null,0,""]
[null,null,null,"Tilgung",null,0,null,0,"",null,0,""]
[null,null,null,"Steuern",null,0,null,0,"",null,0,""]
[null,null,"Ergebnis nach Steuern und Tilgung",null,{"$f":"SUM(E41:E44)","v":0},0,{"$f":"SUM(G41:G44)","v":0},0,"",{"$f":"SUM(J41:J44)","v":0},0,""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"TODAY()","v":"2021-12-28"}]
[]
[null,null,null,"Datum","Unterschrift"]