Show me the steps to solve using excel formulas: $($A$)$ If you want to have $$300$ in $3$ years and you can earn an annual return of $6\%,$ how much must you invest today? Be sure to use cell references and make sure that your answer appears as a positive value.

$($B$)$ If you make a one$-$time deposit today of $$500$ and you can earn $8\%$ per year, how much would you have in your account after $10$ years? Be sure to use cell references and remember that deposits from you are outflows.

$($C$)$ If your investment of $$1,000$ declined to $$400$ in $8$ years, what would have been your compounded annual rate of return? Be sure to use cell references and to convert your answer to a percent rounded to two places after the decimal point.

$($D$)$ If you can earn $7\%$ per year, precisely how many years would it take for your investment of $$500$ to turn into $$800?$ Be sure to use cell references and display your answer rounded to two places after the decimal point.

solve for

$($A$)($B$)($C$)($D$)$

PV

FV

r

n