Question

Having just started a nice job after graduation, you would like to be financially responsible and start planning for your expected retirement in 40 years. What will be the value of your Roth IRA be if you fund it with $2,000 each year and earn a 7% rate of return? Please provide a sensitivity analysis to explore the range of outcomes.

Answer 1

FV of annuity	=	P * [ (1+r)^n -1 ]/ r
Periodic payment	P=	$                2,000.00
rate of interest per period	r=
Rate of interest per year		7.0000%
Payment frequency		Once in 12 months
Number of payments in a year		1.00
rate of interest per period		0.07*12/12	7.0000%
Number of periods
Number of years		40
Number of payments in a year		1
Total number of periods	n=	40
FV of annuity	=	2000* [ (1+0.07)^40 -1]/0.07
FV of annuity	=	399,270.22

IRA future value is $399,270.22

IRA future value in different situations:

	Rate of interest
Deposit	4%	4.50%	5%	5.500%	6.000%	6.500%
$          500	$     47,512.76	$     53,515.16	$     60,399.89	$     68,302.81	$     77,380.98	$     87,815.96
$      1,000	$     95,025.52	$   107,030.32	$   120,799.77	$   136,605.61	$   154,761.97	$   175,631.92
$      1,500	$   142,538.27	$   160,545.48	$   181,199.66	$   204,908.42	$   232,142.95	$   263,447.87
$      2,000	$   190,051.03	$   214,060.65	$   241,599.55	$   273,211.23	$   309,523.93	$   351,263.83
$      2,500	$   237,563.79	$   267,575.81	$   301,999.44	$   341,514.04	$   386,904.91	$   439,079.79
$      3,000	$   285,076.55	$   321,090.97	$   362,399.32	$   409,816.84	$   464,285.90	$   526,895.75
$      3,500	$   332,589.30	$   374,606.13	$   422,799.21	$   478,119.65	$   541,666.88	$   614,711.71
$      4,000	$   380,102.06	$   428,121.29	$   483,199.10	$   546,422.46	$   619,047.86	$   702,527.66
$      4,500	$   427,614.82	$   481,636.45	$   543,598.98	$   614,725.26	$   696,428.85	$   790,343.62
$      5,000	$   475,127.58	$   535,151.62	$   603,998.87	$   683,028.07	$   773,809.83	$   878,159.58
$      5,500	$   522,640.34	$   588,666.78	$   664,398.76	$   751,330.88	$   851,190.81	$   965,975.54