Answer:
Expected withdrawal is $45,000 for 30 years = total of $1,350,000
You will be required to invest in $25.063 every year.
Explanation:
By applying the goal seek formula in excel to determine the annual invested fund, based on a compounded interest rate of 6% over a duration of up to a maximum of 25 years from Year 0, we can clearly see that Savings ought to be $25,063 for every year.
The future Value of each saved fund is derived and added to future value of each years subsequent saved fund to arrive at a total expectation of $1,350,000 expected value after 25 years (i.e. $45,000 annual withdrawal x 30 years of withdrawal)
This brings total savings to $626,572 for the entire 25 years
Kindly refer to the attachment for breakdown of workings.
