Answered step by step
Verified Expert Solution
Link Copied!

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
Table 1 is an assumptions table and table 2 is the data to be used to create table 3
image text in transcribed
image text in transcribed
. 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Sustainability

Authors: Karolina Daszyńska-Żygadło, Agnieszka Bem, Bożena Ryszawska, Erika Jáki, Taťána Hajdíková

1st Edition

3030344037, 978-3030344030

More Books

Students also viewed these Finance questions