{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Einkommensstrategie","Ergebnisblatt"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Ergebnisblatt","index":1,"reason":"not_a_worksheet"}],"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":"Einkommensstrategie","index":0,"n_rows":85,"n_cols":10,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Ihre persönliche EINKOMMENSSTRATEGIE"]
[null,null,"Ihre Vorgaben:",null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-10"}]
[null,null,null,null,null,null,null,null,{"$f":"YEAR(D6)","v":1967}]
[null,null,"Geburtsdatum","1967-08-22",null,"Sie sind heute",{"$f":"CONCATENATE(I6-I5,\" Jahre alt.\")","v":"50 Jahre alt."},null,{"$f":"YEAR(I4)","v":2017}]
[null,null,"Anlagebetrag",100000]
[null,null,"gewünschter Rentenbeginn",65]
[null,null,"1. Phase bis zum Lebensjahr",75,null,"mit einem Anteil von ",60,"% bei einer Rendite von ",2,"%"]
[null,null,"2. Phase bis zum Lebensjahr",85,null,"mit einem Anteil von ",30,"% bei einer Rendite von ",4,"%"]
[null,null,"3. Phase bis zum Lebensjahr",100,null,"mit einem Anteil von ",10,"% bei einer Rendite von ",6,"%"]
[null,null,"Produktkosten",1,"%"]
[null,null,"Rendite Auszahlungsplan",2,"%",null,{"$f":"IF(SUM(G9:G11)<>100,\"Die Summe der Anteile müssen 100% ergeben!\",\"\")","v":""}]
[]
[]
[null,null,"Ihre Einkommensstrategie:"]
[]
[null,null,"Phase 1"]
[null,null,"Beginn: ",{"$f":"$I$6+($D$8-($I$6-$I$5))","v":2032},{"$f":"CONCATENATE(\"in \",($D$8-($I$6-$I$5)),\" Jahren mit Ihrem \",$D$8,\". Lebensjahr\")","v":"in 15 Jahren mit Ihrem 65. Lebensjahr"}]
[null,null,"Anlage:",{"$f":"D7*G9/100","v":60000}]
[null,null,{"$f":"CONCATENATE(\"Guthaben zum \",D8,\". Lebensjahr\")","v":"Guthaben zum 65. Lebensjahr"},{"$f":"$D$20*(1+($I$9-$D$12)/100)^($D$8-($I$6-$I$5))","v":69658.137322199909}]
[null,null,"monatlicher Auszahlungsbetrag:",{"$f":"PMT(D13%/12,(D9-D8)*12,D21,0,1)*-1","v":639.88211014192973},"in Phase 1"]
[]
[null,null,"Phase 2"]
[null,null,"Beginn: ",{"$f":"$I$6+($D$9-($I$6-$I$5))","v":2042},{"$f":"CONCATENATE(\"in \",($D$9-($I$6-$I$5)),\" Jahren mit Ihrem \",$D$9,\". Lebensjahr\")","v":"in 25 Jahren mit Ihrem 75. Lebensjahr"}]
[null,null,"Anlage:",{"$f":"D7*G10/100","v":30000}]
[null,null,{"$f":"CONCATENATE(\"Guthaben zum \",D9,\". Lebensjahr\")","v":"Guthaben zum 75. Lebensjahr"},{"$f":"$D$26*(1+($I$10-$D$12)/100)^($D$9-($I$6-$I$5))","v":62813.337889626418}]
[null,null,"monatlicher Auszahlungsbetrag:",{"$f":"PMT(D13%/12,(D10-D9)*12,D27,0,1)*-1","v":577.0055407591658},"in Phase 2"]
[]
[null,null,"Phase 3"]
[null,null,"Beginn: ",{"$f":"$I$6+($D$10-($I$6-$I$5))","v":2052},{"$f":"CONCATENATE(\"in \",($D$10-($I$6-$I$5)),\" Jahren mit Ihrem \",$D$10,\". Lebensjahr\")","v":"in 35 Jahren mit Ihrem 85. Lebensjahr"}]
[null,null,"Anlage:",{"$f":"D7*G11/100","v":10000}]
[null,null,{"$f":"CONCATENATE(\"Guthaben zum \",D10,\". Lebensjahr\")","v":"Guthaben zum 85. Lebensjahr"},{"$f":"$D$32*(1+($I$11-$D$12)/100)^($D$10-($I$6-$I$5))","v":55160.153675922513}]
[null,null,"monatlicher Auszahlungsbetrag:",{"$f":"PMT(D13%/12,(D11-D10)*12,D33,0,1)*-1","v":354.36977185914157},"in Phase 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"10","v":10},"RES",null,{"$f":"D7","v":100000}]
[null,null,{"$f":"I9","v":2},{"$f":"D22","v":639.88211014192973},null,{"$f":"D77","v":639.88211014192973},{"$f":"CONCATENATE(C77,\"%\")","v":"2%"}]
[null,null,{"$f":"D13","v":2},null,null,{"$f":"CONCATENATE(C78,\"%\")","v":"2%"}]
[null,null,{"$f":"I10","v":4},{"$f":"D28","v":577.0055407591658},null,{"$f":"D79","v":577.0055407591658},{"$f":"CONCATENATE(C79,\"%\")","v":"4%"}]
[null,null,{"$f":"D13","v":2},null,null,{"$f":"F78","v":"2%"}]
[null,null,{"$f":"I11","v":6},{"$f":"D34","v":354.36977185914157},null,{"$f":"D81","v":354.36977185914157},{"$f":"CONCATENATE(C81,\"%\")","v":"6%"}]
[null,null,null,null,null,{"$f":"F80","v":"2%"}]
[null,null,null,null,null,{"$f":"CONCATENATE(\"1. Phase (\",$D$8,\"-\",$D$9,\")\")","v":"1. Phase (65-75)"}]
[null,null,null,null,null,{"$f":"CONCATENATE(\"2. Phase (\",$D$9,\"-\",$D$10,\")\")","v":"2. Phase (75-85)"}]
[null,null,null,null,null,{"$f":"CONCATENATE(\"3. Phase (\",$D$10,\"-\",$D$11,\")\")","v":"3. Phase (85-100)"}]