{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Contents","Guidance Notes","Member Details"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":"Contents","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,22,17],[2,1,4,3],[2,4,4,17],[5,1,12,17],[14,1,15,17],[16,1,19,17]]}
[]
[]
[null,null,null,null,"Commutation Calculator (including Individual Protection 2016) 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer"]
[]
[null,"Please note that the illustration is not a guarantee or a statement of your legal entitlement. The calculator is NOT intended to provide you with financial advice.  If you require financial advice, you should contact an independent financial advisor.  "]
[]
[]
[]
[null,"Please refer to the SPPA website for contact information or any other details of benefits available through the NHS Superannuation Scheme (Scotland) or Scottish Teachers' Superannuation Scheme (STSS)."]

{"sheet":"Guidance Notes","index":1,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":true,"merged":[[33,1,35,14],[0,1,2,14],[4,1,23,14],[26,1,27,14],[28,1,31,14],[32,1,32,14]]}
[null,"Guidance Notes"]
[]
[]
[]
[null,"Understanding your results\n\nThis calculator is solely for guidance purposes and is an estimate only.  It is not a statement of your legal entitlement and is not intended to provide you with financial advice.  While every care has been taken in the preparation of this calculator the Scottish Public Pensions Agency will accept no responsibility for the accuracy of the information it provides.  If you require financial advice, you should contact an authorised independent financial adviser.  \n\nThis calculator estimates the maximum tax free lump sum you can take should you wish to exhange some of your pension for a tax free lump sum (commutation).  Once  you have completed all the relevant information your estimated benefits will be shown under \"Details after Maimum Commutation\".  If you do not complete all of the necessary information your estimate will not work.  \n\nIf you hold Individual Protection, you can select this option under LTA to estimate your details based on your Individual Protection amount.  You can also estimate specific figures should you wish to commute an amount up to the permitted maximum.  If your estimate exceeds the permitted maximum, you will be shown the restricted and the unrestricted amounts.\n\nPLEASE NOTE, the NHS and STSS Regulations do not allow members to exceed the maximum tax free lump sum available to them and will restrict any benefits accordingly.\n\nEach page allows you to go back to previous stages if you wish by simply clicking on the relevant box to where you wish to go.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer"]
[]
[null,"This calculator is intended for illustrative purposes only. This is not a statement of your legal entitlement.  While every care has been taken in the preparation of this ready reckoner the Scottish Public Pensions Agency will accept no responsibility for the accuracy of the information it provides."]
[]
[]
[]
[]
[null,"Please refer to the SPPA website for contact information or any other details of benefits available through the NHS Superannuation Scheme (Scotland) or Scottish Teachers' Superannuation Scheme (STSS)."]

{"sheet":"Member Details","index":2,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":true,"merged":[[26,1,27,7],[28,1,29,7],[30,1,30,7],[31,1,31,7],[10,5,13,5],[10,7,13,7]]}
[]
[null,null,"Commutation Calculator (including Individual Protection 2016) 2022"]
[null,null,null,null,null,null,null,null,1,1]
[]
[null,null,"Basic Pension ",null,"Natural LTA %","LTA to be used",null,"Maximum or specific amount?",null,{"$f":"IF(AND(H8>0,H8>C13),1,0)","v":0}]
[null,null,"Basic Lump Sum (if applicable) ",null,{"$f":"J16","v":0}]
[null,null,"Tax Year ","21/22",null,{"$f":"IF(I3=1,\"\",\"Individual Protection Amount\")","v":""},null,{"$f":"IF(J3=1,\"\",\"Specific Amount to commute\")","v":""}]
[null,null,"Benefits Taken Elsewhere ",null,"%"]
[]
[null,null,{"$f":"IF(C11<L15,\"LTA Restricted\",\"\")","v":""},{"$f":"IF(C11<L15,\"Unrestricted\",\"\")","v":""},null,{"$f":"IF(I3=2*(AND(F8=\"\")),\"Please type in amount!\",\"\")","v":""},null,{"$f":"IF(J3=2*(AND(H8=\"\")),\"Please type in amount!\",\"\")","v":""}]
[null,"Max Lump Sum Available",{"$f":"IF(L15>(L22/4),((L22/4)),L15)","v":0},{"$f":"IF(L15>C11,L15,\"\")","v":""},null,null,null,{"$f":"IF((AND(H8<>\"\",J3=2,C13<H8)),CONCATENATE(\"WARNING: CANNOT COMMUTE MORE THAN \",TEXT(C13,\"£0.00\")),\"\")","v":""}]
[]
[null,"Max Commutable Pension",{"$f":"ROUNDDOWN((C11-D6)/12,0)","v":0},{"$f":"IF(L15>C11,(L15-D6)/12,\"\")","v":""}]
[null,"Lump Sum Commuted ",{"$f":"C13*12","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D5*20+D6","v":0},null,{"$f":"ROUNDDOWN((((D5*20)+(D6*(20/12)))/4.6667),0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(J15/L21)","v":0}]
[null,"Details after Maximum Commutation",null,null,null,null,{"$f":"IF(J3=2,\"Details after specific amount\",\"\")","v":""}]
[null,{"$f":"IF(C11<L15,\"LTA Restricted\",\"\")","v":""},null,{"$f":"IF(C11<L15,\"Unrestricted\",\"\")","v":""},null,null,null,null,null,{"$f":"C20*20+C21","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(J18/L21)","v":0}]
[null,"Pension",{"$f":"D5-C13","v":0},{"$f":"IF(L15>C11,ROUND(D5-((L15-D6)/12),2),\"\")","v":""},null,null,{"$f":"IF(J3=2,\"Pension\",\"\")","v":""},{"$f":"IF(J3=2,D5-H8,\"\")","v":""},null,null,null,null,null,"Benefits previously taken"]
[null,"Lump Sum",{"$f":"C14+D6","v":0},{"$f":"IF(L15>C11,L15,\"\")","v":""},null,null,{"$f":"IF(J3=2,\"Lump Sum\",\"\")","v":""},{"$f":"IF(J3=2,(D6+(H8*12)),\"\")","v":""},null,null,null,{"$f":"IF(I3=2,F8,VLOOKUP(D7,K34:M47,2,FALSE))","v":1073100},null,{"$f":"D8/100*L21","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"H20*20+H21","v":{"$error":"#VALUE!"}},null,{"$f":"L21-N21","v":1073100}]
[null,"LTA %",{"$f":"J19","v":0},null,null,null,{"$f":"IF(J3=2, \"LTA %\", \" \")","v":" "},{"$f":"IF(J3=2,J22/L21, \" \")","v":" "},null,{"$f":"J22/L21","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,"Disclaimer"]
[]
[null,"This calculator is intended for illustrative purposes only. This is not a statement of your legal entitlement.  While every care has been taken in the preparation of this ready reckoner the Scottish Public Pensions Agency will accept no responsibility for the accuracy of the information it provides."]
[]
[null,"This calculator can be used to estimate the maximum lump sum available after commutation for members of the NHS and Teachers Pension Schemes (Scotland)."]
[null,"Please refer to the SPPA website for contact information or any other details of benefits available through the NHS or Teachers Pension Schemes (Scotland)."]
[]
[null,null,null,null,null,null,null,null,null,null,"12/13",1500000,2013]
[null,null,null,null,null,null,null,null,null,null,"13/14",1500000,2014]
[null,null,null,null,null,null,null,null,null,null,"14/15",1250000,2015]
[null,null,null,null,null,null,null,null,null,null,"15/16",1250000,2016]
[null,null,null,null,null,null,null,null,null,null,"16/17",1000000,2017]
[null,null,null,null,null,null,null,null,null,null,"17/18",1000000,2018]
[null,null,null,null,null,null,null,null,null,null,"18/19",1030000,2019]
[null,null,null,null,null,null,null,null,null,null,"19/20",1055000,2020]
[null,null,null,null,null,null,null,null,null,null,"20/21",1073100,2021]
[null,null,null,null,null,null,null,null,null,null,"21/22",1073100,2022]
[null,null,null,null,null,null,null,null,null,null,"22/23",1073100,2023]
[null,null,null,null,null,null,null,null,null,null,"23/24",1073100,2024]
[null,null,null,null,null,null,null,null,null,null,"24/25",1073100,2025]
[null,"                                                  ",null,null,null,null,null,null,null,null,"25/26",1073100,2026]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,50]