Using Excel answer the following:

A.) Create assumptions table 1 that will be used to link with tables 2 and 3, thus providing analysis flexibility.

B.) Assuming a range of return rates of 2.00 to 8.00 percent (varying by 0.50 percent increments) and three different lengths of contribution (20, 30 and 40 years), create table 2 to illustrate the final account balances of a Roth IRA. Assume a monthly contribution of $300.00 in all scenarios. Create the table to allow flexibility in changing these values.

C.) 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.