PLease solve this for me. I will thumbs up.

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! ey realized that they have worked hard in their careers, Jamie Lee as the proprietor of a cupcake caf 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 felt it necessary. They purchase vehicles with cash and do not carry credit 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 4%. They expect this percentage to drop to 3% 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 have a value for the assignment to be complete. Enter "O" for any unused categories. Current Expense Amounts (Jamie Lee and Ross Combined) Fixed expenses: $3,200/month Variable expenses: $2,200/month Estimated Income Amounts (Jamie Lee and Ross Combined) Social Security: $2,300/month Current IRA balance: $91,000 Estimated IRA withdrawal: $300/month Other investments: $27,400/year Estimated Annual Retirement Living Expenses Estimated annual living expenses if retiring today Number of years until retirement Expected annual rate of return before retirement Future value (use Exhibit 1-A) Projected annual retirement living expenses, adjusted for inflation (Round your final answer to nearest whole number.) (A) $ Estimated Annual Income at Retirement Social Security income Company pension, personal retirement account income Investment and other income Total retirement income (Round your final answer to nearest whole number.) (B) $ Needed investment fund after retirement (A-B) (Round your final answer to nearest whole number.) Number of years until retirement Expected annual rate of return before retirement Future value for a series of deposits (use Exhibit 1-B) Annual deposit to achieve needed investment fund (C/D) (Round your final answer to two decimal places.) EXHIBIT 1-A Future value (compounded sum) of $1 after a given number of time periods 1100 1210 1110 122 100 100 100 101 100 100 100 100 102 103 112 115 1251011011225 170 216 136 1311 1217 216 100 116 120 1360 1000 118 125 1412 VI 100 100 100 101 101 1093 102 136 114 115 1125 1194 119 120 172 137 11051305 1210 1062 1 1870 2076 2305 1083 138 145 1.NO 1.07 1551 18 103 2172 15041718151 160 B 2144 28 1105 2352 2518 2720 2653 3150 290 2015 3066 342 16 3910 3152 400 SAS 4310 4785 4505 3700 117 13143616011 20122252 1294149465 2 153 2010 1319 1546 1.558 16 117313731.005 1873 2.183 2.500 2.952 17 11841.00 1653 10082 202 203 3150 18 119 120 120 2006 2007 2854 101208 1457 7542107 2.527 3026 120 146 106 21012053 2014 20 30 348 1811 2.47 3.243 432 73 7613 4 2200 326240100 101 1 2002 2.102 11.457184309 457 3316 4717 6544 5.142 7.263 5.04 6727 BOA 15 13268 17.440 22.092 3100 65.001 358 117300 164570 0063 135 0 2 Period COS OVOS 322 POVOL 13% 14% 15% 16% 17% 20% 25% 30% 1120 130 1140 0 1180 1101101100 1200 120 1300 154 277 300 3 33 16 10 141 140 1SAS 1000 405 44314821521101 102 103 15 28 1953 2197 154 1430 1400 140 1011 14 195 2006 2074 2858 842925 1925 2011 2011 2100 2192 228 2586 2488 2.313 2450 zsas 2700 29 2211 2355 2.5022 00 2008 3001 18 583 2476 2658 2853 305932783511 350 021 300 273 3004 3518 5160 2 1106 3.395 3702 404 401 402 54 56 17 6 3836 4226 4652117 1177174 114 4818 5350 5956507258801916 1021536700000 55356361 7016 7.958 9002 010 11.40 23.30 314 8137 518 61507067132358 10 1250 149 141728 9.16 10261 6 2210 7600904 105 12 35 6 10 22001 36633 55511 112460 813 1019212056 142 214 2 1 00 1153313743 1617 21 230 10000 17000 21231241232919 048 2 7 0306600050 0116 12 111.6 1 0 30 000 3051 1250 1 2 0 37870 S59 160 1 7500 119000 000000000000 0 0 10000 77000 OF POS 2 EXHIBIT 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) Period 1 10 2 % 3% 4% 5% 6% 7% 8% 9% 10% 11% 1000 1000 1.000 1.000 1.000 1000 1.000 1.000 1.000 1000 1000 2010 2030 2030 2040 200 200 2010 2000 2000 2100 2110 30303060 3.091 3122 3.153 184 5215 5.246 3.278 3.310 3542 4122 TRE 2 310 375 5101 5.204 5.30 5.416 5.525 5.657 5 .751 5.367 5.985 6 105 6 220 66 675 753 7536 752377167015 721474547562 789881628394 8 656 923 9200 9.487 9783 RS R53 BRO 0214 059 07 10 260 10637 11078 114 11 AS 19 .755 10.159 1058 11.027 11.091 11.978 1248 13.021 13.579 14164 10.462 10.950 11.464 12.006 12.578 13.181 13816 14.457 15.193 15937 10 722 117 12160 12 BOB 13.66 14207 14.972 15 784 16.54517560 1853119561 12.685 13.412 15.026 15.917 16.70 17183 18.977 20.141 21.504 22.713 S RO 16015618 16.627 17.713 18.082 2011 21.405 22.053 24523 26212 144 15.974 17.086 18.292 1 9.599 21.015 22.550 24215 26.019 27.975 30095 1600717203 1 500 20024 21.579 23 276 25120 27.152 20 361 31.772 3 4405 1735818.639 20.157 21.825 25.657 25.673 27.888 30.524 55.00 55.950 39.190 18.430 20012217623 .608 25 30 282130 0 33750 36074 40 545 44501 19615 21412 25.414 25.645 28.132 30.906 33.999 37.450 41.301 45.599 50396 20 811 22841 25.117 27.671 30539 33.760 37 379 41.446 45 018 51.150 56030 22019 20207 26870 29.778 33.066 36.786 40.905 45.762 51.160 57.275 6 4.203 28.243 32.030 3 6.459 41.646 47.727 54.565 632497 106 4.701 98.347 114410 4 785405A 7575560S 66.41 7905A 04461 11120 116 310 164490199020 48.856 60.402 75.401 05.026 120 300 154.760 199660 259060 357.890 442.590 501 850 64.463 4.570 12800 152.670 200 350290.340 606 530 573770815.080 1.163.000 1.668200 13 14 30 40 50 Period 11 12% 13% 14% 15% 16% 17% 18% 19% 20% 25% 30% 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 2.120 2130 2140 2.150 2 .180 2170 2100 2199 2200 2250 2.500 3.374 5.407 4.40 5.475 3.506 353 3 572 3608 560 5813 5 .000 47794.850 4921 4993 5.066 5.141 52155291 538 5.766 187 6353480661067426877701471547 297 7442 8.207 9043 6.115 325 3536 754 8.977 9207 9.442 9 683 9 .950 11.259 12.756 100 10.405 10.73011067 11414 117721214212533 12016 15.073 17585 12.300 12.757 132531 727 14240 14773 15.527 15.902 16.499 19.842 2 3.858 14776 15.416 16.085 16.756 17519 18.265 1906 19.925 20 25 302 5 2015 17.549 18.42019 55720.3042132122303 2352124701 25950 53.253 42619 2 0655 21.014 23.045 24349 25.735 27 200 28.755 3 0.404 32.150 42.560 56.405 24133 25650 27271 9002 30 30 32 34 4931 57.180 95815420874527 28.029 29.5 52089 54352 432 56.786 36.736 3904 59.404 42219 2 19 45.244 48.97 0.760 303 37581105055672 27.10350818 54,841 600 127910 37.280 10.41743842 47580 51.660 56110 0 965 6261 72056 109 690 167290 4275346672 50 980 5571780925 666 7230 SO 1511021540 48884 33.750 0.11865.075 71.67578.97987068 06.022 09301750 205010 55.750 61725 39475.836 84.141 95.4006103740115270 1201202180SO7 520 65.440 707 7 80 8212 98.603 110.290 123.410 138 170 170 273 1970 72052 0947 91.025 102.400 115.580 150.050 146.650 165.420 186.00 52.950 650.170 155150 155.630 181670 212790 209.210392110 00 02 040 71.00 105.000 250.000 241.350 295.200 556.790 434.750 530.310 647.440 790.950966.700 1.181.900 3.227.200 750.000 7 670000137001562000 19.100 250 300 145004165210 5520800 7343 000 000 000 120 30 000 2.400.000 3.450.500 49945007217.700 10.456.000 15.090.000 21.815.000 51.515.000 5.497.000 10.256.000 165.976.000 0 50 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! ey realized that they have worked hard in their careers, Jamie Lee as the proprietor of a cupcake caf 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 felt it necessary. They purchase vehicles with cash and do not carry credit 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 4%. They expect this percentage to drop to 3% 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 have a value for the assignment to be complete. Enter "O" for any unused categories. Current Expense Amounts (Jamie Lee and Ross Combined) Fixed expenses: $3,200/month Variable expenses: $2,200/month Estimated Income Amounts (Jamie Lee and Ross Combined) Social Security: $2,300/month Current IRA balance: $91,000 Estimated IRA withdrawal: $300/month Other investments: $27,400/year Estimated Annual Retirement Living Expenses Estimated annual living expenses if retiring today Number of years until retirement Expected annual rate of return before retirement Future value (use Exhibit 1-A) Projected annual retirement living expenses, adjusted for inflation (Round your final answer to nearest whole number.) (A) $ Estimated Annual Income at Retirement Social Security income Company pension, personal retirement account income Investment and other income Total retirement income (Round your final answer to nearest whole number.) (B) $ Needed investment fund after retirement (A-B) (Round your final answer to nearest whole number.) Number of years until retirement Expected annual rate of return before retirement Future value for a series of deposits (use Exhibit 1-B) Annual deposit to achieve needed investment fund (C/D) (Round your final answer to two decimal places.) EXHIBIT 1-A Future value (compounded sum) of $1 after a given number of time periods 1100 1210 1110 122 100 100 100 101 100 100 100 100 102 103 112 115 1251011011225 170 216 136 1311 1217 216 100 116 120 1360 1000 118 125 1412 VI 100 100 100 101 101 1093 102 136 114 115 1125 1194 119 120 172 137 11051305 1210 1062 1 1870 2076 2305 1083 138 145 1.NO 1.07 1551 18 103 2172 15041718151 160 B 2144 28 1105 2352 2518 2720 2653 3150 290 2015 3066 342 16 3910 3152 400 SAS 4310 4785 4505 3700 117 13143616011 20122252 1294149465 2 153 2010 1319 1546 1.558 16 117313731.005 1873 2.183 2.500 2.952 17 11841.00 1653 10082 202 203 3150 18 119 120 120 2006 2007 2854 101208 1457 7542107 2.527 3026 120 146 106 21012053 2014 20 30 348 1811 2.47 3.243 432 73 7613 4 2200 326240100 101 1 2002 2.102 11.457184309 457 3316 4717 6544 5.142 7.263 5.04 6727 BOA 15 13268 17.440 22.092 3100 65.001 358 117300 164570 0063 135 0 2 Period COS OVOS 322 POVOL 13% 14% 15% 16% 17% 20% 25% 30% 1120 130 1140 0 1180 1101101100 1200 120 1300 154 277 300 3 33 16 10 141 140 1SAS 1000 405 44314821521101 102 103 15 28 1953 2197 154 1430 1400 140 1011 14 195 2006 2074 2858 842925 1925 2011 2011 2100 2192 228 2586 2488 2.313 2450 zsas 2700 29 2211 2355 2.5022 00 2008 3001 18 583 2476 2658 2853 305932783511 350 021 300 273 3004 3518 5160 2 1106 3.395 3702 404 401 402 54 56 17 6 3836 4226 4652117 1177174 114 4818 5350 5956507258801916 1021536700000 55356361 7016 7.958 9002 010 11.40 23.30 314 8137 518 61507067132358 10 1250 149 141728 9.16 10261 6 2210 7600904 105 12 35 6 10 22001 36633 55511 112460 813 1019212056 142 214 2 1 00 1153313743 1617 21 230 10000 17000 21231241232919 048 2 7 0306600050 0116 12 111.6 1 0 30 000 3051 1250 1 2 0 37870 S59 160 1 7500 119000 000000000000 0 0 10000 77000 OF POS 2 EXHIBIT 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) Period 1 10 2 % 3% 4% 5% 6% 7% 8% 9% 10% 11% 1000 1000 1.000 1.000 1.000 1000 1.000 1.000 1.000 1000 1000 2010 2030 2030 2040 200 200 2010 2000 2000 2100 2110 30303060 3.091 3122 3.153 184 5215 5.246 3.278 3.310 3542 4122 TRE 2 310 375 5101 5.204 5.30 5.416 5.525 5.657 5 .751 5.367 5.985 6 105 6 220 66 675 753 7536 752377167015 721474547562 789881628394 8 656 923 9200 9.487 9783 RS R53 BRO 0214 059 07 10 260 10637 11078 114 11 AS 19 .755 10.159 1058 11.027 11.091 11.978 1248 13.021 13.579 14164 10.462 10.950 11.464 12.006 12.578 13.181 13816 14.457 15.193 15937 10 722 117 12160 12 BOB 13.66 14207 14.972 15 784 16.54517560 1853119561 12.685 13.412 15.026 15.917 16.70 17183 18.977 20.141 21.504 22.713 S RO 16015618 16.627 17.713 18.082 2011 21.405 22.053 24523 26212 144 15.974 17.086 18.292 1 9.599 21.015 22.550 24215 26.019 27.975 30095 1600717203 1 500 20024 21.579 23 276 25120 27.152 20 361 31.772 3 4405 1735818.639 20.157 21.825 25.657 25.673 27.888 30.524 55.00 55.950 39.190 18.430 20012217623 .608 25 30 282130 0 33750 36074 40 545 44501 19615 21412 25.414 25.645 28.132 30.906 33.999 37.450 41.301 45.599 50396 20 811 22841 25.117 27.671 30539 33.760 37 379 41.446 45 018 51.150 56030 22019 20207 26870 29.778 33.066 36.786 40.905 45.762 51.160 57.275 6 4.203 28.243 32.030 3 6.459 41.646 47.727 54.565 632497 106 4.701 98.347 114410 4 785405A 7575560S 66.41 7905A 04461 11120 116 310 164490199020 48.856 60.402 75.401 05.026 120 300 154.760 199660 259060 357.890 442.590 501 850 64.463 4.570 12800 152.670 200 350290.340 606 530 573770815.080 1.163.000 1.668200 13 14 30 40 50 Period 11 12% 13% 14% 15% 16% 17% 18% 19% 20% 25% 30% 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 2.120 2130 2140 2.150 2 .180 2170 2100 2199 2200 2250 2.500 3.374 5.407 4.40 5.475 3.506 353 3 572 3608 560 5813 5 .000 47794.850 4921 4993 5.066 5.141 52155291 538 5.766 187 6353480661067426877701471547 297 7442 8.207 9043 6.115 325 3536 754 8.977 9207 9.442 9 683 9 .950 11.259 12.756 100 10.405 10.73011067 11414 117721214212533 12016 15.073 17585 12.300 12.757 132531 727 14240 14773 15.527 15.902 16.499 19.842 2 3.858 14776 15.416 16.085 16.756 17519 18.265 1906 19.925 20 25 302 5 2015 17.549 18.42019 55720.3042132122303 2352124701 25950 53.253 42619 2 0655 21.014 23.045 24349 25.735 27 200 28.755 3 0.404 32.150 42.560 56.405 24133 25650 27271 9002 30 30 32 34 4931 57.180 95815420874527 28.029 29.5 52089 54352 432 56.786 36.736 3904 59.404 42219 2 19 45.244 48.97 0.760 303 37581105055672 27.10350818 54,841 600 127910 37.280 10.41743842 47580 51.660 56110 0 965 6261 72056 109 690 167290 4275346672 50 980 5571780925 666 7230 SO 1511021540 48884 33.750 0.11865.075 71.67578.97987068 06.022 09301750 205010 55.750 61725 39475.836 84.141 95.4006103740115270 1201202180SO7 520 65.440 707 7 80 8212 98.603 110.290 123.410 138 170 170 273 1970 72052 0947 91.025 102.400 115.580 150.050 146.650 165.420 186.00 52.950 650.170 155150 155.630 181670 212790 209.210392110 00 02 040 71.00 105.000 250.000 241.350 295.200 556.790 434.750 530.310 647.440 790.950966.700 1.181.900 3.227.200 750.000 7 670000137001562000 19.100 250 300 145004165210 5520800 7343 000 000 000 120 30 000 2.400.000 3.450.500 49945007217.700 10.456.000 15.090.000 21.815.000 51.515.000 5.497.000 10.256.000 165.976.000 0 50