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 Excel answer the following also showing all excel calculations in cells to do to so
Table 1 is an assumptions table and table 2 is the data to be used to create table 3
Using Excel answer the following also showing all excel calculations in cells
to do to soTable 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!