Question

Ryan Ripley is celebrating his 25^th birthday today by accepting his first job offer as a software engineer with a local manufacturing firm since graduating college about 6 months ago. Ryan will be paid a starting salary of $30,655.68. His salary will be paid in annual installments with his first payment coming 1 year from today. Ryan plans to stay in this job for 41 years, such that he will receive his 41^st and final salary payment on his 66^th birthday. He expects to receive an annual raise of 3%. (Note that his first payment is already set, so he will receive 40 annual raises to his income.)

Ryan has just completed a meeting with his employer’s benefits counselor as part of the on-boarding process and, thus, has some important decisions regarding benefit plan selection. In particular, he is attempting to determine how best to handle his employer’s 401(k) plan. Following the advice of his benefits counselor, Ryan believes that, in retirement, he will want to target a 70% income replacement rate. That is, his first withdrawal from his 401(k) plan, which will occur on his 67^th birthday (1 year after his final salary payment), should be equal to 70% of his final salary payment. Ryan wants to plan for a 30-year retirement, indicating that his last withdrawal should come on his 96^th birthday. He also wants to be able to increase the size of his withdrawal by 2% per year so that his income keeps pace with increases in the cost of living.

Ryan is trying to determine how much of his annual salary he should set aside in his 401(k) plan each year to satisfy his retirement goals. Based off of some of the information gathered in his benefits meeting, he expects to earn a return of 7% per year on his 401(k) balance while working, and 5% per year once retired. Ryan does not have any interest in leaving any money to his heirs and, so, wants his final withdrawal from his retirement account to leave the account balance at zero. To work out what percentage of his salary to contribute to his 401(k) plan, Ryan has drawn up a list of questions to address. Since he isn’t terribly familiar with financial concepts, Ryan has asked for your help in addressing these questions. (Ignore any tax effects.)

What level of income will Ryan need in his first year of retirement? (That is, how large will that first withdrawal on his 67^th birthday need to be?)

How much will Ryan need to have accumulated in his retirement account as of the end of his 41 first year (i.e. by his 66^th birthday) working with the company in order to generate this level of income?

How much would Ryan have to deposit into his retirement account today (age 25) in order to fully fund his retirement goals if he were to make no subsequent deposits?

Realizing that he doesn’t have this much to deposit in a single lumps-sum today, Ryan wants to work out how much of each annual paycheck he would have to contribute to his retirement plan to fund his retirement goals. Assuming that he contributes a fixed percentage of his annual salary to his retirement account every year, what dollar amount would the first year’s contribution have to be?

What percentage of his income does Ryan need to set his contribution rate to?

Answer 1

Current Salary	$    30,655.68
Increament rate	3%
No of annual rise in salary	40
Last Salary	$    99,997.77		(30655*1.03^40)
Replacement rate	70%
Salary after retirement	$    69,998.44		($ 99997.77*70%)
Post retirement rate of return	5%
Pre retirement rate of return	7%
Rate in increase in withdrawl rate	2%
Year	Retirement benefit		Discount factor @5%	PV @ 5%
Y_67	$    69,998.44		0.95238	$        66,665.11
Y_68	$    71,398.41		0.90703	$        64,760.50
Y_69	$    72,826.38		0.86384	$        62,910.34
Y_70	$    74,282.91		0.82270	$        61,112.55
Y_71	$    75,768.57		0.78352	$        59,366.19
Y_72	$    77,283.94		0.74621	$        57,670.05
Y_73	$    78,829.62		0.71068	$        56,022.63
Y_74	$    80,406.21		0.67684	$        54,422.14
Y_75	$    82,014.33		0.64461	$        52,867.26
Y_76	$    83,654.62		0.61391	$        51,356.41
Y_77	$    85,327.71		0.58468	$        49,889.41
Y_78	$    87,034.26		0.55684	$        48,464.16
Y_79	$    88,774.95		0.53032	$        47,079.13
Y_80	$    90,550.45		0.50507	$        45,734.32
Y_81	$    92,361.46		0.48102	$        44,427.71
Y_82	$    94,208.69		0.45811	$        43,157.94
Y_83	$    96,092.86		0.43630	$        41,925.31
Y_84	$    98,014.72		0.41552	$        40,727.08
Y_85	$    99,975.01		0.39573	$        39,563.11
Y_86	$ 101,974.51		0.37689	$        38,433.17
Y_87	$ 104,014.00		0.35894	$        37,334.79
Y_88	$ 106,094.28		0.34185	$        36,268.33
Y_89	$ 108,216.17		0.32557	$        35,231.94
Y_90	$ 110,380.49		0.31007	$        34,225.68
Y_91	$ 112,588.10		0.29530	$        33,247.27
Y_92	$ 114,839.86		0.28124	$        32,297.56
Y_93	$ 117,136.66		0.26785	$        31,375.05
Y_94	$ 119,479.39		0.25510	$        30,479.19
Y_95	$ 121,868.98		0.24295	$        29,608.07
Y_96	$ 124,306.36		0.23138	$        28,762.01
			Total	$ 1,355,384.41
	PV factor of 7% for 41 years			0.06241
			PV at Y_25	$84,589.54	($1355384.41*.06241)
			Equated amount	$ 2,063.16	($84589.54/41)
Income received by Ryan in first year of retirement				$        69,998.44
Amount would have accumulated by Ryan at his retirement to generate this level of income
				$ 1,355,384.41
Equated annual contribution				$ 2,063.16
Percentage of income to be set apart towards contribution to retirement				6.73%	(2063 / 30655.68 *100)