{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Freibetragsrechner","Tabelle2","Tabelle3"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Freibetragsrechner","index":0,"n_rows":94,"n_cols":10,"rows_kept":94,"cut":false,"hidden":false,"merged":[[3,1,3,3],[14,1,14,3],[1,1,1,3]]}
[]
[null,"bAV-Freibetragsrechner ",null,null,null,null,null,null,null,"Ja"]
[null,null,null,null,null,null,null,null,null,"Nein"]
[null,"Bitte blaue Eingabefelder kundenindividuell anpassen"]
[]
[null,"monatliche Versorgungsbezüge \n(bzw. 1/120 der Kapitalleistung)",null,1000]
[null,"Freibetrag (120tel der monatlichen Bezugsgröße nach § 18 SGB IV) aus dem Jahr:",2024,{"$f":"VLOOKUP(C7,A51:B81,2,0)","v":176.75}]
[null,"Gesamtbeitragssatz gessetzliche Krankenversicherung im Jahr:",2024,0.14599999999999999]
[null,"Zusatzbeitragssatz (z.B.1,30%) im Jahr: ",2024,1.2999999999999999E-2]
[null,"Beitragssatz der gesetzlichen Pflegeversicherung Jahr:",2024,3.4000000000000002E-2]
[null,"Haben Sie Kinder? Wenn ja Zuschlag für Kinderlose.","Nein",{"$f":"IF(C11=\"nein\",0.6%,0)","v":6.0000000000000001E-3}]
[null,"Beitragsbemessungsgrenze in der gesetzlichen Kranken- und Pflegeversicherung ",2024,5175]
[]
[]
[null,"Berechnungsergebnisse",null,null,null,"Zum Vergleich: \nalte Regelung",null,"Monatliche Verbesserung im Vergleich zur alten Regelung"]
[]
[null,"Beiträge in der gesetzlichen Krankenversicherung",null,{"$f":"IF(IF($D$6<$D$12,($D$6-$D$7)*($D$8+$D$9), ($D$12-$D$7)*($D$8+$D$9))<0,0,IF($D$6<$D$12,($D$6-$D$7)*($D$8+$D$9), ($D$12-$D$7)*($D$8+$D$9)))","v":130.89675},null,{"$f":"IF(D17=0,0,IF($D$6<$D$12,$D$6*($D$8+$D$9), $D$12*($D$8+$D$9)))","v":159}]
[null,"Beiträge in der gesetzlichen Pflegeversicherung ",null,{"$f":"IF(D17=0,0,IF($D$6<$D$12,$D$6*($D$10+$D$11), $D$12*($D$10+$D$11)))","v":40},null,{"$f":"IF(D17=0,0,IF($D$6<$D$12,$D$6*($D$10+$D$11), $D$12*($D$10+$D$11)))","v":40}]
[null,"Bruttomonatsrente nach Abzug der Beiträge ",null,{"$f":"D6-D17-D18","v":829.10325},null,{"$f":"D6-F17-F18","v":801},null,{"$f":"D19-F19","v":28.103250000000003}]
[null,"Effektive Beitragsbelastung der monatl. Versorgungsbezüge ",null,{"$f":"1-D19/D6","v":0.17089675000000004},null,{"$f":"1-F19/D6","v":0.19899999999999995}]
[]
[]
[null,null,null,null,null,null,null,"Stand 20.11.2023"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Die Bezugsgröße (gem. § 18 Abs. 1 SGB IV) hatte im Zeitraum von 1990 bis 2019 einen Anstieg von im Durchschnitt 2,22% pro Jahr"]
["Jahr","Freibetrag",null,"Freibetrag"]
[2019,155.75,null,{"$f":"B51*120","v":18690}]
[2020,159.25,null,{"$f":"B52*120","v":19110}]
[2021,164.5,null,19740]
[2022,164.5,null,19740]
[2023,{"$f":"B54*1.0222","v":168.15190000000001},null,20178.228000000003]
[2024,176.75,null,21210]
[2025,180.67384999999999,null,21680.861999999997]
[2026,184.68480946999998,null,22162.177136399998]
[2027,188.78481224023398,null,22654.177468828078]
[2028,192.97583507196717,null,23157.10020863606]
[2029,197.25989861056485,null,23671.187833267781]
[2030,201.63906835971937,null,24196.688203166326]
[2031,206.11545567730514,null,24733.854681276614]
[2032,210.69121879334131,null,25282.946255200957]
[2033,215.36856385055347,null,25844.227662066416]
[2034,220.14974596803575,null,26417.969516164289]
[2035,225.03707032852614,null,27004.448439423137]
[2036,230.03289328981941,null,27603.947194778331]
[2037,235.13962352085341,null,28216.754822502407]
[2038,240.35972316301635,null,28843.166779561961]
[2039,245.69570901723532,null,29483.485082068237]
[2040,251.15015375741794,null,30138.018450890151]
[2041,256.7256871708326,null,30807.082460499911]
[2042,262.42499742602507,null,31490.999691123008]
[2043,268.25083236888281,null,32190.099884265939]
[2044,274.20600084747201,null,32904.720101696643]
[2045,280.29337406628588,null,33635.204887954307]
[2046,286.5158869705574,null,34381.906436466888]
[2047,292.87653966130375,null,35145.184759356453]
[2048,299.3783988417847,null,35925.407861014166]
[2049,{"$f":"B80*1.0222","v":306.02459929607232},null,36722.951915528676]
[2050,{"$f":"B81*1.0222","v":312.81834540044514},null,37538.20144805342]
[2051,319.76291266833505,null,38371.549520200206]
[2052,326.86164932957206,null,39223.397919548646]
[2053,334.11797794468856,null,40094.157353362629]
[2054,341.53539705506063,null,40984.247646607277]
[2055,349.11748286968299,null,41894.097944361958]
[2056,356.86789098938993,null,42824.146918726794]
[2057,364.79035816935436,null,43774.842980322523]
[2058,372.88870412071401,null,44746.644494485678]
[2059,{"$f":"B90*1.0222","v":381.16683335219386},null,45740.020002263263]
[2060,{"$f":"B91*1.0222","v":389.62873705261256},null,46755.448446313509]
[2061,398.27849501518057,null,47793.419401821666]
[2062,{"$f":"B93*1.0222","v":407.12027760451758},null,48854.433312542111]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}