Question

You are saving for retirement. To live comfortably, you decide you will need to save $1 million by the time you are 65. Today is your 33rd birthday, and you decide, starting today and continuing on every birthday up to and including your 65th birthday, that you will put the same amount into a savings account. If the interest rate is 3%, how much must you set aside each year to make sure that you will have $1 million in the account on your 65th birthday?

Answer 1

Number of payments
	33	(65-32)
Interest rate	3.00%
Future value	$1,000,000.00
Payment amount
	(18,156.12)	(1000000*3%*33)
Explanation:

Your age	Payment	Cumulative value of account (end of year)
33	(18,156.12)	*(18,700.81)
34	(18,156.12)	(37,962.64)
35	(18,156.12)	(57,802.32)
36	(18,156.12)	(78,237.20)
37	(18,156.12)	(99,285.12)
38	(18,156.12)	(120,964.48)
39	(18,156.12)	(143,294.22)
40	(18,156.12)	(166,293.85)
41	(18,156.12)	(189,983.47)
42	(18,156.12)	(214,383.78)
43	(18,156.12)	(239,516.10)
44	(18,156.12)	(265,402.39)
45	(18,156.12)	(292,065.26)
46	(18,156.12)	(319,528.03)
47	(18,156.12)	(347,814.67)
48	(18,156.12)	(376,949.92)
49	(18,156.12)	(406,959.22)
50	(18,156.12)	(437,868.80)
51	(18,156.12)	(469,705.67)
52	(18,156.12)	(502,497.65)
53	(18,156.12)	(536,273.38)
54	(18,156.12)	(571,062.39)
55	(18,156.12)	(606,895.07)
56	(18,156.12)	(643,802.73)
57	(18,156.12)	(681,817.61)
58	(18,156.12)	(720,972.95)
59	(18,156.12)	(761,302.94)
60	(18,156.12)	(802,842.83)
61	(18,156.12)	(845,628.92)
62	(18,156.12)	(889,698.60)
63	(18,156.12)	(935,090.36)
64	(18,156.12)	(981,843.88)
65	(18,156.12)	**(1,000,000.00)

*(18156.12)*3%-18156 =18700.81 **(981,843.88)+

(18,156.12) = 1000000