{"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]]}
[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":99500},{"$f":"H5-P5","v":99500},{"$f":"I5*(1+$D$14)^(-G5)","v":97549.019607843133},{"$f":"J5-D$12","v":-2450.9803921568673},null,null,{"$f":"H5-D12","v":-500},{"$f":"IF(N5-$D$16<0,0,N5-$D$16)","v":0},{"$f":"O5*$D$15","v":0}]
[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":99002.5},{"$f":"M6-P6","v":99002.5},{"$f":"I6*(1+$D$14)^(-G6)","v":95158.112264513649},{"$f":"J6-D$12","v":-4841.8877354863507},2,{"$f":"I5*(1+$D$13)","v":99002.5},{"$f":"M6-I5","v":-497.5},{"$f":"IF(N6-$D$16<0,0,N6-$D$16)","v":0},{"$f":"O6*$D$15","v":0}]
[null,"Lösungen:","www.target-fonds.info","www.private-wealth-police.de",null,null,{"$f":"G6+1","v":3},{"$f":"$D$12*((1+$D$13)^G7)","v":98507.487500000003},{"$f":"M7-P7","v":98507.487500000003},92825.805591363824,-7174.1944086361764,3,{"$f":"I6*(1+$D$13)","v":98507.487500000003},{"$f":"H7-H6","v":-495.01249999999709},0,0]
[null,null,null,null,null,null,4,98014.950062500007,98014.950062500007,90550.663297457839,-9449.3367025421612,4,{"$f":"I7*(1+$D$13)","v":98014.950062500007},-492.53743749999558,0,0]
[null,"Berechnungsdaten",null,null,null,null,5,97524.875312187505,97524.875312187505,88331.28429506917,-11668.71570493083,5,{"$f":"I8*(1+$D$13)","v":97524.875312187505},-490.07475031250215,0,0]
[null,null,null,null,null,null,6,97037.25093562658,97037.250935626565,86166.30183685667,-13833.69816314333,6,97037.250935626565,-487.62437656092516,0,0]
[null,null,"Beispiel:","Bankguthaben",null,null,7,96552.064680948431,96552.064680948431,84054.38267418863,-15945.61732581137,7,96552.064680948431,-485.18625467814854,0,0]
[null,null,"Anlagebetrag:",100000,null,null,8,96069.30435754369,96069.30435754369,81994.226236095768,-18005.773763904232,8,96069.30435754369,-482.76032340474194,0,0]
[null,null,"Zins:",-5.0000000000000001E-3,null,null,9,95588.957835755966,95588.957835755966,79984.563828348328,-20015.436171651672,9,95588.957835755966,-480.34652178772376,0,0]
[null,null,"Inflationsrate:",0.02,null,null,10,95111.013046577194,95111.01304657718,78024.157852163306,-21975.842147836694,10,95111.01304657718,-477.94478917877132,0,0]
[null,null,"Abgeltungsteuer (inkl. SolZ + KiSt):",0.27994999999999998,null,null,11,94635.457981344312,94635.457981344298,76111.801042061285,-23888.198957938715,11,94635.457981344298,-475.55506523288204,0,0]
[null,null,"verbliebener Sparerpauschbetrag:",801,null,null,12,94162.280691437598,94162.280691437569,74246.315722402898,-25753.684277597102,12,94162.280691437569,-473.17728990671458,0,0]
[null,null,{"$f":"IF(K5>0,\"Kaufkraftgewinn nach 30 Jahren:\",\"Kaufkraftverlust nach 30 Jahren:\")","v":"Kaufkraftverlust nach 30 Jahren:"},{"$f":"K34","v":-52500.693430539082},null,null,13,93691.469287980406,93691.469287980377,72426.553082147933,-27573.446917852067,13,93691.469287980377,-470.81140345719177,0,0]
[null,null,null,null,null,null,14,93223.011941540506,93223.011941540477,70651.392467389393,-29348.607532610607,14,93223.011941540477,-468.45734643989999,0,0]
[null,null,null,null,null,null,15,92756.896881832799,92756.89688183277,68919.740691227897,-31080.259308772103,15,92756.89688183277,-466.11505970770668,0,0]
[null,null,null,null,null,null,16,92293.11239742364,92293.112397423611,67230.531360560548,-32769.468639439452,16,92293.112397423611,-463.78448440915963,0,0]
[null,null,null,null,null,null,17,91831.646835436521,91831.646835436492,65582.724219370328,-34417.275780629672,17,91831.646835436492,-461.46556198711914,0,0]
[null,null,null,null,null,null,18,91372.488601259334,91372.488601259305,63975.304508111258,-36024.695491888742,18,91372.488601259305,-459.15823417718639,0,0]
[null,null,null,null,null,null,19,90915.626158253042,90915.626158253013,62407.282338794808,-37592.717661205192,19,90915.626158253013,-456.86244300629187,0,0]
[null,null,null,null,null,null,20,90461.048027461773,90461.048027461744,60877.69208539297,-39122.30791460703,20,90461.048027461744,-454.57813079126936,0,0]
[null,null,null,null,null,null,21,90008.742787324474,90008.742787324431,59385.591789182356,-40614.408210817644,21,90008.742787324431,-452.30524013729882,0,0]
[null,null,null,null,null,null,22,89558.699073387848,89558.699073387805,57930.062578663172,-42069.937421336828,22,89558.699073387805,-450.04371393662586,0,0]
[null,null,null,null,null,null,23,89110.905578020902,89110.905578020858,56510.208103695943,-43489.791896304057,23,89110.905578020858,-447.79349536694644,0,0]
[null,null,null,null,null,null,24,88665.351050130805,88665.351050130746,55125.153983507305,-44874.846016492695,24,88665.351050130746,-445.55452789009723,0,0]
[null,null,null,null,null,null,25,88222.024294880146,88222.024294880088,53774.047268225273,-46225.952731774727,25,88222.024294880088,-443.32675525065861,0,0]
[null,null,null,null,null,null,26,87780.914173405748,87780.91417340569,52456.055913611905,-47543.944086388095,26,87780.91417340569,-441.1101214743976,0,0]
[null,null,null,null,null,null,27,87342.009602538717,87342.009602538659,51170.368268670441,-48829.631731329559,27,87342.009602538659,-438.904570867031,0,0]
[null,null,null,null,null,null,{"$f":"G31+1","v":28},86905.299554526035,86905.299554525962,49916.192575810855,-50083.807424189145,28,86905.299554525962,-436.71004801268282,0,0]
[null,null,null,null,null,null,29,86470.773056753416,86470.773056753329,48692.756483266479,-51307.243516733521,29,86470.773056753329,-434.52649777261831,0,0]
[null,null,null,null,null,null,30,86038.419191469642,86038.419191469555,47499.306569460918,-52500.693430539082,30,86038.419191469555,-432.35386528377421,0,0]