{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Einmaleinlage","Kapitalaufbau"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Einmaleinlage","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,1,37,4],[10,1,11,1],[10,3,11,3],[10,4,11,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[2,12,4,12],[2,7,4,7],[2,8,4,8],[2,6,4,6],[2,9,4,9],[2,10,4,10],[2,11,4,11]]}
[null,null,null,null,null,null,null,{"$f":"H6+D8","v":2052}]
[null,"Altersversorgung"]
[null,"Alter",null,65,"Jahre",null,"Alter","Jahr","Kapital","Wert-zuwachs","Kapital zzgl. Wertzuwachs","jährliche Entnahme","Restkapital"]
[null,"Anlagebetrag",null,250000,"EUR"]
[null,"Aufschubphase",null,0,"Jahre"]
[null,"Rendite in der Aufschubphase",null,3,"%",null,{"$f":"D3+D5","v":65},{"$f":"YEAR(TODAY())+D5","v":2022},{"$f":"IF(H$1>H6,D7,0)","v":250000},{"$f":"I6*D$9/100","v":7500},{"$f":"I6+J6","v":257500},{"$f":"IF(I6>0,D$10,0)","v":12648.121011883515},{"$f":"IF(K6>L6,K6-L6,0)","v":244851.87898811648}]
[null,"angespartes Kapital",null,{"$f":"FV(D6/1200,D5*12,0,-D4,1)","v":250000},"EUR",null,{"$f":"G6+1","v":66},{"$f":"H6+1","v":2023},{"$f":"IF(H7<=H$1,M6,0)","v":244851.87898811648},7345.5563696434947,252197.43535775997,{"$f":"IF(I7>0,MIN(D$10,K7),0)","v":12648.121011883515},{"$f":"IF(K7>L7,K7-L7,0)","v":239549.31434587645}]
[null,"Kapitalverzehrdauer",null,30,"Jahre",null,67,2024,{"$f":"IF(H8<=H$1,M7,0)","v":239549.31434587645},7186.4794303762937,246735.79377625274,12648.121011883515,234087.67276436923]
[null,"Rendite in der Entsparphase",null,3,"%",null,68,2025,234087.67276436923,7022.630182931076,241110.30294730031,12648.121011883515,{"$f":"IF(K9>L9,K9-L9,0)","v":228462.1819354168}]
[null,"Entnahme pro Jahr",null,{"$f":"12*D11","v":12648.121011883515},"EUR",null,69,2026,228462.1819354168,6853.8654580625043,235316.0473934793,12648.121011883515,222667.92638159578]
[null,"Entnahme pro Monat   ",null,{"$f":"PMT(D9/1200,D8*12,-D7)","v":1054.0100843236262},"EUR",null,70,2027,222667.92638159578,6680.0377914478731,229347.96417304364,12648.121011883515,216699.84316116013]
[null,null,null,null,null,null,71,2028,216699.84316116013,6500.9952948348036,223200.83845599493,12648.121011883515,210552.71744411142]
[null,"Information zur Höhe der",null,null,null,null,72,2029,210552.71744411142,6316.5815233233434,216869.29896743476,12648.121011883515,204221.17795555125]
[null,"\"ewigen Rente\" pro Monat",null,{"$f":"IF(D9<0%,0,PMT((1+D9/100)^(1/12)-1,12,-D7,D7,0))","v":616.56744307592157},"EUR",null,73,2030,{"$f":"IF(H14<=H$1,M13,0)","v":204221.17795555125},6126.6353386665369,210347.81329421778,12648.121011883515,197699.69228233426]
[null,null,null,null,null,null,74,2031,197699.69228233426,5930.9907684700283,203630.68305080428,12648.121011883515,190982.56203892076]
[null,null,null,null,null,null,75,2032,190982.56203892076,5729.4768611676227,196712.03890008837,12648.121011883515,184063.91788820486]
[null,null,null,null,null,null,76,2033,184063.91788820486,5521.9175366461459,189585.83542485101,12648.121011883515,176937.7144129675]
[null," Wichtige Hinweise:",null,null,null,null,77,2034,176937.7144129675,5308.1314323890256,182245.84584535653,12648.121011883515,169597.72483347301]
[null,null,null,null,null,null,78,2035,169597.72483347301,5087.9317450041908,174685.65657847721,12648.121011883515,162037.53556659369]
[null," Bei dieser Berechnung handelt es sich um eine kalkulatorische",null,null,null,null,79,2036,162037.53556659369,4861.126066997811,166898.66163359152,12648.121011883515,154250.540621708]
[null," Betrachtung eines möglichen Depotverlaufs. Keine Garantie!",null,null,null,null,80,2037,154250.540621708,4627.5162186512398,158878.05684035923,12648.121011883515,146229.93582847572]
[null,null,null,null,null,null,81,2038,146229.93582847572,4386.8980748542708,150616.83390333,12648.121011883515,137968.71289144648]
[null," Die Berechnungen und Verläufe berücksichtigen keine Steuern.",null,null,null,null,82,2039,137968.71289144648,4139.0613867433949,142107.77427818987,12648.121011883515,129459.65326630636]
[null,null,null,null,null,null,83,2040,129459.65326630636,3883.7895979891905,133343.44286429553,12648.121011883515,120695.32185241202]
[null," Die \"ewige Rente\" ist der Ertrag (Zinsen, Dividenden und ",null,null,null,null,84,2041,120695.32185241202,3620.8596555723607,124316.18150798438,12648.121011883515,{"$f":"IF(K25>L25,K25-L25,0)","v":111668.06049610086}]
[null," Wertzuwächse), den das angesparte Kapital bei der Rendite von",null,null,null,null,85,2042,111668.06049610086,3350.0418148830258,115018.10231098389,12648.121011883515,{"$f":"IF(K26>L26,K26-L26,0)","v":102369.98129910037}]
[null," X% in der Entsparphase erzielt, ohne das Kapital zu verbrauchen.",null,null,null,null,86,2043,102369.98129910037,3071.0994389730108,105441.08073807337,12648.121011883515,92792.95972618986]
[null," Da das Kapital erhalten bleibt, wird die \"Rente\" ewig erzielt.",null,null,null,null,87,2044,92792.95972618986,2783.788791785696,95576.74851797556,12648.121011883515,82928.627506092045]
[null,null,null,null,null,null,88,2045,82928.627506092045,2487.8588251827614,85416.486331274806,12648.121011883515,72768.365319391291]
[null,null,null,null,null,null,89,2046,72768.365319391291,2183.0509595817384,74951.416278973033,12648.121011883515,62303.295267089517]
[null,null,null,null,null,null,90,2047,62303.295267089517,1869.0988580126857,64172.394125102204,12648.121011883515,51524.273113218689]
[null,null,null,null,null,null,91,2048,51524.273113218689,1545.7281933965608,53070.001306615253,12648.121011883515,40421.880294731738]
[null,null,null,null,null,null,92,2049,40421.880294731738,1212.6564088419523,41634.536703573693,12648.121011883515,28986.415691690177]
[null," Camesstr. 59, 47807 Krefeld",null,null,null,null,93,2050,28986.415691690177,869.59247075070539,29856.008162440881,12648.121011883515,17207.887150557366]
[null,"Tel.: 02151-313148",null,null,null,null,94,2051,17207.887150557366,516.23661451672103,17724.123765074088,12648.121011883515,5076.0027531905725]
[null,"info@proneutralis.de, www.proneutralis.de",null,null,null,null,95,2052,5076.0027531905725,152.28008259571718,5228.28283578629,5228.28283578629,0]
[null,null,null,null,null,null,96,2053,0,0,0,0,0]
[null,"Infos unter: www.tmd-ar.de",null,null,null,null,97,2054,0,0,0,0,0]
[null,null,null,null,null,null,98,2055,0,0,0,0,0]
[null,null,null,null,null,null,99,2056,0,0,0,0,0]

{"sheet":"Kapitalaufbau","index":1,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,1,38,4],[2,12,4,12],[2,7,4,7],[2,8,4,8],[2,6,4,6],[2,9,4,9],[2,10,4,10],[2,11,4,11],[35,1,35,4],[36,1,36,4],[11,1,12,1],[11,3,12,3],[11,4,12,4],[34,1,34,4]]}
[null,null,null,null,null,null,null,{"$f":"H6+D9","v":2092}]
[null,"Altersvorsorge"]
[null,"Alter",null,25,"Jahre",null,"Alter","Jahr","Kapital","Wert-zuwachs","Kapital zzgl. Wertzuwachs","jährliche Entnahme","Restkapital"]
[null,"Anlagebetrag",null,10000,"EUR"]
[null,"Sparbetrag pro Monat",null,250,"EUR"]
[null,"Spardauer",null,40,"Jahre",null,{"$f":"D3+D6","v":65},{"$f":"YEAR(TODAY())+D6","v":2062},{"$f":"IF(H$1>H6,D8,0)","v":265245.15001492709},{"$f":"I6*D$10/100","v":7957.3545004478119},{"$f":"I6+J6","v":273202.50451537489},{"$f":"IF(I6>0,D$11,0)","v":13419.411020815978},{"$f":"IF(K6>L6,K6-L6,0)","v":259783.09349455891}]
[null,"Rendite in der Sparphase",null,3,"%",null,{"$f":"G6+1","v":66},2063,{"$f":"IF(H7<=H$1,M6,0)","v":259783.09349455891},{"$f":"I7*D$10/100","v":7793.4928048367674},267576.58629939565,{"$f":"IF(I7>0,MIN(D$11,K7),0)","v":13419.411020815978},{"$f":"IF(K7>L7,K7-L7,0)","v":254157.17527857967}]
[null,"angespartes Kapital",null,{"$f":"FV(D7/1200,D6*12,-D5,-D4,1)","v":265245.15001492709},"EUR",null,67,2064,254157.17527857967,7624.7152583573898,261781.89053693705,{"$f":"IF(I8>0,MIN(D$11,K8),0)","v":13419.411020815978},248362.47951612106]
[null,"Kapitalverzehrdauer",null,30,"Jahre",null,68,2065,248362.47951612106,7450.8743854836321,255813.35390160469,13419.411020815978,242393.9428807887]
[null,"Rendite in der Entsparphase",null,3,"%",null,69,2066,242393.9428807887,7271.8182864236614,249665.76116721236,13419.411020815978,236246.35014639638]
[null,"Entnahme pro Jahr",null,{"$f":"12*D12","v":13419.411020815978},"EUR",null,70,2067,236246.35014639638,7087.3905043918921,243333.74065078827,13419.411020815978,229914.32962997229]
[null,"Entnahme pro Monat   ",null,{"$f":"PMT(D10/1200,D9*12,-D8)","v":1118.2842517346648},"EUR",null,71,2068,229914.32962997229,6897.429888899168,236811.75951887146,13419.411020815978,223392.34849805548]
[null,null,null,null,null,null,72,2069,223392.34849805548,6701.770454941664,230094.11895299715,13419.411020815978,216674.70793218116,{"$f":"D8/30/12","v":736.79208337479747}]
[null,"Information zur Höhe der",null,null,null,null,73,2070,216674.70793218116,6500.2412379654343,223174.9491701466,13419.411020815978,209755.53814933062]
[null,"\"ewigen Rente\" pro Monat",null,{"$f":"IF(D10<0%,0,PMT((1+D10/100)^(1/12)-1,12,-D8,D8,0))","v":654.16609573197138},"EUR",null,74,2071,209755.53814933062,6292.6661444799183,216048.20429381053,13419.411020815978,202628.79327299455]
[null,null,null,null,null,null,75,2072,202628.79327299455,6078.8637981898364,208707.6570711844,13419.411020815978,195288.24605036841]
[null,null,null,null,null,null,76,2073,195288.24605036841,5858.6473815110521,201146.89343187946,13419.411020815978,187727.48241106348]
[null,null,null,null,null,null,77,2074,187727.48241106348,5631.824472331904,193359.30688339539,13419.411020815978,179939.8958625794]
[null," Wichtige Hinweise:",null,null,null,null,78,2075,179939.8958625794,5398.1968758773828,185338.09273845679,13419.411020815978,171918.68171764081]
[null,null,null,null,null,null,79,2076,171918.68171764081,5157.5604515292243,177076.24216917003,13419.411020815978,163656.83114835405]
[null," Bei dieser Berechnung handelt es sich um eine kalkulatorische",null,null,null,null,80,2077,163656.83114835405,4909.7049344506213,168566.53608280467,13419.411020815978,155147.12506198869]
[null," Betrachtung eines möglichen Depotverlaufs. Keine Garantie!",null,null,null,null,81,2078,155147.12506198869,4654.4137518596599,159801.53881384834,13419.411020815978,146382.12779303236]
[null,null,null,null,null,null,82,2079,146382.12779303236,4391.463833790971,150773.59162682333,13419.411020815978,137354.18060600734]
[null," Die Berechnungen und Verläufe berücksichtigen keine Steuern.",null,null,null,null,83,2080,137354.18060600734,4120.6254181802205,141474.80602418756,13419.411020815978,128055.39500337158]
[null,null,null,null,null,null,84,2081,128055.39500337158,3841.6618501011476,131897.05685347272,13419.411020815978,{"$f":"IF(K25>L25,K25-L25,0)","v":118477.64583265674}]
[null," Die \"ewige Rente\" ist der Ertrag (Zinsen, Dividenden und ",null,null,null,null,85,2082,118477.64583265674,3554.3293749797017,122031.97520763644,13419.411020815978,{"$f":"IF(K26>L26,K26-L26,0)","v":108612.56418682045}]
[null," Wertzuwächse), den das angesparte Kapital bei der Rendite von",null,null,null,null,86,2083,108612.56418682045,3258.3769256046135,111870.94111242506,13419.411020815978,98451.530091609078]
[null," X% in der Entsparphase erzielt, ohne das Kapital zu verbrauchen.",null,null,null,null,87,2084,98451.530091609078,2953.5459027482721,101405.07599435735,13419.411020815978,87985.664973541367]
[null," Da das Kapital erhalten bleibt, wird die \"Rente\" ewig erzielt.",null,null,null,null,88,2085,87985.664973541367,2639.5699492062408,90625.234922747608,13419.411020815978,77205.823901931624]
[null,null,null,null,null,null,89,2086,77205.823901931624,2316.1747170579488,79521.998618989572,13419.411020815978,66102.587598173588]
[null,null,null,null,null,null,90,2087,66102.587598173588,1983.0776279452077,68085.665226118799,13419.411020815978,54666.254205302823]
[null,null,null,null,null,null,91,2088,54666.254205302823,1639.9876261590846,56306.241831461906,13419.411020815978,42886.83081064593]
[null,null,null,null,null,null,92,2089,42886.83081064593,1286.6049243193779,44173.435734965307,13419.411020815978,30754.024714149331]
[null,null,null,null,null,null,93,2090,30754.024714149331,922.62074142447989,31676.645455573809,13419.411020815978,18257.234434757833]
[null," Camesstr. 59, 47807 Krefeld",null,null,null,null,94,2091,18257.234434757833,547.71703304273501,18804.951467800569,13419.411020815978,5385.5404469845907]
[null,"Tel.: 02151-313148",null,null,null,null,95,2092,5385.5404469845907,161.56621340953771,5547.1066603941281,5547.1066603941281,0]
[null,"info@proneutralis.de, www.proneutralis.de",null,null,null,null,96,2093,0,0,0,0,0]
[null,null,null,null,null,null,97,2094,0,0,0,0,0]
[null,"Infos unter: www.tmd-ar.de",null,null,null,null,98,2095,0,0,0,0,0]
[null,null,null,null,null,null,99,2096,0,0,0,0,0]