{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Transaktionen","Portfolio","Zinseszins-Rechner","Dashboard","ROI-Formel"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Transaktionen","index":0,"n_rows":11,"n_cols":8,"rows_kept":11}
["Datum","Wertpapier","ISIN/Ticker","Typ","Anzahl","Kurs (€)","Gebühren (€)","Gesamtwert (€)"]
["2024-01-15","MSCI World ETF","IE00BJ0KDQ92","Kauf",10,85.5,1.5,{"$f":"E2*F2+G2","v":null}]
["2024-02-01","DAX ETF","DE0005933931","Kauf",5,145.2,1.5,{"$f":"E3*F3+G3","v":null}]
["2024-02-15","MSCI World ETF","IE00BJ0KDQ92","Kauf",8,87.3,1.5,{"$f":"E4*F4+G4","v":null}]
["2024-03-01","Apple Inc.","US0378331005","Kauf",3,172.5,4.99,{"$f":"E5*F5+G5","v":null}]
["2024-03-15","Bitcoin ETC","DE000A27Z304","Kauf",2,48.75,2,{"$f":"E6*F6+G6","v":null}]
["2024-04-01","DAX ETF","DE0005933931","Kauf",3,148,1.5,{"$f":"E7*F7+G7","v":null}]
["2024-04-15","MSCI World ETF","IE00BJ0KDQ92","Dividende",0,12.5,0,{"$f":"E8*F8+G8","v":null}]
["2024-05-01","Apple Inc.","US0378331005","Kauf",2,178.25,4.99,{"$f":"E9*F9+G9","v":null}]
["2024-05-15","MSCI EM ETF","IE00BKM4GZ66","Kauf",15,42.8,1.5,{"$f":"E10*F10+G10","v":null}]
["2024-06-01","Gold ETC","DE000A0S9GB0","Kauf",10,58.9,2,{"$f":"E11*F11+G11","v":null}]

{"sheet":"Portfolio","index":1,"n_rows":8,"n_cols":10,"rows_kept":8}
["Wertpapier","ISIN/Ticker","Anteile","Einstandskurs (€)","Einstandswert (€)","Aktueller Kurs (€)","Aktueller Wert (€)","Gewinn/Verlust (€)","ROI (%)","Gewichtung (%)"]
["MSCI World ETF","IE00BJ0KDQ92",18,86.22,{"$f":"C2*D2","v":null},89.5,{"$f":"C2*F2","v":null},{"$f":"G2-E2","v":null},{"$f":"IF(E2=0,0,(G2-E2)/E2*100)","v":null},{"$f":"IF($G$8=0,0,G2/$G$8*100)","v":null}]
["DAX ETF","DE0005933931",8,146.25,{"$f":"C3*D3","v":null},152.8,{"$f":"C3*F3","v":null},{"$f":"G3-E3","v":null},{"$f":"IF(E3=0,0,(G3-E3)/E3*100)","v":null},{"$f":"IF($G$8=0,0,G3/$G$8*100)","v":null}]
["Apple Inc.","US0378331005",5,174.85,{"$f":"C4*D4","v":null},185.2,{"$f":"C4*F4","v":null},{"$f":"G4-E4","v":null},{"$f":"IF(E4=0,0,(G4-E4)/E4*100)","v":null},{"$f":"IF($G$8=0,0,G4/$G$8*100)","v":null}]
["Bitcoin ETC","DE000A27Z304",2,48.75,{"$f":"C5*D5","v":null},52.3,{"$f":"C5*F5","v":null},{"$f":"G5-E5","v":null},{"$f":"IF(E5=0,0,(G5-E5)/E5*100)","v":null},{"$f":"IF($G$8=0,0,G5/$G$8*100)","v":null}]
["MSCI EM ETF","IE00BKM4GZ66",15,42.8,{"$f":"C6*D6","v":null},44.15,{"$f":"C6*F6","v":null},{"$f":"G6-E6","v":null},{"$f":"IF(E6=0,0,(G6-E6)/E6*100)","v":null},{"$f":"IF($G$8=0,0,G6/$G$8*100)","v":null}]
["Gold ETC","DE000A0S9GB0",10,58.9,{"$f":"C7*D7","v":null},61.25,{"$f":"C7*F7","v":null},{"$f":"G7-E7","v":null},{"$f":"IF(E7=0,0,(G7-E7)/E7*100)","v":null},{"$f":"IF($G$8=0,0,G7/$G$8*100)","v":null}]
["GESAMT",{"$nulls":3},{"$f":"SUM(E2:E7)","v":null},null,{"$f":"SUM(G2:G7)","v":null},{"$f":"SUM(H2:H7)","v":null},{"$f":"IF(E8=0,0,(G8-E8)/E8*100)","v":null},"100.0"]

{"sheet":"Zinseszins-Rechner","index":2,"n_rows":20,"n_cols":2,"rows_kept":20,"merged":[[0,0,0,4],[18,0,18,4],[19,0,19,4]]}
["📈 Zinseszins-Rechner: Portfolio-Wachstum"]
[]
["EINGABEN"]
["Startkapital (€)",5000]
["Monatliche Sparrate (€)",200]
["Erwartete Rendite p.a. (%)",{"v":7,"d":"7.0%"}]
["Anlagedauer (Jahre)",10]
[]
["ERGEBNISSE"]
["Monatlicher Zinssatz (%)",{"$f":"B6/12","v":null}]
["Anzahl Monate",{"$f":"B7*12","v":null}]
["Endwert Startkapital (€)",{"$f":"B4*(1+B6/100/12)^(B7*12)","v":null}]
["Endwert Sparraten (€)",{"$f":"IF(B6=0,B5*B7*12,B5*((1+B6/100/12)^(B7*12)-1)/(B6/100/12))","v":null}]
["Voraussichtliches Endkapital (€)",{"$f":"B12+B13","v":null}]
["Eingezahltes Kapital (€)",{"$f":"B4+B5*B7*12","v":null}]
["Zinsgewinn (€)",{"$f":"B14-B15","v":null}]
[]
["Formel-Erklärung:"]
["Endwert = Startkapital × (1 + r/n)^(n×t) + Sparrate × ((1 + r/n)^(n×t) - 1) / (r/n)"]
["Wobei: r = jährliche Rendite, n = 12 (monatliche Verzinsung), t = Jahre"]

{"sheet":"Dashboard","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"merged":[[0,0,0,6],[2,0,2,3],[9,0,9,3]]}
["📊 PORTFOLIO DASHBOARD"]
[]
["PORTFOLIO KENNZAHLEN"]
["Gesamtwert Portfolio:",{"$f":"Portfolio!G8","v":null}]
["Einstandswert:",{"$f":"Portfolio!E8","v":null}]
["Gesamter Gewinn/Verlust:",{"$f":"Portfolio!H8","v":null}]
["Gesamt-ROI:",{"$f":"Portfolio!I8","v":null}]
["Anzahl Positionen:",{"$f":"COUNTA(Portfolio!A2:A7)","v":null}]
[]
["ASSET ALLOCATION"]
["Asset","Wert (€)","Anteil (%)"]
[{"$f":"Portfolio!A2","v":null},{"$f":"Portfolio!G2","v":null},{"$f":"Portfolio!J2","v":null}]
[{"$f":"Portfolio!A3","v":null},{"$f":"Portfolio!G3","v":null},{"$f":"Portfolio!J3","v":null}]
[{"$f":"Portfolio!A4","v":null},{"$f":"Portfolio!G4","v":null},{"$f":"Portfolio!J4","v":null}]
[{"$f":"Portfolio!A5","v":null},{"$f":"Portfolio!G5","v":null},{"$f":"Portfolio!J5","v":null}]
[{"$f":"Portfolio!A6","v":null},{"$f":"Portfolio!G6","v":null},{"$f":"Portfolio!J6","v":null}]
[{"$f":"Portfolio!A7","v":null},{"$f":"Portfolio!G7","v":null},{"$f":"Portfolio!J7","v":null}]

{"sheet":"ROI-Formel","index":4,"n_rows":21,"n_cols":2,"rows_kept":21,"merged":[[0,0,0,4],[2,0,2,4],[4,0,4,4],[20,0,21,4]]}
["📐 ROI-Formel (Return on Investment)"]
[]
["Die einfache Rendite-Formel:"]
[]
["ROI = ((Aktueller Wert - Einstandswert) / Einstandswert) × 100"]
[]
["Bestandteile:"]
["• Aktueller Wert = Anzahl der Anteile × Aktueller Kurs"]
["• Einstandswert = Summe aller Kaufpreise + Gebühren"]
[]
["BEISPIELRECHNUNG"]
[]
["Anzahl Anteile:",10]
["Kaufkurs (€):",85.5]
["Aktueller Kurs (€):",89.5]
["Einstandswert (€):",{"$f":"B13*B14","v":null}]
["Aktueller Wert (€):",{"$f":"B13*B15","v":null}]
["ROI (%):",{"$f":"(B17-B16)/B16*100","v":null}]
[]
["Hinweis:"]
["Für das gesamte Portfolio inklusive Ein- und Auszahlungen ist der interne Zinsfuß (XINTZINSFUSS/XIRR in Excel) genauer."]