You are trying to decide how much money you will need at retirement. You expect

Question

You are trying to decide how much money you will need at retirement. You expect to retire at age 65. You hope to travel extensively while you are healthy enough. To finance your travels (and cover your basic living expenses) you think you will need income of $152,000 per year (at the end of each year). You will make your first withdrawal on your 66th birthday. You expect to stay healthy enough for travel for the first 16 years after retirement and thus make a withdrawal of $152,000 at the end of each of those16 years. Once your active travel years are over you will settle down into a retirement home. During your retirement home years you will only need $128,000 in income per year. You expect to live in the retirement home for 9 years. You will make the first retirement home withdrawal 17 years after retirement and all subsequent withdrawals will continue to be at year-end. If retirement savings will earn a return of 7%, then how much will you need at retirement to fund these planned withdrawals?

Question-How much will you need at retirement to fund these planned withdrawals?

Explanation / Answer

Hello Sir/ Mam

YOUR REQUIRED ANSWER IS $1,718,378.21

Using Goal Seek Function of excel:

I hope this solves your doubt.

Feel free to comment if you still have any query.

Do give a thumbs up if you find this helpful.

Time Balance Withdrawls Balance 65 $1,718,378.21 $0.00 $1,838,664.69 66 $1,838,664.69 -$152,000.00 $1,804,731.22 67 $1,804,731.22 -$152,000.00 $1,768,422.40 68 $1,768,422.40 -$152,000.00 $1,729,571.97 69 $1,729,571.97 -$152,000.00 $1,688,002.01 70 $1,688,002.01 -$152,000.00 $1,643,522.15 71 $1,643,522.15 -$152,000.00 $1,595,928.70 72 $1,595,928.70 -$152,000.00 $1,545,003.71 73 $1,545,003.71 -$152,000.00 $1,490,513.97 74 $1,490,513.97 -$152,000.00 $1,432,209.94 75 $1,432,209.94 -$152,000.00 $1,369,824.64 76 $1,369,824.64 -$152,000.00 $1,303,072.37 77 $1,303,072.37 -$152,000.00 $1,231,647.43 78 $1,231,647.43 -$152,000.00 $1,155,222.75 79 $1,155,222.75 -$152,000.00 $1,073,448.34 80 $1,073,448.34 -$152,000.00 $985,949.73 81 $985,949.73 -$152,000.00 $892,326.21 82 $892,326.21 -$128,000.00 $817,829.04 83 $817,829.04 -$128,000.00 $738,117.08 84 $738,117.08 -$128,000.00 $652,825.27 85 $652,825.27 -$128,000.00 $561,563.04 86 $561,563.04 -$128,000.00 $463,912.45 87 $463,912.45 -$128,000.00 $359,426.33 88 $359,426.33 -$128,000.00 $247,626.17 89 $247,626.17 -$128,000.00 $128,000.00 90 $128,000.00 -$128,000.00 $0.00

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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