{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["input details and see results","calcs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"input details and see results","index":0,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,9],[19,1,21,5],[29,1,29,9],[24,1,24,9],[25,1,25,9],[26,1,26,9]]}
[null,null,null,null,"Lump sum calculator"]
["This calculator is intended to help you decide how big a lump sum to take when you retire.  Please fill in the blue boxes to see the maximum tax-free lump sum you can have and the effect this would have on your pension.  You can also put numbers in the yellow boxes to see what effect a chosen lump sum (or a chosen pension) would have on your benefits.  "]
[]
["Which pension scheme are you in?",null,null,null,null,null,null,null,null,null,null,"classic"]
[null,null,null,null,null,null,null,null,null,null,null,"premium"]
["What is your pension entitlement?",null,null,null,null,"a year",null,null,null,null,null,"classic plus"]
[null,null,null,null,null,null,null,null,null,null,null,"nuvos"]
[{"$f":"IF(L10=1,\"How much is your automatic lump sum?\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(E4=\"classic\",OR(E8<E6*2.9,E8>E6*3)),calcs!A22,\"\")","v":""},null,null,null,null,null,"alpha"]
[null,null,null,null,{"$f":"IF(L10=1,\"Any WPS refund must be included in the above figure in order to provide accurate results (see note 6)\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E4=\"classic\",E4=\"classic plus\"),1,2)","v":2}]
[{"$f":"IF(L10=1,\"The maximum extra lump sum you can have is\",\"The maximum lump sum you can have is\")","v":"The maximum lump sum you can have is"},null,null,null,{"$f":"calcs!F11","v":0},{"$f":"IF(L10=1,\"   giving you a total lump sum of\",\"\")","v":""},null,null,{"$f":"calcs!F12","v":0}]
[]
[null,"and your pension would be reduced to",null,null,{"$f":"calcs!F13","v":0},"a year"]
[]
["Choose a different lump sum"]
[null,{"$f":"IF(L10=1,\"Your chosen extra lump sum of\",\"Your chosen lump sum of\")","v":"Your chosen lump sum of"},null,null,null,null,"your pension reduces to",null,{"$f":"IF(E16=\"\",\"\",calcs!F14)","v":""},"a year"]
[null,{"$f":"IF(E16>calcs!E11,calcs!A19,\"\")","v":""}]
["Choose how much pension you want"]
[null,"Your chosen annual pension of ",null,null,null,null,{"$f":"IF(L10=1,\"gives you an extra lump sum of\",\"gives you a lump sum of\")","v":"gives you a lump sum of"},null,{"$f":"IF(E19=\"\",\"\",calcs!F15)","v":""}]
[null,{"$f":"IF(AND(E19<>\"\",E19<calcs!E13),calcs!A20,IF(E19>E6,calcs!A21,\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(L10=1,\"and a total lump sum of\",\"\")","v":""},null,{"$f":"IF(E19=\"\",\"\",calcs!F16)","v":""}]
[]
["Notes"]
[]
[1,"In most cases, under current tax law your pension lump sum will be tax-free."]
[2,"Benefits for your dependants are based on your original pension entitlement and are not generally affected by the amount of lump sum you choose to take.  However, if you die aged over 75, the total of the pensions paid to your dependants cannot exceed your pension at the date of death."]
[3,"Your pension will increase every year in line with price inflation.  If you decide to take a higher lump sum, you will have a reduced pension throughout your retirement."]
[4,"You may wish to take financial advice to help you decide what to do."]
[5,"For any further information, please contact the scheme administrator."]
[{"$f":"IF(L10=1,\"6\",\"\")","v":""},{"$f":"IF(L10=1,\"If you are not married nor in a civil partnership when you retire you may be due a WPS refund.  The amount of any WPS refund needs to be added to your automatic lump sum in order to give an accurate result of the additional lump sum you are entitled to.\",\"\")","v":""}]
[{"$f":"calcs!A23","v":"printed on 25 Nov 2025"}]
["Version number: 1.01"]
["Review date: 02/09/2020"]

{"sheet":"calcs","index":1,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["scheme",{"$f":"'input details and see results'!E4","v":0},{"$f":"IF(B1=\"classic\",1,IF(B1=\"classic plus\",3,2))","v":2},{"$f":"TODAY()","v":"2025-11-25"}]
["pension",{"$f":"'input details and see results'!E6","v":0}]
["Auto LS",{"$f":"'input details and see results'!E8","v":0}]
["desired LS",{"$f":"'input details and see results'!E16","v":0}]
["desired pension",{"$f":"'input details and see results'!E19","v":0}]
[]
["calcs"]
[null,"classic","other","classic plus","actual","display"]
["assumed classic pension",{"$f":"B3/3","v":0},null,{"$f":"B3/3","v":0}]
["assumed premium pension",{"$f":"B2-B9","v":0},null,{"$f":"B2-D9","v":0}]
["max LS",{"$f":"B10*30/7+B9*33/14","v":0},{"$f":"B2*30/7","v":0},{"$f":"D10*30/7+D9*33/14","v":0},{"$f":"INDEX(B11:D11,$C$1)","v":0},{"$f":"E11","v":0}]
["total LS for classic",{"$f":"B11+B3","v":0},null,{"$f":"D11+B3","v":0},0,{"$f":"E12","v":0},null,"Fund value",0.25]
["reduced pension",{"$f":"B2-B11/12","v":0},{"$f":"B2-C11/12","v":0},{"$f":"B2-D11/12","v":0},0,{"$f":"E13","v":0},null,{"$f":"F13*20+MAX(F12,F11)","v":0},{"$f":"H13/4","v":0},{"$f":"IF(I13=F12,\"OK\",\"problem\")","v":"OK"}]
["Pension for desired LS",{"$f":"B2-B4/12","v":0},{"$f":"B2-B4/12","v":0},{"$f":"B2-B4/12","v":0},0,{"$f":"IF(OR(E14>B2,E14<E13),\"N/A\",E14)","v":0}]
["LS for desired pension",{"$f":"(B2-B5)*12","v":0},{"$f":"(B2-B5)*12","v":0},{"$f":"(B2-B5)*12","v":0},0,{"$f":"IF(OR(E15<0,E15>E11),\"N/A\",E15)","v":0}]
["Total LS",{"$f":"B3+B15","v":0},null,{"$f":"B3+D15","v":0},0,{"$f":"IF(F15=E15,E16,\"N/A\")","v":0}]
[]
["Error messages etc"]
[{"$f":"\"Your chosen lump sum cannot be more than \"&TEXT(E11,\"£#,###.##\")","v":"Your chosen lump sum cannot be more than £."}]
[{"$f":"\"You cannot reduce your pension below \"&TEXT(E13,\"£#,###.##\") &\" a year\"","v":"You cannot reduce your pension below £. a year"}]
[{"$f":"IF(C1=2,\"You cannot increase your pension above \" &TEXT(B2,\"£#,###.##\"),\"If you want to increase your pension and take a smaller lump sum, ask your pension administrator about inverse commutation\")","v":"You cannot increase your pension above £."}]
[{"$f":"\"   Your automatic lump sum is usually 3 times your pension\"","v":"   Your automatic lump sum is usually 3 times your pension"}]
[{"$f":"\"printed on \" &TEXT(D1,\"dd mmm yyyy\")","v":"printed on 25 Nov 2025"}]