{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Asset Projection","Retirement Income","Random Returns"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Asset Projection","index":0,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,4],[12,7,12,8],[0,0,0,8],[12,5,12,6]]}
["Asset Projection Calculator"]
[]
[]
[null,"Initial Balance",null,null,"Rate Of Return",null,"Fee Rate",null,"Real ROR"]
[null,500000,null,null,5,null,0,null,{"$f":"E5-G5","v":5}]
[]
[null,"Annual Additions",null,null,"Years to Compound",null,"Tax Rate"]
[null,0,null,null,25,null,0]
[]
[]
[]
[]
[null,"GROSS",null,"Net of Fees",null,"Net of Taxes",null,"Net of Fees & Taxes"]
["Year ","Balance","Interest","Balance After Fees","Fees","Balance After Taxes","Taxes","Balance After Fees & Taxes","Taxes & Fees"]
[{"$f":"IF($E$8=0,\" \",1)","v":1},{"$f":"IF(+B5+B8=0,\" \",+B5+B8)","v":500000},{"$f":"IF(+B15*($E$5/100)=0,\" \",+B15*($E$5/100))","v":25000},{"$f":"IF(+B5+B8=0,\" \",+B5+B8)","v":500000},{"$f":"IF(+D15*($I$5/100)=0,0,+(B15+C15)*($G$5/100))","v":0},{"$f":"IF(+B5+B8=0,\" \",+B5+B8)","v":500000},{"$f":"IF(+F15*($G$8/100)=0,0,+C15*($G$8/100))","v":0},{"$f":"IF(+B5+B8=0,\" \",+B5+B8)","v":500000},{"$f":"IF(+C15*($G$8/100)=0,E15+G15,E15+G15)","v":0}]
[{"$f":"IF(A15=\" \",\" \",IF(A15=\"Totals\",\" \",IF(A15=$E$8,\"Totals\",IF(A15<$E$8,A15+1,\" \"))))","v":2},{"$f":"IF(+A16=\"Totals\",+B15+C15,IF(+A15=\"Totals\",\" \",IF(+A15=\" \",\" \",+B15+C15+$B$8)))","v":525000},{"$f":"IF(A16=\"Totals\",SUM($C$15),IF(A15=\"Totals\",\" \",IF(A15=\" \",\" \",+B16*($E$5/100))))","v":26250},{"$f":"IF(+A16=\"Totals\",+D15+(C15-E15),IF(+A15=\"Totals\",\" \",IF(+A15=\" \",\" \",+D15+$B$8+(C15-E15))))","v":525000},{"$f":"IF(A16=\"Totals\",SUM($E$15),IF(A15=\"Totals\",\" \",IF(A15=\" \",\" \",+(B16+C16)*($G$5/100))))","v":0},{"$f":"IF(+A16=\"Totals\",+F15+(C15-G15),IF(+A15=\"Totals\",\" \",IF(+A15=\" \",\" \",+F15+$B$8+(C15-G15))))","v":525000},{"$f":"IF(A16=\"Totals\",SUM($G$15),IF(A15=\"Totals\",\" \",IF(A15=\" \",\" \",+C16*($G$8/100))))","v":0},{"$f":"IF(A16=\"Totals\",+H15+C15-I15,IF(+A15=\"Totals\",\" \",IF(+A15=\" \",\" \",+H15+C15+$B$8-I15)))","v":525000},{"$f":"IF(+A16=\"Totals\",SUM($I$15),IF(A15=\"Totals\",\" \",IF(A15=\" \",\" \",E16+G16)))","v":0}]
[3,{"$f":"IF(+A17=\"Totals\",+B16+C16,IF(+A16=\"Totals\",\" \",IF(+A16=\" \",\" \",+B16+C16+$B$8)))","v":551250},{"$f":"IF(A17=\"Totals\",SUM(C15:$C$16),IF(A16=\"Totals\",\" \",IF(A16=\" \",\" \",+B17*($E$5/100))))","v":27562.5},{"$f":"IF(+A17=\"Totals\",+D16+(C16-E16),IF(+A16=\"Totals\",\" \",IF(+A16=\" \",\" \",+D16+$B$8+(C16-E16))))","v":551250},{"$f":"IF(A17=\"Totals\",SUM($E$15:E16),IF(A16=\"Totals\",\" \",IF(A16=\" \",\" \",+(B17+C17)*($G$5/100))))","v":0},{"$f":"IF(+A17=\"Totals\",+F16+(C16-G16),IF(+A16=\"Totals\",\" \",IF(+A16=\" \",\" \",+F16+$B$8+(C16-G16))))","v":551250},{"$f":"IF(A17=\"Totals\",SUM($G$15:G16),IF(A16=\"Totals\",\" \",IF(A16=\" \",\" \",+C17*($G$8/100))))","v":0},{"$f":"IF(A17=\"Totals\",+H16+C16-I16,IF(+A16=\"Totals\",\" \",IF(+A16=\" \",\" \",+H16+C16+$B$8-I16)))","v":551250},{"$f":"IF(+A17=\"Totals\",SUM($I$15:I16),IF(A16=\"Totals\",\" \",IF(A16=\" \",\" \",E17+G17)))","v":0}]
[4,{"$f":"IF(+A18=\"Totals\",+B17+C17,IF(+A17=\"Totals\",\" \",IF(+A17=\" \",\" \",+B17+C17+$B$8)))","v":578812.5},{"$f":"IF(A18=\"Totals\",SUM(C15:$C$17),IF(A17=\"Totals\",\" \",IF(A17=\" \",\" \",+B18*($E$5/100))))","v":28940.625},{"$f":"IF(+A18=\"Totals\",+D17+(C17-E17),IF(+A17=\"Totals\",\" \",IF(+A17=\" \",\" \",+D17+$B$8+(C17-E17))))","v":578812.5},{"$f":"IF(A18=\"Totals\",SUM($E$15:E17),IF(A17=\"Totals\",\" \",IF(A17=\" \",\" \",+(B18+C18)*($G$5/100))))","v":0},{"$f":"IF(+A18=\"Totals\",+F17+(C17-G17),IF(+A17=\"Totals\",\" \",IF(+A17=\" \",\" \",+F17+$B$8+(C17-G17))))","v":578812.5},{"$f":"IF(A18=\"Totals\",SUM($G$15:G17),IF(A17=\"Totals\",\" \",IF(A17=\" \",\" \",+C18*($G$8/100))))","v":0},{"$f":"IF(A18=\"Totals\",+H17+C17-I17,IF(+A17=\"Totals\",\" \",IF(+A17=\" \",\" \",+H17+C17+$B$8-I17)))","v":578812.5},{"$f":"IF(+A18=\"Totals\",SUM($I$15:I17),IF(A17=\"Totals\",\" \",IF(A17=\" \",\" \",E18+G18)))","v":0}]
[5,607753.125,{"$f":"IF(A19=\"Totals\",SUM(C15:$C$18),IF(A18=\"Totals\",\" \",IF(A18=\" \",\" \",+B19*($E$5/100))))","v":30387.65625},607753.125,{"$f":"IF(A19=\"Totals\",SUM($E$15:E18),IF(A18=\"Totals\",\" \",IF(A18=\" \",\" \",+(B19+C19)*($G$5/100))))","v":0},{"$f":"IF(+A19=\"Totals\",+F18+(C18-G18),IF(+A18=\"Totals\",\" \",IF(+A18=\" \",\" \",+F18+$B$8+(C18-G18))))","v":607753.125},{"$f":"IF(A19=\"Totals\",SUM($G$15:G18),IF(A18=\"Totals\",\" \",IF(A18=\" \",\" \",+C19*($G$8/100))))","v":0},607753.125,{"$f":"IF(+A19=\"Totals\",SUM($I$15:I18),IF(A18=\"Totals\",\" \",IF(A18=\" \",\" \",E19+G19)))","v":0}]
[6,638140.78125,{"$f":"IF(A20=\"Totals\",SUM(C15:$C$19),IF(A19=\"Totals\",\" \",IF(A19=\" \",\" \",+B20*($E$5/100))))","v":31907.0390625},638140.78125,{"$f":"IF(A20=\"Totals\",SUM($E$15:E19),IF(A19=\"Totals\",\" \",IF(A19=\" \",\" \",+(B20+C20)*($G$5/100))))","v":0},{"$f":"IF(+A20=\"Totals\",+F19+(C19-G19),IF(+A19=\"Totals\",\" \",IF(+A19=\" \",\" \",+F19+$B$8+(C19-G19))))","v":638140.78125},{"$f":"IF(A20=\"Totals\",SUM($G$15:G19),IF(A19=\"Totals\",\" \",IF(A19=\" \",\" \",+C20*($G$8/100))))","v":0},638140.78125,{"$f":"IF(+A20=\"Totals\",SUM($I$15:I19),IF(A19=\"Totals\",\" \",IF(A19=\" \",\" \",E20+G20)))","v":0}]
[7,670047.8203125,{"$f":"IF(A21=\"Totals\",SUM(C15:$C$20),IF(A20=\"Totals\",\" \",IF(A20=\" \",\" \",+B21*($E$5/100))))","v":33502.391015624999},670047.8203125,{"$f":"IF(A21=\"Totals\",SUM($E$15:E20),IF(A20=\"Totals\",\" \",IF(A20=\" \",\" \",+(B21+C21)*($G$5/100))))","v":0},670047.8203125,{"$f":"IF(A21=\"Totals\",SUM($G$15:G20),IF(A20=\"Totals\",\" \",IF(A20=\" \",\" \",+C21*($G$8/100))))","v":0},670047.8203125,{"$f":"IF(+A21=\"Totals\",SUM($I$15:I20),IF(A20=\"Totals\",\" \",IF(A20=\" \",\" \",E21+G21)))","v":0}]
[8,703550.21132812498,{"$f":"IF(A22=\"Totals\",SUM(C15:$C$21),IF(A21=\"Totals\",\" \",IF(A21=\" \",\" \",+B22*($E$5/100))))","v":35177.51056640625},703550.21132812498,{"$f":"IF(A22=\"Totals\",SUM($E$15:E21),IF(A21=\"Totals\",\" \",IF(A21=\" \",\" \",+(B22+C22)*($G$5/100))))","v":0},703550.21132812498,{"$f":"IF(A22=\"Totals\",SUM($G$15:G21),IF(A21=\"Totals\",\" \",IF(A21=\" \",\" \",+C22*($G$8/100))))","v":0},703550.21132812498,{"$f":"IF(+A22=\"Totals\",SUM($I$15:I21),IF(A21=\"Totals\",\" \",IF(A21=\" \",\" \",E22+G22)))","v":0}]
[9,738727.72189453128,{"$f":"IF(A23=\"Totals\",SUM(C15:$C$22),IF(A22=\"Totals\",\" \",IF(A22=\" \",\" \",+B23*($E$5/100))))","v":36936.386094726564},738727.72189453128,{"$f":"IF(A23=\"Totals\",SUM($E$15:E22),IF(A22=\"Totals\",\" \",IF(A22=\" \",\" \",+(B23+C23)*($G$5/100))))","v":0},738727.72189453128,{"$f":"IF(A23=\"Totals\",SUM($G$15:G22),IF(A22=\"Totals\",\" \",IF(A22=\" \",\" \",+C23*($G$8/100))))","v":0},738727.72189453128,{"$f":"IF(+A23=\"Totals\",SUM($I$15:I22),IF(A22=\"Totals\",\" \",IF(A22=\" \",\" \",E23+G23)))","v":0}]
[10,775664.1079892579,{"$f":"IF(A24=\"Totals\",SUM(C15:$C$23),IF(A23=\"Totals\",\" \",IF(A23=\" \",\" \",+B24*($E$5/100))))","v":38783.205399462895},775664.1079892579,{"$f":"IF(A24=\"Totals\",SUM($E$15:E23),IF(A23=\"Totals\",\" \",IF(A23=\" \",\" \",+(B24+C24)*($G$5/100))))","v":0},775664.1079892579,{"$f":"IF(A24=\"Totals\",SUM($G$15:G23),IF(A23=\"Totals\",\" \",IF(A23=\" \",\" \",+C24*($G$8/100))))","v":0},775664.1079892579,{"$f":"IF(+A24=\"Totals\",SUM($I$15:I23),IF(A23=\"Totals\",\" \",IF(A23=\" \",\" \",E24+G24)))","v":0}]
[11,814447.31338872085,{"$f":"IF(A25=\"Totals\",SUM(C15:$C$24),IF(A24=\"Totals\",\" \",IF(A24=\" \",\" \",+B25*($E$5/100))))","v":40722.365669436047},814447.31338872085,{"$f":"IF(A25=\"Totals\",SUM($E$15:E24),IF(A24=\"Totals\",\" \",IF(A24=\" \",\" \",+(B25+C25)*($G$5/100))))","v":0},814447.31338872085,{"$f":"IF(A25=\"Totals\",SUM($G$15:G24),IF(A24=\"Totals\",\" \",IF(A24=\" \",\" \",+C25*($G$8/100))))","v":0},814447.31338872085,{"$f":"IF(+A25=\"Totals\",SUM($I$15:I24),IF(A24=\"Totals\",\" \",IF(A24=\" \",\" \",E25+G25)))","v":0}]
[12,855169.67905815691,{"$f":"IF(A26=\"Totals\",SUM(C15:$C$25),IF(A25=\"Totals\",\" \",IF(A25=\" \",\" \",+B26*($E$5/100))))","v":42758.483952907845},855169.67905815691,{"$f":"IF(A26=\"Totals\",SUM($E$15:E25),IF(A25=\"Totals\",\" \",IF(A25=\" \",\" \",+(B26+C26)*($G$5/100))))","v":0},855169.67905815691,{"$f":"IF(A26=\"Totals\",SUM($G$15:G25),IF(A25=\"Totals\",\" \",IF(A25=\" \",\" \",+C26*($G$8/100))))","v":0},855169.67905815691,{"$f":"IF(+A26=\"Totals\",SUM($I$15:I25),IF(A25=\"Totals\",\" \",IF(A25=\" \",\" \",E26+G26)))","v":0}]
[13,897928.16301106475,{"$f":"IF(A27=\"Totals\",SUM(C15:$C$26),IF(A26=\"Totals\",\" \",IF(A26=\" \",\" \",+B27*($E$5/100))))","v":44896.408150553238},897928.16301106475,{"$f":"IF(A27=\"Totals\",SUM($E$15:E26),IF(A26=\"Totals\",\" \",IF(A26=\" \",\" \",+(B27+C27)*($G$5/100))))","v":0},897928.16301106475,{"$f":"IF(A27=\"Totals\",SUM($G$15:G26),IF(A26=\"Totals\",\" \",IF(A26=\" \",\" \",+C27*($G$8/100))))","v":0},897928.16301106475,{"$f":"IF(+A27=\"Totals\",SUM($I$15:I26),IF(A26=\"Totals\",\" \",IF(A26=\" \",\" \",E27+G27)))","v":0}]
[14,942824.57116161799,{"$f":"IF(A28=\"Totals\",SUM(C15:$C$27),IF(A27=\"Totals\",\" \",IF(A27=\" \",\" \",+B28*($E$5/100))))","v":47141.228558080904},942824.57116161799,{"$f":"IF(A28=\"Totals\",SUM($E$15:E27),IF(A27=\"Totals\",\" \",IF(A27=\" \",\" \",+(B28+C28)*($G$5/100))))","v":0},942824.57116161799,{"$f":"IF(A28=\"Totals\",SUM($G$15:G27),IF(A27=\"Totals\",\" \",IF(A27=\" \",\" \",+C28*($G$8/100))))","v":0},942824.57116161799,{"$f":"IF(+A28=\"Totals\",SUM($I$15:I27),IF(A27=\"Totals\",\" \",IF(A27=\" \",\" \",E28+G28)))","v":0}]
[15,989965.79971969884,{"$f":"IF(A29=\"Totals\",SUM(C15:$C$28),IF(A28=\"Totals\",\" \",IF(A28=\" \",\" \",+B29*($E$5/100))))","v":49498.289985984942},989965.79971969884,{"$f":"IF(A29=\"Totals\",SUM($E$15:E28),IF(A28=\"Totals\",\" \",IF(A28=\" \",\" \",+(B29+C29)*($G$5/100))))","v":0},989965.79971969884,{"$f":"IF(A29=\"Totals\",SUM($G$15:G28),IF(A28=\"Totals\",\" \",IF(A28=\" \",\" \",+C29*($G$8/100))))","v":0},989965.79971969884,{"$f":"IF(+A29=\"Totals\",SUM($I$15:I28),IF(A28=\"Totals\",\" \",IF(A28=\" \",\" \",E29+G29)))","v":0}]
[16,1039464.0897056838,{"$f":"IF(A30=\"Totals\",SUM(C15:$C$29),IF(A29=\"Totals\",\" \",IF(A29=\" \",\" \",+B30*($E$5/100))))","v":51973.204485284194},1039464.0897056838,{"$f":"IF(A30=\"Totals\",SUM($E$15:E29),IF(A29=\"Totals\",\" \",IF(A29=\" \",\" \",+(B30+C30)*($G$5/100))))","v":0},1039464.0897056838,{"$f":"IF(A30=\"Totals\",SUM($G$15:G29),IF(A29=\"Totals\",\" \",IF(A29=\" \",\" \",+C30*($G$8/100))))","v":0},1039464.0897056838,{"$f":"IF(+A30=\"Totals\",SUM($I$15:I29),IF(A29=\"Totals\",\" \",IF(A29=\" \",\" \",E30+G30)))","v":0}]
[17,1091437.2941909679,{"$f":"IF(A31=\"Totals\",SUM(C15:$C$30),IF(A30=\"Totals\",\" \",IF(A30=\" \",\" \",+B31*($E$5/100))))","v":54571.864709548398},1091437.2941909679,{"$f":"IF(A31=\"Totals\",SUM($E$15:E30),IF(A30=\"Totals\",\" \",IF(A30=\" \",\" \",+(B31+C31)*($G$5/100))))","v":0},1091437.2941909679,{"$f":"IF(A31=\"Totals\",SUM($G$15:G30),IF(A30=\"Totals\",\" \",IF(A30=\" \",\" \",+C31*($G$8/100))))","v":0},1091437.2941909679,{"$f":"IF(+A31=\"Totals\",SUM($I$15:I30),IF(A30=\"Totals\",\" \",IF(A30=\" \",\" \",E31+G31)))","v":0}]
[18,1146009.1589005163,{"$f":"IF(A32=\"Totals\",SUM(C15:$C$31),IF(A31=\"Totals\",\" \",IF(A31=\" \",\" \",+B32*($E$5/100))))","v":57300.457945025817},1146009.1589005163,{"$f":"IF(A32=\"Totals\",SUM($E$15:E31),IF(A31=\"Totals\",\" \",IF(A31=\" \",\" \",+(B32+C32)*($G$5/100))))","v":0},1146009.1589005163,{"$f":"IF(A32=\"Totals\",SUM($G$15:G31),IF(A31=\"Totals\",\" \",IF(A31=\" \",\" \",+C32*($G$8/100))))","v":0},1146009.1589005163,{"$f":"IF(+A32=\"Totals\",SUM($I$15:I31),IF(A31=\"Totals\",\" \",IF(A31=\" \",\" \",E32+G32)))","v":0}]
[19,1203309.6168455421,{"$f":"IF(A33=\"Totals\",SUM(C15:$C$32),IF(A32=\"Totals\",\" \",IF(A32=\" \",\" \",+B33*($E$5/100))))","v":60165.480842277109},1203309.6168455421,{"$f":"IF(A33=\"Totals\",SUM($E$15:E32),IF(A32=\"Totals\",\" \",IF(A32=\" \",\" \",+(B33+C33)*($G$5/100))))","v":0},1203309.6168455421,{"$f":"IF(A33=\"Totals\",SUM($G$15:G32),IF(A32=\"Totals\",\" \",IF(A32=\" \",\" \",+C33*($G$8/100))))","v":0},1203309.6168455421,{"$f":"IF(+A33=\"Totals\",SUM($I$15:I32),IF(A32=\"Totals\",\" \",IF(A32=\" \",\" \",E33+G33)))","v":0}]
[20,1263475.0976878193,{"$f":"IF(A34=\"Totals\",SUM(C15:$C$33),IF(A33=\"Totals\",\" \",IF(A33=\" \",\" \",+B34*($E$5/100))))","v":63173.754884390968},1263475.0976878193,{"$f":"IF(A34=\"Totals\",SUM($E$15:E33),IF(A33=\"Totals\",\" \",IF(A33=\" \",\" \",+(B34+C34)*($G$5/100))))","v":0},1263475.0976878193,{"$f":"IF(A34=\"Totals\",SUM($G$15:G33),IF(A33=\"Totals\",\" \",IF(A33=\" \",\" \",+C34*($G$8/100))))","v":0},1263475.0976878193,{"$f":"IF(+A34=\"Totals\",SUM($I$15:I33),IF(A33=\"Totals\",\" \",IF(A33=\" \",\" \",E34+G34)))","v":0}]
[21,1326648.8525722101,{"$f":"IF(A35=\"Totals\",SUM(C15:$C$34),IF(A34=\"Totals\",\" \",IF(A34=\" \",\" \",+B35*($E$5/100))))","v":66332.442628610515},1326648.8525722101,{"$f":"IF(A35=\"Totals\",SUM($E$15:E34),IF(A34=\"Totals\",\" \",IF(A34=\" \",\" \",+(B35+C35)*($G$5/100))))","v":0},1326648.8525722101,{"$f":"IF(A35=\"Totals\",SUM($G$15:G34),IF(A34=\"Totals\",\" \",IF(A34=\" \",\" \",+C35*($G$8/100))))","v":0},1326648.8525722101,{"$f":"IF(+A35=\"Totals\",SUM($I$15:I34),IF(A34=\"Totals\",\" \",IF(A34=\" \",\" \",E35+G35)))","v":0}]
[22,1392981.2952008205,{"$f":"IF(A36=\"Totals\",SUM(C15:$C$35),IF(A35=\"Totals\",\" \",IF(A35=\" \",\" \",+B36*($E$5/100))))","v":69649.06476004103},1392981.2952008205,{"$f":"IF(A36=\"Totals\",SUM($E$15:E35),IF(A35=\"Totals\",\" \",IF(A35=\" \",\" \",+(B36+C36)*($G$5/100))))","v":0},1392981.2952008205,{"$f":"IF(A36=\"Totals\",SUM($G$15:G35),IF(A35=\"Totals\",\" \",IF(A35=\" \",\" \",+C36*($G$8/100))))","v":0},1392981.2952008205,{"$f":"IF(+A36=\"Totals\",SUM($I$15:I35),IF(A35=\"Totals\",\" \",IF(A35=\" \",\" \",E36+G36)))","v":0}]
[23,1462630.3599608615,{"$f":"IF(A37=\"Totals\",SUM(C15:$C$36),IF(A36=\"Totals\",\" \",IF(A36=\" \",\" \",+B37*($E$5/100))))","v":73131.517998043084},1462630.3599608615,{"$f":"IF(A37=\"Totals\",SUM($E$15:E36),IF(A36=\"Totals\",\" \",IF(A36=\" \",\" \",+(B37+C37)*($G$5/100))))","v":0},1462630.3599608615,{"$f":"IF(A37=\"Totals\",SUM($G$15:G36),IF(A36=\"Totals\",\" \",IF(A36=\" \",\" \",+C37*($G$8/100))))","v":0},1462630.3599608615,{"$f":"IF(+A37=\"Totals\",SUM($I$15:I36),IF(A36=\"Totals\",\" \",IF(A36=\" \",\" \",E37+G37)))","v":0}]
[24,1535761.8779589045,{"$f":"IF(A38=\"Totals\",SUM(C15:$C$37),IF(A37=\"Totals\",\" \",IF(A37=\" \",\" \",+B38*($E$5/100))))","v":76788.093897945233},1535761.8779589045,{"$f":"IF(A38=\"Totals\",SUM($E$15:E37),IF(A37=\"Totals\",\" \",IF(A37=\" \",\" \",+(B38+C38)*($G$5/100))))","v":0},1535761.8779589045,{"$f":"IF(A38=\"Totals\",SUM($G$15:G37),IF(A37=\"Totals\",\" \",IF(A37=\" \",\" \",+C38*($G$8/100))))","v":0},1535761.8779589045,{"$f":"IF(+A38=\"Totals\",SUM($I$15:I37),IF(A37=\"Totals\",\" \",IF(A37=\" \",\" \",E38+G38)))","v":0}]
[25,1612549.9718568497,{"$f":"IF(A39=\"Totals\",SUM(C15:$C$38),IF(A38=\"Totals\",\" \",IF(A38=\" \",\" \",+B39*($E$5/100))))","v":80627.498592842487},1612549.9718568497,{"$f":"IF(A39=\"Totals\",SUM($E$15:E38),IF(A38=\"Totals\",\" \",IF(A38=\" \",\" \",+(B39+C39)*($G$5/100))))","v":0},1612549.9718568497,{"$f":"IF(A39=\"Totals\",SUM($G$15:G38),IF(A38=\"Totals\",\" \",IF(A38=\" \",\" \",+C39*($G$8/100))))","v":0},1612549.9718568497,{"$f":"IF(+A39=\"Totals\",SUM($I$15:I38),IF(A38=\"Totals\",\" \",IF(A38=\" \",\" \",E39+G39)))","v":0}]
["Totals",1693177.4704496921,{"$f":"IF(A40=\"Totals\",SUM(C15:$C$39),IF(A39=\"Totals\",\" \",IF(A39=\" \",\" \",+B40*($E$5/100))))","v":1193177.4704496926},1693177.4704496921,{"$f":"IF(A40=\"Totals\",SUM($E$15:E39),IF(A39=\"Totals\",\" \",IF(A39=\" \",\" \",+(B40+C40)*($G$5/100))))","v":0},1693177.4704496921,{"$f":"IF(A40=\"Totals\",SUM($G$15:G39),IF(A39=\"Totals\",\" \",IF(A39=\" \",\" \",+C40*($G$8/100))))","v":0},1693177.4704496921,{"$f":"IF(+A40=\"Totals\",SUM($I$15:I39),IF(A39=\"Totals\",\" \",IF(A39=\" \",\" \",E40+G40)))","v":0}]
[" "," ",{"$f":"IF(A41=\"Totals\",SUM(C15:$C$40),IF(A40=\"Totals\",\" \",IF(A40=\" \",\" \",+B41*($E$5/100))))","v":" "}," ",{"$f":"IF(A41=\"Totals\",SUM($E$15:E40),IF(A40=\"Totals\",\" \",IF(A40=\" \",\" \",+(B41+C41)*($G$5/100))))","v":" "}," ",{"$f":"IF(A41=\"Totals\",SUM($G$15:G40),IF(A40=\"Totals\",\" \",IF(A40=\" \",\" \",+C41*($G$8/100))))","v":" "}," ",{"$f":"IF(+A41=\"Totals\",SUM($I$15:I40),IF(A40=\"Totals\",\" \",IF(A40=\" \",\" \",E41+G41)))","v":" "}]
[" "," ",{"$f":"IF(A42=\"Totals\",SUM(C15:$C$41),IF(A41=\"Totals\",\" \",IF(A41=\" \",\" \",+B42*($E$5/100))))","v":" "}," ",{"$f":"IF(A42=\"Totals\",SUM($E$15:E41),IF(A41=\"Totals\",\" \",IF(A41=\" \",\" \",+(B42+C42)*($G$5/100))))","v":" "}," ",{"$f":"IF(A42=\"Totals\",SUM($G$15:G41),IF(A41=\"Totals\",\" \",IF(A41=\" \",\" \",+C42*($G$8/100))))","v":" "}," ",{"$f":"IF(+A42=\"Totals\",SUM($I$15:I41),IF(A41=\"Totals\",\" \",IF(A41=\" \",\" \",E42+G42)))","v":" "}]
[" "," ",{"$f":"IF(A43=\"Totals\",SUM(C15:$C$42),IF(A42=\"Totals\",\" \",IF(A42=\" \",\" \",+B43*($E$5/100))))","v":" "}," ",{"$f":"IF(A43=\"Totals\",SUM($E$15:E42),IF(A42=\"Totals\",\" \",IF(A42=\" \",\" \",+(B43+C43)*($G$5/100))))","v":" "}," ",{"$f":"IF(A43=\"Totals\",SUM($G$15:G42),IF(A42=\"Totals\",\" \",IF(A42=\" \",\" \",+C43*($G$8/100))))","v":" "}," ",{"$f":"IF(+A43=\"Totals\",SUM($I$15:I42),IF(A42=\"Totals\",\" \",IF(A42=\" \",\" \",E43+G43)))","v":" "}]
[" "," ",{"$f":"IF(A44=\"Totals\",SUM(C15:$C$43),IF(A43=\"Totals\",\" \",IF(A43=\" \",\" \",+B44*($E$5/100))))","v":" "}," ",{"$f":"IF(A44=\"Totals\",SUM($E$15:E43),IF(A43=\"Totals\",\" \",IF(A43=\" \",\" \",+(B44+C44)*($G$5/100))))","v":" "}," ",{"$f":"IF(A44=\"Totals\",SUM($G$15:G43),IF(A43=\"Totals\",\" \",IF(A43=\" \",\" \",+C44*($G$8/100))))","v":" "}," ",{"$f":"IF(+A44=\"Totals\",SUM($I$15:I43),IF(A43=\"Totals\",\" \",IF(A43=\" \",\" \",E44+G44)))","v":" "}]
[" "," ",{"$f":"IF(A45=\"Totals\",SUM(C15:$C$44),IF(A44=\"Totals\",\" \",IF(A44=\" \",\" \",+B45*($E$5/100))))","v":" "}," ",{"$f":"IF(A45=\"Totals\",SUM($E$15:E44),IF(A44=\"Totals\",\" \",IF(A44=\" \",\" \",+(B45+C45)*($G$5/100))))","v":" "}," ",{"$f":"IF(A45=\"Totals\",SUM($G$15:G44),IF(A44=\"Totals\",\" \",IF(A44=\" \",\" \",+C45*($G$8/100))))","v":" "}," ",{"$f":"IF(+A45=\"Totals\",SUM($I$15:I44),IF(A44=\"Totals\",\" \",IF(A44=\" \",\" \",E45+G45)))","v":" "}]
[" "," ",{"$f":"IF(A46=\"Totals\",SUM(C15:$C$45),IF(A45=\"Totals\",\" \",IF(A45=\" \",\" \",+B46*($E$5/100))))","v":" "}," ",{"$f":"IF(A46=\"Totals\",SUM($E$15:E45),IF(A45=\"Totals\",\" \",IF(A45=\" \",\" \",+(B46+C46)*($G$5/100))))","v":" "}," ",{"$f":"IF(A46=\"Totals\",SUM($G$15:G45),IF(A45=\"Totals\",\" \",IF(A45=\" \",\" \",+C46*($G$8/100))))","v":" "}," ",{"$f":"IF(+A46=\"Totals\",SUM($I$15:I45),IF(A45=\"Totals\",\" \",IF(A45=\" \",\" \",E46+G46)))","v":" "}]
[" "," ",{"$f":"IF(A47=\"Totals\",SUM(C15:$C$46),IF(A46=\"Totals\",\" \",IF(A46=\" \",\" \",+B47*($E$5/100))))","v":" "}," ",{"$f":"IF(A47=\"Totals\",SUM($E$15:E46),IF(A46=\"Totals\",\" \",IF(A46=\" \",\" \",+(B47+C47)*($G$5/100))))","v":" "}," ",{"$f":"IF(A47=\"Totals\",SUM($G$15:G46),IF(A46=\"Totals\",\" \",IF(A46=\" \",\" \",+C47*($G$8/100))))","v":" "}," ",{"$f":"IF(+A47=\"Totals\",SUM($I$15:I46),IF(A46=\"Totals\",\" \",IF(A46=\" \",\" \",E47+G47)))","v":" "}]
[{"$f":"IF(A47=\" \",\" \",IF(A47=\"Totals\",\" \",IF(A47=$E$8,\"Totals\",IF(A47<$E$8,A47+1,\" \"))))","v":" "}," ",{"$f":"IF(A48=\"Totals\",SUM(C15:$C$47),IF(A47=\"Totals\",\" \",IF(A47=\" \",\" \",+B48*($E$5/100))))","v":" "}," ",{"$f":"IF(A48=\"Totals\",SUM($E$15:E47),IF(A47=\"Totals\",\" \",IF(A47=\" \",\" \",+(B48+C48)*($G$5/100))))","v":" "}," ",{"$f":"IF(A48=\"Totals\",SUM($G$15:G47),IF(A47=\"Totals\",\" \",IF(A47=\" \",\" \",+C48*($G$8/100))))","v":" "}," ",{"$f":"IF(+A48=\"Totals\",SUM($I$15:I47),IF(A47=\"Totals\",\" \",IF(A47=\" \",\" \",E48+G48)))","v":" "}]
[" "," ",{"$f":"IF(A49=\"Totals\",SUM(C15:$C$48),IF(A48=\"Totals\",\" \",IF(A48=\" \",\" \",+B49*($E$5/100))))","v":" "}," ",{"$f":"IF(A49=\"Totals\",SUM($E$15:E48),IF(A48=\"Totals\",\" \",IF(A48=\" \",\" \",+(B49+C49)*($G$5/100))))","v":" "}," ",{"$f":"IF(A49=\"Totals\",SUM($G$15:G48),IF(A48=\"Totals\",\" \",IF(A48=\" \",\" \",+C49*($G$8/100))))","v":" "}," ",{"$f":"IF(+A49=\"Totals\",SUM($I$15:I48),IF(A48=\"Totals\",\" \",IF(A48=\" \",\" \",E49+G49)))","v":" "}]
[" "," ",{"$f":"IF(A50=\"Totals\",SUM(C15:$C$49),IF(A49=\"Totals\",\" \",IF(A49=\" \",\" \",+B50*($E$5/100))))","v":" "}," ",{"$f":"IF(A50=\"Totals\",SUM($E$15:E49),IF(A49=\"Totals\",\" \",IF(A49=\" \",\" \",+(B50+C50)*($G$5/100))))","v":" "}," ",{"$f":"IF(A50=\"Totals\",SUM($G$15:G49),IF(A49=\"Totals\",\" \",IF(A49=\" \",\" \",+C50*($G$8/100))))","v":" "}," ",{"$f":"IF(+A50=\"Totals\",SUM($I$15:I49),IF(A49=\"Totals\",\" \",IF(A49=\" \",\" \",E50+G50)))","v":" "}]
[" "," ",{"$f":"IF(A51=\"Totals\",SUM(C15:$C$50),IF(A50=\"Totals\",\" \",IF(A50=\" \",\" \",+B51*($E$5/100))))","v":" "}," ",{"$f":"IF(A51=\"Totals\",SUM($E$15:E50),IF(A50=\"Totals\",\" \",IF(A50=\" \",\" \",+(B51+C51)*($G$5/100))))","v":" "}," ",{"$f":"IF(A51=\"Totals\",SUM($G$15:G50),IF(A50=\"Totals\",\" \",IF(A50=\" \",\" \",+C51*($G$8/100))))","v":" "}," ",{"$f":"IF(+A51=\"Totals\",SUM($I$15:I50),IF(A50=\"Totals\",\" \",IF(A50=\" \",\" \",E51+G51)))","v":" "}]
[" "," ",{"$f":"IF(A52=\"Totals\",SUM(C15:$C$51),IF(A51=\"Totals\",\" \",IF(A51=\" \",\" \",+B52*($E$5/100))))","v":" "}," ",{"$f":"IF(A52=\"Totals\",SUM($E$15:E51),IF(A51=\"Totals\",\" \",IF(A51=\" \",\" \",+(B52+C52)*($G$5/100))))","v":" "}," ",{"$f":"IF(A52=\"Totals\",SUM($G$15:G51),IF(A51=\"Totals\",\" \",IF(A51=\" \",\" \",+C52*($G$8/100))))","v":" "}," ",{"$f":"IF(+A52=\"Totals\",SUM($I$15:I51),IF(A51=\"Totals\",\" \",IF(A51=\" \",\" \",E52+G52)))","v":" "}]
[" "," ",{"$f":"IF(A53=\"Totals\",SUM(C15:$C$52),IF(A52=\"Totals\",\" \",IF(A52=\" \",\" \",+B53*($E$5/100))))","v":" "}," ",{"$f":"IF(A53=\"Totals\",SUM($E$15:E52),IF(A52=\"Totals\",\" \",IF(A52=\" \",\" \",+(B53+C53)*($G$5/100))))","v":" "}," ",{"$f":"IF(A53=\"Totals\",SUM($G$15:G52),IF(A52=\"Totals\",\" \",IF(A52=\" \",\" \",+C53*($G$8/100))))","v":" "}," ",{"$f":"IF(+A53=\"Totals\",SUM($I$15:I52),IF(A52=\"Totals\",\" \",IF(A52=\" \",\" \",E53+G53)))","v":" "}]
[" "," ",{"$f":"IF(A54=\"Totals\",SUM(C15:$C$53),IF(A53=\"Totals\",\" \",IF(A53=\" \",\" \",+B54*($E$5/100))))","v":" "}," ",{"$f":"IF(A54=\"Totals\",SUM($E$15:E53),IF(A53=\"Totals\",\" \",IF(A53=\" \",\" \",+(B54+C54)*($G$5/100))))","v":" "}," ",{"$f":"IF(A54=\"Totals\",SUM($G$15:G53),IF(A53=\"Totals\",\" \",IF(A53=\" \",\" \",+C54*($G$8/100))))","v":" "}," ",{"$f":"IF(+A54=\"Totals\",SUM($I$15:I53),IF(A53=\"Totals\",\" \",IF(A53=\" \",\" \",E54+G54)))","v":" "}]
[" "," ",{"$f":"IF(A55=\"Totals\",SUM(C15:$C$54),IF(A54=\"Totals\",\" \",IF(A54=\" \",\" \",+B55*($E$5/100))))","v":" "}," ",{"$f":"IF(A55=\"Totals\",SUM($E$15:E54),IF(A54=\"Totals\",\" \",IF(A54=\" \",\" \",+(B55+C55)*($G$5/100))))","v":" "}," ",{"$f":"IF(A55=\"Totals\",SUM($G$15:G54),IF(A54=\"Totals\",\" \",IF(A54=\" \",\" \",+C55*($G$8/100))))","v":" "}," ",{"$f":"IF(+A55=\"Totals\",SUM($I$15:I54),IF(A54=\"Totals\",\" \",IF(A54=\" \",\" \",E55+G55)))","v":" "}]
[" "," ",{"$f":"IF(A56=\"Totals\",SUM(C15:$C$55),IF(A55=\"Totals\",\" \",IF(A55=\" \",\" \",+B56*($E$5/100))))","v":" "}," ",{"$f":"IF(A56=\"Totals\",SUM($E$15:E55),IF(A55=\"Totals\",\" \",IF(A55=\" \",\" \",+(B56+C56)*($G$5/100))))","v":" "}," ",{"$f":"IF(A56=\"Totals\",SUM($G$15:G55),IF(A55=\"Totals\",\" \",IF(A55=\" \",\" \",+C56*($G$8/100))))","v":" "}," ",{"$f":"IF(+A56=\"Totals\",SUM($I$15:I55),IF(A55=\"Totals\",\" \",IF(A55=\" \",\" \",E56+G56)))","v":" "}]
[" "," ",{"$f":"IF(A57=\"Totals\",SUM(C15:$C$56),IF(A56=\"Totals\",\" \",IF(A56=\" \",\" \",+B57*($E$5/100))))","v":" "}," ",{"$f":"IF(A57=\"Totals\",SUM($E$15:E56),IF(A56=\"Totals\",\" \",IF(A56=\" \",\" \",+(B57+C57)*($G$5/100))))","v":" "}," ",{"$f":"IF(A57=\"Totals\",SUM($G$15:G56),IF(A56=\"Totals\",\" \",IF(A56=\" \",\" \",+C57*($G$8/100))))","v":" "}," ",{"$f":"IF(+A57=\"Totals\",SUM($I$15:I56),IF(A56=\"Totals\",\" \",IF(A56=\" \",\" \",E57+G57)))","v":" "}]
[" "," ",{"$f":"IF(A58=\"Totals\",SUM(C15:$C$57),IF(A57=\"Totals\",\" \",IF(A57=\" \",\" \",+B58*($E$5/100))))","v":" "}," ",{"$f":"IF(A58=\"Totals\",SUM($E$15:E57),IF(A57=\"Totals\",\" \",IF(A57=\" \",\" \",+(B58+C58)*($G$5/100))))","v":" "}," ",{"$f":"IF(A58=\"Totals\",SUM($G$15:G57),IF(A57=\"Totals\",\" \",IF(A57=\" \",\" \",+C58*($G$8/100))))","v":" "}," ",{"$f":"IF(+A58=\"Totals\",SUM($I$15:I57),IF(A57=\"Totals\",\" \",IF(A57=\" \",\" \",E58+G58)))","v":" "}]
[" "," ",{"$f":"IF(A59=\"Totals\",SUM(C15:$C$58),IF(A58=\"Totals\",\" \",IF(A58=\" \",\" \",+B59*($E$5/100))))","v":" "}," ",{"$f":"IF(A59=\"Totals\",SUM($E$15:E58),IF(A58=\"Totals\",\" \",IF(A58=\" \",\" \",+(B59+C59)*($G$5/100))))","v":" "}," ",{"$f":"IF(A59=\"Totals\",SUM($G$15:G58),IF(A58=\"Totals\",\" \",IF(A58=\" \",\" \",+C59*($G$8/100))))","v":" "}," ",{"$f":"IF(+A59=\"Totals\",SUM($I$15:I58),IF(A58=\"Totals\",\" \",IF(A58=\" \",\" \",E59+G59)))","v":" "}]
[" "," ",{"$f":"IF(A60=\"Totals\",SUM(C15:$C$59),IF(A59=\"Totals\",\" \",IF(A59=\" \",\" \",+B60*($E$5/100))))","v":" "}," ",{"$f":"IF(A60=\"Totals\",SUM($E$15:E59),IF(A59=\"Totals\",\" \",IF(A59=\" \",\" \",+(B60+C60)*($G$5/100))))","v":" "}," ",{"$f":"IF(A60=\"Totals\",SUM($G$15:G59),IF(A59=\"Totals\",\" \",IF(A59=\" \",\" \",+C60*($G$8/100))))","v":" "}," ",{"$f":"IF(+A60=\"Totals\",SUM($I$15:I59),IF(A59=\"Totals\",\" \",IF(A59=\" \",\" \",E60+G60)))","v":" "}]
[" "," ",{"$f":"IF(A61=\"Totals\",SUM(C15:$C$60),IF(A60=\"Totals\",\" \",IF(A60=\" \",\" \",+B61*($E$5/100))))","v":" "}," ",{"$f":"IF(A61=\"Totals\",SUM($E$15:E60),IF(A60=\"Totals\",\" \",IF(A60=\" \",\" \",+(B61+C61)*($G$5/100))))","v":" "}," ",{"$f":"IF(A61=\"Totals\",SUM($G$15:G60),IF(A60=\"Totals\",\" \",IF(A60=\" \",\" \",+C61*($G$8/100))))","v":" "}," ",{"$f":"IF(+A61=\"Totals\",SUM($I$15:I60),IF(A60=\"Totals\",\" \",IF(A60=\" \",\" \",E61+G61)))","v":" "}]
[" "," ",{"$f":"IF(A62=\"Totals\",SUM(C15:$C$61),IF(A61=\"Totals\",\" \",IF(A61=\" \",\" \",+B62*($E$5/100))))","v":" "}," ",{"$f":"IF(A62=\"Totals\",SUM($E$15:E61),IF(A61=\"Totals\",\" \",IF(A61=\" \",\" \",+(B62+C62)*($G$5/100))))","v":" "}," ",{"$f":"IF(A62=\"Totals\",SUM($G$15:G61),IF(A61=\"Totals\",\" \",IF(A61=\" \",\" \",+C62*($G$8/100))))","v":" "}," ",{"$f":"IF(+A62=\"Totals\",SUM($I$15:I61),IF(A61=\"Totals\",\" \",IF(A61=\" \",\" \",E62+G62)))","v":" "}]
[" "," ",{"$f":"IF(A63=\"Totals\",SUM(C15:$C$62),IF(A62=\"Totals\",\" \",IF(A62=\" \",\" \",+B63*($E$5/100))))","v":" "}," ",{"$f":"IF(A63=\"Totals\",SUM($E$15:E62),IF(A62=\"Totals\",\" \",IF(A62=\" \",\" \",+(B63+C63)*($G$5/100))))","v":" "}," ",{"$f":"IF(A63=\"Totals\",SUM($G$15:G62),IF(A62=\"Totals\",\" \",IF(A62=\" \",\" \",+C63*($G$8/100))))","v":" "}," ",{"$f":"IF(+A63=\"Totals\",SUM($I$15:I62),IF(A62=\"Totals\",\" \",IF(A62=\" \",\" \",E63+G63)))","v":" "}]
[" "," ",{"$f":"IF(A64=\"Totals\",SUM(C15:$C$63),IF(A63=\"Totals\",\" \",IF(A63=\" \",\" \",+B64*($E$5/100))))","v":" "}," ",{"$f":"IF(A64=\"Totals\",SUM($E$15:E63),IF(A63=\"Totals\",\" \",IF(A63=\" \",\" \",+(B64+C64)*($G$5/100))))","v":" "}," ",{"$f":"IF(A64=\"Totals\",SUM($G$15:G63),IF(A63=\"Totals\",\" \",IF(A63=\" \",\" \",+C64*($G$8/100))))","v":" "}," ",{"$f":"IF(+A64=\"Totals\",SUM($I$15:I63),IF(A63=\"Totals\",\" \",IF(A63=\" \",\" \",E64+G64)))","v":" "}]
[" ",{"$f":"IF(+A65=\"Totals\",+B64+C64,IF(+A64=\"Totals\",\" \",IF(+A64=\" \",\" \",+B64+C64+$B$8)))","v":" "},{"$f":"IF(A65=\"Totals\",SUM(C15:$C$64),IF(A64=\"Totals\",\" \",IF(A64=\" \",\" \",+B65*($E$5/100))))","v":" "}," ",{"$f":"IF(A65=\"Totals\",SUM($E$15:E64),IF(A64=\"Totals\",\" \",IF(A64=\" \",\" \",+(B65+C65)*($G$5/100))))","v":" "}," ",{"$f":"IF(A65=\"Totals\",SUM($G$15:G64),IF(A64=\"Totals\",\" \",IF(A64=\" \",\" \",+C65*($G$8/100))))","v":" "}," ",{"$f":"IF(+A65=\"Totals\",SUM($I$15:I64),IF(A64=\"Totals\",\" \",IF(A64=\" \",\" \",E65+G65)))","v":" "}]

{"sheet":"Retirement Income","index":1,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,7],[6,5,6,7],[7,5,7,7],[3,0,3,1],[4,0,4,1],[6,0,6,1],[7,0,7,1],[3,5,3,7],[4,5,4,7]]}
["Retirement Income Calculator"]
[]
[]
["Initial Balance",null,null,null,null,"Rate of Return"]
[100000,null,null,"Years of ",null,5]
[null,null,null,"Withdrawing"]
["Withdrawal Rate",null,null,25,null,"Tax Rate"]
[3,null,null,null," ",35]
[]
[]
[]
[null,"Beginning ",null,"Gross",null,"Taxes Due",null,"Total Net"]
["Year","Balance",null,"Withdrawal",null,"On Withdrawal",null,"Income"]
[{"$f":"IF($D$7=0,\" \",1)","v":1},{"$f":"IF(+$A$5=0,\" \",$A$5)","v":100000},null,{"$f":"IF(+$A$8=0,\" \",($A$8/100)*B14)","v":3000},null,{"$f":"IF(A14=\" \",\" \",+D14*($F$8/100))","v":1050},null,{"$f":"IF(A14=\" \",\" \",+D14-F14)","v":1950}]
[{"$f":"IF(A14=\" \",\" \",IF(A14=$D$7,\"Totals\",IF(A14=\"Totals\",\" \",+A14+1)))","v":2},{"$f":"IF(A15=\" \",\" \",+B14+(B14*($F$5/100)-D14))","v":102000},null,{"$f":"IF(A15=\" \",\" \",IF(A15=\"Totals\",SUM(D14),(+$A$8/100)*$B$14))","v":3000},null,{"$f":"IF(A15=\" \",\" \",IF(A15=\"Totals\",SUM(F14),+D15*($F$8/100)))","v":1050},null,{"$f":"IF(A15=\" \",\" \",IF(A15=\"Totals\",SUM(H14),+D15-F15))","v":1950}]
[3,{"$f":"IF(A16=\" \",\" \",+B15+(B15*($F$5/100)-D15))","v":104100},null,{"$f":"IF(A16=\" \",\" \",IF(A16=\"Totals\",SUM($D$14:D15),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A16=\" \",\" \",IF(A16=\"Totals\",SUM($F$14:F15),+D16*($F$8/100)))","v":1050},null,{"$f":"IF(A16=\" \",\" \",IF(A16=\"Totals\",SUM($H$14:H15),+D16-F16))","v":1950}]
[4,{"$f":"IF(A17=\" \",\" \",+B16+(B16*($F$5/100)-D16))","v":106305},null,{"$f":"IF(A17=\" \",\" \",IF(A17=\"Totals\",SUM($D$14:D16),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A17=\" \",\" \",IF(A17=\"Totals\",SUM($F$14:F16),+D17*($F$8/100)))","v":1050},null,{"$f":"IF(A17=\" \",\" \",IF(A17=\"Totals\",SUM($H$14:H16),+D17-F17))","v":1950}]
[5,108620.25,null,{"$f":"IF(A18=\" \",\" \",IF(A18=\"Totals\",SUM($D$14:D17),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A18=\" \",\" \",IF(A18=\"Totals\",SUM($F$14:F17),+D18*($F$8/100)))","v":1050},null,{"$f":"IF(A18=\" \",\" \",IF(A18=\"Totals\",SUM($H$14:H17),+D18-F18))","v":1950}]
[6,111051.2625,null,{"$f":"IF(A19=\" \",\" \",IF(A19=\"Totals\",SUM($D$14:D18),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A19=\" \",\" \",IF(A19=\"Totals\",SUM($F$14:F18),+D19*($F$8/100)))","v":1050},null,{"$f":"IF(A19=\" \",\" \",IF(A19=\"Totals\",SUM($H$14:H18),+D19-F19))","v":1950}]
[7,113603.825625,null,{"$f":"IF(A20=\" \",\" \",IF(A20=\"Totals\",SUM($D$14:D19),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A20=\" \",\" \",IF(A20=\"Totals\",SUM($F$14:F19),+D20*($F$8/100)))","v":1050},null,{"$f":"IF(A20=\" \",\" \",IF(A20=\"Totals\",SUM($H$14:H19),+D20-F20))","v":1950}]
[8,116284.01690624999,null,{"$f":"IF(A21=\" \",\" \",IF(A21=\"Totals\",SUM($D$14:D20),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A21=\" \",\" \",IF(A21=\"Totals\",SUM($F$14:F20),+D21*($F$8/100)))","v":1050},null,{"$f":"IF(A21=\" \",\" \",IF(A21=\"Totals\",SUM($H$14:H20),+D21-F21))","v":1950}]
[9,119098.21775156249,null,{"$f":"IF(A22=\" \",\" \",IF(A22=\"Totals\",SUM($D$14:D21),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A22=\" \",\" \",IF(A22=\"Totals\",SUM($F$14:F21),+D22*($F$8/100)))","v":1050},null,{"$f":"IF(A22=\" \",\" \",IF(A22=\"Totals\",SUM($H$14:H21),+D22-F22))","v":1950}]
[10,122053.12863914062,null,{"$f":"IF(A23=\" \",\" \",IF(A23=\"Totals\",SUM($D$14:D22),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A23=\" \",\" \",IF(A23=\"Totals\",SUM($F$14:F22),+D23*($F$8/100)))","v":1050},null,{"$f":"IF(A23=\" \",\" \",IF(A23=\"Totals\",SUM($H$14:H22),+D23-F23))","v":1950}]
[11,125155.78507109765,null,{"$f":"IF(A24=\" \",\" \",IF(A24=\"Totals\",SUM($D$14:D23),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A24=\" \",\" \",IF(A24=\"Totals\",SUM($F$14:F23),+D24*($F$8/100)))","v":1050},null,{"$f":"IF(A24=\" \",\" \",IF(A24=\"Totals\",SUM($H$14:H23),+D24-F24))","v":1950}]
[12,128413.57432465254,null,{"$f":"IF(A25=\" \",\" \",IF(A25=\"Totals\",SUM($D$14:D24),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A25=\" \",\" \",IF(A25=\"Totals\",SUM($F$14:F24),+D25*($F$8/100)))","v":1050},null,{"$f":"IF(A25=\" \",\" \",IF(A25=\"Totals\",SUM($H$14:H24),+D25-F25))","v":1950}]
[13,131834.25304088517,null,{"$f":"IF(A26=\" \",\" \",IF(A26=\"Totals\",SUM($D$14:D25),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A26=\" \",\" \",IF(A26=\"Totals\",SUM($F$14:F25),+D26*($F$8/100)))","v":1050},null,{"$f":"IF(A26=\" \",\" \",IF(A26=\"Totals\",SUM($H$14:H25),+D26-F26))","v":1950}]
[14,135425.96569292943,null,{"$f":"IF(A27=\" \",\" \",IF(A27=\"Totals\",SUM($D$14:D26),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A27=\" \",\" \",IF(A27=\"Totals\",SUM($F$14:F26),+D27*($F$8/100)))","v":1050},null,{"$f":"IF(A27=\" \",\" \",IF(A27=\"Totals\",SUM($H$14:H26),+D27-F27))","v":1950}]
[15,139197.2639775759,null,{"$f":"IF(A28=\" \",\" \",IF(A28=\"Totals\",SUM($D$14:D27),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A28=\" \",\" \",IF(A28=\"Totals\",SUM($F$14:F27),+D28*($F$8/100)))","v":1050},null,{"$f":"IF(A28=\" \",\" \",IF(A28=\"Totals\",SUM($H$14:H27),+D28-F28))","v":1950}]
[16,143157.1271764547,null,{"$f":"IF(A29=\" \",\" \",IF(A29=\"Totals\",SUM($D$14:D28),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A29=\" \",\" \",IF(A29=\"Totals\",SUM($F$14:F28),+D29*($F$8/100)))","v":1050},null,{"$f":"IF(A29=\" \",\" \",IF(A29=\"Totals\",SUM($H$14:H28),+D29-F29))","v":1950}]
[17,147314.98353527742,null,{"$f":"IF(A30=\" \",\" \",IF(A30=\"Totals\",SUM($D$14:D29),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A30=\" \",\" \",IF(A30=\"Totals\",SUM($F$14:F29),+D30*($F$8/100)))","v":1050},null,{"$f":"IF(A30=\" \",\" \",IF(A30=\"Totals\",SUM($H$14:H29),+D30-F30))","v":1950}]
[18,151680.7327120413,null,{"$f":"IF(A31=\" \",\" \",IF(A31=\"Totals\",SUM($D$14:D30),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A31=\" \",\" \",IF(A31=\"Totals\",SUM($F$14:F30),+D31*($F$8/100)))","v":1050},null,{"$f":"IF(A31=\" \",\" \",IF(A31=\"Totals\",SUM($H$14:H30),+D31-F31))","v":1950}]
[19,156264.76934764336,null,{"$f":"IF(A32=\" \",\" \",IF(A32=\"Totals\",SUM($D$14:D31),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A32=\" \",\" \",IF(A32=\"Totals\",SUM($F$14:F31),+D32*($F$8/100)))","v":1050},null,{"$f":"IF(A32=\" \",\" \",IF(A32=\"Totals\",SUM($H$14:H31),+D32-F32))","v":1950}]
[20,161078.00781502554,null,{"$f":"IF(A33=\" \",\" \",IF(A33=\"Totals\",SUM($D$14:D32),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A33=\" \",\" \",IF(A33=\"Totals\",SUM($F$14:F32),+D33*($F$8/100)))","v":1050},null,{"$f":"IF(A33=\" \",\" \",IF(A33=\"Totals\",SUM($H$14:H32),+D33-F33))","v":1950}]
[21,166131.90820577682,null,{"$f":"IF(A34=\" \",\" \",IF(A34=\"Totals\",SUM($D$14:D33),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A34=\" \",\" \",IF(A34=\"Totals\",SUM($F$14:F33),+D34*($F$8/100)))","v":1050},null,{"$f":"IF(A34=\" \",\" \",IF(A34=\"Totals\",SUM($H$14:H33),+D34-F34))","v":1950}]
[22,171438.50361606566,null,{"$f":"IF(A35=\" \",\" \",IF(A35=\"Totals\",SUM($D$14:D34),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A35=\" \",\" \",IF(A35=\"Totals\",SUM($F$14:F34),+D35*($F$8/100)))","v":1050},null,{"$f":"IF(A35=\" \",\" \",IF(A35=\"Totals\",SUM($H$14:H34),+D35-F35))","v":1950}]
[23,177010.42879686895,null,{"$f":"IF(A36=\" \",\" \",IF(A36=\"Totals\",SUM($D$14:D35),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A36=\" \",\" \",IF(A36=\"Totals\",SUM($F$14:F35),+D36*($F$8/100)))","v":1050},null,{"$f":"IF(A36=\" \",\" \",IF(A36=\"Totals\",SUM($H$14:H35),+D36-F36))","v":1950}]
[24,182860.95023671241,null,{"$f":"IF(A37=\" \",\" \",IF(A37=\"Totals\",SUM($D$14:D36),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A37=\" \",\" \",IF(A37=\"Totals\",SUM($F$14:F36),+D37*($F$8/100)))","v":1050},null,{"$f":"IF(A37=\" \",\" \",IF(A37=\"Totals\",SUM($H$14:H36),+D37-F37))","v":1950}]
[25,189003.99774854802,null,{"$f":"IF(A38=\" \",\" \",IF(A38=\"Totals\",SUM($D$14:D37),((+$A$8/100)*$B$14)))","v":3000},null,{"$f":"IF(A38=\" \",\" \",IF(A38=\"Totals\",SUM($F$14:F37),+D38*($F$8/100)))","v":1050},null,{"$f":"IF(A38=\" \",\" \",IF(A38=\"Totals\",SUM($H$14:H37),+D38-F38))","v":1950}]
["Totals",195454.19763597543,null,{"$f":"IF(A39=\" \",\" \",IF(A39=\"Totals\",SUM($D$14:D38),((+$A$8/100)*$B$14)))","v":75000},null,{"$f":"IF(A39=\" \",\" \",IF(A39=\"Totals\",SUM($F$14:F38),+D39*($F$8/100)))","v":26250},null,{"$f":"IF(A39=\" \",\" \",IF(A39=\"Totals\",SUM($H$14:H38),+D39-F39))","v":48750}]
[" "," ",null,{"$f":"IF(A40=\" \",\" \",IF(A40=\"Totals\",SUM($D$14:D39),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A40=\" \",\" \",IF(A40=\"Totals\",SUM($F$14:F39),+D40*($F$8/100)))","v":" "},null,{"$f":"IF(A40=\" \",\" \",IF(A40=\"Totals\",SUM($H$14:H39),+D40-F40))","v":" "}]
[" "," ",null,{"$f":"IF(A41=\" \",\" \",IF(A41=\"Totals\",SUM($D$14:D40),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A41=\" \",\" \",IF(A41=\"Totals\",SUM($F$14:F40),+D41*($F$8/100)))","v":" "},null,{"$f":"IF(A41=\" \",\" \",IF(A41=\"Totals\",SUM($H$14:H40),+D41-F41))","v":" "}]
[" "," ",null,{"$f":"IF(A42=\" \",\" \",IF(A42=\"Totals\",SUM($D$14:D41),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A42=\" \",\" \",IF(A42=\"Totals\",SUM($F$14:F41),+D42*($F$8/100)))","v":" "},null,{"$f":"IF(A42=\" \",\" \",IF(A42=\"Totals\",SUM($H$14:H41),+D42-F42))","v":" "}]
[" "," ",null,{"$f":"IF(A43=\" \",\" \",IF(A43=\"Totals\",SUM($D$14:D42),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A43=\" \",\" \",IF(A43=\"Totals\",SUM($F$14:F42),+D43*($F$8/100)))","v":" "},null,{"$f":"IF(A43=\" \",\" \",IF(A43=\"Totals\",SUM($H$14:H42),+D43-F43))","v":" "}]
[" "," ",null,{"$f":"IF(A44=\" \",\" \",IF(A44=\"Totals\",SUM($D$14:D43),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A44=\" \",\" \",IF(A44=\"Totals\",SUM($F$14:F43),+D44*($F$8/100)))","v":" "},null,{"$f":"IF(A44=\" \",\" \",IF(A44=\"Totals\",SUM($H$14:H43),+D44-F44))","v":" "}]
[" "," ",null,{"$f":"IF(A45=\" \",\" \",IF(A45=\"Totals\",SUM($D$14:D44),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A45=\" \",\" \",IF(A45=\"Totals\",SUM($F$14:F44),+D45*($F$8/100)))","v":" "},null,{"$f":"IF(A45=\" \",\" \",IF(A45=\"Totals\",SUM($H$14:H44),+D45-F45))","v":" "}]
[" "," ",null,{"$f":"IF(A46=\" \",\" \",IF(A46=\"Totals\",SUM($D$14:D45),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A46=\" \",\" \",IF(A46=\"Totals\",SUM($F$14:F45),+D46*($F$8/100)))","v":" "},null,{"$f":"IF(A46=\" \",\" \",IF(A46=\"Totals\",SUM($H$14:H45),+D46-F46))","v":" "}]
[" "," ",null,{"$f":"IF(A47=\" \",\" \",IF(A47=\"Totals\",SUM($D$14:D46),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A47=\" \",\" \",IF(A47=\"Totals\",SUM($F$14:F46),+D47*($F$8/100)))","v":" "},null,{"$f":"IF(A47=\" \",\" \",IF(A47=\"Totals\",SUM($H$14:H46),+D47-F47))","v":" "}]
[" "," ",null,{"$f":"IF(A48=\" \",\" \",IF(A48=\"Totals\",SUM($D$14:D47),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A48=\" \",\" \",IF(A48=\"Totals\",SUM($F$14:F47),+D48*($F$8/100)))","v":" "},null,{"$f":"IF(A48=\" \",\" \",IF(A48=\"Totals\",SUM($H$14:H47),+D48-F48))","v":" "}]
[" "," ",null,{"$f":"IF(A49=\" \",\" \",IF(A49=\"Totals\",SUM($D$14:D48),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A49=\" \",\" \",IF(A49=\"Totals\",SUM($F$14:F48),+D49*($F$8/100)))","v":" "},null,{"$f":"IF(A49=\" \",\" \",IF(A49=\"Totals\",SUM($H$14:H48),+D49-F49))","v":" "}]
[" "," ",null,{"$f":"IF(A50=\" \",\" \",IF(A50=\"Totals\",SUM($D$14:D49),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A50=\" \",\" \",IF(A50=\"Totals\",SUM($F$14:F49),+D50*($F$8/100)))","v":" "},null,{"$f":"IF(A50=\" \",\" \",IF(A50=\"Totals\",SUM($H$14:H49),+D50-F50))","v":" "}]
[" "," ",null,{"$f":"IF(A51=\" \",\" \",IF(A51=\"Totals\",SUM($D$14:D50),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A51=\" \",\" \",IF(A51=\"Totals\",SUM($F$14:F50),+D51*($F$8/100)))","v":" "},null,{"$f":"IF(A51=\" \",\" \",IF(A51=\"Totals\",SUM($H$14:H50),+D51-F51))","v":" "}]
[" "," ",null,{"$f":"IF(A52=\" \",\" \",IF(A52=\"Totals\",SUM($D$14:D51),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A52=\" \",\" \",IF(A52=\"Totals\",SUM($F$14:F51),+D52*($F$8/100)))","v":" "},null,{"$f":"IF(A52=\" \",\" \",IF(A52=\"Totals\",SUM($H$14:H51),+D52-F52))","v":" "}]
[" "," ",null,{"$f":"IF(A53=\" \",\" \",IF(A53=\"Totals\",SUM($D$14:D52),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A53=\" \",\" \",IF(A53=\"Totals\",SUM($F$14:F52),+D53*($F$8/100)))","v":" "},null,{"$f":"IF(A53=\" \",\" \",IF(A53=\"Totals\",SUM($H$14:H52),+D53-F53))","v":" "}]
[" "," ",null,{"$f":"IF(A54=\" \",\" \",IF(A54=\"Totals\",SUM($D$14:D53),((+$A$8/100)*$B$14)))","v":" "},null,{"$f":"IF(A54=\" \",\" \",IF(A54=\"Totals\",SUM($F$14:F53),+D54*($F$8/100)))","v":" "},null,{"$f":"IF(A54=\" \",\" \",IF(A54=\"Totals\",SUM($H$14:H53),+D54-F54))","v":" "}]

{"sheet":"Random Returns","index":2,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Random Returns"]
[]
[]
[null,null,"Initial Balance",null,null,"Withdrawal Rate",null,"Participation Rate"]
[null,null,250000,null,null,0.05,null,0.4]
[null,null,null,null,null,"  "]
[]
[]
[]
[null,null," Beginning",null,"Historical","Annual",null," Beginning",null,"Annuity","Annual"]
[null,null," Balance",null,"Return","Withdrawal",null," Balance",null,"Return","Withdrawal"]
[null,null,{"$f":"C5","v":250000},{"$f":"RAND()*(1-100)+100","v":79.96995743801476},0.1278,{"$f":"$C$5*$F$5","v":12500},null,{"$f":"C5","v":250000},{"$f":"RAND()*(1-100)+100","v":91.178122357384353},{"$f":"IF(E12>0,E12*$H$5,0)","v":5.1119999999999999E-2},{"$f":"$C$5*$F$5","v":12500}]
[null,null,{"$f":"C12*(1+E12)-F12","v":269450},{"$f":"RAND()*(1-100)+100","v":5.3394672597141408},-1.12E-2,{"$f":"$C$5*$F$5","v":12500},null,{"$f":"H12*(1+J12)-K12","v":250280},{"$f":"RAND()*(1-100)+100","v":47.324849896949395},{"$f":"IF(E13>0,E13*$H$5,0)","v":0},{"$f":"$C$5*$F$5","v":12500}]
[null,null,{"$f":"C13*(1+E13)-F13","v":253932.15999999997},{"$f":"RAND()*(1-100)+100","v":42.710917166873372},0.26379999999999998,12500,null,{"$f":"H13*(1+J13)-K13","v":237780},{"$f":"RAND()*(1-100)+100","v":14.438029083753179},{"$f":"IF(E14>0,E14*$H$5,0)","v":0.10552},12500]
[null,null,308419.46380799997,{"$f":"RAND()*(1-100)+100","v":6.7809382899913686},-0.13039999999999999,12500,null,250370.54560000001,{"$f":"RAND()*(1-100)+100","v":53.629849892765485},{"$f":"IF(E15>0,E15*$H$5,0)","v":0},12500]
[null,null,255701.5657274368,{"$f":"RAND()*(1-100)+100","v":50.823384812206008},0.23449999999999999,12500,null,237870.54560000001,{"$f":"RAND()*(1-100)+100","v":51.180260713835764},{"$f":"IF(E16>0,E16*$H$5,0)","v":9.3799999999999994E-2},12500]
[null,null,303163.58289052069,{"$f":"RAND()*(1-100)+100","v":12.690716473698274},-0.38490000000000002,12500,null,247682.80277727998,{"$f":"RAND()*(1-100)+100","v":15.59650456290899},{"$f":"IF(E17>0,E17*$H$5,0)","v":0},12500]
[null,null,173975.91983595927,{"$f":"RAND()*(1-100)+100","v":87.165934892164188},4.2200000000000001E-2,12500,null,235182.80277727998,{"$f":"RAND()*(1-100)+100","v":54.282285421158974},{"$f":"IF(E18>0,E18*$H$5,0)","v":1.6880000000000003E-2},12500]
[null,null,168817.70365303676,{"$f":"RAND()*(1-100)+100","v":9.0331247448519321},0.13619999999999999,12500,null,{"$f":"H18*(1+J18)-K18","v":226652.68848816046},{"$f":"RAND()*(1-100)+100","v":99.104651404652344},{"$f":"IF(E19>0,E19*$H$5,0)","v":5.4480000000000001E-2},12500]
[null,null,179310.67489058038,{"$f":"RAND()*(1-100)+100","v":27.723562925763702},8.9899999999999994E-2,12500,null,226500.72695699547,{"$f":"RAND()*(1-100)+100","v":88.783702426988242},{"$f":"IF(E20>0,E20*$H$5,0)","v":3.5959999999999999E-2},12500]
[null,null,182930.70456324358,{"$f":"RAND()*(1-100)+100","v":8.1780633301840453},0.1951,12500,null,222145.69309836903,{"$f":"RAND()*(1-100)+100","v":92.110699113918258},{"$f":"IF(E21>0,E21*$H$5,0)","v":7.8039999999999998E-2},12500]
[null,null,206120.48502353241,{"$f":"RAND()*(1-100)+100","v":35.683541372669836},0.03,12500,null,226981.94298776577,{"$f":"RAND()*(1-100)+100","v":93.060285611634271},{"$f":"IF(E22>0,E22*$H$5,0)","v":1.2E-2},12500]
[null,null,199804.09957423838,{"$f":"RAND()*(1-100)+100","v":17.235145236691352},-0.1014,12500,null,217205.72630361895,{"$f":"RAND()*(1-100)+100","v":88.506759660762597},{"$f":"IF(E23>0,E23*$H$5,0)","v":0},12500]
[null,null,167043.9638774106,{"$f":"RAND()*(1-100)+100","v":6.224823483814788},-0.23369999999999999,12500,null,204705.72630361895,{"$f":"RAND()*(1-100)+100","v":81.369961851887979},{"$f":"IF(E24>0,E24*$H$5,0)","v":0},12500]
[null,null,115505.78951925974,null,null,12500,null,192205.72630361895,null,{"$f":"IF(B25=1991,0.1315,IF(B25=1992,0.0446,IF(B25=1993,0.0353,IF(B25=1994,0,IF(B25=1995,0.1705,IF(B25=1996,0.1013,IF(B25=1997,0.155,IF(B25=1998,0.1335,IF(B25=1999,0.0975,IF(B25=2000,0,IF(B25=2001,0,IF(B25=2002,0,IF(B25=2003,0.1319,IF(B25=2004,0.045,IF(B25=2005,0.03,IF(B25=2006,0.0681,IF(B25=2007,0.0422,IF(B25=2008,0,IF(B25=2009,0.1173,IF(B25=2010,0.0639,IF(B25=2011,0,\" \")))))))))))))))))))))","v":" "},12500]