401K Planner Use this template to forecast the growth in value of your 401K plan and to project the monthly income you will receive from the plan upon retirement. It also compares the wealth accumulation in the 401K plan in contrast to the growth of a taxable savings plan. The forecasted monthly income during retirement is pre-tax. After tax retirement income will depend on the marginal tax rates upon retirement. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next. 401K Planner <--Enter name in cell to the left <--Enter date in cell to the left Assumptions 401K Contribution per paycheck 401K Employer contribution match per paycheck Paychecks per year (12, 24, 26, and 52) Expected annual rate of return Age as of the end of this tax year Anticipated retirement age Current value of 401K Date (the "as of" date for the current value) Enter the date of the year end Marginal Tax Rate (Federal plus State) Tax Deferred 401K Plan Growth Taxable Savings Plan Growth Age Estimated 401K Value Age Estimated Savings Value Pre-tax retirement income Pre-tax retirement income From retirement age to 90 years old From retirement age to 90 years old Monthly income Monthly income 0 0 401K Taxable Investment $0 $0 $0 $1 $1 $1Ages Growth of Investment 401K Taxable Investment