{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["401K Planner"],"not_rendered":{"charts":1,"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"401K Planner","index":0,"n_rows":61,"n_cols":9,"rows_kept":61,"merged":[[42,0,42,9]]}
[]
[]
[null,"401K Planner"]
[null,"Your Name"]
[null,{"$f":"NOW()","v":"2010-04-21T08:57:15.680"}]
[]
[null,null,"Assumptions"]
[null,null,"401K Contribution per paycheck",{"$nulls":5},{"v":100,"d":"$100"}]
[null,null,"401K Employer contribution match per paycheck",{"$nulls":5},{"v":25,"d":"$25"}]
[null,null,"Paychecks per year (12, 24, 26, and 52)",{"$nulls":5},{"v":52,"d":"52 "}]
[null,null,"Expected annual rate of return",{"$nulls":5},{"v":0.1,"d":"10%"}]
[null,null,"Age as of the end of this tax year",{"$nulls":5},{"v":30,"d":"30 "}]
[null,null,"Anticipated retirement age",{"$nulls":5},{"v":65,"d":"65 "}]
[null,null,"Current value of 401K",{"$nulls":5},{"v":5000,"d":"$5,000"}]
[null,null,"Date (the \"as of\" date for the current value)",{"$nulls":5},"2006-09-01"]
[null,null,"Enter the date of the year end",{"$nulls":5},"2006-12-31"]
[null,null,"Marginal Tax Rate (Federal plus State)",{"$nulls":5},{"v":0.4,"d":"40%"}]
[]
[null,null,"Tax Deferred 401K Plan Growth",{"$nulls":3},"Taxable Savings Plan Growth"]
[null,null,"Age",null,"Estimated 401K Value",null,"Age",null,"Estimated Savings Value"]
[null,null,{"$f":"+C54","v":{"v":30,"d":"30 "}},null,{"$f":"IF(SUM(C21),+I14*(1+I11*(I16-I15)/(340+25))+FV(I11/((340+25)/C49),C52,-SUM(I8:I9)),\"\")","v":{"v":7360.542364559511,"d":"$7,361"}},null,{"$f":"C21","v":{"v":30,"d":"30 "}},null,{"$f":"IF(SUM(G21),+I14*(1+(I11*(1-I17))*(I16-I15)/(340+25))+FV((I11*(1-I17))/((340+25)/C49),C52,-SUM(I8:I9)),\"\")","v":{"v":7280.531126893524,"d":"$7,281"}}]
[null,null,{"$f":"+C55","v":{"v":35,"d":"35 "}},null,{"$f":"IF(SUM(C22),((E21*((1+I11)^(C22-C21))+FV((I11/(I10)),(C22-C21)*I10,-(I8+I9)))),\"\")","v":{"v":53969.66545031682,"d":"$53,970"}},null,{"$f":"C22","v":{"v":35,"d":"35 "}},null,{"$f":"IF(SUM(G22),((I21*((1+(I11*(1-I17)))^(C22-C21))+FV(((I11*(1-I17))/(I10)),(C22-C21)*I10,-(I8+I9)))),\"\")","v":{"v":47619.07557968102,"d":"$47,619"}}]
[null,null,{"$f":"+C56","v":{"v":45,"d":"45 "}},null,{"$f":"IF(SUM(C23),((E22*((1+I11)^(C23-C22))+FV((I11/(I10)),(C23-C22)*I10,-(I8+I9)))),\"\")","v":{"v":251502.1380128837,"d":"$251,502"}},null,{"$f":"C23","v":{"v":45,"d":"45 "}},null,{"$f":"IF(SUM(G23),((I22*((1+(I11*(1-I17)))^(C23-C22))+FV(((I11*(1-I17))/(I10)),(C23-C22)*I10,-(I8+I9)))),\"\")","v":{"v":174273.11672305333,"d":"$174,273"}}]
[null,null,{"$f":"+C57","v":{"v":65,"d":"65 "}},null,{"$f":"IF(SUM(C24),((E23*((1+I11)^(C24-C23))+FV((I11/(I10)),(C24-C23)*I10,-(I8+I9)))),\"\")","v":{"v":2106347.702861803,"d":"$2,106,348"}},null,{"$f":"C24","v":{"v":65,"d":"65 "}},null,{"$f":"IF(SUM(G24),((E23*((1+(I11*(1-I17)))^(C24-C23))+FV(((I11*(1-I17))/(I10)),(C24-C23)*I10,-(I8+I9)))),\"\")","v":{"v":1057698.6967750564,"d":"$1,057,699"}}]
[]
[null,null,"Pre-tax retirement income",{"$nulls":3},"Pre-tax retirement income"]
[null,null,"From retirement age to 90 years old",{"$nulls":3},"From retirement age to 90 years old"]
[null,null,"Monthly income ",null,{"$f":"IF(SUM(C21:C24),IF(SUM(E24),PMT($I$11/12,(90-$I$13)*12,-E24),IF(E23,PMT($I$11/12,(90-$I$13)*12,-E23),PMT($I$11/12,(90-$I$13)*12,-E22))),\"\")","v":{"v":19140.397279571163,"d":"$19,140"}},null,"Monthly income ",null,{"$f":"IF(SUM(G21:G24),IF(SUM(I24),PMT($I$11/12,(90-$I$13)*12,-I24),IF(SUM(I23),PMT($I$11/12,(90-$I$13)*12,-I23),PMT($I$11/12,(90-$I$13)*12,-I22))),\"\")","v":{"v":9611.315943162452,"d":"$9,611"}}]
{"$rows_empty":15}
[null,null,"Days in pay period"]
[null,null,{"$f":"IF(I10=52,7,\"\")","v":7}]
[null,null,{"$f":"IF(I10=26,(340+25)/26,\"\")","v":""}]
[null,null,{"$f":"IF(I10=24,(340+25)/24,\"\")","v":""}]
[null,null,{"$f":"IF(I10=12,(340+25)/12,\"\")","v":""}]
[null,null,{"$f":"SUM(C45:C48)","v":7}]
[]
[null,null,"Compounding periods in first yr"]
[null,null,{"$f":"(+I16-I15)/C49","v":17.285714285714285}]
[]
[null,null,{"$f":"IF(C58<I13,C58,\"\")","v":30},{"$f":"+I12","v":{"v":30,"d":"30 "}},{"$f":"+E21","v":{"v":7360.542364559511,"d":"7,361 "}},{"$f":"+I21","v":{"v":7280.531126893524,"d":"$7,281"}}]
[null,null,{"$f":"IF(C59>C58,C59,\"\")","v":35},{"$f":"I13","v":{"v":65,"d":"65 "}},{"$f":"MAX(E21:E24)","v":{"v":2106347.702861803,"d":"$2,106,348"}},{"$f":"MAX(I21:I24)","v":{"v":1057698.6967750564,"d":"$1,057,699"}}]
[null,null,{"$f":"IF(C60>C59,C60,\"\")","v":45}]
[null,null,{"$f":"IF(C61>C60,C61,\"\")","v":65}]
[null,null,{"$f":"+I12","v":30}]
[null,null,{"$f":"IF($C$58+5>I13,I13,+$C$58+5)","v":35}]
[null,null,{"$f":"IF($C$59+10>I13,I13,+$C$59+10)","v":45}]
[null,null,{"$f":"I13","v":{"v":65,"d":"65 "}}]