Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
. 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 Table 1 is an assumptions table and table 2 is the data to be used to create table 3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started