Excel Finance Help

After retiring, Stacy expects to live for another 30 years. During those 30 years, she needs $4,000 (at the BEGINNING of every month) for living expenses. How much money does Stacy need to have in her retirement account to make this happen on the day of her retirement? Assume that she can earn 8% on her investments.

I need answer for B28,B29,B30

B28) Present Value of Annuity Due (Excel Function)

B29) VBA Formula ( please provide the VBA Code)

B30) Math Formula

All 3 answers should be the same

B A 24 Q4) Stacy's Retirement Savings 25 Payment 26 Years (N) 27 Rate 28 PV of Annuity Due (Excel Function) 29 Your VBA formula 30 Math Formula (Extra Credit, 2 points) $4,000.00 30.0 8.00%