{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Finanzplanung 2019","Finanzplanung 2020"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Finanzplanung 2019","index":0,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Rechtseinheit","Betrieb","Marke","Kostenstelle","Ebene21","Ebene22","Ebene23","Ebene24","Ebene25","Ebene26","Bookkeep Date","GuV1","GuV2","GuV3","GuV4","GuV5","GuV6","GuV7","GuV8","GuV9","GuV10","GuV11","GuV12"]
[1,"01",1,1,"GuV","1. Umsatzerlöse","a) Neuwagen",null,null,null,2019,-10708400,-10708400,-10708400,-10708400,-10708400,-10708400,-10708400,-10708400,-10708400,-10708400,-10708400,-10708400]
[1,"01",1,2,"GuV","1. Umsatzerlöse","b) Gebrauchtwagen",null,null,null,2019,-3958300,-3958300,-3958300,-3958300,-3958300,-3958300,-3958300,-3958300,-3958300,-3958300,-3958300,-3958300]
[1,"01",1,6,"GuV","1. Umsatzerlöse","c) Teile & Zubehör",null,null,null,2019,-750000,-750000,-750000,-750000,-750000,-750000,-750000,-750000,-750000,-750000,-750000,-750000]
[1,"01",1,3,"GuV","1. Umsatzerlöse","d) Service",null,null,null,2019,-583300,-583300,-583300,-583300,-583300,-583300,-583300,-583300,-583300,-583300,-583300,-583300]
[1,"01",1,7,"GuV","1. Umsatzerlöse","e) Mietwagen",null,null,null,2019,-291700,-291700,-291700,-291700,-291700,-291700,-291700,-291700,-291700,-291700,-291700,-291700]
[1,"01",1,8,"GuV","1. Umsatzerlöse","f) Tankstelle",null,null,null,2019,-400000,-400000,-400000,-400000,-400000,-400000,-400000,-400000,-400000,-400000,-400000,-400000]
[1,"01",1,9,"GuV","1. Umsatzerlöse","g) Waschstrasse",null,null,null,2019,-37500,-37500,-37500,-37500,-37500,-37500,-37500,-37500,-37500,-37500,-37500,-37500]
[1,"01",1,"1.1","GuV","1. Umsatzerlöse","h) Logistik",null,null,null,2019,-166700,-166700,-166700,-166700,-166700,-166700,-166700,-166700,-166700,-166700,-166700,-166700]
[1,"01",1,0,"GuV","2. Erhöhung oder Verminderung des Bestands an fertigen und unfertigen Erzeugnissen",{"$nulls":4},2019,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"01",1,0,"GuV","4. Sonstige betriebliche Erträge",{"$nulls":4},2019,-41650,-41650,-41650,-41650,-41650,-41650,-41650,-41650,-41650,-41650,-41650,-41650]
[1,"01",1,1,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","aa) Neuwagen",null,null,2019,10000000,10000000,10000000,10000000,10000000,10000000,10000000,10000000,10000000,10000000,10000000,10000000]
[1,"01",1,2,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ab) Gebrauchtwagen",null,null,2019,3716700,3716700,3716700,3716700,3716700,3716700,3716700,3716700,3716700,3716700,3716700,3716700]
[1,"01",1,6,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ac) Teile & Zubehör",null,null,2019,537000,537000,537000,537000,537000,537000,537000,537000,537000,537000,537000,537000]
[1,"01",1,3,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ad) Service",null,null,2019,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500]
[1,"01",1,7,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ae) Mietwagen",null,null,2019,1650,1650,1650,1650,1650,1650,1650,1650,1650,1650,1650,1650]
[1,"01",1,8,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","af) Tankstelle",null,null,2019,377050,377050,377050,377050,377050,377050,377050,377050,377050,377050,377050,377050]
[1,"01",1,9,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ag) Waschstrasse",null,null,2019,1250,1250,1250,1250,1250,1250,1250,1250,1250,1250,1250,1250]
[1,"01",1,"1.1","GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ah) Logistik",null,null,2019,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[1,"01",1,0,"GuV","6. Personalaufwand",{"$nulls":4},2019,958350,958350,958350,958350,958350,958350,958350,958350,958350,958350,958350,958350]
[1,"01",1,0,"GuV","7. Abschreibungen",{"$nulls":4},2019,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","a) Raumkosten",null,null,null,2019,133350,133350,133350,133350,133350,133350,133350,133350,133350,133350,133350,133350]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","b) Versicherungen / Beiträge",null,null,null,2019,83300,83300,83300,83300,83300,83300,83300,83300,83300,83300,83300,83300]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","c) KFZ-Kosten",null,null,null,2019,129150,129150,129150,129150,129150,129150,129150,129150,129150,129150,129150,129150]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","d) Werbekosten",null,null,null,2019,58350,58350,58350,58350,58350,58350,58350,58350,58350,58350,58350,58350]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","e) Kosten der Warenabgabe",null,null,null,2019,125000,125000,125000,125000,125000,125000,125000,125000,125000,125000,125000,125000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","f) Reparaturen/Instandhaltungen",null,null,null,2019,20850,20850,20850,20850,20850,20850,20850,20850,20850,20850,20850,20850]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","g) Sonstige",null,null,null,2019,162500,162500,162500,162500,162500,162500,162500,162500,162500,162500,162500,162500]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","h) Mieten bew. WG",null,null,null,2019,500,500,500,500,500,500,500,500,500,500,500,500]
[1,"01",1,0,"GuV","9. Zinsen und ähnliche Erträge",{"$nulls":4},2019,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500]
[1,"01",1,0,"GuV","10. Zinsen und ähnliche Aufwendungen",{"$nulls":4},2019,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[1,"01",1,0,"GuV","12. Außerordentliche Erträge",{"$nulls":4},2019,-50000,-50000,-50000,-50000,-50000,-50000,-50000,-50000,-50000,-50000,-50000,-50000]
[1,"01",1,0,"GuV","13. Außerordentliche Aufwendungen",{"$nulls":4},2019,43300,43300,43300,43300,43300,43300,43300,43300,43300,43300,43300,43300]
[1,"01",1,0,"GuV","14. Steuern vom Einkommen und vom Ertrag",{"$nulls":4},2019,59550,59550,59550,59550,59550,59550,59550,59550,59550,59550,59550,59550]
[1,"01",1,0,"GuV","15. sonstige Steuern",{"$nulls":4},2019,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]

{"sheet":"Finanzplanung 2020","index":1,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Rechtseinheit","Betrieb","Marke","Kostenstelle","Ebene21","Ebene22","Ebene23","Ebene24","Ebene25","Ebene26","Bookkeep Date","GuV1","GuV2","GuV3","GuV4","GuV5","GuV6","GuV7","GuV8","GuV9","GuV10","GuV11","GuV12"]
[1,"01",1,1,"GuV","1. Umsatzerlöse","a) Neuwagen",null,null,null,2020,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000]
[1,"01",1,2,"GuV","1. Umsatzerlöse","b) Gebrauchtwagen",null,null,null,2020,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000]
[1,"01",1,6,"GuV","1. Umsatzerlöse","c) Teile & Zubehör",null,null,null,2020,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000]
[1,"01",1,3,"GuV","1. Umsatzerlöse","d) Service",null,null,null,2020,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000]
[1,"01",1,7,"GuV","1. Umsatzerlöse","e) Mietwagen",null,null,null,2020,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000]
[1,"01",1,8,"GuV","1. Umsatzerlöse","f) Tankstelle",null,null,null,2020,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000]
[1,"01",1,9,"GuV","1. Umsatzerlöse","g) Waschstrasse",null,null,null,2020,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000]
[1,"01",1,"1.1","GuV","1. Umsatzerlöse","h) Logistik",null,null,null,2020,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000]
[1,"01",1,0,"GuV","2. Erhöhung oder Verminderung des Bestands an fertigen und unfertigen Erzeugnissen",{"$nulls":4},2020]
[1,"01",1,0,"GuV","4. Sonstige betriebliche Erträge",{"$nulls":4},2020,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000]
[1,"01",1,1,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","aa) Neuwagen",null,null,2020,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000]
[1,"01",1,2,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ab) Gebrauchtwagen",null,null,2020,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000]
[1,"01",1,6,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ac) Teile & Zubehör",null,null,2020,610000,610000,610000,610000,610000,610000,610000,610000,610000,610000,610000,610000]
[1,"01",1,3,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ad) Service",null,null,2020,32500,32500,32500,32500,32500,32500,32500,32500,32500,32500,32500,32500]
[1,"01",1,7,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ae) Mietwagen",null,null,2020,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750]
[1,"01",1,8,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","af) Tankstelle",null,null,2020,330000,330000,330000,330000,330000,330000,330000,330000,330000,330000,330000,330000]
[1,"01",1,9,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ag) Waschstrasse",null,null,2020,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100]
[1,"01",1,"1.1","GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ah) Logistik",null,null,2020,5500,5500,5500,5500,5500,5500,5500,5500,5500,5500,5500,5500]
[1,"01",1,0,"GuV","6. Personalaufwand",{"$nulls":4},2020,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000]
[1,"01",1,0,"GuV","7. Abschreibungen",{"$nulls":4},2020,420000,420000,420000,420000,420000,420000,420000,420000,420000,420000,420000,420000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","a) Raumkosten",null,null,null,2020,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","b) Versicherungen / Beiträge",null,null,null,2020,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","c) KFZ-Kosten",null,null,null,2020,160000,160000,160000,160000,160000,160000,160000,160000,160000,160000,160000,160000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","d) Werbekosten",null,null,null,2020,57500,57500,57500,57500,57500,57500,57500,57500,57500,57500,57500,57500]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","e) Kosten der Warenabgabe",null,null,null,2020,127500,127500,127500,127500,127500,127500,127500,127500,127500,127500,127500,127500]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","f) Reparaturen/Instandhaltungen",null,null,null,2020,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","g) Sonstige",null,null,null,2020,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","h) Mieten bew. WG",null,null,null,2020,62500,62500,62500,62500,62500,62500,62500,62500,62500,62500,62500,62500]
[1,"01",1,0,"GuV","9. Zinsen und ähnliche Erträge",{"$nulls":4},2020,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000]
[1,"01",1,0,"GuV","10. Zinsen und ähnliche Aufwendungen",{"$nulls":4},2020,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000]
[1,"01",1,0,"GuV","12. Außerordentliche Erträge",{"$nulls":4},2020,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000]
[1,"01",1,0,"GuV","13. Außerordentliche Aufwendungen",{"$nulls":4},2020,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000]
[1,"01",1,0,"GuV","14. Steuern vom Einkommen und vom Ertrag",{"$nulls":4},2020,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000]
[1,"01",1,0,"GuV","15. sonstige Steuern",{"$nulls":4},2020,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]