Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 72.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 72.0 when he fully retires, he will begin to make annual withdrawals of $192,814.00 from his retirement account until he turns 92.00. He he will make contributions to his retirement account from his 26th birthday to his 65th birthday. To reach his goal, what must the contributions be? Assume a 4.00% interest rate.

3 answers

To determine the amount Derek must contribute annually from his 26th birthday to his 65th birthday in order to fund his withdrawals after retirement, we can break down the problem into several steps:

  1. Calculate the present value of the withdrawals that he will make from age 73 to 92.
  2. Calculate the future value needed at retirement age (age 65) to fund those withdrawals.
  3. Calculate the annual contributions needed from age 26 to age 65 to reach this future value.

Step 1: Present Value of Withdrawals

Derek will withdraw $192,814 each year from age 73 to 92 (which is 20 withdrawals). The present value \(PV\) of an annuity can be calculated using the formula:

\[ PV = PMT \times \frac{1 - (1 + r)^{-n}}{r} \]

where:

  • \(PMT = 192,814\) (annual withdrawal),
  • \(r = 0.04\) (interest rate),
  • \(n = 20\) (number of withdrawals).

Substituting the values into the formula:

\[ PV = 192,814 \times \frac{1 - (1 + 0.04)^{-20}}{0.04} \]

Calculating the annuity factor:

\[ PV = 192,814 \times \frac{1 - (1.04)^{-20}}{0.04} \]

Calculating \((1.04)^{-20}\):

\[ (1.04)^{-20} \approx 0.2083 \]

Now calculate the full expression:

\[ PV = 192,814 \times \frac{1 - 0.2083}{0.04} \approx 192,814 \times \frac{0.7917}{0.04} \] \[ PV \approx 192,814 \times 19.7925 \approx 3,818,330.39 \]

Step 2: Future Value Needed at Retirement

Now, we need to find out how much Derek needs to have in his retirement account at age 65 to cover the present value we just calculated at the time of the withdrawals (which will actually occur at age 73). To find this future value, we need to account for the time value of money from age 65 to age 73 (8 years). The future value \(FV\) can be calculated with:

\[ FV = PV \times (1 + r)^n \]

where:

  • \(PV \approx 3,818,330.39\),
  • \(r = 0.04\),
  • \(n = 8\).

Substituting in these values:

\[ FV = 3,818,330.39 \times (1 + 0.04)^{8} \]

Calculating \((1.04)^8\):

\[ (1.04)^{8} \approx 1.3685696 \]

Now substituting this value back in:

\[ FV \approx 3,818,330.39 \times 1.3685696 \approx 5,224,516.49 \]

Step 3: Annual Contributions to Age 65

Next, we need to calculate how much Derek must contribute annually to reach the future value of approximately $5,224,516.49 at age 65, starting from his 26th birthday and making contributions for 39 years (from age 26 to 65).

Using the future value of an annuity formula:

\[ FV = PMT \times \frac{(1 + r)^n - 1}{r} \]

Rearranging to solve for \(PMT\):

\[ PMT = \frac{FV \times r}{(1 + r)^n - 1} \]

Substituting in the values we have:

\[ FV = 5,224,516.49, \] \[ r = 0.04, \] \[ n = 39. \]

Calculating \((1.04)^{39}\):

\[ (1.04)^{39} \approx 5.297517 \]

Now plugging this value into our equation:

\[ PMT = \frac{5,224,516.49 \times 0.04}{(1.04)^{39} - 1} \] \[ PMT = \frac{209,020.6596}{5.297517 - 1} \] \[ PMT = \frac{209,020.6596}{4.297517} \approx 48,687.87 \]

Conclusion:

Derek must contribute approximately $48,687.87 annually from his 26th birthday until his 65th birthday to ensure he can withdraw $192,814 every year from ages 73 to 92, assuming a 4% interest rate.

what value do i enter for N, i/y, PV, PMT, and FV on a finance calculator?

To enter the values into a finance calculator, you'll need to identify what each variable represents in your scenario. Here's how to set it up for the calculations we just did:

When Calculating the Present Value of Withdrawals:

  1. Calculate Present Value (PV) of annual withdrawals:

    • N (Number of periods): 20 (for the 20 withdrawals from age 73 to 92)
    • I/Y (Interest per year): 4 (the annual interest rate)
    • PV (Present Value): \( ? \) (this is what you're calculating; you'll typically store this value after calculation)
    • PMT (Payment amount): 192,814 (the annual withdrawal amount)
    • FV (Future Value): 0 (since we are calculating present value and will not have a future value)
  2. Calculate Future Value needed at age 65 (to fund withdrawals):

    • After calculating the Present Value (let's call this calculated value \(PV_{withdrawals}\), which came to approximately $3,818,330.39):
    • N: 8 (the number of years from age 65 to 73)
    • I/Y: 4 (the annual interest rate)
    • PV: 3,818,330.39 (the present value calculated from the previous step)
    • PMT: 0 (no additional contributions needed during these years)
    • FV: \( ? \) (this is what you're calculating for retirement age, and it should output approximately $5,224,516.49)

When Calculating Annual Contributions:

  1. Calculate the annual contributions from age 26 to 65:
    • N: 39 (the number of years he will make contributions)
    • I/Y: 4 (the annual interest rate)
    • PV: 0 (since you are starting from nothing in the retirement account)
    • PMT: \( ? \) (this is what you're calculating; it will represent the annual contribution amount)
    • FV: 5,224,516.49 (the future value calculated needed at retirement age)

Summary of Inputs for Finance Calculator:

For Present Value of Withdrawals:

  • N: 20
  • I/Y: 4
  • PV: (calculate this; it will be the PV of withdrawals)
  • PMT: -192,814 (input as negative, since it's a cash outflow)
  • FV: 0

For Future Value Needed at Retirement:

  • N: 8
  • I/Y: 4
  • PV: 3,818,330.39 (the value from the previous calculation)
  • PMT: 0
  • FV: (calculate this; it will represent the future value needed)

For Annual Contributions:

  • N: 39
  • I/Y: 4
  • PV: 0
  • PMT: (calculate this; it will represent the contribution amount)
  • FV: 5,224,516.49

Make sure to adjust positive/negative signs based on your finance calculator's convention for cash inflows and outflows. Good luck!