Lets explore retirement planning analysis by calculating the data and sketching
ID: 2647145 • Letter: L
Question
Lets explore retirement planning analysis by calculating the data and sketching a graph that shows the relationship between interest rate and length of the annuity, i.e. the period that monthly withdrawals are made from the retirement account.
Lets assume that Joe has $500,000 in his retirement account on his 65th birthday. Assume that his first withdrawal is made one month after his 65th birthday.
a. Determine the maximum monthly withdrawal that can be made from the account for each combination of interest rate and annuity length listed below:
1) Interest rates of 3%, 6% and 9% per year, each compounded monthly.
2) Annuity terminating at ages 70, 75, 80 and 85.
Explanation / Answer
a. Determine the maximum monthly withdrawal that can be made from the account for each combination of interest rate and annuity length listed below
Maximum monthly withdrawal would be at higher interest rate & lesser period to withdrawl i.e 9% terminating age 70
Maximum monthly withdrawal = pmt(rate,nper,pv,fv)
rate = 9%/12
nper = 5*12 = 60
pv = 500000
fv = 0
Maximum monthly withdrawal = pmt(9%/12,60,-500000,0)
Maximum monthly withdrawal =$ 10,379.18
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.