Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
401k withdraw calculation
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
401k withdraw calculation
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. "eighthman11" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
401k withdraw calculation
The FV formula might be more appropriate for this case since the interest
will be added to the principal instead of the payment. "Joel" wrote: 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. "eighthman11" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up a cash in hand statement in excel, money withdraw. | Excel Discussion (Misc queries) | |||
401k Match | Excel Worksheet Functions | |||
Calculating a tiered 401k Match | Excel Worksheet Functions | |||
401k formula | Excel Worksheet Functions | |||
Help! 401k match formula | New Users to Excel |