{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Steuern bei TZ"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":281,"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":"Steuern bei TZ","index":0,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[36,1,36,10],[0,6,0,10],[0,1,0,4],[8,1,9,4],[5,1,5,4],[6,2,6,3]]}
[null,"Zinseszins-Rechner",null,null,null,null,"Kaufkraftentwicklung"]
[null,null,null,null,null,null,null,"Entwicklung","Entwicklung","Entwicklung",{"$f":"IF(K5>0,\"Kaufkraftgewinn\",\"Kaufkraftverlust\")","v":"Kaufkraftverlust"},null,null,"Zinsen","Zinsen","Steuern"]
[null,null,null,null,null,null,"Jahr","nominell","nach Steuern","nach Steuern","nach Steuern",null,null,null,"nach PB"]
[null,null,null,null,null,null,null,null,null,"und Inflation","und Inflation"]
[null,null,null,null,null,null,1,{"$f":"$D$12*(1+$D$13^G5)","v":102000},{"$f":"H5-P5","v":101720.05},{"$f":"I5*(1+$D$14)^(-G5)","v":96876.238095238092},{"$f":"J5-D$12","v":-3123.7619047619082},null,null,{"$f":"H5-D12","v":2000},{"$f":"IF(N5-$D$16<0,0,N5-$D$16)","v":1000},{"$f":"O5*$D$15","v":279.95}]
[null,"Tel.:  02151-313148, info@proneutralis.de, www.proneutralis.de",null,null,null,null,{"$f":"G5+1","v":2},{"$f":"$D$12*((1+$D$13)^G6)","v":104040},{"$f":"M6-P6","v":103464.87044005},{"$f":"I6*(1+$D$14)^(-G6)","v":93845.687473968253},{"$f":"J6-D$12","v":-6154.3125260317465},2,{"$f":"I5*(1+$D$13)","v":103754.451},{"$f":"M6-I5","v":2034.400999999998},{"$f":"IF(N6-$D$16<0,0,N6-$D$16)","v":1034.400999999998},{"$f":"O6*$D$15","v":289.58055994999944}]
[null,null,"www.neutralis-fondsshop.de",null,null,null,{"$f":"G6+1","v":3},{"$f":"$D$12*((1+$D$13)^G7)","v":106120.79999999999},{"$f":"M7-P7","v":105231.59788885101},90903.010809935004,-9096.9891900649964,3,{"$f":"I6*(1+$D$13)","v":105534.16784885101},{"$f":"H7-H6","v":2080.7999999999884},1080.7999999999884,302.56995999999674]
[null,null,null,null,null,null,4,108243.216,107022.00948742803,88047.272062507313,-11952.727937492687,4,{"$f":"I7*(1+$D$13)","v":107336.22984662803},2122.416000000012,1122.416000000012,314.22035920000332]
[null,"Berechnungsdaten",null,null,null,null,5,110408.08032000001,108836.3459107926,85276.12488391847,-14723.87511608153,5,{"$f":"I8*(1+$D$13)","v":109162.4496771766},2164.8643200000079,1164.8643200000079,326.1037663840022]
[null,null,null,null,null,null,6,112616.24192640001,110674.84798729677,82587.275588539123,-17412.724411460877,6,111013.07282900845,2208.1616063999973,1208.1616063999973,338.22484171167918]
[null,null,"Beispiel:","Bankguthaben",null,null,7,114868.56676492798,112537.75660849681,79978.482556386385,-20021.517443613615,7,112888.34494704271,2252.324838527973,1252.324838527973,350.58833854590603]
[null,null,"Anlagebetrag:",100000,null,null,8,117165.93810022656,114425.31263534992,77447.555604043329,-22552.444395956671,8,114788.51174066676,2297.3713352985797,1297.3713352985797,363.19910531683735]
[null,null,"Zins:",0.02,null,null,9,119509.25686223108,116337.75680063375,74992.35532646619,-25007.64467353381,9,116713.81888805692,2343.318762004521,1343.318762004521,376.06208742316562]
[null,null,"Inflationsrate:",0.05,null,null,10,121899.4419994757,118275.32960747481,72610.792412930561,-27389.207587069439,10,118664.51193664644,2390.1851372446254,1390.1851372446254,389.18232917163283]
[null,null,"Abgeltungsteuer (inkl. SolZ + KiSt):",0.27994999999999998,null,null,11,124337.4308394652,120238.27122386925,70300.826940154118,-29699.173059845882,11,120640.8361996243,2437.988839989499,1437.988839989499,402.56497575506017]
[null,null,"verbliebener Sparerpauschbetrag:",1000,null,null,12,126824.17945625453,122226.82137307647,68060.467645433644,-31939.532354566356,12,122643.03664834664,2486.7486167893221,1486.7486167893221,416.21527527017071]
[null,null,{"$f":"IF(K5>0,\"Kaufkraftgewinn nach 30 Jahren:\",\"Kaufkraftverlust nach 30 Jahren:\")","v":"Kaufkraftverlust nach 30 Jahren:"},{"$f":"K34","v":-62362.511169229801},null,null,13,129360.66304537961,124241.21921976242,65887.77118244255,-34112.22881755745,13,124671.357800538,2536.4835891250841,1536.4835891250841,430.13858077556728]
[null,null,null,null,null,null,14,131947.87630628722,126281.70325176659,63780.841362157313,-36219.158637842687,14,126726.04360415768,2587.213260907607,1587.213260907607,444.34035239108454]
[null,null,null,null,null,null,15,134586.83383241293,128348.51115736304,61737.828381211286,-38262.171618788714,15,128807.33731680193,2638.9575261257123,1638.9575261257123,458.82615943889311]
[null,null,null,null,null,null,16,137278.57050906122,130441.87969788261,59756.928039816128,-40243.071960183872,16,130915.4813805103,2691.7366766482883,1691.7366766482883,473.60168262768826]
[null,null,null,null,null,null,17,140024.14191924245,132562.04457556002,57836.380951239647,-42163.619048760353,17,133050.71729184026,2745.5714101812337,1745.5714101812337,488.67271628023633]
[null,null,null,null,null,null,18,142824.62475762726,134709.2402964654,55974.471744688453,-44025.528255311547,18,135213.28546707123,2800.4828383848071,1800.4828383848071,504.04517060582668]
[null,null,null,null,null,null,19,145681.1172527798,136883.70002837677,54169.528263309745,-45830.471736690255,19,137403.42510239471,2856.4924951525463,1856.4924951525463,519.72507401795531]
[null,null,null,null,null,null,20,148594.73959783543,139085.65545344597,52419.920758901593,-47580.079241098407,20,139621.37402894429,2913.6223450556281,1913.6223450556281,535.71857549832305]
[null,null,null,null,null,null,21,151566.63438979213,141315.33661550662,50724.06108480219,-49275.93891519781,21,141867.36856251489,2971.8947919566999,1971.8947919566999,552.03194700827805]
[null,null,null,null,null,null,22,154597.96707758796,143572.97176186831,49080.401888317887,-50919.598111682113,22,144141.64334781675,3031.3326877958316,2031.3326877958316,568.67158594844295]
[null,null,null,null,null,null,23,157689.92641913969,145858.78717943828,47487.435803944747,-52512.564196055253,23,146444.43119710567,3091.9593415517302,2091.9593415517302,585.64401766740684]
[null,null,null,null,null,null,24,160843.72494752251,148173.00702500629,45943.69464854015,-54056.30535145985,24,148775.96292302705,3153.7985283828166,2153.7985283828166,602.9558980207695]
[null,null,null,null,null,null,25,164060.59944647294,150515.85314952524,44447.748619508136,-55552.251380491864,25,151136.46716550642,3216.8744989504339,2216.8744989504339,620.61401598117391]
[null,null,null,null,null,null,26,167341.81143540243,152887.54491621495,42998.205496975585,-57001.794503024415,26,153526.17021251575,3281.2119889294845,2281.2119889294845,638.62529630080917]
[null,null,null,null,null,null,27,170688.64766411044,155288.29901231243,41593.70985085416,-58406.29014914584,27,155945.29581453925,3346.836228708009,2346.836228708009,656.99680222680706]
[null,null,null,null,null,null,{"$f":"G31+1","v":28},174102.42061739269,157718.3292542873,40232.942253606547,-59767.057746393453,28,158394.06499255868,3413.7729532822559,2413.7729532822559,675.7357382713675]
[null,null,null,null,null,null,29,177584.46902974052,160177.84638633628,38914.618499463468,-61085.381500536532,29,160872.69583937305,3482.0484123478236,2482.0484123478236,694.84945303677318]
[null,null,null,null,null,null,30,181136.15841033534,162667.05787196549,37637.488830770199,-62362.511169229801,30,163381.40331406301,3551.6893805948202,2551.6893805948202,714.34544209751982]