VBA Problem Your annual Salary is forecast, after taxes, until expected retirement in cells $B$33:$B$70. You anticipate retiring 38 years from now. Until retirement, you plan to save 16.00% of your salary each year and invest it. Your first annual salary payment is 1 year from today. After retirement you will never work again. What will be your monthly gross income, in retirement, be if you plan for a 30 year horizon (from retirement until you have a zero balance) and receive your first retirment check 1 month after retiring? (If you live longer than that, you'd better have been nice to your kids). Your first salary cash flow occurs 1 year from now and you can wihdraw monthly amounts starting 1 month after retirement. (HINT: Do the Savings Annually, and the spending Monthly.) REMEMBER, Your solution should work if I change the purple cells! Years until retirement Years after retirement Percent of income you can save Effective Annual Rate 38 30 16.00% 2.09% 1,060,256 a. You are given the value of your retirement savings (at retirement) = Write a VBA function to compute the future value of the savings. The problem has been solved below on the spreadsheet for reference. The function may only refer to cells $D$17:$D$20 and $B$33:$B$70. Your Function Answer = FV @ Retirement 1,060,256 Two different Methods 483,113 1,060,256 0 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 80,700 83,754 84,403 87,028 88,758 92,260 94,771 97,800 100,533 102,011 102,443 104,996 108,251 109,421 112,469 114,739 117,566 121,014 122,501 123,363 124,659 127,767 130,137 130,414 133,708 137,540 138,377 140,711 142,203 142,216 142,284 143,697 147,490 148,930 151,483 154,257 158,236 158,364 27,756.97 28,217.65 27,854.16 28,132.47 28,104.33 28,615.15 28,792.19 29,104.15 29,304.99 29,127.06 28,651.59 28,764.45 29,049.05 28,761.90 28,957.86 28,937.53 29,043.50 29,283.28 29,036.25 28,641.95 28,350.33 28,462.30 28,396.76 27,874.63 27,993.62 28,206.39 27,797.08 27,687.27 27,408.01 26,849.37 26,312.28 26,029.56 26,169.69 25,884.21 25,788.94 25,723.57 25,846.90 25,338.24 27,757 55,975 83,829 111,961 140,066 168,681 197,473 226,577 255,882 285,009 313,661 342,425 371,474 400,236 429,194 458, 132 487,175 516,458 545,495 574,136 602,487 630,949 659,346 687,221 715,214 743,421 771,218 798,905 826,313 853,162 879,475 905,504 931,674 957,558 983,347 1,009,070 1,034,917 1,060,256 12,912 26,583 40,643 55,416 70,776 87,017 103,999 121,820 140,452 159,709 179,438 199,987 221,487 243,624 266,710 290,643 315,528 341,485 368,222 395,656 423,870 453, 172 483,465 514,436 546,581 580,011 614,273 649,625 685,955 723,046 760,923 799,818 840,133 881,520 924, 181 968,178 1,013,730 1,060,256 VBA Problem Your annual Salary is forecast, after taxes, until expected retirement in cells $B$33:$B$70. You anticipate retiring 38 years from now. Until retirement, you plan to save 16.00% of your salary each year and invest it. Your first annual salary payment is 1 year from today. After retirement you will never work again. What will be your monthly gross income, in retirement, be if you plan for a 30 year horizon (from retirement until you have a zero balance) and receive your first retirment check 1 month after retiring? (If you live longer than that, you'd better have been nice to your kids). Your first salary cash flow occurs 1 year from now and you can wihdraw monthly amounts starting 1 month after retirement. (HINT: Do the Savings Annually, and the spending Monthly.) REMEMBER, Your solution should work if I change the purple cells! Years until retirement Years after retirement Percent of income you can save Effective Annual Rate 38 30 16.00% 2.09% 1,060,256 a. You are given the value of your retirement savings (at retirement) = Write a VBA function to compute the future value of the savings. The problem has been solved below on the spreadsheet for reference. The function may only refer to cells $D$17:$D$20 and $B$33:$B$70. Your Function Answer = FV @ Retirement 1,060,256 Two different Methods 483,113 1,060,256 0 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 80,700 83,754 84,403 87,028 88,758 92,260 94,771 97,800 100,533 102,011 102,443 104,996 108,251 109,421 112,469 114,739 117,566 121,014 122,501 123,363 124,659 127,767 130,137 130,414 133,708 137,540 138,377 140,711 142,203 142,216 142,284 143,697 147,490 148,930 151,483 154,257 158,236 158,364 27,756.97 28,217.65 27,854.16 28,132.47 28,104.33 28,615.15 28,792.19 29,104.15 29,304.99 29,127.06 28,651.59 28,764.45 29,049.05 28,761.90 28,957.86 28,937.53 29,043.50 29,283.28 29,036.25 28,641.95 28,350.33 28,462.30 28,396.76 27,874.63 27,993.62 28,206.39 27,797.08 27,687.27 27,408.01 26,849.37 26,312.28 26,029.56 26,169.69 25,884.21 25,788.94 25,723.57 25,846.90 25,338.24 27,757 55,975 83,829 111,961 140,066 168,681 197,473 226,577 255,882 285,009 313,661 342,425 371,474 400,236 429,194 458, 132 487,175 516,458 545,495 574,136 602,487 630,949 659,346 687,221 715,214 743,421 771,218 798,905 826,313 853,162 879,475 905,504 931,674 957,558 983,347 1,009,070 1,034,917 1,060,256 12,912 26,583 40,643 55,416 70,776 87,017 103,999 121,820 140,452 159,709 179,438 199,987 221,487 243,624 266,710 290,643 315,528 341,485 368,222 395,656 423,870 453, 172 483,465 514,436 546,581 580,011 614,273 649,625 685,955 723,046 760,923 799,818 840,133 881,520 924, 181 968,178 1,013,730 1,060,256