You plan to retire 24 years from now, and you expect that you will live 35 years
ID: 2727706 • Letter: Y
Question
You plan to retire 24 years from now, and you expect that you will live 35 years after retiring. You want to have enough money upon reaching retirement age to withdraw $175,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death. You plan to accumulate the retirement fund by making equal bi-weekly deposits at the end of each two week period for the next 24 years. You expect that you will be able to earn a quoted rate of 10%, compounded semi-annually on your deposits. However, you only expect to earn an EAR of 5% on your investment after you retire since you will choose to place the money in less risky investments. What equal bi-weekly deposits must you make to reach your retirement goal?
Explanation / Answer
first use pv formulae to find the present value of the retirement amount which you are going to withdraw
=PV(5%,35,175000,1000000,0)=$3,046,774
assuming 52 weeks in a year
biweekly deposits n=26*52 rate=10%/26
=PMT(10%/26,26*24,3046774,,0)
=$1175.06
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.