{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Illustration Calculator","Plan Calculations"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Illustration Calculator","index":0,"n_rows":105,"n_cols":8,"rows_kept":105,"cut":false,"hidden":false,"merged":[[10,7,10,8],[11,7,11,8],[1,1,1,9],[2,1,2,9],[4,7,4,8],[5,7,5,8],[7,7,7,8],[8,7,8,8]]}
[]
[null,"ILLUSTRATION TOOL"]
[null,"For Agent Use Only"]
[]
[null,"Plan # Selection",null,"Age","Year","Exp. Annuity Payment",null,"Total Payment"]
[null,"Plan # 5",null,{"$f":"B9","v":40},1,{"$f":"_xlfn.IFNA(IF(E6=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E6+1, FALSE)), \"Something is wrong\")","v":0},null,{"$f":"SUM(F6:F105)","v":440000}]
[null,null,null,{"$f":"IF(E7=\"\", \"\", D6+1)","v":41},{"$f":"IF(E6=\"\", \"\", IF($B$9+E6-1>=110, \"\", E6+1))","v":2},{"$f":"_xlfn.IFNA(IF(E7=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E7+1, FALSE)), \"Something is wrong\")","v":0}]
[null,"Current Age",null,{"$f":"IF(E8=\"\", \"\", D7+1)","v":42},{"$f":"IF(E7=\"\", \"\", IF($B$9+E7-1>=110, \"\", E7+1))","v":3},{"$f":"_xlfn.IFNA(IF(E8=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E8+1, FALSE)), \"Something is wrong\")","v":0},null,"Total Years of Payment"]
[null,40,null,43,4,{"$f":"_xlfn.IFNA(IF(E9=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E9+1, FALSE)), \"Something is wrong\")","v":0},null,{"$f":"COUNTIF(F6:F105, \">0\")","v":20}]
[null,null,null,44,5,{"$f":"_xlfn.IFNA(IF(E10=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E10+1, FALSE)), \"Something is wrong\")","v":0}]
[null,{"$f":"IF(OR(B6=\"Plan # 1\", B6=\"Plan # 3\", B6=\"Plan # 5\", B6=\"Plan # 6\", B6=\"plan # 7\"), \"Age Payments Begin\", \"\")","v":"Age Payments Begin"},null,45,6,{"$f":"_xlfn.IFNA(IF(E11=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E11+1, FALSE)), \"Something is wrong\")","v":19000},null,"Age of Last Payment"]
[null,45,null,46,7,{"$f":"_xlfn.IFNA(IF(E12=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E12+1, FALSE)), \"Something is wrong\")","v":19000},null,{"$f":"IF(OR(B6=\"Plan # 1\", B6=\"plan # 5\", B6=\"plan # 6\", B6=\"plan # 7\"), B12+B15-1, IF(B6=\"Plan # 2\", 94, IF(B6=\"Plan # 3\", 110, 100)))","v":64}]
[null,null,null,47,8,{"$f":"_xlfn.IFNA(IF(E13=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E13+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,{"$f":"IF(OR(B6=\"Plan # 1\", B6=\"Plan # 5\", B6=\"Plan # 6\", B6=\"plan # 7\"), \"Years of Payment\", \"\")","v":"Years of Payment"},null,48,9,{"$f":"_xlfn.IFNA(IF(E14=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E14+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,20,null,49,10,{"$f":"_xlfn.IFNA(IF(E15=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E15+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,null,null,50,11,{"$f":"_xlfn.IFNA(IF(E16=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E16+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,null,null,51,12,{"$f":"_xlfn.IFNA(IF(E17=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E17+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,null,null,52,13,{"$f":"_xlfn.IFNA(IF(E18=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E18+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,null,null,53,14,{"$f":"_xlfn.IFNA(IF(E19=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E19+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,null,null,54,15,{"$f":"_xlfn.IFNA(IF(E20=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E20+1, FALSE)), \"Something is wrong\")","v":19000}]
[null,null,null,55,16,{"$f":"_xlfn.IFNA(IF(E21=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E21+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,56,17,{"$f":"_xlfn.IFNA(IF(E22=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E22+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,57,18,{"$f":"_xlfn.IFNA(IF(E23=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E23+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,58,19,{"$f":"_xlfn.IFNA(IF(E24=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E24+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,59,20,{"$f":"_xlfn.IFNA(IF(E25=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E25+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,60,21,{"$f":"_xlfn.IFNA(IF(E26=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E26+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,61,22,{"$f":"_xlfn.IFNA(IF(E27=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E27+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,62,23,{"$f":"_xlfn.IFNA(IF(E28=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E28+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,63,24,{"$f":"_xlfn.IFNA(IF(E29=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E29+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,64,25,{"$f":"_xlfn.IFNA(IF(E30=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E30+1, FALSE)), \"Something is wrong\")","v":25000}]
[null,null,null,65,26,{"$f":"_xlfn.IFNA(IF(E31=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E31+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,66,27,{"$f":"_xlfn.IFNA(IF(E32=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E32+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,67,28,{"$f":"_xlfn.IFNA(IF(E33=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E33+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,68,29,{"$f":"_xlfn.IFNA(IF(E34=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E34+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,69,30,{"$f":"_xlfn.IFNA(IF(E35=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E35+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,70,31,{"$f":"_xlfn.IFNA(IF(E36=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E36+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,71,32,{"$f":"_xlfn.IFNA(IF(E37=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E37+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,72,33,{"$f":"_xlfn.IFNA(IF(E38=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E38+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,73,34,{"$f":"_xlfn.IFNA(IF(E39=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E39+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,74,35,{"$f":"_xlfn.IFNA(IF(E40=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E40+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,75,36,{"$f":"_xlfn.IFNA(IF(E41=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E41+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,76,37,{"$f":"_xlfn.IFNA(IF(E42=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E42+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,77,38,{"$f":"_xlfn.IFNA(IF(E43=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E43+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,78,39,{"$f":"_xlfn.IFNA(IF(E44=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E44+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,79,40,{"$f":"_xlfn.IFNA(IF(E45=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E45+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,80,41,{"$f":"_xlfn.IFNA(IF(E46=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E46+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,81,42,{"$f":"_xlfn.IFNA(IF(E47=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E47+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,82,43,{"$f":"_xlfn.IFNA(IF(E48=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E48+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,83,44,{"$f":"_xlfn.IFNA(IF(E49=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E49+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,84,45,{"$f":"_xlfn.IFNA(IF(E50=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E50+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,85,46,{"$f":"_xlfn.IFNA(IF(E51=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E51+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,86,47,{"$f":"_xlfn.IFNA(IF(E52=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E52+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,87,48,{"$f":"_xlfn.IFNA(IF(E53=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E53+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,88,49,{"$f":"_xlfn.IFNA(IF(E54=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E54+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,89,50,{"$f":"_xlfn.IFNA(IF(E55=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E55+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,90,51,{"$f":"_xlfn.IFNA(IF(E56=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E56+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,91,52,{"$f":"_xlfn.IFNA(IF(E57=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E57+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,92,53,{"$f":"_xlfn.IFNA(IF(E58=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E58+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,93,54,{"$f":"_xlfn.IFNA(IF(E59=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E59+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,94,55,{"$f":"_xlfn.IFNA(IF(E60=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E60+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,95,56,{"$f":"_xlfn.IFNA(IF(E61=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E61+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,96,57,{"$f":"_xlfn.IFNA(IF(E62=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E62+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,97,58,{"$f":"_xlfn.IFNA(IF(E63=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E63+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,98,59,{"$f":"_xlfn.IFNA(IF(E64=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E64+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,99,60,{"$f":"_xlfn.IFNA(IF(E65=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E65+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,100,61,{"$f":"_xlfn.IFNA(IF(E66=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E66+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,101,62,{"$f":"_xlfn.IFNA(IF(E67=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E67+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,102,63,{"$f":"_xlfn.IFNA(IF(E68=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E68+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,103,64,{"$f":"_xlfn.IFNA(IF(E69=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E69+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,104,65,{"$f":"_xlfn.IFNA(IF(E70=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E70+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,105,66,{"$f":"_xlfn.IFNA(IF(E71=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E71+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,{"$f":"IF(E72=\"\", \"\", D71+1)","v":106},{"$f":"IF(E71=\"\", \"\", IF($B$9+E71-1>=110, \"\", E71+1))","v":67},{"$f":"_xlfn.IFNA(IF(E72=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E72+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,107,68,{"$f":"_xlfn.IFNA(IF(E73=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E73+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,108,69,{"$f":"_xlfn.IFNA(IF(E74=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E74+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,109,70,{"$f":"_xlfn.IFNA(IF(E75=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E75+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,110,71,{"$f":"_xlfn.IFNA(IF(E76=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E76+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E77=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E77+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E78=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E78+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E79=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E79+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E80=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E80+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E81=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E81+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E82=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E82+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E83=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E83+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E84=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E84+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E85=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E85+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E86=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E86+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E87=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E87+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E88=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E88+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E89=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E89+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E90=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E90+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E91=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E91+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E92=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E92+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E93=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E93+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E94=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E94+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E95=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E95+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E96=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E96+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E97=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E97+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E98=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E98+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E99=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E99+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E100=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E100+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E101=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E101+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E102=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E102+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E103=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E103+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E104=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E104+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E105=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E105+1, FALSE)), \"Something is wrong\")","v":""}]

{"sheet":"Plan Calculations","index":1,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Years of Payment",null,null,null,"Plan # 1","Plan # 2","Plan # 3","Plan # 4","Plan # 5","Plan # 6","Plan # 7"]
[null,{"$f":"'Illustration Calculator'!B15","v":20},{"$f":"B6","v":40},1,"Year 1",{"$f":"IF(AND($B$6+D3-1>=$B$9, $B$6+D3-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D3-1< 95, IF($B$6+D3-1=65, 25000, IF($B$6+D3-1>65, 25000+1000*($B$6+D3-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D3-1<$B$9, $B$6+D3-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D3-1>=60, $B$6+D3-1<=100), ($B$6+D3-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D3-1>=$B$9, $B$6+D3-1<$B$9+$B$3), IF($B$6+D3-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},{"$f":"IF(AND($B$6+D3-1>=$B$9, $B$6+D3-1<($B$9+$B$3)), 100000/$B$3, 0)","v":0},{"$f":"IF(AND($B$6+D3-1>=$B$9,$B$6+D3-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D3-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D3-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,null,{"$f":"C3+1","v":41},2,"Year 2",0,0,0,0,0,{"$f":"IF(AND($B$6+D4-1>=$B$9, $B$6+D4-1<($B$9+$B$3)), 100000/$B$3, 0)","v":0},0]
[null,"Current Age of Client",{"$f":"C4+1","v":42},3,"Year 3",0,0,0,0,0,0,{"$f":"IF(AND($B$6+D5-1>=$B$9,$B$6+D5-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D5-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D5-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,{"$f":"'Illustration Calculator'!B9","v":40},43,4,"Year 4",0,0,0,0,0,0,{"$f":"IF(AND($B$6+D6-1>=$B$9,$B$6+D6-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D6-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D6-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,null,44,5,"Year 5",0,0,0,0,0,0,0]
[null,"Age Payments begin",45,6,"Year 6",15000,0,7200,0,19000,5000,30000]
[null,{"$f":"'Illustration Calculator'!B12","v":45},46,7,"Year 7",15000,0,7200,0,19000,5000,0]
[null,null,47,8,"Year 8",15000,0,7200,0,19000,5000,30000]
[null,null,48,9,"Year 9",15000,0,7200,0,19000,5000,0]
[null,null,49,10,"Year 10",15000,0,7200,0,19000,5000,30000]
[null,null,50,11,"Year 11",15000,0,7200,0,19000,5000,0]
[null,null,51,12,"Year 12",15000,0,7200,0,19000,5000,30000]
[null,null,52,13,"Year 13",15000,0,7200,0,19000,5000,0]
[null,null,53,14,"Year 14",15000,0,7200,0,19000,5000,30000]
[null,null,54,15,"Year 15",15000,0,7200,0,19000,5000,0]
[null,null,55,16,"Year 16",15000,0,7200,0,25000,5000,30000]
[null,null,56,17,"Year 17",15000,0,7200,0,25000,5000,0]
[null,null,57,18,"Year 18",15000,0,7200,0,25000,5000,30000]
[null,null,58,19,"Year 19",15000,0,7200,0,25000,5000,0]
[null,null,59,20,"Year 20",15000,0,7200,0,25000,5000,30000]
[null,null,60,21,"Year 21",15000,0,7200,60000,25000,5000,0]
[null,null,61,22,"Year 22",15000,0,7200,61000,25000,5000,30000]
[null,null,62,23,"Year 23",15000,0,7200,62000,25000,5000,0]
[null,null,63,24,"Year 24",15000,0,7200,63000,25000,5000,30000]
[null,null,64,25,"Year 25",15000,0,7200,64000,25000,5000,0]
[null,null,65,26,"Year 26",0,25000,7200,65000,0,0,0]
[null,null,66,27,"Year 27",0,26000,7200,66000,0,0,0]
[null,null,67,28,"Year 28",0,27000,7200,67000,0,0,0]
[null,null,68,29,"Year 29",0,28000,7200,68000,0,0,0]
[null,null,69,30,"Year 30",0,29000,7200,69000,0,0,0]
[null,null,70,31,"Year 31",0,30000,7200,70000,0,0,0]
[null,null,71,32,"Year 32",0,31000,7200,71000,0,0,0]
[null,null,72,33,"Year 33",{"$f":"IF(AND($B$6+D35-1>=$B$9, $B$6+D35-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D35-1< 95, IF($B$6+D35-1=65, 25000, IF($B$6+D35-1>65, 25000+1000*($B$6+D35-1-65), 0)), 0)","v":32000},{"$f":"IF(OR($B$6+D35-1<$B$9, $B$6+D35-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D35-1>=60, $B$6+D35-1<=100), ($B$6+D35-1)*1000, 0)","v":72000},{"$f":"IF(AND($B$6+D35-1>=$B$9, $B$6+D35-1<$B$9+$B$3), IF($B$6+D35-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,73,34,"Year 34",0,33000,7200,73000,0,0,0]
[null,null,74,35,"Year 35",0,34000,7200,74000,0,0,0]
[null,null,75,36,"Year 36",0,35000,7200,75000,0,0,0]
[null,null,76,37,"Year 37",0,36000,7200,76000,0,0,0]
[null,null,77,38,"Year 38",0,37000,7200,77000,0,0,0]
[null,null,78,39,"Year 39",0,38000,7200,78000,0,0,0]
[null,null,79,40,"Year 40",0,39000,7200,79000,0,0,0]
[null,null,80,41,"Year 41",0,40000,7200,80000,0,0,0]
[null,null,81,42,"Year 42",0,41000,7200,81000,0,0,0]
[null,null,82,43,"Year 43",0,42000,7200,82000,0,0,0]
[null,null,83,44,"Year 44",0,43000,7200,83000,0,0,0]
[null,null,84,45,"Year 45",0,44000,7200,84000,0,0,0]
[null,null,85,46,"Year 46",0,45000,7200,85000,0,0,0]
[null,null,86,47,"Year 47",0,46000,7200,86000,0,0,0]
[null,null,87,48,"Year 48",0,47000,7200,87000,0,0,0]
[null,null,88,49,"Year 49",0,48000,7200,88000,0,0,0]
[null,null,89,50,"Year 50",0,49000,7200,89000,0,0,0]
[null,null,90,51,"Year 51",0,50000,7200,90000,0,0,0]
[null,null,91,52,"Year 52",0,51000,7200,91000,0,0,0]
[null,null,92,53,"Year 53",0,52000,7200,92000,0,0,0]
[null,null,93,54,"Year 54",0,53000,7200,93000,0,0,0]
[null,null,94,55,"Year 55",0,54000,7200,94000,0,0,0]
[null,null,95,56,"Year 56",0,0,7200,95000,0,0,0]
[null,null,96,57,"Year 57",0,0,7200,96000,0,0,0]
[null,null,97,58,"Year 58",0,0,7200,97000,0,0,0]
[null,null,98,59,"Year 59",0,0,7200,98000,0,0,0]
[null,null,99,60,"Year 60",0,0,7200,99000,0,0,0]
[null,null,100,61,"Year 61",0,0,7200,100000,0,0,0]
[null,null,101,62,"Year 62",0,0,7200,0,0,0,0]
[null,null,102,63,"Year 63",0,0,7200,0,0,0,0]
[null,null,103,64,"Year 64",0,0,7200,0,0,0,0]
[null,null,104,65,"Year 65",{"$f":"IF(AND($B$6+D67-1>=$B$9, $B$6+D67-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D67-1< 95, IF($B$6+D67-1=65, 25000, IF($B$6+D67-1>65, 25000+1000*($B$6+D67-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D67-1<$B$9, $B$6+D67-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D67-1>=60, $B$6+D67-1<=100), ($B$6+D67-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D67-1>=$B$9, $B$6+D67-1<$B$9+$B$3), IF($B$6+D67-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,105,66,"Year 66",0,0,7200,0,0,{"$f":"IF(AND($B$6+D68-1>=$B$9, $B$6+D68-1<($B$9+$B$3)), 100000/$B$3, 0)","v":0},0]
[null,null,{"$f":"C68+1","v":106},67,"Year 67",0,0,7200,0,0,0,0]
[null,null,107,68,"Year 68",0,0,7200,0,0,0,{"$f":"IF(AND($B$6+D70-1>=$B$9,$B$6+D70-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D70-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D70-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,null,108,69,"Year 69",0,0,7200,0,0,0,0]
[null,null,109,70,"Year 70",0,0,7200,0,0,0,0]
[null,null,{"$f":"C72+1","v":110},71,"Year 71",{"$f":"IF(AND($B$6+D73-1>=$B$9, $B$6+D73-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D73-1< 95, IF($B$6+D73-1=65, 25000, IF($B$6+D73-1>65, 25000+1000*($B$6+D73-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D73-1<$B$9, $B$6+D73-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D73-1>=60, $B$6+D73-1<=100), ($B$6+D73-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D73-1>=$B$9, $B$6+D73-1<$B$9+$B$3), IF($B$6+D73-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,111,72,"Year 72",0,0,0,0,0,0,0]
[null,null,112,73,"Year 73",0,0,0,0,0,0,0]