Problem 2 Mr. Smith is currently 50 years old and is planning for his retirement

Question

Problem 2 Mr. Smith is currently 50 years old and is planning for his retirement. He has been saving $20,000 per year for 20 years, and the current value of his retirement account is $735,712. He plans to make an additional 15 payments of $20,000 each into the retirement plan, retire at age 65 (right after making his last payment), and receive an annual benefit payment (pension) for the following 20 years, i.e., from age 66 to age 85. He expects to earn a return of 6% on his investments while he is working, and then expects to earn 4% a year in retirement. He would like his benefit payments in retirement to be $200,000 per year (with no growth). (a) How much does Mr. Smith need to have in his account at age 65 (right after making his last payment) to achieve his goal? (b) At his current rate of savings, how much should He expect to have in his account at age 65 (right after making his last payment)? (c) At his current rate of savings, how much should He expect his annual benefit payment to be in retirement? Problem 2 Mr. Smith is currently 50 years old and is planning for his retirement. He has been saving $20,000 per year for 20 years, and the current value of his retirement account is $735,712. He plans to make an additional 15 payments of $20,000 each into the retirement plan, retire at age 65 (right after making his last payment), and receive an annual benefit payment (pension) for the following 20 years, i.e., from age 66 to age 85. He expects to earn a return of 6% on his investments while he is working, and then expects to earn 4% a year in retirement. He would like his benefit payments in retirement to be $200,000 per year (with no growth). (a) How much does Mr. Smith need to have in his account at age 65 (right after making his last payment) to achieve his goal? (b) At his current rate of savings, how much should He expect to have in his account at age 65 (right after making his last payment)? (c) At his current rate of savings, how much should He expect his annual benefit payment to be in retirement? Problem 2 Mr. Smith is currently 50 years old and is planning for his retirement. He has been saving $20,000 per year for 20 years, and the current value of his retirement account is $735,712. He plans to make an additional 15 payments of $20,000 each into the retirement plan, retire at age 65 (right after making his last payment), and receive an annual benefit payment (pension) for the following 20 years, i.e., from age 66 to age 85. He expects to earn a return of 6% on his investments while he is working, and then expects to earn 4% a year in retirement. He would like his benefit payments in retirement to be $200,000 per year (with no growth). (a) How much does Mr. Smith need to have in his account at age 65 (right after making his last payment) to achieve his goal? (b) At his current rate of savings, how much should He expect to have in his account at age 65 (right after making his last payment)? (c) At his current rate of savings, how much should He expect his annual benefit payment to be in retirement?

Explanation / Answer

a) FV = 0, PMT = 200,000, rate = 4%, N = 20

use PV function in Excel

amount needed = 2,718,065.27

b) PV = 735,712, N = 15, rate = 6%, PMT = 20,000

use FV function in Excel

amount expected = 2,228,696.02

c) PV = 2,228,696.02, FV = 0, N = 20, rate = 4%

use PMT function in Excel

annual benefit = 163,991.35

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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