{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ZAL"],"not_rendered":{"charts":0,"images":1,"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":"ZAL","index":0,"n_rows":63,"n_cols":19,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["TPD Personal Cover Limits ",null,null,"All for personal covers only"]
["This calculator should only be used when the income supports a sum insured of more than $2.5m on a Multiples of Income + Additional Considerations",null,null,"Comments"]
["basis (please refer to the Adviser Guide for details)."]
["This calculator does not consider any Continuous Care Option quoted or retained. "]
[]
["Customer date of birth (dd/mm/yyyy):","1982-10-01",null,"ANB",{"$f":"DATEDIF(B6,TODAY(),\"Y\")+1","v":44}]
[]
["Annual income (incl. Super):",230000]
["Years remaining to age 65:",{"$f":"IFERROR(66-E6,\"\")","v":22}]
["Derived income to age 65:",{"$f":"IF(B9=\"\",\"\",B8*B9)","v":5060000}]
[]
[]
["Proposed working definition TPD (personal purpose only):",2000000]
[]
["Retained TPD (personal purpose):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of IP payments possible to end of benefit period for different WP and BP"]
["Retained TPD (business purpose):",null,null,null,null,null,null,null,null,null,null,null,null,"BP/WP","30 days","60 days","90 days","1 year","2 years"]
[null,null,null,null,null,null,null,null,null,null,null,"To Age 65",null,"1 year",1,1,1,1,1]
["Proposed monthly IP (including any Super Contribution Option)",null,null,null,null,null,null,null,null,null,null,null,null,"2 years",2,2,2,2,2]
["Benefit Period:","To Age 65",null,null,null,null,null,null,null,null,null,null,null,"5 years",5,5,5,5,5]
["Waiting period","90 days",null,null,null,null,null,null,null,null,null,"30 days",null,"To Age 65",{"$f":"66-$E$6","v":22},{"$f":"66-$E$6","v":22},22,{"$f":"66-$E$6-1","v":21},{"$f":"66-$E$6-2","v":20}]
["Total to expiry",{"$f":"IFERROR(IF(OR(B19=\"\",B19=0),\"$0\",IF(OR(B20=\"\",B21=\"\"),\"Require BP & WP to calculate\",B19*12*INDEX($O$18:$S$22,MATCH(B20,$N$18:$N$22,0),MATCH(B21,$O$17:$S$17,0)))),\"Error, please contact Zurich\")","v":"$0"},null,null,null,null,null,null,null,null,null,"60 days"]
[null,null,null,null,null,null,null,null,null,null,null,"90 days"]
["Retained monthly IP (including any Super Contribution Option)",null,null,null,null,null,null,null,null,null,null,"1 year"]
["Benefit period:","To Age 65",null,null,null,null,null,null,null,null,null,"2 years"]
["Waiting period","90 days"]
["Total to expiry",{"$f":"IFERROR(IF(OR(B24=\"\",B24=0),\"$0\",IF(OR(B25=\"\",B26=\"\"),\"Require BP & WP to calculate\",B24*12*INDEX($O$18:$S$22,MATCH(B25,$N$18:$N$22,0),MATCH(B26,$O$17:$S$17,0)))),\"Error, please contact Zurich\")","v":"$0"}]
[]
[]
["Income to retirement",{"$f":"B10","v":5060000}]
["Insured amount (including TPD and IP)",{"$f":"IFERROR(B13+B15+B17+B22+B27,\"Waiting for information above\")","v":2000000}]
[]
["Income to retirement vs insured amount",{"$f":"IF(ISNUMBER(B31)=FALSE,\"Waiting for information above\",(IF(B8=\"\",\"\",IF(B13=0,\"Calculator is only required if TPD cover is being proposed\",_xlfn.XLOOKUP(M53,$D$56:$D$63,$M$56:$M$63,,0)))))","v":"Sums insured provided are within limits"}]
["Action:",{"$f":"IF(OR(B22=\"Require BP & WP to calculate\",B27=\"Require BP & WP to calculate\"),\"Complete all fields above\",IF(B33=\"Complete all fields\",\"Complete all fields\",IF(B33=\"Calculator is only required if TPD cover is being proposed\",\"Please add a sum insured in the 'Proposed TPD' field above\",IF(B8=\"\",\"\",_xlfn.XLOOKUP(M53,$D$56:$D$63,$I$56:$I$63,,0)))))","v":"No action"}]
[]
[]
[]
["Today",{"$f":"TODAY()","v":"2026-03-17"}]
[]
["PDR number","JFUU-021914-2024"]
[null,null,null,"Step 1 - cap the TPD sum insured to the greater of $2.5m and the amount of TPD needed to replace income to age 65",null,null,null,null,null,null,null,null,{"$f":"MAX(2500000-B15,B10-B15-B22-B27)","v":5060000},null,"max(2.5m- retained personal TPD, income to retirement - retained personal TPD - retained IP)"]
[]
[null,null,null,"Step 2 - max $5m industry cap on TPD",null,null,null,null,null,null,null,null,{"$f":"MAX(MIN(M41,5000000-SUM(B15,B17)),0)","v":5000000},null,"min(step1, 5m - retained TPD)"]
[]
[null,null,null,"Step 3 - Cover requested and allowed under normal TPD",null,null,null,null,null,null,null,null,{"$f":"MIN(M43,B13)","v":2000000},{"$f":"IF(M46>0,MAX(B13-N46,0),M45)","v":2000000}]
[null,null,null,"Step 4 - Additional cover allowed under CCO",null,null,null,null,null,null,null,null,{"$f":"MIN(B13-M45,5000000-SUM(B15,B17)-M45)","v":0},{"$f":"IF(M46>0,MAX(M46,250000),0)","v":0},"min(SI requested - step 3, 5m - retained TPD - step 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"minimum sum insured for CCO is $250k"]
[null,null,null,"Cover requested and not allowed",null,null,null,null,null,null,null,null,{"$f":"MAX(0,B13-M45-M46)","v":0}]
[]
[]
[null,null,null,"> 2.5m/income cap",null,null,null,null,null,null,null,null,{"$f":"B13>M41","v":false}]
[null,null,null,"> 5m industry cap",null,null,null,null,null,null,null,null,{"$f":"SUM(B13,B15,B17)>5000000","v":false}]
[null,null,null,"Outcome",null,null,null,null,null,null,null,null,{"$f":"IF(AND(M45=0,M46>0,M46<250000),D60,IF(AND(M45=0,M46>=250000,M48=0),D61,IF(AND(M45=0,M46>=250000,M48>0),D62,IF(AND(M45=0,M46=0),D63,IF(AND(M51=FALSE,M52=FALSE),D56,IF(AND(M51=TRUE,M52=FALSE),D57,IF(AND(M51=TRUE,M52=TRUE),D58,IF(AND(M51=FALSE,M52=TRUE),D59))))))))","v":"<2.5m/income cap, <5m industry cap"}]
[]
[null,null,null,"Outcome",null,null,null,null,"Action",null,null,null,"Income to retirement vs insured amount"]
[null,null,null,"<2.5m/income cap, <5m industry cap",null,null,null,null,"No action",null,null,null,"Sums insured provided are within limits"]
[null,null,null,">2.5m/income cap, <5m industry cap",null,null,null,null,"Consider taking part of the proposed TPD in Continuous Care Option",null,null,null,{"$f":"\"Based on the information provided, the maximum allowable new TPD cover is \"&\"$\"&TEXT(M43,\"#,##0\")&\". Consider reducing TPD and adding Continuous Care Option of \"&\"$\"&TEXT(N46,\"#,##0\")","v":"Based on the information provided, the maximum allowable new TPD cover is $5,000,000. Consider reducing TPD and adding Continuous Care Option of $0"}]
[null,null,null,">2.5m/income and >5m industry cap",null,null,null,null,"Consider taking part of the proposed TPD in Continuous Care Option",null,null,null,{"$f":"\"Based on the information provided, the maximum allowable new TPD cover is \"&\"$\"&TEXT(M43,\"#,##0\")&\". Consider reducing TPD and adding Continuous Care Option of \"&\"$\"&TEXT(N46,\"#,##0\")","v":"Based on the information provided, the maximum allowable new TPD cover is $5,000,000. Consider reducing TPD and adding Continuous Care Option of $0"}]
[null,null,null,"<2.5m/income cap, >5m industry cap",null,null,null,null,"Reduce the proposed TPD",null,null,null,{"$f":"\"Based on the information provided, the maximum allowable new TPD cover is \"&\"$\"&TEXT(M43,\"#,##0\")&\". Consider reducing TPD to be within the allowed limits\"","v":"Based on the information provided, the maximum allowable new TPD cover is $5,000,000. Consider reducing TPD to be within the allowed limits"}]
[null,null,null,"The maximum permitted amount of TPD is already in place, new TPD quoted <250k",null,null,null,null,"Additional cover can only be taken in Continuous Care Option",null,null,null,{"$f":"\"The maximum permitted amount of TPD is already in place. Consider reducing retained TPD and adding Continuous Care Option of \"&\"$\"&TEXT(N46,\"#,##0\")&\"\"","v":"The maximum permitted amount of TPD is already in place. Consider reducing retained TPD and adding Continuous Care Option of $0"}]
[null,null,null,"The maximum permitted amount of TPD is already in place, new TPD can be fully taken in CCO",null,null,null,null,"Additional cover can only be taken in Continuous Care Option",null,null,null,{"$f":"\"The maximum permitted amount of TPD is already in place. Consider taking Continuous Care Option of \"&\"$\"&TEXT(N46,\"#,##0\")&\"\"","v":"The maximum permitted amount of TPD is already in place. Consider taking Continuous Care Option of $0"}]
[null,null,null,"The maximum permitted amount of TPD is already in place, new TPD can be partially taken in CCO",null,null,null,null,"Additional cover can only be taken in Continuous Care Option",null,null,null,{"$f":"\"The maximum permitted amount of TPD is already in place. Consider taking Continuous Care Option of \"&\"$\"&TEXT(N46,\"#,##0\")&\"\"","v":"The maximum permitted amount of TPD is already in place. Consider taking Continuous Care Option of $0"}]
[null,null,null,"The maximum permitted amount of TPD is already in place, no additional TPD may be proposed",null,null,null,null,"No additional TPD may be proposed",null,null,null,{"$f":"\"The maximum permitted amount of TPD is already in place\"","v":"The maximum permitted amount of TPD is already in place"}]