{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Lump sum disability calculator"],"not_rendered":{"charts":0,"images":2,"macros":0,"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":"Instructions","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Calculator for Invalidity and Death Claims"]
[]
["Instructions"]
[]
[1,"Enter required information in blue fields: ",null,null,null,null,null,"Start Date","1995-05-16"]
[]
[]
[2,"White fields are working out fields and should be left unaltered",null,null,null,null,null,"No. of days from x to y",17.568899999999999]
[]
[3,"Results fields (ie.those fields that show the \"answer\" to required ",null,null,null,null,null,"Invalidity "]
[null,"information are in gold:",null,null,null,null,null,"Component",17159.650000000001]

{"sheet":"Lump sum disability calculator","index":1,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,2,2,7],[29,2,29,7],[3,2,3,7]]}
[]
[]
[null,null,"Lump sum disability superannuation benefits"]
[null,null,"To be used as in indication only. This calculation may differ between super funds. You should contact the relevant super fund for an actual calculation."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"D10","v":0},"D10"]
[null,null,"Benefit details",null,null,null,null,null,null,null,{"$f":"D11","v":0},"D11"]
[null,null,null,null,null,null,null,null,null,null,null,"1988-06-30"]
[null,null,"Amount of superannuation lump sum payment",null,null,null,null,null,null,null,{"$f":"IF(K8<K7,\"No\",\"Yes\")","v":"Yes"}]
[null,null,"Existing tax free component of superannuation lump sum",null,{"$f":"MIN(D10,D11+D22)","v":{"$error":"#VALUE!"}}]
[null,null,"Service period start date"]
[null,null,"Date member stopped being capable of being gainfully employed due to disability",null,null,null,null,null,null,{"$f":"IF(D12=\"\",0,D12)","v":0}]
[null,null,"Date of normal retirement (usually the 65th birthday)"]
[]
[]
[null,null,"Calculation"]
[]
[null,null,"Days from ceasing to be capable of being gainfully employed to normal retirement",{"$f":"IF(OR(D12=\"\",D13=\"\",D14=\"\"),\"\",IF(D12>D13,0,IF(D12>D14,0,MAX(0,D14-D13+1))))","v":""}]
[]
[null,null,"Days from start date to normal retirement",{"$f":"IF(OR(D12=\"\",D13=\"\",D14=\"\"),\"\",IF(D12>D14,0,MAX(1,D14-D12+1)))","v":""}]
[null,null,"Tax free component due to disability",{"$f":"IF(OR(D12=\"\",D13=\"\",D14=\"\"),\"\",IF(D21=0,0,MAX(0,SUM($D$10*$D$19)/$D$21)))","v":""}]
[]
[null,null,"Components of disability superannuation benefit"]
[]
[null,null,"Tax free component",{"$f":"IF(OR(D12=\"\",D13=\"\",D14=\"\"),\"\",IF(OR(D10=0,D10=\"\"),0,IF(D21=0,D11,MAX(0,IF(E11>=D10,D10,E11)))))","v":""}]
[null,null,"Taxable component",{"$f":"IF(OR(D12=\"\",D13=\"\",D14=\"\"),\"\",IF(D21=0,MAX(0,D10-D11),MAX(0,D10-D26)))","v":""}]
[]
[]
[null,null,"Important Disclaimer: This information is a summary based on OnePath's understanding of current legislation as at 1 July 2019. It is general in nature and may not be relevant to individual circumstances. You should not do or refrain from doing anything in reliance on this information without obtaining suitable professional advice. This calculator is for adviser use only and may not be reproduced without prior written permission from OnePath Life Limited. OnePath Technical Services is not a registered tax agent under the Tax Agent Services Act 2009. Your client should refer to a registered tax agent before relying on information in this publication that may impact their tax obligations, liabilities or entitlements.  "]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Start date",{"$f":"D10","v":0}]
[null,null,"Date of death",{"$f":"D11","v":0}]
[null,null,"1988-06-30",{"$f":"C40","v":32324}]
[null,null,"1983-06-30",{"$f":"C41","v":30497}]