Answer:
X = $25,717.13 is the contribution amount that Derek has to plan.
Explanation:
Solution:
Assumption = Interest rate = 4%
Amount required at the age of 70 = value of all withdrawals
So, he will be making withdrawals until 94 years of age.
94 - 70 = 24
Annual Withdrawals = $195,078.00
Interest Rate = 4%
Period = 24 years.
Putting these values into the PVAF function, you will get:
PVAF(4%,24 years) = 15.24
So,
Amount required at the age of 70 = $195,078 x 15.24
Amount required at the age of 70 = 2972988.72
And now, we need to find the amount needed at the age of 65.
Amount required at the age of 65 = Present Value at the age of 65
Amount required at the age of 65 = 2972988.72 x PVF (4%,5 years)
PVF (4%,5 years) = 0.822
Amount required at the age of 65 = 2972988.72 x 0.822
Amount required at the age of 65 = $2443796.72
Let suppose, annual contribution = x
X*[{(1+0.04)40-1]}/0.04] = $2443796.72
95.026X = $2443796.72
X = $25,717.13 is the contribution amount that Derek has to plan.