Question

Suppose you are exactly 25 years old and you are planning to save for your retirement which will happen in 40 years. You plan to deposit equal amount at the beginning of each month in your retirement account with the first saving made today. Assume the retirement account pays you 6% p.a. compounded monthly.

(a) If you would like to have $1,000,000 in your retirement account 40 years later when you are retired, how much will you have to deposit monthly?

(b) If you could only afford to deposit $400 per month, but you still want to retire with $1,000,000 in 40 years, what is the effective annual rate of return that you need to earn on your retirement account?

(c) If you are expected to live for 30 years in retirement and you need to withdraw $4000 per month (with the first withdrawal one month after retiring) for living expense. Assume your saving will continue to earn you 6% p.a. compounded monthly. Calculate how much remaining account balance will you be able to leave to your children 30 years later?

Answer 1

B D E 1 2 3 4 time to get retire (in mopnths) Target Amount interest rate monnthly $ 480 1,000,000 0.50% 5 6 7 amount to be required to deposite $499.64 8 9 b) $ 400 monthly possible savings Effective annual rate 10 7.02% 11 12 360 13 expected life after retirement (in months) monthly amount required Balance for chillden $ 4,000 $2,004,515.04 14

formulas used :-

a)

amount to be required to deposite

=PMT(E5,E3,0,-E4,1)

b)	monthly possible savings	400
	Effective annual rate	=(1+RATE(E3,-E9,0,E4,1))^12-1

c)	expected life after retirement (in months)	360
	monthly amount required	4000
	Balance for chillden	=FV(E5,E12,E13,-E4)

i hope my efforts will be fruitful to you.