Question

You want to be able to withdraw $45,000 from your account each year for 30 years after you retire. You expect to retire in 25 years. If your account earns 6% interest, how much will you need to deposit each year until retirement to achieve your retirement goals?

Answer 1

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.