Question

In: Accounting

After the 30 years of working Charlie Conway has saved $950,000 in a 401k account for...

After the 30 years of working Charlie Conway has saved $950,000 in a 401k account for his retirement. If Charlie decides to take annual distributions to empty the account during the next 20 years, how much more would he be able to withdraw and spend each year if his 401k is a Roth 401k account as opposed to a Traditional 401k? Assume that the 401k earns 12% annual return, and Charlie is in the 25% tax bracket?

Solutions

Expert Solution

Year Opening balance Interest W/d Closing balance
(12% X Opening balance) (trial & error method) (Op bal+int-w/d)
1                                    9,50,000.00                                              1,14,000.00                             1,27,184.84                    9,36,815.16
2                                    9,36,815.16                                              1,12,417.82                             1,27,184.84                    9,22,048.14
3                                    9,22,048.14                                              1,10,645.78                             1,27,184.84                    9,05,509.07
4                                    9,05,509.07                                              1,08,661.09                             1,27,184.84                    8,86,985.32
5                                    8,86,985.32                                              1,06,438.24                             1,27,184.84                    8,66,238.72
6                                    8,66,238.72                                              1,03,948.65                             1,27,184.84                    8,43,002.52
7                                    8,43,002.52                                              1,01,160.30                             1,27,184.84                    8,16,977.98
8                                    8,16,977.98                                                 98,037.36                             1,27,184.84                    7,87,830.50
9                                    7,87,830.50                                                 94,539.66                             1,27,184.84                    7,55,185.32
10                                    7,55,185.32                                                 90,622.24                             1,27,184.84                    7,18,622.72
11                                    7,18,622.72                                                 86,234.73                             1,27,184.84                    6,77,672.60
12                                    6,77,672.60                                                 81,320.71                             1,27,184.84                    6,31,808.47
13                                    6,31,808.47                                                 75,817.02                             1,27,184.84                    5,80,440.65
14                                    5,80,440.65                                                 69,652.88                             1,27,184.84                    5,22,908.69
15                                    5,22,908.69                                                 62,749.04                             1,27,184.84                    4,58,472.89
16                                    4,58,472.89                                                 55,016.75                             1,27,184.84                    3,86,304.80
17                                    3,86,304.80                                                 46,356.58                             1,27,184.84                    3,05,476.53
18                                    3,05,476.53                                                 36,657.18                             1,27,184.84                    2,14,948.87
19                                    2,14,948.87                                                 25,793.86                             1,27,184.84                    1,13,557.90
20                                    1,13,557.90                                                 13,626.95                             1,27,184.84                                 0.00

Constructing table as shown above and by trial and error input value of 127,184.84 in withdrawls in each of period so as to get closing balance as zero at end of 20th year.

So W/d & spend each year = 127,184.84

Please Like the solution if satisfied with the answer and if any query please mention it in comments...thanks


Related Solutions

bob Katz has saved $22,000 annually for the last 30 years in an account earning 8%....
bob Katz has saved $22,000 annually for the last 30 years in an account earning 8%. if bob estimates that he will live for 25 years during his retirement, how much would he withdraw annually at 6% interest
Suppose you want to retire after working for 40 years with $2 million saved for retirement....
Suppose you want to retire after working for 40 years with $2 million saved for retirement. Calculate how much you need to save each month if your retirement savings is in an account that grows at 3%, 6%, and 9% interest annually. (three answers, one for each rate.) Show your work.
Penny has recently retired after working as a lawyer for 30 years. However, to keep herself...
Penny has recently retired after working as a lawyer for 30 years. However, to keep herself active and also to earn some money for holidays she is planning to sell cup-cakes at the Farmers Market held in her locality every Saturday. Penny inherited a unique recipe for cakes from her grandmother and believes her cakes will hit the market. Penny is looking forward to a relatively quiet lifestyle aims to minimise paperwork or legal complexities. Advise the most appropriate business...
You are planning to retire after working for another 30 years. You believe that you can...
You are planning to retire after working for another 30 years. You believe that you can save 4% of your salary annually. Your last salary, which has just been paid, was $45,000. You anticipate that your salary will increase at the rate of 5% for the remainder of your working life. The savings will be placed in investments earning an average return of 9% per year. After retiring you expect to live on your savings for 20 years. a. If...
1. Susan has a 401k plan through her job and has accumulated $375,000 in her account....
1. Susan has a 401k plan through her job and has accumulated $375,000 in her account. Her company has invested her funds in a high interest-bearing account yielding 8% per year. She would like to retire with $600,000 in her account. When will she be able to retire? 2. Joe has $100,000 in an investment account. He is looking to retire in 12 years. He needs a minimum of $240,000 in order to retire. What rate of return does Joe...
Account Balance after 3 years
You deposit $1000 into a saving account with 9% interest per annum. Assuming no transactions on the account, determine the account balance after 3 years.
You plan on retiring in 30 years and want to have $3,000,000 saved in your retirement...
You plan on retiring in 30 years and want to have $3,000,000 saved in your retirement account. You will earn an average rate of return of 6% on your investments. How much will you need to invest each month in order to get to your goal.
Dad has $25,000 in his 401k account and contributes 5% of his salary ever year. His...
Dad has $25,000 in his 401k account and contributes 5% of his salary ever year. His employer will match up to 10% dollar for dollar. He currently has 100% of his 401k invested in the fixed rate fund earning 2%. How much money will dad have after 30 years when he is going to retire? Dad, 35, is an electrical engineer and earns $60,000 per year working for a local aerospace company. He has been getting a 3% raise every...
The balance in an investment account years t after the account is opened is given by...
The balance in an investment account years t after the account is opened is given by 7500(1.065t). Compute the average rate of change for 2.5 ≤ t ≤ 3.5. (Round your answer to two decimal places.) Δ balance/ Δt=?
Mary is 30 years old and has $ 20,000 in her investment account equally spread in...
Mary is 30 years old and has $ 20,000 in her investment account equally spread in two funds and plans to add additional $ 2000 in each fund. ( 10 % of this grade)          Fund A :       Current amount : $ 10,000       Historical performance , 10 year average : 6.5 %       $2000 added ever year          Fund B :       Current amount : $ 10,000       Historical performance , 10 year average : 5 .5 %...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT