{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Aufgabenstellung","Daten","Berechnung und Ergebnisse"],"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,"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":"Aufgabenstellung","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Aufgabenstellung"]

{"sheet":"Daten","index":1,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["1. Vorgegebene Werte"]
["Jahr",2015,2016,2017,2018,2019,2020]
["STROMEINSPEISUNG MWh/a",{"$f":"B4/90","v":90400},{"$f":"C4/90","v":90400},90400,90400,90400,90400]
["Erlös Stromeinspeisung (90,00 €/MWh)",8136000,8136000,8136000,8136000,8136000,8136000]
[]
[]
["KOSTEN (€/a)"]
["Kapitalkosten"]
["Kalkulatorische Kosten für AV",1600000,{"$f":"B9","v":1600000},{"$f":"C9","v":1600000},1600000,1600000,1600000]
["Kalkulatorische Kosten für UV",170000,{"$f":"B10*1.01","v":171700},{"$f":"C10*1.01","v":173417},175151.17,176902.68170000002,178671.70851700002]
["Summe Kapitalkosten",{"$f":"SUM(B9:B10)","v":1770000},{"$f":"SUM(C9:C10)","v":1771700},1773417,1775151.17,1776902.6817000001,1778671.7085170001]
[]
["Verbrauchsgebundene Kosten"]
["Brennstoffkosten",2000000,{"$f":"B14*1.15","v":2300000},{"$f":"C14*1.15","v":2645000},3041749.9999999995,3498012.4999999991,4022714.3749999986]
["Stromversorgung",1000000,{"$f":"B15*1.01","v":1010000},1020100,1030301,1040604.01,1051010.0501000001]
["Ascheentsorgung",400000,{"$f":"B16*1.01","v":404000},408040,412120.4,416241.60400000005,420404.02004000003]
["Wasseraufbereitung",40000,{"$f":"B17*1.01","v":40400},40804,41212.04,41624.160400000001,42040.402004000003]
["Hilfs- und Betriebsstoffe",600000,{"$f":"B18*1.01","v":606000},612060,618180.6,624362.40599999996,630606.03006000002]
["Summe verbrauchsgeb. Kosten",{"$f":"SUM(B14:B18)","v":4040000},{"$f":"SUM(C14:C18)","v":4360400},4726004,5143564.0399999991,5620844.680399999,6166774.8772039982]
[]
["Betriebsgebundene Kosten"]
["Laufende Betriebsführung",1100000,{"$f":"B22*1.01","v":1111000},{"$f":"C22*1.01","v":1122110},1133331.1000000001,1144664.4110000001,1156111.0551100001]
["Wartung und Instandhaltung",800000,{"$f":"B23*1.01","v":808000},{"$f":"C23*1.01","v":816080},824240.8,832483.2080000001,840808.04008000006]
["Summe betriebsgeb. Kosten",{"$f":"SUM(B22:B23)","v":1900000},{"$f":"SUM(C22:C23)","v":1919000},1938190,1957571.9000000001,1977147.6190000002,1996919.0951900003]
[]
["Sonstige Kosten"]
["Versicherung",300000,{"$f":"B27*1.01","v":303000},{"$f":"C27*1.01","v":306030},309090.3,312181.20299999998,315303.01503000001]
["Summe sonstige Kosten",{"$f":"SUM(B27:B27)","v":300000},{"$f":"SUM(C27:C27)","v":303000},306030,309090.3,312181.20299999998,315303.01503000001]
[]
["Summe jährliche Gesamtkosten",{"$f":"B11+B19+B24+B28","v":8010000},{"$f":"C11+C19+C24+C28","v":8354100},8743641,9185377.4100000001,9687076.1841000002,10257668.695940999]
["Stromgestehungskosten €/MWh",{"$f":"B30/B3","v":88.606194690265482},{"$f":"C30/C3","v":92.412610619469021},96.721692477876104,101.60815719026549,107.15792239048673,113.46978645952433]
["Stromgestehungskosten €/kWh",{"$f":"B31/1000","v":8.8606194690265483E-2},{"$f":"C31/1000","v":9.2412610619469024E-2},9.6721692477876098E-2,0.10160815719026549,0.10715792239048673,0.11346978645952432]
[]
["kalkulatorischer Gewinn(+) bzw. Verlust(-)",{"$f":"B4-B30","v":126000},{"$f":"C4-C30","v":-218100},-607641,-1049377.4100000001,-1551076.1841000002,-2121668.6959409993]
[]
["2. Berechnete Werte"]
["laufender Cash-Flow",{"$f":"B34+B9+B10","v":1896000},1553600,1165776,725773.75999999989,225826.49759999983,-342996.98742399929]
["Liquidationserlös im Falle des Verkaufs der Anlage nach Rumänien",2000000,{"$f":"B38-200000","v":1800000},{"$f":"C38-200000","v":1600000},1400000,1200000,1000000]

{"sheet":"Berechnung und Ergebnisse","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Ermittlung der optimalen Nutzungsdauer",null,null,null,"Kalkulationszins"]
[null,"Cash Flow","Liquidationserlös","weitere Nutzung würde erbringen …",0.05]
[2015,{"$f":"TRANSPOSE(Daten!B37:G38)","v":1896000},2000000,{"$f":"IF(MAX(C3,(B4+D4)/(1+E$2))=C3,C3,(B4+D4)/(1+E$2))","v":4373335.544757586},{"$f":"IF(D3>C3,\"halten\",\"verkaufen\")","v":"halten"},"Kapitalwert der Weiternutzung im Jahr 2015"]
[2016,1553600,1800000,{"$f":"IF(MAX(C4,(B5+D5)/(1+E$2))=C4,C4,(B5+D5)/(1+E$2))","v":3038402.3219954646},"halten"]
[2017,1165776,1600000,2024546.4380952378,"halten","Kapitalwert der Weiternutzung im Jahr 2017"]
[2018,725773.75999999989,1400000,1400000,"verkaufen","Am Ende von 2018 verkaufen"]
[2019,225826.49759999983,1200000,{"$f":"IF(MAX(C7,(B8+D8)/(1+E$2))=C7,C7,(B8+D8)/(1+E$2))","v":1200000},{"$f":"IF(D7>C7,\"halten\",\"verkaufen\")","v":"verkaufen"}]
[2020,-342996.98742399929,1000000,{"$f":"C8","v":1000000},{"$f":"IF(D8>C8,\"halten\",\"verkaufen\")","v":"verkaufen"}]