Continuing Case 65. Retirement Income Forecast Jamie Lee and Ross, now 57 and still very active, have plenty of time on their hands now that the triplets are away at college. They both realized that time has just flown by; over twenty-four years have passed since they married! Looking back over the past years, they realized that they have worked hard in their careers, Jamie Lee as the proprietor of a cupcake cafe and Ross, self-employed as a web-page designer. They have enjoyed raising their family and strived to be financially sound as they are looking to retirement that is just around the corner. They saved regularly and invested wisely over the years. They rebounded nicely from the economic crisis over the past few years, as they watched their investments closely and adjusted their strategies when they feit it necessary. They purchase vehicles with cash and do not carry crecit card balances, choosing instead to use them for convenience only. The triplets are pursuing their master's degrees and have tuition covered through work/study programs at the university. Jamie Lee and Ross are just a few short years from realizing their goals of retiring at 65 and purchasing a home at the beach! They are reviewing their financial situation to ensure they will be ready for retirement. They anticipate being able to live comfortably with 80% of their current expenses. The rate of return on their investments until they retire is 3%. They expect this percentage to drop to 2% after retirement. Use this information, along with Exhibit 1.A. Exhibit 1.B, and the information provided below to determine the annual deposit amount Jamie Lee and Ross will need to make until they retire in order to make up the shortfall between their estimated expenses and income needed during retirement. Each answer must hove a value for the assignment to be complete. Enter " 0 " for any unused categories. Current Expense Amounts (Jamie Lee and Ross Combined) Flxed expenses: $3,700 per month Variable expenses; $2,700 per month Estimated Income Amounts. (Jamie Lee and Ross Combined) Current Expense Amounts (Jamie Lee and Ross Combined) Fixed expenses: $3,700 per month Variable expenses: $2,700 per month Estimated Income Amounts (Jamie Lee and Ross Combined) Social Security: $2,800 per month Current IRA balance: $96,000 Estimated IRA withdrawal: $200 per month Other investments: $29,900 per year Other investments: $29,900 per year hibit 1-B Future Value (Compounded Sum) of $1 Paid In at the End of Each Period for a Given Number of Time Periods (an Annuity) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Period & 10 & 20 & 3x & 4v & 5N & 6s & 75 & 88 & 98 & 105 & 115 \\ \hline 1 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.060 & 1.000 & 1.000 & 1.000 \\ \hline 2 & 2.010 & 2.020 & 2.030 & 2.040 & 2.050 & 2.060 & 2.076 & 2.080 & 2.090 & 2.100 & 2.110 \\ \hline 3 & 3.030 & 3.660 & 3.091 & 3.122 & 3.153 & 3.184 & 3.215 & 3.246 & 3.278 & 3.310 & 3.342 \\ \hline 4 & 4.060 & 4.122 & 4.184 & 4.246 & 4.310 & 4.375 & 4.440 & 4.506 & 4.573 & 4.641 & 4,710 \\ \hline 5 & 5.101 & 5.204 & 5.309 & 5.416 & 5.526 & 5.637 & 5.751 & 5.867 & 5.985 & 6.105 & 6.228 \\ \hline 6 & 6.152 & 6.3e8 & 6.468 & 6.633 & 6.802 & 6.975 & 7.153 & 7.336 & 7.523 & 7.716 & 7.913 \\ \hline 7 & 7.214 & 7.434 & 7.662 & 7.898 & 8.142 & 8.394 & 8.654 & 8.923 & 9.200 & 9.487 & 9.783 \\ \hline 8 & 8.286 & 8.583 & 8.892 & 9.214 & 9.549 & 9.897 & 10.260 & 10.637 & 11.028 & 11.436 & 11.859 \\ \hline 9 & 9.369 & 9.755 & 10.159 & 10.583 & 11.027 & 11.491 & 11.978 & 12.488 & 13.021 & 13.579 & 14.164 \\ \hline 10 & 16.462 & 10.950 & 11.464 & 12.606 & 12.578 & 13.181 & 13.816 & 14.487 & 15.193 & 15.937 & 16.722 \\ \hline 11 & 11.567 & 12.169 & 12.808 & 13.486 & 14.287 & 14.972 & 15.784 & 16.645 & 17.560 & 18.531 & 19.561 \\ \hline 12 & 12.683 & 13.412 & 14.192 & 15.026 & 15.917 & 16.870 & 17.888 & 18.977 & 20.141 & 21.384 & 22.713 \\ \hline 13 & 13.809 & 14.680 & 15.618 & 16.627 & 17.713 & 18.882 & 20.141 & 21.495 & 22.953 & 24.523 & 26.212 \\ \hline 14 & 14.947 & 15.974 & 17.086 & 18.292 & 19.599 & 21.015 & 22.550 & 24.215 & 26.019 & 27.975 & 30.095 \\ \hline 15 & 16.697 & 17.293 & 18.599 & 26.024 & 21.579 & 23.276 & 25.129 & 27.152 & 29.361 & 31.772 & 34.405 \\ \hline 16 & 17.258 & 18.639 & 20.157 & 21.825 & 23.657 & 25.673 & 27.888 & 30.324 & 33.003 & 35.950 & 39.190 \\ \hline 17 & 18.430 & 20.012 & 21.762 & 23.698 & 25.840 & 28.213 & 30.840 & 33.758 & 36.974 & 40.545 & 44.501 \\ \hline 18 & 19.615 & 21.412 & 23.414 & 25.645 & 28.132 & 30.906 & 33.999 & 37.450 & 41.301 & 45.599 & 50.396 \\ \hline 19 & 20.811 & 22.841 & 25.117 & 27.671 & 30.539 & 33.760 & 37.379 & 41.446 & 46.018 & 51.159 & 56.939 \\ \hline 20 & 22.819 & 24.297 & 26.870 & 29.778 & 33.866 & 36.786 & 40.995 & 45.762 & 51.160 & 57.275 & 64.203 \\ \hline 25 & 28.243 & 32.030 & 36.459 & 41.646 & 47.727 & 54.865 & 63.249 & 73.166 & 84.701 & 98.347 & 114.413 \\ \hline 30 & 34.785 & 40.568 & 47.575 & 56.085 & 66.439 & 79.058 & 94.461 & 113.283 & 136.308 & 164.494 & 199.021 \\ \hline 40 & 48.886 & 60.402 & 75.401 & 95.026 & 120.800 & 154.762 & 199.635 & 259.057 & 337.882 & 442.593 & 581.826 \\ \hline 50 & 64.463 & 84.579 & 112.797 & 152.667 & 209.348 & 290.336 & 4e6.529 & 573.770 & 815.084 & 1,163.909 & 1,668.771 \\ \hline \end{tabular} Exhibit 1-A Future Value (Compounded Sum) of $1 after a Given Number of Time Periods