{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Tabelle1","index":0,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[11,0,12,2],[15,0,15,4],[17,0,18,6],[1,0,2,6],[5,0,5,6],[7,0,7,2],[9,0,9,2],[7,3,7,6],[9,3,9,6],[57,1,57,2],[58,1,58,2],[60,1,60,2],[22,0,22,2],[20,0,20,2],[29,0,29,2],[41,1,41,2],[31,1,31,2],[51,1,51,2],[56,1,56,2],[26,0,27,6],[54,0,54,6],[24,0,24,4]]}
[]
["Ermittlung Liquiditätshilfe"]
[]
[]
[]
["Allgemeine Angaben"]
[]
["Name des Unternehmens:"]
[]
["Branche:"]
[]
["Anzahl der Monate, für welche sich das Unternehmen voraussichtlich in der Krise befindet"]
[{"$nulls":4},3.5,"Monate"]
[]
[]
["Einnahmen",{"$nulls":4},"Ansatz"]
[]
["Einnahmen sind nur anzusetzen, sofern diese zahlungswirksam sind. Nicht hierunter fallen z. B. Erträge aus der Auflösung von Rückstellungen etc."]
[]
[]
["Einnahmen des Jahres 2019",null,null,null,1000000]
[]
["Einnahmen für das Jahr 2020 (geschätzt)",null,null,{"$f":"100/E21*(E21-F23)/100","v":0.5},null,500000]
[]
["Kosten",{"$nulls":4},"Ansatz"]
[]
["Kosten sind nur anzusetzen, sofern diese zahlungswirksam sind. Nicht hierunter fallen z. B. Abschreibungen, Bildung von Rückstellungen etc."]
[]
[]
["Gesamtkosten des Jahres 2019",null,null,null,700000]
[]
[null,"davon fixe Kosten (ohne Lohnkosten)",null,null,{"$f":"SUM(D34:D40)","v":270000},{"$f":"+E32","v":270000}]
[]
[null,null,"Miete",270000]
[null,null,"Zinsen",0]
[null,null,"Grundgebühren Strom, Telefon, Internet",0]
[null,null,"Investitionskosten",0]
[null,null,null,0]
[null,null,null,0]
[null,null,"Sonstige",0]
[]
[null,"davon variable Kosten (ohne Lohnkosten)",null,null,{"$f":"SUM(D44:D50)","v":30000},{"$f":"+E42*D23","v":15000}]
[]
[null,null,"Materialkosten",0]
[null,null,"Instandhaltungen, Reparaturen",30000]
[null,null,"Verbrauch an Strom, Wasser",0]
[null,null,"Telefon, Internet etc. ",0]
[null,null,"Reisekosten",0]
[null,null,null,0]
[null,null,"Sonstige",0]
[]
[null,"davon Lohnkosten",null,null,400000,{"$f":"+E52-E53","v":325000}]
[null,null,"abzgl. Kurzarbeitergeld",null,75000]
[]
["Ermittlung der Liquiditätshilfe"]
[]
[null,"Einnahmen",null,null,{"$f":"+F23","v":500000}]
["-","Ansatz Kosten",null,null,{"$f":"+F52+F42+F32","v":610000}]
["=","Liquiditätsbedarf",null,null,{"$f":"+E57-E58","v":-110000}]
[]
["Ü","Liquiditätshilfe",null,null,{"$f":"(E59/12*E13)*-1","v":32083.333333333332}]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}