The future value of an annuity payment can be calculated in Excel using the function FV$.$ Suppose that you want to calculate the possible future values of an annuity that will have $30$ payment periods, but in addition you want to perform what$-$if analysis for the payment amount and interest rate. Use Excel to create a Two$-$Way Data Table to see the effects of varying interest rates from $5\mathrm{.}0\%$ to $11\mathrm{.}5\%$ in increments of $0\mathrm{.}5\%($i$.$e$.,5\mathrm{.}0,5\mathrm{.}5\%,6\mathrm{.}0\%,6\mathrm{.}5\%,$ etc.$)$ as well as payment amounts between $$3500$ and $$8500$ in increments of $$500($i$.$e$.,$ $$3500,$ $$4000,$ $$4500,$ etc.$).$ What is the future value of an annuity with payment of $$7500$ and interest rate of $9\mathrm{.}5\%?$

in excel