Please do a detail excel spreadsheet from Lisa age 20-32 and then when she leaves work and still is accumulating money from her IRA from 32 - 65 years old. Do the same for Her husband Bob. Please make sure it is detail for each age have a spreadsheet showing it from one column to another for both. Also the last question for a 2-3 paragraph summary with can also be explained with a graph.

There are three (3) types of textbook based homework items located at the end of each chapter. These include Discussion Questions (DQ), Exercises (E), and Problems (P). Some homework items have been custom created. Complete the following homework scenario: Bob and Lisa are both married, working adults. They both plan for retirement and consider the $2,000 annual contribution a must. First, consider Lisa's savings. She began working at age 20 and began making an annual contribution of $2,000 at the first of the year beginning with her first year. She makes 13 contributions. She worked until she was 32 and then left full time work to have children and be a stay at home mom. She left her IRA invested and plans to begin drawing from her IRA when she is 65. Bob started his IRA at age 32. The first 12 years of his working career, he used his discretionary income to buy a home, upgrade the family cars, take vacations, and pursue his golfing hobby. At age 32, he made his first $2,000 contribution to an IRA, and contributed $2,000 every year up until age 65, a total of 33 years / contributions. He plans to retire at age 65 and make withdrawals from his IRA. Both IRA accounts grow at a 7% annual rate. Do not consider any tax effects. Write a two to three (2-3) paragraph summary in which you: Create a chart summarizing the details of the investment for both Bob and Lisa. Explain the results in terms of time value of money. Deposit Rate $ 2,000.00 7% Age 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 Deposit $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 Beginning Bal $ 2,000.00 $ 4,140.00 $ 6,429.80 $ 8,879.89 $ 11,501.48 $ 14,306.58 $ 17,308.04 $ 20,519.61 $ 23,955.98 $ 27,632.90 $ 31,567.20 $ 35,776.90 $ 40,281.29 Rate $ 140.00 $ 289.80 $ 450.09 $ 621.59 $ 805.10 $ 1,001.46 $ 1,211.56 $ 1,436.37 $ 1,676.92 $ 1,934.30 $ 2,209.70 $ 2,504.38 $ 2,819.69 Ending Bal $ 2,140.00 $ 4,429.80 $ 6,879.89 $ 9,501.48 $ 12,306.58 $ 15,308.04 $ 18,519.61 $ 21,955.98 $ 25,632.90 $ 29,567.20 $ 33,776.90 $ 38,281.29 $ 43,100.98