{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Steuern bei TZ"],"not_rendered":{"charts":1,"images":2,"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":[[6,2,6,4],[35,1,35,10],[0,6,0,10],[0,1,0,4],[8,1,9,4]]}
[null,"Termineinlagen - Effektivrechner",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":97807.740384615376},{"$f":"J5-D$12","v":-2192.2596153846243},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,null,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":95659.088794424912},{"$f":"J6-D$12","v":-4340.9112055750884},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,"Tel.: 02151-313148, info@rk-famliyoffice.de, www.rk-familyoffice.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},93550.507340310491,-6449.4926596895093,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,91482.862242276547,-8517.1377577234525,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,89455.542904717746,-10544.457095282254,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,87467.93999733642,-12532.06000266358,6,111013.07282900845,2208.1616063999973,1208.1616063999973,338.22484171167918]
[null,null,"Beispiel:","Festgeld",null,null,7,114868.56676492798,112537.75660849681,85519.445904594948,-14480.554095405052,7,112888.34494704271,2252.324838527973,1252.324838527973,350.58833854590603]
[null,null,"Anlagebetrag:",100000,null,null,8,117165.93810022656,114425.31263534992,83609.455146939916,-16390.544853060084,8,114788.51174066676,2297.3713352985797,1297.3713352985797,363.19910531683735]
[null,null,"Zins:",0.02,null,null,9,119509.25686223108,116337.75680063375,81737.364775121154,-18262.635224878846,9,116713.81888805692,2343.318762004521,1343.318762004521,376.06208742316562]
[null,null,"Inflationsrate:",0.04,null,null,10,121899.4419994757,118275.32960747481,79902.574738871073,-20097.425261128927,10,118664.51193664644,2390.1851372446254,1390.1851372446254,389.18232917163283]
[null,null,"Abgeltungsteuer (inkl. SolZ + KiSt):",0.27994999999999998,null,null,11,124337.4308394652,120238.27122386925,78104.488231157855,-21895.511768842145,11,120640.8361996243,2437.988839989499,1437.988839989499,402.56497575506017]
[null,null,"verbliebener Sparerpauschbetrag:",1000,null,null,12,126824.17945625453,122226.82137307647,76342.51200917321,-23657.48799082679,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":-49846.70939376032},null,null,13,129360.66304537961,124241.21921976242,74616.056693167004,-25383.943306832996,13,124671.357800538,2536.4835891250841,1536.4835891250841,430.13858077556728]
[null,null,null,null,null,null,14,131947.87630628722,126281.70325176659,72924.537044192621,-27075.462955807379,14,126726.04360415768,2587.213260907607,1587.213260907607,444.34035239108454]
[null,null,null,null,null,null,15,134586.83383241293,128348.51115736304,71267.372221782382,-28732.627778217618,15,128807.33731680193,2638.9575261257123,1638.9575261257123,458.82615943889311]
[null,null,null,null,null,null,16,137278.57050906122,130441.87969788261,69643.98602252845,-30356.01397747155,16,130915.4813805103,2691.7366766482883,1691.7366766482883,473.60168262768826]
[null,null,null,null,null,null,17,140024.14191924245,132562.04457556002,68053.807100502308,-31946.192899497692,17,133050.71729184026,2745.5714101812337,1745.5714101812337,488.67271628023633]
[null,null,null,null,null,null,18,142824.62475762726,134709.2402964654,66496.269170406274,-33503.730829593726,18,135213.28546707123,2800.4828383848071,1800.4828383848071,504.04517060582668]
[null,null,null,null,null,null,19,145681.1172527798,136883.70002837677,64970.811194311973,-35029.188805688027,19,137403.42510239471,2856.4924951525463,1856.4924951525463,519.72507401795531]
[null,null,null,null,null,null,20,148594.73959783543,139085.65545344597,63476.877552803293,-36523.122447196707,20,139621.37402894429,2913.6223450556281,1913.6223450556281,535.71857549832305]
[null,null,null,null,null,null,21,151566.63438979213,141315.33661550662,62013.91820130642,-37986.08179869358,21,141867.36856251489,2971.8947919566999,1971.8947919566999,552.03194700827805]
[null,null,null,null,null,null,22,154597.96707758796,143572.97176186831,60581.388812355217,-39418.611187644783,22,144141.64334781675,3031.3326877958316,2031.3326877958316,568.67158594844295]
[null,null,null,null,null,null,23,157689.92641913969,145858.78717943828,59178.750904507564,-40821.249095492436,23,146444.43119710567,3091.9593415517302,2091.9593415517302,585.64401766740684]
[null,null,null,null,null,null,24,160843.72494752251,148173.00702500629,57805.47195859746,-42194.52804140254,24,148775.96292302705,3153.7985283828166,2153.7985283828166,602.9558980207695]
[null,null,null,null,null,null,25,164060.59944647294,150515.85314952524,56461.025521977106,-43538.974478022894,25,151136.46716550642,3216.8744989504339,2216.8744989504339,620.61401598117391]
[null,null,null,null,null,null,26,167341.81143540243,152887.54491621495,55144.891301374824,-44855.108698625176,26,153526.17021251575,3281.2119889294845,2281.2119889294845,638.62529630080917]
[null,null,null,null,null,null,27,170688.64766411044,155288.29901231243,53856.555244966716,-46143.444755033284,27,155945.29581453925,3346.836228708009,2346.836228708009,656.99680222680706]
[null,null,null,null,null,null,{"$f":"G31+1","v":28},174102.42061739269,157718.3292542873,52595.509614234281,-47404.490385765719,28,158394.06499255868,3413.7729532822559,2413.7729532822559,675.7357382713675]
[null,null,null,null,null,null,29,177584.46902974052,160177.84638633628,51361.25304615379,-48638.74695384621,29,160872.69583937305,3482.0484123478236,2482.0484123478236,694.84945303677318]
[null,null,null,null,null,null,30,181136.15841033534,162667.05787196549,50153.29060623968,-49846.70939376032,30,163381.40331406301,3551.6893805948202,2551.6893805948202,714.34544209751982]