Excel Finance Help

Stacy is planning her retirement, and she concluded that she needs $1,250,000 in 30 years to retire. She can invest in a retirement account that guarantees a 5% annual return. How much should Stacy save at the end of each year to reach your retirement goal?

I need answer for B5, B6, B7

B5) Yearly Payment (Excel Function)

B6) VBA Formula ( please provide the VBA Code)

B7) Math Formula

All 3 answers should be the same

B. C A 1 Stacy's Annual Payment 2 Future Value (F) 3 Years (N) 4 Rate (R) 5 Yearly Payment (Excel Function) 6 Your VBA formula 7 Math Formula (Extra Credit, 2 points) $1,250,000.00 30.0 5.00%