401k withdraw calculation

  • Thread starter Thread starter eighthman11
  • Start date Start date
E

eighthman11

Hello everyone,

Looking for a calculation which will show data on 401K withdraws. For
example let say someone retires with 500,000 dollars in their 401k
fund and they are 65. They believe they will live another 15 years so
they decide to make withdraws monthly of $2,777.00 ($500,000 divided
by 15 years divided by 12 months). They estimate the money in this
fund will have a return of 10% while the withdraws are being made
thoughout the 15 year span. Need a calculation that will show the 10%
gains monthly while the fund is being reduced monthly by the
withdrawals.

Am I making any sense what so ever?

Any help appreciated
 
Go to worksheet and insert PV function. Look at help (bottom of pop up) for
this function. See example at the bottom of the help.
 
The FV formula might be more appropriate for this case since the interest
will be added to the principal instead of the payment.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top