{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["delningstal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":"delningstal","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,4,5,6],[5,0,7,0]]}
[null,"För detaljer om beräkningen se avsnittet \"Delningstal i premiepensionen\" i Orange rapport:'"]
[null,"A. Bilaga Beräkningsfaktorer | Pensionsmyndigheten"]
[]
[null,"Födelsedatum","1959-01-01"]
[null,"Datum för pensionering/omräkning","2025-01-01",null,"Celler med orange färg innehåller input till beräkningarna"]
[null,"Pensionsålder/ålder vid omräkning",{"$f":"dur(C4,datum_pensionering)","v":66},"år"]
[null,"Födelseår",{"$f":"YEAR(C4)","v":1959}]
[null,"Kohort makehamparametrar",{"$f":"IF(C7<=1939,1930,IF(C7>=1950,IF(C7>=1960,IF(C7>=1970,1970,1960),1950),1940))","v":1950}]
[null,"Förskottsränta",1.7500000000000002E-2]
[]
[null,"Dödlighets- och ränteparametrar för alla kohorter"]
[null,"Födelsedecenium","A","B","C","K","W","Dödlighetsbelastning",null,"Räntebelastning för kostnader"]
[null,1930,6.0000000000000002E-5,3.8850000000000002E-7,0.14119999999999999,0.04,97,0,null,1E-3]
[null,1940,2.0400000000000001E-3,3.2070000000000001E-7,0.1426,0.04,97,0,null,1E-3]
[null,1950,4.2700000000000004E-3,1.5590000000000001E-7,0.14949999999999999,0.04,97,0,null,1E-3]
[null,1960,3.6700000000000001E-3,6.9650000000000005E-8,0.15740000000000001,0.04,97,0,null,1E-3]
[null,1970,2.5400000000000002E-3,3.5740000000000001E-8,0.1638,0.04,97,0,null,1E-3]
[]
[null,"Makeham- och ränteparametrar för aktuell kohort"]
[null,"Födelsedecenium","A","B","C","K","W","Dödlighetsbelastning","R","Räntebelastning för kostnader"]
[null,{"$f":"C8","v":1950},{"$f":"SUMPRODUCT(($B21=$B$13:$B$17)*(C$20=$C$12:$L$12)*($C$13:$L$17))","v":4.2700000000000004E-3},1.5590000000000001E-7,0.14949999999999999,0.04,97,0,{"$f":"C9","v":1.7500000000000002E-2},{"$f":"SUMPRODUCT(($B21=$B$13:$B$17)*(J$20=$C$12:$L$12)*($C$13:$L$17))","v":1E-3}]
[]
[null,"Delningstal utan efterlevandeskydd",{"$f":"n1x(pensionsålder,a_makeham,b_makeham,c_makeham,w_makeham,k_makeham,belastn_dödlighet,förskottsränta,driftavdrag,0)/d1x(pensionsålder,a_makeham,b_makeham,c_makeham,w_makeham,k_makeham,belastn_dödlighet,förskottsränta,driftavdrag,0)","v":17.859329155418795}]