You plan on retiring in 35 years. To support your retirement you want to be able

Question

You plan on retiring in 35 years. To support your retirement you want to be able to make 30 annual withdrawls of $100,000 each year with the first withdrawl in the day you retire. If you can earn 5.5% on your retirement account for the next 64 years:

A) How large of a deposit do you have to make today to be able to achieve your retirement goal?

B) If you decide to save for your retirement by making annual deposits instead of a lump sum today, how much should your annual deposit be, if your first deposit was made today and your last deposit is made one year before you retire?

This is suppose to be done in  excel any advice would help!!!!!!

Explanation / Answer

Future Value of all the withdrawals after 30 yrs = 100000+10000/1.055+...+100000/(1.055)^30 = $1,453,374.52 PV(0.055,30,100000)]

Present Value of deposits[ PV(0.055,35,0,$1,453,374.52)] = D

D(1+0.055)^35 = $1,453,374.52

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.