You plan on starting a retirement fund at the end of the year. The fund earns...

60.1K

Verified Solution

Question

Finance

You plan on starting a retirement fund at the end of the year.The fund earns 11% per year. You will invest X dollars into thefund. You plan to retire at the end of 40 years from now. Once youretire, you will take your entire retirement fund and transfer itinto a safer investment that will only earn 5% interest per yearcompounded monthly. You will need $4000 per month for 30 yearsduring your retirement to sustain your lifestyle. (After whichpoint, RIP). Calculate exactly how much money you will deposit inyour retirement account at the end of this year. Your cousin who isthe same age as you and with the same life expectancy and desiredretirement age decides she will wait 10 years to start saving forretirement (so she will save for only 30 years). How much does sheneed to invest per year to achieve the same retirement nest egg asyou when she retires? Finally, your lazy best friend who is alsoyour age decides he will wait 10 years to start saving forretirement just like your cousin. However, he will only save thesame amount you save per year. He will retire at the same time asyou and reinvest just like you do into a safer investment. He willtry to live the same life style as you. How long after retirement(in months) before he is broke?

Answer & Explanation Solved by verified expert
3.9 Ratings (638 Votes)
1valueof investment at the time of retirementUsingpresent value function in MS excelpvratenperpmtfvtype rate 512 4166 nper 3012 360 pmt 4000 fv 0 type 0PV0416636040000074519434Yearlypayment to achieve the    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

You plan on starting a retirement fund at the end of the year.The fund earns 11% per year. You will invest X dollars into thefund. You plan to retire at the end of 40 years from now. Once youretire, you will take your entire retirement fund and transfer itinto a safer investment that will only earn 5% interest per yearcompounded monthly. You will need $4000 per month for 30 yearsduring your retirement to sustain your lifestyle. (After whichpoint, RIP). Calculate exactly how much money you will deposit inyour retirement account at the end of this year. Your cousin who isthe same age as you and with the same life expectancy and desiredretirement age decides she will wait 10 years to start saving forretirement (so she will save for only 30 years). How much does sheneed to invest per year to achieve the same retirement nest egg asyou when she retires? Finally, your lazy best friend who is alsoyour age decides he will wait 10 years to start saving forretirement just like your cousin. However, he will only save thesame amount you save per year. He will retire at the same time asyou and reinvest just like you do into a safer investment. He willtry to live the same life style as you. How long after retirement(in months) before he is broke?

Other questions asked by students