{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Beräkning"],"not_rendered":{"charts":0,"images":0,"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":"Beräkning","index":0,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,7,2,8],[2,5,2,6],[2,3,2,4],[2,1,2,2],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8]]}
[null,null,null,null,null,null,null,null,null,null,"Pensionsålder",65,null,"Nettoränta 1",{"$f":"L2-L4-L5","v":1.125E-2}]
["Utbetalningstabell för optimering",null,null,null,null,null,null,null,null,null,"Avkastning 1",0.02,null,"Nettoränta 2",{"$f":"L3-L4-L5","v":5.1249999999999997E-2}]
["Mer i kronor",20,null,30,null,40,null,50,null,null,"Avkastning 2",0.06]
[null,"avk. 1","avk. 2","avk. 1","avk. 2","avk. 1","avk. 2","avk. 1","avk. 2",null,"Avkastningsskatt",3.7499999999999999E-3]
[1000,{"$f":"-GeoSum($O$1,($L$1-B$3)*12)*B14/GeoSum($O$1,-$L$6*12)","v":999.99999999999989},{"$f":"-GeoSum($O$2,($L$1-B$3)*12)*C14/GeoSum($O$2,-$L$6*12)","v":999.99999999999955},{"$f":"-GeoSum($O$1,($L$1-D$3)*12)*D14/GeoSum($O$1,-$L$6*12)","v":1000.0000000000006},{"$f":"-GeoSum($O$2,($L$1-D$3)*12)*E14/GeoSum($O$2,-$L$6*12)","v":999.99999999999955},{"$f":"-GeoSum($O$1,($L$1-F$3)*12)*F14/GeoSum($O$1,-$L$6*12)","v":1000.0000000000003},{"$f":"-GeoSum($O$2,($L$1-F$3)*12)*G14/GeoSum($O$2,-$L$6*12)","v":1000.0000000000001},{"$f":"-GeoSum($O$1,($L$1-H$3)*12)*H14/GeoSum($O$1,-$L$6*12)","v":999.99999999999989},{"$f":"-GeoSum($O$2,($L$1-H$3)*12)*I14/GeoSum($O$2,-$L$6*12)","v":1000.0000000000001},null,"Driftbelastning",5.0000000000000001E-3]
[2000,{"$f":"-GeoSum($O$1,($L$1-B$3)*12)*B15/GeoSum($O$1,-$L$6*12)","v":1999.9999999999998},{"$f":"-GeoSum($O$2,($L$1-B$3)*12)*C15/GeoSum($O$2,-$L$6*12)","v":1999.9999999999991},{"$f":"-GeoSum($O$1,($L$1-D$3)*12)*D15/GeoSum($O$1,-$L$6*12)","v":2000.0000000000011},{"$f":"-GeoSum($O$2,($L$1-D$3)*12)*E15/GeoSum($O$2,-$L$6*12)","v":1999.9999999999991},{"$f":"-GeoSum($O$1,($L$1-F$3)*12)*F15/GeoSum($O$1,-$L$6*12)","v":2000.0000000000007},{"$f":"-GeoSum($O$2,($L$1-F$3)*12)*G15/GeoSum($O$2,-$L$6*12)","v":2000.0000000000002},{"$f":"-GeoSum($O$1,($L$1-H$3)*12)*H15/GeoSum($O$1,-$L$6*12)","v":1999.9999999999998},{"$f":"-GeoSum($O$2,($L$1-H$3)*12)*I15/GeoSum($O$2,-$L$6*12)","v":2000.0000000000002},null,"Antal år utbetalning",20]
[5000,{"$f":"-GeoSum($O$1,($L$1-B$3)*12)*B16/GeoSum($O$1,-$L$6*12)","v":4999.9999999999982},{"$f":"-GeoSum($O$2,($L$1-B$3)*12)*C16/GeoSum($O$2,-$L$6*12)","v":5000},{"$f":"-GeoSum($O$1,($L$1-D$3)*12)*D16/GeoSum($O$1,-$L$6*12)","v":4999.9999999999982},{"$f":"-GeoSum($O$2,($L$1-D$3)*12)*E16/GeoSum($O$2,-$L$6*12)","v":5000},{"$f":"-GeoSum($O$1,($L$1-F$3)*12)*F16/GeoSum($O$1,-$L$6*12)","v":5000},{"$f":"-GeoSum($O$2,($L$1-F$3)*12)*G16/GeoSum($O$2,-$L$6*12)","v":5000},{"$f":"-GeoSum($O$1,($L$1-H$3)*12)*H16/GeoSum($O$1,-$L$6*12)","v":5000},{"$f":"-GeoSum($O$2,($L$1-H$3)*12)*I16/GeoSum($O$2,-$L$6*12)","v":4999.9999999999991}]
[10000,{"$f":"-GeoSum($O$1,($L$1-B$3)*12)*B17/GeoSum($O$1,-$L$6*12)","v":9999.9999999999964},{"$f":"-GeoSum($O$2,($L$1-B$3)*12)*C17/GeoSum($O$2,-$L$6*12)","v":10000},{"$f":"-GeoSum($O$1,($L$1-D$3)*12)*D17/GeoSum($O$1,-$L$6*12)","v":9999.9999999999964},{"$f":"-GeoSum($O$2,($L$1-D$3)*12)*E17/GeoSum($O$2,-$L$6*12)","v":10000},{"$f":"-GeoSum($O$1,($L$1-F$3)*12)*F17/GeoSum($O$1,-$L$6*12)","v":10000},{"$f":"-GeoSum($O$2,($L$1-F$3)*12)*G17/GeoSum($O$2,-$L$6*12)","v":10000},{"$f":"-GeoSum($O$1,($L$1-H$3)*12)*H17/GeoSum($O$1,-$L$6*12)","v":10000},{"$f":"-GeoSum($O$2,($L$1-H$3)*12)*I17/GeoSum($O$2,-$L$6*12)","v":10000.000000000002}]
[]
[]
["Sparande",null,null,null,null,null,null,null,null,null,"Skattebelastning för 2020"]
["Mer i kronor",20,null,30,null,40,null,50,null,null,"P-skatt",7.5000000000000002E-4]
[null,"avk. 1","avk. 2","avk. 1","avk. 2","avk. 1","avk. 2","avk. 1","avk. 2",null,"K-skatt",3.7499999999999999E-3]
[1000,306.36856429333523,74.532382563380395,418.2991780283196,133.03117559341121,621.24647752588282,253.94793463201557,1097.2622779773883,566.09987699714429]
[2000,612.73712858667045,149.06476512676079,836.5983560566392,266.06235118682241,1242.4929550517656,507.89586926403115,2194.5245559547766,1132.1997539942886]
[5000,1531.8428214666758,372.66191281690215,2091.4958901415962,665.15587796705631,3106.2323876294131,1269.7396731600777,5486.3113898869424,2830.499384985721]
[10000,3063.6856429333516,745.32382563380429,4182.9917802831924,1330.3117559341126,6212.4647752588262,2539.4793463201554,10972.622779773885,5660.9987699714429]