{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":4,"macros":1,"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":"Tabelle1","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,4,36,4],[37,4,38,4],[39,4,40,4],[41,4,42,4],[43,4,44,4],[33,7,34,8],[35,7,36,8],[37,7,38,8],[39,7,40,8],[41,10,42,10],[43,11,44,11],[45,10,46,10],[45,11,46,11],[33,10,34,10],[35,10,36,10],[35,11,36,11],[37,10,38,10],[37,11,38,11],[39,10,40,10],[41,11,42,11],[39,11,40,11],[33,11,34,11],[37,1,38,1],[37,2,38,2],[39,1,40,1],[39,2,40,2],[43,10,44,10],[37,6,38,6],[39,6,40,6],[33,6,34,6],[35,6,36,6],[43,1,44,1],[43,2,44,2],[33,3,34,3],[35,3,36,3],[37,3,38,3],[39,3,40,3],[35,1,36,1],[35,2,36,2],[43,3,44,3],[33,1,34,1],[33,2,34,2],[41,2,42,2],[41,3,42,3],[41,1,42,1],[4,13,6,13],[9,13,11,13],[9,7,10,7],[24,6,31,9],[30,1,31,1],[30,2,31,2],[30,3,31,4],[20,6,20,7],[21,6,21,7],[23,3,25,4],[23,1,25,2],[28,1,29,1],[28,2,29,2],[20,11,22,11],[15,10,16,10],[20,10,22,10],[27,3,28,3],[27,4,28,4],[1,1,1,11],[13,10,14,10],[16,7,17,7],[17,10,18,10],[15,11,16,11],[13,11,14,11],[17,11,18,11]]}
[]
[null,"Ordentliche Kapitalerhöhung"]
[]
[null,"Aktiva","Bilanz vor der Kapitalerhöhung",null,"Passiva",null,"Emmissionsdatum","2018-07-12",null,null,"Dividende vor der Kapitalerhöhung"]
[null,"Anlagevermögen",2740000000,"   gezeichnetes Kapital",1500000000,null,"Dividendendatum","2018-12-31",null,null,"Dividende in %",0.09,null,"alternative Angaben"]
[null,"   Vorräte",900000000,"   Kapitalrücklagen",2000000000,null,"Kapitalerhöhung",300000000,null,null,"Gesamtdividende",{"$f":"E5*L5","v":135000000}]
[null,"   Forderungen",null,"   Gewinnrücklagen",null,null,"Aktiennennwert",1,null,null,"Gesamtdividende"]
[null,"   liquide Mittel",880000000,"Eigenkapital",{"$f":"SUM(E5:E7)","v":3500000000},null,"Kurs alter Aktien",3.5,null,null,"Dividende in %",{"$f":"IF(L7>0,L7/E5,\"\")","v":""}]
[null,"Umlaufvermögen",{"$f":"SUM(C6:C8)","v":1780000000},"Rückstellungen",0,null,"Emmissionskurs",2,null,null,"Dividende nach der Kapitalerhöhung"]
[null,null,null,"Verbindlichkeiten",1020000000,null,"Ausschluss von",0,null,null,"Dividende in %",0.09,null,"alternative Angaben"]
[null,null,{"$f":"C5+C9","v":4520000000},null,{"$f":"E8+E9+E10","v":4520000000},null,"Bezugsrechten in %",null,null,null,"Gesamtdividende",2700000]
[null,"Bilanzkurs in €",{"$f":"E8/H14","v":2.3333333333333335},"Bilanzkurs in %",{"$f":"E8/E5","v":2.3333333333333335},null,"Zuzahlungen je Aktie",0,null,null,"Gesamtdividende"]
[null,null,null,null,null,null,null,null,null,null,"Dividende in %",{"$f":"IF(L12>0,L12/E15,\"\")","v":""}]
[null,"Aktiva","Bilanz nach der Kapitalerhöhung",null,"Passiva",null,"Anzahl Altaktien",{"$f":"E5/H7","v":1500000000},null,null,"Jahresdividende                          je Altaktie",{"$f":"IF(L10>0,L10*H7,L13*H7)","v":0.09}]
[null,"Anlagevermögen",{"$f":"C5","v":2740000000},"   gezeichnetes Kapital",{"$f":"E5+H6","v":1800000000},null,"Bezugsverhältnis",{"$f":"E5/(H6-(H6*H10))","v":5},":1"]
[null,"   Vorräte",{"$f":"C6","v":900000000},"   Kapitalrücklagen",{"$f":"E6+((H19*H9)-H6)","v":2300000000},null,"Mittelkurs",{"$f":"H8-H17","v":3.25},null,null,"Dividendentage für die Jungaktien",{"$f":"DAYS360(H4,H5)","v":169}]
[null,"   Forderungen",{"$f":"C7","v":0},"   Gewinnrücklagen",{"$f":"E7","v":0},null,"rechnerischer Wert",{"$f":"(H8-H9)/(H15+1)","v":0.25}]
[null,"   liquide Mittel",{"$f":"(H19*H9)+C8","v":1480000000},"Eigenkapital",{"$f":"SUM(E15:E17)","v":4100000000},null,"eines Bezugsrechtes",null,null,null,"Jahresdividende                          je Jungaktie",{"$f":"IF(L10>0,H7*L10*L16/360,H7*L13*L16/360)","v":4.2249999999999996E-2}]
[null,"Umlaufvermögen",{"$f":"SUM(C16:C18)","v":2380000000},"Rückstellungen",{"$f":"E9","v":0},null,"Anzahl der Jungaktien",{"$f":"H6/H7","v":300000000}]
[null,null,null,"Verbindlichkeiten",{"$f":"E10","v":1020000000},null,null,null,null,null,"Dividendennachteil",{"$f":"L14-L18","v":4.7750000000000001E-2}]
[null,null,{"$f":"C15+C19","v":5120000000},null,{"$f":"E18+E19+E20","v":5120000000},null,"Eingabewerte",null,null,null,"rechnerischer Wert des Bezugsrechtes mit Dividendennachteil",{"$f":"(H8-(H9+L20))/(H15+1)","v":0.24204166666666663}]
[null,"Bilanzkurs in €",{"$f":"E18/(H14+H19)","v":2.2777777777777777},"Bilanzkurs in %",{"$f":"E18/E15","v":2.2777777777777777},null,"berechnete Werte"]
[]
[null,"Kauf bzw. Verkauf von Bezugsrechten         bei einer bestimmten Nachfrage nach Jungaktien",null,"Wie viele Jungaktien kann ein Aktionär aufgrund bestehender Bezugsrechte erwerben?"]
[null,null,null,null,null,null,"Geben Sie jeweils die Ausgangsdaten über die Menus ein. Entnehmen Sie die Ausgabewerte der Tabelle.                           (Die Bilanzen werden immer nach der Gewinnverwendung dargestellt)"]
[]
[null,"Anzahl Altaktien",250,"Anzahl Altaktien",{"$f":"C27","v":250}]
[null,"Nachfrage Jungaktien",100,"Jungaktien ohne Kauf von Bezugsrechten",{"$f":"ROUNDDOWN(E27/H15,0)","v":50}]
[null,"benötigte Bezugsrechte",{"$f":"ROUNDUP(H15*C28,0)","v":500}]
[]
[null,"Differenz in Bezugsrechten",{"$f":"C27-C29","v":-250},{"$f":"IF(C31<0,\"Bezugsrechtskauf notwendig\",IF(C31>0,\"Verkauf von Bezugsrechten\",\"\"))","v":"Bezugsrechtskauf notwendig"}]
[]
[]
[null,"Bankabrechnung Aktienkauf","Aktienanzahl","Abrechnung in €",null,null,"Dividenden- abrechnung","Jahresdividende in €",null,null,"Vermögenwert des Aktionärs  (ohne Dividende)","Werte in €"]
[]
[null,"Aktien ohne Zukauf von Bezugsrechten",{"$f":"IF(C31>=0,C28,E28)","v":50},{"$f":"H9*C36","v":100},"Kurswert",null,"Dividende für Altaktien",{"$f":"C27*L14","v":22.5},null,null,"vor der Kapitalerhöhung",{"$f":"C27*H8","v":875}]
[]
[null,"Aktien mit Zukauf von Bezugsrechten",{"$f":"IF(C31>=0,0,(C28-E28))","v":50},{"$f":"IF(C31>=0,0,(H9*C38)+((C31*-1)*L21))","v":160.51041666666666},"Kurswert + Wert der Bezugsrechte",null,"Dividende für Jungaktien",{"$f":"C28*L18","v":4.2249999999999996},null,null,"Kurswert nach der Kapitalerhöhung",{"$f":"(C27+C28)*H16","v":1137.5}]
[]
[null,"Zuzahlung",null,{"$f":"C28*H12","v":0},"Gesamtzuzahlung",null,"Gesamtdividende",{"$f":"H36+H38","v":26.725000000000001},null,null,"Wert der Jungaktien",{"$f":"C28*H9","v":200}]
[]
[null,"Bezugsrechts- auszahlung",{"$f":"IF(C31>=0,C31,0)","v":0},{"$f":"C42*H17","v":0},"bei Bezugsrechts- verkauf",null,null,null,null,null,"Bezugsrechtskauf",{"$f":"IF(C31>=0,0,(C31*-1)*H17)","v":62.5}]
[]
[null,"Gesamtbetrag",{"$f":"C28","v":100},{"$f":"D36+D38+D40-D42","v":260.51041666666663},"bei Bezugsrechts- verkauf",null,null,null,null,null,"Bezugsrechts- auszahlung",{"$f":"D42","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Wertveränderung (muss 0 sein)",{"$f":"L38-L36-L40-L42+L44","v":0}]

{"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":[]}