Question: Using Excel answer the following also showing all excel calculations in cells to do to so Table 1 is an assumptions table and table 2

. Using the numbers from table 2, create table 3 to compare the monthly withdrawals from the potential Roth IRA account balances. The initial plan is to exhaust the account after 20 years and the rate of return on the account is a constant 4.00 percent in all scenarios. However, both numbers may change, and table construction should take this into account. (6 pts.) Starting Rate of return (annual) Table 1: ROTH IRA Retirement Assumptions Amount of periodic 2.00% deposits $300.00 Rate Increment 0.50% Deposit/ withdraw frequency within a year 12.00 20.00 Withdraw length (years) 20.00 Starting investment length (years) Increment in length (years) 10.00 Rate of return during withdrawals 4.00% Rate of Return Table 2: Projected ROTH IRA Retirement Values 20 Years 30 Years 40 Years 2.00% $ 88,439.05$ 147,817.62 $ 220,330.69 2.50% $ 93,292.41 $ 160,610.26 $ 247,025.62 3.00% $ 98,490.60 $ 174,821.07 $ 277,817.85 3.50% $ 104,060.78 $ 190,623.82 $ 313,400.07 4.00% $ 110,032.39 $ 208,214.82 $ 354,588.40 4.50% $ 116,437.31 $ 227,815.84 $ 402,345.20 5.00% $ 123,310.10$ 249,677.59 $ 457,806.05 5.50% $ 130,688.22$ 274,083.57 $ 522,311.88 6.00% $ 138,612.27$ 301,354.51 $ 597,447.22 6.50% $ 147,126.28 $ 331,853.43 $ 685,085.68 7.00% $ 156,278.00 $ 365,991.30$ 787,444.02 7.50% $ 166,119.22 $ 404,233.63 $ 907,146.65 8.00% $ 176,706.12$ 447,107.83 $ 1,047,302.35
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
